Hi there! I’m Mohamed Ali

Get in touch

<aside> <img src="/icons/mail_gray.svg" alt="/icons/mail_gray.svg" width="40px" /> Email

</aside>

<aside> <img src="/icons/phone-call_gray.svg" alt="/icons/phone-call_gray.svg" width="40px" /> Phone

</aside>

Skill Sets

Programming Languages & Analysis Tools: Python (Pandas, NumPy, BeautifulSoup), SQL, Microsoft Excel, Power Query, DAX

Database Systems: MySQL, SQL Server Management

BI & Visualization: Power BI, Google Looker Studio, Python (Matplotlib, Seaborn, Plotly, Dash)

Core Competencies: Data Mining, ETL Processes, Data Cleaning & Wrangling, Exploratory Data Analysis (EDA), Statistical Analysis, Data-Driven Decision Making

Soft Skills: Teamwork & Collaboration, Critical Thinking, Analytical Thinking, Business Acumen

Certifications

<aside> <img src="attachment:f7481526-acbd-49ec-b347-a7bc723f5dd0:6154722.png" alt="attachment:f7481526-acbd-49ec-b347-a7bc723f5dd0:6154722.png" width="40px" /> Microsoft Power BI Data Analyst Professional Certificate

</aside>

<aside> <img src="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80bb-a166-007a0d34a36f" alt="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80bb-a166-007a0d34a36f" width="40px" /> IBM Data Analyst Professional Certificate, Coursera

</aside>

<aside> <img src="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-8012-8b5c-007a1e4fec2e" alt="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-8012-8b5c-007a1e4fec2e" width="40px" /> Microsoft Data Analysis Certification, LinkedIn Learning

</aside>

<aside> <img src="attachment:12757ffa-71f7-44eb-8d98-58b89fef985e:cec60480-04a9-11eb-80c4-df7359d94047.png" alt="attachment:12757ffa-71f7-44eb-8d98-58b89fef985e:cec60480-04a9-11eb-80c4-df7359d94047.png" width="40px" /> SQL (Advanced, Intermediate, basic) certificate, Hacker Rank

</aside>

<aside> <img src="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80bb-a166-007a0d34a36f" alt="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80bb-a166-007a0d34a36f" width="40px" /> IBM Data Analysis with Python, Coursera

</aside>

<aside> <img src="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80ea-b72e-007a9f84cba9" alt="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-80ea-b72e-007a9f84cba9" width="40px" /> Database Fundamentals, MaharaTech - ITI

</aside>

Education

<aside> <img src="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-8004-994a-007a2ddbca69" alt="notion://custom_emoji/ca94f755-905d-48ed-bbdb-30e0102e8037/2b2d6ba3-cee4-8004-994a-007a2ddbca69" width="40px" /> Bachelor of Commerce

• Accounting and Business Cairo University • GPA: 3.55/4.0

</aside>

Hobbies

Listening Podcast

Reading Books

Running

Watching Comics

About Me

Data Analyst & Analytics Engineer who solves business problems — with hands-on experience in SQL, Python, Excel, and BI Tools (Power BI & Looker Studio).

I work across multiple business domains including Sales, Marketing, Operations & Logistics, and HR — transforming raw data into insights that support real decisions.

My background in Accounting & Business (Cairo University, Faculty of Commerce) means I understand the business side, not just the technical side.

Currently building an advanced analytics portfolio focused on automated data pipelines and end-to-end analysis projects — using Python, SQL, DAX, and Power BI.

<aside> <img src="https://i.pinimg.com/736x/92/d1/db/92d1db1521d374335498624cc95e9554.jpg" alt="https://i.pinimg.com/736x/92/d1/db/92d1db1521d374335498624cc95e9554.jpg" width="40px" />

Mohamed Ali

</aside>

<aside> <img src="https://img.icons8.com/?size=100&id=LoL4bFzqmAa0&format=png&color=000000" alt="https://img.icons8.com/?size=100&id=LoL4bFzqmAa0&format=png&color=000000" width="40px" />

GitHub

</aside>

My Services

Checkout services offered by me

Services

Tools

Tools

Work Experience

<aside> <img src="attachment:8409bcd6-3264-466f-8086-d607be803bb0:cropped-cropped-Respect-Tours-Egypt-Through-Local-Eyes.png" alt="attachment:8409bcd6-3264-466f-8086-d607be803bb0:cropped-cropped-Respect-Tours-Egypt-Through-Local-Eyes.png" width="40px" /> Business Intelligence (BI) & Data Analyst | Respect Tours Heliopolis, Cairo, Egypt ( 07/2025 – Present )

• Led the design and maintenance of the company’s data and reporting infrastructure, ensuring reliable access to financial and operational insights.
• Developed and deployed automated data pipelines using Python and SQL hosted on Docker, achieving high-frequency data refreshes and ensuring near real-time data integrity for stakeholders.
• Transformed complex ERP datasets into structured analytical models to uncover trends in sales performance, seasonal demand, and tour profitability.
• Engineered a sophisticated performance evaluation model in Power BI, normalizing supervisor KPIs based on geography and shifts to ensure equitable, context-aware, and data-driven assessments.
• Partnered directly with Sales, Finance, and Operations teams to deliver insights on P&L structures and pricing strategies, directly influencing revenue optimization. </aside>

<aside> <img src="attachment:2a2855ee-4559-443f-b8f3-436e09f69cf1:proAr.png" alt="attachment:2a2855ee-4559-443f-b8f3-436e09f69cf1:proAr.png" width="40px" /> Data Analyst Trainee | DEPI Data Analysis Program Giza, Egypt ( 06/2025 – Present )

• Executed comprehensive data analysis training focused on real-world business cases, delivering strategic decision support through data-driven methods.
• Analyzed complex datasets using SQL and Python to identify meaningful patterns and generate actionable insights.
• Designed interactive dashboards in Power BI to track key performance indicators and visualize performance trends.
• Collaborated with cross-functional teams to deliver data-driven insights that improved decision quality and analytical effectiveness. </aside>

Work Examples

Portfolio Items