The Challenge
Stallergenes implemented a new ERP to improve production and facilitate the supply and delivery processes. With the implementation of the new system, technical problems arose, resulting in the company being forced to shut down its production plant and recall already-released products due to labelling problems.
Problems to solve
- Exponential growth of data thathad to be qualified due to improperly performed migration to the SAP
- Faulty logic of the SKU (stock keeping unit) introduced with the SAP
- Data cleansing was never fully completed
- Improperly documented SKU generation for the SAP while the system was live
- No trusted reference points in data (only distributed business knowledge)
The solution
Introducing rigorous quality assurance and management tools into data integration:
- off-site teams to effectively support validation processes and delegate all development work to a nearshore location to save costs
- data management and data cleansing processes redesign: building an effective RACI and assigning ownership
- establishing two data cleansing streams: one for manual data cleansing (quick fix) and the other – automated validation based on business rules (long-term solution)
- implementation of the Alteryx tool to explore, analyze and group data for faster validation
- implementation of output validation reports that can automatically be loaded into the SAP (swift data integration)
Results
- Disrupted production restored
Can proper data management help restart a shutdown pharma production plant?