Custom Business Process Automation Software

Automating manual data entry & integrating with 3rd party 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

Capabilities Demonstrated

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

Need something like this?