Overview:

• As HFM custodian ensure timely submission of AOP, SBP, financial templates and other associated Region requirements.
• Support Planning/ Finance Managers of both the businesses in development of SBP, AOP and Forecasts and related presentations.
• Prepare and report Management reviews/ analytics including MBR, QBR, OCF, Outlook and NOPBT Flash

Responsibilities:

• Financial Reporting (NOPBT Flash/MBR/QBR/OCF/Interim Outlook)

• Prepare monthly NOPBT flash – Pakistan, monthly financials for review with Planning Managers/CFO.
• Compilation of Monthly Business Review (Internal & External) while liaison with finance planning team and other functions.
• Prepare Interim Outlook / Rolling forecast.
• Manage monthly submission of G&A tracking and Rolling Forecast templates to Region
• Preparation of Fixed Asset schedule along with depreciation calculation for AOP & forecasts
• Preparation of monthly CAPEX template – monthly & YTD tracking against plan & forecasts & submit to region / BU
• Independent preparation & submission of all financial & functional templates to submit to BU for AOP & forecasts
• Support Planning Manager in the preparation and consolidate of bottlers’ COOPs agreements and circulate to franchise for bottlers sign-off.
• A&M and G&A funds management/reconciliation in Oracle.

• 
  Volume Reporting – Plan & Actual

• Independently manage HFM submission of AOP e-case Volumes (franchise-wise, brand wise, SKU-wise with monthly split) by working closely with Franchise team.
• Supervise/Prepare the mid/full month volume flash, HFM e-case reporting for both Pakistan (coordinating with 8 bottlers) & Afghanistan and Volume Performance Summary in multiple categories, e.g. CSD, NCB (Water & Juice).
• Supervise/prepare the National Key Account volume reporting template and Sector Template of NKA.
• Co-ordinate with Region planning team for updating/addition of new products/SKUs in HFM.
• Co-ordinates submission of mid-month volume flash

• SBP / AOP / Quarterly Forecasts

• SBP - Support planning team and take active participation in the preparation and submission of IBP financial algo (P&L, Balance sheet & OCF).
• Forecasts: Take active role in preparation of financials (Volumes, P&L/BS working) for March/June/Sept forecasts and manage HFM submission along with Offline templates.
• Pakistan & Afghanistan AOP- Proactively participate in the preparation of financials (Volumes, P&L/BS support working) and manage HFM submission thereof, along with Offline templates.
• Provide support in preparation of ad-hoc, SBP and AOP finance review presentations.
• Take lead in the preparation and finalization of Region/BU financial templates e.g, Bench marking, VDT, Capex and other offline templates as and when required by BU.

• Concentrate Forecasting / Shipments

• Independently manage the SAP upload of 52-weeks concentrate bottlers forecast in close coordination with the franchise team.
• Keep track of forecast accuracy on monthly basis and communicate to franchise/ Hattar team.
• Circulate the weekly status of concentrate shipments to GM/Franchise Team with analysis vs Forecast/plan numbers.
• Prepare monthly Days in Inventory - DII of all bottlers.

Qualifications:

• Commerce Graduate + CMA / ACCA
• Exposure to Oracle/ ERP Hyperion HFM
• Business Fundamentals

• Relevant Work Experience of 7-8 years

• Financial Planning & Forecasting
• Financial Reporting
• Business Risk Assessment and Management
• Acting with Integrity
• Collaborating & Influencing
• Driving for Results
• Decision Making
• Innovating