Database Update Automation for a Service Company Applying DMAIC

Abstract

Abstract – Working in a service oriented engineering organization, delivery, quality and cost reduction, are very important for a competitive and successful environment, managing data and present reports to their clients needs to be precise, accurate, and aware of the importance of the delivery date. Because of these reasons manual data management must be reduced using software programming to manage the data. The objective of this project was to reduce the manual data management from 100% to 75%. DMAIC methodology was used to identify possible causes and areas of improvement in the process. The major causes for complaints are the late delivery, missing information, and wrong data used. The standard works and workflow were updated during the Control phase of the DMAIC and a checklist was created to verify the data accuracy. The manual process was automated to a 95% and the lead time reduced in 80%. Key Terms – Customer Satisfaction, Database Automation, DMAIC, Process Improvement.