VAIBHAV
AGARWAL
Chartered Accountant
Summary
Chartered Accountant with 3 years of professional experience in the banking industry. Working in dynamic environment and proficient in financial modelling, VBA for automation of work, data analytics and regulatory reporting. Professional Experience
Upwork [January 2020-Present]
• Re-constructing and creating a new Financial Model for Rego Realty which is a Canada based Real-Estate company.
• Data Analysis and finding trends in data.
• Handling projects on VBA, cash flows, financial statements. Deputy Manager (Regulatory Reporting) [March 2017– December 2019] AU Small Finance Bank Ltd. - Jaipur
Roles and Responsibilities:
• Preparing and reviewing of accounts and Finance regulatory reports in accordance with regulatory instructions and ensuring completeness and accuracy.
• Creating Processes for main returns of the bank like CRILC (Central Repository for Information of Large Creditors) and Financial Inclusion Plans.
• Implementing ADF Project (Automated Data Flow) wherein coordinated with vendors and IT for systematic flow of information and validation of data.
• Handled Annual Financial Inspection by Reserve Bank of India for 2 simultaneous years in close coordination with the senior management of the Bank.
• Automating the reports by creating Macros and Templates to improve work efficiency and reduce manual intervention.
• Obtained RBI licences and approvals like MICR, IFSC, Branch Authorisations and Mobile payments.
• Making, reviewing and filing the regulatory reports in accordance with regulatory instructions efficiently within the prescribed deadlines.
Accomplishments:
• Key member of the project team during the conversion of AU financiers to AU Small Finance Bank Ltd.
• Received Consistent Performer award for continuously performing in the span of 2 years. Article Assistant [Oct, 2013 – Sept, 2016]
M/S G. Dutta & Co. - Jaipur
• Prepared the project report for ADLIFE Hospital in Jaipur.
• Worked in Finance Team for 6 Months under direct supervision of CFO of Mahima Real Estate Pvt. Ltd. wherein assisted management of various loans like WCDL, term loans, vehicle loan and construction loan.
• Prepared CMA Data for 10 years of projections and MIS for interest loan payment and verification of interest
• Planned & assigned audits of 48 hubs between various External Auditors and variance analysis and reporting at Jabong.com (E-commerce Industry)
• Performed Bank Audit of State Bank of Bikaner and Jaipur (Bassi branch) Additional Activities
• Skill Development course of Financial Modelling including Microsoft Excel for data analysis, VBA for automation of work and Building of Financial Models.
• NCFM-Project Finance Module Exam conducted by NSE India.
• Presented the profiles in the National Convention for CA Students held at Jaipur
• Participated in various competitions at School level including Debate, Karate and Mathematics Olympiad.
Skills :
Data Analytics
Accounting
Creating New Process
Liaisoning
General Management
Research
Pressure Handling
Handling Voluminous
Data
Jaipur, India
adcgca@r.postjobfree.com
DOB: July 5, 1994