Ahmed Mohamed Samir Elgharabawy, CMA

Decision Support General Manager at Telecom Egypt

• Egypt - Cairo
• My current job since February 2017

Decision Support Manager at Telecom Egypt

• Egypt - Cairo
• April 2010 to January 2017

 Preparing valuations studies to Telecom Egypt Group investments on a monthly, quarterly and annually basis using Discount Cash Flow Model (DCF), P/E Multiplier & P/EBITDA Multiplier.
 Valuation of Telecom Egypt overall portfolio on an annually basis.
 Exploring and preparing the feasibility studies for new investment opportunities and internal projects and highlights weaknesses and risks to mitigate.
 Making Projections using Assumption Method and Trend Method as well.
 Member of Product & Pricing Subcommittee in Telecom Egypt; Evaluating the profitability of Telecom Egypt new products and services and agreements with MNO’s, ISP’s and International customers and preparing the required feasibility studies.
 Compute Telecom Egypt WACC on a quarterly and annually basis.
 Develops procedures and guidelines for business plans in coordination with Financial Planning department and investment committees, analysis and evaluation of cost-benefit obtained in business plans and projects.
 Liaises with divisions to ensure that their needs and expectations are met.
 Presents or assists direct in the presentation of Finance point-of-view for the business cases at the investment committees.
 Develops recommendations on corporate Finance implementation.
 Act as a TE Representative in the General Meetings of TE Group investments (e.g. Vodafone Egypt).
 Oversee of the development of capital structure guidelines.
 Develops guidelines for measurement of financial performance against standard benchmarks.

Senior Specialist Financial Planning and Variance Analysis at STC - Saudi Telecommunication Company

• Saudi Arabia - Riyadh
• October 2011 to April 2013

 Analyze current and past trends in KPIs including all areas of revenue, cost of sales, OpEx and Capex.
 Monitor KPIs, highlighting trends and analyzing causes of unexpected variance.
 Participate and oversee the continued development of 3 years Financial Plan and Forecasting for STC KSA at BU level, and selecting the appropriate and applicable drivers that derive the best forecast.
 Prepare of 3 years Financial Plan and Budget Reforecast (3+9, 6+6, 5+7 & 9+3) manually and on Hyperion Essbase after the system has gone live.
 Evaluate the company using Discount Cash Flow Model.
 Responsible for annual Budget distribution on all Business Units on quarterly basis for the purpose of Segment Reporting.
 Prepare the Annual and Quarter BU’s Income Statement by allocating Function Unit costs for the purpose of Segment Reporting.
 Quarterly and Monthly Financial and Variance reports.
 Implement and work with a Business Intelligence Tool and Dashboard reports.
 Develop financial and analysis models to support strategic initiatives.
 Analyze complex financial information and reports to provide accurate and timely financial recommendations to management for decision making purposes.
 Supporting Senior Management Team and Departments heads with in-depth analysis.
 Prepare presentations to Board of Directors and Senior Management Team.
 Participate in implementing Financial Planning Hyperion Essbase Program starting from preparing the CSD till the testing phase and Go Live.
 Ad-Hoc Reporting and Analysis.

Senior Financial Analyst at Telecom Egypt

• Egypt - Cairo
• May 2009 to March 2010

 Preparing ongoing financial analysis of the financial statements of Telecom Egypt Group investments (Subsidiaries, Affiliates & Others), and making reports to the Top Management on a quarterly basis.
 Creating and presenting detailed pre-analysis and post-analysis reports which include portfolio risk decomposition, transaction cost analysis and portfolio performance reporting.
 Following up the monthly performance of Telecom Egypt Group investments (Revenues, COGS, S, G&A, CAPEX & ARPU), and making a presentation on it to the Top Management showing the trend of its Margins (Gross Profit, EBIT, EBITDA, NPAT) and the Financial Ratios as well.
 Identify and analyze any variances from the budget presented by the management of the investment companies.
 Making inquiries to be presented in the annual GAM of the companies by the General Manager.
 Preparing any required memos related to our investments by both Arabic and English language.
 Creating a Financial analysis model, Has a well classified financial statements spreading, Summaries of financial statements, Percentage changes, new Financial ratios, Free Cash Flow to Firm & Equity and Economic Value Added (EVA).
 Creating a Forecasting model using Time Series Analysis (Exponential smoothing technique, Holt-Winters Additive Method).

Senior Accountant at Telecom Egypt

• Egypt - Cairo
• January 2005 to April 2009

 Responsible for reviewing and posting all entries to the General Ledger of the Oracle system on a daily basis.
 Responsible for adjusting all the incoming invoices concerning the foreign contracts on Oracle system.
 Participating in preparing the financial statements of Telecom Egypt by Egyptian GAAP.
 Participating in IFRS Telecom Egypt working group in preparing the financial statements by the international standards since2005 up to 2009 specialized in Leases and Investments and helping in other fields.
 Participating in developing Oracle system in conjunction with the information technology team for any unforeseen practical needs or problems has discovered.
 Providing expertise and problem solving to the team on a daily basis for the accounting functions.
 Ensure all accounting policies and adequate internal controls are in place and monitored.
 Monitor bank transactions and perform bank reconciliation on a regular basis between the general ledger’s bank accounts and the bank statement received on a regular basis, identify and review all transactions impacting the bank accounts (for one year period).
 Participating in preparing the annual budget of Telecom Egypt in conjunction with the Financial Planning team.

Accountant at Telecom Egypt

• Egypt - Cairo
• June 2002 to December 2004

 Preparing and recording on Oracle system all entries related to L/Cs & Current account among financial departments.
 Preparing and recording on Oracle system all entries related to Fixed Assets & its Depreciation.
 Monitoring the Inventory Account (6 months) and making the entries related to it.
 Working on Oracle Application system.

Senior Accountant at REGWA Co.

• Egypt - Cairo
• September 1998 to July 2002

 Working on A/P, A/R& Sub-contractors.
 Participating in preparing the monthly trial balance and the annual financial statements.
 Monitor bank transactions and perform bank reconciliation on a regular basis between the general ledger’s bank accounts and the bank statement.
 Financial & Administrative Manager of REGWA co. Nairobi-Kenya branch since2001 up to 2002(Financial Affairs, Payrolls, Purchasing & relation with suppliers, Warehouse monitoring and Administrative issues).