
Khaled Sayed Abd El-Mwgoud
RTM Analyst at Sykes Enterprises
Alzawya Alhamraa, Cairo, EgyptWork Experience
Senior Business Intelligence DeveloperFull Time
- Job Details:● Developed and maintained interactive dashboards and reports using Power BI, delivering actionable insights to support key business decisions. ● Designed and optimized data models and implemented advanced calculations using DAX, improving report performance and usability. ● Integrated and automated data pipelines by leveraging Jira APIs to extract real-time operational data for analytics purposes. ● Implement periodic Data Quality Checks to validate the data in DW.
MIS Sr.AnalystFull Time
- Job Details:• Created the report automation project to automate the data pipeline. • Designing a dashboard for operation management to visualize the operational performance. • Creating KPIs module • Reporting figures on daily, weekly and monthly basis.
RTM AnalystFull Time
- Job Details:• Manage call volume, and program break schedules. • Manage non-productive time request process, ensuring activities are planned without impacting SLAs. • Monitor agent status in real-time and take action to keep workforce utilization optimal. • Monitor and analyze key performance indicators and trends to forecast, reschedule, and adjust staffing levels
Education
Technical Diploma in Data science
Cairo University (CU)Jan 2021 - Jan 2023 - 2 yr
Bachelor's degree in law in Law
Cairo University (CU)Jan 2017 - Jan 2021 - 4 yr
Achievements
Sales Data analysis project database analysis for restaurants data with visual Dashboards Used technology: Python (Pandas), SQL, Tableau GitHub link: https://github.com/An999n/database-analysis Tableau Dashboard1: https://public.tableau.com/app/profile/khaled4192/viz/ElMenus_test_Area-Analysis/AreasDashboard Tableau Dashboard2: https://public.tableau.com/app/profile/khaled4192/viz/ElMenus_test_Monthly__restaurant_Analysis/Dashboard1 stock exchange simulator Python/Flask web app GitHub link: https://github.com/An999n/Stock-Exchange-simulator Tic-Tac-Toe Command-line Created using C Programming GitHub link: https://github.com/An999n/Tic-Tac-Toe
Skills
- Microsoft Excel - VBA
- Mathematics
- Python
- Microsoft SQL Server
- Computer Science
- Business Analysis
- Mysql Database
- Multivariate testing
- Analyst
- Data Science
Languages
Arabic
FluentEnglish
Advanced
Training & Certifications
Data Analysis Challenger
Udacity·2021Software Development
Raya·2021CS50 introduction to computer science
Harvard·2021PCAP: Programming essentials in python
Cisco Networking Academy·2020Certificate of participate on web development track
Udacity·2020Soft skills Training course
MBS·2020HTML Essentials
LinkedIn learning·2020