CTG

If you have ever watched a CNN television production or listened to a Whitney Houston album - you\'ve benefited from the work of the people at CTG. This company sells and services high-end audio and video recording equipment for companies throughout the US and Internationally. 

Following an intensive interviewing process with a variety of persons within the company -- GeoSolve Consulting made a detailed design proposal to the owners, received refining instructions and then began development work.

We created a SQL Server product that covers all aspects of customer management, job initiation, service histories, labor and material tracking and invoice generation

• When customers call to check the status on their equipment repair, CTG staff can quickly retrieve that artist\'s information and not only tell them whether their repair is complete but remind them of preventive maintenance scheduled at her studio later that week.
• The lab technicians have invested years in their training and are compensated accordingly. CTG however needs to make sure their hard work on behalf of customers is billed correctly. With this in mind we designed  labor tracking features to allow: technicians to easily record work they do for customers, shop supervisors to monitor rework events; and accounting staff to generate invoices accurately reflecting each technician\'s involvement in a project.

CTG takes customer care seriously -- and wanted an information system to help them. The product GeoSolve created for them allows them to record detailed contact information for each person within their customers company, and can be used to provide a variety of customized reports including a summary of all gear that CTG has ever worked on for a customer.