Yahia Mahmoud

Yahia Mahmoud

$15/hr
Data analysis | web scraping | python | SQL| Selenium | Automation
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
24 years old
Location:
Cairo, Cairo, Egypt
Experience:
3 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.