Abdelrahman Ali
Performance Analyst
New Cairo
Summary
Dynamic Performance Analyst with a proven track for enhancing business intelligence through advanced SQL and Power BI development. Skilled in quantitative analysis and adaptive learning, excelling in transforming data into actionable insights, fostering a culture of continuous improvement and data-driven decision-making.
Overview
13
13
years of professional experience
6
6
Certifications
Work History
Performance Analyst
Cartona For Information Technology
07.2023 - Current
- Collaborated with cross-functional teams to develop and implement performance improvement initiatives.
- Advanced organizational goals by designing, monitoring, and refining key performance metrics aligned with business objectives.
- Enhanced performance analysis by developing advanced SQL queries to create visualization dashboards.
- Proactively share knowledge and promote a data-driven culture.
Power BI Developer
ProAnalytix
01.2023 - 06.2023
- Organized business meeting to address client needs.
- Consulted clients for the best BI tool to achieve their targets.
- Data cleansing, modelling to be ready for analysis.
- Designed Power BI dashboard for better visualization of client’s project insights.
- Provided induction session to familiarize the client with utilization of the dashboard.
- Followed-up with the client for further inquiries.
Pharmacy Manager
Nawah Pharmacy
10.2021 - 12.2022
- Boosted store profitability through strategic pricing adjustments and cost-control measures.
- Maximized employee productivity through effective scheduling, delegation of tasks, and ongoing feedback on performance goals.
- Addressed customer complaints or issues in a timely manner, demonstrating empathy and commitment to exceptional service standards.
- Managed pharmacy inventory for optimal product availability and reduced waste.
Retail Pharmacist
Al-Dawaa Medical Service Company Ltd (DMSCo)
05.2018 - 09.2021
- Developed strong relationships with customers by addressing their concerns and providing personalized service.
- Contributed to revenue growth through effective cross-selling of over-the-counter medications and health products.
- Entered orders into database, verified insurance and prepared medications.
Pharmacy Manager
Omnia Ali Phrmacy
12.2015 - 04.2018
- Analyzed pharmacy sales data, resulting in a remarkable 75% increase in average daily sales, showcasing the direct impact of data-driven insights on business performance.
- Monitored and managed pharmacy staff performance to maximize productivity and customer satisfaction.
Researcher
Prof. Leif Kirsebom Group, Uppsala University
09.2014 - 09.2015
- Gathered and organized information for research purposes.
- Performed statistical, qualitative, and quantitative analysis.
- Utilized statistical packages to analyze data and create visualizations.
- Maintained detailed records of experimental procedures, observations, and results for accurate reporting and replication purposes.
- Effectively communicated research findings and insights to diverse audiences through engaging presentations delivered in seminar settings.
Retail Pharmacist
El Enany Pharmacy
12.2011 - 07.2013
- Provided advice on health issues, symptoms, and medications.
- Administered prescription medications to public.
Education
Master of Science - Cellular And Molecular Biology
Uppsala University
Uppsala, Sweden 04.2001 -
Bachelor of Science - Pharmaceutical Sciences
Faculty of Pharmacy, Ain-Shams University
Cairo, Egypt 04.2001 -
Skills
Power BI Development
SQL Proficiency
Business Intelligence
Excel expertise
Python Programming
Quantitative Analysis
Statistical modeling
Adaptive Learning
Projects
Three USA cities Bike-Share Data Analysis Investigate Medical Appointments Dataset
CS50’s Introduction to Programming with Python [20 Dec 2022]
• Imported data from csv files using the Pandas library in Python.
• Performed statistical analysis and calculated descriptive statistics using NumPy and Pandas.
• Created an interactive experience in the terminal for users to learn about bike share data in three major USA cities.
Links: https://github.com/AbdMoh88/CS50P/tree/main/project | https://www.youtube.com/watch?v=cVxzEO19HgE
Udacity Data Analysis Professional Nanodegree Program [15 Nov 2022]
• Posed questions that can be answered with a given dataset.
• Investigated problems in a dataset, wrangled data into a usable format.
• Communicated results of an analysis, using vectorized operations in NumPy and Pandas to speed up code.
• Utilized Matplotlib to produce plots showing findings.
• Successfully completed a comprehensive data analysis curriculum.
Link: https://github.com/AbdMoh88/Medical-Appointments-project
Certification
Data Analysis and IT Support Training - [UN-ESCWA Technology Centre training program]
07-2024
SQL for Data Science [UC Davis]
03-2024
CS50’s Introduction to Programming with Python [Harvard Open Courseware]
12-2022
Data Analysis Professional Nanodegree Program [Udacity]
12-2022
Power BI – Beginner to Intermediate [ProAnalytix]
11-2022
Biostatistics [Doanex]
06-2020
Timeline
Data Analysis and IT Support Training - [UN-ESCWA Technology Centre training program]
07-2024
SQL for Data Science [UC Davis]
03-2024
Performance Analyst
Cartona For Information Technology
07.2023 - Current
Power BI Developer
ProAnalytix
01.2023 - 06.2023
CS50’s Introduction to Programming with Python [Harvard Open Courseware]
12-2022
Data Analysis Professional Nanodegree Program [Udacity]
12-2022
Power BI – Beginner to Intermediate [ProAnalytix]
11-2022
Pharmacy Manager
Nawah Pharmacy
10.2021 - 12.2022
Biostatistics [Doanex]
06-2020
Retail Pharmacist
Al-Dawaa Medical Service Company Ltd (DMSCo)
05.2018 - 09.2021
Pharmacy Manager
Omnia Ali Phrmacy
12.2015 - 04.2018
Researcher
Prof. Leif Kirsebom Group, Uppsala University
09.2014 - 09.2015
Retail Pharmacist
El Enany Pharmacy
12.2011 - 07.2013
Master of Science - Cellular And Molecular Biology
Uppsala University
04.2001 -
Bachelor of Science - Pharmaceutical Sciences
Faculty of Pharmacy, Ain-Shams University
04.2001 -
Similar Profiles
Hao Yuan (Mark) ChenHao Yuan (Mark) Chen
Research Engineer at Institute for Information Industry (III) / Taiwan Association of Quantum Computation and Information Technology (TAQCIT)Research Engineer at Institute for Information Industry (III) / Taiwan Association of Quantum Computation and Information Technology (TAQCIT)
Shakibu Mussa NsekelaShakibu Mussa Nsekela
Senior Accounts Officer at Ministry of Information, Communication and Information TechnologySenior Accounts Officer at Ministry of Information, Communication and Information Technology
Daniel NaderDaniel Nader
Senior Technology Consulting Specialist at King Abdullah University of Science & Technology (KAUST), Information Technology Services DepartmentSenior Technology Consulting Specialist at King Abdullah University of Science & Technology (KAUST), Information Technology Services Department
ASHRAF EL-GHOULASHRAF EL-GHOUL
Section Head - Natural Gas Projects and Business Development - EU project Management Unit at Egyptian Natural Gas Holding Company "EGAS"Section Head - Natural Gas Projects and Business Development - EU project Management Unit at Egyptian Natural Gas Holding Company "EGAS"
Nancy AzzamNancy Azzam
CEO at Eunoia Marketing SolutionsCEO at Eunoia Marketing Solutions