Custom Business Process Automation Software
- Manual labor reduction of ~40%
- Human error reduction
Client – Custom chemical solutions manufacturer
Problem
Our client is one of the leading manufacturers of chemical standards in the USA. They produce tens of thousands of unique chemical solutions for laboratories around the world. Each solution must have its own unique Safety Data Sheet (SDS), which lists the blend’s detailed chemical composition, precautionary and hazard statements, handling instructions and other relevant safety information.
Our client was overwhelmed by the amount of manual data entry involved in producing these custom SDS documents.
With production reaching as many as 100 custom solutions daily, the staff was spending hours a day inputting detailed chemical information into a website provided by a third-party safety compliance service.
In order to keep costs in line and reduce errors, our client needed a more accurate and efficient system to generate SDSs. In addition to internal pressures to improve the process, our client needed to abide by more stringent labeling standards formally known as the Globally Harmonized System of Classification and Labeling of Chemicals (GHS), which made the project time sensitive.
Solution
We developed custom BPA (Business Process Automation) software that allowed our client’s LIMS (Laboratory Information Management System) to communicate directly with the third-party software and generate an SDS. The LIMS then retrieves the data and generates GHS-compliant documentation, drastically reducing the need for manual data entry or human intervention.
Results / Outcomes
- Manual labor reduction of ~40%
- Human error reduction
Capabilities Demonstrated
- Business Process Improvement
- Business Process Improvement Assessment
- Business Process Automation (BPA) software development
- Custom 3rd-party software integration
- User Training
- Exception handling and alerting
- Web Portal Development
- Cloud integration
Overview
Working closely with our client’s Regulatory Officer, Product Document Supervisor and a team from the third-party safety data sheet compliance service, we developed an automated system that allowed our client’s LIMS (Laboratory Information Management System) to communicate directly with the third-party service and generate an SDS. The chemical formula and custom blend information was exported into a format designated by the compliance service and transferred via secure FTP for processing.
Once the SDS is generated, our client’s LIMS retrieves the data and generates GHS-compliant documentation, drastically reducing the need for manual data entry or human intervention.
Features
- Third Party Integration
- Windows Task Scheduler
- File Transfer Protocol Secure (FTPS)
Technologies
- Microsoft SQL Server
- .NET, MVC, Entity Framework
- Visual Basic (VB)
Need something like this?