Bassem Sherif
Dar El Salam
Summary
Results-driven pharmacist with a strong track record at Misr Pharmacies, specializing in sales analysis and dashboard creation using Microsoft Excel and Power BI. Expertise in data visualization has led to enhanced product availability and optimized sales strategies, resulting in significant improvements in sales performance through precise KPI monitoring. Exceptional analytical skills paired with effective communication facilitate collaboration and drive results.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Hospital Pharmacist
Kasr Al Aini Hospital
Manial, Cairo
08.2019 - Current
- Coordinated with medical staff to manage medication shortages, finding suitable alternatives without compromising care.
- Secured drugs against theft, loss, or mismanagement by setting and enforcing effective procedures.
- Provided medication and pharmaceutical services to inpatients and outpatients.
Pharmacist
Misr Pharmacies
Maadi, Cairo
06.2019 - 08.2024
- Besides my duties as a Senior Pharmacist, I was responsible for:
- Preparing Sales sheet.
- Creating Dashboard to monitor sales.
- Screening of sales KPIs.
- Making comparisons through pivot tables, power queries, DAX and power pivots.
- Creating Excel Pivots with data extracted from SAP to spot product availability in warehouses and our branch to increase sales.
- Creating Pivots to spot our top products sales and their quantity to make them available and the lowest products sales to work on them.
Education
Bachelor - Pharmaceutical Science
Cairo University
Cairo, Egypt05-2017
Skills
- Microsoft Excel
- Google Sheets
- Microsoft Power BI
- Tableau
- Google Data Studio
- Python
- SQL
- ETL processing
- Dashboard Creation
- Sales analysis
- Data visualization
Certification
- Excel/VBA for creative problem solving, Coursera, 01/01/25
- Certified Data Analyst Professional by Google, Coursera, 01/01/25
- Certified Data Analyst Professional, Epsilon AI, 03/01/24 - 10/01/24
- Data Analysis Professional Track, EgFWD, 07/01/22
- Data Analysis Challenger Track, EgFWD, 03/01/22
Languages
- Arabic, Native
- English, Fluent
Personal Information
Date of Birth: 03/10/92
Title
Data Analyst | Pharmacist
Timeline
Hospital Pharmacist
Kasr Al Aini Hospital
08.2019 - Current
Pharmacist
Misr Pharmacies
06.2019 - 08.2024
Bachelor - Pharmaceutical Science
Cairo University
Similar Profiles
Ahmed Aid Saied MohamedAhmed Aid Saied Mohamed
Intern Doctor at Kasr Al Aini HospitalsIntern Doctor at Kasr Al Aini Hospitals
Mohamed TaherMohamed Taher
Maxillofacial Surgeon at Kasr Al Aini Medical SchoolMaxillofacial Surgeon at Kasr Al Aini Medical School
Omar AlsayadOmar Alsayad
Dental Intern at Kasr El Aini Teaching HospitalDental Intern at Kasr El Aini Teaching Hospital