Moustafa Sadek, Developer in Cairo, Cairo Governorate, Egypt
Moustafa is available for hire
Hire Moustafa

Moustafa Sadek

Verified Expert  in Engineering

Data Analyst and Developer

Cairo, Cairo Governorate, Egypt

Toptal member since January 10, 2024

Bio

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

Henkel
Azure Databricks, Data Analysis, Statistics, Microsoft Azure...
Noon
SQL, Google BigQuery, Looker Studio, Tableau, Google Sheets, Python, Logistics...

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

Part-time

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

2023 - 2024
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.
Technologies: Azure Databricks, Data Analysis, Statistics, Microsoft Azure, Microsoft Power BI, Tableau, Agile, PySpark, Python, SQL, DAX, SSAS Tabular, Big Data, Stakeholder Engagement, Sprint Planning, Agile DevOps, User Acceptance Testing (UAT), Dashboards, SAP, Communication, Diversity, Equity, & Inclusion (DEI), CI/CD Pipelines, Data Pipelines, Data Engineering, Business Intelligence (BI), Image Annotation, Data Transformation, Node.js, PostgreSQL, Machine Learning, Amazon Web Services (AWS), ETL, Data Extraction, Unit Testing, Databricks, Apache Airflow, Data Build Tool (dbt), Microsoft Excel, Excel Add-ins, REST APIs, ECharts, Product Management, SAP ERP, Data Analytics, Data Product Manager, Microsoft Power BI

Data Analyst

2022 - 2023
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.
Technologies: SQL, Google BigQuery, Looker Studio, Tableau, Google Sheets, Python, Logistics, Agile DevOps, Google Cloud, Excel 365, Excel VBA, Business Analysis, Forecasting, Complex Problem Solving, eCommerce, Statistical Data Analysis, ETL, Teamwork, IT Project Management, QuickBase, BigQuery, Business Intelligence (BI), Image Annotation, Data Transformation, Google Cloud Platform (GCP), Amazon Web Services (AWS), Data Extraction, Apache Airflow, Data Build Tool (dbt), Microsoft Excel, Excel Add-ins, REST APIs, ECharts, Flask, Product Management, SAP ERP, Data Analytics, Data Product Manager, Microsoft Power BI

Experience

Cost-to-Deliver Dashboard

The Cost-to-Deliver Dashboard is a comprehensive tool designed to monitor and manage the cost and quantities of goods within a logistics network. It provides real-time data on the cost of delivering goods, enabling businesses to make informed decisions to optimize their supply chain and reduce overall costs.

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 Forecast Accuracy dashboard is a robust tool designed to monitor and analyze the precision of predictions on a regional and monthly basis. It provides a comprehensive view of forecasting performance, enabling users to identify trends, patterns, and deviations over time.

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

2015 - 2020

Bachelor's Degree in Engineering

Alexandria University - Alexandria, Egypt

Certifications

MAY 2022 - PRESENT

Algorithms and Data Structures MicroMasters Program

Rochester Institute of Technology | via edX

JUNE 2021 - PRESENT

MITx MicroMasters Certificate in Data Analytics

Massachusetts Institute of Technology | via edX

MARCH 2020 - PRESENT

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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring