Mohamed  Raafat Mahfouz, Business Analysis And Performance Monitoring Manager

Mohamed Raafat Mahfouz

Business Analysis And Performance Monitoring Manager

Ghabbour Auto

Location
Egypt - Cairo
Education
Bachelor's degree, Management Information Systems
Experience
11 years, 8 Months

Share My Profile

Block User


Work Experience

Total years of experience :11 years, 8 Months

Business Analysis And Performance Monitoring Manager at Ghabbour Auto
  • Egypt - Cairo
  • My current job since January 2018

• Full responsibility for implementation, maintains, monitoring of Balanced Scorecard System.
• Preparation of KPIs (Key Performance Indicator) reports.
• Elicits data and reporting requirements from business leadership, and other staff, using interviews, document analysis,
requirements workshops, data analysis, task, and workflow analysis.
• Developed project plans including understanding resources and requirements, project scope, data mapping and defining
the business process.
• Tracking business trends and performance through using (Microsoft Analysis Services), (Business Intelligence Dashboard
Designer).
• Design and Implement scorecards using (BI Dashboard Designer) for All employee in (Sales and After Sales Service)
sectors.
• Create Project Documentation as required as per the project framework.
• Supporting decision making and C-Level management with required data and analysis that need it.
• Performs data analysis through Balanced Scorecard System supporting managers and subordinates with monitoring their
KPIs on (Monthly & Yearly) basis.
• Presenting data and analysis to key stakeholder groups as requested, including creating materials for and giving
presentations as needed.
• Enhance operational performance and decision-making through the advanced analysis of operational data and KPIs
reports.
• Understand the management systems and be able to recommend changes in order to continuously improve the systems
for the benefit of the operational employees and analytics.
• Support the end user with training documentation as need it.
• Be able to communicate technical solutions to non-technical people.

Senior Business Analyst and Performance Monitoring at Ghabbour Auto
  • Egypt - Cairo
  • January 2016 to December 2017

•Full responsibility for implementation, maintains, monitoring of Balanced Scorecard System.
•Preparation of KPIs (Key Performance Indicator) reports.
•Elicits data and reporting requirements from business leadership, and other staff, using interviews, document analysis, requirements workshops, data analysis, task, and workflow analysis.
•Tracking business trends and performance through using (Microsoft Analysis Services), (Business Intelligence Dashboard Designer).
•Design and Implement scorecards using (BI Dashboard Designer) for All employee in (Sales and After Sales Service) sectors.
•Performs data analysis through Balanced Scorecard System supporting managers and subordinates with monitoring their KPIs on (Monthly & Yearly) basis.
•Presenting data and analysis to key stakeholder groups as requested, including creating materials for and giving presentations as needed.
•Supporting decision making and C-Level management with required data and analysis that need it.
•Enhance operational performance and decision-making through the analysis of operational data and KPIs reports.
•Understand the management systems and be able recommend changes in order to continuously improve the systems for the benefit of the operational employees and analytics.
•Be able to communicate technical solutions to non-technical people.

Senior Business Development Executive at GEYUSHI MOTORS
  • Egypt - Cairo
  • April 2014 to January 2016

●Finding ways to leverage new markets to bring more revenue to the company.
●Perform market analyses to determine new products that should be developed.
●Project potential profits from new markets and new products.
●Train newly hired members of the business development team.
●Present ideas for new products, services and markets to management.
●Network with others in the industry.
●Keep up with what the competitors are doing in the marketplace.
●Stays abreast of trends in the industry.
●Attend industry functions, seminars and conferences to learn about market trends and changes in the industry.
●Participate In trade shows to market products and services.
●Strive to grow company profits by attracting new customers.
●Write proposals, Design presentations.
●Pitches presentations to top management.
●Write contracts and reviews existing contracts to determine if changes are needed.
●Collaborate with the marketing department on the design of promotional materials and displays.
●Generate new leads for the purpose of increasing sales.
●Research businesses and potential clients to determine their needs.
●Supervise sales follow-up work

Customer Relationship Management Executive at COMPUME
  • Egypt - Cairo
  • March 2013 to May 2013

●Deal directly with customer either by telephone, electronically or face to face.
●Handle and resolve customer complaints.
●Obtain and evaluate all relevant information to handle product and service inquiries.
●Perform customer verifications.
●Organize workflow to meet customer timeframes.
●Direct requests and unresolved issues to the designated resource.
●Record details of inquiries, comments and complaints on the system.
●Communicate and coordinate with internal departments.
●Follow up on customer interactions.
●Provide feedback on the efficiency of the customer service process.

