Ahmed Attia, Finance Business Partner

Ahmed Attia

Finance Business Partner

The Coca Cola Company

Location
Egypt - Cairo
Education
Bachelor's degree, Accounting
Experience
6 years, 2 Months

Share My Profile

Block User


Work Experience

Total years of experience :6 years, 2 Months

Finance Business Partner at The Coca Cola Company
  • Egypt - Cairo
  • My current job since April 2021

• Support different functions across the Africa Operating Unit by providing financial modeling and insights relevant to their key initiatives
• Provide key metrics and KPIs across different projects based on multiple scenarios in order to facilitate investment decisions
• Delivered key financial modeling and output as finance lead for VTM acceleration in conjunction with the Operations team and our bottling partners
• Supplied financial support towards the Hydration category value chain optimization across several bottlers in the OU, turning several SKUs from losing to profitable
• Delivered on providing Africa-wide discounts and marketing figures for the 2023 Annual Business Planning process in conjunction with the operations and marketing teams
• Worked on creating a standardized innovation business case template that has been successfully implemented across the Operating Unit
• Revamped the innovation finance process by ensuring monthly protocols are in place for approval meetings for finance decisions
• Provided financial support during the Long Range Plan process to assist the forecasting and planning for Operations, Innovation, O2O, and Supply Chain
• Worked with legal and tax teams to draft a contract for VTM acceleration for use in current acceleration as well as future acceleration initiatives
• Assisted the O2O team in creating and developing a financial model for their multiple platforms

Financial Planning Analyst at The Coca Cola Company
  • Egypt - Cairo
  • January 2019 to March 2021

• Oversee budget planning, changes, and use for both marketing, commercial, and PR projects. This includes marketing campaigns, promotions, bottler support, donations etc.
• Part of one of the first teams globally to completely implement use of the System Economics Tool which records and displays full P&Ls/Value Chains of both us and our bottling partners with detail.
• Provides analyses for performance versus business plans/rolling estimates while highlighting variances and providing narratives for said variances.
• In charge of calculating and posting entry for revenue recognition, rebate calculation, as well as accruals for both marketing, supply chain, and commercial projects.
• In charge of submitting business plans & rolling estimates onto PMR Hyperion.
• Prepared the volume reconciliations for our volume versus our bottling partner for Egypt, Libya, and Sudan.
• Mediated transactions between company and bottler to facilitate operations and reduce AR balance.
• Prepared and posted amortization as well as reviewed reconciliation for coolers programs in accordance with information provided by bottler.

Accountant at The Coca Cola Company
  • Egypt - Cairo
  • March 2018 to December 2018

• Oversee purchasing cycle, responsible for recording withholding tax information after three-way matching invoice with PO and GR.
• Responsibility over withholding tax organization and submission to tax authority
• Responsibility over reconciling and reviewing certain OPEX accounts on SAP
• Organized and submitted accruals for utilities and open POs monthly
• Prepared and reviewed bank reconciliation and local payments to ensure full bank account fully matched system data
• In charge of petty cash distribution and reconciliation
• Handled the creation of Form 41 every quarter and the accompanying withholding tax-related responsibilities

Education

Bachelor's degree, Accounting
  • at The American University In Cairo
  • June 2017

Specialties & Skills

Business Intelligence Tools
Hyperion Planning
Microsoft Excel
Value Chain Analysis
Financial Analysis
MICROSOFT EXCEL
MICROSOFT OFFICE
Power BI
Financial Analysis
ACCOUNTANCY
Hyperion
Value Chains

Languages

Arabic
Expert
English
Expert
French
Expert