Hello, I'm

Ahmed Mahmoud

I am a Data Analyst who gets results. I have worked with lots of companies in the Telecom and Sales. My job is to make sense of data. I do this by cleaning up the data making models and creating reports that people can use. I use tools like Python, SQL and Power BI to turn data into information that businesses can actually use. My main goal is to stop people from having to do things by hand. I have already helped some companies get rid of their systems and replaced them with automated scripts. These scripts can do things in seconds that used to take hours. This means that the people in charge can focus on making decisions based on the data. I like working with Data Analyst things. I am good, at it.

Ahmed Mahmoud

Technical Arsenal

SQL Server
Python (Pandas/NumPy)
Power BI & DAX
Microsoft Azure
Automation Tools
Power Query
Advanced Excel
Web Scraping
Machine Learning

Experience

Performance Analyst

Huawei | Orange corporate (Smart Village,Egypt)
Jan 2026 - Present
  • Spearheaded the automation of the weekly NUR reporting pipeline using Python and SQL, replacing manual legacy workflows and drastically reducing processing time from 16 hours to under 1 minute.
  • Engineered complex SQL queries (CTEs, Window Functions, Stored Procedures) to clean and validate 1M+ network records, ensuring 99% data accuracy.
  • Designed dynamic Power BI executive dashboards utilizing Star Schema models and advanced DAX to track 20+ critical KPIs in real-time, replacing static Excel reports.
  • Delivered actionable insights to senior management by identifying key performance bottlenecks, directly supporting data-driven network optimization.

Freelance Data Analyst

Mostaql & Khamsat Platforms
Feb 2026 - Present
  • Delivering tailored data analysis and business intelligence solutions for diverse clients across multiple sectors, including Medical and Sales.
  • Cleaning and transforming complex, unstructured, and messy datasets into accurate, ready-to-analyze formats.
  • Building automated reporting tools and interactive dashboards using Power BI, Python, and Advanced Excel to address specific business needs.

Operations Specialist

SLS
May 2023 - Nov 2024
  • Managed supply chain operations and tracked performance KPIs to identify and resolve workflow bottlenecks.
  • Developed strong business acumen in logistics data analysis and process optimization.

Licenses & Certifications

Machine Learning Engineer

Digital Egypt Pioneers (DEPI) & Microsoft

Comprehensive AI & Data Science training covering ML engineering job profiles.

View Certificate

Professional Data Analyst Diploma

Mazen Analytics Lab

Completed an intensive Data Analyst Diploma covering SQL, Python, Power BI, and Tableau, culminating in a real-world capstone project.

Open PDF Certificate

AZ-900 Azure Fundamentals

Udemy

Mastered foundational cloud concepts and core Microsoft Azure architectural components in Arabic.

View Certificate

Data Analysis with Python & Pandas

LinkedIn Learning

Advanced data manipulation, cleaning, and exploratory data analysis.

Open PDF Certificate

SQL Certifications

HackerRank

Verified proficiency in complex queries, window functions, and database logic.

Basic Intermediate Advanced

Business English Track

OTO Courses / DEPI

Advanced business communication skills within a professional corporate environment.

View Certificate

English Language Course

4Level1 Center

Completed comprehensive English language training focused on professional fluency and effective communication.

View Certificate

Embedded Systems Diploma & Challenge

AMIT & Orange Digital Center

175-Hour rigorous engineering diploma & hackathon challenge (Grade: 94%). Solidified my core programming logic.

View Diploma Orange Hackathon

Featured Projects

Automated NUR Pipeline

Telecom Domain
  • Slashed weekly reporting time from 16 hours to under 1 minute.
  • Automated workflows using Python and SQL scripts.
View Case Study Source Code

E-commerce Logistics Analysis

Supply Chain
  • Structured 1.28M in sales from manual data entries.
  • Identified a 17.6% return rate as a major profit leak.
View Case Study Source Code

Real Estate Intelligence

Market Analysis
  • Web scraped 10,000+ property listings using Python.
  • Delivered strategic recommendations for investment.
View Case Study Python Scraper

Call Center Efficiency

Operations
  • Analyzed over 2 Million call records to track SLAs.
  • Identified a forecasting accuracy bottleneck at 71.6%.
View Case Study Data Model