profile-img

MOHAMED HAMDY ABDEL - HAFEZ

Global Business Analyst at Majorel / Teleperformance

Haram, Giza, Egypt

Work Experience

  • Global Business AnalystFull Time

    Majorel / Teleperformance

    Sep 2022 - Present -2 yrs, 10 months

    Egypt , Cairo

    • Job Details:* Develop tabular models on Azure Analysis Services (Cube) and Power-BI * Design Interactive analytical and intuitive dashboards in Power-BI * Analyze, Document KPIs Indicator and Interpret Data * Use Power Query to structure the data tables and create Relations * Maintaining, evaluate and improve dashboard and data models * Maintaining and support Power-BI Portal in Cloud * Collaborate with teams to apply Polices and Check gaps * Collaborate with teams to test and improve process of implementation * Collaborate with teams to design new BI cloud solutions for multi-regional access to distributed data sets
  • Analyst & PerformanceFull Time

    Fawry Plus payment

    May 2019 - Sep 2022 -3 yrs, 4 months

    Egypt , Cairo

    • Job Details:* Managed and maintained structured datasets, including data creation, transformation, and query execution across multiple sources with a strong focus on data quality and validation. * Conducted quality assurance of imported datasets, ensuring data integrity, accuracy, and alignment with operational standards. * Handled confidential and sensitive information in compliance with organizational data governance and privacy policies. * Designed, developed, and automated performance reports, dashboards, and analytical views to support strategic decision-making. * Consolidated and generated reports from various internal systems and external data sources to provide actionable insights. * Defined and implemented KPIs and performance metrics to monitor agents productivity and service quality. * Investigated and tracked fraud cases, conducted root-cause analysis, and developed preventive scenario models to reduce recurrence risk. * Developed and maintained monthly Commission Reports for all channels based on achievement metrics and incentive structures. Monitored system outages and service interruptions; compiled detailed Monthly Outage Reports with impact analysis and follow-up actions. * Collaborated with cross-functional teams to support ad hoc analysis and continuous process improvement initiatives.
  • Senior Data SpecialistFull Time

    Next-Home For CONSTRUCTION & REAL ESTATE DEVELOPMENT

    Jun 2018 - Apr 2019 -10 months

    Egypt , Cairo

    • Job Details:- Making / Assure sales Policy For All Sales Sector ( TeleSales - Direct Sales ) Match Company Policy - Making Reports & Dashboards , Manage CRM Reports . - Creating Sales Time Rules , Target , Kpi Time Gun. - Creating Daily - Monthly - Quarters - Annual Related Reports
  • Data Analyst ( Acting Operations Manager )Full Time

    AL-Watania Poultry

    Jul 2016 - May 2018 -1 yr, 10 months

    Egypt , Cairo

    • Job Details:1- Key business partner in monthly planning 2- Perform analysis on sales data: volume, turnover, promo investment, trade stock and in store quality KPIs 3- Handling with supply chain department ( material , packing , shipping ) 4- Make sales presentations. 5- Generate reports that analyze competition and market requirements. 6- Day to day operation to include planning and organizing daily work direction for buying operations department, previous day's performance, problem solving , performance management. 7. analysis of the sales figures for all sectors of the company and compare a target monthly - daily 8. Follow-up varieties in terms of movement and rotation rate of the best-selling and follow-up near expiration 9. Preparation of the functional structure of all sales sectors 10.monthly and annual comparisons of sales figures for the various sectors of the company varieties 11.performance of sales representatives and supervisors evaluated in terms of target achievement and good customer handling and discipline at work 12. Manage A Team Of Sales Coordinators and Data Entry by leading them toward company policy and Sales Goals.
  • Education

    • Bachelor's Degree in Faculty OF Law

      Cairo University (CU)

      Jan 2006 - Jan 2012 - 6 yr

    • High School - Thanaweya Amma

      OM AL ABTAL Lang School

      Jan 2006 

    Skills

    • Microsoft Office
    • Sales Analysis
    • Data Analysis
    • Sales Planning
    • CRM System
    • Microsoft Visual Studio
    • Adobe Photoshop
    • Dashboards,Power BI
    • AX Dynamics
    • SQL
    View More

    Languages

    • Arabic

      Fluent
    • English

      Intermediate
    Share this Profile