Allergan Weekly report
OBJECTIVE
In Scope:
Quality Management, Customer Service Satisfaction, Use of Automated tool, Accounts specific, Time Management, Associates who run Allergan Weekly.
Out Scope:
Can only be used for Allergan weekly reports
Implementing Automation, will lower the rework and increase quality, through
-
Poka-yoke
-
Without adding additional resources
-
Decrease time,
-
Lower human fault,
If achieved, the Allergan weekly reports could be produced with greater quality.
PROJECT SCOPE
EXPECTED DELIVERABLES
Oct'3rd 2016 - Nov'7th 2016
VWR International LLC
Project Charter
Primary Objective:
Reducing the manual process and increase the quality
Secondary Objective
-
To save time taken to process from 90 Min to 5 Min by implementing automation.
-
To develop a procedure for Quality check once the reports are generated without manual intervention to reduce the error.
-
To propose an alternate method that reduces the rework rate.
PROBLEM STATEMENT
Generate 8 Allergan individual reports every week that requires more manual steps which prone to have human fault. Exporting them manually to PDF has alignment problems.
Work Break down Structure
The Tool has been created on Microsoft Excel VBA. It has been incorporated with SAP BEx query and it needs the SAP BEx analyzer to pull the data for mentioned Allergan accounts for the user specified time period. The QC mechanism is also incorporated successfully. It can also export data in both Excel and PDF formats based on the requirements. If this is implemented successfully then the Turn Around Time for the customer can be achieved without any issues on quality.
The Tool has been created and it performs good. The user needs to login SAP BEx and open the template into the BEx explorer. Enter the time period in the desired cell and click "Start". When the button is clicked the tool runs 8 excel files and exports 8 PDF files in less than 5 Minutes. The QC status can be checked whether the tool has run the reports 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 Oct'3rd 2016
-
The Project has Gone live after getting approval with IT on Nov'7th 2016
-
It saves time and increases the quality