M · I
Loading Portfolio...
Mohanad Ibrahim — Senior Finance Executive
Strategic Finance Business Partner Finance Transformation Leader ERP & Analytics Executive AI-Driven Finance Operations
8+
Years
−17%
OPEX
+25pp
Forecast
0
Findings
Executive Finance Transformation Portfolio · 2026

Mohanad Ibrahim

Strategic Finance Business Partner ·
Finance Transformation Leader · ERP & AI-Driven Finance Executive

Senior finance professional with 8+ years driving financial performance, ERP modernization, FP&A leadership, and AI-enabled finance operations across multi-site manufacturing, international trading, and healthcare in Egypt and the UAE. Proven architect of finance transformation programs delivering 17% OPEX reduction, 25% cash flow forecasting precision uplift, 30% data integrity gain, and zero-finding audit outcomes across multiple fiscal years and jurisdictions.

Email acc.mohanadibrahim@gmail.com
Phone +20 100 961 3099
Base Menoufia, Egypt · Open to UAE / KSA / Qatar relocation
LinkedIn linkedin.com/in/acc-mohanad-ibrahim
Financial ControllerFinance ManagerHead of FinanceFP&A Lead
§02 · Executive Summary
The Headline

Executive Summary

A boardroom-ready finance executive bridging technical accounting rigor with digital transformation leadership across two regulatory regimes — UAE and Egypt — and the four highest-demand finance hiring lanes in MENA 2025–2026.

Mohanad Ibrahim is a Strategic Finance Business Partner who converts traditional accounting functions into AI-enabled, ERP-driven decision engines. Eight years of progressive leadership across food processing, international trading, and healthcare — anchored by Odoo ERP transformation, Power BI executive reporting, and zero-finding governance stewardship — position him as a promotion-ready candidate for Financial Controller, Finance Manager, or Head of Finance roles across the GCC.
+8 yrs
Progressive Finance Leadership
Egypt + UAE · multi-currency · multi-jurisdiction · multi-sector experience
−17%
OPEX Reduction Delivered
Granular variance discipline · vendor consolidation · zero service-quality loss
+25 pp
Cash Flow Forecast Accuracy
13-week rolling forecast · reconciliation redesign · proactive WC management
+30%
Data Integrity Gain
Odoo ERP automation · 15+ hrs/week recovered · multi-currency clean
0
Audit Material Findings
Multi-year clean opinions · Big-4-standard documentation · zero violations
38+
Professional Certifications
CMA P1+P2 · IFRS Diploma · ACCA Modeling · Anthropic AI Fluency · ESAA Member
§03 · Positioning
Five Identity Pillars

Executive Positioning Statement

Five reinforcing identities that together form a single boardroom-ready finance executive — not an accountant scaling up, but a transformation leader operating at finance-controller cadence today.

01
Strategic Finance Business Partner
Translates financial data into commercial, operational, and pricing decisions — directly partnering sales, procurement, and the MD office.
02
Finance Transformation Leader
Architect of two ERP rollouts, ten executive dashboards, and an AI automation layer that recovered 8 hrs/week of finance capacity.
03
Executive Decision Support Advisor
Builds the rolling forecasts, variance bridges, and 13-week cash projections that senior leadership uses to set capital allocation cadence.
04
Financial Governance Specialist
Multi-year zero-finding audit stewardship · UAE VAT & CT · ETA · IFRS · EAS · SOX-lite controls · transfer-pricing aware.
05
ERP & Analytics-Driven Executive
Odoo ERP expert (4+ yrs) · Power BI · Looker Studio · SQL Server · PostgreSQL · Anthropic-certified AI fluency.
§04 · Competencies
ATS-Optimized Skill Inventory

Core Competencies Matrix

Six competency clusters mapped to proficiency anchors — every line backed by a quantified achievement elsewhere in this portfolio.

Strategic Finance & FP&A

Decision Support
Financial Planning & Analysis (FP&A)●●●●●
Strategic Budgeting & Forecasting●●●●●
Financial Modeling & Scenario Analysis●●●●○
Variance Analysis & Margin Bridge●●●●●
EBITDA & Margin Management●●●●○
Working Capital Optimization●●●●○
Treasury & Cash Flow Management●●●●○

Financial Controlling & Reporting

Governance
Month-End / Year-End Close●●●●●
Financial Consolidation (Multi-Entity)●●●●○
IFRS / IAS Reporting●●●●●
Egyptian Accounting Standards (EAS)●●●●●
GAAP & Multi-Currency Accounting●●●●○
Internal Controls & SOX-Lite Frameworks●●●●○
External Audit Coordination (Big-4-standard)●●●●●

Tax & Regulatory Compliance

Multi-Jurisdiction
UAE VAT Filing & FTA Compliance●●●●○
UAE Corporate Tax Preparation●●●●○
Egyptian Tax Authority Compliance●●●●●
Multi-Jurisdiction Filing Coordination●●●●○
Transfer Pricing Awareness●●●○○
Regulatory Reporting●●●●○

ERP, Analytics & AI Finance

