Your Company

 




©2000-2003,
Innovative Office Systems
All rights reserved.

Address:
8180 Greensboro Drive Suite 700 McLean, VA 22102
Phone: 703-714-1304
Fax: 703-714-1330
E-Mail: info@iosweb.com

 

Complaint Manager

Overview

    Complaint Manager is an online application currently under development by Innovative Office Systems (IOS) on behalf of a telephone company client that needed an efficient, automated way of tracking customer complaints. A very basic version of the Complaint Manager has been operational for over one year. It is now being enhanced with more sophisticated reporting features.

    Beyond the specific functionality and capabilities of the Complaint Manager, this tour should also demonstrate IOS’ capability to integrate an add-on application with the “look & feel” design of the customer’s website.

Application Features

Submitting Complaints

Click to EnlargeCustomers may submit a complaint by using a Customer Feedback Form that can be found on the telephone company’s website. Note that the form has been designed similarly to the company’s website.

(WCSS2001.com in example shown)

After filling in all of the required information, three actions occur:

  1. The details are emailed to the Complaint Manager administrator.
  2. A record is added to the online database with the same details.
  3. The customer receives confirmation record of submitting the complaint in one of two ways:
        a. If an email address was provided, the customer receives an email.
        b. If no email was provided, a printable web page with all of the details opens.

Managing Complaints

Click to EnlargeAfter logging in the administrator can choose to view a list of all complaints received or only the ones that have not yet been resolved (“Open”).



Click to EnlargeFrom either list, the administrator can click on the name of an entry to view all of the details originally submitted plus some additional fields for further record keeping (Resolution Yes/No and Notes, Comments).

 

Also, from either list summary page, administrators can add new complaints received directly by phone, fax, email, or letter.

Advanced Data Management

    IOS is presently working with the client to develop enhancements that will allow more informative reporting, searching, and sorting capabilities. The database will be modified to add a complaint type field. This will allow users to parse and group data by State and complaint type.

Click to EnlargeCriteria selection is made through a user friendly screen. Then the user clicks whether a listing or summary should be displayed.

 

 

Click to EnlargeThis list view page gives quick access to sorted/filtered records that are specified on the criteria selection form.

 

 

Click to EnlargeThe summary page gives users a cross matrix report format that groups and summarizes the data.

Services Provided:
- Record Tracking/Management
- Web Development
- Reporting

Technologies Used:
- Microsoft Access
- ASP.NET

- Microsoft FrontPage
- SQL Server