Hi, I'm Omar Alghannam

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

6th of October, Giza, Egypt

Email Phone LinkedIn GitHub Upwork Download CV
{
}
SQL
Omar Alghannam

About Me

Building Data Systems
From the Ground Up

I specialize in building intelligent systems, analytics dashboards, and data pipelines that actually work in production.

Drawing from my experience as a freelance AI & Data Science Engineer and my Microsoft DEPI training, my focus is on turning complex business problems into clean, scalable solutions. Whether it's architecting a recommendation engine, fine-tuning an LLM, or designing an interactive BI dashboard—I care about the output being useful, not just functional.

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.

Data Engineering / Analytics

Road Accident Analytics Platform

End-to-end data engineering pipeline analyzing road accident data with interactive BI dashboards and predictive insights.

My Work Built the full ETL pipeline, data modeling, and interactive visualization layer for road accident analysis.
Results Actionable insights on accident patterns, hotspots, and contributing factors surfaced through dynamic dashboards.
Python SQL Pandas BI Dashboard
Source Code

Confidential Client Project

AI / LLM Fine-Tuning

Gemma-4 Fine-Tuning Pipeline

Production-grade LLM fine-tuning pipeline for Gemma-4 with custom dataset preparation, LoRA adapters, and evaluation framework.

My Work Designed and implemented the full fine-tuning pipeline including data preprocessing, LoRA configuration, training, and evaluation.
Results Significant improvement in task-specific performance metrics over the base Gemma-4 model.
Python Gemma-4 LoRA HuggingFace
Confidential
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
Source Code
Information Retrieval

Football Search Engine

A domain-specific search engine for football data, enabling fast and accurate retrieval of player, team, and match information.

My Work Built the indexing pipeline, query processing logic, and ranking algorithms for football-specific information retrieval.
Results Fast, relevant search results across a large football dataset with optimized retrieval performance.
Python Information Retrieval NLP
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
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
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
Source Code

Technical Arsenal

Skills & Tools

Languages & Frameworks

Python SQL C# FastAPI React JavaScript HTML/CSS

Data Engineering & Cloud

Azure Data Factory Azure Synapse Databricks SQL Server ETL Pipelines BI Dashboards Pandas Git

AI & Machine Learning

LLM Fine-Tuning RAG Systems Vector DBs Agentic Pipelines Machine Learning NLP HuggingFace Data Modeling

Recognition

Achievements

Microsoft Data Engineer – DEPI Internship

Digital Egypt Pioneers Initiative (DEPI) · Remote

Training in building and managing modern data systems with Azure Data Factory, Azure Synapse Analytics, and Databricks.

Dec 2025 – Present

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