Digital
Odoo ERP Implementation (4+ yrs Expert)●●●●●
QuickBooks Desktop●●●●○
SAP / Oracle (literacy)●●●○○
Power BI Dashboards & DAX●●●●○
Looker Studio Reporting●●●●○
Microsoft Excel · VBA · Power Query●●●●●
SQL Server & T-SQL · PostgreSQL●●●●○
AI-Powered Finance Automation (Claude)●●●●○

Leadership & Stakeholder Management

Strategy
Team Development & Mentoring●●●●○
Cross-Functional Business Partnering●●●●●
Executive / Board-Level Reporting●●●●○
Stakeholder Communication●●●●○
Process Re-Engineering & Change Management●●●●○
Audit Committee Readiness●●●●○

Industry & Sector Coverage

Vertical
Food Processing & Manufacturing●●●●●
International Trading (Multi-Currency)●●●●○
Healthcare Billing & Insurance Claims●●●●○
Cost Accounting (ABC, Standard, Job)●●●●○
Construction Accounting●●●○○
Fixed Asset Lifecycle Management●●●●○

LEGEND · ●●●●● Expert · ●●●●○ Advanced · ●●●○○ Proficient

§05 · Technical & ERP
Tech Stack

Technical Skills & ERP Expertise

A digital-finance toolkit organized by stakeholder use case — from transactional ERP backbone to executive-grade visualization to next-generation AI automation.

ERP Systems

Odoo ERP (4+ yrs · Expert · Porta People certified) — finance, AP/AR, inventory, multi-currency · custom dashboard development with PostgreSQL backend.

QuickBooks Desktop · SAP & Oracle literacy · ERP migration playbooks · chart of accounts redesign aligned to IFRS & UAE FTA.

Analytics & BI

Power BI — DAX measure authoring · star schema modeling · 10+ executive dashboards · MindLuster certified.

Looker Studio · single-page KPI dashboards · scheduled distribution.

Excel Advanced · VBA automation · PivotTables · Power Query · Edraak 6-course specialization.

Databases & SQL

Microsoft SQL Server & T-SQL — Edraak / Arab Bank 4-course Specialization · custom queries for Power BI extracts.

PostgreSQL · Linux server administration · custom Odoo report development.

AI & Automation

Anthropic AI Fluency · Claude Code in Action · Claude 101 — certified by Anthropic for production-grade prompt engineering and finance automation.

One Million Prompters (Dubai Future Foundation) · ChatGPT for Management Accounting · AI Automation Kickstart · AI in Accounting (Oxford).

Standards & Compliance

IFRS Diploma (Nabraas) · IAS · GAAP · Egyptian Accounting Standards · UAE Federal Tax Authority compliance · Egyptian Tax Authority filings.

Internal Auditing CPD-certified (Alison) · audit committee readiness · SOX-lite control frameworks.

Specialized Finance

CMA Part 1 coursework — Preparing External Financial Reports (Edraak).

CMA Part 2 Aligned — Strategic Financial Management (MindLuster).

Advanced Financial Modeling (ACCA, 2024) · Cost Accounting · Construction Accounting · Business Plan & Financial Feasibility Study.

إضافة رسوم بيانية احترافية، جداول تحليلية، ولوحات معلومات تفاعلية شاملة لتمثيل وتحليل الأداء المالي الكامل بصورة تنفيذية حديثة.
§06 · Experience
Eight Years · Five Engagements

Executive Experience

Each role rewritten using the formula: Action Verb + Business Scope + Method + Technology / Tools + Quantified Impact + Strategic Outcome. Zero generic responsibilities.

General Accountant — Acting Senior Finance Lead
Abohashem for Meat — Food Processing & Distribution · Obour, Qalyubia, Egypt
Jan 2024 – Present
🏆 Top Performer Award · Abohashem for Meat · October 2024 — for exceeding all FY2024 financial targets and delivering measurable operational improvements across the finance function.
Accountant — International Finance Operations
Legend Vision L.L.C — International Trading · Dubai, UAE
Oct 2021 – Dec 2023
Accountant
Abohashem for Meat — Food Processing · Menoufia, Egypt
Apr 2019 – Sep 2021
Accountant — Healthcare Finance
El Sherouk Medical Services — Healthcare · Menoufia, Egypt
Apr 2018 – Mar 2019
Accountant (Contract)
El Karnak · Cairo, Egypt
Jan 2018 – Mar 2018
§07 · Achievements
Quantified Outcomes

Executive Achievements

The numbers a hiring manager reads first — every figure traceable to a specific engagement and verifiable through references.

−17%
Operating Cost Reduction
Legend Vision · Dubai · variance-led
+25pp
Cash Flow Forecast Accuracy
Abohashem · 13-week rolling
+30%
Data Integrity Uplift
Odoo automation · multi-currency
+20%
Decision Support Quality
10+ Power BI dashboards
−20%
AP Cycle Compression
Approval workflow redesign
+18%
Collection Rate Lift
El Sherouk · 15+ insurers
+15%
Team Productivity Gain
3-person team · structured mentoring
0
Audit Findings · Multi-Year
Big-4-standard · clean opinions
🏆 Top Performer Award · Abohashem for Meat · October 2024 — awarded for exceeding all FY2024 financial targets and delivering measurable operational improvements across the finance function.
§08 · Transformation Portfolio
Six Pillars · One Operating Model

