Capacity Monitoring

SOLUTIONS

.NET application

INDUSTRIES

Pharmaceuticals

COUNTRIES

Czech Republic

EFFORTS

3 MMs

THE TASK

For certain medications to retain their efficacy, they must be stored in stability chambers under precisely controlled climate conditions.

Meeting the special storage requirements for a large inventory of prescription drugs can be rather difficult. When a growing pharmaceutical company found that its solution for managing this process was no longer ideal, it turned to us for help. The organization used an Excel file to keep track of the medications stored in stability chambers. We replaced this method with sophisticated inventory systems - a dedicated solution that included advanced features such as collaboration and stability chamber utilization planning.

THE PROCESS

Managing the stability chambers was no ordinary matter - if imperfectly executed, the customer's daily operations would be severely disrupted.

That's why we carefully studied the old solution to make sure that our new, more effective one would flawlessly integrate its functionality without missing anything. (Our Microsoft developers were particularly interested in the customer's approach to monitoring chamber capacity.) After we conducted our analysis, we determined the exact relationship between the information in the Excel file and the inventory of products stored inside the chambers. This knowledge allowed us to create a highly intelligent application that streamlined and automated the customer's pre-existing processes. (In order to incorporate these processes into a convenient, easy-to-use software, we've engineered a data structure, SharePoint workflows, and a UI.)

THE SOLUTIONS

Our SharePoint Team has delivered a stability chamber capacity monitoring solution with the following features:

Web application that keeps real-time records of individual stability chamber capacities using SharePoint for document management

Automatic inventory recalculation based on merchandise manipulation reports (in volume units)

Up-to-date inventory log

Permission-based access

Audit log

Versioning

THE RESULTS

After our solution was successfully implemented at the client's manufacturing plant, we did not stop there. In fact, our SharePoint consultants also offered the client a convenient medication identification system. With this new system, various medication-related data - such as batch number, manufacture and expiration dates - can be easily accessed via QR codes affixed to the products with labels. This feature is both software and hardware based - the software consists of a QR code generator and an inventory log, and the hardware of a PDA QR code reader and a label printer.

The work invested into the creation of this new system paid off - the company now has an efficient process to tag information to products, and to retrieve this information from an application. This is a significant improvement over their previous method of manually labeling the medications and storing the information in an Excel file.