# Abd Elaziz Sabry

Abd Elaziz Sabry is a remote worker on Himalayas, Junior Data Analyst at Pharmacy Chain Sales & Inventory Analysis, based in Egypt.

Source: https://himalayas.app/@abdelazizsabry

```text
Junior Data Analyst who turned pharmacy-chain sales and inventory data into validated KPIs and an interactive Tableau dashboard.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Egypt |
| Authorized to work in | Egypt |
| Salary expectations | 30k+ USD |
| Job categories | Data Analyst |
| Skills | Data Analysis, Data Cleaning, Exploratory Data Analysis, KPI Reporting, Trend Analysis, Data Validation, SQL, MySQL, Join, Aggregation, Subqueries, Common Table Expressions (CTEs), Window Functions, Data Quality Checks, Excel |
| Portfolio | https://github.com/abdelazizsabry7/pharmacy-chain-analysis |

## About

```text
I built a sales and inventory analysis project for a pharmacy chain, turning data from four source datasets into validated, decision-ready insights.

Using SQL, I analyzed revenue, gross profit, transactions, and sales trends across products, branches, and customers. CTEs and window functions helped me calculate month-over-month growth.

I also assessed inventory risk across four branches using stock levels, sales velocity, and days of inventory cover to flag overstocked and stockout-risk products.

I created an interactive Tableau executive dashboard with KPI cards, time-series analysis, branch and category comparisons, and user-controlled filters. My toolkit includes SQL, Excel, Tableau, and Python, alongside my pharmacy education.
```

## Experience

### Junior Data Analyst

[Pharmacy Chain Sales & Inventory Analysis](https://himalayas.app/companies/github)

```text
Cleaned and validated transaction, product, customer, store, and inventory data across four source datasets using SQL. Analyzed $2.54M in revenue and $640.67K in gross profit across 51,203 transactions and 105,594 units sold through 32 SQL analyses.
```

Skills: SQL, Tableau, Data-Cleaning, Data-Validation, KPI-Reporting, Trend-Analysis, CTEs, Window-Functions, Data-Visualization

## Education

### Alexandria University

Bachelor of Pharmacy (PharmD), Pharmacy

```text
Graduated with a Bachelor of Pharmacy (PharmD) from Alexandria University in 2025.
```

### Maven Analytics

Thinking Like an Analyst; Microsoft Excel Foundations; Data Literacy Foundations, Data Analytics

```text
Completed certifications in Thinking Like an Analyst, Microsoft Excel Foundations, and Data Literacy Foundations.
```

### Mahara Tech

Python Programming Basics, Programming

```text
Completed a certification in Python Programming Basics.
```

### DataCamp

SQL Fundamentals and Data Manipulation; Python Fundamentals and Functions, Data Science

```text
Completed certifications in SQL Fundamentals and Data Manipulation, and Python Fundamentals and Functions.
```

## Tech stack

- Tableau
- NumPy
- Pandas
- MySQL
- Python
- Microsoft Excel
- SQL
- Join

To contact Abd Elaziz, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Yousif Naser](https://himalayas.app/@yousifnaser): Medical Activity Officer, Resala Charity Organization
- [Mohammed Abdelnasr](https://himalayas.app/@mohammedabdelnasr): AdventureWorks Sales, AdventureWorks
- [Ahmed Elsayad](https://himalayas.app/@ahmedelsayad): Data Analyst & Power BI Dev, E Commerce Retail Store
- [Ahmed Mahmoud](https://himalayas.app/@ahmedmahmoud6): Performance Analyst, Orange Egypt
- [Mohamed Essam](https://himalayas.app/@mohamedessam6): Entry Level Data Analyst, Self Employed
- [Youssef Abdelwadoud](https://himalayas.app/@youssefabdelwadoud): Data Analyst, The Bar Method
- [Moamen Taha](https://himalayas.app/@moamentaha): Data Entry Specialist, Future Trading
- [Mateo Magdy](https://himalayas.app/@mateomagdy): Pharmacy Operations & Data Specialist, Pharmacy Operations
- [Mohamed Rafaat](https://himalayas.app/@mohamedrafaat): Customer Behavior Analysis Dashboard, Self directed project
- [Hassan Sakkoury](https://himalayas.app/@hassansakkoury): Data Analysis Instructor, Easily
