Open to Data Analyst & BI opportunities

Pharmacy knowledge.
Analytical clarity.

I combine 10+ years of retail pharmacy experience with SQL, Python, Power BI and Tableau to turn complex operational data into clear business decisions.

Explore the flagship project View / Download CV GitHub

10+: Years in pharmacy retail
6 pages: Live Power BI case study
SQL · BI: Data to business decisions

01 / About

Domain knowledge is my analytical advantage.

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.

My portfolio applies that context to practical analytics work. The flagship Power BI project connects sales, margin, customer behavior, targets and inventory risk. Alongside it, I am developing SQL and Python data warehouse projects with transparent progress. These are independent learning projects using synthetic or public datasets.

02 / Capabilities

SQL & Data Warehousing

T-SQL, joins, CTEs, window functions, stored procedures, ETL, Medallion Architecture and dimensional modeling.

Business Intelligence

Power BI, DAX measures and filter context, Power Query, KPI definitions, interactive reporting, Tableau and business storytelling.

Python & Analysis

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

Business & Domain

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

SQL Server Python Power BI Tableau Excel Git GitHub

03 / Selected work

Business questions.
Work you can explore.

Explore a working dashboard, read the business logic, and see what each project can—and cannot—tell you.

Flagship · Live reportPower BI · Power Query · DAX

Saudi Pharma Commercial Intelligence

A six-page commercial reporting project for a fictional Saudi pharmaceutical distributor. Built to connect sales and margin with customers, sales-agent targets and inventory decisions.

150,000 sales lines and 48,613 invoices across three years
70 DAX measures covering KPIs, rankings, context checks and visual formatting
6 report pages with a guided walkthrough, a metric dictionary and documented limitations

Read the case study ↗Use the dashboard

Independent portfolio project · Synthetic training data · No employer or patient data

Published Power BI Executive Overview dashboard

Explore the interactive report →

Further work & ongoing development

An illustrative arrangement of acerola and guava — Acerola & guava · editorial illustration

Published learning studyPython · pandas · Regression

Vitamin C & Calorie Modeling

Which fruit has the most vitamin C? Explore 7,793 foods across 25 categories through data cleaning, nutrient comparisons, visualization and calorie modeling.

Original DataCamp publication: December 2023. Includes a reproducible review with model assumptions and evaluation limits.

Read the full analysis and code →

Bronze is the current layer; Silver and Gold are planned — Medallion layers · in development

In developmentSQL Server · Python

Pharmacy Enterprise Data Warehouse

An enterprise analytics foundation integrating simulated pharmacy source systems through Bronze, Silver and Gold layers.

Current checkpoint: 72 Bronze tables and 60.2 million rows loaded. Validation and reconciliation precede the Silver / Gold and BI phases.

Explore the development repository ↗

Conceptual diagram of pharmacy sources feeding generated records — Products, sales & stock · synthetic data

Supporting · In progress SQL · Python

Synthetic Pharmacy Data Platform

Building realistic source data for a large pharmacy chain to feed and test the enterprise data warehouse across operational domains.

View development work ↗

Conceptual illustration of image features, PCA and SVM; not model results — Image features · PCA · SVM

Exploratory study Python · ML

Histopathology Image Exploration

An early machine-learning notebook exploring image features, PCA and SVM classification using the UBC Ovarian Cancer dataset.

GitHub ↗ Kaggle ↗

04 / Learning and practice

A documented foundation
in data and analytics.

My DataCamp record brings together Python, SQL, statistics and machine learning, with direct accomplishment links and an applied nutrition analysis.

An illustrative study workspace with an open notebook and laptop — Learning and practice · illustrative workspace.

74Completed courses

7Completed tracks

25Guided project records

397,107Learning XP

Activity verified September 2026. Training completion records include some historical project versions.

Explore learning, projects and credentials ↗

05 / Experience

2015 — Present

Aldawaa Pharmacies

Pharmacist · Retail Pharmacy Operations

10+ years across pharmacy operations, customer care, sales and insurance processes.
Four years in one of the company's major branches, contributing to sales and operational performance.
More than eight years handling branch management responsibilities, alongside customer service, sales and pharmacy operations.
Used sales data analysis to guide branch actions, contributing to a 10% increase in daily sales.

Education Alexandria University

Bachelor of Pharmaceutical Sciences · 2013

Available for the next challenge

Let’s turn operational questions into measurable answers.

Open to Data Analyst, BI Analyst, Reporting Analyst, Retail Analytics and Healthcare Analytics opportunities.