Automated Batch Report Generation
Client: A biotech company selling automated lab equipment needed GMP-compliant PDF reports generated after every batch process. Previously, generating each report manually required pulling data, building graphs and formatting tables — a process that took several hours per run.
What we built: A custom Python application that connects directly to the equipment's SQL database, automatically pulls the relevant batch data, generates formatted tables and graphs and produces a complete GMP-compliant PDF report, triggered automatically at the end of each batch or on demand for any past run.
Result: Several hours of manual work eliminated per batch run, with consistent and compliant output every time.
OPC UA Integration
Client: A biotech company manufacturing robotic liquid handling machines for upstream bioprocess labs needed a way for their machine to be controlled and integrated directly into their customers' existing lab workflows. Previously, operators had to control the machine through its own proprietary software, making it impossible to run it synchronously alongside other equipment in an automated workflow.
What we built: A custom OPC UA server that exposed the machine's core functionality to external systems, allowing lab automation platforms, LIMS and process control systems such as DeltaV to connect, communicate and control the machine seamlessly as part of a fully integrated workflow.
Result: The machine went from a standalone device requiring manual operation to a fully integratable component that could run synchronously within any automated lab environment, unlocking new value for their end customers.
HMI Export Automation
Client: An industrial controls environment required frequent manual exports of HMI displays, dataloggers and tags to version control whenever updates were made — a multi-step process that was time consuming and prone to human error if any step was missed.
What we built: A custom automation tool that handles the entire export process in one click, automatically exporting the correct components and saving them to the right location, every time.
Result: Daily manual effort eliminated, human error removed and a previously error prone process made consistently reliable.