Ayman Ramzy - CMA - AFM, FP&A Manager

Ayman Ramzy - CMA - AFM

FP&A Manager

Geidea Solution

Location
Saudi Arabia - Riyadh
Education
Master's degree, Finance
Experience
14 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 10 Months

FP&A Manager at Geidea Solution
  • Saudi Arabia - Riyadh
  • My current job since October 2019
Financial analyst at Al-Tijaria Real Estate Co.
  • Kuwait - Al Kuwait
  • September 2017 to October 2019

A: Managerial reports:-

• Preparing Quarterly Board Reports that outline the company’s performance, ratio analysis, and trends.

B: Budgeting and forecasting:-

• Reviewing and coordinating with the relevant departments for the preparation of the budget.
• Reporting on a monthly basis the variances between the actual performance and the budget.
• Periodic maintenance of rolling forecast model (Consolidated and Stand-alone).

C: Cash Management:-

• Find sources of funding to meet the needs of the company.
• Prepare the facility position report.
• Prepare the monthly, quarterly, and annually cash flows projection for the company’s future plans.
• Ensure the optimal utilization of the available cash balances in coordination with all relevant departments.
• Preparation of monthly, quarterly, and annually YTD variance cash flows report.
• Report and publish the Daily Cash Statement for the Top Management.

D: Financial modeling / Ad hoc reports:-

• Ensure the optimal utilization of the company assets to be in line with strategic ROA (Optimal profitability).
• Monthly Investment performance report.
• Weekly reviewing property department performance.

Financial Analyst - Budgeting at Al Rai Media Group (BoodaiCorp)
  • Kuwait - Al Kuwait
  • March 2013 to September 2017

Key Functions:
Planning & Budgeting - Financial Modeling - Departmental performance evaluation - Reporting & Forecasting - SME project management - Revenue & Expense analysis - Investment planning - Bank reconciliations - Auditing requirements - Capital Expenditure Tracking (CAPEX).

Using my expertise in:-

A: Financial modeling and Planning, by provide Ad-hoc financial analysis to support business objectives through:-

• Create automatic new KPI’s financial models for all subsidiaries monthly selection Act. Vs. Bud. Or LYR.
• Create accounting system linked with reporting system for Alsouq activity (new project).
• Consolidate all subsidiaries operating budget excels in one.
• Prepare advance 3 year business plan based on management & HoD assumptions.
• Develop MIS reports by linking actual extraction with budget excel & KPI’s graphs for presentations automatically.
• Acting as database & financial administrator for the new ERP software implementation.

B: Budgeting and forecast:-

• Involved in the annual budget preparation, and monitor throughout the year.
• Identify emerging trends to the market in order to revise Budget.
• Periodic maintenance of rolling forecast model (Consolidated and Divisional).
• Prepare Cash flow projection for the coming year (Direct method).

C: Financial analysis and reporting:-

• Prepare KPI’s and maintain it for the purpose of departmental performance evaluation (Act. Vs. Budget).
• Develop integrated revenue/expense analysis, projections, reports, and presentation.
• Support decision making by graphs and ratio analysis by activity on a weekly basis.
• Costing analysis, Revenue share (intercompany) analysis allocation based on subsidiaries agreements.
• Perform complex analytical activities as per request. (Ad hoc reports).
• Prepare monthly consolidation and executive financial package (MIS) (Act. Vs. Budget).
• Support investment decisions by what if scenarios and capital budgets for any upcoming investment.
• Acting as a financial manager to one of our subsidiaries for Alsouq Magazine.

SAP FICO Consultant at Samsung Electronics
  • Egypt - Cairo
  • January 2013 to March 2013

Key Functions: SAP Implementation - Internal audit system - Fixed Assets Management - Analyze business processes.

SAP Implementation:

