ASHEESH PAHWA
RTR-Intercompany ,GL Accounting And MIS
Delhi
Summary
Results-driven finance professional with over 10 years of experience in Record-to-Report (R2R) processes, specializing in MIS reporting and financial operations. Proven expertise in automating workflows, developing data models, and delivering advanced Excel solutions that enhance operational efficiency. A strong analytical mindset combined with a commitment to accuracy ensures the delivery of high-quality financial insights. Dedicated to driving continuous improvement and leveraging technology to optimize financial performance.
Overview
11
11
years of professional experience
Work History
Assistant Manager
Genpact
08.2021 - Current
- Reviewing and supporting for booking month end journal entries like accruals, prepayrments,amortization, inter-company accounting.
- Review and analysis Bank Reconciliation prepared on monthly basis to showcase alignment between Bank transaction and GL
- Review and analysis Inter-Company reconciliation on monthly basis for different entities and make adjustment entries
- Following up on Open items with GL and B/S reconciliation.
- Standard operation procedures (SOP) documentation and ensures procedures are continuously updated for my team to reflect current practices and policies.
- Managing a Team of 5 FTE's and responsible for effective, efficient and accurate financial.
- Built Interactive Dashboards through Power query, power pivot (Data Modelling)
- Works on M code language.
- In depth knowledge of dynamic arrays.
- Worked on project to send all email on one click through VBA macros
- Reconciliation of the open invoice we booked and what affiliate had book at their end and we must reconcile them every month closure.
- Taking calls with the clients and the affiliates for the resolution of the open items on weeklybasis.
Team Leader
Thomas Cook India
08.2019 - 08.2021
- Designed dashboards for collections and outstanding tracking
- Analyzed DSO and credit performance
- Automated reports using Excel and Power Query
Process Associate
Genpact
07.2015 - 08.2019
- Vendor reconciliation and invoice processing
- Handled journal entries and MIS reporting
- Conducted training and quality audits
- Handling profile related to R2R and reporting, for US Client responsible for Month, Quarter, Yearend closing.
- During closing responsible for preparing various types of journals like Accrual, Reclass, Prepaid, Depreciation, Amortization.
- Month End closing, and Depreciation run
Education
B.Com -
Delhi University
01.2010
CBSE - undefined
01.2007
CBSE - undefined
01.2005
Skills
- Advanced Excel, Dynamic Arrays, Lambda Functions (SCAN, REDUCE)
- VBA Macros (automation & reporting)
- Power Query (M Language), Power Pivot, Data Modelling
- Power Automate & Workflow Automation
- R2R, Intercompany Accounting, MIS Reporting
- Team Management & Stakeholder Communication
- Accounts Payable
- Invoice processing
- GL Accounting
Timeline
Assistant Manager
Genpact
08.2021 - Current
Team Leader
Thomas Cook India
08.2019 - 08.2021
Process Associate
Genpact
07.2015 - 08.2019
CBSE - undefined
CBSE - undefined
B.Com -
Delhi University