MAHMOUD ELMAHDY

Data Analyst | BI Developer | Process Analytics Specialist
Alexandria, Egypt (Open to Relocate) +20 111 078 2859 mahmoud.ilmahdy1@gmail.com GitHub LinkedIn Portfolio
Data Analyst & BI Developer with 3+ years of experience constructing 120+ analytics projects for 30+ international clients. Specialized in Power BI, SQL, and Excel automation — compressed reporting cycles from 10 days to 1 day and reduced operational costs by 20% for SGS Saudi Arabia. Trilingual in Arabic, English, and German. Seeking a full-time role in Egypt, Saudi Arabia, or remotely.

Professional Experience

Data Analyst & BI Consultant
SGS – Saudi Ground Services (Remote)
Mar 2022 – May 2023
  • Analyzed passenger load, boarding, and delay data across 3 daily shifts during Hajj season — enabling strategic staff reallocation without new hiring costs.
  • Identified operational bottlenecks through statistical modeling, reducing passenger wait times and cutting flight delay costs by 20%+ per shift.
  • Built a multi-module Excel KPI dashboard and PowerPoint presentation for real-time ground operations monitoring; automated reporting pipeline from 10 days to 1 day.
  • Facilitated stakeholder workshops to translate complex data into actionable process redesigns and sustainable operating models.
Data Analyst – Freelance
Khamsat & Mostaql (International)
Sep 2021 – Present
  • Designed 120+ end-to-end analytics projects for 30+ clients: dashboards, ETL pipelines, KPI reporting, and process automation across multiple industries.
  • Built 70+ Power BI & Excel dashboards; engineered VBA/Power Query automation that cut manual processing time by 50% across client workflows.
  • Conducted root cause analysis on operational data, translating complex findings into clear recommendations and data-driven process redesigns.
  • Maintained 20+ verified 5-star reviews reflecting consistent delivery quality, clear communication, and business-focused outcomes.

Key Projects

Enterprise Data Warehouse & Analytics Solution
SQL Server · ETL · Medallion Architecture
  • Architected a scalable SQL Server data warehouse (Bronze/Silver/Gold), created ETL pipelines with quality checks, and built analytics covering customer behavior and sales trends.
  • Established end-to-end ETL pipelines with rigorous quality checks, and built an analytics roadmap covering customer behavior, cumulative trends, and segmentation.
Excel Automation Consultant
SAR – Saudi Arabia Railways (Remote)
Feb 2025 – Jun 2025
  • Devised a 4-system Excel automation suite for SAR’s engineering and operations teams, replacing fully manual workflows with structured, error-proof data entry via custom VBA forms.
  • Built an ECR management system with Gantt chart timeline, automated overdue alerts, and one-click PDF daily dashboard for management reporting.
  • Developed systems for RCA tracking, asset task management, and attendance — centralizing operational data into auditable records.

Key Achievements

120+ Projects
30+ Clients
20% Cost cut
10d → 1d Reports
50% Faster
20+ 5-Star

Technical Skills

BI & Visualization
Power BI, DAX, Excel (VBA, PivotTables), Tableau, Power Query
Data Engineering
SQL Server, PostgreSQL, MySQL, ETL, Medallion Architecture, Star Schema, Data Modeling
Analytics & Automation
Python (Pandas, NumPy), Process Optimization, Root Cause Analysis, KPI Development, LLMs
Languages
Arabic (Native) · English (Fluent) · German (Fluent)

Education

Bachelor of Management Information Systems
Alexandria University
2018 – 2022

Certifications

Udacity: Advanced Data Analysis, Machine Learning
McKinsey: Forward Program
365 Data Science: Advanced SQL & Excel, Power BI Reporting

Pursuing: Google Advanced Data Analytics, Microsoft Power BI Data Analyst, Stanford ML Specialization