Kerolos Medhat
Data Analyst & Data Scientist
Transforming raw data into actionable business insights through analytics, machine learning, and visualization.
About Me
I am a Data Analyst & Scientist with a strong focus on solving real-world business problems using data. I have delivered multiple projects across Retail, Supply Chain, Finance, and Healthcare domains. My skill set spans advanced SQL for data extraction, Python for complex analysis and machine learning, and Power BI for building high-impact dashboards. I also possess solid foundations in Data Engineering, ensuring data pipelines are clean, scalable, and production-ready.
Technical Skills
Programming
Data Analysis
Visualization
Machine Learning
Databases & Storage
Big Data & Processing
Cloud Platforms
Tools
Services I Offer
Comprehensive data solutions tailored to your business needs
Data Analysis & Business Insights
Transform raw data into actionable insights that drive business decisions and improve operational efficiency.
Power BI Dashboard Development
Create interactive, high-impact dashboards that visualize complex data in intuitive and meaningful ways.
Machine Learning Solutions
Build and deploy predictive models for classification, regression, and clustering to solve real-world problems.
Data Engineering Foundations
Design and implement scalable data pipelines and warehouses following industry best practices.
Reporting Solutions
Create efficient, comprehensive reports that provide clear insights and support data-driven decision-making.
Experience
Data Engineer | Python, SQL, Spark
Digital Egypt Pioneers Initiative (DEPI)
- •Built and processed datasets using Python and SQL for data engineering workflows
- •Designed and queried relational databases using MySQL and PostgreSQL
- •Applied Apache Spark and Hadoop for large-scale data processing
- •Developed projects involving web scraping, data integration, and cloud-based solutions using Microsoft Azure
Data Analyst | Excel, Power BI, SQL
Data-X
- •Developed advanced Excel solutions using formulas, functions, Pivot Tables, Power Query, and Power Pivot
- •Cleaned, transformed, and modeled data for reporting and analytical use cases
- •Built professional dashboards using Power BI, applying strong data modeling and data warehousing concepts
- •Delivered multiple projects across Banking, Retail, Supply Chain, Sales, and Healthcare
AI & Data Science Engineer | Machine Learning Projects
National Telecommunication Institute (NTI)
- •Built and evaluated machine learning models using Python and Scikit-learn
- •Applied supervised learning techniques on datasets exceeding 50K records
- •Worked with neural networks using TensorFlow and Keras
- •Delivered AI-based analytical solutions in a professional team setting
Machine Learning Engineer | Python & Scikit-learn
Sprints × Microsoft Summer Camp
- •Studied programming fundamentals and OOP concepts
- •Performed data analysis using NumPy, Pandas, and Matplotlib
- •Built and evaluated machine learning models following end-to-end workflows
- •Completed multiple applied projects simulating real-world ML tasks
Data Engineer | SQL & Data Processing
Information Technology Institute (ITI)
- •Designed and queried datasets using advanced SQL joins and aggregations
- •Applied Linux fundamentals for data and file management
- •Processed and transformed datasets using Python
- •Built strong foundations in ETL processes and data engineering concepts
Data Analyst | Power BI & Data Visualization
Digital Egypt Pioneers Initiative (DEPI)
- •Cleaned, transformed, and analyzed structured datasets for business insights
- •Built interactive dashboards using Power BI and Tableau
- •Wrote optimized SQL queries for reporting and analysis
- •Applied Python statistical libraries to support data-driven decision making
Data Scientist | ML & Analytics Projects
Optical Soft
- •Completed a comprehensive Data Science program covering Python, SQL, and ML
- •Built and evaluated machine learning models on real datasets
- •Delivered capstone projects applying end-to-end data science workflows
- •Strengthened analytical thinking and problem-solving skills
Projects
Real-world projects demonstrating expertise in data analysis and machine learning
Data Analysis Projects
Comprehensive analysis of Uber trip data with interactive visualizations and insights.
Marketing Campaign Analysis
Analyzed marketing campaign performance to optimize ROI and customer engagement.
End-to-end sales analysis identifying trends, patterns, and growth opportunities.
Data Science & Machine Learning Projects
Machine learning application predicting heart disease risk with interactive interface.
Classification model predicting passenger survival with feature engineering.
Education
Bachelor of Computer Science
Higher Technological Institute
Leadership
Data Analysis Capstone Project – DEPI Scholarship
Team Leader
- •Led a team of 5 members through complete project lifecycle
- •Delivered end-to-end analytics solution using Python, SQL, and Power BI
- •Coordinated tasks, resolved blockers, and ensured timely delivery
Let's Connect
Interested in working together? Reach out and let's discuss your data needs.
Direct Contact
Open to Opportunities
I'm actively seeking data analyst and data scientist roles where I can apply my skills to solve complex business problems and drive data-driven decision making.