Finance Transformation Portfolio

Six pillars that together define a modern finance operating model — moving from manual, reactive accounting to AI-augmented, predictive, decision-engine finance.

I · ERP Modernization

Manual ledgers → Odoo ERP + Power BI executive layer · automated bank reconciliation · 3-tier AP approval workflow · multi-currency engine · IFRS-aligned chart of accounts.

+25% data accuracy · −30% manual time

II · FP&A Redesign

Static annual budgets → rolling forecasts · 13-week cash projections · scenario modeling · margin-bridge waterfalls · price/volume/mix variance decomposition.

+25 pp forecast accuracy

III · KPI & Decision Support

Monthly PDFs → 10+ live Power BI dashboards · MD-level scorecards · drill-through navigation · RAG flagging · bilingual Arabic insight layer.

+20% decision quality

IV · AI-Driven Automation

Manual reporting → Claude + custom Python scripts · variance commentary · AR follow-up letters · monthly close memos · reconciliation anomaly detection.

8 hrs/week recovered

V · Audit-Ready Governance

Reactive prep → SOX-lite framework · standardized audit documentation · UAE FTA + ETA compliance · transfer pricing awareness · multi-year clean opinions.

0 material findings · multi-year

VI · Team & Stakeholder Leadership

3 direct reports · structured KPI scorecards · cross-functional partnership with sales, procurement, operations · MD-office advisory cadence.

+15% team productivity

§09 · ERP Cases
Case Studies · ERP Transformation

ERP Transformation Case Studies

Each case follows the McKinsey-grade structure: Problem → Analysis → Solution → Implementation → KPI Impact → Strategic Business Outcome.

Case Study · ERP-01
Odoo ERP Multi-Currency Transformation @ Legend Vision L.L.C.
Dubai · Trading
🔴 Problem

Disconnected manual workflows across AP/AR/GL/inventory · 3-currency complexity (AED/EGP/USD) · 25%+ data error rate · 2-day reconciliation backlog · cross-jurisdiction audit exposure (UAE FTA + Egyptian Tax Authority).

📊 Analysis

Process mining surfaced 11 redundant manual touch-points · 40% of journal entries required correction within 7 days · multi-currency conversions performed in spreadsheets, creating reconciliation noise and audit findings risk.

💡 Solution

Phased Odoo ERP automation: (i) Chart of accounts redesign aligned to IFRS + UAE FTA · (ii) Multi-currency engine activation · (iii) Automated bank feed reconciliation · (iv) AP 3-tier approval workflow · (v) End-user training program.

⚙️ Implementation

Months 1–2: COA & multi-currency · Months 3–4: AP/AR automation · Months 5–6: Bank reconciliation · Month 7: Training + go-live · Month 8+: Hyper-care & continuous improvement.

📈 KPI Impact

Data accuracy: +25 pp · Manual processing time: −30% · AP cycle: −20% · Audit findings: 0 · VAT/CT violations: 0 across 2 fiscal years · ~15 hrs/wk capacity recovered.

🎯 Strategic Outcome

Eliminated penalty-risk exposure · enabled the 17% OPEX reduction through visibility · positioned the finance function as a strategic business partner · clean audit opinions every cycle.

+25 ppData Accuracy
−30%Manual Time
−20%AP Cycle
0Audit Findings
Case Study · ERP-02
Power BI Executive Layer @ Abohashem for Meat
Egypt · Food Processing
🔴 Problem

MD relied on monthly PDFs delivered T+15 · zero live profitability or cash visibility · cash flow forecast accuracy ~75% · finance function operating reactively, not predictively · no SKU-level decision support.

📊 Analysis

Data audit revealed Odoo GL contained the answers but lacked a presentation layer · KPIs were calculated manually in Excel each month · MD's decision cadence lagged the financial reality by 15+ days.

💡 Solution

Designed and deployed a 10-dashboard Power BI executive layer connected directly to Odoo via SQL/PostgreSQL · standardized DAX measure library · Arabic RTL insight boxes · weekly auto-refresh · drill-through to GL detail.

⚙️ Implementation

Week 1–2: Star schema data model · Week 3–4: KPI catalog & DAX library · Week 5–6: Dashboard build & design system · Week 7: UAT with MD office · Week 8: Go-live + training + adoption support.

📈 KPI Impact

Decision-support quality: +20% · Cash flow forecasting accuracy: 75% → 100% (+25 pp) · Close cycle: T+15 → T+5 · 10+ live executive dashboards · MD review cadence weekly (was monthly).

🎯 Strategic Outcome

MD now leads weekly financial reviews from a live dashboard · proactive working capital interventions · reduced reliance on emergency funding · finance promoted from cost-center to decision-engine.

10+Dashboards
+20%Decision Quality
T+5Close Cycle
+25 ppForecast Accuracy
§10 · Performance Cases
Case Studies · Performance Optimization

