Mostafa Hegazy

Expert Data Engineer & Data Management Consultant with 10+ years of experience delivering enterprise data platforms, cloud migrations, and large-scale ETL/ELT architectures across banking, government, and telecom sectors in EMEA. Combines deep hands-on engineering (Oracle ODI, OAC, PL/SQL, Python, Spark, Databricks, SQL Server, Azure Data Factory, Informatica) with strategic advisory, leading cross-functional delivery teams through the full data lifecycle from requirements modeling and dimensional design to multi-source ingestion, transformation, and executive reporting. DAMA CDMP-certified expert in complete data management, governance, metadata, quality automation, master data, lineage, and business glossaries — who modernizes legacy estates into scalable cloud platforms.

Engineers

Python-automated reconciliation pipelines validating millions of records and establishes policy-driven technical controls to deliver trusted, decision-grade data for compliance and growth.

Senior Data Engineer | Oracle — Dubai, UAE Mar 2024 – Present

•

Spearhead the Data Management and ETL engineering team, architecting end-to-end data migration, enterprise data warehousing, and comprehensive data governance frameworks for Oracle’s regional clients.

•

Program Python-based automated data reconciliation and auditing scripts, validating system-wide data quality and operational integrity across millions of records.

Key Project — Ministry of Municipality, Qatar: End-to-End Data Migration & EDW

•

Led end-to-end data migration and enterprise data warehouse build for the Ministry, covering the full data governance cycle.

•

Source analysis & mapping: profiled and analyzed legacy source systems; built source-to-target mapping documents ahead of transformation design.

•

Migration build: designed and developed ETL/ELT pipelines (Oracle ODI) to move data from source systems into the target data warehouse.

•

Validation & reconciliation: built and ran load validation and reconciliation checks to confirm migrated data matched source, including automated Python-based reconciliation scripts across millions of records.

•

Cutover & governance: led the Data Management team through cutover activities and established the ongoing data governance framework (ownership, quality rules, metadata) for the migrated environment.

Key Project — Abu Dhabi Executive Office (ADEO): Data Warehouse & Oracle Analytics Cloud

• Architected production Data Warehouse and Oracle Analytics Cloud (OAC) solution.
• Integrated Oracle E-Business Suite (EBS) and Oracle Fusion data into the platform using BICC, landing into Object

Storage, then loaded via ODI — a source-system data migration/integration into a new analytics platform.

Senior Data Analytics Principal Consultant | Oracle — Cairo, Egypt Aug 2019 – Mar 2024

• Directed technical delivery for multiple regional clients across banking and telecom, from requirements and data modeling through ETL/ELT build and reporting.

Key Project — Central Bank of Kenya: EDW, Big Data, GDI & Digital Lender

• Directed the technical delivery team across four initiatives (Enterprise Data Warehouse, Big Data, Government Data

Integration, Digital Lender), executing full lifecycle engineering from requirements and data modeling through multisource

ELT ingestion (Oracle ODI).

• Built strategic performance-management frameworks (Oracle Scorecard and Strategy Management – OSSM) for CBK executives to track corporate strategy, targets, and KPIs.
• Deployed Oracle Enterprise Metadata Management (OEMM) across the CBK IT landscape — cataloging, search, and automated impact/lineage analysis across databases, RPDs, and OBIEE analysis layers.
• Designed and tuned high-throughput OAC dashboards and mobile analytics interfaces, enforcing strict performance optimization standards to standardize enterprise-wide executive reporting.

Key Project — Al Rajhi Bank (KSA): “Sniper” Project

• Engineered a dedicated dimensional and relational data model for Al Rajhi Bank as part of the Sniper Project.
• Worked directly within a Tier-1 commercial/retail banking data environment, translating banking data structures into an analytics-ready model.

Key Project — Windtre (Italy): Telecom Data Warehouse

• Maintained and iterated on large-scale telecom data warehouse via ODI and PL/SQL using Agile delivery, Oracle Git version control, and Jira.

Business Intelligence Developer | Mantrac Group — Cairo, Egypt Aug 2018 – Aug 2019

Key Project — BI & Analytics Platform Across 12 Countries

• Engineered end-to-end BI and analytics solutions across 12 international territories: requirements gathering, data modeling, ETL pipeline development, and executive dashboards.
• Designed and deployed a supply chain and logistics analytics platform from scratch for heavy equipment, parts distribution, and inventory tracking.
• Re-architected legacy data warehouse structures, substantially accelerating query response times and improving data retrieval efficiency across multi-country business units.
• Spearheaded comprehensive data quality governance protocols across the central data warehouse, systematically cleansing anomaly-ridden data to guarantee reporting accuracy.
• Directed BI environment administration and release management under ITIL standards, securing maximum system uptime and top-tier SLA compliance.

Business Intelligence Developer | Mufaddal — Cairo, Egypt Mar 2017 – Jul 2018

Key Project — First Enterprise Data Warehouse & BI Function

• Founded and led the organization’s first BI function, building the first enterprise-wide data warehouse (Purchase,

Production, Inventory, Sales, Finance modules) from scratch.

• Gathered requirements from executive stakeholders and end-users to design end-to-end analytics lifecycles,

encompassing raw data extraction, ETL engineering, SSAS cube development, and dynamic reporting.

• Migrated legacy ERP (Microsoft Dynamics AX) reporting into a new BI/ETL pipeline and SSAS cube layer,

improving processing speed and data accuracy — a full legacy-to-target reporting migration.

• Built complex batch and financial statement reporting previously unattainable directly from the ERP system.
• Developed custom Microsoft Dynamics AX forms, reports, and functional enhancements during a 6-month rotation in the ERP engineering team.
• Conducted organization-wide Power BI training using pre-aggregated OLAP cubes, empowering business stakeholders for self-service analytics and ad-hoc dashboards.

BA, Computer Science