Consumer complaints are an important indicator of the perception of a product by consumers. It is also in some instances a regulatory requirement that such systems are in place. For those two reasons it is very important to have an effective system to track and analyze this type of information.
The company uses an application called CRS to enter data at the call centers. However, this software is limited in its internal data analysis capabilities. For that reason the raw data from this software is used to externally create reports.
Due to the nature of the complaint data and the output from CRS the process is highly involved and manual in nature. It can take 2-4 days of work by one of the Quality Engineers to generate a report for a particular manufacturing site (there are 4 major sites in North America).
It is the intent of this project to improve the process of creating the consumer complaint reports by using a relational database to import the data and then manipulate it to create the reports.
The University of Kansas prohibits discrimination on the basis of race, color, ethnicity, religion, sex, national origin, age, ancestry, disability, status as a veteran, sexual orientation, marital status, parental status, gender identity, gender expression and genetic information in the University’s programs and activities. The following person has been designated to handle inquiries regarding the non-discrimination policies: Director of the Office of Institutional Opportunity and Access, IOA@ku.edu, 1246 W. Campus Road, Room 153A, Lawrence, KS, 66045, (785)864-6414, 711 TTY.