Financial Performance Optimization

Three engagements where direct financial-performance levers — OPEX, working capital, and collections — produced measurable, defensible business impact.

Case Study · PERF-01
Operating Cost Optimization Program @ Legend Vision L.L.C.
Dubai · Trading
🔴 Problem

OPEX growing faster than revenue · operating margin under compression · zero category-level visibility into cost drivers · vendor concentration risk in 2 high-spend categories.

📊 Analysis

Granular variance and category review identified 4 expense families with structural inefficiency · vendor count fragmented · no PO-matching controls · early-payment discounts left on table.

💡 Solution

Re-tendered top-spend categories · consolidated vendors · introduced PO-matching controls in Odoo · early-payment discount protocol · monthly cost-review cadence with operations leadership.

⚙️ Implementation

Q1: Vendor mapping & spend baseline · Q2: Re-tender + consolidation · Q3: Control deployment in Odoo · Q4: Cadence rollout + early-payment discount activation.

📈 KPI Impact

OPEX: −17% with no service-quality degradation · Vendor count: −35% · PO-matching coverage: 100% · AP cycle: −20%.

🎯 Strategic Outcome

Operating margin and EBITDA contribution lifted directly · stronger vendor terms · predictable cash outflows · finance positioned as commercial-leverage partner.

−17%OPEX
−35%Vendor Count
−20%AP Cycle
100%PO Match
Case Study · PERF-02
Working Capital & Cash Flow Forecasting Turnaround @ Abohashem
Egypt · Food Processing
🔴 Problem

Cash flow forecasting accuracy ~75% · frequent reliance on emergency credit facilities · CCC elevated · reconciliation backlog across banking, AR, and AP sub-ledgers.

📊 Analysis

Reconciliation gap analysis · sub-ledger ↔ GL mismatch traced to four root causes · cash conversion cycle decomposition revealed DSO drift in two customer segments.

💡 Solution

Re-engineered multi-step reconciliation workflows · 13-week rolling cash forecast model · automated bank feed integration · weekly cash council with operations and sales.

⚙️ Implementation

Month 1: Process redesign · Month 2: Forecast model build · Month 3: Bank feed integration · Month 4+: Weekly cash council cadence.

📈 KPI Impact

Forecast accuracy: 75% → 100% (+25 pp) · CCC: −11 days YoY · Emergency credit drawdowns: eliminated · WC unlocked: ~EGP 8.2M (illustrative).

🎯 Strategic Outcome

Funded inventory build for peak season from operating cash · improved supplier negotiating position · MD office gained predictive cash visibility for the first time.

+25 ppForecast Accuracy
−11 dCCC
0Emergency Drawdowns
EGP 8M+WC Unlocked
Case Study · PERF-03
Insurance Collections Turnaround @ El Sherouk Medical
Egypt · Healthcare
🔴 Problem

Collection rate from 15+ insurance providers dragging cash position · DSO elevated · ad-hoc follow-up · claim rejection rate high due to documentation gaps.

📊 Analysis

AR aging analysis revealed concentration in 90+ day bucket · zero systematic follow-up cadence · documentation pack lacked standardization across insurers.

💡 Solution

Designed 3-tier follow-up protocol (T+30 / T+60 / T+90 escalation) · standardized claim documentation pack · weekly insurance-by-insurance dashboard · escalation pathway to legal.

⚙️ Implementation

Month 1: Protocol design · Month 2: Documentation standard rollout · Month 3: Dashboard + cadence · ongoing: weekly review.

📈 KPI Impact

Collection rate: +18% · DSO: meaningful compression · 90+ AR bucket: declined steadily · claim rejection rate: reduced.

🎯 Strategic Outcome

Cash position improved · reduced reliance on credit · improved provider relationships · finance function recognized as a strategic enabler of clinical operations.

+18%Collection Rate
15+Insurers
−25%Billing Errors
3-tierFollow-up Protocol
§11 · AI Finance Automation
Anthropic-Certified · Production-Grade

AI Finance Automation Use Cases

Four production-grade AI-assisted finance workflows built on Anthropic AI Fluency, Claude Code in Action, and the One Million Prompters Initiative (Dubai Future Foundation) credentials. Aggregate impact: ~8 hours/week recovered finance capacity.

AI Variance Commentary

Workflow: Power BI variance numbers → Claude prompt with CoA context → narrative commentary in Arabic + English.

Time: 3 hrs/month → 20 min review.

~2.5 hrs/month recovered

AR Follow-Up Letters

Workflow: Aging report → Claude prompt with customer history → personalized bilingual reminder letter, legal-aware tone graduated by aging bucket.

Time: 1.5 hrs/week → 15 min review.

~5 hrs/month recovered

Monthly Close Memos

Workflow: Close package → structured Claude prompt → executive memo with variance highlights, risks, and proposed actions for the MD.

Time: 2 hrs/month → 25 min.

~1.5 hrs/month recovered

Bank Reconciliation Anomaly

Workflow: Bank statements + GL → Python script with rule-based + LLM-assisted anomaly flagging → review-only exceptions queue.

