Prashant Mishra
Hyderabad
Summary
19 years of experience specializing in ETL architecture and team leadership. Successfully led significant data integration projects that improved platform efficiency and drove profitability. Demonstrates strong skills in strategic planning and critical thinking, with a proven track record of mentoring diverse teams to enhance productivity. Committed to leveraging expertise to optimize data solutions for continued organizational growth.
Overview
19
19
years of professional experience
1
1
Certification
Work History
VP
BANK OF AMERICA
Hyderabad
09.2019 - Current
- Project: Virtual Assistant for Support Teams.
- Role: Project Manager.
- Technologies: Rasa Pro, NLP, Python.
- Engineered tool empowering Support team with first-line support capabilities via VA. Thus, enabling LOB to clock 20% of operational benefits.
- Project: Enterprise Data Platform.
- Role: Project Manager
- Enterprise Data Platform Services is a shared platform for internal tenants in the bank to utilize the Informatica tool for data integration projects.
- The EDP Informatica portfolio is worth 7 million dollars.
- 26 administrators are working in this team in the US and India to provide 24/7 platform support.
- Establish a Kanban board for the team.
- Work on costing finalization and licensing for Informatica.
- Establish a chargeback model in the bank.
- Performance evaluation, goal setting, and individual development programs for team members.
Project Manager
BANK OF AMERICA
Hyderabad
08.2017 - 09.2019
- Experience in data warehousing, business intelligence, ETL, reporting, and data analytics, especially within customer data in the bank.
- Hands-on experience in development, QA, and management of projects.
- Established Scrum Teams from India
- Recruited new team members, trained, coached as mentor
- Built teams offshore-onsite from scratch for ETL COE development Team
- Responsible for delivery for 24-member team
- SOX compliance projects-Reconciliation of financial transactions between Legacy systems and Core applications
- Responsible for the overall delivery of project between India and USA
- Demonstrated experience of project management, Quality Management, managing onsite-offshore teams and coordinated test execution across locations
- Responsible for all activities related to the requirement gathering, development, implementation and support of ETL processes for large-scale data warehouses
- Design, build and implement controls and monitoring mechanisms to ensure accuracy and data integrity
- Responsible for design, development and implementation various tasks in building BI platform
- Manage ETL specifications and supporting documentation
- Worked on critical initiatives in like FDIC, Complying to SOX and CCAR
- Coordinate with Vendor team for task allocation and resource onboarding
- Automated and saved 32000$ through various automations
Senior Data Warehouse Project Manager
BANK OF AMERICA
Hyderabad
05.2011 - 07.2017
- Project : Party Reference Data Store (PRDS)
Technologies: Informatica 10.5, Unix, Ansible. - Role: Project Manager
- PRDS is an authorized data source for party data, responsible for owning customer data.
Spearheaded in establishing the team from India. - Carried out technological upgrades, streamlining processes and eliminating business inefficiencies.
- Hired, trained, and mentored staff members to maximize productivity.
- Created program to promote new managers from within, leading to cohesive leadership structure.
- Design and implement multi-dimensional models, including the construction of Data View, Dimensions while adhering to enforced development methodologies
⦁ Developed the ETL design of complex project using Web Services Consumer transformation and xml transformation
⦁ Taking care of resource bandwidth and task assignment
⦁ Develop and implement information management strategies and solutions
⦁ Develop and improve processes that monitor data feeds, with the goal of detecting, repairing, and preventing duplicates, inconsistencies, and other errors
⦁ Played the role of Informatica Administrator for 70 Servers
Senior Software Engineer
PATNI COMPUTERS
Hyderabad
04.2009 - 04.2011
- Project : ETL Management Motorola is Global company producing many products from mobile to Non-Mobile components
- As a Part of our L3 support team we support all Non –Mobile business in Data warehousing
- OBIEE and BO used as reporting tool
- Informatica is the tool used as loading data from ERP Source to Data warehouse called EDW.(Enterprise Data warehouse)
- Role : Team Lead
- Technologies: Informatica 8.x , Oracle
- Played the role of L3 Lead at Client location
- Weekly interaction with business users to understand the criticality of tickets of the ticket
- Setting up the prioritization of the tickets and assigning to the team members
- Weekly updates to client and trying to improve the productivity of the team
- Accepting the tickets and work upon them
- Discussion with Solution Architects to discuss the approach of various tickets
Senior Software Engineer
SATYAM COMPUTERS
Hyderabad
11.2005 - 03.2009
- Company Overview: State Farm Insurance Company is one of the largest financial institutions in the world as of today in insurance business; State farm has 27 regional offices and more than 1000 claim service centers
- Project : State Farm Insurance Company is one of the largest financial institutions in the world as of today in insurance business; State farm has 27 regional offices and more than 1000 claim service centers
- The main objective of this project is to develop and implement the conversion components that would convert the existing claims data into ECS (Enterprise Claim Systems) from HP9000 Platform
- Role : Team Lead
- Technologies: Informatica 8.x, Unix
- State Farm Insurance Company is one of the largest financial institutions in the world as of today in insurance business; State farm has 27 regional offices and more than 1000 claim service centers
- Understanding the changes required for each iteration
- Data assessment – with direction and support from STATE FARM INSURANCE
- Design of Conversion, Data extraction, transformation and load using INFORMATICA (8X), ISQL (HP-ALLBASE), UNIX
- Conversion development & unit testing
- Testing, validation and implementation of delivered conversion components – with STATE FARM INSURANCE’s active participation
- Provide support for System testing and Integration testing
- Running the delivered code involved 377 mappings of different functionality on Different server for a particular region
- To improve the performance of mappings
- Coordinate with Dev team to resolve the issues
- Loading Exception Tables and providing the data to different Stakeholders
- Motivating the team in terms of learning and helping the team members in achieving their target
Education
MCA -
BPUT Bhubaneswar
07.2005
B Sc -
PANJAB University
06.2002
Intermediate -
K.V. Air Force Jodhpur
Jodhpur, Rajasthan06.1998
Skills
- Team leadership
- Data analysis
- Strategic planning
- Critical thinking
- ETL
- SQL/PLSQL
Certification
- AZ 900 Microsoft Certified on Azure Fundamentals
- Rasa Pro Developer
- ITIL 4 Foundation
- Certified Scrum Master
- Oracle certified professional
- Trained on Hadoop and Big Data
Activities
- Won the white paper contest within organization on topic Archer Outbound as a service
- Worked at Onsite directly with customer and successfully executed the project.
- Rated as STAR Performer in the project in Satyam Computer services Ltd.
- Part of BI Pre sales team in Satyam Computers
- Submitted White Paper on 'Grid Computing for Informatica 8'
- Submitted White paper on 'Future of ETL'
- Submitted an Idea for Patent
Timeline
VP
BANK OF AMERICA
09.2019 - Current
Project Manager
BANK OF AMERICA
08.2017 - 09.2019
Senior Data Warehouse Project Manager
BANK OF AMERICA
05.2011 - 07.2017
Senior Software Engineer
PATNI COMPUTERS
04.2009 - 04.2011
Senior Software Engineer
SATYAM COMPUTERS
11.2005 - 03.2009
MCA -
BPUT Bhubaneswar
B Sc -
PANJAB University
Intermediate -
K.V. Air Force Jodhpur
Similar Profiles
Nicholas ShakanNicholas Shakan
Vice President, Portfolio Manager at Bank of America Private BankVice President, Portfolio Manager at Bank of America Private Bank
Kevin BetheaKevin Bethea
Digital Ambassador at Bank of AmericaDigital Ambassador at Bank of America
Anne MilneAnne Milne
Managing Director - Global Head EM Credit Research at Bank of AmericaManaging Director - Global Head EM Credit Research at Bank of America
Daniella Melo GilDaniella Melo Gil
Client SVCS Blended at Bank of AmericaClient SVCS Blended at Bank of America
Suresh BhumireddySuresh Bhumireddy
Technical Specialist at Bosch Global Software TechnologiesTechnical Specialist at Bosch Global Software Technologies