Actively looking for a job


Maged Kamal

Maged Kamal

Quality Assurance AnalystHuawei Consumer Business Group

LawAin Shams University

Cairo Cairo Governorate, Egypt

AboutEventsChannelsMemberships

Hi, I'm Maged Kamal!

Quality Assurance Analyst at Huawei Consumer Business Group

I am a professional data analyst who have concluded many projects using SQL, Excel, Python and visualized data using Tableau and Power BI. I managed within the data that I got to extract insights from qualitative / quantitative data and visualize impactful dashboard for business requirements which created impact in decision making. Also, I have sharpened my data analytics skills during my learning journey at Udacity platform sponsored by the Ministry of Communications 'FWD' initiative, where I solved real world problems through data analysis.

Education

Law

Law

Bachelor's·Graduated in 2017·Ain Shams University

Experience

Quality Assurance Analyst at Huawei Consumer Business Group

October · 2020 - Present

• Analyzing line of business performance data to enhance the LOB gaps. • Working with several departments to extract insights from qualitative/quantitative data using RCA. • Monitoring and evaluating LOB progress. • Achieving business impact with dat...See more

Corporate Trainer at Huawei Consumer Business Group

November · 2019 - October · 2020

• Delivering product knowledge training sessions. • Developing onboarding programs for new employees. • Creating training programs to address skill gaps in employees. • Evaluating training progress, track learning curve and implement performance impr...See more

Technical Support Engineer at Huawei Consumer Business Group

January · 2019 - November · 2019

• Supporting end users and handle their technical inquiries related to software and hardware issues. • Do the needed scoping to diagnose and identify software and hardware faults. • Searching internal database to provide accurate tech solutions. • Si...See more

Projects

Excel - Ecommerce Business Interactive Dashboard

Part-Time

I have create an impressive and interactive Excel Dashboard from scratch by combining Pivot Tables, Pivot Charts, Slicers, and a beautiful design concept for an E-Commence Business.

https://github.com/Maged27/Interactive-Excel-Dashboard/blob/main/Interactive%20Excel%20Dashboard.xlsx

Python - Udacity Advanced Project

Part-Time

Project overview: To complete my Data Analysis professional project I have used TMDb movies dataset that Udacity provided us with. This data set contains information about 10 thousand movies collected from The Movie Database (TMDb). In this project I did the following: Cleaned, removed duplicates and renamed columns in the DataFrame. Concluded some insights from the data, like the highest budget and the lowest movie income in the past 150 years. Used matplotlib to visualize data in charts.

https://github.com/Maged27/TMDB---udacity-Data-Analysis-Professional-project-/blob/main/Investigate_a_Dataset.ipynb

Power BI - Survey Breakdown

Part-Time

I have created this dashboard in which I gathered real data about Data Professionals! Topics: - Cleaning & transforming data in Power Query - Data visualization using Power BI This dashboard answers the following questions: - When was this survey taken - How many respondents - Average yearly salary by job title - Average yearly salary by industry - Favorite programming language - Salary happiness rating - Work-life balance happiness rating - Countries of survey takers - Difficulty levels of breaking into data

https://github.com/Maged27/Power-BI---Survey-Breakdown/blob/main/Data%20Pro.%20Survey%20Breakdown.pbix

Excel - DTI Calculator

Part-Time

DTI is an important part of your overall financial health. I have created an interactive Excel sheet to help you calculate DTI ratio (debt-to-income).

https://github.com/Maged27/DTI-calculator/blob/main/DTI%20by%20Maged.xlsx

SQL+Tableau - Salaries Breakdown Based on Gender

Part-Time

In this project I have used MySQL to find insights related to salaries based on gender and I used tableau for the viz. SQL clause used: ORDER BY GROUP BY HAVING JOIN Aliases Tableau skills used: Dashboard building Connecting SQL with Tableau Data filtering

https://public.tableau.com/app/profile/maged1454/viz/AbreakdownbetweenMaleandFemalesalaries/Dashboard1

Languages

Arabic

Native

English

Professional

French

Beginner

Skills

Data Analysis

Analysis and Reporting

SQL

Excel

Python

Tableau

Power BI

JIRA

Trello

Data Analytics

Analyst

Interests

  • Business & Consulting
  • Career Guidance
  • Media & Communications
  • Entrepreneurship
  • Finance & Banking
  • Future Trends
  • Management & Leadership
  • Soft Skills
  • Tech & Web3
  • Telecommunications

Localized connects university students and recent graduates with industry experts and employers.

ProductStudentsEmployersUniversities
Download appiOS mobile appAndroid mobile app

PrivacyTermsSitemap

©2023 Localized, Inc. All rights reserved.