Time: 8 hrs/month → review only.

~6 hrs/month recovered

Aggregate AI impact: ~8 hours of finance capacity recovered every week — redirected from reactive reporting to strategic advisory for the Managing Director. The AI layer is not a productivity tool; it is the difference between an accountant and a finance executive.
§12 · KPI Framework
Ten Executive Dashboards

KPI Dashboard Framework

A ten-dashboard executive analytics framework — every dashboard with a defined audience, KPI catalog, refresh frequency, and decision use-case.

1 · EBITDA Dashboard

KPIs: EBITDA, EBITDA Margin %, EBITDA Growth %, EBITDA Bridge.
Audience: MD / Board · Refresh: Monthly.
Use: Operating leverage assessment, scenario planning.

2 · Budget vs Actual Dashboard

KPIs: Variance EGP, Variance %, RAG flags, Top-10 variance lines.
Audience: Department heads · Refresh: Monthly.
Use: Accountability cadence, course correction.

3 · Treasury Dashboard

KPIs: Cash balance, available facilities, FX exposure, debt service coverage.
Audience: CFO / MD · Refresh: Daily.
Use: Liquidity management, hedging decisions.

4 · Working Capital Dashboard

KPIs: DSO, DPO, DIO, Cash Conversion Cycle, NWC days.
Audience: Controller / Operations · Refresh: Weekly.
Use: WC optimization, inventory and credit decisions.

5 · Cash Flow Dashboard

KPIs: Operating CF, Investing CF, Financing CF, Free Cash Flow, 13-week forecast.
Audience: CFO / Treasury · Refresh: Weekly.
Use: Self-funding capacity assessment.

6 · AR / AP Aging Dashboard

KPIs: Aging buckets (0–30 / 31–60 / 61–90 / 90+), top overdue customers/suppliers.
Audience: AR/AP leads · Refresh: Daily.
Use: Collection escalation, payment prioritization.

7 · Margin Analysis Dashboard

KPIs: Gross Margin %, Operating Margin %, Margin Bridge (Price/Volume/Mix/Cost).
Audience: Commercial / Finance · Refresh: Monthly.
Use: Pricing decisions, product portfolio strategy.

8 · Forecast Accuracy Dashboard

KPIs: Forecast vs Actual %, MAPE, bias, hit-rate by category.
Audience: FP&A · Refresh: Monthly.
Use: Forecast model calibration.

9 · Profitability Dashboard

KPIs: SKU-level contribution margin, customer profitability, channel margin.
Audience: Commercial / Finance · Refresh: Monthly.
Use: SKU rationalization, customer-mix shift.

Master Dashboard
10 · Executive KPI Scorecard (One-Page MD View)
Board · Live
Top Row · KPI Cards (5)

Total Revenue (vs PY %) · Gross Margin % (vs Budget RAG) · EBITDA (EGP + %) · Net Profit (vs Target) · Cash Balance (+ 30-day forecast).

Mid Row · Primary Charts (3)

Monthly Revenue Trend (line · 12 months · budget overlay) · Cost Breakdown (stacked bar · Materials/Labor/Overhead) · Margin Bridge (waterfall · Price/Volume/Mix/Cost).

Lower Row · Secondary (3)

SKU Profitability (horizontal bar · sorted by margin) · Cash Flow Waterfall (Op/Inv/Fin) · Financial Ratios Table (Actual vs Benchmark · 12 ratios with RAG flags).

§13 · Power BI Architecture
Star Schema · DAX · Drill-Through

Power BI & Analytics Architecture

Enterprise-grade analytics architecture — from data ingestion to executive distribution — built for governed financial reporting at GCC scale.

01
Data Ingestion
02
Transformation
03
Modeling & DAX
04
Distribution

Data Model · Star Schema

Fact Tables

  • FactGL — DateKey, ProductKey, CostCenterKey, CustomerKey, AccountCode, TxnType, Amount_EGP, Quantity
  • FactBudget — DateKey, AccountKey, BudgetAmount, BudgetQuantity, Scenario
  • FactCashFlow — DateKey, CashFlowType, Amount, Activity (Op/Inv/Fin)

Dimension Tables

  • DimCalendar — DateKey, Month, Quarter, Year, FiscalPeriod, MonthName_AR
  • DimProduct — ProductKey, ProductName, Brand, Category, UnitCost, StandardPrice
  • DimCostCenter — CostCenterKey, Name, Department, Manager
  • DimCustomer — CustomerKey, Name, Region, Segment, CreditLimit
  • DimAccount — AccountKey, AccountName, Type, GLCode, IFRS Mapping

Governance Layer

  • Row-Level Security — by Brand, Region, Cost Center, Department
  • Sensitivity Labels — Public, Confidential, Board-Only
  • Audit Trail — query logging · access logs · refresh history
  • Refresh Schedule — incremental · 06:00 daily · on-demand
  • Lineage Tracking — source → bronze → silver → gold

DAX KPI Logic · Production-Ready Measures

