I designed and built a solution to source, consolidate, certify and distribute 2 Master Data Domains (*) for The Adecco Group France on MDM Informatica 10.4 and IDQ 10.4.
(*) Business Organization and Human Ressources Master Data
Plan & Design Achievements :
- Established Business Project Scope with client.
- Gathered MDM High Level Requirements.
- Developped Project Plan & Build Roadmap for Incremental Delivery (Scrum)
- Assessed Data to be mastered based on legacy Oracle Data Integrator architecture
- Established Metadata Inventory from Source and consumer applications (Data Catalog)
- Assessed raw data quality (Data Profiling)
- Assessed Preliminary MDM Architecture Strategies (Batch Vs Online/BES API for distribution)
- Designed MDM Hub Conceptual Model for the 2 Domains (UML)
- Realized Proof of Concept on Business Terms Definition (Informatica DQ Analyst)
- Defined development standards for IDQ & MDM
Build Achivements :
- MDM Hub core model on Erwin Data Modeler (Base Objects and Hub Hierarchies design)
- ETL Data Acquisition with IDQ (mapping & quality transformations to load MDM Staging tables)
- Match & Merge (MDM Hub)
- MDM Data Director / Entity 360 Application (Business Entity/Views/Layouts)
- MDM Data Director / Entity 360 Hierarchies & Network
- MDM REST API (BES) publication