Hi, I’m
Subham Kumar
Hyderabad
Summary
Accomplished finance professional with a track record of success in various roles within the finance departments of FMCG and banking industries. Skilled in MIS reporting, financial planning, compliance, forecasting, budgeting, variance analysis, AP and AR processes, accrual management, and stakeholder relationship management. Proven expertise in driving business and operational excellence through continuous process improvement, transitions, financial transformation, and FP&A initiatives.
Overview
8
years of professional experience
Work History
PepsiCo
Deputy Manager (FP &A)- Commercial - UK & Ireland
04.2023 - Current
Job overview
- Collaborated with Business Partners, Sales Finance Director, and Sales team to develop AR & AP Ageing reports, enabling leaders to analyze data by customers, suppliers, and regions
- Partnered with leadership to implement an automated financial statement reporting system using Power BI
- Extracted data from TM1 and SAP, created a data model with data refresh capabilities using Power Query, and developed Settlement & Deductions data in Power BI by team-wise queue
- Designed a data model with data refresh capabilities using Power Query and constructed a month-end reconciliation report to compare month-to-date (MTD) processed transactions against general ledger (GL) postings
- Managed accounting functions for Accounts Payable (AP), Accounts Receivable (AR), and collections, including promotions, base agreements, and pricing changes
- Formulated Standard Operating Procedures (SOPs) for various processes
- Prepared and presented management decks to senior leadership on a quarterly basis
- Developed new procedures for AR, cash flow, and reconciliation processes, reducing average invoice processing time by 20%
- Analyzed and reviewed accruals with Finance Business Partners following promotion runs and pricing changes
- Provided supporting documentation for external audits in compliance with state regulations
- Reviewed and provided commentary on accrual variances across divisions, regions, and functional roll-ups
PepsiCo
Assistant Manager (FP &A)- Commercial - FLNA
10.2021 - 03.2023
Job overview
- Supported PepsiCo Frito-Lay North America in Trade Promotion Management, a key function within the Finance department
- Responsible for creating new contracts by analyzing forecast versus actual performance of vendors and distributors, and resolving issues related to new or existing contracts
- As a Rebate Finance Analyst, conducted contract reviews, profit and sales projections, rebate calculations and reporting, and prepared monthly, quarterly, and annual reports
- Performed variance analysis to identify discrepancies between projected figures and actual expenditures and recommended or implemented corrective actions
- Managed vendor creation, vendor management, and purchase order (PO) creation in Oracle
- Handled invoicing within the trade promotion management system
ICICI Bank Limited
Deputy Manager (Corporate Banker)
03.2021 - 10.2021
Job overview
- Deliver financial advice to clients, proposing strategies to achieve short and long-term objectives for investment, insurance, business, and estate planning with minimal risk
- Prepare weekly reports and lead presentations to brief HNI clients on financial outlook
- Monitoring cash flow transactions of clients
AXIS Bank Limited
Assistant Manager (Retail Operations)
06.2017 - 09.2020
Job overview
- Managing Branch Operations and day-to-day activities
- Preparing MIS report on the cash inflow and outflow of mapped book
- Disbursement of inventory and deliverables and retail foreign remittance
Education
LPU
M.B.A from Finance and Marketing
01.2017
LPU
B. Com from Finance
01.2015
Skills
- Budgeting & forecasting
- Strategic Business Planning
- Financial Planning & Reporting
- Process Improvement
- SOP Control
- Cross-functional Collaboration
- Internal Compliance
- Stakeholder & Client Relationship Management
- SLA & OLA Optimization
- Continuous process improvement & Automation
- Data Analyst
- Financial Transformation
- Data Analysis
- Quick learner
- Advance Excel
Accomplishments
- Got an opportunity to Travel to UK for KC capture and to introduce and stabilize the new process in PepsiCo HBS.
- Was able to complete a quick transition from two SME’s (Subject matter experts) at a time in a short span of one and half months.
- Followed up with Member firm people and cleared all the receivables pending 90-365 days bracket which had a huge impact on the revenue (£3.5MM).
- GBS Champ Nov’21: Stabilized A&M process, achieved early Go-live.
- FP Townhall Recognition: Transition of Accrual & deduction reporting process & successfully completed KT for 2 FTE’s & started working on production environment & tracking KPI.
- Automation: Used PowerBi to automate the reconciliation process with saving of 155 hours p.a.
Languages
English
Hindi
Locations
- Hyderabad, Telangana, India
- Araria, Bihar, India
Personal Information
- Date of Birth: 05/28/95
- Gender: Male
- Nationality: Indian
- Marital Status: Single
System Knowledge
- SAP
- SAP & S4 HANA
- MS Office
- Cockpit 3.0 & 2.0
- Power BI
- Oracle
- CDSI
- Mosaic
Timeline
Deputy Manager (FP &A)- Commercial - UK & Ireland
PepsiCo
04.2023 - Current
Assistant Manager (FP &A)- Commercial - FLNA
PepsiCo
10.2021 - 03.2023
Deputy Manager (Corporate Banker)
ICICI Bank Limited
03.2021 - 10.2021
Assistant Manager (Retail Operations)
AXIS Bank Limited
06.2017 - 09.2020
LPU
B. Com from Finance
LPU
M.B.A from Finance and Marketing
Similar Profiles
RICARDO HINOJOSARICARDO HINOJOSA
Team Lead at PepsiCoTeam Lead at PepsiCo
Shane HillShane Hill
Maintenance and Engineering Leader at PepsiCoMaintenance and Engineering Leader at PepsiCo
Ja'Shon SnipesJa'Shon Snipes
Warehouse Worker at PepsiCoWarehouse Worker at PepsiCo
Vaibhav DubeyVaibhav Dubey
Principal Software Engineer at PepsiCoPrincipal Software Engineer at PepsiCo
SAI HARISH PASUPULETISAI HARISH PASUPULETI
Head – Marketing & Communications at MoninHead – Marketing & Communications at Monin