Ahmed Essam
Verified Expert in Engineering
Data Analyst and Software Developer
Cairo, Cairo Governorate, Egypt
Toptal member since January 10, 2024
Ahmed is a senior data analyst proficient in Power BI, SQL, Python, and Databricks. He is experienced in consulting, telecommunications, and eCommerce and has delivered insightful data analysis and visualizations to optimize operations and inform critical business decisions. Ahmed is looking forward to his next challenge!
Portfolio
Experience
- Google Sheets - 4 years
- Excel 365 - 4 years
- Microsoft Power BI - 3 years
- SQL - 3 years
- Python - 2 years
- Looker Studio - 2 years
- Alteryx - 1 year
- Azure Databricks - 1 year
Availability
Preferred Environment
Windows, SQL, Databricks
The most amazing...
...thing I've done is automate a data validation process that consumed nearly four hours a day from three team members.
Work Experience
Senior Data Analyst
PwC
- Leveraged Alteryx's data manipulation and cleaning capabilities to prepare complex datasets for efficient analysis and visualization.
- Designed impactful and informative dashboards and reports using Microsoft Power BI, empowering stakeholders to extract actionable insights from data.
- Conducted an ad-hoc business analysis, generating reports, forecasts, and visualizations that uncover hidden patterns and trends, ultimately delivering key business insights.
Senior Data Analyst
Retail eCommerce Ventures
- Designed, developed, and maintained dashboards, reports, and systems using Microsoft Power BI, Looker, Salesforce, and sometimes Google Sheets to show performance and KPIs indigestible formats for brands' executives to enable effective decision-making.
- Launched and created a business performance management system using Google Sheets, making it 100% automated and free for operations KPIs, collecting, optimizing, and analyzing performance on the department level for 250+ employees.
- Led a team of four business intelligence analysts. We were in charge of reporting and analysis for more than nine eCommerce brands under retail eCommerce ventures, including RadioShack, Pier 1, Dressbarn, and Modell's Sporting Goods.
Reporting Analyst
Blue Modo Media
- Conducted daily, weekly, and monthly analyses of the email marketing performance, identifying key trends and insights to improve campaign performance and optimize return on investment (ROI).
- Utilized advanced Excel functions and data visualization tools to create reports and dashboards that communicated performance metrics to stakeholders.
- Conducted an ad-hoc analysis and provided recommendations to optimize email marketing campaigns based on performance data.
Experience
Visualizing Space Exploration Data
https://lnkd.in/dwQZx-CfI applied some color theory and typography principles to make the report aesthetically pleasing and easy to read.
Databel Customer Churn Analysis and Visualization
https://www.linkedin.com/feed/update/urn:li:activity:7054950245545254912/I wanted to understand why customers were leaving and what could be done to prevent it. I delved deep, discovered some intriguing factors contributing to high churn rates, and identified how various types of customers were churning.
Education
Bachelor's Degree in Mechanical Engineering
Alexandria University - Egypt, Alexandria
Certifications
Alteryx Designer Core Certification
Alteryx
Excel Skills for Business Forecasting
Coursera
Skills
Tools
Google Sheets, Microsoft Power BI, Google Slides, Power Query
Languages
SQL, Python
Paradigms
ETL
Platforms
Alteryx, Windows, Databricks
Other
Excel 365, Data Analysis, Looker Studio, Azure Databricks, Analysis, Mathematical Analysis, Calculus, Statistics, Data Visualization, Data Cleaning, Data Manipulation, Data Mining, Forecasting
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring