Context
RIVP centralizes a large volume of asset data within its ERP system, the reliability of which is a major financial factor and a constant concern. The aim of the project was to design a solution capable of cleansing historical data and justifying modifications.
Work performed
- Scoping and exploration phase: interviews with business teams and management to identify functional and strategic needs
- Source inventory: identification of files, databases and update processes, analysis of historical depth and volumes.
- Specification workshops: definition of the consistency rules to be applied and drafting of the specifications for the monitoring and alerting tool.
- Planning: scheduling and costing of subsequent phases (technical architecture, development of control modules, execution).
Results
At the end of this first phase, RIVP approved the continuation of the project and commissioned us to implement and then execute the data cleansing solution, and therefore the production of a file listing all the modifications to be made to the asset databases, as well as the justifications for each modification.