Master Data Management Pilot Implementation – Medium

Approach:

Through Adastra's best practice methodology, we will deliver a pilot MDM solution, that can be expanded upon in future stages.

Scope:

• Limited to 2-3 source systems to 1 domain of customer, product, supplier, vendor, employee, or legal entity
• Consolidation style MDM for a quick win with limited matching rules
• Up to 50 fields total for the domain

Assumptions/Dependencies:

• Business SMEs at the client’s organization must be available and engaged
• Adastra must have access to production data and systems at the client’s organization
  • The MDM business case must be established
  • The MDM technology must be installed and configured within the client’s environment
  • The solution development will be complete for a limited functional scope
  • The scope of work will not be deployed to production in this phase as dependencies arise to client QA, user acceptance (UAT) and production deployment cycles
  • Out of scope functional items:
    • Business and technical workflows
    • Upstream/downstream system integration
    • ESB integration
    • MDM authoring capabilities, and fully defined user role security

Client Requirements:

• Business SME availability

Next Steps:

• Extension of MDM pilot implementation
• Duration: 14 Weeks

Activities:

• Define and implement the data model for the data domain in scope
• Design and ingest data, implement data quality rules and processes for filtering, parsing, standardization, cleansing, validation, and enrichment for identified domain data elements
• Define and implement matching and consolidation fields, rules and processes for the supplier domain
  • Define the ‘Golden Record’ and its lineage to the source
• Define and implement master data governance business workflows and processes
• Assess usage of AWS Glue Data Catalog to index the location, schema, and runtime metrics of your data.

Deliverables:

• A data model for the domain in scope
• Data quality rules implementation, process and procedure
• Mastering/consolidation rules, process and procedure
• Data quality and master data governance business processes and RACI (responsible, accountable, consulted, informed)
• CRUD (create, read, update, delete) lifecycle
• An MDM solution for phase 1
• A processes to ingest data and implement data quality rules - filtering, parsing, standardization, cleansing, validation, and enrichment
• A processes to implement matching and consolidation rules and its lineage to source
• Master data governance business workflows and processes

Outcomes:

• MDM Pilot Implementation
• A ready-to-use MDM