-- ═══════════════════════════════════════════════════════════ -- REVENUE FAMILY -- ═══════════════════════════════════════════════════════════ [Total Revenue] = CALCULATE( SUM(FactGL[Amount_EGP]), FactGL[TxnType] = "Revenue" ) [PY Revenue] = CALCULATE( [Total Revenue], SAMEPERIODLASTYEAR(DimCalendar[Date]) ) [Revenue Growth %] = DIVIDE( [Total Revenue] - [PY Revenue], [PY Revenue] ) -- ═══════════════════════════════════════════════════════════ -- PROFITABILITY FAMILY -- ═══════════════════════════════════════════════════════════ [Gross Margin %] = DIVIDE( [Total Revenue] - [COGS], [Total Revenue] ) [EBITDA] = [Operating Profit] + [Depreciation] + [Amortization] [EBITDA Margin %] = DIVIDE( [EBITDA], [Total Revenue] ) -- ═══════════════════════════════════════════════════════════ -- WORKING CAPITAL FAMILY -- ═══════════════════════════════════════════════════════════ [DSO] = DIVIDE( [Avg Receivables] * 365, [Total Revenue] ) [DPO] = DIVIDE( [Avg Payables] * 365, [COGS] ) [DIO] = DIVIDE( 365, [Inventory Turnover] ) [Cash Conversion Cycle] = [DIO] + [DSO] - [DPO] -- ═══════════════════════════════════════════════════════════ -- VARIANCE DECOMPOSITION (Price · Volume · Mix) -- ═══════════════════════════════════════════════════════════ [Price Variance] = SUMX( FactGL, ( FactGL[Amount_EGP] / FactGL[Quantity] - RELATED(DimProduct[StdPrice]) ) * FactGL[Quantity] ) [Volume Variance] = SUMX( FactGL, ( FactGL[Quantity] - CALCULATE(SUM(FactBudget[BudgetQty])) ) * RELATED(DimProduct[StdPrice]) ) -- ═══════════════════════════════════════════════════════════ -- RAG STATUS FLAG (Conditional Formatting Driver) -- ═══════════════════════════════════════════════════════════ [Margin RAG] = SWITCH( TRUE(), [Gross Margin %] >= 0.35, "🟢 Above Target", [Gross Margin %] >= 0.30, "🟡 At Risk", "🔴 Below Target" )

Looker Studio · 1-Page Mirror Layout

Header & Filters

  • Logo · Title (AR) · Date Range filter
  • Brand multi-select (أبو هاشم / الهنا / الكل)
  • Cost Center · Product Category · Region
  • Last Updated timestamp (06:00 Cairo)

Body Visuals

  • Row 2 · 5 KPI scorecards with delta indicators
  • Row 3 · Line + Stacked Bar + Horizontal Bar
  • Row 4 · Waterfall + Multi-line scenario
  • Row 5 · SKU detail table with conditional formatting

Distribution

  • Daily refresh at 06:00 Cairo time
  • Scheduled email PDF delivery to MD & Department Heads
  • Mobile-optimized executive view
  • Aggregated data source for fast load
§14 · Visual Analytics
Nine Visualization Specifications

Executive Visual Analytics

Each visualization specified across four dimensions: Purpose · KPI Used · Executive Insight · Business Interpretation. The discipline that separates a finance dashboard from a data dump.

01
Revenue Trend · 12-Month Line Chart
Line · Multi-Series
Purpose

Track 12-month revenue trajectory vs Budget vs Prior Year on a single canvas.

KPI Used

Total Revenue (EGP M), Revenue Growth %, Budget Attainment %.

Executive Insight

Identifies seasonality, demand peaks, and trough months — drives inventory build cadence.

Business Interpretation

"Q4 surge of +X% above budget signals seasonal strength → inventory build-up plan triggered for FY2026 Q4 starting July."

02
Cost Structure · Stacked Bar
Bar · Stacked Monthly
Purpose

Decompose monthly OPEX into Materials · Labor · Overhead · Other.

KPI Used

Total OPEX, Cost Mix %, Materials-to-Revenue Ratio.

Executive Insight

Pinpoints structural cost drivers and inflation pass-through pressure.

Business Interpretation

"Materials at X% of OPEX → supplier consolidation + long-term contract negotiation prioritized for Q1 FY2026."

03
Margin Bridge · Waterfall
Waterfall · YoY Decomposition
Purpose

Decompose YoY gross margin movement into Price · Volume · Mix · Cost components.

KPI Used

Gross Margin % (start vs end), Component Variances (pp).

Executive Insight

Reveals which lever drove margin gain or loss — critical for next pricing cycle.

Business Interpretation

"Cost-side gain of +X.X pp offset by labor inflation of −Y.Y pp → automation case for next CapEx cycle."

04
EBITDA Trend · Combo Chart
Bar + Line · Dual Axis
Purpose

Track EBITDA EGP value (bars) and EBITDA margin % (line) over 24 months.

KPI Used

EBITDA, EBITDA Margin %, EBITDA Growth %.

Executive Insight

Distinguishes scale effects from operational leverage.

Business Interpretation

"EBITDA up X% but margin flat → growth is volume-led, not efficiency-led → operational leverage program proposed."

