SQL & Data Warehousing
T-SQL, joins, CTEs, window functions, stored procedures, ETL, Medallion Architecture and dimensional modeling.
Open to Data Analyst & BI opportunities
From pharmacy operations to evidence-driven decisions.
I combine 10+ years of retail pharmacy experience with SQL, Python, Power BI and Tableau to turn complex operational data into clear business decisions.
- 10+
- Years in pharmacy retail
- SQL
- Warehouse & analytics
- BI
- Power BI & Tableau
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.
I am now building hands-on analytics and data warehouse projects that connect technical execution with real operational questions—from branch profitability and inventory availability to insurance performance and customer behavior.
02 / Capabilities
Business Intelligence
Power BI, Tableau, DAX fundamentals, Power Query, KPI design, dashboards 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
Projects built around real business systems.
Transparent progress, documented architecture and links to the work itself.
Pharmacy Enterprise Data Warehouse
An enterprise-scale pharmacy analytics platform integrating simulated ERP, POS, CRM, prescriptions, insurance, inventory, supply chain and delivery data through Bronze, Silver and Gold layers.
- 72 / 72 source-aligned Bronze tables loaded successfully into SQL Server
- 60,234,021 rows loaded with zero failed tables and table-level batch auditing
- Bronze final validation and reconciliation is the active phase before Silver cleaning and conformance
Current progress
Bronze ingestion complete
Architecture
RAW dataset
Bronze ingestion
Validation
Silver / Gold & BI
Project overview
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 ↗Histopathology Image Exploration
An early machine-learning notebook exploring image features, PCA and SVM classification using the UBC Ovarian Cancer dataset.
04 / 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.
- Practical knowledge of retail KPIs, customer behavior, product movement and branch workflows.
- Applying structured problem-solving and analytics to business and operational questions.
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.