Amr Ayyad, MSc

BI Developer & Data Consultant

Data and Business Intelligence Professional with over 5 years of experience driving data strategy, analytics solutions, and BI enablement across multinational corporations, government initiatives, and academic institutions.

I turn data chaos into beautiful, actionable insights. Like a data whisperer, but with more SQL and less mysticism.

amr@ayyad.dpdns.org
(+20) 115-676-6566
linkedin.com/in/amr-m-ayyad

About Me

Proven expertise in Python, SQL, Power BI, Tableau, and advanced statistical tools to design scalable, insight-driven analytics ecosystems. Adept at leading cross-functional teams, developing high-impact training programs, and aligning data solutions with business objectives.

Education

2022 - 2025
Master's Degree in Science

Microbiology and Immunology (MSc)
Faculty of Science, Mansoura University, Egypt

2020 - 2021
Diploma in Forensic Science

Faculty of Science, Zagazig University, Egypt

2013 - 2017
Bachelor's Degree in Science

Microbiology and Immunology (BSc)
Faculty of Science, Mansoura University, Egypt

Certifications

Stanford Deep Data Research Center: Fundamentals of Data Science in Precision Medicine and Cloud Computing

Huawei: Huawei Cloud Certified Developer Associate (HCCDA)

Stanford University: Machine Learning Specialization

University of Michigan: Statistics with Python Specialization

Udacity: Data Analysis Professional Nanodegree

DataCamp: SQL Associate Certification

Yes, I collect certifications like some people collect stamps. Each one tells a story of late nights and countless cups of coffee.

Professional Experience

Recognized for transforming raw data into strategic insights, architecting end-to-end BI workflows, and fostering data literacy across organizations.

Mar 2024 - Present
Founder & Director of Learning and Development

Empirici Academy

Designed and implemented training programs to enhance employee skills and performance. Assessed training needs and developed curricula to address gaps. Supervised a team of trainers and overseeing their activities.

Apr 2024 - Present
Training Specialist

Digital Egypt Pioneers Initiative (DEPI), MICT, Egypt

Developed and delivered training programs for data analytics tracks. Led virtual classrooms of 200+ learners, using interactive teaching strategies to boost engagement and retention.

Feb 2023 - Feb 2024
Business Intelligence Reporting Specialist

LHH, Florida, United States

Developed key business intelligence reports and dashboards using BI tools. Extracted, transformed, and loaded data from diverse sources using SQL and ETL processes for reporting and analysis.

May 2021 - Dec 2022
Market Risk Analyst

DBS Bank, Singapore

Identified and analyzed market risk issues, contributing to the development of mitigation strategies. Developed and utilized data visualization tools for risk reporting and monitoring.

May 2020 - Mar 2021
People Analytics Specialist

Suncor Energy, Alberta, Canada

Analyzed HR data to identify key trends and provide actionable insights for improving employee engagement and retention. Developed data visualizations and reports to communicate complex HR metrics.

Feb 2022 - Oct 2023
Data & Analytics Consultant

Upwork

Provided data analysis and business intelligence consulting services to various clients across industries.

Projects

A selection of my recent data analysis and business intelligence projects showcasing end-to-end analytics workflows.

Energy Consumption Dashboard

Energy Consumption Analysis

Comprehensive analysis of energy consumption patterns using Power BI. Transformed raw data into actionable insights through data cleaning, transformation, modeling, and visualization.

Key Insights: Residential consumption shows 15% increase in winter, commercial usage peaks 40% higher during business hours, urban areas account for 65% of total consumption.

View Code Live Demo
Market Risk Dashboard

Market Risk Visualization Platform

Interactive dashboard for monitoring market risk exposures and exceptions. Built with Tableau and Power BI to provide real-time risk assessment and reporting capabilities.

Features: Real-time risk monitoring, limit exception alerts, historical trend analysis, predictive risk modeling integration.

View Code Case Study
HR Analytics Dashboard

People Analytics Dashboard

HR analytics platform for tracking employee engagement, retention, and performance metrics. Developed using Python, SQL, and Power BI with statistical analysis capabilities.

Impact: Identified key factors affecting employee turnover, predicted retention risks with 85% accuracy, enabled data-driven HR decision making.

View Code View Dashboard

Skills

Technical and personal skills honed through years of professional experience across diverse industries and roles.

Technical Skills

Python
SQL
Power BI
Tableau
Excel/Spreadsheets
Data Visualization
Statistical Analysis
ETL Processes
Data Warehousing
Machine Learning
SPSS / Minitab
SAS JMP

Personal Skills & Languages

Communication
Team Leadership
Curriculum Design
Problem Solving
Time Management
Attention to Detail

Languages: English (Professional Fluency), Arabic (Native), Japanese (Elementary), Spanish (Elementary). I can ask for data in four languages, but the insights are universal.

Publications

Research papers and publications demonstrating the intersection of data science with biological and medical applications.

Response surface optimization of sedimentation efficiency for sustainable green microalgae harvesting using automated non-invasive methods (2025)

doi.org/10.1186/s12934-025-02765-2

Optimization of flocculation parameters for efficient microalgal biomass harvesting: a response surface methodology approach (2025)

researchgate.net/publication/390947011

Significance of siderophore-producing cyanobacteria on enhancing iron uptake potentiality of maize plants grown under iron-deficiency (2024)

doi.org/10.1186/s12934-024-02618-4

Maize plant development and antioxidant defense influenced by selenium-enriched Cyanobacteria species (2024)

doi.org/10.1016/j.sajb.2024.12.033

Get In Touch

Interested in collaborating on a data project or need BI consulting? Feel free to reach out!

Contact Information

What I'm Looking For

I'm currently open to:

  • BI Developer roles
  • Data Consultant projects
  • Data Analytics training opportunities
  • Research collaborations at the intersection of data science and biology

I promise not to over-engineer your data solutions. Unless you want me to. Then I'll over-engineer them beautifully.