Maged Kamal
Quality Assurance Analyst at Huawei Consumer Business Group
Law at Ain Shams University
Egypt
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.
Experience
Huawei Consumer Business Group
Quality Assurance Analyst
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 data that improved performance.
• Complete all LOB relevant analysis to make sure it meets our OKRs.
• Maintain a database for all data and reports monitored.
• Liaising with team leaders and other departments to increase the efficiency of our services.
• Brief the team leaders with the gaps of their teams and their points of development.
• Preparing PPT to the frequently asked inquires and top call drivers.
• Presenting LOB performance at quality monthly business review meetings.
• Give new batches training and quality sessions.
• Frequently communicate with our HQ to get the latest updates and new tasks.
Huawei Consumer Business Group
Corporate Trainer
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 improvement initiatives.
• Share trainees’ performance at the monthly business review meeting
• Conducting surveys to gauge the effectiveness of training sessions.
• Liaising with team leaders and other departments to increase the efficiency of our services.
• Frequently communicate with our HQ to get updates and new products info.
Huawei Consumer Business Group
Technical Support Engineer
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.
• Side task - supporting users with their E-commerce, buying and bulk sale process.
Education
Law
Ain Shams University
Graduated in 2017
Certificates & Badges
No certificates or badges added
Projects
Excel - Ecommerce Business Interactive Dashboard
•https://github.com/Maged27/Interactive-Excel-Dashboard/blob/main/Interactive%20Excel%20Dashboard.xlsxPart-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.
Python - Udacity Advanced Project
•https://github.com/Maged27/TMDB---udacity-Data-Analysis-Professional-project-/blob/main/Investigate_a_Dataset.ipynbPart-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.
Power BI - Survey Breakdown
•https://github.com/Maged27/Power-BI---Survey-Breakdown/blob/main/Data%20Pro.%20Survey%20Breakdown.pbixPart-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
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).
SQL+Tableau - Salaries Breakdown Based on Gender
•https://public.tableau.com/app/profile/maged1454/viz/AbreakdownbetweenMaleandFemalesalaries/Dashboard1Part-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
Languages
Arabic
Native
English
Professional
French
Beginner
Skills
Data Analysis
Data Analytics
SQL
Excel
Python
Analysis and Reporting
Tableau
Trello
Power BI
JIRA
Analyst
Ready for a personalized experience? We use cookies and similar technologies to tailor our site just for you. By clicking 'Accept', you're giving us the thumbs up to use cookies and similar technologies. 🍪