Hatem Kamal
Aspiring Data Engineer-
-
hatem-m-kamal
Cairo, Egypt
Completed
HMMK99
PROFILE
Motivated Junior Data Engineer with hands-on experience in Python scripting, SQL database management,
and building ETL pipelines. Skilled in automating workflows, cloud fundamentals (AWS), and data
visualization with Power BI. Committed to optimizing data processes and delivering scalable solutions
through a problem-solving and detail-oriented approach.
PROFESSIONAL EXPERIENCE
Application Support Engineer
Giza Systems, EEHC & Riyadh Park
Developed Python scripts to monitor system performance, enabling proactive
identification and resolution of transaction issues.
Optimized system performance through analysis using Linux commands and SQL
queries, ensuring smooth system operation.
Implemented customer change requests, including one major update per month,
to enhance system functionality and user experience.
Maintained and updated Oracle BI dashboards to reflect system changes and
ensure user access to critical data.
Automated manual tasks using Python, streamlining workflows and improving
operational efficiency, resulting in a 2-hour time saving per task.
07/2023 – present
Data Science Scholarship
ALx
Data Preparation: utilizing Excel for data operations.
Advanced SQL: writing complex SQL queries to extract and transform data from
RDB.
Data Visualization with Power BI: creating interactive and insightful data
visualizations using Power BI.
Python Programming: using Python for data analysis, scripting, and automation.
Regression Analysis: applying regression techniques to model relationships and
make predictions.
NLP and Classification: knowledge of Natural Language Processing (NLP)
techniques for text analysis and classification tasks.
Unsupervised Learning: unsupervised learning algorithms for uncovering hidden
patterns in data.
AWS Foundations: strong understanding of foundational AWS cloud computing
services.
05/2023 – 07/2024
•
•
•
•
•
•
•
•
•
•
•
•
•
PROJECTS
X-shop
Graduation project, Django SAAS Application
Cooperated in developing a SaaS platform using Django for Point-of-Sale (POS) and ecommerce functionalities.
Set user authentication and authorization with a robust system for managing user
roles and permissions.
Designed a comprehensive product and order management system within the
Django framework, ensuring efficient inventory tracking and order fulfillment.
Customized the Django admin interface to provide a user-friendly and role-based
management experience.
•
•
•
Payment Service monitoring script
GIZA SYSTEMS, Python script with SQL and Webservices
Automated payment data extraction and processing pipeline:
Retrieved data from the payments table.
Calculated transaction performance metrics using statistical analysis.
•
•
09/2020 – 06/2021
Identified transaction exceptions through data validation techniques.
Integrated with a web service to verify transaction status on an external system.
Designed logic to automate actions based on the results.
•
•
•
Data Adjustment script
GIZA SYSTEMS, ETL with python
A data ingestion process for customer data:
Reading data from customer-provided Excel files.
Used data validation routines including null checks, length checks, and format
verification to ensure data integrity.
Performed customer ID verification against the database to ensure accurate data
mapping.
Loaded the validated data into the database for further processing and analysis.
•
•
•
•
Collect Toll Data (ETL)
personal project, Airflow ETL project
Automate toll data collection: Build an Airflow DAG to orchestrate data extraction
from various sources using appropriate operators.
Ensure data quality: Integrate data validation tasks within the DAG to check
completeness, format, and consistency before loading.
Schedule and centralize data: Set the DAG to run periodically, collecting fresh toll
data and loading it into a central target (data warehouse, data lake) for further
processing.
•
•
•
UDEMY Coupons Web Scraping App
Django Application
A web scraping tool using Django for automatic coupon collection:
Monitoring site logs to get errors happening, investigate the cause and fixing it.
Utilized Selenium for web browser automation to navigate and interact with
targeted websites.
Leveraged BeautifulSoup for efficient parsing of HTML content and coupon data
extraction.
Exported scraped coupons as CSV files for further analysis or distribution.
•
•
•
•
System Monitor Project
Giza Systems, monitor automation
Developed a python script to monitor 5+ functions over 3+ applications then send the
status update to whatsapp group or open an Azure ticket.
EDUCATION
BSc. Computer Engineering
Zagazig university
CERTIFICATES
Data Analysis nanodegree
Machine learning engineer
ETL and Data Pipelines with
Shell, Airflow and Kafka
Deep Learning
LANGUAGES
Arabic
English
SKILLS
Technical skills:
Database management and manipulation, Data modeling, Automating tasks, ML, Data operations,
Containerization, ETL, System administration, batching and streaming data, data vizualization.
Tools:
SQL, Python, Linux, Odoo, Power BI, Docker, Oracle BI, Kafka, Airflow, Git, Oracle utilities, Elastic Search,
Excel.
Soft skills:
Teamwork, Adaptability, Communication, Problem-solving, Time management, Attention to detail
