Senior FP&A Analyst
PepsiCo International - United Arab Emirates
Total years of experience :14 years, 11 Months
• Managing forecast process including P&L and Cash Flow for AMESA; consolidating, preparing and analyzing Business submissions. Identifying risks & opportunities and preparing review decks for senior leadership and corporate.
• Led Opex benchmarking & analysis exercise for AMESA in 2020; comparing different Businesses historical trends and cost evolution. Presented to sector leadership to highlight opportunities for cost savings.
• Responsible for Financial Monthly Reporting Pack to Sector CFO & SVP Planning; including GP margin analysis, NRR, Opex analysis, monthly profitability and P&L, Cash flow performance of Sector and Businesses.
• Coached & trained FP&A hub team; Yielding significant dividends as hub now manages several tasks with little intervention.
• Revamped forecast models to facilitate process change from CFR to Hyperion Financial Management (HFM) helped different Business Units FP&A team in ensuring smooth transition.
• Supporting FP&A leadership in adhoc analyses & Quarterly Corp. POR deck preparation, BOD letters, CEO letters etc.
• HFM subject matter expert with hands on experience of preparing analytical, consolidation & upload tools for P&L/OCF.
• Drove simplification & time saving for Businesses by instituting centralized OCF template reset for each BU leveraging GBS Hub team thereby freeing up time for BU FP&A to focus more on quality submissions.
• Led the process from FP&A team for AMENA sector split into AMESA and APAC - prepared revised HQ costs, Plan numbers, flex and historical data and aligned control team.
• Preparing AMENA Monthly and Quarterly business reviews - analyzing the performance of BUs and Key markets.
• Supporting FP&A leadership in adhoc analyses & Quarterly Corp. POR deck preparation, AOP reviews to corp. & BOD letters.
• Responsible for sector Innovation planning - comparing vs Plan, Prior Fcst and PY and analyzing project performance
• Managing Sector Brand P&L data collection, consolidation, analysis and publishing the report
• Tracking Working and Non-Working A&M and brand wise A&M spend for BUs in the sector.
• Responsible for End to End business planning for Levant & North Africa clusters, comprising 10+ countries. Partnered with cross functional teams including Franchise, Marketing & Supply chain to effectively plan for and support business growth.
• Prepared PSP for diverse markets of Levant & North Africa (OFAC, JVs, Multiple bottlers) in line with PepsiCo growth aspirations and was awarded Dream Team award for my efforts
• Responsible for monthly P&L forecasts and quarterly OCF including; identifying & highlighting business risks & Opportunities to Sr. management. Formulate strategies to capitalize on opportunities & mitigate risk.
• Worked with key stakeholders to analyze profitability for new products launches in Levant and NA markets.
• Preparing and presenting Monthly Business Reviews for key markets to Franchise / Finance leadership.
• Prepared Bottler P&Ls for different markets like Iran, Algeria & Sudan to calculate system profits.
• Preparing different scenarios and evaluating financial impact - including but not limited to pack price changes, mix, NWSP etc.
• Conducted Training in Beirut on “Total System Economics” & inculcated the primacy of total system profitability.
Monthly Reporting & Financial Analysis
• Developed Monthly Dashboard Reports, Project Profitability & Consolidation of Financials for the companies in the Group (Q Properties, Q Avalon, Q Development, Safecage Armour Works, CirQ Investments)
• Prepared Monthly & Quarterly Performance Reports for the companies & analyze variances vs Budget & PY.
• Preparing Budgeted vs Actual Costing and Profitability for different projects & identify key factors for variances.
• Analyzing the financials using KPIs, vertical and horizontal analysis to pinpoint inconsistencies in costs and revenues.
• Worked on several ad hoc reports & analyzing numerous scenarios and highlighting the financial impact.
Financial Controlling
• Assisting team members in Preparing and Finalizing the Financial Statements and reviewing them with CFO.
• Managing the Finance team in ensuring the finance operations are run smoothly.
• Responsible for Project profitability and costing by ensuring all costs are booked in respective projects by control team.
• Reconciliation of the Receivables from the clients and managing their statement of account & ensuring timely collection.
Financial Modelling
• Implemented numerous Financial Models in routine activities to help in enhancing Productivity eg. Prepared model to automatically generate pay slips for employees using existing payroll system that reduced time from 1.5 days to 2 hours.
• Standardized Dashboard & Financial reporting structure by preparing financial models which increased productivity.
• Prepared Business Plan Models for several ventures and in analyzing their worth and viability to launch.
• Prepared Business Models to analyze KPIs for the group which was circulated with monthly dashboard reports.
Financial & Business Planning
• Prepared 3 Year Strategic plan for all companies in Q Group by working with all the concerned departments.
• Prepared Annual Budget for the companies in the Group for 2015 & 2016 which was used to compare monthly performance
• Worked with Q Development team in preparing financial feasibility & analysis for The World Island Project.
• Part of Internal Meetings on subjects like Project Analysis, Budgeting, Recruiting Workforce, closing of accounts, making Financial Decisions, Analyzing different scenarios, costing, increasing revenues and forecasting.
• Forecasting cash flows of the group to assist in making important cash flow decisions & in highlighting cash flow requirements and managing the payments to ensure company has adequate working capital.
Investment & Research Analysis
• Conducted research & prepared Feasibility Report to start business center & recruitment consultancy business.
• Analyzing Investment & Project Feasibility for various ventures using distinct techniques like NPV, projected financial statements, payback period & profitability index. Prepared feasibility & analysis when acquired one of the companies.
• Conducted Benchmarking Analysis, Valuation Analysis, & Industry Research to ascertain Risk and Profitability of projects.
Strategic Management, Business Improvements & Decision Making
• Assisting CFO in making Financial Decisions and working on several ad hoc reports whenever needed.
• Preparing Presentations and Reports for Board Meetings on behalf of the Finance Department.
• Identifying the costs of projects, monitoring several projects in the group and their profitability.
• Worked with directors to revise Remuneration Plan, & formulate strategies to improve business processes & productivity.
• Identifying areas of cost savings & reported to enhance processes/ productivity & improve profitability.
• Analyzing the cost trends vs plan and vs historical period and identifying the variances and reasons for higher/lower costs.
• Creating Scenario Based Reports using Macros for the Management to evaluate a number of scenarios.
• Working closely with the team in preparing Business Plans and Feasibility reports.
• Managing multiple projects at a time and ensuring all projects are delivered with timely and accuracy.
• Formulating Financial Statements including P&L for Business and Marketing Plans.
• Consulting clients and facilitating them in starting their new ventures & to expand their businesses.
• Working with the manager in formulating strategies for different clients.
• Identifying issues in the projects and highlighting to the management to improve the quality of the projects.
• Managing the Accounting of the company & ensuring accurate Recording of revenues and costs in their respective projects.
• Worked with the accountant in preparing & preparing the financials including Profit & Loss, Cash Flow, and Balance Sheet.
• Preparing Monthly, Quarterly and Yearly Financial and Management Reports and circulating it to the management.
• Managing the payables and receivables along with Bank reconciliation as well as preparing the aging report.
• Assisting the financial manager in cash flow and financial decisions
• Preparing and processing the payroll of the employees
Worked on a project to analyze the NPV, Payback period and Average Return on Investment of different retail outlets of PSO.
Worked on Oracle as well as prepared different types of documents for routine activities to learn about how accounts are maintained at the company.
Learnt about branch banking and different operations at Branch banking.
Qualification Institution Result Year M.B.A. Bahria University, Karachi Majors: Finance & Accounting CGPA: 3.67 Honored: Cum Laude 2011
Internships: Pakistan State Oil Dec, 2007- Feb, 2008 Faysal Bank Ltd. July, 2006 –Aug, 2006 Hinopak Motors Ltd. Aug, 2007 –Sep, 2007 ACHIEVEMENTS • Honored “Cum Laude” by Bahria University for excellent performance throughout BBA as well as MBA. • Leaded the team from Bahria University for Innovative Business Idea in ProCom and won 2nd prize. • Pure Merit based Scholarship in 3rd semester for securing 4 GPA. PROJECTS / RESEARCH WORK Project on Analysis of the PSO Retail Outlets’ Expected and Actual Sales, Cash Flows, • Pakistan”. • Payback Period, NPV etc. Prepared a Thesis for MBA on “Trade liberalization in the Outsourcing Industry of
B.B.A. (Hons.) Bahria University, Karachi Majors: Finance & Accounting CGPA 3.72 Honored: Cum Laude 2009