Open to Finance, FP&A & Financial Analyst Roles

Om Sandip
Adhav

MBA Finance candidate specialising in FP&A, financial modelling, and data visualisation. Built production dashboards at Tata Motors. Open to Finance, FP&A, Analyst, and Accounting roles across Big 4, BFSI, and corporate finance.

View Projects ⬇ Download Resume Get in Touch

8.62

MBA CGPA

45%

Reporting time saved

80+

Page analyst report

Highlights

8.62 CGPA MBA Finance · Indira School of Business Studies

45% faster daily production reporting at Tata Motors

80%+ reduction in reporting errors

100% GST compliance — zero penalties across 12 months

80+ page analyst report rated "Very Good" by DGM · Tata Motors

4 plants cost-efficiency analysis presented to Deputy General Manager

8.25 CGPA B.Com Banking & Finance · Dr. D.Y. Patil College

8.62 CGPA MBA Finance · Indira School of Business Studies

45% faster daily production reporting at Tata Motors

80%+ reduction in reporting errors

100% GST compliance — zero penalties across 12 months

80+ page analyst report rated "Very Good" by DGM · Tata Motors

4 plants cost-efficiency analysis presented to Deputy General Manager

8.25 CGPA B.Com Banking & Finance · Dr. D.Y. Patil College

About Me

Finance meets
data fluency

I'm an MBA Finance candidate at Indira School of Business Studies (CGPA: 8.62) with hands-on FP&A experience at Tata Motors Passenger Vehicles, where I built automated production dashboards, surfaced cost-efficiency insights across 4 manufacturing plants, and presented findings directly to the Deputy General Manager.

Before my MBA, I spent 12 months doing full-cycle accounting and compliance work at a CA firm — achieving 100% GST compliance with zero penalties across all client portfolios.

I combine financial rigour with data tools to turn raw numbers into decisions. Open to Finance, FP&A, Financial Analyst, Management Accounting, and Audit roles across Big 4, BFSI, NBFCs, and corporate finance.

Power BI

SAP

Advanced Excel

Financial Modelling

FP&A

Variance Analysis

Tally Prime

GST Compliance

₹ Tata Motors
Finance Intern — Purchase Finance Division, FY2025

45% faster
Daily production report preparation time reduced

4 plants
Cost-efficiency analysis across all Pune manufacturing plants

100%
GST compliance — zero penalties across 12 months

Experience

Where I've worked

Hands-on finance roles across corporate FP&A and professional accounting.

Tata Motors Passenger Vehicles Ltd.

Internship

Finance Intern — Purchase Finance Division

May 2025 – July 2025 · Pune, India

Identified a recurring production variance pattern — first-half-of-month output running ~15–20% higher than second-half — by extracting and cleaning daily SAP data across 4 plants and 5+ vehicle models (ICE & EV).
Reduced daily production report preparation time by ~45% and cut reporting errors by over 80% by building automated Excel templates using Power Query, pivot tables, and VLOOKUP.
Delivered a cost-efficiency analysis to the Deputy General Manager comparing 2 months of daily production cost data against output metrics across all 4 Pune plants.

Nilesh Nahata & Co.

Full-time

Accounts & Compliance Associate (Trainee)

August 2023 – July 2024 · Pune, India

Managed end-to-end accounting for 3–5 client companies in Tally Prime, maintaining ledgers and reconciling 2+ bank accounts daily with consistent accuracy.
Achieved 100% GST compliance with zero penalties across all client filings over 12 months — year-end submissions completed 10 days ahead of deadline.
Strengthened financial reporting controls across 4 audit engagements by identifying discrepancies in ledger entries and recommending process improvements.

Projects

Featured work

Financial analysis and data visualisation projects built with real-world data.

Financial Analysis

Tata Motors vs M&M — 5-Year Financial Performance Analysis

Comprehensive ratio analysis across 8 financial dimensions using audited annual reports, BSE/NSE filings, and CMIE Prowess data for FY2021–FY2025. Delivered as an 80+ page analyst report rated "Very Good" by DGM Purchase Finance.

Excel Power BI Ratio Modelling Trend Analysis

80-observation ratio model across 8 financial dimensions

Tata net profit margin: -8.31% (FY21) → +4.29% (FY25)

M&M D/E: 0.02x vs Tata 0.95x — leverage comparison

Interactive Power BI dashboard with 4 visuals & 2 slicers

⬇ Download Full Report (PDF)

Power BI · Data Visualisation

Tata Motors vs M&M — Interactive Power BI Dashboard

Built an interactive Power BI dashboard on top of the 80-observation ratio model — visualising Tata Motors' full financial turnaround across FY2021–FY2025 with dynamic slicers, DAX measures, and 4 custom visuals.

Power BI DAX Excel Data Modelling Financial Visualisation

5-year trend line chart — Tata vs M&M across 5 ratio categories

FY2025 head-to-head clustered bar chart across 13 metrics

Turnaround story visual with red zero reference line

4 KPI cards + 2 interactive slicers (Category & FY)

⬇ Download Dashboard (.pbix)

Interactive Power BI Dashboard — Tata Motors vs M&M Financial Ratio Analysis

FP&A · Financial Modelling

HDFC Bank — FP&A Financial Forecasting Model

Built a 3-sheet Excel FP&A model forecasting HDFC Bank's P&L across FY2025E–FY2027E using historical data from audited annual reports (FY2020–FY2024). Includes a full budget vs. actual variance analysis for FY2024 and a pessimistic / base / optimistic scenario comparison — with analyst commentary on every key line item.

Excel Financial Modelling FP&A Scenario Analysis Variance Analysis

NII 4-yr CAGR of 19% — ₹1.23L Cr to ₹2.47L Cr (FY2020–FY2024)

Base case PAT forecast: ₹1.82L Cr by FY2027E (~15% CAGR)

Pessimistic vs optimistic PAT gap widens to ~₹64,000 Cr by FY27

FY2024 budget vs actual: Total Revenue beat by ₹12,129 Cr (+4.3%)

CIR improvement from 40.2% → 37.5% — key profit driver in model

⬇ Download Model (.xlsx)

Om SandipAdhav

Om Sandip
Adhav