Aveva Monthly
Sep 13'th 2018 - Sep 19'th 2018
VWR International LLC
CURRENT PROCESS
Analyst needs to filter each and every purchase orders in the report and need to rename them with alpha-numeric content as provided by the requester.
PROPOSED PROCESS
Eliminates complete manual steps involved. Stores a table of required alpha-numeric requirements from the user and vlookups automatically as the data gets extracted from SAP BEx.
PROJECTED
Saving 30 minutes per month
The impact is significant from turnaround time, accuracy and user-friendly.
Introduced a slicer that avoids hovering to multiple sheet tabs.
ACTUAL
30 minutes per month
Analyst must do a fuzzy search & check for each and every customer purchase order number with the requirements by requestor and update them to extracted data, which involves searching and
validation at each data point.
Cost Savings
Increased Efficiency
Additional Controls
Manually separate each tab, one tab for one cutomer purchase order.
-
The official meeting with team members and management was conducted on Sep 13'th 2018
-
The Project has Gone live after getting approval with IT on Sep 19'th 2018
-
It Eliminates complete manual steps involved.
-
Stores a table of required alpha-numberic requirements from the user.
-
Vlookups automatically as the data gets extreacted from SAP BEx.
-
It introduces a slicer that avaoids hovering to multiple sheet tabs.
-
It saves time and increases the quality.