Abdalatyf Ahmed Ibrahim

Abdalatyf Ahmed Ibrahim

Junior Data Analyst & Analytics Engineer | Power BI · SQL · Python

Transforming complex datasets and raw records into reliable relational architectures, automated ETL pipelines, and decision-ready Power BI cockpits.

View Projects Get In Touch

About Me

Bridging data engineering precision with analytical research thinking.

"I help businesses and organizations turn messy, complex data into reliable relational architectures, automated ETL pipelines, and decision-ready Power BI cockpits."

I am a Junior Data Analyst and Analytics Engineer currently training in the Digital Egypt Pioneers Initiative (DEPI Round 5), alongside my academic medical studies at Al-Azhar University.

I don't just visualize surface metrics — I architect the entire data lifecycle. From programmatically extracting and cleaning 15 years of regulatory financial records with Python, to engineering normalized 9-table Star Schemas in MySQL with 121,000+ verified rows, and building interactive Power BI dashboards with drill-through navigation engines.

Currently, I serve as Team Leader, Lead Data Architect & QA Manager for our DEPI graduation project, directing a 6-member team on the Financial Risk Early Warning System analyzing 20 major US commercial banks across 60 quarters.

Education

Academic foundations and analytical clinical research methodology.

Bachelor of Medicine and Surgery (MBBCh Candidate)
Faculty of Medicine, Al-Azhar University
2025 – 2030 (Expected, Year 2)

Technical Skills

Core technical stack across data engineering, relational modeling, and business intelligence.

⚙️ Data Engineering & Python

Python 3.12 Data Cleaning Web Scraping Pandas NumPy Automated ETL Pipelines BeautifulSoup yfinance API CLI & Batch Scripts

🗄️ Database Architecture & SQL

MySQL 8.0 Star Schema Design (3 Facts, 6 Dims) 3NF Normalization Composite Keys Complex Joins CTEs Window Functions

📊 BI & Visualization

Power BI Desktop Power BI Service DAX Measures Power Query (M-Code) VertiPaq Optimization Field Parameters Drill-Through Engine Advanced Excel

🛠️ DevOps & Workflow

Git & GitHub VS Code Batch Scripts (.bat) .env Security Code QA & Review Agile Leadership

Experience & Roles

Hands-on technical leadership and end-to-end project execution.

Team Leader, Lead Data Architect & QA Manager
Financial Risk Early Warning System (DEPI Graduation Project)
Sept 2026 – Present
Data Analyst Trainee
Digital Egypt Pioneers Initiative (DEPI Round 5)
July 2026 – Present

Offered Services

Concrete data solutions delivered for businesses and clients.

📊

Power BI Executive Dashboards

Transform disjointed spreadsheets into interactive, multi-page analytical cockpits with custom grid layouts, dynamic DAX measures, field parameters, and drill-through navigation.

🗄️

Database Architecture & Star Schemas

Design normalized relational databases (MySQL/PostgreSQL) and dimensional models (facts and dimensions) optimized for analytical speed and clean reporting.

🧹

Data Cleaning & Automated ETL

Build automated Python scripts (Pandas, NumPy) and Power Query pipelines that detect outliers, deduplicate records, fix broken formats, and output audit-ready datasets without manual human error.

🌐

Web Scraping & Data Extraction

Develop automated scrapers (BeautifulSoup, Requests, APIs) to extract public registries, market benchmarks, and web archives into structured databases and CSV files.

Featured Projects

Deep case studies demonstrating data cleaning, web scraping, modeling, and dashboard design.

Financial Risk Early Warning System (EWS) FLAGSHIP · IN PROGRESS

View GitHub Repository ↗

Python (ETL, Scraping, Cleaning) · MySQL (Star Schema) · Power BI · Git · DEPI Graduation Project (Sept 2026 – Present)

Team LeaderWeb ScrapingData CleaningFFIEC Call Reports Star Schema (9 Tables)121,328 RecordsDevOps (.bat)

Executive Superstore Analytics Application

View Full Report (PDF) ↗

Power BI · DAX · Power Query (Data Cleaning) · Dimensional Modeling · UI/UX Design · DEPI Mini-Project (August 2026)

Data Cleaning5-Page ArchitectureVertiPaq OptimizationField Parameters Drill-ThroughAzure MapsPop-Out Filter Modal
Executive Overview Product Performance Customer Insights Returns and Quality Analysis Shipping Operations

Ready to build reliable data pipelines and interactive dashboards?

Whether you need automated Python data cleaning, web scraping, a clean MySQL Star Schema, or an executive Power BI dashboard, let's connect and discuss your project.