SARTHAK MAHAJAN

• Ab-initio on-prem to AWS cloud migration for JP Morgan Chase.
• Managed and implemented cloud migration project for Legacy code of Consumer Banking LOB of JPMC. (HWX exit)
• Estimated resourcing , budgeting based on inventory analysis and reviewing Task Order for same.
• Streamlined project process across all LOB's by conducting thorough post-project evaluations and incorporating lessons learned into future efforts.
• Managed and guided 15 resources for Consumer LOB.
• Thorough inventory analysis of all psets involved and Control M Legacy job schedule.
• Building image for On prem Ab-initio graphs for Cloud AWS compatibility via Express>IT .
• Development of on prem code to make it AWS compatible including image creation , POD creation via Kubernetes and testing same in Dev and migrating it to UAT and PRPL
• Separate Control M job creation for AWS enabled psets on similar lines of Legacy jobs.
• Complete Source data availability check to ensure PRPL are with full volume data .
• Driving NFR review calls for SNOW implementation with Change management team.
• Creating GLUE datasets & tables, generating Parquet DML's , preparing GUID config file for writing to entities in Refined zone.
• Validation carried out via MTRS (in-house tool) and using Teradata SQL Assistance for data check.
• Created psets for copying from On prem to S3 and S3 to EFS.
• Carried out Teradata Provisioning for TD loads/unloads/Post-loads.
• Used SQL Workbench to compare HWX data with AWS data (used ATHENA) for same.
• CICD pipeline via Jules (built on Jenkins).
• Working with BitBucket & JFrog Repository
• Performance tuning of graphs to ensure proper container allocation during job runs.
• Provided L3 support for 2 weeks post cutover - carrying out RCA and implementing fixes as and where required.

Recognition's :

1) Stellar Achiever Cognizant award ( 2023)

2) Stellar Achiever cognizant Award ( H1- 2024)

• Client Interaction and building data pipelines with Abinitio after requirement gathering from business and translating into technical implementation
• Application of SDLC principles whilst including planning, designing, impact assessment, development, testing, deployment,maintenance and ELS support
• Contributed to internal activities for overall process improvements, efficiencies and innovation including Performance tuning & Optimization.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Reverse Engineering for Troubleshooting, analyzing and resolving data quality issues reported by stakeholders.
• Mentoring & guiding team members for ensuring cross functional technical as well as business knowledge
• Supporting Operations team in Troubleshooting technical challenges & problems.
• Led and managed team of 15+ members at Offshore
• Experience in estimating resourcing effort for new CR's.
• End to End exposure of development along with testing and impact analysis
• Exposure of migration from On-Prem to GCP

April 2021-September2021

Ab initio To Informatica Migration

• Responsible for migrating Applications from Ab initio which incorporates strategizing plan to move entire Data Integration Platform to Informatica.
• Backtracking graphs in Ab initio and consolidating true Source, Target and underlying Transformation, so as to develop Mappings via Informatica as a part of migration
• Communicating with Client and understanding their needs so as to incorporate changes effectively and efficiently.
• Domain Knowledge of Banking Industry and exposure of 6+ years

January 2020- March 2021

Ab initio Level 3 Support

• Responsible for L3 support for Consumer Banking Applications for Client. Task area included handling of job failures, Root Cause Analysis to rectify issue and providing long-term or short-term resolution.
• Analyzed failures, providing work around as well as carrying out RCA for complex ETL jobs.
• Applied Analytical skills in resolving data issue. Monitoring jobs, resolving incidents, Batch failures in Prod Environment
• Led team of 5 during tenure in this project, overseeing co-ordination and work progress in entire Track and driving client calls as POC for updates and weekly reporting.
• Troubleshooting complex Incidents via Abinitio GDE and responsible for metrics, and isolating any potential bottlenecks
• Increased network uptime through proactive monitoring of key metrics and swift resolution of potential issues

November 2016- December 2019

Ab initio Application Developer

• Responsible for Designing ,developing, testing and implementing Ab initio graphs.
• Migrating change in different environments(Dev/QA/Prod) and automating repeated processes by shell scripting.
• Client interaction on daily basis to get insights of business requirement and applying analytical skills to minimize graph complexity.
• Performance tuning of graph so as to ensure better cluster utilization.
• Working with HDFS and Hive tables and parallel processing in abinitio
• Enhanced understanding of SQL and Unix

July 2016 -October 2016

Abinitio Data-Lake Sourcing Project

• Performed Meta Data Listing of numerous banking applications which consumes data from various Sources and captured details for migrating data from DIME to LAKE.
• Working with Source Team to get in-depth knowledge of application and data usage in downstream applications.
• Working as Abinitio Developer for building/enhancing new/existing feeds for Retail, Consumer, Marketing LOB.
• Performed E2E development, testing and impact assessment for downstream applications following AGILE methodology

February 2015 -June 2015

Training

• 4 months training which included ETL Tool-Informatica, Reporting Tool- Cognos, Language -SQL,Shell Script
• Enhancing Business Communication skills.
• Learning business ethics
• Understanding of Agile methodologies and waterfall model in business