Key Performance Indicator Generator
Apr'12th 2016 - Aug'16th 2016
VWR International LLC
Project Charter
PROBLEM STATEMENT
Generate 450 KPI's every month by extracting the data from SAP BEx, format them in the desired template . This involves manual copying and pasting data from separate tabs which is time consuming and have quality issues.
OBJECTIVE
Primary Objective:
-
Reducing the manual process and increase the quality
-
To extract data from SAP without manual interventions
Secondary Objective
-
To save time taken to process from 4500 Min to 480 Min by implementing automation.
-
To develop a procedure for extracting the data from SAP BEx and format various sheet tabs in excel dashboard
-
Quality check once the reports are generated.
-
To propose an alternate method that reduces the rework rate
EXPECTED DELIVERABLES
Implementing Automation, will lower the rework and increase quality, through
-
Poka-yoke
-
To extract data from SAP without manual intervention,
-
Without adding additional resources,
-
Decrease time,
-
Lower human fault,
If achieved, the Monthly KPI's could be produced with greater quality in very short time.
PROJECT SCOPE- IN SCOPE
In Scope:
Quality Management, Customer Service Satisfaction, Use of Automated tool, Time Management, Associates who run Monthly KPI's, If modified it can run Monthly Usage reports
Out Scope:
Can only be used for Monthly KPI reports
Work Break down Structure
The Tool has been created on Microsoft Excel VBA. It has been incorporated with SAP BEx query and excel VBA. It needs to run, extract, format and populate the data for the user specified time period and usage template. The QC mechanism is also incorporated successfully. If this is implemented successfully then the Turn Around Time for the stakeholder can be achieved without any issues on quality
The Tool has been created and it performs good. The user needs to open the template in BEx explorer and enter the time period in the desired cell and click "Start". When the button is clicked the tool runs, extracts the data from SAP and copies them to the respective sheet tabs and formats each tab based on requirements. The QC status can be checked whether the tool has run the report correctly. If the reports are ran correctly then it marks as "QC Passed" else the tool marks "QC Failed"
-
The official meeting with team members and management was conducted on Apr'12th 2016
-
The Project has Gone live after getting approval with IT on Aug'16th 2016
-
The Tool runs all the monthly KPI's for the month on a single click
-
It extracts data from SAP without manual interventions
-
It saves time and increases the quality