The example in full
Rohan Mehta
Senior Financial Analyst
London, United Kingdom · rohan.mehta@example.com · +44 7700 900162
Summary
Senior financial analyst with 7 years in FP&A across retail and manufacturing. Owns the monthly close commentary, the rolling forecast and the budget cycle for a £240M business unit, and is usually the person finance and non-finance teams come to when the variance doesn't make sense.
Experience
Senior Financial Analyst, Harlow & Vance Group
01.2022 – Present
- Own the monthly close for a £240M business unit: journals, accruals and prepayments, variance analysis and the commentary the board reads.
- Rebuilt the rolling 12-month forecast model in Excel and Power BI, cutting the forecast cycle from nine working days to four.
- Identified £1.8M of margin leakage in freight recharges by reconciling ERP shipment data against invoiced cost, now a standing monthly control.
- Partnered with supply chain and commercial finance on the annual budget for 14 cost centres, landing the submission two weeks ahead of the group deadline.
- Led the audit walkthrough for revenue recognition with the external auditors, closing the cycle with no adjustments.
- Built the pricing sensitivity model used in the annual customer negotiations, quantifying the margin impact of each tier before it was offered.
- Mentor two analysts on modelling and close discipline, and run the monthly finance business-partnering session with the commercial team.
Financial Analyst, Brightline Manufacturing
04.2019 – 12.2021
- Prepared month-end reporting packs for three plants, including balance sheet reconciliations and headcount cost analysis.
- Built the capex tracking model used to approve £30M of spend, replacing four disconnected spreadsheets.
- Automated the weekly cash flow report with Power Query, removing a full day of manual work each week.
- Supported the ERP migration from Sage to SAP as finance lead for the plant workstream, reconciling opening balances to the penny.
Finance Graduate Trainee, Brightline Manufacturing
09.2018 – 03.2019
- Rotated through accounts payable, management accounts and treasury while completing the first CIMA papers.
Education
- BSc Accounting & Finance, 2:1, University of Warwick — 09.2015 – 06.2018
Skills
FP&A · Financial modelling · Forecasting & budgeting · Month-end close · Variance analysis · Advanced Excel & Power Query · Power BI · SAP · Reconciliation & controls · Audit support · Stakeholder partnering · Cost centre budgeting · ERP migration (Sage to SAP) · Board reporting
Certifications
- CIMA (Chartered Global Management Accountant) — 11.2021
