Ali Ezzat

Senior Data Analyst with 7 years of experience in analytical modelling, financial performance analysis, and large-scale reporting automation. Skilled in SQL, Python, Power BI, and advanced Excel, with deep expertise in building automated data pipelines, ETL workflows, and scalable dashboards that eliminate manual effort and improve data reliability. Proven ability to transform complex operational and financial datasets into actionable insights for programs exceeding 300B SAR.

Seeking analytics-driven roles in Riyadh where I can enhance automation maturity and support strategic, data-driven decision-making.

Data Analytics & Reporting Lead at C-Bloc (National Housing Company) (2025-04 – Present)

• Reduced weekly reporting time by nearly 80% using Python to extract unit-level progress, schedule updates, and financials; automated folder structuring, file updates, and email distribution for residential portfolios.
• Delivered the live construction-progress data integration between NHC and major Saudi banks, enabling customers to track building and unit progress directly through their banking apps.
• Performed sales and financing analytics for NHC and partner banks by analysing sold and bank-financed units, tracking progress status, and ensuring accurate reporting of unit-level construction updates across all regions.
• Implemented end-to-end data models in Power BI using star and snowflake schema patterns; integrated 15+ tables (units, schedules, contracts, inspections, invoices, payments) with optimised relationships and DAX measures for dynamic filtering.
• Developed interactive Power BI dashboards for real-time construction performance monitoring. The solution integrated detailed unit-level data to visualise key performance indicators (KPIs), including budget utilisation variances, milestone-triggered revenue recognition, and VAT compliance status, coupled with percentage-complete-based cash-flow forecasts.
• Developed predictive regression models in Python (Pandas, Scikit-learn) to forecast unit delivery and handover dates. These models were built by integrating baseline scheduling data, actual project progress, and quantifiable delay drivers to generate probabilistic forecast windows.
• Incorporated AR, Unbilled Aging, and DSO at unit and project levels to prioritise collections, align milestone billing with handovers, and improve short-term liquidity planning.
• Implemented Power Query techniques within Power BI/Excel to efficiently clean, explore, transform, load, and manipulate large datasets covering residential units development across the Kingdom, ensuring data readiness and integrity for financial and progress reporting.

Data Analytics and Reporting Specialist at Saudi Binladin Group (2024-04 – 2025-04)

• Designed and maintained advanced Power BI dashboards to monitor project KPIs, including budget utilisation, disbursement progress, AR aging, DSO, issue resolution timelines, and milestone achievement for the Haram Expansion program.
• Developed complex Excel models with dynamic formulas, pivot tables, Power Query, and error-tracing logic to consolidate multi-source financial and operational data into audit-ready reports.
• Applied variance analysis and forecasting techniques to evaluate schedule adherence, cash flow stability, and resource allocation, supporting proactive risk management.
• Streamlined reporting cycles by automating recurring tasks with advanced Excel logic and query-driven workflows, reducing manual effort and improving reporting consistency.
• Delivered weekly and monthly performance reports to internal stakeholders and senior project managers, highlighting progress against milestones, compliance metrics, and operational insights.
• Validated and reconciled project data with field teams to ensure accuracy of financial progress logs and operational observations, reinforcing transparency and accountability.
• Created visual performance trackers in Power BI and Excel to illustrate closure rates, budget drawdowns, and reporting cadence, driving timely interventions across project workflows.

Senior Data Analytics and Reporting at RATP Dev. Mobility Cairo (Light Rail Transit & Metro Line 3) Operation and Maintenance (2020-08 – 2024-04)

• Designed and maintained interactive dashboards in Power BI and Tableau to monitor project KPIs, including budget utilisation, disbursement progress, schedule adherence, resource allocation, and milestone achievement, enhancing visibility for executive decision-makers.
• Analysed large volumes of financial and operational data (e.g., cost variance, progress ratios, and compliance metrics) to generate actionable insights and optimise project delivery strategies.
• Performed variance and trend analysis by integrating quantitative datasets with qualitative project reports, improving understanding of drivers behind delays, cost overruns, and performance gaps.
• Examined workflow and compliance data to identify bottlenecks, reporting gaps, and risks in project execution, using SQL and Power BI to deliver insights that supported process improvements and governance.
• Created visual performance trackers and scorecards to illustrate progress against milestones, reporting frequency, and financial drawdowns, driving timely interventions and strategic alignment across Metro Line 3 and LRT projects.
• Conducted training workshops for project staff on reporting best practices.

Reporting Specialist at Acrow Integrated Construction Services (2019-01 – 2020-08)

• Developed and maintained Excel-based reporting frameworks with advanced formulas, pivot tables, and Power Query to consolidate financial and operational data, ensuring accuracy and audit-ready outputs for construction project monitoring.
• Prepared performance dashboards and variance analysis reports to track budget tracking, disbursement progress, and milestone achievement, providing management with actionable insights for decision-making.
• Collaborated with project teams and finance departments to validate data integrity, reconcile discrepancies, and standardise reporting processes across multiple construction projects.

Bachelor of Science in Petroleum Geoscience Department – Cairo University (2018)