Arpit Mehrotra
Pune
Summary
Business intelligence and data analytics professional specializing in risk management and operational controls. Expertise in visualizing and interpreting complex data patterns to facilitate informed decision-making. Proven track record of implementing analytical solutions that improve operational efficiency and drive positive business outcomes.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Vice President, Operational Risk at
Citibank
Pune, India
12.2024 - Current
- Supported the execution of managers' control assessment (MCA) testing to ensure controls are operating effectively across business units.
- Contributed to the creation and development of risk and control-related presentation materials for senior leadership.
- Automated the MCA programme to assess enterprise processing risk using Tableau and Python. The project's goal is to identify high-risk businesses and processes by reviewing their control environment.
- Automated incident reports that highlight the near-miss events and actual gain/loss events to pinpoint root causes, preventing future occurrences through targeted corrective actions.
- Built Python-driven automated reporting that supports the Preventative Payment Controls programme, which introduced Dual Blind Re-key (DBR) control to limit Manual Touchpoints (MTP), and reduce payment errors.
- Conduct biweekly evaluations of control effectiveness across business units, with a strong emphasis on expediting the remediation of identified control gaps. This programme aims to enhance control effectiveness at both the business and enterprise levels, targeting an overall enterprise-wide effectiveness score of 85% or higher.
- Analyse large and complex datasets to identify trends that support decision-making.
- Use Co-Pilot to review controls and publications to identify those mitigating processing risks.
- Overseeing associates and AVPs to accomplish the team's overall goal.
- Monitored operations to keep processes aligned with targets and matching forecasts.
Assistant Vice-President, Credit Risk at
JPMorgan Chase
Bangalore
03.2017 - 11.2024
- Analysed credit risk data to identify patterns, trends, and potential areas of concern for informed decision-making.
- Developed reporting solutions to ensure risk data was accurate, complete, and delivered promptly, enabling decision-makers to access current information, and gain real-time business insights.
- Analysed and compiled performance metrics to assess risk exposures, provisioning levels, delinquency, net charge-offs, CECL, etc., across various business units.
- Created a series of regulatory and executive reports to evaluate the health of Chase CCB, and the consumer portfolio.
- Contributed to a 70% automation milestone by transitioning reports from VBA, Excel, and SAS to Tableau and Alteryx, resulting in a 60% efficiency gain, real-time insights, and reduced manual effort.
- Identified opportunities for process enhancements by implementing customized automation solutions tailored to business needs, ensuring seamless data flow, improving accuracy, and reducing manual entry.
- Managed end-to-end design, development, and testing of automation solutions, using Jira for project planning, tracking, and delivery.
- Led a team of associates and analysts, overseeing year-end objectives, work distribution, training, career development discussions, performance evaluations, and providing feedback and support.
Business Analyst, US Equity Research at
Credit Suisse
Mumbai
01.2016 - 03.2017
- Managed business processes, strategic planning, and MI development for the AMER and EMEA COO head.
- Prepared monthly MIS reports and scorecards to support resource planning and performance reviews.
- Assisted senior IB management in preparing presentations for executive meetings.
- Reduced report preparation time by 40% using automated solutions.
Assistant Vice-President, EMEA Equity Research at
Moody’s Knowledge Analytics Services
Mumbai
04.2013 - 01.2016
- Created a monthly scorecard to support resource planning and performance reviews for the Barclays equity research management team.
- Streamlined existing processes through automation, leading to a 30% increase in team productivity.
Education
Master of Business Administration - International Business & Finance
Amity Business School
Noida, UP2011
Bachelor of Engineering - Electrical Engineering
Jaipur Engineering College & Research Centre, Rajasthan University
Jaipur, RJ2008
Skills
- Alteryx
- Microsoft CoPilot
- Power Query
- Python Programming
- SQL
- Tableau
- MS Excel & VBA Programming
- Xceptor
Certification
- Alteryx Designer Core Certified
Projects
- Automated monthly payment reports across multiple applications to assess if controls are effective, such as threshold controls, by verifying that the appropriate C-level employee approves a transaction that exceeds set thresholds. The project goal is to identify and mitigate processing risks.
- Automated monthly reports that highlight any failed manual payment transactions during the dual blind re-key process through python programming. The goal is to identify payment errors & control gaps, which has resulted in an 60% time saving.
- Created Tableau dashboard that provides real-time business insights to senior stakeholders on key credit performance metrics like delinquency, charge-offs, total exposure, non-accrual loans, provisions etc. across different business and products.
Timeline
Vice President, Operational Risk at
Citibank
12.2024 - Current
Assistant Vice-President, Credit Risk at
JPMorgan Chase
03.2017 - 11.2024
Business Analyst, US Equity Research at
Credit Suisse
01.2016 - 03.2017
Assistant Vice-President, EMEA Equity Research at
Moody’s Knowledge Analytics Services
04.2013 - 01.2016
Master of Business Administration - International Business & Finance
Amity Business School
Bachelor of Engineering - Electrical Engineering
Jaipur Engineering College & Research Centre, Rajasthan University