Portfolio > MedicAlert Foundation

SwansonSoftware Home | Site Index | View With Frames

Customer Call Tracking System

Customer Support is a Web-based customer call tracking system. Functionality includes ad hoc reporting, role-based security, online help, and Web-based system administration. The system was created using MS SQL Server 2000, TSQL, ASP, Behaviors, CSS, ActiveX controls, and JavaScript. Everything was coded by hand using TextPad©.

I did the system design and development, compiled requirements specifications gathered through work with users and a product champion. This system improved customer service by tracking customer requests so they would stop falling between the cracks, and lowered support costs by improving the efficiency of support.

Images - click an image to open larger image in a new window:

		My Calls page. Only the support calls assigned to the user appear in the list.

		New Call page. New calls are entered here.

		Search Calls page. Users enter search criteria and choose the fields they want displayed in the results.

		Help - Note this is not a CHM

		User-defined Report - created with Query Builder. Note that this report was saved by the user as a 'Private' report, so other users don't see this report.

		Query Builder

		Knowledge Base - create new article

		Knowledge Base - search

		Knowledge Base - search results

		Knowledge Base - edit an article

		Administration Page - table administration. Add or change values in system tables.

		Administration - Table Maintenance, brought up with "Modify Values..." button on table administration page.

		Administration Page - User Setup. Add or change users.

Some of the features I want to point out:

Column headers on tables - these are buttons that were created using Internet Explorer behaviors. Click one and a client-side sort of the grid occurs on that column, alternately ascending/descending.
Query Builder - allows ad hoc reporting, with ability to save report definition as public or private so the report may be run whenever the need arises.
My Calls - the user sees only the issues that are assigned to him or her. Users can search the database for other calls also.
Email notification - users can be notified by email when a call is assigned.
Email response to customer - these can be generated using built-in functionality, and responses are saved with the call.
Knowledge Base - full-featured knowledge base that enables customer self-help.
Full Web-based administration - user maintenance, report layout, and field values can be added, removed, and changed using the Admin page.
Help - complete system documentation is available and presented in HTML format using the HTML Help Java applet.

Top of page