05
Cash Flow · Operating / Investing / Financing Waterfall
Waterfall · Activity
Purpose

Visualize cash generation and deployment by activity type.

KPI Used

Net Operating CF, Investing CF, Financing CF, Net Cash Movement.

Executive Insight

Distinguishes self-funded vs externally-funded growth profile.

Business Interpretation

"Operating cash covered all CapEx and debt service → balance-sheet de-risking continues into FY2026."

06
Budget vs Actual · Variance Bar
Horizontal Bar · RAG
Purpose

Compare actuals to budget across major P&L lines with RAG flags.

KPI Used

Variance EGP, Variance %, RAG Status.

Executive Insight

Surfaces accountability hotspots month-over-month.

Business Interpretation

"Marketing line +X% over budget without proportional revenue lift → ROAS audit triggered."

07
Working Capital · CCC Composite
Multi-Line · Days
Purpose

Monitor DSO, DPO, DIO, and Cash Conversion Cycle on a single panel.

KPI Used

DSO, DPO, DIO, CCC (days), NWC days.

Executive Insight

Links operational discipline to cash health.

Business Interpretation

"CCC compressed by Z days YoY → ~EGP X M unlocked working capital → reinvested in inventory build."

08
AR / AP Aging · Heatmap
Stacked Horizontal · Buckets
Purpose

Visualize aged buckets (0–30 / 31–60 / 61–90 / 90+) by customer or supplier.

KPI Used

AR Aging by Bucket, % Past Due, Top-10 Overdue, Concentration %.

Executive Insight

Surfaces collection risk and payment-terms abuse.

Business Interpretation

"X% of AR sits in 90+ bucket concentrated in 3 customers → escalate to legal collection and tighten credit limits."

09
Forecast Accuracy · Hit-Rate Trend
Line · MAPE / Bias
Purpose

Track forecast vs actual accuracy by category and forecast horizon.

KPI Used

Forecast Accuracy %, MAPE, Bias, Category Hit-Rate.

Executive Insight

Identifies systemic forecast bias requiring model recalibration.

Business Interpretation

"Beverage category persistently 12% under-forecast → seasonality model adjustment + safety-stock rule update."

§15 · Live Dashboard
Live HTML Executive Dashboard · Sample View

Executive Dashboard · Sample

A working preview of the executive layer described in §13 — KPI cards · sparklines · primary charts · ratio governance table · Arabic insight overlay. Illustrative dataset for hiring-manager preview.

Revenue YTD
EGP 142.6 M
▲ +12.4% vs PY
Gross Margin
38.4 %
▲ +2.1 pp vs Budget
EBITDA
EGP 24.8 M
▲ +18.2% YoY · 17.4% margin
Net Profit
EGP 14.3 M
▼ −1.2% vs Target
Cash Balance
EGP 18.9 M
▲ 30-day forecast: 21.4M
Revenue Trend · 12M
Line · Actual vs Budget
Insight: Q4 surge above budget signals seasonal demand strength → trigger early inventory build for FY2026 Q4 starting July.
الرؤية: ذروة الإيرادات في ديسمبر بنسبة +X% فوق الميزانية — يُوصى بتخطيط مخزوني مسبق لموسم 2026.
Cost Structure
Stacked · Materials/Labor/OH
Insight: Materials dominate at 62% of OPEX — supplier consolidation and long-term contracts are the highest-leverage action.
الرؤية: المواد الخام 62% من إجمالي التكاليف — أولوية قصوى لإبرام عقود توريد طويلة الأجل.
Margin Bridge
Waterfall · YoY Drivers
Insight: Cost-side gain +3.2 pp partly offset by labor inflation −1.1 pp → automation case for next CapEx cycle.
الرؤية: تحسّن الهامش +3.2 نقطة بفضل خفض المواد، تضخم العمالة استهلك −1.1 نقطة — أتمتة الإنتاج هي المسار القادم.
Cash Flow · Operating / Investing / Financing
Waterfall · FY2025
Insight: Operating cash fully covered investing and financing activities — self-funded growth profile preserved.
الرؤية: التدفق التشغيلي غطى الاستثمارات وخدمة الدين بالكامل — استمرار في تخفيف المخاطر المالية.
Working Capital · CCC Composite
DSO · DPO · DIO · CCC (days)
Insight: CCC compressed −11 days YoY · ~EGP 8.2M working capital unlocked · redirected to peak-season inventory build.
الرؤية: دورة التحويل النقدي ضُغطت 11 يوماً — إفراج عن نحو EGP 8.2M رأس مال عامل.
EBITDA Trend · 24M
Combo · EGP M (bar) + Margin % (line)
Insight: EBITDA growth volume-led, margin flat → operational leverage program needed beyond top-line growth.
AR Aging · Top Customers
Stacked · 0–30 / 31–60 / 61–90 / 90+
Insight: 12% of AR in 90+ bucket concentrated in 3 customers → legal escalation + credit limit review.

Financial Ratios · Actual vs Industry Benchmark

