Open to Junior Data Engineer & Data Analyst roles

I find where pharmacy
chains lose money.

A pharmacist with 11+ years in Saudi retail pharmacy. I build the data pipelines and dashboards that turn sales, stock and staff records into one clear answer: where the money goes, and what to do next.

114M SAR
Hidden loss found in a 1,000-branch chain
11+
Years inside Saudi retail pharmacy
2 case studies
Each one: the problem, the cause, the fix

Problems I solved.
Proof you can open.

Each project in three lines: the problem, what I built, and the result. All data is practice data built to behave like a real Saudi company: no employer or patient data.

Flagship · CompletedMicrosoft Fabric · PySpark · SQL · Power BI

Why a growing pharmacy chain loses money

Problem: a 1,000-branch chain sold more every year and still lost money. What I did: followed every sale from the till to one clear report. Result: the chain was paying more for 248 products than it sold them for.

  • 114M SAR lost on those 248 products (2020–2025); every other product earns about 33%
  • A fix for each product: the supplier discount needed to make it profitable again
  • No one blamed without proof: 7 fraud patterns checked, none found

No sign-in needed · See the code ↗

Products page: 248 products cause 23.97 million SAR loss in 2025See where the money goes →
01 / Ingest

Lakehouse · PySpark

72 source tables, 60,234,021 rows, reconciled to the raw files with a difference of 0.

02 / Model

Warehouse · T-SQL

Star schema: 9 dimensions, 9 facts. 23 stored procedures rebuild it in about 2 minutes. In Git.

03 / Report

Power BI · Direct Lake

6 pages, measures in TMDL, under 2 seconds per visual.

04 / Real time

Eventstream · KQL · Activator

Receipts from 18 branches, minute by minute. In a test, a branch stopped at 10:26 and the alert email arrived at 10:31.

Read the technical details ↗

Live reportPower BI · Power Query · DAX

Why a drug distributor missed its target

Problem: a Saudi drug distributor reached 97.2% of target, SAR 7.0M short. What I did: a 6-page Power BI report on sales, targets, discounts and stock. Result: the sales team was not the cause; discounts (2x the gap) and stock in the wrong place were.

  • 68 of 72 agents within 5% of target: a shared cause, not weak people
  • SAR 14.1M in discounts against a SAR 7.0M gap
  • 27 stockouts while SAR 825K of stock was near expiry
Published Power BI Executive Overview dashboardExplore the interactive report →

Next project

Conceptual diagram of pharmacy sources feeding generated records
Products, sales & stock · synthetic data
Supporting · In progress SQL · Python

Synthetic Pharmacy Data Platform

Realistic practice data for a large pharmacy chain (products, sales and stock), used to test the next reports before they reach a manager.

View development work ↗

Earlier learning studies: Vitamin C & calorie modeling (Python) · Histopathology image study (ML) · All learning work

Shamseldeen Ismaiil

A pharmacist who speaks data.

I have worked at Aldawaa Pharmacies since 2015 across customer service, sales, insurance workflows and branch operations. That experience gives me practical context for the numbers behind retail and healthcare decisions.

I now build the data side of that work: pipelines that move and check millions of records, warehouses that keep one version of the truth, and reports that answer a manager’s question in one sentence. My projects use synthetic or public data, and every number is reconciled.

In plain words: I collect messy business data, check that every number adds up, and turn it into a report a manager can act on. The tools below are how I do it.

01

Data Engineering

Microsoft Fabric, PySpark, Delta Lake, T-SQL stored procedures, Medallion architecture, star schemas, reconciliation and Git.

02

Business Intelligence

Power BI (Direct Lake, DAX, TMDL), dashboard design that answers one question per page, Tableau and data storytelling.

03

Python & Analysis

Pandas, NumPy, data cleaning, exploratory analysis, visualization and analytical automation.

04

Business & Domain

Retail analytics, pharmacy operations, insurance workflows, sales, customer service and inventory KPIs.

Microsoft Fabric PySpark SQL Server Python Power BI Tableau Excel Git GitHub
2015 — Present

Aldawaa Pharmacies

Pharmacist · Retail Pharmacy Operations

  • 11+ years across pharmacy operations, customer care, sales and insurance processes.
  • Five years in a major branch, four as pharmacist-in-charge of a two-person team: built relationships with nearby hospitals; insurance sales grew about 3x and branch sales about 75%.
  • About 9 years as pharmacist-in-charge across three branches, leading the branch team and fellow pharmacists by example.
  • Current branch: raised daily sales about 13% for three months by fixing stock-outs and merchandising, and co-led a full branch relocation (about 5,000 items counted in 5 days, reconciled with pivot tables).
  • Used sales data analysis to guide branch actions, contributing to a 10% increase in daily sales.
Education Alexandria University

Bachelor of Pharmaceutical Sciences · 2013

74 completed DataCamp courses and 7 tracks in Python, SQL and statistics. See credentials and practice projects ↗

Available for the next challenge

Let’s find where your data hides the money.

Open to Junior Data Engineer, Data Analyst and BI roles, in healthcare, retail and beyond.