Mostafa Mohamed — Data Analyst

Hi, I am

Mostafa Mohamed

Applied AI & Workflow Automation | Data Analytics & BI | ERP Systems

I interrogate complex enterprise operations with legal-grade critical logic — architecting production Power BI diagnostic models, SQL pipelines, and autonomous AI workflows that protect revenue and eliminate friction.

Explore My Work
Power BI
SQL Server
Python 3.12
DAX Modeling
PostgreSQL
n8n Automations
PyTorch
Pandas & Polars
Streamlit Cloud
Groq LLM APIs
Power BI
SQL Server
Python 3.12
DAX Modeling
PostgreSQL
n8n Automations
PyTorch
Pandas & Polars
Streamlit Cloud
Groq LLM APIs

Evidence-Driven Problem Solving

Top-tier data analytics is not about drawing charts; it is about interrogating evidence, tracing operational root causes, and delivering solutions at lightning speed.

With formal training in Law from Cairo University and certified mastery as a Microsoft Power BI Data Analyst (PL-300), I approach commercial datasets as forensic evidence. I interrogate assumptions, isolate correlation from true causality, and construct diagnostic dashboards that reveal exactly where operational friction occurs and where revenue leaks can be plugged.

Legal-Grade Logic

Rigorous hypothesis testing, eliminating confirmation bias, and verifying the causal validity of every metric before presenting to leadership.

Forensic BI Modeling

Production DAX time-intelligence, robust Star Schemas, and SQL CTEs that answer specific commercial questions on margins, retention, and risk.

Applied AI Prototyping

Moving from commercial requirements to fully functioning Streamlit apps, PyTorch models, and automated n8n agent pipelines in hours.

Tools, Technologies & Methods

Modern technologies deployed to ingest, model, interrogate, and automate commercial operations.

Business Intelligence

Power BI Desktop & Service DAX Measures & Calculations Data Cleaning (Power Query / ETL) Data Modeling (Star Schema) PL-300 Microsoft Certified Excel Financial Models

Databases & SQL

SQL Server (T-SQL) SELECT Queries & Views JOINs, CTEs & Subqueries Data Aggregations & Grouping Database Schema Design PostgreSQL & MySQL

Python & AI Engineering

Python 3.12 Core Pandas & NumPy (EDA) Computer Vision (OpenCV) PyTorch Deep Learning Groq / Llama 3 APIs Streamlit Cloud Apps

Automation & Workflows

n8n Multi-Agent Pipelines Git & Git Bash (CLI) Webhooks & REST APIs JSON Schema Validation Google Sheets Mini CRM Automated Alerts (Telegram)

Featured Projects & Case Studies

Real-world business problems, analytical methodologies, verified results, and interactive code artifacts.

Hotel Booking Performance Dashboard
Hospitality Analytics & Revenue Interactive BI + Video

Hotel Booking Performance & Cancellation Diagnostics

Business Problem: 37% cancellation volatility across 119k+ bookings caused operational forecasting inaccuracies and unsold peak rooms.
Dataset & Method: 119,390 reservation records. Cleaned using SQL Server CTEs and modeled with multi-page Power BI DAX time-intelligence.
Key Findings: Bookings made >90 days in advance via OTAs exhibited double the cancellation propensity; formulated dynamic non-refundable tiers.
Power BI DAX Measures SQL Server Revenue Modeling
Download .pbix
Financial Fraud Analytics
Financial Analytics & Risk 1.05M Audited Records

Financial Fraud Analytics at Scale

Business Problem: In 1.05M transactions, rare fraud anomalies (1,142 cases or 0.11%) made manual auditing economically impossible.
Dataset & Method: 1,048,575 financial transactions analyzed with tiered DAX measures, velocity tracking, and risk exposure modeling.
Key Findings: Proved 100% of confirmed fraud instances concentrated exclusively in TRANSFER and CASH_OUT modes, slashing audit noise by 98%.
Power BI Desktop DAX Velocity Risk Modeling 1.05M Records
Autonomous AI Lead Qualification System
AI Agents & Orchestration Production n8n + Groq

Autonomous AI Lead Qualification & CRM Agent

Business Problem: Inbound sales inquiries across Telegram, web forms, and Gmail suffered from hours of qualification latency.
Dataset & Method: 4-pipeline autonomous n8n workflow integrating Groq LLM API. Parses raw text into validated JSON intent schemas.
Key Findings: Slashed response latency from hours to under 30 seconds; automatically triggers instant Telegram alerts for high-value leads.
n8n Workflow Groq LLM REST APIs Google Sheets CRM
Download Workflows (.zip)
Electricity Theft Detection System
Deep Learning & Computer Vision Live Streamlit App

Electricity Theft Detection System

