Summary
Overview
Work History
Education
Skills
Websites
Certificates And Awards
Certification
Languages
Accomplishments
Timeline
Generic
Bagmi Mohapatra

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, India
01.2021

B-Tech - Computer Science Technology

BPUT
Odisha, India
01.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

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
Bagmi Mohapatra