محمد ع.

Dedicated Data Analyst & Instructor with 5+ years of experience in analytics, reporting, and

automation, and proven ability to design and deliver engaging training programs. Skilled in

SQL, Python, Excel, Power BI, Tableau, and ETL pipelines. Adept at simplifying complex

concepts into practical lessons and empowering learners to apply data analytics and basic

statistics in real-world scenarios.

Core Competencies

• Data Analysis & Visualization: SQL, Excel (Advanced), Power BI, Tableau

• Programming & Automation: Python, Google Apps Script, ETL pipelines

• Instruction & Training: Curriculum design, classroom & online teaching, mentoring,

assessments

• Business & Financial Analysis: Sales analytics, forecasting, KPI tracking, AR/AP reporting

• Communication & Problem Solving: Data storytelling, stakeholder engagement,

presentation skills

Professional Experience

Part-Time Instructor

Route Academy | July 2025 – Present - Teach Excel, Power BI, Python, SQL, and Basic Statistics to students and professionals. - Develop and deliver course materials, hands-on labs, and real-world case studies. - Mentor learners, evaluate progress, and provide feedback to ensure skill mastery.

Data Analyst & Sales Support

Froneri Ice Cream Egypt (Nestlé) | 2023 – Present - Extract and analyze data from multiple sources to track KPIs and support decision-making. - Build dashboards using Excel, Power Pivot, Power Query, and Power BI to provide

visibility to stakeholders. - Achievements: Reduced manual reporting time by 70 %; improved sales forecast accuracy

by 15 %.

Freelance Data Analyst & Google App Script Developer

2021 – 2023

- Designed ETL pipelines with Google Apps Script, reducing manual processing time by

40%. - Built automation tools for data cleansing and preparation, saving clients significant time. - Created dashboards in Excel, Google Sheets, and Tableau for small businesses. - Developed web scraping solutions using Python (BeautifulSoup, Selenium). - Conducted training sessions for clients on data visualization and automation.

Accountant & Analyst

Eldiesel for Importing and Trading | 2018 – 2021 - Analyzed sales data to identify market trends and forecast demand. - Optimized inventory levels aligned with projections, reducing stockouts and overstock. - Tracked AR/AP ensuring accurate financial records and strong cash flow.