Ahmed Hany
Data Analyst & Power Bi Engineer
New Cairo,C
Summary
Results-driven data analyst and problem-solver with a passion for continuous learning and applying advanced data technologies. Proficient in SQL, Power BI, and other tools, leveraging expertise to assist businesses in uncovering valuable insights and making data-driven decisions. Known for adapting quickly to new challenges, excelling in fast-paced environments, and consistently delivering exceptional results.
Overview
23
23
years of professional experience
15
15
years of post-secondary education
10
10
Certifications
Work History
Freelancer, Data Analyst
Multiple Clients
New Cairo, Cairo Governorate
6 2021 - Current
- As a freelance data analyst, I successfully delivered solutions for numerous clients by leveraging my expertise in Python, Excel, SQL, Power BI, Power Apps, and Power Automate. I have a proven track record of:
- Analyzing complex datasets to identify trends and patterns.
Visualizing data effectively using Power BI, Python, and Tableau to communicate insights.
- Solving business problems through innovative applications of the Power Platform and AI technologies.
- For example, I implemented a Power BI dashboard that increased sales by 15% for a retail client by providing actionable insights into customer behavior."
Solutions Architect and Delivery Director DPL
DPL Systems
New Cairo, Cairo Governorate
01.2023 - Current
- As a solutions and design architect at a digital transformation agency, I played a key role in:
- Developing tailored solutions to meet client needs and maximize business potential.
- Securing three major contracts through successful presales activities.
- Leading the implementation of multiple ERP systems.
- Overseeing the design and integration of an aluminum manufacturing automation solution.
- Architecting an MS 365 environment for automating NGO operations using Power Apps and the MS Power Platform.
Functional Team Lead MBS
MBS
Cairo, Cairo Governorate
12.2021 - 01.2023
- As Retail and Supply chain Team leader I Lead My team to meet customers' expectations, I was able to secure the following: Deliver full upgrade for Ghaya pharmacies from MS AX 2012 to D365 F&O
- Secure Implementation for Royal Pharma Group Kuwait
- Set the project scope and fulfill the analysis and design phase for the Energya - Elsweedy project.
Senior Functional Consultant
ElRaed
Cairo, Cairo Governorate
12.2020 - 11.2021
- Retail and Supply chain Ego group Egypt Go live project: where: I helped the customer through the go-live supporting the day-to-day business activities
- Setup and configuration of different branches
- Build the user's system security and rules
- Build the needed reports by different business users including but not limited to sales, logistics, stock, and procurement reports (using Excel and Power BI and connecting to the D- 365 F&O data entities)
- Government Digital transformation project, system architecture, and design in supply chain and retail
- Designed and implemented a power app to generate new items’ codes based on customer rules that were not possible in the D365 environment, and then upload the new item into D365 F&O
- Designed and implemented the Retail and supply chain implementation
- Delivered training and day-to-day support for the system users that helped increase the performance of those departments.
Operation Manager
Normandy Pharmacies
Cairo, Cairo Governorate
11.2019 - 05.2020
- As Operations Manager, I successfully led a turnaround of the pharmacy business by:
- Implementing contingency plans to mitigate the impact of a declining market.
- Developing standardized operating procedures (SOPs) to improve efficiency and consistency.
- Establishing a balanced scorecard system using SQL, Excel, and Power BI to evaluate employee performance.
- Decreasing sales costs by 20% through a new target policy that aligned with business unit, line of business, and customer segment-specific needs.
IS Manager
Normandy Pharmacies
Cairo, Cairo Governorate
06.2016 - 09.2019
- Created and implemented Data warehouse to allow for Sales analysis from legacy systems, dashboards by Power BI and Excel to MS SQL database
- Planned and partially executed digital transformation plan
- Website
- Facebook page
- ERP system
- Paperless Company
- Manage and Train Employees for the new work environment.
Project Manager
Normandy Pharmacies
Cairo, Cairo Governorate
06.2012 - 06.2016
- Successfully implemented and upgraded Microsoft Dynamics AX 2012 from RT to R3 CU10, driving improved efficiency and data accuracy within the organization.
Branch Manager
Normandy Pharmacies
Cairo, Cairo Governorate
12.2009 - 06.2012
- As Branch Manager, I consistently led the team to exceed sales targets by an average of 15% over a three-year period, even during the economically challenging year of 2011. My exceptional leadership and strategic planning resulted in a promotion to a higher position within the organization.
- As part of my daily routine, I leveraged Excel to conduct in-depth analyses of sales and stock data, leading to improved operational efficiency and increased sales performance.
Long irrelevant History
12.2001 - 06.2009
- Along history that is irrelevant to this title, yet It helped shape my personality and made me who I am today.
Education
Computer science IS – Masters -
AASTMT
Cairo, C 01.2018 - Current
Computer science IS – Diploma -
AASTMT
Cairo, C 01.2015 - 01.2018
Bachelor of Science (B.Sc.) -
Faculty of Pharmacy, Cairo University
Cairo, C 09.1996 - 06.2001
Skills
SQL admin, and querying
Developing Data science and machine learning skills
Back-End: Some C#, MVC, C and Python
Front-End: Some web development HTML, CSS, and WordPress
MS Dynamics Trade, Finance, configuration, retail, data import & export
System analysis, Requirement collection and analysis
Soft skills: communication, time management, organization, leadership & management
MS Office suite MS project
Data Analysis
Data Visualization and Presentations
Data Validation
Data Cleaning
Certification
Microsoft Power Bi Engineer, DEPI – MCIT, 10/01/24
Languages
Arabic
Proficient
C2
English
Advanced
C1
Projects
Multiple AX 2012 Implementation Projects Multiple D 365 F&O Implementation Projects Integration Projects: Integrating D365 F&O with D365 CRM, Integrating Power BI with D365 Multiple Dashboard Design and Implementation: Reports and Dashboards For fashion business – Xrm ToolBox, Power bi and D365 F&O, Reports and Dashboards for Retail business – Power bi and D365 F&O, Multi-source Reports and Dashboards for IT services business – SQL, Excel, Power-Bi, and AX 2012 and D365. Asset Tracking System – Power Apps SMS, LMS based on Microsoft Education Accelerator, Power Platform Personal Projects: BikeStore Sales analysis and dash boards design, Online-Retail Store analysis and dash boards design, Stock Market Analysis and dashboards design, Covid-19 Prediction using python, Twitter Sentiment analysis covid-19, Customers churn analysis and dashboards design
Affiliations
Medicine For All Cofounder:
Medicine for All help those of need through collecting extra medication from people, recycle them and redistribute them for other patients in need. we have managed over the past 5 years to recycle more than 6o million worth of medication in Egypt
Timeline
Solutions Architect and Delivery Director DPL
DPL Systems
01.2023 - Current
Functional Team Lead MBS
MBS
12.2021 - 01.2023
Senior Functional Consultant
ElRaed
12.2020 - 11.2021
Operation Manager
Normandy Pharmacies
11.2019 - 05.2020
Computer science IS – Masters -
AASTMT
01.2018 - Current
IS Manager
Normandy Pharmacies
06.2016 - 09.2019
Computer science IS – Diploma -
AASTMT
01.2015 - 01.2018
Project Manager
Normandy Pharmacies
06.2012 - 06.2016
Branch Manager
Normandy Pharmacies
12.2009 - 06.2012
Long irrelevant History
12.2001 - 06.2009
Bachelor of Science (B.Sc.) -
Faculty of Pharmacy, Cairo University
09.1996 - 06.2001
Freelancer, Data Analyst
Multiple Clients
6 2021 - Current