Critical Issue:

The client wanted to replace a manual Excel-based series of spread sheets with a SQL Server database solution.

Reasons:

To centralize company data and enhance business operations.

The Comdyn Group Provided:

The Comdyn Group developed a multi-tiered system solution using a Visual Basic and SQL Server. All database operations are performed via stored procedure for improved performance.

Other functionality includes managing product test results and allowing for reporting and trend analysis. Some reporting is generated through Excel automation, including complex charting of regression lines and statistical 95% confidence intervals.
The system has undergone and passed a rigorous FDA validation process by an independent organization. The new system has now been in use at the client for several years. It has substantially reduced the labor required to maintain, analyze, and report on the test results.

 Results:

“I have been extremely pleased with not only the results of the finished project, but as importantly the personal attention to detail and cooperative nature of Comdyn professionals working together to ensure the project is completed on time and within budget.”

Jim Branigan, Director of Manufacturing and Logistics, Novartis Animal Health