Available for Opportunities · Open to Projects

Mohamed Gawad

PMP® PRMG · AUC Lean Six Sigma Black Belt Civil Engineer · Ain Shams

// PROJECT MANAGEMENT · DATA ANALYTICS · POWER BI · PYTHON

A Project & Data Engineer with 15+ years of experience across various industries, combining an engineering mindset with data tools to turn numbers into clear decisions. Leading major projects and building precise planning & analytics systems at AIC Steel, El Sewedy Electric, and Zamil Steel. PMP® Certified — Civil Engineering graduate, Ain Shams University.

💬 WhatsApp Contact Me My Services
Mohamed Gawad
15+
Years Experience
100+
Dashboards Built
3
Major Companies
150K
Tons/Year Managed
1000+
Workers Tracked
// Core Skills

Core Skills

A unique blend of project management, data analytics, and business intelligence.

⚡
Power BI Service & Desktop
Built 100+ interactive dashboards for project tracking, production, inventory, and human resources management.
95%
📊
Microsoft Excel & VBA
Full professional proficiency including Macros programming, report automation, and complex data analysis.
95%
🏗️
Project Management
Managing the full project lifecycle from Kick-off to delivery — Master Plan, daily follow-up, and problem-solving.
90%
🐍
Python & Data Science
Building Regression, Clustering, and Time Series Forecasting models using Pandas, Scikit-learn, and Prophet.
85%
🧠
Statistical Modeling & DAX
Building precise statistical models with DAX mastery for Pearson and Regression calculations inside Power BI.
90%
🎯
Data-Driven Decision Making
Transforming production, project, and resource data into actionable decisions at the senior management level.
98%
// Power BI Work

Featured Dashboards

Real-world projects from 15+ years in heavy industries and steel construction.

Sales Dashboard
SALES · 393 PROJECTS · 9 COUNTRIES
Sales Project Dashboard
Comprehensive analysis of 393 projects — 123,963 tons, 235 clients, sales managers performance, geographical distribution across 9 countries, and revenue growth from 2021 to 2026.
Power BIMapsDAXTime Intelligence
Time Series
FORECASTING · TIME SERIES · PROPHET
Sales Forecasting — Time Series Model
Time Series model to forecast future tonnage with Confidence Intervals — used for planning raw materials and workforce requirements for coming months through 2026.
PythonProphetPower BIDeneb
Decomposition
DECOMPOSITION · TREND · SEASONAL
Data Decomposition — Trend · Seasonal · Residual
Sales pattern analysis by decomposing data into Trend + Seasonality + Residual to evaluate model strength and understand market behavior from 2022 to 2025.
Power BIPythonSTL DecompDeneb
Monthly Target
MONTHLY TARGET · PLAN VS ACTUAL
Monthly Target Dashboard
Monthly target monitoring with future forecasts — Plan vs Actual across all categories with clear visual progress tracking.
Power BIDAXForecasting
Master Dashboard
MASTER DASHBOARD · ALL PROJECTS
Master Dashboard — All Projects Follow-up
Comprehensive board — project status (In Progress / Review / Hold), Cash Flow 113M SAR, site & material & procurement readiness, payment methods, and manufacturing locations.
Power BIDAXOracleCash Flow
// What I Offer

How Can I Help You?

Professional services built on 15+ years of real-world experience in industry and data.

🔮
Demand Forecasting Model
Building an AI model that predicts demand volume or sales for upcoming months, identifying peak and low points to support planning and procurement decisions.
PythonProphetPower BI
🏗️
Project Management Consulting
Preparing a comprehensive Master Plan, tracking project progress, analyzing delay causes (Delay Analysis), and delivering periodic reports to senior management in a professional manner.
MS ProjectPrimaveraPMP®
📁
Data Organization & Report Automation
Organizing and consolidating scattered data, connecting it to Power BI to build interactive dashboards, and automating recurring reports using VBA or Python to save time and effort.
Power BIVBAPython
⚙️
ERP Integration with Power BI
Designing a professional reporting layer on top of ERP systems (Oracle / SAP and others), connecting them directly to Power BI to produce real-time interactive dashboards for management needs.
OracleSAPPower BI
🤝
Monthly Retainer — Data Partner
Fixed monthly subscription including: periodic reports for senior management, updated dashboards, sales forecasts & inventory monitoring, resource organization, monthly targets, and KPIs for each department.
Power BIKPIsReportingPlanning
// Python & Data Science

Data Science Models

Statistical analysis and machine learning models built with Python to solve real-world problems.

01
Car Price Prediction — Linear Regression
Linear Regression model to predict car prices based on specifications — data cleaning, feature engineering, and performance evaluation.
📈 R² Score: 0.87
PythonPandasNumPyScikit-learnMatplotlib
02
Customer Churn Prediction — Logistic Regression
Classification model to predict customer churn — analyzing factors influencing churn and helping sales teams retain customers effectively.
PythonPandasScikit-learnSeaborn
03
Customer Segmentation — K-Means Clustering
Segmenting customers into homogeneous groups based on purchasing behavior — to improve marketing strategies and understand demand patterns.
PythonPandasScikit-learnK-Means
// Education & Certifications

Education & Certifications

A strong academic background supported by internationally recognized professional certifications.

🏆
Project Management Professional — PMP®
PMI · Credential #4132936
Feb 2025 — Jun 2025 · Renewal: June 2028
The highest international certification in project management
🎓
Diploma in Project Management — PRMG
American University in Cairo (AUC)
Sep 2015 — Jun 2016
Grade: Excellent
⚙️
Lean Six Sigma Black Belt — Training Course
TÜV — German Standards Institute
Sep 2019 — Jan 2020
Highest level in quality improvement methodology
🏛️
B.Sc. Civil Engineering
Ain Shams University — Faculty of Engineering
Sep 2006 — Jun 2011
Very Good grade — Excellent in graduation project
// About Me

Who Am I?

A Project & Data Engineer with 15+ years of experience across various industries, combining an engineering mindset with data tools to turn numbers into clear, actionable decisions.

Leading major projects and building precise planning and analytics systems — from Master Plans to interactive Dashboards and AI-powered forecasting models.

Holds PMP® from PMI, Lean Six Sigma Black Belt Training course from TÜV, and is a graduate of Faculty of Engineering — Ain Shams University.

🏗️
Project Management
AIC Steel · El Sewedy · Zamil Steel
⚡
Power BI & Data Analytics
100+ Interactive Dashboards
🐍
Python & AI Forecasting
Prophet · Scikit-learn · Pandas
// Get In Touch

Have a Project?

Available for consulting, project management, and professional dashboard development.

💬
WHATSAPP
+20 1007456505
...