Data-Driven Rewards Professional with 2.5 years of intensive experience in Compensation Data Management
(Payroll & C&B), Compliance, and HR Analytics, built upon a decade of success in Sales Leadership and
relationship m…
Data-Driven Rewards Professional with 2.5 years of intensive experience in Compensation Data Management
(Payroll & C&B), Compliance, and HR Analytics, built upon a decade of success in Sales Leadership and
relationship management. Expert in utilizing Excel (Advanced) & Power BI to analyze payroll data, track Total Cost
of Compensation (TCC), and generate analytical dashboards that inform strategic Rewards decisions and ensure
strict Labor Law adherence. Proven ability to lead teams and maintain business relationships. Seeking a Rewards
Data Consultant role to leverage analytical and relationship skills in optimizing compensation strategies.
Managed the end-to-end payroll cycle utilizing LogiN HRMS, serving as the primary data source for all employee compensation and benefits.
Analyzed key payroll metrics (e.g., overtime, variable pay, TCC) to provide insights on labor cost efficiency and allocation.
Oversaw all termination and social insurance procedures.
Analyzed potential legal risks related to severance and benefit payouts.
Ensured full adherence to Labor Law requirements and company policies.
Utilized Excel (Advanced) and Power BI to transform raw payroll and attendance data into strategic KPIs and dashboards.
Provided leadership with actionable insights on workforce cost and efficiency.
Compensation Data Analysis & Management, Rewards Compliance & Risk Mitigation, HR Dashboarding & KPI Tracking
Led a sales strategy that increased sales from EGP 0 to EGP 27 million within three years.
Managed and successfully mentored a team of 16 tele sales representatives.
Consistently exceeded quarterly performance targets.
Strategic Growth Achievement, Managed and mentored sales team
📊 Business Intelligence (BI) Project Description: Sales and Performance Analysis 💡 Project Overview: This project involved the development and implementation of a comprehensive Business Intelligence (BI) system utilizing Microsoft Power BI to provide real-time, data-driven insights for executive management and sales teams. The system focuses on analyzing financial performance, product sales, return rates, and the effectiveness of sales representatives and inventory levels across four key governorates: Qena, Minya, Assiut, and Beni Suef. A core feature is the detailed comparison of performance between the years 2024 and 2025. ✨ Key Objectives: Sales Efficiency Improvement: Identify top and bottom-performing products and pinpoint geographical areas for strategic focus. Inventory/Returns Management: Monitor and analyze the volume and value of returns to address underlying issues. Performance Evaluation: Measure and track the performance of sales representatives (Top 10 REP) and the number of active pharmacies. Strategic Planning: Provide insights into seasonal trends (June, July, August, September) related to sales value and order volume. 🛠️ Methodology and Tools Used: Primary Tool: Microsoft Power BI (for dashboard development). Data Modeling: Designed a robust Star Schema/Snowflake data model to link key tables (e.g., ProductsTable, BranchesTable, rep sales, DimDate), ensuring data accuracy and reporting efficiency. DAX (Data Analysis Expressions): Wrote complex measures and calculations to define core Key Performance Indicators (KPIs), including: Net Sales Value, Total Quantity Sold, Total Returns Value, Transactions 2025, and Total Sales Value. Visualization: Created clear and informative visualizations (Bar Charts, Line Charts, and focused KPI cards) organized into multiple interactive reports: Core KPIs: Highlighting metrics such as 248.20K Net Sales Value and 5814 Total Quantity Sold. Product Analysis: Identifying and comparing the TOP 7 Products performance for 2024 vs. 2025. Channel Analysis: Ranking the TOP 10 Pharmacies by sales value. Geographical and Time Series Analysis: Tracking sales and returns performance across different regions and months. 🎯 Results and Achievements: Successfully developed 4 interactive dashboards covering (Overview, Sales Reps/Agents 2025, Products & Pharmacies), providing a 360-degree view of the business. Established a monthly tracking system that highlights significant fluctuations in sales value (e.g., the notable recovery/increase in September). Enabled management to identify products like Olustat 120mg, Glycokinase, and Ibuprofen as critical items requiring continuous monitoring and strategic focus.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
