HR Analytics

Built an interactive HR analytics dashboard to analyze workforce structure, compensation, age distribution, management concentration, and years of service.

Analyzed employee tenure and compensation levels to identify gaps in salary progression and develop a years-of-service-based salary increase structure.

Redesigned the workforce structure and identified excess positions, generating EGP 2.8M in projected monthly payroll savings through workforce and compensation optimization.

Recalculated the payroll after applying tenure-based salary increases, resulting in EGP 630.5K in remaining monthly savings while improving alignment between compensation and years of service.