Hi, I'm Omar Alghannam

AI & Data Engineer  |  SQL & Database Systems  |  BI & Analytics

6th of October, Giza, Egypt

Email Phone LinkedIn GitHub Download CV
{
}
SQL
Omar Alghannam

About Me

Building Data Systems
From the Ground Up

I am a Data Engineer & Full-Stack Developer with a deep passion for SQL, relational database design, and machine learning. I've built a mini DBMS from scratch — complete with B+ Tree indexing, ACID transactions, and WAL recovery — and developed robust full-stack platforms ranging from real-time ride-hailing systems to AI-powered recommendation engines.

My focus is on transforming raw data into reliable, queryable, and insightful systems. From designing normalized schemas and writing complex SQL queries to deploying machine learning pipelines and BI dashboards with real-time filters, I bring both engineering rigor and analytical thinking to every project.

6+
Major Projects
5+
Languages
10+
Visualizations Built
3+
Years Coding

Featured Work

Projects

A selection of database engines, backend systems, and analytics dashboards I've engineered.

AI / Machine Learning

CineMatch AI – Recommendation Engine

A robust movie recommendation platform powered by a 3-stage machine learning pipeline and a FastAPI + React architecture.

My Work Developed a 3-stage recommendation pipeline (Retrieval, Filtering, Ranking), integrated a vector database, and built the FastAPI backend.
Results High-performance ML predictions with optimized ranking metrics (NDCG, Precision/Recall) surfaced through a seamless Vite-powered frontend.
Python FastAPI React & Vite Vector DB
View Details → Source Code
Backend System

Mowasla – Ride-Hailing System

Full backend connecting passengers & drivers in real-time with complete ride management, payments, and admin panel.

My Work Database schema, backend logic, admin panel, real-time ride handling, fare estimation
Results Complete passenger & driver system with admin monitoring, wallet, and rating features
C# SQL Visual Studio ADO.NET
View Details → Source Code
Full-Stack Web App

CostStruct – Construction Expense Tracker

A professional, bilingual (EN/AR) construction expense tracker handling project budgets, labor, materials, and equipment.

My Work Developed a secure React app backed by Firebase real-time database, with RTL support, authentication, and multi-format exports.
Results Interactive dashboard featuring 6 management sections, AMCharts 5 visualizations, and automated alerts for budgets exceeding 85%.
React 19 & Vite Firebase AMCharts 5 Tailwind CSS
View Details → Source Code
BI Dashboard

Premier League Analytics Dashboard

Interactive SQL-powered dashboard analyzing the 2023–24 Premier League season with 10 advanced visualizations.

My Work SQL data extraction, dynamic filters, interactive charts (bar, donut, scatter, area, lollipop)
Results 10 visualizations with dynamic filters; insights on player efficiency, club ROI, and revenue
SQL Server Python AmCharts 5 HTML/CSS
View Details → Source Code

Technical Arsenal

Skills & Tools

Programming

SQL C# Python C++ C JavaScript HTML/CSS

Tools & Platforms

Visual Studio VS Code SQL Server Git Google Colab PyCharm Pandas AmCharts 5

Concepts

Database Design Indexing (B+ Trees) ACID Transactions Normalization Data Governance BI Dashboards Data Pipelines OOP Web Scraping REST APIs

Recognition

Achievements

Certificate of Participation – 20th UGRF

Undergraduate Research Forum, Nile University, Egypt

Project: Cleaning System Robot

August 2025

B.Sc. in Data Science & AI

Zewail City of Science and Technology — Currently pursuing (Sep 2024 – May 2028)

Expected May 2028

Robotics Course – Arduino Projects

Line follower, obstacle-avoiding robot, Bluetooth-controlled navigation, MPU6050 & nRF24L01 integration

July 2025