Ahmedabad, Gujarat · rohan.shah@email.com · +91 98765 43210 · linkedin.com/in/rohan-shah-finance
MBA (Finance) graduate (2025) aiming for a Financial Analyst role, skilled in financial modelling, variance analysis and Excel. Built the monthly variance report a mid-size manufacturer’s CFO now uses.
MBA, Finance, Nirma University, Ahmedabad2023 – 2025 · CGPA 3.3 / 4
B.Com, Gujarat University2020 – 2023 · 79%
Finance: financial modelling, DCF valuation, ratio analysis, variance analysis, budgeting
Tools: Excel (INDEX-MATCH, pivot tables), Power BI, Tally Prime
FP&A Intern, Sahyadri Auto Components, PuneApr 2024 – Jun 2024
• Built a monthly variance analysis of budget against actuals for 6 cost centres in Excel with INDEX-MATCH and pivot tables.
• The CFO now uses the report every month; it found ₹14 lakh of freight costs booked to the wrong plant.
• Helped with budgeting for the next year: collected inputs from 6 department heads into one template.
Valuation of a listed FMCG company | Excel | SoloJan 2025
• Built a five-year financial modelling workbook and a DCF valuation from the company’s annual reports.
• Ran ratio analysis against two peers; presented the valuation range and its key assumptions to a faculty panel.
Mess expense dashboard | Power BI, Tally Prime | Team of 2Sep 2024
• Moved the hostel mess accounts from Tally Prime into a Power BI dashboard; the mess committee cut food waste costs by 9% in a term.
• CFA Level I, passed, 2024