Document Controller at Mobillink
  • Egypt - Cairo
  • September 2012 to February 2013

• Coordinating with ops. To assure that all documents are kept in right place.
• Preparation of all documents and communicating with subcontractors for work done.
• Receiving monthly report from subcontractors for work done, and revise acceptance status, sign GRN and report it to finance.
• Check on ERP monthly work done.
• Download received PO’s on ERP.
• Link sites done with sites on PO’s.
• Troubleshooting with operation in case of mismatching.
• Follow-up the acceptance internally linked with sites PO’s.
Build acceptance and report it to senior DC.

HR Coordinator at Pyramid Scientific Office
  • Egypt - Cairo
  • March 2012 to September 2012

• Leading day to day payroll administration, including biweekly payroll processing, collecting timesheets, and acting as initial degree of contact for inquiries and issues related to payroll.
• Organizing, managing, coordinating, and directing the operations and functions of personnel.
• Coordinating and participating as a selection panel member in recruitment process, including selection, appointment process, preparing reports.
• Conducting investigations and research into reclassification, classification and criteria advancement submissions and preparing appraisal reports of employees.
• Identifying, reviewing, and advising on tasks related to recruitment process and employment strategies to meet human resources requirements.
• Interpreting, assisting and advising employees and managers regarding cooperative agreement applications, leave management and benefit administration, and HR procedures and policies within the specified guidelines.
• Supporting in completion of job application materials and documents, and preparation of employment interviews and tests.

Summer training at Bank HSBC
  • Egypt - Cairo
  • July 2009 to August 2009

Summer training in Customer Service Department

Summer training at Bank HSBC
  • Egypt - Cairo
  • July 2008 to August 2008

Summer training in Customer Service Department

Education

Bachelor's degree, Management Information Systems
  • at EL Shorouk Academy
  • July 2010

Specialties & Skills

Adobe Photoshop
Administration
Preparation
Materials
Operation
System Analysis
Good knowledge of Accounting
Soundbooth CS5
Flash CS5 Core
XHTML & CSS
DBA Oracle 11g
PhotoShop CS5 For Web
Dream weaver CS5 Core
Microsoft SQL Management Studio 2012
Microsoft Business Intelligence Dashboard Designer 2010
Microsoft Office 2016
Microsoft Visio 2016
Project Management
Microsoft Visual Studio 2012
Microsoft Analysis Service 2012
Microsoft DAX Queries
Business Analysis
Data Analysis

Languages

English
Intermediate
Arabic
Native Speaker

Training and Certifications

Lean Six Sigma Yellow Belt (Certificate)
Date Attended:
May 2018
Web Design (Training)
Training Institute:
EL Shorouk Academy
Date Attended:
January 2009
Asp.net web Application Using Visual Studio.net. (Training)
Training Institute:
Ministry OF Defence
Date Attended:
July 2009
ICDL Certificate (Certificate)
Date Attended:
October 2009
Valid Until:
January 9999
English Intermediate Level – 4 (Certificate)
Date Attended:
May 2012
Valid Until:
January 9999
Project Management Professional Diploma (Training)
Training Institute:
RITI
Date Attended:
September 2015
Duration:
90 hours
Online Advertising & Media Planning -Rules (Training)
Training Institute:
DM Arts Academy
Date Attended:
February 2015
Duration:
12 hours
Social Media Marketing & Online PR-Rules (Training)
Training Institute:
DM Arts Academy
Date Attended:
January 2015
Duration:
12 hours
Oracle Database 11g Administration Workshop 1 (Training)
Training Institute:
Orascom Training & Technology
Date Attended:
November 2011
Duration:
40 hours
Oracle Database 11g Introduction to SQL (Training)
Training Institute:
Orascom Training & Technology
Date Attended:
November 2011
Duration:
40 hours
Conversational English Diploma – Elementary (Training)
Training Institute:
YAT Learning Solution
Date Attended:
April 2011
Duration:
72 hours
YAT Professional Diploma in Web Design 2010 (Training)
Training Institute:
YAT Learning Solution
Date Attended:
March 2011
Duration:
87 hours
Business Analyst Practitioner Program (Training)
Training Institute:
RITI
Date Attended:
April 2017
Duration:
56 hours