A result driven finance professional with a PGDM in Finance and seven (7) years of experience in financial management with multinational organizations. Internship experience with SBI mutual fund. Experience in financial modeling, planning, budgeting, financial control, competitive bidding for government tenders, banking relationships, ERP, SQL, Power BI, reconciliation, credit risk assessment and fundamental analysis of companies.
Overview
11
11
years of professional experience
Work History
Senior Financial Analyst
Warner Bros. Discovery (WBD)
09.2023 - Current
Forecasting & Reporting for distribution revenue of $305 Million USD for Central & Eastern Europe (CEE) for HBO Max Over The Top (OTT).
Made the budget for FY25 for CEE HBO Max OTT.
Variance analysis for month close for Forecast vs Actuals.
Monthly revenue accruals for unrecognized revenue.
Reconciliation of billing vs payment received at month end.
Provide analytical dashboard of businesses via Tableau and excel to walkthrough performance metrics.
Involve in building of presentation decks so as to highlight key
movements in each LOB(s) to senior management.
Act as a business partner for the finance functions across CEE with regards to financial P&L overview and consolidation.
Management reporting for CEE HBO Max and highlighting any risks and opportunities.
Key Project and Achievements:
Developed dashboards in Tableau & Excel, enabling real-time data visualization that improved stakeholder engagement, reporting clarity & reduced reporting time by 0.3 FTE.
Senior Financial Analyst
Advance Auto Parts India (AAP)
09.2021 - 09.2023
Handling 5 Finance Categories with sales volume of $3.8 Billion USD
Transitioned merchandise financial planning role from US
Mentoring TM's to be their best with knowledge gained on transition phase
Handling Ad-Hoc analysis for Finance executive on a regular basics
Skilled in process reverse engineering
Created multiple tailor made Power BI dashboard for finance team and merchants to have better grasp on product performance
Worked closely with Finance executive's to track strategic decisions made on improving Gross margin
Reported on POG (planogram) performance after reset
Partnered with Inventory & Pricing team extensively on forecast
Worked on Trade (vendor discount, billback's & fixtures) to allocate at product level
Tracked and analyzed Markdown SKU's and stock levels
Partnered with Finance Team & Merchants on AOP (Budget)
Created and optimized SQL query to work with large data sets
Weekly reports on Sales, GM & SKU performance
Part of COE (Center of Excellence) for Finance to optimize performance
Key Project and Achievements:
Transitioned merchandise financial planning process from US to India to forecast sales for worth ($10 billion) and set up a team from scratch.
Management Trainee
Genpact India Pvt. Ltd (Genpact)
10.2020 - 09.2021
Reporting of key financial metric to stakeholders
Variance Analysis of monthly collections to plan
Reconciliation of bank and customer account
Revenue recognition at cost center level
Key Project and Achievements:
Worked with a global auto original equipment manufacturer (OEM) for analyzing, managing and streamlining their order to cash process for Europe, Australia and USA
Improved efficiency by ensuring that the profit center is marked at the time of the posting entries to ensure the profitability analysis is performed correctly.
Senior Executive
SBI Funds Management Pvt. Ltd
05.2019 - 06.2019
Investment Research: Reported to the fund manager of SBI Credit Risk Fund
Worked in the debt investment department and critically analyzed the business and financials of various companies to ascertain their credit worthiness for debt investment
Created proposals for investment in infrastructure and chemical companies
Created credit updates sent to senior management regarding existing investments.
Senior Executive
WaterHealth India. Pvt. Ltd (WHIN)
06.2014 - 06.2017
Prepared the budget for 3 business units (Capital, Operations & IRCTC)
Forecast for 2 business units (IRCTC & Service Unit)
Prepared the monthly financial Management Dashboard
Cashflow management & projections
Banking relationships and conversion of inward remittances
Financial Modelling for bidding on government Tenders
Worked with the business unit heads and support function heads to make the budget file for company for FY 16 & FY 17
Key Projects and Achievements:
Indian Railway Catering and Tourism Corporation Tender: Developed a financial model from scratch to bid in the IRCTC Railway tenders for setting up Water Vending Machines (WVMs) at railway stations to provide purified safe drinking water
WHIN has participated and won 15 clusters for setting up of 515 WVMs
Delhi Jal Board, : Made financial models to determine feasibility and bid value to participate in various government and private tenders
Model was used to successfully to participate and win a tender from the Delhi Jal Board to set up 29 Water Health Centers (Mini RO Plants) in the city of Delhi.
Sport Presenter - Newshub Live at 6 at Newshub/Warner Bros Discovery/Warner Bros DiscoverySport Presenter - Newshub Live at 6 at Newshub/Warner Bros Discovery/Warner Bros Discovery
Senior Financial Analyst, Financial&Risk Analytics at Federal Housing Finance AgencySenior Financial Analyst, Financial&Risk Analytics at Federal Housing Finance Agency