Vikas Gupta

As a finance professional, I have been working around financial statements and helping my organizations to tap opportunities to improve their mix in the top line with better gross margin while optimizing the expenses. I had opportunities to work as a part of a team, leading it, contributing as an individual, along with working with cross-functional teams. Over time I have gained skills and experiences of working with top executives and implementing their ideas on the ground which make my candidature strong and niche. In my current role, I am working as a business analyst which not only focuses on the financial aspect but the operational/ enablers as well for the business unit. Feeding important data points (sales related and its impact on financials) and highlighting areas of improvement/ concern to the business unit head to support in making sound business decisions.

Feb’22 – Present (1.1 yr) Senior Department Manager at Usha International, Gurugram Role: Analysis to improve financial & Operational performance of Appliance Business - Summarization, Analysis and Evaluation of financial/ operational data - Creation of reports for key stakeholders - Benchmarking at regional/ national level on Financial & Operational KPIs - Identify trends, risk, opportunities across various product categories - Review regional results and share insights at national level with BU head - Track and highlight Market share, Gross Margin, Expense movement across categories - Highlight variance along with reasons of budget vs actual P&L - Engage with stakeholders to seek inputs for overall health check of BU performance - Review the reported data and sharing the analysis with the BU Head - Standardizing tracking mechanisms to enable smooth reviews on agreed actionable - Support on Annual Operating Plan preparation Aug’15 – Jan’22 (6.5 yrs~) Deputy Manager at Honda Cars India Ltd., Greater Noida Role: Financial Analysis to support business decisions, profit improvement and assess financial risk - Identify opportunities to maximize revenues, optimize expenses to improve Net Profit - Ensure financial close process, perform variance analysis with comments - Develop budget & forecast for scheduled cycles through concrete inputs - Analyse Leverage, Liquidity & Profitability ratios basis Financial Statements - Benchmark KPIs/ ratios and execute root cause analysis for underachievement - Extensively work on financial models to simulate/ project P&L (3to5Yrs) - Prepare/ present financial health reports/ dashboards to mgmt. for decision-making - Risk evaluation to get early signs of sick business units, which may go out of business - Due diligence to validate Business plan/ sources of funds/ organization structure etc. - Forecast Honda network profitability w.r.t. Internal or economy or government policies - Prioritize/ assign activities and review the deliverables of 7 members team - Various monthly reporting (presentations) to Honda management - Detail scheduling & implementation of initiatives (Tool development, Trainings etc.) Apr’14 – Aug’15 (1.4 yrs) Senior Manager at MSX International (Project: Ford Motors), Gurugram Role: Business analysis to monitor & improve financial performance - Analysis of monthly variations in financial performance and its impact on profitability - Plan vs actual monitoring and reporting of variance analysis with commentary - Ratio Analysis using financial statements for Ford Dealerships across India - Financial consulting based on risk level to dealerships across India - Preparation of various financial reports & analysis for stakeholders Finance Professional Personal Info. Date of Birth 1st Nov 1988 Address: Gurugram, Haryana / Key Skills & Expertise  Financial Analysis  Business Profit Analysis  Business Planning and Analysis  Network Performance & Profitability  Forecasting & Simulations  Ratio Analysis & Benchmarking  Budget & Variance Analysis  Financial Consulting & Management Reporting  Financial Risk Assessment  Trainings & Mentoring  Tool Development Vikas Gupta - Projections, Break-even, ‘What If’ analysis & simulations for stakeholders - Coordinate & Reporting to Asia Pacific teams (onshore) - Prioritizing & Quality review of work assigned to team size of 5 people Jun’11 – Apr’14 (2.10 yrs) Senior Analyst at Deloitte USI, Gurugram Role: Financial Statements Analysis & Research - Research on critical business transactions: merger, dissolution & its financial impact -Compare & analyse old financial statements to report major changes to onshore teams - Find discrepancies between audited & Un-audited financials to get final GAAP numbers - Work extensively on Excel based financial models to get correct P & L & Balance Sheet - Analyse historical trends, forecast revenue, expense streams & future cash flows - Involved in strategic planning & preparation of revenue budgets for engagements - Working on multiple projects across US, UK & Canada & meet deadlines for deliverables - Trainings and on-board activities for new hires, active participation in firms’ C.S.R. Apr’10 – Jun’11 (1.2 Yrs) Associate at Bank of America: Merrill Lynch, Gurugram Role: Accounts Payables (Investment Banking) - Processing Foreign Exchange Derivatives Trades (Spot, Forward, Swaps, Options, NDF) - Brokerage validation & confirmation on trades across Global Financial Institutions - Processing broker payment for trades through various medium in their local currencies - Preparation of the Journal Voucher and Reconciliation on daily basis - Settlement & Validation of discrepancies due to rate differences in FX Market - Direct Process (GFX) reporting (Including month end) to LOB, Middle Office BOA - Monthly Forecast of revenue and preparation of various reports for LOB - Maintain business relations with BOA brokers across the globe

Qualification University/College/School Batch Score P.G.D.M. Finance New Delhi Institute Of Management 08 – 10 74.6% B.Com Ram Lal Anand College, University of Delhi 05 – 08 60.4% 12th Holy Child Public (C.B.S.E) 04 – 05 70.4% 10th D.A.V Public (C.B.S.E) 02 – 03 65.3%