Yahia Mahmoud
Data Analyst | Web Scraper
EXECUTIVE SUMMARY
CONTACT INFO
17, St2 , Moqattam, Cairo, Egypt
--www.linkedin.com/in/yahia-ml
Accountable and results-driven Data Analyst with more than three years of experience in data
migration, analysis, and web scraping. Adept at optimizing data workflows using Python, SQL,
AWS Glue, and web scraping tools such as Selenium and BeautifulSoup to deliver efficient,
data-driven solutions. Achieved a 25% increase in processing efficiency by leading data
migration projects at Siemens AG and enhanced productivity by reducing manual effort by 95%
across more than thirty web scraping projects.
Skilled in streamlining data processes and implementing scalable solutions, ensuring data
accuracy, and enabling data-driven decision-making. Seeking to leverage strong analytical and
technical expertise to drive impactful results in future roles.
WORK EXPERIENCE
Data Analyst
LANGUAGE
Brightly Software, Inc. - USA (remotely)
Arabic: Native
English: Fluent
•
Migrated and integrated data for over one-hundred clients from legacy systems to new
databases using AWS Glue, improving data processing efficiency by 25%.
•
Reduced task completion time by 15% compared to the team average through advanced
Python and SQL automation, ensuring 100% data validation accuracy.
•
Resolved six critical client issues by troubleshooting and optimizing SQL queries,
decreasing average incident resolution time by 30%.
•
Developed and fine-tuned SQL scripts that decreased database errors by 40%, improving
performance and operational reliability.
•
Led cross-functional meetings with clients, cutting recurring data migration errors by
20% through proactive issue identification and solution implementation.
German: Basic
Skills
* Programming: Python, SQL, R
* Visualization: Tableau, Power
Bi, Lucidchart, Excel, Google
sheets,
Python
04/2024 - Present
(Matplotlib,
Data Analyst
05/2022 - Present
Analytic Company GmbH - Hamburg, Germany (remotely)
seaborn).
•
Delivered over seven high-quality datasets monthly by analyzing vehicle data and filling
100% of missing values using SQL, improving data completeness by 15%.
* Other: MS Office (Word, Excel,
•
Spearheaded quality assurance processes that increased data accuracy by 20%, ensuring
reliable outputs for model-specific analysis and reports.
•
Uncovered key patterns and insights through data comparison, resulting in
recommendations that improved operational decision-making by 10%.
•
Conducted in-depth research, enhancing data integrity and reducing errors in analysis
by 25%.
Power Point), regex, python
(Pandas, NumPy, Selenium,
Beautifulsoup), Mongo DB, AWS,
Salesforce, Jira, Confluence.
Data Analyst & Web Scraper
08/2023 – 05/2024
e-motion digital creative agency – Cairo, Egypt (part time)
•
Designed and led the Gromart project, successfully scraping and processing data from
fifteen plus websites, improving data collection speed by 80%.
•
Created Python scripts (Selenium, BeautifulSoup) that automated data extraction tasks,
cutting down manual effort by 95% and transforming multi-day projects into minutes.
•
Integrated diverse data sources (MongoDB, relational databases) into a unified system,
boosting data processing efficiency and scalability by 30%.
•
Managed data storage, ensuring seamless handling of structured and unstructured data,
reducing system errors by 20%.
Data Analyst & Web Scraper
11/2022 – 05/2023
Aview International - Toronto, Ontario, Canada (remotely)
•
Led a team to scrape over forty-thousand rows of data from platforms such as YouTube
and Udemy, delivering 50% of the target data within the first month.
•
Developed efficient Python-based scraping solutions, reducing manual data collection
time by 75% and enhancing data quality for further analysis.
•
Leveraged Pandas and NumPy to clean and organize data, cutting data processing time
by 40% and ensuring 99% data accuracy for reports.
•
Coordinated data extraction into CSV and Excel formats, enabling faster report
generation and improved stakeholder decision-making.
Data Analyst Freelancer
01/2021 - 05/2022
Upwork - California, United States
•
Managed over thirty freelance data projects, achieving a 98% client satisfaction rate by
delivering high-quality web scraping, analysis, and visualization services.
•
Increased client data processing speed by 40% through tailored Python and SQL
automation solutions.
•
Implemented custom data scraping and visualization techniques that provided
actionable insights, driving decision-making improvements across 5 companies.
•
Consistently met and exceeded project goals, delivering 100% of projects on time and
contributing to client success through effective data strategies.
ACADEMIC BACKGROUND
B.CS. Undergraduate
2023 - Present
Arab Open University - Faculty of Computer Science - Cairo, Egypt
B.Sc. Undergraduate
Al-Azhar University - Faculty of Science - Cairo, Egypt
2020 - 2023