
Moustafa Sadek
Verified Expert in Engineering
Data Analyst and Developer
Cairo, Cairo Governorate, Egypt
Toptal member since January 10, 2024
Moustafa is a seasoned data analyst with a robust background in eCommerce and fast-moving consumer goods industries. He specializes in supply chain data analytics and data engineering. With a proven track record of leveraging data-driven insights, Moustafa drives business improvement and optimizes overall performance.
Portfolio
Experience
- Spreadsheets - 7 years
- Data Analytics - 5 years
- SQL - 4 years
- Python - 4 years
- Microsoft Power BI - 4 years
- Data Modeling - 4 years
- Tableau - 3 years
- Azure Databricks - 2 years
Availability
Preferred Environment
Azure Databricks, SQL, Snowflake, Jupyter Notebook, Spyder, Azure, Google BigQuery, Microsoft Power BI, Tableau
The most amazing...
...thing I've developed was 15+ full-stack dashboards for inventory, demand planning, and logistics, enhancing operational efficiency and data visibility.
Work Experience
Senior Data Analyst
Henkel
- Developed a data model and a dashboard to monitor the product lifecycle in the logistics network regarding quantity and cost.
- Planned features and product backlog items (PBIs) via Azure DevOps, created a data model in Azure Databricks, and presented the dashboard in Microsoft Power BI.
- Optimized and reduced costs through multiple factors, such as truck utilization, which also decreased CO2 emissions.
- Created a dashboard to track and monitor forecast accuracy for regional and monthly levels.
Data Analyst
Noon
- Developed a dashboard to track the number of damaged shipments by defining each shipment's location and timestamps.
- Set weekly and monthly KPIs and analyzed them statistically.
- Created queries and views using SQL, BigQuery, and Data Studio.
- Analyzed distribution demand using Python and R to gain insights and facilitate decision-making.
- Built data models using statistics and programming.
Experience
Cost-to-Deliver Dashboard
The dashboard also tracks the quantities of goods in transit, providing insights into inventory levels and helping to prevent overstocking or understocking. This feature aids in maintaining a balanced inventory, reducing storage costs and waste.
Moreover, the dashboard is environmentally conscious as it tracks the CO2 emissions associated with the transportation of goods, encouraging businesses to adopt greener logistics practices. By reducing CO2 emissions, businesses can not only lower their environmental impact but also potentially benefit from cost savings in regions where carbon pricing is in effect.
Forecast Accuracy Dashboard
The dashboard is divided into two main sections: regional accuracy and monthly accuracy. The regional accuracy section provides data on the accuracy of forecasts for different regions, allowing for comparative analysis across various geographical areas. This helps identify regions where forecasts are consistently accurate or require further attention. The monthly accuracy section, on the other hand, tracks the accuracy of forecasts on a month-by-month basis. This allows users to observe how forecast accuracy fluctuates over time and can help identify specific months where forecasts tend to be more or less accurate.
Education
Bachelor's Degree in Engineering
Alexandria University - Alexandria, Egypt
Certifications
Algorithms and Data Structures MicroMasters Program
Rochester Institute of Technology | via edX
MITx MicroMasters Certificate in Data Analytics
Massachusetts Institute of Technology | via edX
MITx MicroMasters Certificate in Supply Chain Management
Massachusetts Institute of Technology | via edX
Skills
Libraries/APIs
PySpark, NumPy, Pandas, Node.js, REST APIs
Tools
Microsoft Power BI, Tableau, Spreadsheets, Google Sheets, BigQuery, Microsoft Excel, Spyder, Apache Airflow
Languages
SQL, Python, Excel VBA, Snowflake, R, JavaScript
Paradigms
ETL, Business Intelligence (BI), Unit Testing, Agile, User Acceptance Testing (UAT)
Platforms
Databricks, Jupyter Notebook, Azure, Anaconda, Google Cloud Platform (GCP), Amazon Web Services (AWS)
Storage
QuickBase, PostgreSQL, SSAS Tabular, Data Pipelines, Google Cloud
Frameworks
Flask
Other
Google BigQuery, Supply Chain Management (SCM), Mathematics, Statistics, Data Modeling, Microsoft Office, Excel Expert, Data Cleaning, Data Analytics, Data Analysis, Microsoft Azure, DAX, Dashboards, CI/CD Pipelines, Excel 365, Data Visualization, Data Engineering, Image Annotation, Data Transformation, Data Extraction, Excel Add-ins, ECharts, Product Management, SAP ERP, Data Analytics, Data Product Manager, Microsoft Power BI, Azure Databricks, Industrial Engineering, IT Project Management, Statistical Modeling, Statistical Analysis, Communication, Statistical Programming, Analytical Thinking, Demand Planning, Logistics, Order to Cash (O2C), Supply Chain Operations, Optimization, Big Data, Data Wrangling, Data Warehousing, ETL Tools, Stakeholder Engagement, Agile DevOps, SAP, Diversity, Equity, & Inclusion (DEI), Looker Studio, Business Analysis, Forecasting, Complex Problem Solving, eCommerce, Statistical Data Analysis, Teamwork, ERD, Machine Learning, Genesys, Data Build Tool (dbt), Linear Algebra, Sprint Planning, Call Centers, JDA
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring