SHAKTI BANSAL
Finance Manager
New Delhi
Summary
To Work in a dynamic environment that provides me a wide spectrum of experience and exposure. To bring a dynamic and versatile portfolio of skills at work place and to serve the organization with positive attitude and efficiency.
Overview
11
11
years of professional experience
3
3
Languages
Work History
Finance Manager
Genpact
04.2023 - Current
- Reporting of revenue numbers and P&L dashboards for Coca -cola and Bottlers.
- Finalization of revenue sharing with bottler & its settlement
- Finalization of system P&L
- Roplling Estimate calcuation and uploading in SET
- Weekly revenue dashboard with YOY & MTD comparison
- Issuance & maintenance of revenue sharing and concentrate pricing letter to bottler
- Acting as single point of contact for all revenue sharing, pricing information for Coca Cola
Finance Manager
HSBC
11.2022
- Performing reconciliation and substantiation including checking for open items and reporting them on monthly basis including their clearance details
- Monitoring control and suspense account and reaching out to account owners for its clearance
- Managed reconciliation tool which included assignment of recons, making sure Ledger balances are correctly copied to reconciliation tool and all recons are completed within timeline
- Preparing Nostro Vostro journal on quarterly basis.
Assistant Manager
Intercontinental Hotel Group India Pvt Ltd
04.2013 - 11.2022
- Worked in various roles including Assistant Manager in Finance governance compliance (SOX), Assistant Manager in AP, Team Lead in AP Domain managing AP, Team Lead in R2R domain_ Europe region, Specialist ASIA -GC region, Senior Analyst ASIA-GC region, and Analyst ASIA-GC region.
- Implemented IFRS 15,16
- Part of project management wherein I implemented Concur, Kyriba, Purchase plus, FoodBuy and led to saving of US$10,000.
Team Member
KS Arcis Outsourcing Pvt Ltd
- Handled accounting of UK clients including preparation of financial statements, maintaining accounts receivable, accounts payable, General Ledger, Intercompany transactions, bank and balance sheet reconciliation, preparation of management reports, preparation of VAT returns.
Accounts Executive
North East Garments Private Limited
- 05.2012
- Handled all accounting and taxation matters including filling of CST, VAT, TDS return, issuance of Form 16, 16A, managing payroll, banking matters, preparation of monthly reports for managerial decisions, handling cash transactions, preparation of monthly purchase statement, maintenance of stock items and godowns, working knowledge of revised schedule VI, updating and submitting annual return Form 20B to ROC.
Education
B.Com (Hons) - Accounting & Finance
University of Delhi
Delhi 04.2001 -
No Degree - Financial Modelling
Financial Modelling
Delhi 04.2001 -
No Degree - Six Sigma White Belt
Six Sigma White Belt
Delhi 04.2001 -
No Degree - Power BI
Power BI
Delhi 04.2001 -
Skills
In-house trainer for Advanced excel and Marco (VBA)
Power BI
Six Sigma White belt
Project Management
Oracle PeopleSoft (current version 92) finance support
Essbase Hyperion Financial Module
Blackline
Kyriba
Concur
MySQL
Personal Information
- Total Experience: 12 years
- Date of Birth: 11/20/89
Past Experience
- HSBC, 11/22, 04/23, 5 months, Finance Manager, Performing reconciliation and substantiation including checking for open items and reporting them on monthly basis including their clearance details., Monitoring control and suspense account and reaching out to account owners for its clearance., Managed reconciliation tool which included assignment of recons, making sure Ledger balances are correctly copied to reconciliation tool and all recons are completed within timeline., Preparing Nostro Vostro journal on quarterly basis.
- Intercontinental Hotel Group India Pvt Ltd, 04/13, 11/22, 9 years, Assistant Manager, Finance governance compliance (SOX), AP Domain managing AP, R2R domain_ Europe region, Specialist ASIA -GC region, Senior Analyst ASIA-GC region, Analyst ASIA-GC region
- KS Arcis Outsourcing Pvt Ltd, 06/12, 04/13, 10 months, Team Member, Preparation of Financial statements, Maintaining accounts receivable, accounts payable, General Ledger, Intercompany transactions on Sage, Xero under UK IFRS, XBRL Tagging of Financials for submission to HMRC using XBRL, Bank, balance sheet Reconciliation, Preparing Management reports, Preparation of VAT Returns
- North East Garments Private Limited, 06/11, 05/12, 1 year, Accounts Executive, Filling of CST, VAT, TDS return, Issuance of Form 16, 16A, Managing pay roll, Banking matters including Bank Reconciliation, deposit of TDS /TCS, Preparation of monthly report for managerial decisions including MIS, Handling all cash transactions including monthly wages, Preparation of monthly purchase statement & reconciling them with balances as per ERP., Maintenance of stock items, godowns for job work using Tally, Working knowledge of revised schedule VI, Updating & submitting annual return Form 20B to ROC
Personal Assets
- Integrity
- Innovation
- Initiative
Projects
Implementation of PeopleSoft ARM module Kyriba TMS Foodbuy T&E tool – SAP Concur IRFS 15,16 Month end simplification including moving activities from Month end to non Month end period Automation of activities using PeopleSoft, excel Macros Implementation of new balance sheet reconciliation process with change of tool from Blackline to PeopleSoft
Timeline
Finance Manager
Genpact
04.2023 - Current
Finance Manager
HSBC
11.2022
Assistant Manager
Intercontinental Hotel Group India Pvt Ltd
04.2013 - 11.2022
B.Com (Hons) - Accounting & Finance
University of Delhi
04.2001 -
No Degree - Financial Modelling
Financial Modelling
04.2001 -
No Degree - Six Sigma White Belt
Six Sigma White Belt
04.2001 -
No Degree - Power BI
Power BI
04.2001 -
Team Member
KS Arcis Outsourcing Pvt Ltd
Accounts Executive
North East Garments Private Limited
- 05.2012