Customer Profile
Sector: Research
Industry: Business
Sales: $1 million
This information research firm offers custom knowledge services to help answer specific business, science and/or technology questions in the form of summarized reports. Their primary focus is to locate and make sense of the intelligence buried deep in large commercial databases, web sites, online scientific libraries, patent data, SEC and other government filings, market research reports and various sources of public information. Their clients range from Fortune 500 companies to individual consultants, laboratory scientists, market researchers and attorneys.
Business Situation
The company’s current system to track their customers and work orders featured data access pages that connected to a shared Microsoft Access back-end database. The system lacked in functionality, versatility and in ease-of-use. In addition, the response time their remote users were experiencing was unacceptable. The company also required enhancements to track billing calculation details. It was important that they maintain the querying and reporting functionality they had come to rely upon within Microsoft Access and that the system be internet based so that their staff could access the information quickly from anywhere at anytime.
Solution
Work Order Management System
The web based solution created by SQL Server Programmers enables the information research staff to easily connect and manage their customers, costs and work orders via the world wide web. Microsoft Active Server Pages on the .NET platform was used to design the new web browser-based application. Additional cost options and customized pricing was added in addition to capturing work order percent complete details. This additional information now allows management to monitor work orders more efficiently and produce billing quickly and accurately. In addition, remote staff members can now quickly connect to the database to perform their jobs just by using the web.