Loay Ayman Mohamed profile photo

Loay Ayman

Data Analyst

Python | SQL | Excel | Data Visualization
Resume

+201029248463

Projects

Real-world data analytics projects

Sales Analysis

• Built an end-to-end ETL pipeline for 60,000+ records using Python and Power Query.
• Identified key revenue drivers ($293.8M Total Revenue) and optimized profit margins (37.3%).
• Engineered 8+ DAX measures for KPIs including ROI and Gross Profit Margin.

PythonPandas Power BIDAXSQL

HR Analysis

• Automated ETL for 6,000+ HR records, architecting a Star-Schema data model.
• Engineered 15+ DAX measures to track Attrition Rate and Tenure Metrics.
• Uncovered turnover correlations among low-tenure staff to guide retention strategies.

Power BIDAX Power QueryData Modeling

Uber Analysis

• Automated ETL for 6,000+ HR records, architecting a Star-Schema data model.
• Engineered 15+ DAX measures to track Attrition Rate and Tenure Metrics.
• Uncovered turnover correlations among low-tenure staff to guide retention strategies.

Power BIDAX Power QueryData Modeling

Technical Skills

Tools and technologies I work with daily

Python Stack

Pandas NumPy Matplotlib Seaborn Scikit-learn SciPy

SQL Stack

MS SQL Server MySQL PostgreSQL Complex Joins CTEs Window Functions

Excel Stack

PivotTables Advanced Functions Charts Data Modeling Power Pivot

Visualization Stack

Power BI Tableau DAX Power Query Data Modeling

Education

Academic background that supports my data journey

Bachelor's Degree in Communications & Electronics Engineering

Mansoura Higher Institute of Engineering and Technology

Duration: 2020 : 2025

Certifications

Structured learning and credentials

Professional Certifications

Let's Connect

Ready to transform data into insights? Let's talk!

Get in Touch

I'm always interested in hearing about new projects and opportunities. Whether you have a question or just want to say hi, feel free to reach out!

Name: Loay Ayman Mohamed
Location: Egypt
Phone: +201029248463
Email: loayaymaan@gmail.com