Time Tracking System

Customer Profile

Sector: Biochemical & Cell Culture Reagents
Industry: Health Care

SAFC Biosciences develops and manufactures cell culture reagents and services targeted for commercial firms involved with developing and producing biopharmaceuticals. They have 6 production facilities in the US, Europe, and Australia and are the provider to more than 50% of approved drugs.

Business Situation

The company has scientists working from multiple facilities nationwide. SAFC noted the need for an efficient means for scientists to report time and expenses against a project. The previous system, based on Microsoft Access, suffered from performance issues since the application ran on a wide-area network between facilities. They needed an enhanced system that would be available for simultaneous access by scientists at different facilities. System administrators required the ability to centrally report against this data, as well as maintain project information.

Solution

Scientist Time and Project Tracking System

The team at SQL Server Programmers addressed the need for a distributed system with a web browser-based application. The system is available to internal users and offers a user interface that is simple and intuitive. Each scientist is able to run and view individual reports on their time and expenses, allowing them to manage their own project budgets. System administrators can run reports that aggregate time for all scientists and monitor project budgets. The system features ad-hoc reporting available to system administrators via a Microsoft Access Data Project that connects to the SQL Server back-end database.

Project Tracking System

The construction consulting company specializes in obtaining construc…

Change Bid Tracking System

The flight attendant scheduling company is a Chicagoland based leader…

Book Inventory System

This book supplier is a full service resource for their customers. Th…

  • Large Manufacturing Plant

    Open quoteEvery major project has gone live by the desired target date, and runs problem-free.Close quote

    - Vice President

  • Plant Museum

    Open quoteSQL Programmers upgraded our Plant Records database and Plant Production database. The new systems provide access to a scalable, reliable and user-friendly system for any user within our networks.Close quote

    - Director of Information Systems

  • A Regional Philanthropy Foundation

    Open quoteYou continually translate our business needs into successful projects within budget. Thank you!Close quote

    - Manager of Information Technology

  • A Meat Distributor

    Open quoteSQL Programmers did an outstanding job translating our needs and wants into a workable program. After the development, we have been very pleased with the support. We are currently working on Phase Two!Close quote

    - Operations and Process Support

About us

SQL Server Programmers is a database consulting firm specializing in Microsoft technologies. For over twenty years, we have assisted hundreds of companies nationwide. Our staff has extensive experience working in various industries to develop systems that manage business information. We develop desktop database solutions and integrate these solutions with the web to create data-driven websites. Our firm is a Microsoft Certified Partner, and our developers are Microsoft Certified Professionals.