Youssef Elzahar

Data Analyst, Data Scientist, and AI Engineer with experience collecting, transforming, validating, and analyzing large-scale enterprise datasets using SQL and Python. Experienced in designing ETL pipelines, developing automated reporting workflows, building business intelligence dashboards, and delivering actionable insights that support business decision-making. Strong background in machine learning, predictive analytics, statistical analysis, and AI-powered applications, with hands-on experience developing end-to-end ML solutions, Retrieval-Augmented Generation (RAG) systems, NLP pipelines, recommendation systems, and intelligent automation tools.

Skilled in SQL, Python (Pandas, Scikit-learn, XGBoost), Power BI, SSRS, FastAPI, Large Language Models (LLMs), and data warehousing concepts. Experienced working with Infor LN and Odoo ERP systems to transform operational data into scalable analytics and AI solutions. Passionate about solving complex business problems through data science, artificial intelligence, and modern data engineering practices while enabling data-driven decision-making.

Data Analyst / Python Developer at 3Brothers (2025-11 – Present)

• Designed and maintained ETL workflows to extract, clean, transform, and validate data from Infor LN and Odoo ERP systems.
• Wrote complex SQL queries, CTEs, stored procedures, and views to support reporting and business analytics.
• Built automated reporting pipelines using Python and SQL, reducing manual reporting effort.
• Developed Power BI dashboards and SSRS reports for KPI monitoring and executive decision making.
• Performed exploratory data analysis and ad hoc analysis to identify operational trends and business opportunities.
• Collaborated with finance, operations, and business teams to define reporting requirements and business KPIs.
• Implemented data validation and quality checks to improve reporting accuracy.
• Optimized SQL queries and reporting workflows for improved performance.
• Documented reporting logic, data sources, and ETL processes.

Freelance Data Scientist at Mostaql (2026-03 – Present)

• Delivered end-to-end machine learning solutions for freelance clients including recommendation systems, classification models, and predictive analytics applications.
• Built an airline recommendation system using TF-IDF, preprocessing pipelines, feature engineering, sampling strategies, and supervised learning models.
• Evaluated machine learning models using ROC-AUC, precision, recall, F1-score, and comparative performance analysis.
• Built Streamlit applications for interactive model deployment and business-facing analytical tools.

Full Stack Data Scientist Intern at Fixed Solutions (2025-07 – 2025-10)

• Developed backend applications using Python, FastAPI, and REST APIs.
• Built automated data processing and ETL workflows.
• Worked with SQL databases and data transformation pipelines.
• Developed scalable applications following clean architecture principles.
• Collaborated with development teams to deliver production-ready software.

Freelance Data Analyst at FreelanceYard (2025-04 – 2025-05)

• Built business intelligence dashboards and analytical reporting solutions.
• Conducted exploratory analysis, KPI monitoring, and business performance analysis.
• Delivered actionable analytical insights for pricing and sales strategy optimization.

Data Analysis for Machine Learning Intern at NTI (2024-12 – 2025-01)

• Built machine learning preprocessing workflows, feature engineering pipelines, and predictive analytics models.
• Applied statistical analysis, model evaluation, and experimental analysis techniques.
• Participated in machine learning competitions and predictive modeling projects.

Bachelor of Computer Science in Computer Science – Elshrouk Academy (2018 – 2022)