RatioActualBenchmarkTrend YoYStatus
Current Ratio2.18×1.50×▲ +0.22ABOVE
Quick Ratio1.42×1.00×▲ +0.18ABOVE
Cash Ratio0.48×0.30×▲ +0.09ABOVE
Gross Margin %38.4%32.0%▲ +2.1 ppABOVE
EBITDA Margin %17.4%14.5%▲ +1.6 ppABOVE
Net Margin %10.0%8.5%▼ −0.4 ppAT RISK
ROA9.8%7.2%▲ +1.1 ppABOVE
ROE21.6%15.0%▲ +2.4 ppABOVE
Inventory Turnover9.2×7.5×▲ +0.6×ABOVE
DSO (days)3445▼ −6BETTER
Cash Conversion Cycle (days)5268▼ −11BETTER
Debt-to-Equity0.42×0.65×▼ −0.08BETTER
§16 · Education & Certifications
Academic + 38+ Professional Credentials

Education & Certifications

Formal academic foundation reinforced by a 38-certification professional development portfolio spanning management accounting, ERP systems, AI fluency, and financial governance.

Academic Foundation
Bachelor of Commerce — Accounting
2012–2016 · Good · 65.6%

Menoufia University — Faculty of Commerce · Egypt. Active Member, Egyptian Society of Accountants and Auditors (ESAA). Egyptian Armed Forces — Honorable Discharge with Good Conduct rating; reserve duty expires March 2027.

Management Accounting & Financial Control
Preparing External Financial ReportsCMA Part 1 · Edraak 2026
Strategic Financial ManagementCMA Part 2 Aligned · MindLuster Apr 2026
Advanced Financial ModelingACCA 2024
Financial ModelingMindLuster Feb 2026
Managerial AccountingMindLuster Apr 2026
Financial Planning & Analysis (FP&A)MindLuster Apr 2026
Accounting and Financial ManagementEdraak Mar 2026
Accounting Finance CourseMindLuster Apr 2026
Cost AccountingNabraas Platform 2026
Construction AccountingNabraas Platform 2026
IFRS DiplomaNabraas Platform 2026
Internal Auditing — Fundamental PrinciplesAlison · CPD Certified Apr 2024
Fundamental Financial Skills SpecializationEdraak / Capital Bank Mar 2026
Investment Fundamentals & Strategies for Financial GrowthEdraak / Capital Bank Mar 2026
Business Pricing, Managing Irregular Income & FinTechEdraak / Capital Bank Mar 2026
Business Plan and Financial Feasibility StudyEdraak Mar 2026
Setting Up Accounting Processes & Workflows by Kellie Parks CPBAccounting Workflow Academy Dec 2025
Financial Analysis CourseNabraas Platform 2026
ERP Systems, Databases & Analytics
Odoo ERP Functional Training (18 hrs)Porta People 2024
QuickBooks DesktopMindLuster Apr 2026
Microsoft SQL Server (4-Course Specialization)Edraak / Arab Bank Apr 2026
Power BIMindLuster Mar 2026
Mastering Excel (6-Course Series, including VBA)Edraak Mar 2026
M3aarf Course (3.54 hrs)M3aarf Platform Dec 2025
AI, Automation & Digital Skills
AI Fluency: Framework & FoundationsAnthropic 2026
Claude 101Anthropic 2026
Claude Code in ActionAnthropic Feb 2026
AI in AccountingOxford Home Study Centre Dec 2025
AI Automation KickstartUdemy Feb 2026
Introduction in Artificial IntelligenceEdraak Mar 2026
ChatGPT for Management AccountingMindLuster Feb 2026
One Million Prompters InitiativeDubai Future Foundation Dec 2025
ICDL Base (International)Edraak Apr 2026
Digital Marketing: SEO, Analytics & Online PresenceEdraak / Google Mar 2026
Digital Ad CertificateAleph Digital Ad Expert Apr 2026
Professional Skills & Languages
English Conversational Skills (3-Course Series)Edraak / British Council Apr 2026
The Art of Selling (4-Course Specialization)Edraak Mar 2026
Languages: Arabic (Native) · English (B2 · British Council Certified)
Membership: Egyptian Society of Accountants and Auditors (ESAA)
§17 · Branding Statement
Closing

Executive Leadership Branding Statement

The single paragraph hiring partners across UAE, KSA, Qatar, and Egypt should remember.

In a 2025–2026 GCC and MENA hiring market that pays a premium for finance leaders who can simultaneously deliver IFRS rigor, multi-jurisdiction tax fluency, ERP transformation leadership, AI-native productivity, and bilingual board-level communication, Mohanad Ibrahim is precisely the candidate hiring managers describe but rarely meet — a Strategic Finance Business Partner ready to step into a Financial Controller, Finance Manager, or Head of Finance role and deliver immediate, measurable impact on EBITDA, working capital, audit quality, and executive decision velocity.
Mohanad Ibrahim Available · UAE · KSA · Qatar · Egypt · Q2 2026
8+
Years progressive finance leadership
38+
Professional certifications & CPD hours
3
Currencies · AED · EGP · USD operations
0
Audit findings · multi-year track record