profile-img

Ahmed Essam Elden

Data Analyst

New Cairo, Cairo, Egypt

Work Experience

  • Data AnalystInternship

    Khazna

    Jan 2022 - Mar 2022 -2 months

    Egypt

    • Job Details:Python: Pull data from SQL, analyze with Pandas, generate Word reports using python-docx. - - - - Used Google Sheets to collect team input, synchronize for real-time updates and share interim analysis. SQL Server: Run queries to extract insights and KPIs for internal reports. Conducted employee data analysis and created automated attendance/vacation tracking systems. Implemented work progress monitoring solutions.

    • Education

    • Bachelor's Degree in Biosystems Programming

      Ain Shams University (ASU)

      Jan 2019 - Jan 2024 - 5 yr

    Achievements

    Financial Transactions Analytics End-to-end financial transactions analytics project using Python, SQL Server and Power BI. Synthetic data generation, Star schema modeling, DAX KPIs, and reproducible dashboards. Smartphone Market Analytics - Egypt Designed and documented a full-cycle analytics project analyzing synthetic smartphone sales data. Applied advanced data cleaning, segmentation, and anomaly detection techniques, and developed an interactive dashboard in Power BI.

    Skills

    • Microsoft Excel
    • Microsoft SQL Server
    • Python
    • Microsoft Power BI
    • HTML5
    • CSS3
    • Tableau

    Languages

    • English

      Advanced

    Training & Certifications

    • Database Fundamentals

      Mahara Tech·2025

    • Advanced Microsoft SQL Server

      Mahara Tech·2025

    • Business Intelligence

      Mahara Tech·2025

    • MS SQL Server

      Eng. Mohamed El Desouki·2024

    • Data Engineering Foundations

      LinkedIn Learning·2024

    • Learning Microsoft SQL Server 2022

      LinkedIn Learning·2024

    • Python Programming Language

      El Zero Web School·2020

    • CS50

      Harvard University·2020
    Share this Profile