Hardik Sehgal

About Hardik Sehgal

I\'m a proactive Chartered Accountant with a passion for transforming complex financial data into actionable insights that drive strategic business decisions. After clearing my CA exams in my first attempt, I gained experience in tax litigation and audit, working with clients such as Apple and Unicorn. Currently, I am part of the Business Finance team at Tata Motors Ltd, India\'s largest OEM, where I undertake financial planning and analysis initiatives.

Experience

1. Senior Manager- Business Planning

   Tata Motors

   Jun 2023 — Present · Mumbai, IN

   Part of the Business Finance team at Tata Motors Commercial Vehicles, focusing on financial planning and analysis. My responsibilities include:•Preparation of Annual Budget, focusing on freight costs and refining Anaplan Financial Model.•Consolidating and analyzing product line and plant-specific forecasts to prepare periodic Outlooks, assessing and presenting the company\'s profitability to senior leadership.•Delivering Monthly Profitability reports, ensuring timely and accurate reporting of LOB-wise P&L for management review, and tracking Performance metrics.•Conducting variance analysis with forecasts and budget targets, highlighting significant deviations and providing insights into underlying reasons.•Monitoring Warranty and Pre-Delivery Inspection (PDI) expenses monthly, analyzing deviations from budgeted figures, and identifying key reasons behind discrepancies.Previously, I participated in the CFO-structured program, gaining cross-functional exposure across departments such as Group Controlling, Treasury, M&A, Internal Audit, Plant Finance, Business Finance, ERC Finance, and Sales Finance, including subsidiaries Tata Motors Business Services and Tata Motors Finance Limited.Key projects during this program include:•Assessing hedge accounting feasibility for Seagull Options and conducting Sum-of-the-Parts (SOTP) valuation for Tata Motors Limited (TML) within the Treasury department.•Delivering a benchmarking report comparing TML\'s Commercial Vehicle Business with Mahindra & Mahindra, identifying white spaces and key focus areas.•Undertaking an on-field project to prepare a Risk Assessment Control Matrix (RACM) for depot operations in the new GCC Business model of TML.•Conducting a risk assessment of VME expenditure, leading to the discovery of discount benefits not passed to the end customer.•Creating Power BI dashboards for the Warranty team to track claims at a batch-plant level, providing insights into assembly line-related warranty claims.

Education

• GOSWAMI GANESH DUTTA SANATAN DHARMA COLLEGE

  Bachelor of Commerce - B.Com (Hons)

  2018 — 2021

• Ryan International School, Chandigarh

  All India Senior Secondary School Examination (XII)

  2017 — 2018