BIOMERIEUX – OTP automation

Implementation of a .Net application that will automate the export of the CLR file from CARL, the launch of the VBA Macro for printing WBS sheets, as well as the creation and printing of kanban sheets in Crystal Reports. Some enhancements have also been made to the VBA Macro. This application will be launched daily per Windows scheduled task.

For the realization of the project, 2 persons have been allocated :

• 1 Project Manager,
• 1 Development Engineers.

This contract was executed entirely with Tana Corp resources dedicated to the project.

A global player in the field of in vitro diagnostics for over 40 years, BioMérieux offers diagnostic solutions (reagents, instruments and software) that determine the origin of a disease or contamination to improve patient health and ensure consumer safety.

BioMérieux’s distribution network is present in more than 150 countries. The company is listed on Euronext Paris with sales of more than one billion euros per year.

Business processes covered by the solution

• rinting of preventive intervention sheets
• Printing kanbans to monitor the progress of the tasks

What were the most difficult features to implement?

The crucial point of the project was interfacing with the Carl Master CMMS software. In fact, all the data required for the application came from its database.

Solution: the queries needed to extract the WBSs were identified and analyzed on site in collaboration with BioMérieux’s Logistics and Maintenance Manager, Marcy l’Etoile.

Software package, software or development languages used

After analysis of all the constraints, Tana Corp proposed the realization of a custom application, based entirely on a Microsoft :

• Microsoft .Net Framework, C# language, Crystal Reports

Reasons for the choice

• Microsoft .Net with C#: In order to improve productivity, the interface had to offer good ergonomics and a good integration into the Windows operating system. In addition, Crystal Reports allows the creation of very complex reports. The choice of this technology was made in close collaboration with the customer.

Share of pre-existing developments used on which the Supplier has capitalized to complete the project

• VBA macro to open CLR files and fill in Word OTPs

• Robustness: It is important that the application can run every day without human intervention.

Today the application is used in production and has allowed considerable time savings on the preparation and printing of WBS sheets and associated kanbans.