SHAKTI BANSAL
Finance Manager
New Delhi
Summary
Results-driven finance professional with over 14 years of expertise in FP&A, SOX compliance, IFRS, R2R, and financial reporting. Currently managing commercial finance for Coca-Cola, overseeing critical functions such as revenue reporting, P&L dashboards, rolling forecasts, budgeting, and pricing strategies. Demonstrated success in financial modeling, variance analysis, cash flow forecasting, and cost optimization, with hands-on experience in the implementation of IFRS 15 and 16. Committed to enhancing team productivity through advanced Excel and VBA/Macros training while fostering a culture of continuous improvement and operational excellence.
Overview
14
14
years of professional experience
3
3
Languages
Work History
Finance Manager
Genpact
04.2023 - Current
- Independently managed 15 Bottlers in one of Coca-Cola's largest markets, overseeing revenue performance, cost management, and financial operations.
- Streamlined weekly and monthly financial reporting, improving the accuracy, efficiency, and timeliness of business insights.
- Implemented Lean Sigma strategy to optimize financial processes, reduce inefficiencies, and enhance operational performance.
- Led revenue reporting and P&L dashboard management for Coca-Cola and Bottlers, ensuring accurate financial tracking and analysis.
- Managed revenue sharing agreements with Bottlers, ensuring accurate settlement finalization and alignment with commercial goals.
- Finalized system P&L and ensured data accuracy across financial systems and platforms.
- Calculated and uploaded Rolling Estimates in SET, driving improved forecasting precision and supporting business planning.
- Developed and delivered weekly revenue dashboards with YOY and MTD performance comparisons, providing actionable business insights.
- Utilized scenario planning to assess various financial outcomes, enabling better strategic decision-making and risk management.
- Issued and maintained revenue sharing agreements and concentrate pricing letters to Bottlers, ensuring clear communication and consistent pricing strategies.
- Acted as the primary point of contact for all revenue sharing and pricing matters, ensuring clarity and alignment between Coca-Cola and Bottlers.
- Enhanced financial forecasting accuracy through advanced analytical models, scenario planning, and predictive analytics, driving more reliable decision-making.
Finance Manager
HSBC
11.2022 - 04.2023
- 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
- Held multiple roles, including Assistant Manager in FP&A, R2R, SOX compliance, and AP, developing a broad financial skill set.
- Conducted P&L trend analysis, including adjustments via journal vouchers (JV) for accurate financial reporting.
- Performed budget vs actual comparisons, providing insights into variances and improving financial planning.
- Managed Rolling Estimates, ensuring timely and accurate forecasting to support business decision-making.
- Performed payroll analysis, ensuring alignment with budget and financial objectives.
- Developed revenue and cash forecasts, enhancing cash flow management and financial predictability.
- Reconciled balance sheet accounts and substantiated financial data for accurate reporting and audit compliance.
- Managed month-end closing, ensuring timely and accurate completion of financial reporting processes.
- Processed JVs for accurate accounting and financial statement preparation.
- Led Accounts Payable (AP) team, overseeing processing, payment, and vendor management to ensure operational efficiency.
- Coordinated SOX audits, ensuring compliance with internal controls and regulatory standards.
- Prepared tax packs and impairment schedules, supporting tax reporting and financial statement preparation.
- Led process simplification initiatives, resulting in $10K savings by optimizing financial workflows and reducing inefficiencies.
- Managed and executed the implementation of key projects, including IFRS 15 & 16, Concur, Kyriba, Purchase Plus, and FoodBuy.
Team Member
KS Arcis Outsourcing Pvt Ltd
06.2012 - 04.2013
- Managed accounting for UK clients, including the preparation of financial statements in compliance with local accounting standards.
- Handled accounts receivable and accounts payable, ensuring timely invoicing, payment processing, and reconciliation.
- Maintained and updated the General Ledger, ensuring accurate and complete recording of financial transactions.
- Managed intercompany transactions to ensure proper accounting treatment and elimination for consolidation.
- Conducted bank and balance sheet reconciliations, ensuring accuracy and resolving discrepancies.
- Prepared detailed management reports for internal stakeholders, highlighting key financial metrics and insights.
- Prepared and filed VAT returns, ensuring compliance with tax regulations and timely submission.
Accounts Executive
North East Garments Private Limited
06.2011 - 06.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
08.2011
Skills
In-house trainer for Advanced excel and Macro (VBA)
Power BI
Six Sigma White belt
Project Management
Oracle PeopleSoft (current version 92) finance support
Budget forecasting
Financial analysis
Financial modeling
Performance analysis
Personal Assets
- Integrity
- Innovation
- Initiative
Timeline
Finance Manager
Genpact
04.2023 - Current
Finance Manager
HSBC
11.2022 - 04.2023
Assistant Manager
Intercontinental Hotel Group India Pvt Ltd
04.2013 - 11.2022
Team Member
KS Arcis Outsourcing Pvt Ltd
06.2012 - 04.2013
Accounts Executive
North East Garments Private Limited
06.2011 - 06.2012
B.Com (Hons) - Accounting & Finance
University of Delhi