Profile

BI Developer and Data Engineer with experience building end-to-end analytics solutions, automated reporting pipelines, and data-driven applications using SQL, Python, Power BI, and SQL Server. Skilled in ETL/ELT, data warehousing, dimensional modeling, DAX, and Java Spring Boot REST APIs. Experienced in integrating SAP data, automating business reporting, and delivering executive dashboards for sales, supply chain, procurement, inventory management, and budgeting. Combines data engineering and business intelligence to transform operational data into actionable insights.

Professional Experience
Supply Chain Data Analyst and BI, Wadi Degla Holding
Aug 2025 – Present | Cairo , Egypt
  • •Deliver centralized BI, analytics, and data engineering solutions using Python and SQL as part of the Annual Procurement Planning (APP) team supporting supply chain, planning, budgeting, and stock control across multiple Wadi Degla Holding companies,
  • •Wadi Degla Clubs , Wadi Degla Developments , Cairo Tower, The District Vill , National Yachts Company , Peak Marine , Egypro , EgyproFME, Egy Const
  • •Work closely with management and C-level executives to understand business needs and translate them into executive Power BI dashboards and infographics that support data-driven decision-making.
  • •Build automated Python and SQL reporting pipelines to generate daily reports, analysis, and insights with minimal manual effort.
  • •Design and build Power BI solutions by creating low-fidelity and high-fidelity dashboards and dynamic infographic layouts, and deliver storytelling reports using advanced DAX to clearly communicate business insights.
  • •Support planning and yearly budgeting by analyzing historical demand, consumption, and pricing data, including price forecasting for budget preparation.
  • •Perform stock control and inventory aging analysis using Python to improve operational visibility and decision-making.
  • •Prepare executive presentations, communicate insights to leadership, and lead knowledge transfer and technical enablement sessions to promote best practices in BI development, automation, and analytics.

    • Technologies: Python , SAP , Power BI, SQL, DAX, Excel

    Business Intelligence Analyst, Bingo Global Group
    Dec 2024 – Jul 2025 | Cairo, Egypt
  • •Developed Java-based APIs on the data warehouse (DWH) for real-time data access, replacing manual updates and improving visibility via Power BI and Excel dashboards.
  • •Developed a Customer Service website using Java Spring APIs and React front-end for real-time inventory access and improved staff efficiency.
  • •Built DWH and ETL workflows using SSIS,
  • •Automated daily Python reports with SQL reports, increasing accuracy and reducing turnaround time for decision-making.
  • •Created a Python data pipeline to scrape Bingo products in Amazon
  • •Optimized product transfer operations across 26 retail channels by integrating multi-system data and automating reporting.
  • •Implemented Git-based version control for dashboard projects and code to control change management.
  • •Analyzed inventory aging and branch performance to identify growth opportunities and gaps.
  • •Designed Power BI dashboards for daily KPI tracking, applying data storytelling for clearer management insights.

    • Technologies: Python, Java, REST APIs, GitHub, Power BI, SQL, DWH, SSIS, DAX, Excel

    Inventory Data Analyst, Z2Data
    Sep 2023 – Dec 2024 | Cairo, Egypt
  • •Integrated external APIs and Python web scraping to collect real-time data on pricing, lead time, and inventory availability.
  • •Analyzed historical inventory and pricing data to identify trends and support proactive procurement planning.
  • •Conducted inventory aging, shortage, and supplier performance analysis to improve supply chain flexibility and sourcing decisions.
  • • Built pricing recommendation logic to suggest alternative components during shortages.

    • Technologies: Python, SQL, APIs, Excel, Power Query, DAX

    Sales Data Anlaysis intern, Elbaat Digital agency
    Jun 2023 – Aug 2023 | Mansoura, Egypt
  • •Conducted growth and sales data analysis, providing insights
  • •Built interactive Power BI dashboards for client presentations.
  • •Technologies :SQL , Excel , Dax ,Power BI
    • Technical Skills

    Database & Data Management: Data Warehousing, SQL, MySQL, T-SQL, ETL, SSIS, SSAS, SSRS, SQL Server, SQLite, MongoDB (NoSQL)

    Backend Development (Java Spring):

  • •Spring Framework (Core), Spring Boot, Spring MVC, Spring Data JPA / Hibernate, RESTful APIs, JSON / XML, Swagger / OpenAPI, Postman

    • Data Analysis & Visualization:

    Power BI, Excel, Power Query, DAX, Data Visualization, Data Storytelling

    Programming Languages:

    Java, Python (Pandas,SQLAlchemy, Plotly, SciPy)

    Projects
  • •Developed an end-to-end HR Analytics platform using Python ETL, SQL Server, Spring Boot, and Power BI.
  • •Designed Figma-based analytical and strategic dashboards and implemented secure manager-level reporting through API filtering.
  • • Built a Star Schema data warehouse with advanced DAX, KPI reporting, drill-through analysis, and dynamic storytelling insights.

    • Tools & Technologies: Python (Pandas, SQLAlchemy), SQL Server, Java, Spring Boot, Spring Data JPA, Swagger, Power BI, DAX, Power Query, Figma, Git, GitHub.

  • •Built a Backend Row-Level Security integrating Spring Boot REST API, Spring Data JPA, and SQL Server with Power BI dashboards,
  • •Enforcing backend Row-Level Security for user-specific data by a dynamic parameter in Power Query using the user's email
  • •Reusable DAX UDFs and Dynamic Storytelling depend on the return numbers.
  • •Developed a backend API Project with full CRUD for Task Lists and Tasks
  • •Using Spring Boot, Spring Data, MS SQL Server Database, DTOs, and MapStruct
  • •Implemented Validation, custom centralized exception handling, and Swagger for documentation
  • •Using MVC Architecture

    • BI & Data Engineering Projects – Bingo Global Group
  • •Real-Time Data Access & Reporting: Built Java APIs to enable real-time data access and automate Power BI and Excel reporting.
  • • Data Cubes & Analytics Pipelines: Created SQL data cubes and migrated them to Python pipelines for automated analytics.
  • •Version Control for BI Assets: Implemented Git and GitHub for managing code and Power BI dashboards.
  • •Automated Daily Reporting: Automated sales and operational reports using Python to improve speed and accuracy.
  • •Competitive Price Scraping: Built Python scraping pipelines to collect live Amazon prices for competitive analysis.
  • •Sales Performance & KPI Analysis: Developed Power BI dashboards with data storytelling for sales and KPI analysis.
  • • Customer Service Portal: Built Java Spring APIs to provide real-time inventory access for customer service teams.

    • Enterprise BI & Analytics Projects – Wadi Degla Holding
  • •Procurement & Budget Analytics: Analyzed historical demand, consumption, and pricing for planning and budgeting.
  • •Inventory & Stock Control: Performed aging and stock analysis using Python to reduce slow-moving inventory.
  • •Automated Reporting: Built Python/SQL pipelines integrating SAP data for daily reports.
  • •BI Storytelling & Dashboard Design: Designed dashboards and infographic reports using advanced DAX.
    • Certificates and Training
    Azure Data Engineer Intern at DEPI | March 2024 - November 2024⁠
    • •Microsoft SQL Essentials , Data Warehouse
    • •Python Programming : Pandas| Numpy, Sqlalchemy
    • •Azure Data Fundamentals, MLOps Tools, MLflow, Hugging Face
    • •Agile Development and Scrum , Soft Skills ,Business English
    BI ITI Track Training
    • •Data Base ,DWH , SQL,SSIS, SSAS , SSRS
    • •Microsoft SQL Server Business Intelligence
    • •Microsoft Power BI ,XML,Tableau
    Education
    Digital Egypt Builders Initiative- DEBI, software engineer diploma
    Nov 2024 – Nov 2025 | Cairo, Egypt
  • •Languages & Concepts: Java, Python, SQL | Data Structures, Database Management
  • •Databases: MySQL, SQLite, MongoDB (NoSQL)
  • •Backend (Java Spring): Spring Framework (Core), Spring Boot, Spring MVC, Spring Data JPA, RESTful APIs, JSON/XML, Swagger/OpenAPI, Postman
  • •Frontend: ReactJS
    • BSc in Computers and Information, Mansoura University
    2018 – 2022 | Mansoura, Egypt
  • •Grade: Very Good (80.8%)
  • •Graduation Rank: 6th overall
  • •Graduation Project: Diabetes Management System (With Machine Learning) – Excellent (94.5%)