Abhishek Ailawadi
New Delhi
Summary
A qualified Chartered Accountant and a Microsoft Certified Excel Expert having academic background and work experience in financial reporting having strong analytical skills combined with effective communication abilities. Abilities in handling multiple priorities, with a bias for action and with keen interest in personal and professional development. Set challenging goals and achieved those goals through persistence, dedication and commitment.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Fund Accounting Analyst
Citicorp Services India Private Limited
Gurugram
01.2022 - Current
- Preparation of financial statements including Balance Sheets, Income Statements & Statement of Changes in Net Assets for mutual funds.
- Preparation & review of annual & semi annual reports including the financial statements & the related annexures for mutual funds.
- Performing annual & semi annual reconciliations such as cash reconciliation & income reconciliation.
- Monthly computation of key financial ratios such as Portfolio Turnover Ratio & Ongoing Charges Figure.
- Preparation of client specific weekly & monthly activities as per client's requirement.
- Optimized workflow processes through identifying opportunities for improvement that resulted in increased productivity, thereby enhancing the quality of deliverables and also reducing errors.
- Contributed to team success by sharing expertise on complex topics related to fund accounting.
Education
Chartered Accountant -
The Institute of Chartered Accountants of India
07.2021
PGDBA - Finance & Marketing
Symbiosis Centre For Distance Learning, Pune
2021
B.Com (H) -
Sri Aurobindo College, University of Delhi
2017
Class XII -
SD Public School, Delhi
2014
Class X -
SD Public School, Delhi
2012
Skills
Hard Skills:
- Microsoft Excel
- Microsoft Power BI
- Microsoft Excel VBA
- Tableau
Soft Skills:
- Interpersonal Skills
- Continuous Learning
- Problem Solving
- Process Improvement
Achievements & Activities
- Awarded for developing an automated Excel template (with Macros) that helped in the preparation of a major portion of the Notes to Financial Statements for a major client which now saves around 150-180 hours annually.
- Received recognition from other teams as well for solving complex problems & providing quick resolutions on MS Excel.
- Secured exemption (above 60%) in Financial Reporting, Strategic Financial Management (SFM) & Risk Management in CA Final.
- Secured exemption (above 60%) in Accounting, Cost Accounting & Financial Management and Advanced Accounting in CA IPCC.
- School Topper in Class X and XII with 9.8 CGPA and 92% marks respectively.
Organizational Scan - Additional Tasks
- Developed highly interactive, customized, user-friendly excel templates to automate routine manual tasks and streamline the work processes.
- Utilized Microsoft Excel extensively for analyzing complex datasets and extracting relevant & meaningful information.
- Imparted trainings on MS Excel (both online & offline) to colleagues & co-workers including people from other teams.
- Applied basic to advanced excel tools in work such as: Day to Day formulae like SUMIF(S), COUNTIF(S), VLOOKUP, INDEX/MATCH, XLOOKUP etc., Pivot Tables, Excel VBA, Power Query in Excel.
Marital Status
Single
Personal Information
Date of Birth: 04/26/96
Certification
Microsoft Certified Excel Expert
Languages
English
Hindi
Personal skills & USP
- Good relation building skill.
- Good communication, presentation and interpersonal skill.
- Good problem solving skill.
- Active learner, punctual &hardworking.
Timeline
Fund Accounting Analyst
Citicorp Services India Private Limited
01.2022 - Current
Chartered Accountant -
The Institute of Chartered Accountants of India
PGDBA - Finance & Marketing
Symbiosis Centre For Distance Learning, Pune
B.Com (H) -
Sri Aurobindo College, University of Delhi
Class XII -
SD Public School, Delhi
Class X -
SD Public School, Delhi