Bagmi Mohapatra
Mumbai
Summary
Dynamic data leader with a proven track record at JPMorgan India, excelling in ETL process design and performance tuning. Spearheaded a migration to AWS Glue, achieving a 50% improvement in user experience. Adept at stakeholder management and continuous improvement, driving team efficiency and delivering innovative data solutions.
Overview
18
18
years of professional experience
1
1
Certification
Work History
AVP, ETL and Data Lead
JPMorgan India
Mumbai
09.2015 - Current
- Achieved a remarkable reduction in application response time from 1 hour and 30 minutes to under 10 minutes by successfully migrating the legacy platform from Informatica PowerCenter to AWS Glue jobs, Terraform, and Python scripts. Data is directly pulled from the S3 bucket and loaded into the SEP.
- Successfully designed the Salesforce Chatter XML file generation using Pentaho and Shell scripting. Achieved significant performance and data quality gains by rewriting the entire module. 100% data quality is seen post-migration, with 0% production failure.
- Achieved a significant performance gain, from 30 minutes to less than 5 minutes, after migrating from Sybase to the GraphQL Radix platform. Data consumption was through GraphQL and Pentaho jobs. Control M was used as a scheduling tool.
- Contributed to ongoing migration projects. Migrated & decommissioned multiple legacy feed load operations to AWS Redshift servers, that improved performance/user experience by more than 50% and resulted in highly maintainable code.
- Handled multiple performance tuning challenges in the Data Warehouse and reduced the time consumption to a few seconds, which was taking many hours to complete.
- Contributed to the AFR Revenue Reconciliation project. Any difference in AFR was raised to concerned upstream. XIB is a consumer of more than 300 feeds across all the regions, like AP, EMEA, and North America. This entire process required thorough data analysis using Tableau statistics.
- Actively participated in the Regulatory Reporting Team. Designed and developed reports to satisfy the demands of regulators, and generate the reports from their locations.
- Negotiated with external stakeholders to gather requirements, plan, execute, and coordinate to get the required sign-off prior to release.
- Actively participated in L3 support activities and continuously responded to user queries on a need basis. Also provided 24/7 support for regular intraday, nightly cycle, and summary jobs.
- Enhanced the Software Development Life Cycle (SDLC) by integrating various tools, resulting in a 20% boost in productivity.
- Contributed to firmwide initiatives, including Code for Good, Force for Good, and Hackathons, while also conducting over 80 interviews for various open positions at the Line of Business (LOB) level.
Assistant Consultant
TCS India
Bangalore
10.2011 - 08.2015
- Holding and Trade data warehouse is an integrated module as part of which the Centralized Data Warehouse of Fidelity is populated with Trade and Reference data. The data is flown to WH using Golden gate Technology of Oracle and Distributed in different SCD1, SCD2 and FACT table structures.
- Building new data model to implement the new business logic related REPO. Prior Sybase was used to maintain and store data. As part of Sybase decommissions, the primary decision was taken to populate data in Oracle by implementing new data model.
- Encouraged and facilitated knowledge building within the team, resulting in a 25% increase in overall team productivity.
- Reviewed functional requirements and converted them into technical specifications, ensuring 100% alignment with project goals and reducing development errors by 20%.
- Delivered quick, results-driven, and methodical solutions for issues, reducing resolution time by 30% and increasing client satisfaction.
- Promoted the identification and implementation of innovative ideas, resulting in a 20% decrease in effort.
- Automated the deployment of build changes, reducing deployment time by 60%.
Software Engineer
Exilant
Mumbai
08.2010 - 09.2011
- The T&A Payroll management System is designed and developed by Exilant Technology Private Limited for the calculation of Payroll and maintaining the attendance details of the employees of Apple.
- Design and development of DB components and business logic of the application.
- Design and development of database entities. Pre-processed and indexed location details for all Indian cities in a search engine, enabling efficient access.
- Engineered a clustered environment to manage large datasets on SOLR, resulting in a 50% increase in data processing speed and a 40% improvement in system scalability.
- Administered system studies and coordinated with cross-functional teams for product documentation, system design, system integration, software coding, and application maintenance to ensure seamless project execution and product quality.
Junior Research Fellowship
DRDO
Chandipur
07.2007 - 07.2010
- Handled multiple Defense related and Payroll (finance) related projects such as, Instrument and Weapon Test and Evaluation System, Fuel and Lubricant Management System, Pension Management System.
- Design and development of application UI, Services and business logic of the application.
- Design and development of database entities. Interacting with client as part of functional requirements gathering.
Education
Post Graduate Diploma - Banking and Financial Management
NMIMS
Mumbai, India01.2021
B-Tech - Computer Science Technology
BPUT
Odisha, India01.2007
Skills
- Technical leadership
- Stakeholder management
- ETL process design
- Informatica PowerCenter
- Pentaho
- AWS Glue
- PLSQL
- Python
- Panda
- Redshift
- GraphQL
- JavaScript
- HTML
- Control M
- PySpark
- Jenkins
- Tableau
- Autosys
- MySQL
- Oracle DB
- AWS Cloud
- Unix and Shell scripting
- Regulatory reporting
- Performance tuning
- Data migration
- Data analytics
- Data warehousing
- Problem solving
- Technical specifications
- Process optimization
- Effective communication
- Stakeholder negotiation
- Team leadership
- Continuous improvement
- Project management
Websites
Certificates And Awards
- AWS cloud Practitioner certified.
- Participated in Intel Hacks 2017, got shortlisted in top 150 entries out of 889 participants.
Certification
- AWS Cloud Practitioner Certified
Languages
Hindi
First Language
English
Advanced (C1)
C1
Accomplishments
- Best resource of the year 2023 for single-handedly handling the complicated Sybase Exit module, successfully started sourcing from Radix through GraphQL, and pushed data to AWS cloud.
Timeline
AVP, ETL and Data Lead
JPMorgan India
09.2015 - Current
Assistant Consultant
TCS India
10.2011 - 08.2015
Software Engineer
Exilant
08.2010 - 09.2011
Junior Research Fellowship
DRDO
07.2007 - 07.2010
Post Graduate Diploma - Banking and Financial Management
NMIMS
B-Tech - Computer Science Technology
BPUT