Bassem Magdy Mahmoud

Data Analyst transitioning from HR operations, with hands-on experience building end-to-end analytics solutions using SQL Server, Power BI, Excel, and Python. Designed relational databases and interactive dashboards — applied across real projects including an Electronics Retail Analytics Pipeline and a

Hospital Management System. Managed and analyzed workforce data for 350+ employees, improving workflow efficiency by 40%. Self-driven learner with a strong foundation in Python analysis, ETL, and statistical analysis, combining business context with technical depth to turn raw data into actionable insights.

HR Personnel Specialists in El-Amir Group from 6/2023 to 10/2025

• Participated in building and developing a digital HR system, improving workflow efficiency by 40%

• Managed daily attendance, leaves, missions, and excuses for 350+ employees, ensuring accurate monthly payroll submissions.

• Prepared and updated employee files with accuracy and compliance with company policies.

• Standardized employee file data and automated compliance tracking, cutting document processing time significantly.

• Coordinated data workflows between HR, insurance, and benefits departments, ensuring timely and accurate records activation.

• Conducted exit interviews and delivered structured reports to support turnover analysis.

Customer Service Representative in Etisalat from 6/2022 to 3/2023

• Resolved 60+ daily customer inquiries with a consistent record of meeting monthly performance KPIs.

• Tracked and reported daily performance metrics,

  developing strong attention to data accuracy and KPI monitoring.

Cairo University

Bachelor of Commerce in Insurance