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
11.2022 - 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 unitin 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
04.2019 - 09.2022
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 ie, 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)
11.2022 - Current
Articled Assistant
Salarpuria Jajodia & Co.
04.2019 - 09.2022
Chartered Accountancy -
ICAI
B. Com (Hons.) - Accounting and Finance
Calcutta University
Class XII -
Atrayee DAV Public School, CBSE
Similar Profiles
Priya AgrawalPriya Agrawal
Payments Business Analyst at One MobiKwik Systems Private LimitedPayments Business Analyst at One MobiKwik Systems Private Limited