Mohamed Wael Elsamman
Data Engineer - Data Analyst
"My journey started with a love for visual storytelling - crafting designs that capture emotions and ideas. Now, I'm weaving that passion into the world of data. Just like a well-designed image, I believe insightful data tells a compelling story. I'm excited to use my skills to transform raw information into visuals that inspire, inform, and drive action."
Experience & Education
Trainee at DEPI
- Developed automated ETL solutions using SSIS.
- Implemented data validation, cleansing, and enrichment processes.
- Designed and created a target database schema.
- Ensured data quality and integrity throughout the ETL pipeline.
- Gained proficiency in SQL, data warehousing, data modeling, and Azure cloud services.
- Enhanced skills in Python for data science, utilizing libraries like pandas, NumPy, and matplotlib.
- Acquired foundational knowledge in Power BI, SSAS, and SSRS.
B.Eng. in Artificial Intelligence (in progress)
Mansoura University
GPA: 3.91
Key Courses:
- Machine Learning
- Big Data
- Deep Learning
- Data Analysis
- Data Management
- Discrete Mathematics
- Advanced Mathematics
- Statistics
- Computer Vision
- Neural Networks
- Databases
- Linear Algebra
Certifications & Achievements
DataCamp: Associate Data Engineer in SQL
DataCamp: Data Analyst with Python
IEEE Software Quest Competition: 4th Place with Team BrainUp (Educational Platform using AI)
View on LinkedIn
Skills
Data Visualization & Storytelling
I transform raw data into clear, compelling visuals and narratives, empowering clients to make informed decisions.
Database & SQL Expertise
Proficient in MySQL, PostgreSQL, and MS SQL Server, with proven skills in database design and optimization. My LeetCode and HackerRank badges are a testament to my SQL mastery.
Python & Machine Learning
Leverage Python's power with libraries like pandas, NumPy, matplotlib, seaborn, and Plotly for data analysis and visualization. My academic focus on Artificial Intelligence fuels my passion for machine learning.
Data Warehousing & ETL
Experienced in designing and implementing data warehouses, and building robust ETL pipelines using SSIS. I ensure data quality and accessibility for effective analysis.
Business Intelligence & Reporting
I create interactive dashboards and reports using Power BI, enabling clients to gain valuable insights and track key performance indicators.
Cloud Technologies
Familiar with Azure cloud services, providing scalable and cost-effective solutions for data storage and processing.
Generative AI
Proficient in implementing RAG (Retrieval Augmented Generation) systems, working with LLMs, and developing AI agents. Experienced in automation workflows using n8n and Make. Skilled in vector database implementations using Chroma and FAISS, and building applications with LangChain and LangGraph.
Personal Skills
My volunteering experience has been instrumental in developing a range of essential skills. I've honed my leadership abilities by taking initiative and motivating teams to achieve shared goals. Through organizing and delivering presentations, I've cultivated effective communication and public speaking skills. These experiences, coupled with the challenges of coordinating projects and meeting deadlines, have fostered strong project management and time management capabilities. I'm also a proactive problem-solver with a knack for creative solutions and a high degree of emotional intelligence, allowing me to navigate diverse team dynamics and build strong relationships.
Services
Data Warehousing & Modeling
Design and implement robust data warehouses, create efficient data models, and ensure data consistency and accessibility for effective analytics.
ETL & Data Integration
Develop and maintain seamless data pipelines using SSIS, integrating data from diverse sources for comprehensive analysis.
Data Analysis & Insights
Uncover hidden patterns and trends in your data using advanced analytical techniques, delivering actionable insights to drive business growth.
Interactive Dashboards & Reporting
Create visually appealing and interactive dashboards using Power BI, enabling you to monitor key metrics and make data-driven decisions with ease.
Cloud-Based Data Solutions
Architect and implement cloud-based database and data warehousing solutions on Azure, leveraging its scalability and cost-effectiveness.
Instructor
Share my knowledge and expertise through engaging workshops and training sessions.
Projects
FLEX AI Life Coach Web App (Graduation Project)
- Overview: An innovative web application leveraging AI to provide personalized life coaching and guidance. This is our first graduation project, combining cutting-edge technologies for an intelligent, user-friendly platform.
- Key Features:
- AI-powered, context-aware chat interface
- Personalized recommendations and goal tracking
- Rich Markdown support, code highlighting, and file attachments
- Real-time updates, typing indicators, and message animations
- Secure data handling and adaptive learning
- Technologies: React, TypeScript, TailwindCSS, Vite (Frontend); FastAPI, Python, LangChain, Google AI (Backend)
- Architecture: Modular frontend (React) and backend (FastAPI), with AI integration (LangChain, Google AI), vector database, and secure user data storage.
StudyGenie: AI-Powered Study Assistant
- Developed an advanced AI-powered study assistant using RAG (Retrieval Augmented Generation) technology.
- Implemented PDF document processing with intelligent analysis capabilities.
- Created a smart Q&A system for context-aware answers about study materials.
- Built features for generating comprehensive study materials including summaries, MCQs, and flashcards.
- Utilized Google's Gemini model and LangChain for advanced AI capabilities.
- Implemented FAISS vector database for efficient similarity search and document retrieval.
- Developed both Jupyter Notebook and Streamlit web app versions for flexible usage.
Telecom SSIS Project
- Automated ETL solution to ingest, validate, transform, and load customer activity data from CSV files into a database.
- Implemented data validation and cleansing rules based on provided mapping specifications.
- Enriched data by joining with external reference data.
- Designed and created a target database schema for efficient data storage.
- Implemented incremental loading to prevent duplicate data processing.
- Handled error logging and archiving of processed files.
AdventureWorks Data Warehouse
- Designed and implemented a data warehouse using Microsoft SQL Server and SSIS.
- Modeled data using a star schema for optimal query performance.
- Developed ETL processes to extract, transform, and load data from the AdventureWorks OLTP database.
- Implemented Slowly Changing Dimension Type 2 (SCD2) to track historical data changes.
Customer Data Management DEPI
- Designed and implemented a customer data management solution using SQL Server, SSIS, Python, and Power BI.
- Developed ETL pipelines to automate data extraction, transformation, and loading processes.
- Created interactive Power BI dashboards for data visualization and analysis.
- Implemented data modeling techniques (e.g., star schema) for efficient querying and analysis.
E-commerce Data Preprocessing by Spark
- Prepared e-commerce order data for a demand forecasting project using PySpark.
- Cleaned and preprocessed a large dataset (orders_data.parquet) containing order dates, products, addresses, and financial metrics.
- Implemented data transformations, including date/time manipulation, product/category normalization, and state extraction from addresses.
- Removed invalid or irrelevant data (e.g., orders between 12am-5am, discontinued products).
- Ensured data quality and consistency for accurate demand forecasting.
- Saved the cleaned dataset (orders_data_clean.parquet) for use by the machine learning team.
Testimonials
"I had the pleasure of teaching Eng. Mohamed Wael during the DEPI initiative in the Data Engineering track. Wael consistently stood out as one of the most interactive and cooperative students in the cohort. His commitment to learning and his proactive engagement in discussions were remarkable. Throughout the program, he demonstrated a growing resilience and determination to excel in his studies, continually pushing himself to achieve more. I have no doubt that his dedication and positive attitude will be assets in any professional environment."
"It is with great pleasure that I recommend Mohamed Wael. Throughout my time working alongside Mohamed, I have consistently been impressed by his hard work and dedication. He demonstrates a remarkable work ethic and a commitment to delivering high-quality results in all tasks he undertakes. Mohamed is not only diligent but also highly motivated, always eager to learn and improve. His strong sense of responsibility and perseverance makes him an asset to any team or project. I am confident that Mohamed Wael will continue to excel in all his future endeavors, and I wholeheartedly recommend him for any opportunity he chooses to pursue."
"I've had the pleasure of collaborating with you. You consistently delivered high-quality designs that were both creative and aligned with our marketing goals. You are not only skilled and detail-oriented but also incredibly responsive and open to feedback. Your ability to take our vision and transform it into stunning visuals made our campaigns stand out. You're a reliable and helpful team player who's always ready to go the extra mile. Truly a valuable asset to any project."
"I just wanted to say how much I appreciated working with you. You were always supportive, easy to talk to, and really smart and hardworking. It was a pleasure working with you, and I'm grateful for all your help."
"Working with Mohammed Wael on BrainUp has been a rewarding experience. His technical skills and innovative mindset were key to the success of the app. He demonstrated strong problem-solving abilities and consistently contributed valuable insights, especially in integrating AI to enhance the learning experience. I look forward to collaborating with him again in the future."
"It was a pleasure working with you. You are a hardworking and enthusiastic person with outstanding leadership skills. I truly appreciate your dedication. I've learned so much from you.Thank you for that and I'm looking forward to to working with you again soon inshallah!"
"Mohamed is an incredibly talented, creative, and helpful colleague and friend who is always willing to offer support, providing creative tips and ideas. He consistently goes the extra mile to assist his friends with their work, and learning paths, while also being extremely efficient with his own tasks."
"As a social media specialist, I had a direct contact with Mohamed Wael, working on many projects. With his attention to details and creative thinking, he managed to get the best visual appearance out of the content. He's very dedicated and professional when it comes to graphic design."
"A true learning hustler and -any- team engine. Great leadership personality. Remarkable teamwork. Love to help and to learn."
"I want to thank you for your great work. you were very professional, met deadlines, and communicated well. The quality of your work was excellent. I appreciate your efforts and look forward to working with you again"
"You're very hardworking and you add your touch into everything. You stick well to deadlines because you're very organized. You always have a vision that you wanna accomplish. Working with you was a good experience overall:)"
"Working with you was great and I benefited a lot from you."
"Very helpful and has a huge potential."
"Great work with a big effort and the best part the Punctuality"
"Helpful with creative opinions."