Looking for a job

SIDDHARTH MEHROTRA

@siddharthmehrotra

Message

Financial services data analyst specializing in credit risk, portfolio analytics, and automation.

India

Message

What I'm looking for

I seek a data-focused role in financial services where I can apply credit risk and portfolio analytics, automate reporting, and drive data-informed strategic decisions while growing technical and leadership skills.

I am a financial services data analyst with hands-on experience in credit risk, portfolio analytics, and financial modeling. I leverage SQL, Python, and BigQuery to extract, transform, and automate data workflows that support credit risk review and assurance functions.

I build dashboards and visualizations using Tableau, Power BI, and Excel (VBA, pivot charts) to enable data-driven decision-making for stakeholders. I have implemented macro-based rolling regression models and automated Excel tools to compute performance metrics across multiple indexes.

My projects include credit risk modeling using XGBoost with GridSearchCV to significantly improve recall, and regression and Random Forest models for insurance premium prediction achieving strong R-squared performance. I also synthesize financial insights into presentations that inform strategic client discussions.

I take pride in process documentation, data validation, and adopting Gen AI tools to boost analytical efficiency and innovation, while mentoring and delivering instructional materials that scale learning outcomes.

Experience

Work history, roles, and key accomplishments

Current

Cross Asset Strategy Analyst

Current

JPMorgan Chase

Jan 2025 - Present (11 months)

Built a fully automated VBA Excel tool computing performance metrics for 30+ indexes and implemented rolling regression models to improve portfolio risk assessment; standardized 10+ weekly reports that informed senior management decisions.

VBA Excel Rolling Regression Portfolio Management Risk Assessment Report Automation Data Analysis Statistical Modeling

Equity Analyst Intern

JPMorgan Chase

Jul 2024 - Dec 2024 (5 months)

Collected and analyzed 5 years of revenue data for 35+ companies, forecasted 4-year revenues using company guidance and industry benchmarks, and prepared 3 marketing decks for global client presentations.

Financial Analysis Forecasting Excel Data Collection Revenue Forecasting Benchmarking SQL

Education

Degrees, certifications, and relevant coursework

Birla Institute of Technology and Science, Pilani

M.Sc. (Hons.) Economics; Bachelor of Engineering (Hons.) Mechanical Engineering, Economics; Mechanical Engineering

2020 - 2025

Grade: 8.32/10

Activities and societies: Academic projects in credit risk analytics, insurance premium prediction, cafe sales analysis; prepared financial analysis assignments and recruited students for courses.

Completed dual honours programs in Economics (M.Sc. Hons.) and Mechanical Engineering (B.E. Hons.) with a strong academic record and practical experience in data and financial analysis.