Abdulrahman Alaa Email & Phone Number

6Th Of October, Al Jizah, Egypt

Received multiple awards including the 2023 Champion Award for Employee of the Year, Outstanding Performance Recognition in September 2021, and Best Employee for Q3 2021 and Q4 2020.•Lead and manage the preparation of the Annual Operating Plan (AOP), rolling forecasts, and strategic plans to align with business unit strategic financial objectives.•Prepare weekly best estimates for month-end closing, incorporating changes in sales, COGS, and macroeconomic factors, and report findings to senior management.•Manage working capital by providing regular cash projections in collaboration with the treasury team and other stakeholders.•Report insights on business unit profitability, variance analysis, SKU profitability, sales channel profitability, distribution center profitability, and OPEX analysis to senior management.•Lead monthly performance reviews with department managers and senior management to present and discuss the business unit's financial and operational performance.•Conduct regular scenario analysis ("what if" assessments) to provide insights on business risks and opportunities.•Ensure the efficiency and accuracy of month-end and year-end financial closing activities in collaboration with finance stakeholders.•Analyze and approve the feasibility of new product launches to ensure alignment with business unit financial objectives.•Review and approve weekly trade promotions (tactical discounts) to ensure alignment with the approved budget.•Review and approve monthly loyalty program disbursements to ensure alignment with the budget.•Review and approve monthly credit limits for sales force and agents in accordance with business unit credit policy.•Review and approve export orders to ensure they meet targeted profit margins and maintain overall profitability.•Review and approve contracts for organized trade channels and new agents to ensure alignment with budget and business unit policy.

Cairo, Egypt

Received a Certificate of Achievement for 2019 Performance.•Prepare Business Plans, including Income Statements, Balance Sheets, and Cash Flow Statements for two business units: ASC (Sugar Beet Manufacturing) and AUCR (20,000 Feddan of reclaimed land in Menya for planting beet and other crops).•Develop the Quarterly Business Review (QBR), including the analysis of historical figures and reforecasting for upcoming periods based on new assumptions and environmental changes.•Create the monthly performance package, providing a full analysis of activity profitability per SKU compared to budget and previous year.•Manage the preparation of the monthly sign-off package for month-end closing.•Conduct monthly manufacturing overhead (MOH) variance analysis, comparing against budget and previous year, and engage with management to address operational efficiency.•Perform monthly Bill of Materials (BOM) analysis to identify variances against budget standards, including price, quantity, and mix variances.•Update the monthly cost allocation model based on harvested Feddans to allocate costs to planted crops.•Prepare monthly performance packs for the agro company (AUCR), analyzing profitability per crop and Feddan.•Generate monthly energy consumption reports (Electricity, Diesel, Natural Gas, Water) for each business unit.•Produce weekly and monthly sales analysis reports by segment, including sales channel, customer group, and SKU profitability.•Prepare the monthly operating expenses report by cost center for MOH, G&A, and S&D, and conduct monthly meetings with stakeholders to discuss results versus budget and last year.•Develop quarterly Board of Directors (BoD) presentation materials, including data, visuals, and comments.•Create End-of-Season slides with an infographic summarizing the season.

El-Sheikh Zayed, Giza - Egypt

•Prepare a 5-year Business Plan, including Income Statements, Balance Sheets, and Cash Flow Statements.•Develop the Quarterly Business Review (QBR), analyzing historical figures and reforecasting for upcoming periods based on new assumptions and environmental changes.•Prepare the monthly performance package, delivering a comprehensive analysis of activity profitability per SKU versus budget and previous year, and present findings to management.•Conduct monthly manufacturing overhead (MOH) variance analysis by activity/plant, comparing against budget and previous year, and engage with management to address operational efficiency.•Perform monthly Bill of Materials (BOM) analysis to identify variances against budget standards, including price, quantity, and mix variances.•Generate monthly energy consumption reports (Electricity, Diesel, Natural Gas, Water) for each plant, analyzing consumption and cost per unit produced.•Create weekly and monthly sales analysis reports by segment, including sales channel, customer group, and SKU profitability.•Develop a weekly pricing sensitivity model.•Maintain a daily price tracker for main SKUs to monitor and achieve targeted margins (Cost Plus Method).•Prepare the annual business plan booklet for stakeholders, including infographics for KPIs.•Create the monthly industrial sector dashboard and present flash results to management.•Compile the monthly fleet analysis report on fleet utilization (Tawseel).•Develop and prepare monthly, quarterly, and annual Board of Directors (BoD) packs for Industrial, Commodities Trading, and Logistics divisions.•Produce other ad-hoc reports as requested by management and in response to environmental changes.

6Th October

•Oversee all aspects of budget preparation (monthly, quarterly, and annually), including negotiations with department heads to achieve targeted objectives for Income Statement, Balance Sheet, and Cash Flow Statement.•Develop the Quarterly Business Review (QBR), including the analysis of historical figures and reforecasting for upcoming periods based on new assumptions and environmental changes.•Analyze current and past trends in key performance indicators, including revenue, cost of sales, expenses, and capital expenditures.•Prepare monthly revenue and trade spending reports by category (Milk, Juice, Chilled), distribution channel (local and export), and customer group (Retail, Wholesale, HORECA), comparing against budget and last year, and provide commentary on variances.•Measure financial performance per SKU, comparing against budget and last year, and explain and quantify sources of deviation through variance analysis.•Prepare monthly forecasts for financial statements based on actual figures and related environmental changes.•Generate weekly and monthly sales analysis reports (Sales per SKU vs. Trade Spending) compared to budget and last year (Flash Results).•Collaborate with the commercial team to prepare sales forecasts by calculating CAGR and conducting trend analysis for each SKU across all segments (Volume & Selling Price).•Develop monthly and yearly trade spending plans (Discounts, Trade Support, Replacement & Returns) in coordination with the trade marketing team.•Prepare the monthly Sales & Operations Plan (S&OP) report.•Manage the preparation of the group cash flow on a monthly basis, including actuals and forecasts.

Maadi, Cairo

Sixth Horizon

-Handling all Vodafone dealers and salespersons inquiries over the phone.-Handling mailbox requests as a business supporter.*Ranked number one of my area "Dealer Contact Center" from April 2014 to July 2014.

Master Of Business Administration - Mba, Finance, General

Bachelor'S Degree, Accounting And Finance, Good