• Test after training & Preparing Manual on PowerPoint for all Processes on SAP.
• Works closely with the User Subject Matter Experts, user community, other SAP business analysts, SAP development team and other team members on IT projects.
• Designs processes, implementation, and ongoing enhancements for the overall SAP FICO Module.
• Provides training and mentoring to others in the company related to area of expertise
• Defines and implements best business practices, adhering to the business standards for the FICO functional processes
• Translates business requirements into detailed functional specifications, test scripts, and other system documentation while adhering to company standards
• Identifies costs, benefits, risks, and alternatives in proposed system designs and their impact on the integration with other systems and SAP modules
• Performs SAP configuration to support changing and new business needs.
• Troubleshoots application problems and proposes optimal resolutions.
• Supports for monthly and year-end activities.

Senior Accountant at Pepsico international
  • Egypt - Cairo
  • June 2009 to January 2013

Key Functions: A team Player of FSS Department (Financial shared services) for many companies - Fixed Assets Management - Support budgeting department - Support Financial analysis department - CapEx Tracking - Depreciation - SAP Configurable controls - Internal controls - Accruals - Inter-company - KPMG Auditing requirements - Monthly TB w analysis.

Role Description:

A:- Senior Fixed Assets Accountant (Nov 2011 - Jan 2013) (1.5 Years) (Promotion)
• Perform FA closing process (Depreciation, Reconciliation, Analysis, Reports, etc).
• Update master data of FA register based on Acquisition, Transfer, Disposal, Idle & Physical count.
• Review for all FA actual receiving in all locations (Plants & DCs) on SAP.
• Prepare monthly report of AUC statues and send it to Ops team to reply on each item should be FA or still in AUC Account, to be applied on SAP (FA Settlement).
• Reconcile B/W FA Module & GL Module.
• Run monthly depreciation after reviewing the new additions and retirements.
• Testing COSO internal controls Manual & Configurable (check SAP configurations for FI-Co).
• Prepare Analysis, Reports, Cause of change for related B/S accounts.
• Tracking civil work invoices, follow up with supplier & engineers.
• Calculate Construction engineering consulting fees invoices and send it to AP Team.
• Change Fiscal year every year Via T.Code (AJRW).

B:- GL Accountant (June 2010 - Oct 2011) (1.5 Year)
• Inter-company transactions, Analysis & Reconciliations.
• Accrued expenses for all plants & DCs’ transactions, Aging & Track actual invoices.
• Payroll recording entries & reconciliation.
• Record costing monthly adjustments.
• GAAP vs. Local Trial Balance Reconciliations PTD & YTD.
• Prepare external auditor (KPMG) requirements.
• Internal control: Testing related COSO controls (Manual & Configurable).
• Prepare the trial balance report with the analysis, cause of change for all related B/S accounts to submit to finance team.

Education

Master's degree, Finance
  • at Institute of Management Accoutant (CMA)
  • April 2016

Part 1 External Financial Reporting Decisions Planning, Budgeting and Forecasting Performance Management Cost Management Internal Controls Part 2 Financial Statement Analysis Corporate Finance Decision Analysis Risk Management Investment Decisions Professional Ethics

Bachelor's degree, Finance & Accounting
  • at Tanta University
  • May 2009

Specialties & Skills

Fixed Asset Management
Accounting
Financial Analysis
Budgeting
Financial Modeling
MS Office
SAP Analytics
Workflow Analysis
Oracle based applications
Financial Modelling
Budget Control
SAP Implementation

Languages

Arabic
Native Speaker
English
Expert

Memberships

IMA
  • CMA
  • January 2015

Training and Certifications

8th Ranking - Financial Modeling World competition (Certificate)
Date Attended:
December 2018
Train of trainers (TOT) (Training)
Training Institute:
Train of trainers & Presentation skills (TOT)
Date Attended:
September 2015
Duration:
50 hours
Certified Management Accountant (CMA) # 49806 (Certificate)
Date Attended:
April 2016
Valid Until:
January 9999
Communication & Soft skills, Positive thinking (Certificate)
Date Attended:
February 2012
Valid Until:
January 9999
SAP:-G-ERP (SAP) (Training)
Training Institute:
Samsung Electronics
Date Attended:
February 2013
Duration:
100 hours
Investment. (Certificate)
Date Attended:
June 2009
Valid Until:
January 9999
General Accounting (Certificate)
Date Attended:
February 2010
Valid Until:
January 9999
ICDL (Certificate)
Date Attended:
September 2009
Valid Until:
December 2009