Summary
Overview
Work History
Education
Skills
Extra-curricular Activities
Personal Information
Timeline
Generic

Rahul Agarwala

Kolkata

Summary

  • 1+ year experience in Financial Planning and Analysis division at Jindal Steel & Power Limited, Raigarh
  • 3-year internship & 0.5 year of experience in Audit & Assurance division at Salarpuria Jajodia & Co. ,Kolkata

Overview

5
5
years of professional experience

Work History

Financial Assistant

Jindal Steel and Power Limited (JSPL)
Raigarh
2022.11 - Current
  • Preparation of MIS reports - TOC files (weekly), SOC Deck (monthly performance report).
  • Analyzing trend of SBU wise EBITDA on weekly ,monthly & Year till Date (YTD) basis ,preparing revised annual profitability estimate based on trend.
  • Demonstration of 17 weeks cash flow by preparing next 4 weeks forecast & analyzing last 13 weeks actual trend of cash flow.
  • Analyzing trends of SBU wise sales price per unit in comparison with global steel price index, pictured through box plot graphs & other charts.
  • Handled automation projects for daily operational cash flow report.
  • Assisted in preparation of annual business plan of Raigarh plant and analyzing areas for improvement.
  • Reconciliation of EBITDA and MIS cash flows with books of accounts.
  • Managing working capital of plant by analyzing its various components.

Skills learnt

  • Improvising interpersonal skills through regular co-ordination with various departments.
  • Enhanced presentation skills by visualizing data through charts to cater requirements of top management.
  • Key factors driving steel manufacturing process.

Articled Assistant

Salarpuria Jajodia & Co.
Kolkata
2019.04 - 2022.09
  • Performed statutory audits, analysis of financial statements in various sectors having turnover up to 500 Crore of listed and unlisted companies.
  • Handled and reviewed end to end work regarding finalization of financial statements, ensuring compliance with Schedule III ,Limited Reviews ,stock audits and various certification work related to NBFC.
  • Led teams of around 3-4 people for statutory audit, handled overall audit work including planning, work allocation & follow up with clients.
  • Preparation of Independent Auditor’s Report on CARO for a diverse client base, segment reporting, tax computation, consolidation (Ind AS), vouching & verification, ledger scrutiny and variance analysis etc.
  • Key areas handled pertains to treatment of investments, Property Plant & Equipment, Borrowings etc.

Education

Chartered Accountancy -

ICAI
Kolkata,
05.2022

B. Com (Hons.) - Accounting and Finance

Calcutta University
Kolkata,
12.2020

Class XII -

Atrayee DAV Public School, CBSE
Balurghat, WB ,
03.2017

Skills

  • SAP HANA 4 (Accounting and External Reporting tool at JSPL)
  • Proficiency such as MS Word, MS Excel & MS PowerPoint
  • Tally ERP 9 (Accounting and External Reporting tool used by various mid-sized clients during article ship)
  • IDS (Accounting and External Reporting tool used by Hospitality Industry)
  • BI tools i.e., Qlik sense & Power BI

Extra-curricular Activities

  • Meditation, Swimming, exploring new places, writing.
  • Performed parade as a commander representing school on Republic Day.
  • Speaker on various occasions and weekly training Programs conducted during intership.

Personal Information

  • Languages: Proficient in English, Hindi & Bengali
  • Father's Name: Binod Kumar Agarwala
  • Date of Birth: 20/07/1998
  • Gender: Male
  • Membership No. : 318765
  • In: www.linkedin.com/in/iamrahulagarwala

Timeline

Financial Assistant

Jindal Steel and Power Limited (JSPL)
2022.11 - Current

Articled Assistant

Salarpuria Jajodia & Co.
2019.04 - 2022.09

Chartered Accountancy -

ICAI

B. Com (Hons.) - Accounting and Finance

Calcutta University

Class XII -

Atrayee DAV Public School, CBSE
Rahul Agarwala