Business Problem: Multi-million dollar non-technical utility grid losses caused by illegal bypasses undetectable by static rules.
Dataset & Method: Dual-branch CNN-LSTM neural network. 2D-CNN extracts daily spatial patterns; LSTM models sequential temporal anomalies.
Key Findings: Deployed as an interactive Streamlit app giving field inspection teams calibrated risk probabilities for targeted audits.
PyTorch CNN-LSTM Streamlit Time-Series
Launch Live App
EmoLens Facial Emotion Recognition
Computer Vision & Deep Learning Live Webcam App

EmoLens — Facial Emotion Recognition

Business Problem: Detecting subtle facial micro-expressions in real time under adverse lighting and head-tilt conditions.
Dataset & Method: EfficientNet-B3 backbone with Convolutional Block Attention Modules (CBAM) and temperature-scaled confidence calibration.
Key Findings: Achieved sub-45ms real-time inference latency across 7 emotional states via webcam and video upload streams.
EfficientNet-B3 CBAM Attention PyTorch Streamlit
Launch Live App
RxHand-AI Prescription Structuring
Healthcare AI & Vision Transformers TrOCR Vision Transformer

RxHand-AI: Prescription Recognition & Structuring

Business Problem: Illegible doctor handwriting leads to dangerous pharmacy dispensing mistakes and administrative delays.
Dataset & Method: Microsoft TrOCR (Vision Transformer) with autoregressive decoders extracting clinical entities into validated JSON.
Key Findings: Robust open-vocabulary recognition of cursive medical slips with Human-In-The-Loop confidence safeguards.
TrOCR Vision Transformers PyTorch Medical JSON
GitHub Profile
Global Data Survey Analytics
Business Intelligence & Market Insights Recorded Video Walkthrough

Data Professional Global Survey Analytics

Business Problem: Synthesizing global salary distributions, tool adoption (Power BI vs Tableau vs Python), and career satisfaction across 630+ data professionals.
Dataset & Method: Global practitioner survey data structured and visualized in Power BI with dynamic drill-through filters.
Key Findings: Pinpointed regional compensation anomalies and satisfaction drivers for data analysts transitioning to senior roles.
Power BI Desktop DAX Measures Salary Benchmarking Video Demo

Professional Experience

Demonstrated track record of analytical problem solving and technical implementation.

Applied AI Engineer Intern

ITechPro-eg · Cairo, Egypt
Sep 2026 — Present
  • Utilized AI-assisted engineering (Vibe Coding) and Generative AI to rapidly prototype functional data-driven software solutions.
  • Analyzed business data and project requirements, translating them into structured AI prompts, schemas, and diagnostic pipelines.
  • Built automated workflows (n8n, Python) to streamline repetitive data operations and reduce operational latency.
  • Tested and validated analytical model outputs to ensure precision, reliability, and business objective alignment.

Applied AI & Data Analysis Specialist

Digilians (الرواد الرقميون) · MTC & MCIT Initiative
Oct 2025 — Aug 2026 (11 mos)
  • Executed comprehensive data cleaning, transformation, and statistical modeling on high-volume real-world datasets.
  • Utilized Power BI, SQL, and Excel to architect executive dashboards, KPIs, and diagnostic business reports.
  • Engineered machine learning pipelines (Scikit-Learn, PyTorch, Computer Vision) for predictive pattern extraction.
  • Contributed to data-driven decision making and workflow automation across digital innovation initiatives.

ERP Technical Support Specialist

DewanSoft · Enterprise Systems
Jan 2025 — Sep 2025 (9 mos)
  • Provided enterprise ERP technical support, diagnosing database inconsistencies, user permissions, and SQL data queries.
  • Prepared and structured operational business data for management reporting, directly improving data accuracy.
  • Collaborated across finance and inventory departments to optimize data workflows and eliminate reporting bottlenecks.
  • Documented and standardized system procedures to ensure efficient, compliant enterprise ERP operations.

Legal Research & Critical Evidence Analysis

Faculty of Law — Cairo University
Sep 2019 — Jul 2022
  • Trained in formal evidence interrogation, statutory interpretation, and eliminating confirmation bias.
  • Transferred legal-grade critical methodology to data analytics: treating raw tables as evidence and validating causal claims before drawing business conclusions.

Education & Certifications

Verified technical certifications and academic foundation in critical logic.

Microsoft

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Microsoft Credential Verification
Verify Official Microsoft Credential ↗
Google

Google Data Analytics Professional Certificate

Google Career Certificates (Coursera)
Verify Official Google Credential ↗
IBM

Machine Learning with Python

IBM (Coursera)
Verify Official IBM Credential ↗
Digilians

Applied AI & Data Analysis Professional Diploma

Digilians (الرواد الرقميون) · MTC & MCIT Initiative
11 Months Intensive Program · Practical Applied AI & BI

Bachelor of Laws (LL.B.)

Faculty of Law — Cairo University
Rigorous Analytical Logic & Compliance

Ready to Discuss High-Impact Solutions?

Available for opportunities and consulting in Applied AI, Workflow Automation, Data Analytics, and ERP Systems.