Mohamed Raafat AboElKhair
Abu Dhabi,UAE
Summary
Accomplished professional with expertise in complex Excel formulas, Power BI data analysis and visualizations, and SQL proficiency. Demonstrates strong capabilities in big data management, workforce strategy planning, and capacity requirement planning. Adept at conflict management, guest services, and compassionate communication. Recognized for superior negotiation skills and effective problem-solving abilities. Career goals include leveraging analytics strategy and data analytics tools to drive organizational efficiency and success.
Overview
17
17
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Global Workforce Lead
Careem
06.2022 - 12.2024
- Creating business analysts for Global markets (KSA-UAE- Egypt- Pakistan- Jordan- Kuwait- Qatar-Iraq) using tools like Power BI, Excel, SQL
- Managing WFM teams (Planning, RTM, Routing, Reporting, WFM Analytics)
- Develop and implement workforce management strategies to optimize staffing levels, improve efficiency, and meet service level objectives
- Conduct workforce forecasting and capacity planning to always ensure appropriate staffing levels
- Create and maintain employee schedules, considering forecasted demand, employee availability, and labor regulations
- Monitor real-time adherence to schedules and take appropriate actions to address deviations and minimize service disruptions
- Analyze historical and real-time data to identify trends, patterns, and opportunities for process improvements
- Collaborate with cross-functional teams, including HR, Operations, and Training, to align workforce strategies with business goals
- Implement performance metrics and dashboards to track and report on key workforce management indicators
- Provide coaching and guidance to supervisors and team leads regarding workforce management practices and techniques
- Stay updated on industry trends, emerging technologies, and best practices in workforce management to drive continuous improvement
Workforce Planning Section-head
B-tech
Cairo
03.2019 - 06.2022
- Company Overview: Cairo, Egypt
- Creating analysis for the E-commerce department using tools like Power BI
- Team Management: Supervising and leading a team of employees, providing guidance, support, and coaching to ensure productivity, engagement, and adherence to company policies and procedures
- Workforce Planning: Analyzing staffing needs, forecasting workload, and developing strategies to efficiently allocate resources, ensuring adequate coverage while optimizing productivity and cost-effectiveness
- Performance Management: Setting performance expectations, conducting regular performance evaluations, providing feedback, and implementing performance improvement plans as necessary
- Evaluate, analyze, and maintain system requirements continuously
- Communicate with stakeholders to develop sales and discuss weak points based on historical drops and lessons learned
- Training and Development: Identifying training needs, designing training programs, delivering training sessions, and supporting employees' professional development to enhance their skills and knowledge
- Process Improvement: Identifying opportunities to streamline workflows, improve efficiency, and implement best practices to optimize team performance and achieve operational objectives
- Reporting and Analysis: Collecting and analyzing workforce data, and generating reports on key metrics such as productivity, absenteeism, and turnover
- Utilizing data insights to identify trends, make informed decisions, and drive continuous improvement
- Communication and Collaboration: Facilitating effective communication within the team and across departments, promoting teamwork, and collaborating with stakeholders to achieve organizational goals
- Cairo, Egypt
Enterprise Workforce Analyst
Vodafone Shared Services
Cairo
01.2014 - 03.2019
- Company Overview: Cairo, Egypt
- Gather, document and model data to assess business trends
- Developing and implementing workforce planning strategies aligned with organizational goals and objectives
- Analyzing workforce needs, skill requirements, and market trends ensures the right talent is available to support business objectives
- Developing and managing global compensation and benefits programs, ensuring competitiveness, equity, and compliance
- Conducting benchmarking and analysis to determine appropriate salary structures and benefits packages for different global locations
- Serving as the focal point for stakeholders, including senior leaders, regional HR teams, and business units
- Collaborating with stakeholders to understand business needs, align workforce strategies, and provide guidance on global workforce-related matters
- Utilizing HR data and analytics to provide insights on workforce trends, performance, and engagement
- Generating reports and presenting findings to stakeholders to support data-driven decision-making
- Supporting organizational change initiatives related to workforce transformation, restructuring, or mergers and acquisitions
- Providing expertise and guidance on change management strategies, communication plans, and employee engagement
- Collaborating with external vendors and partners to support global workforce initiatives, such as staffing agencies, relocation services, or HR technology providers
- Managing vendor relationships, contracts, and service level agreements
- Promoting diversity and inclusion initiatives across the global workforce
- Developing and implementing programs to foster an inclusive work environment, ensure equal opportunities
- Cairo, Egypt
Sales Executive
First For Trading and Distribution
Giza
03.2010 - 02.2013
- Company Overview: Giza, Egypt
- Reporting to the store manager
- Attending to walk-in customers
- Promote sales by suggesting products to customers, providing Information and helping in choosing the product
- Keep an eye on the products in the store and be responsible for any pilferage in the store
- Making customers aware of any schemes, discounts, and Promotional offers
- Maintaining the discipline and decorum of the store
- Managing the display of the products and taking care of Visual merchandising
- Stock taking on a day-to-day basis and taking inward goods
- Giza, Egypt
Sales agent
Vodafone Group
Cairo, Egypt
01.2008 - 03.2009
- Established robust client relationships through effective communication and negotiation skills.
- Provided customers with price information and handled financial transactions.
- Fostered a positive team environment to drive collective success in sales targets.
- Empathised with customers and translated technical concepts to promote understanding.
Education
Language and Translation -
Faculty Of Literate
09.2004 - 05.2008
Diploma of Education - Data analysis
Big Data Energy Institue
USA 04.2021 - 04.2022
Skills
- Complex Excel formulas
- Power BI data analysis
- Power BI visualizations
- SQL proficiency
- Big data management
- Workforce strategy planning
- Workforce gap analysis
- Workforce efficiency
- Capacity building
- Capacity requirement planning
- Conflict Management
- Guest services
- Ms Office
- Effective problem solver
- Accurate and detailed
- Deadline and detailed orientated
- Compassionate communication skills
- Superior negotiation skills
- Experience with analytics
- Analytics strategy
- Data analytics tools
Certification
- Excel Data Analysis Expert
- Learning Data Analytics
- SQL
- Power BI Dashboard, visualization storytelling
Languages
Arabic
Native
English
Advanced
Timeline
Global Workforce Lead
Careem
06.2022 - 12.2024
Diploma of Education - Data analysis
Big Data Energy Institue
04.2021 - 04.2022
Workforce Planning Section-head
B-tech
03.2019 - 06.2022
Enterprise Workforce Analyst
Vodafone Shared Services
01.2014 - 03.2019
Sales Executive
First For Trading and Distribution
03.2010 - 02.2013
Sales agent
Vodafone Group
01.2008 - 03.2009
Language and Translation -
Faculty Of Literate
09.2004 - 05.2008
Similar Profiles
Emran Arafeh Sobhi MoqbilEmran Arafeh Sobhi Moqbil
Senior Automation Engineer 2 at CareemSenior Automation Engineer 2 at Careem
Soni TamangSoni Tamang
Store Supervisor at CareemStore Supervisor at Careem
Iftikhar AhmadIftikhar Ahmad
Car Driver at CareemCar Driver at Careem
ABDUL SHAHIDH KABDUL SHAHIDH K
Senior Technical Program Manager at CareemSenior Technical Program Manager at Careem
Chaimae GuiriouiniChaimae Guiriouini
Sales Associate at Oscar Clothing StoreSales Associate at Oscar Clothing Store