AA

Ashraf Aboalyazid

Data Analyst/ Data Engineer

Results-driven Data Analyst and Data Engineer with hands-on experience in SQL, Python, Power BI, and ETL pipeline development. Proven track record of building scalable data warehouses, delivering actionable dashboards, and translating complex datasets into clear business insights. Also brings extensive experience in technical instruction, demonstrating strong communication skills and a passion for solving real-world problems through engineering.

Expertise

Data Engineering & ETL

Expertise in designing and developing scalable data warehouses, implementing ETL pipelines, and optimizing data architecture for robust data solutions.

SQLETLData WarehousingData ModelingStar Schema

Data Analysis & Business Intelligence

Proficient in transforming complex datasets into actionable business insights through advanced analytics, interactive dashboards, and compelling data visualization.

PythonPandasPower BIDAXData Visualization

Technical Education & Mentorship

Extensive experience in delivering technical instruction in Data Science, AI, and programming, coupled with strong mentoring and communication skills for diverse audiences.

Technical InstructionMentorshipData ScienceAIPython

Featured projects

SQL Data Warehouse Project

Designed and developed a complete SQL-based data warehouse, including ETL workflows, dimensional modeling, and reporting layers, implementing a Bronze → Silver → Gold architecture.

Impact: Created clean, analytics-ready datasets for scalable business reporting and optimized querying performance across multiple business domains.

Sales, Orders & Supply Chain Dashboard

Developed a 3-page interactive Power BI dashboard analyzing Sales, Orders, and Supply Chain operations, with dynamic slicers for real-time filtering.

Impact: Enabled data-driven business decision-making and simplified complex sales insights for non-technical stakeholders.

Digital Wallet Transactions Dashboard

Analyzed 5,000+ digital wallet transactions to identify customer spending behavior across various segments and developed an interactive Excel dashboard tracking key KPIs.

Impact: Uncovered transaction trends and supported data-driven business insights through visual reports and advanced filters.

Superstore Sales & Profitability Dashboard

Analyzed 4 years of retail sales data across Sales, Shipping, Products, and Customer segments using Excel and Power Query, building Pivot Tables and dynamic reports.

Impact: Developed interactive dashboards highlighting revenue performance, discount impact, and customer purchasing behavior, automating data preparation for efficient reporting.

Career highlights

2025

Achieved 1000+ five-star student evaluations for engaging teaching and mentoring in Data Science and AI sessions.

2025

Trained and mentored over 340 participants in AI, machine learning, and Python through 165+ hours of hands-on instruction.

2024

Developed automated Power BI and Excel dashboards, significantly reducing manual reporting time and accelerating insight delivery.

2024

Completed 'RealityRX,' a VR-based virtual science lab, as a graduation project, enabling immersive practical experiments.

2026

Earned Data Engineer Associate Certificate from DataCamp, demonstrating expertise in SQL, ETL, and Data Processing.

2025

Earned SQL Associate Certificate from DataCamp, validating skills in SQL, joins, aggregations, and query writing.