Manufacturing Process Management System & Data Warehouse (J&J/Merck Consumer Products)

Designed, developed, and deployed a process management system for a pharmaceutical packaging plant serving 10 users. The system collected, recorded, analyzed and reported on process metrics such as cycle times, equipment downtimes, product quality, and batch release criteria. The application was built on SQLServer using a federated data model utilizing data from SAP, and manufacturing, quality control and laboratory management systems. System services extracted and cleansed data. Analysis services were used to build cubes. Business logic was implemented in .Net (VB/C#), with Business Objects as the graphics front-end.