Data analytics
Statistical analysis, exploration and trends that support business decisions.
- Performance analysis
- Forecasting & trend analysis
- Data exploration & decision support
DUBAI, UNITED ARAB EMIRATES
Ahmed ShawkyData, Analytics
& Intelligent Systems.
Building analytics products that transform complex operational data into reliable insights, automated workflows, and better business decisions.
Data Analytics · Business Intelligence
Analytics Engineering · Automation
DOMAIN KNOWLEDGE.
ENGINEERING MINDSET.
ENGINEERING MINDSET.
Cross-domain knowledge
+Data & analytics
+Business decisions
01 / THE INTERSECTION
Understanding the business.
Engineering the insight.
Technical analytics capability. Practical business understanding.
My progression from a foundation in pharmacy operations to demand planning, data analytics and BI / analytics engineering connects business understanding with technical delivery. My experience spans healthcare, supply chain, retail / pharmacy and e-commerce.
Today, I develop dashboards, planning portals and automated reporting that connect financial, operational and supply-chain data. My approach combines domain knowledge with Python, SQL, Power BI and a continuing education in computer science.
CORE CAPABILITIES
Business intelligence
Reliable reporting that brings performance into focus.
- Power BI & dashboards
- KPI design & measurement
- Management reporting
Analytics engineering
Validated data foundations for dependable analysis.
- Python · SQL · Pandas
- ETL/ELT & data integration
- Validation & analytics-ready datasets
Automation & data products
Analytics applications that connect insight with everyday work.
- Flask · Streamlit · APIs
- Workflow automation
- Automated reporting
CROSS-DOMAIN KNOWLEDGE
One analytics toolkit.
Multiple business contexts.
Healthcare
Retail & pharmacy
E-commerce
02 / SELECTED WORK
Business problems.
Engineered solutions.
Real applications. Synthetic data.
Explore the case study, then launch the application.
LIVE · INTERACTIVE APPLICATION
Demand Planning & Inventory Optimization Portal
Bringing consumption, inventory, purchasing and forecasts together to support replenishment decisions and stock-risk monitoring.
EXPLORE THE APPLICATION
- Explore consumption and stock
- Review replenishment and inventory health
Interactive portfolio demo using fully synthetic data.
LIVE · INTERACTIVE APPLICATION
Supplier Benefits & Procurement Reconciliation Analytics
An analytics application that compares negotiated item-level bonus and credit-note terms with purchasing receipts and recorded supplier credits, helping users inspect realized benefits, pending gaps and supplier-level performance.
EXPLORE THE APPLICATION
- Compare negotiated terms with purchasing receipts
- Inspect expected and realized benefits, pending gaps and supplier performance
Interactive portfolio demo using fully synthetic data.
LIVE · INTERACTIVE APPLICATION
Digital Purchase Request Tracking Portal
A full-stack procurement application combining PR lifecycle tracking, role-based demo workflows, operational KPIs, PO linkage and deterministic Excel reporting.
EXPLORE THE APPLICATION
- Create, assign and follow a purchase request to PO linkage
- Explore operational analytics and export a filtered report
Interactive portfolio demo using fully synthetic data.
Architecture / Technical Case Study
COGS Data Pipeline & Analytics ETL
A sanitized architecture reference for multi-source extraction and consolidation supporting cost-of-goods-sold analytics.
EXPLORE THE ENGINEERING
- Inspect extraction and transformation design
- Understand validation and consolidation boundaries
Three live interactive applications. One COGS technical case study.
03 / EXPERIENCE
A career grounded
in real business context.
2025/05 – presentDubai, United Arab Emirates
UAE Group Supply Chain Planner and Analyst
Bait Al Batterjee Hospitals Management L.L.C. (Saudi German Health)
Lead healthcare planning, reporting and business analytics. Develop executive Power BI dashboards, centralized demand-planning tools and Python reporting workflows, with data-quality controls and financial reconciliation.
2024/06 – 2025/04Cairo, Egypt
Data Analyst
Digital Business Systems (DBS)- outsourced to DMSCO.
Delivered e-commerce and commercial analytics, forecasting and loyalty-program reporting. Automated extraction, cleaning, validation and Excel reporting using Python, SQL, Pandas and SQLAlchemy.
2021/04 – 2024/06Cairo, Egypt
Demand Planner
El-Ezaby Chain Pharmacies
Developed inventory forecasting models using ARIMA, SARIMA, SARIMAX and Prophet. Built Power BI dashboards and automated reports to support replenishment, stock optimization and planning performance.
04 / TOOLKIT
The tools behind
the thinking.
Technology with a purpose.
Selected capabilities from my professional work.
Business Intelligence & Reporting
Data Analysis & Management
Forecasting & Analytical Methods
Programming & Automation
Databases
Industry Analytics
05 / FOUNDATIONS
Healthcare knowledge.
Computer science foundations.
COMPUTER SCIENCE
Bachelor’s Degree in Computer Science
University of the People
2024/11 – presentIn progress
COMPUTER SCIENCE
Associate Degree in Computer Science
University of the People
2024/11 – 2026/08Completed
HEALTHCARE
Bachelor’s Degree · BS Pharm
Faculty of Pharmacy, Cairo university
2008 – 2014Cairo, Egypt
Continued learning
- ALX DATA SCIENCE
- IBM Data Science Professional Certificate
- Analyzing and Visualizing Data with Microsoft Excel at Microsoft
- Analyzing and Visualizing Data with Microsoft Power BI at Microsoft
- AI augmented professional development skills in digital age at Alx Africa
- CS50 SQL - CS50’s Introduction to Databases with SQL at Harvard University
06 / LET’S CONNECT
Complex data.
Better decisions.
Let’s explore how data analytics, business intelligence
and the systems that support them, drive informed decision-making.