Raunak Ahuja

About Raunak Ahuja

With over six years of experience in finance, I am a seasoned professional with a passion…

Experience

1. Senior Manager Finance

   Tantia Constructions Ltd

   Oct 2021 — Present · Kolkata, IN

   i) Responsible for preparation of annual business plan (budget) after collating all the functional budgets of each construction project, including quarterly review and revisions basis the completion stage of the project.ii) Preparation of monthly MIS on revenue, overheads and margin to provide insights to the stakeholders using the Microsoft Power BI Identification and analyzing the trends of the Key Performance Indicator\'s (KPIs).iv) Preparation of presentations for prospective investors, involving medium and long-term forecasts after soliciting inputs from concerned departments. This includes preparation of financial models (of P&L, cashflow and statement of assets & liabilities) for the purposes of forecasting.v) Responsible for calculation & analysis of key financial ratios for each of the projects, viz, asset-management ratios, liquidity ratios, leverage ratios, etc.vi) Developing various expense models using assumptions and scenarios for facilitating financial decision-making. Tracking, Monitoring & Controlling of all Expenses (Opex/ Capex).vii) Responsible for communicating relevant performance metrics to the project leaders and clearly explaining the business reasons for variances, and adjusting outlook models to reflect operational Collaborate for data analysis, trend assessment across departments.ix) Assist in the month end close process by preparing recurring and ad hoc reports, researching general ledger activities and variances to the budget and prior year.x) Validating accuracy of financial data and reports by preparing monthly profit & loss account & balance sheet, performing reconciliations and review of exceptions.xi) Responsible for identifying and driving process improvements, including creation of standard and ad-hoc reports and excel dashboards.

Education

• St Johns' High School

  ISC (Class XII) - Batch of 2012

• St Johns' High School

  ICSE (Class X) - Batch of 2010

• Goenka College of Commerce and Business Administration

  Bachelor of Commerce - BCom

  2012 — 2015