Tana Corporation
  • Call us +33478296939
  • Solutions
    • Turn your requirements into structured digital projects
    • Bring your projects to life
    • Audit your existing solutions
    • Services >
      • Custom Application
      • Custom ERP
      • Application Management (Outsourced Application Maintenance)
  • Our references
  • Quote request
  • Français
  • English
  • Search
  • Menu
  • Mail
  • Twitter
  • Linkedin
  • Facebook

BIOMERIEUX – OTP automation

You are here: Home / Home / BIOMERIEUX – OTP automation

BIOMÉRIEUX

OTP automation

The project consisted in developing a client-rich application to print Preventive Work Orders (PTOs) and associated Kanban sheets for the BioMérieux site in Marcy l’Etoile.

Total project duration: 2 months
The total cost of the project was 30 man.days

Details of the project :

Problematic

The printing process of the KANBAN PTOs/labels on the Marcy l’Etoile site involves several manual steps :

  • Daily manual launch of the generation of the WBS (Preventive Work Order) in the CARL application.
  • Starting a batch export of these WBS manually to a TXT file (CLR)
  • Manual start of an Excel/VBA macro for editing WBS and KANBAN labels

Mission statement

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.

Organization

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.

Main characteristics of the client

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.

Conduct of the project

Advice and support role provided throughout the project

  • A real force of accompaniment: The organization of the project gives a primordial importance to the quality of the accompaniment, to make the customer benefit from the expertise and the know-how capitalized by Tana Corp on its projects of the same type.
  • Consulting strength : Our solid experience on management applications in the field of distribution and fixed-price projects has enabled us to provide the customer with the best market practices in this field. Moreover, Tana Corp is a force of proposal in the highlighting of functional options likely to bring a strong functional added value.

Proposed methodology to validate the project steps from a client’s point of view

Proposed project reporting
A fortnightly steering committee enabled us to steer this project with very tight delivery deadlines.

Tools chosen for the project management
Project Management: MS Project
Incident follow-up : BugX (based on Mantis) http://www.mantisbt.org/)
Version and configuration tracking: SubVersion (http://subversion.tigris.org/)

Solution features

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.

Technical platform elements

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

Challenges and key success factors

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

Business result

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

Our last posts

 

IAFT - ASSOCIATION'S ANTI-DOPING PLATFORM

BIOMERIEUX SOFTWARE FOR MOBILE CALIBRATION

SAMM - SAMPLING ANALYSIS AND MANAGEMENT MODULE

POLE EMPLOI (FORMERLY ANPE)

Twitter Tana Corp LinkeDin Tana Corp Facebook Tana Corp

CONTACT US

Opening hours

Monday through Friday :
8:00 am - 7:00 pm

Legal notices

Contact

contact@tanacorp.com

Phone : +334 78 29 69 39

© Copyright 2019 - Tana Corporation - Site réalisé par Wolo'Graphisme - Enfold Theme by Kriesi
FAST – Processing for ultra-fast MR BIOMERIEUX – CABMLE LABEL PRINTING SOFTWARE
Scroll to top

Ce site utilise des cookies. En continuant à naviguer sur le site, vous acceptez que nous utilisions des cookies.

OK×
Un projet? Une question? A Project? A Question?

Prenez un rendez-vous dans l’agenda ci-dessous, un chargé d’affaires prendra contact par téléphone avec vous sur le créneau choisit. Si vous souhaitez nous contacter par email cliquer ici.