Business Information Systems graduate combining business knowledge with data analytics and technology. I turn business problems into measurable insights and practical solutions, and I have built and shipped my own digital products.
Education
B.Sc. Business Information Systems
July 2026
Arab Academy for Science, Technology & Maritime Transport (AASTMT), Cairo
GPA 3.75 / 4.0 Excellent with Honours
Planning to pursue a master's degree
Planned
Experience
Teaching Assistant
Sep 2026 – Present
AASTMT Cairo
Deliver weekly labs for the AI in Business course and teach hands-on sessions in data cleaning, data modelling and Power BI dashboard design.
Founder & Product Lead
2026 – Present
CareHubs · Healthcare SaaS (Medical ERP), Remote
Founded and launched a live multi-tenant Medical ERP platform for clinics across the MENA region, owning requirements, architecture, delivery and go-to-market.
Quality Assurance Analyst
Aug 2025 – Apr 2026
Untap · Remote, full-time
Ran manual functional and regression testing in an Agile/Scrum team, tracking defects in Jira, and proposed UI/UX improvements adopted by the development team.
Data Analytics Intern
Jan – Feb 2026
Beyti · Cairo, Egypt
Built Power BI KPI dashboards tracking speed, efficiency and utilization across a vehicle fleet, and presented findings to management and an external service provider.
Event Operations
2025 – Present
Tickets Marché · Egypt, seasonal and weekend
Worked 60+ events, including 20+ large-scale MEGA events, managing crowd flow and logistics and resolving on-ground issues in real time.
Events & Talent Management
May 2023 – Jul 2025
Swimaster · Cairo / Alexandria, Co-Manager at North Coast (Jul – Aug 2024)
Organized training camps, open-water swims and charity events, and developed athletes as their coach, tracking performance and attendance in Excel. As Co-Manager, ran daily schedules and swim meets and converted new clients as sales representative.
Skills
Business Intelligence & Analytics
Power BITableauSQLPythonExcel
Business Analysis
Business AnalysisRequirements EngineeringUser StoriesStakeholder AnalysisProcess MappingBusiness Process Analysis
Product & Technology
Node.jsSupabasePostgreSQL
Availability
Cairo, Egypt. Open to relocating, remote work and freelance.
Project snapshots
A quick look at everything. Click a tile to open it.
AI noteI used AI to help brainstorm and to polish the writing and code on these pages.
Products I have founded, built and shipped. They are where I learned how the technical and business sides of a digital product fit together.
AI noteI used AI to help brainstorm and to polish the writing and code on these project pages.
S
Seira
Live e-commerce brand, built end to end.
E-commerceAdmin PanelDashboardsLive Product
Seira is a live e-commerce business selling beach essentials in Egypt, and I built it end to end: the customer storefront, the back office behind it and the reporting on top. The store runs in Egyptian pounds with an Arabic option. The admin panel and dashboards are what let the business run day to day, not just look good online.
Highlights
Live storefront: car seat covers, head shades, beach racket sets
Complex admin panel for running the business behind the store
Dashboards for tracking the business
Built end to end, from product decisions to launch
Multi-tenant clinic management SaaS for MENA clinics.
SaaSMulti-tenantNode.jsSupabasePostgreSQL
A clinic management and online booking platform built for clinics in the MENA region, with Arabic and English support. It brings scheduling, patient records, invoicing and patient communication into one system, with each clinic running as its own tenant on a shared platform.
Gems is a football card game played in real time with friends in online rooms. It has several game modes, so the same room mechanics support different ways to play. I built it as a web app that runs in the browser with nothing to install.
SmartSecure was my graduation project: a full-stack platform where users find a locker on a live map, book it by the hour or day, and unlock it with a one-time code or QR scan. I designed the data model and business rules, then built the Flutter app, the REST API and an admin side for the operator. It is a working end-to-end system rather than a mock-up.
Highlights
Live locker map with location-based search and directions
Bookings with overlap checks, extension, cancellation and delegated access
Wallet top-up and locker pricing by size, per hour and per day
OTP and QR unlock flow, plus in-app notifications and automatic overdue handling
Admin tools: stats, analytics, users, lockers, locations and pricing
Role-based access (customer, admin, technician), JWT auth, English, Arabic and French
AI noteI used AI to help brainstorm and to polish the writing and code on these projects. The numbers are checked against the source files.
01
Raw Data
Sources, files, tables
02
SQL / Python
Clean, join, transform
03
Analysis
Explore, test, segment
04
BI Dashboard
Power BI, Tableau
05
Business Insights
What the data says
06
Recommendations
What to do next
Analysis, SQL and Python
Flagship project
Maven Toys: growth without profit
Business problem: Sales grew 31% year on year but profit only 16%. Where did the margin go?
+30.9%revenue+16.0%profit−3.3 ptsmargin
SQLPythonpandas
Modelled 829,262 sale lines in SQL, cross-checked every figure in Python, and traced the margin fall to a mix shift between two products. Built on the public Maven Analytics dataset, not client work.
Key analytical questions
Is profit growing as fast as sales?
Which products and mix shifts explain the margin change?
Do some store types earn more per store?
Where is stock running out, and what could it cost?
The question: How did American naming habits change from 1980 to 2009, and where did the changes come from?
2.7×more varied19 yrsMichael at #1+12 ptsboys ending in n
SQLPythonpandas2.2M rows
Analysed 98.7 million babies and 22,240 names in SQL, cross-checked every figure in Python, and built a name explorer you can play with. Baby names are not business data, so this one has no business analysis side. Public dataset, not client work.
Key analytical questions
Are names getting more varied, and how much?
Do girls' names change faster than boys'?
Which names appeared from nowhere, and which disappeared?
Business problem: Sales doubled in six months. When do people buy, and what do they buy?
+111%daily revenue46%in 7 to 10am±3%between stores
SQLPythonpandas
Modelled 149,116 sale lines in SQL, cross-checked every figure in Python, and found that the 3 stores earn almost the same money but run very different days. Public dataset, not client work.
Key analytical questions
How much did daily sales grow, and why?
When is the rush in each store?
Does the weekday matter?
What does the menu look like by category and size?
Business problem: Which genres and platforms have sold the most, and where? Do critic scores matter?
50%top 3 genres8%million sellers0.12Mmedian game
SQLPythonpandas
Cleaned a 64,016-row file where only 30% has sales numbers, cross-checked every figure in Python, and found the market is hit-driven and that taste changes a lot by region. Public dataset, not client work.
Key analytical questions
Which genres sell the most, in total and per game?
Turning those requirements into something measurable and useful for decisions.
Where it connects
Data AnalysisKPI DefinitionDashboardsProcess ImprovementBusiness IntelligenceDecision Support
I don't stop at documents. I use business analysis to understand the problem, define what success looks like, and then build the analytical or digital solution around it.
Business analysis projects
Dashboard screenshot coming
Project 1 · Power BI dashboard · scenario on a public dataset
Maven Toys: requirements and Power BI dashboard
Turned the business problem "sales are up, profit is not" into requirements, then into a Power BI dashboard: scope, stakeholders, an AS-IS / TO-BE, a KPI dictionary, business rules, user stories with acceptance criteria, and the dashboard specification it is built to. Dashboard in progress.
Power BIRequirementsStakeholder analysisKPI definitionUser storiesAS-IS / TO-BE
Key focus
10 business rules and 13 KPIs, each defined once
11 functional and 7 non-functional requirements, 7 user stories, 3 use cases
A dashboard spec with a reconciliation table as the acceptance test
Project 2 · Power BI operations dashboard · scenario on a public dataset
Coffee shop: requirements and Power BI operations dashboard
Power BIRequirementsRACIAS-IS / TO-BEUser stories
Turned "we are growing fast and guessing on staffing" into requirements, a current and future process, and a Power BI operations dashboard that managers open every week. A different angle from Maven Toys: process and staffing, not profit.
Key focus
A RACI, business rules and user stories with acceptance criteria
AS-IS and TO-BE for how staff are planned today and how they should be
A 4-page dashboard spec with a reconciliation table as the acceptance test
Project 3 · Power BI market explorer · scenario on a public dataset
Video games: requirements and Power BI market explorer
Power BIDecision framingData limitsTest casesKPI definition
Framed a publisher's decision (which genres and platforms for the next three games), wrote down what the data cannot say, and specified a Power BI explorer with slicers and test cases. A different angle again: exploration and data limits.
Key focus
Decision framing, options and stakeholders
A data limits register (70% of rows have no sales)
Revenue is up 31%. Profit is up 16%. Margin fell 3.3 points.
Comparing the same nine months (Jan to Sep) of 2022 and 2023, because the data ends on 30 September 2023.
Revenue growth
+30.9%
Jan-Sep 2023 vs 2022
Profit growth
+16.0%
Jan-Sep 2023 vs 2022
Margin
29.5% → 26.2%
down 3.3 points
Revenue, all data
$14.4M
Profit, all data
$4.0M
Margin, all data
27.8%
Units sold
1.09M
How I worked
From raw files to a checked answer
01Raw CSVsSales, products, stores, inventory
02SQL clean + modelFix text prices, one spelling, star schema
03Python checksSame numbers in pandas; the script fails if SQL differs
04AnalysisMix, growth, stores, stock
05Power BIBuilt on the business analysis side
06RecommendationsWhat to do next
Finding 1
Revenue climbs while margin slips
Monthly revenue peaked at $884k in March 2023 and stayed well above 2022 levels. Monthly margin moved the other way: it was 30.8% in January 2022 and fell to a low of 25.3% in July 2023, recovering to 27.4% by September. Two charts, not one dual-axis chart, so neither scale can mislead.
Finding 2
It is a mix problem, not a price problem
Every product has one fixed price and one fixed cost in this data, so the blended margin can only move when the sales mix moves. Two products explain most of it. Colorbuds (53% margin) fell from 17.5% to 6.3% of revenue: −2.7 points. Magic Sand (12.5% margin) rose from 0.1% to 12.5% of revenue: −2.1 points. Magic Sand added $108k of profit, so it is a good product with a diluting margin, not a bad one.
Across all 35 products the contributions add up to −3.4 points, matching the actual change. The chart shows the 4 biggest drags and 4 biggest lifts.
Finding 3
Ranking by revenue points at the wrong products
Lego Bricks is the biggest product by revenue ($2.39M) but earns a 12.5% margin, so only 7.4% of profit. Colorbuds alone earns 20.8% of all profit, and the top 5 products earn 47.9%. By category, Toys are 35% of revenue but 27% of profit, while Electronics are 16% of revenue but 25% of profit. Electronics profit fell 39% year on year, which is the Colorbuds story again.
Finding 4
Airport stores earn more each. Downtown is just bigger.
Downtown makes 56% of profit only because it has 29 of the 50 stores. Per store, the 3 airport stores earn about $126k each, roughly 63% more than the other location types (about $77k). Two of them are the most profitable stores in the chain. Friday to Sunday is also 51% of all revenue.
Finding 5
Stock is running out where it costs the most
77 of 1,593 store-and-product pairs (4.8%) are out of stock. The most exposed product is Playfoam, a 64%-margin line that is out of stock in 13 stores. Ranking restocks by money at risk, not by count, puts it first.
Stock value at cost
$300k
Out-of-stock pairs
77 of 1,593
Est. profit at risk / 30 days
$9,685
an estimate, see below
The stock data is a single snapshot with no history. "Profit at risk" assumes each out-of-stock product keeps selling at that store's average daily profit over the last 90 days of data. It is an estimate, not a measured loss.
Look at the code
The SQL behind every number
These are the six scripts behind the numbers, in the order they run. Open one to read it, copy it, or download all of them. They are written for SQLite; the one date function that differs in MySQL is marked in the script.
The Python script that checks them is in the project folder on GitHub.
Recommendations
What I would do next
Investigate Colorbuds first.Units fell 53%, worth about $264k of profit. The data cannot say why, so check availability, supplier and competitor factors before assuming demand fell.
Rank products by profit and margin, not revenue.Review supplier terms or pricing on the 12.5%-margin volume lines (Lego Bricks, Magic Sand). Pair Magic Sand with high-margin lines such as Barrel O' Slime (50%) and Etch A Sketch (48%).
Restock by money at risk.Playfoam first, then Action Figure and Etch A Sketch.
Test more airport-type locations.The per-store gap is large, but the data has no market information, so treat it as a hypothesis to test.
Collect better data.Daily stock history, price and cost history, promotions, and customer or basket data would turn several estimates into measurements.
How much to trust it
Checks and limits
Every figure was calculated twice, in SQL and in pandas. The Python script stops with an error if they ever disagree.
The data is clean: no nulls, no duplicate sale IDs, no orphan store or product IDs. Cost and price were stored as text ("$9.99 ") and were converted; Mexico City was spelled two ways and was standardised.
Prices and costs never change in the data, so price effects cannot be separated from mix effects.
157 of the 1,750 store-and-product pairs are missing from the inventory table (41 of them still sell). I flag them as a data gap, not as zero stock.
No customer, basket, promotion or competitor data, so there is no customer or pricing analysis.
The project files. Everything above comes from three parts, all in the project folder on GitHub:
SQL scriptsThe six scripts shown above.sql/
Python analysisRepeats the whole analysis in pandas, then runs the SQL and stops with an error if the two ever give different numbers.python/analysis.py
Summary dataThe small result tables that the charts on this page are drawn from.data/summary/
Where is the dashboard?
It is the centrepiece of the business analysis project
This page is the analysis. The Power BI dashboard is built from the requirements written on the business analysis side, so that is where it lives, next to the scope, KPI definitions and the specification it was built from.
Business Analysis · Case study
Scenario on a public dataset
Maven Toys: requirements and Power BI dashboard
Understanding the problem before building the solution: the requirements, and the Power BI dashboard they produce.
Power BIRequirementsStakeholder analysisKPI definitionUser storiesAS-IS / TO-BE
This is a scenario, not client work. The stakeholders, objectives and current state are written for the public Maven Analytics dataset to show the business analysis process end to end. The numbers come from the real analysis.
Everything below exists to produce this dashboard. It has five pages, and each page answers one business question. It is built to the specification further down and is accepted only when its totals match the reconciliation table exactly.
PAGE 1Is growth healthy?Revenue, profit, margin and like-for-like growth
PAGE 2What moved the margin?Margin bridge, category and product mix
PAGE 3Who earns the most?Profit per store by location type
PAGE 4Where are we out of stock?Stockouts ranked by profit at risk
PAGE 5How is it defined?KPI dictionary and data notes
IN PROGRESSThe interactive dashboard will be embedded here
Built from the requirements and specification on this page.