Mukesh Jagannath Yadav
Mumbai
Summary
Automation Developer with over 14 years of experience in creating scalable automation and data processing solutions utilizing Alteryx, Python, VBA, and Excel. Demonstrated success in enhancing operational efficiency and automating reporting processes in dynamic financial settings. Expertise in converting business needs into actionable technical solutions.
Overview
15
15
years of professional experience
Work History
Associate Developer
JP Morgan Chase
11.2018 - Current
- Lead developer for automation solutions using Alteryx and Python to support financial operations.
- Designed scalable workflows for data validation, transformation, and reporting automation.
- Architected VBA-based utilities to integrate Excel reports with business logic.
- Worked closely with stakeholders to gather requirements, conduct UATs, and ensure successful deployments.
- Provided post-deployment support and maintained documentation for continuity.
Emerging Lead – VBA Developer
State Street Corporation India Pvt. Ltd.
11.2015 - 11.2018
- Led VBA automation initiatives to standardize and automate complex Excel-based reporting processes.
- Designed Access database solutions for centralized report generation and tracking.
- Developed performance dashboards and audit tools that enhanced transparency.
- Mentored junior team members in VBA coding standards and debugging techniques.
Executive – MIS Automation
CAPITA India Pvt. Ltd.
07.2014 - 11.2015
- Managed end-to-end automation of recurring MIS reports using Excel macros and Access queries.
- Streamlined the report delivery pipeline to reduce manual effort and ensure timely outputs.
- Interacted with internal departments to gather feedback and continuously improve reporting tools.
Associate – MIS Executive
Prudential Process Management India Pvt. Ltd.
10.2010 - 12.2013
- Supported daily and monthly reporting by building and maintaining Excel-based dashboards.
- Automated report consolidation using VBA scripts to ensure accuracy and efficiency.
- Created internal tools for monitoring team performance and productivity.
Education
PGDM - IT
Welingkar Institute
Mumbai04.2022
B.Com - Commerce
University of Mumbai
Mumbai04.2010
Skills
- Python programming
- VBA development
- HTML and XML
- Alteryx analytics
- Tableau visualization
- MS Access management
- SQL Server expertise
- Excel proficiency
Languages
- English
- Hindi
- Marathi
Personal Information
Date of Birth: 01/23/90
Projects
- Reconciliation Tool (Python): Automated matching and verification of financial transaction records across multiple sources, ensuring data integrity and reducing manual effort by 95%.
- Outlook Automation (VBA & Python): Developed solutions for auto-sorting emails, bulk messaging, calendar scheduling, and attachment handling to streamline communication workflows.
- PDF Data Extraction Pipeline (Python): Built a pipeline using Python libraries to parse invoices and compliance reports, converting unstructured PDF data into structured Excel and database-ready formats.
- Alteryx Workflows: Designed reusable workflows for data reconciliation, validation, and real-time reporting, improving month-end close turnaround time.
- VBA Utilities (Outlook & Access): Implemented VBA scripts to automatically extract attachments from Outlook, process PDF forms, and import data into Access for streamlined reporting.
Timeline
Associate Developer
JP Morgan Chase
11.2018 - Current
Emerging Lead – VBA Developer
State Street Corporation India Pvt. Ltd.
11.2015 - 11.2018
Executive – MIS Automation
CAPITA India Pvt. Ltd.
07.2014 - 11.2015
Associate – MIS Executive
Prudential Process Management India Pvt. Ltd.
10.2010 - 12.2013
PGDM - IT
Welingkar Institute
B.Com - Commerce
University of Mumbai
Similar Profiles
Lisa Olivia GrenviczLisa Olivia Grenvicz
Private Client Banker at JP Morgan Chase & Company (Chase Bank)Private Client Banker at JP Morgan Chase & Company (Chase Bank)
Taylor SimsTaylor Sims
Client Services Specialist & Associate Banker at JP Morgan Chase & Chase BankClient Services Specialist & Associate Banker at JP Morgan Chase & Chase Bank
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase
Mahesh TelgadiMahesh Telgadi
Team Leader at JP Morgan Chase pvt LtdTeam Leader at JP Morgan Chase pvt Ltd
RANJEET KUMARRANJEET KUMAR
General Manager – Strategy & Growth at McDONALD’S INDIA (HRPL)General Manager – Strategy & Growth at McDONALD’S INDIA (HRPL)