Multiple systems were being used to track product ingredients and batch traceability for a multi-billion-dollar, multi-site manufacturing company’s production process. The company needed a simple way to assemble the data from the various systems so it could be used to comply with FDA regulations, deliver a consistent, high-quality product, and allow for complete product traceability.
Our team designed and built a data warehouse to maintain the data from their multiple systems. We then documented the processes and associated data for each of the systems. Finally, the information was consolidated and migrated to the data warehouse, creating a single source for all product traceability.
Users now have a single source of truth from which to pull data for any individual product, its ingredients, and the ingredients of those ingredients.
A multi-billion-dollar, multi-site manufacturing company maintained several systems to track product ingredients and batch traceability of their production process. These records were created and maintained to comply with FDA regulations, deliver a consistent, high-quality product, and allow for complete product traceability. However, because the data lived within multiple systems, assembling the data needed to provide full traceability for a single batch spanned multiple days.
InfoWorks was hired to design and build a data warehouse to maintain the data from these multiple systems.
We began by documenting the processes and associated data for each individual system. Using this information, we designed and built a data warehouse suitable for their needs. All data was then consolidated and migrated to the data warehouse, creating a single source for all product traceability.
Leveraging the data warehouse, we produced various reports that enable the client to quickly pull data for any single product, its ingredients, and the ingredients of those ingredients, into a single report.
The client realized significant savings in the form of man-hours and reduced risk from any required FDA audits.
