The main organizational change was implemented by assigning people responsible for master data management, such as having positions for a master data manager and a master data steering group.
The master data solution was based on SQL Server 2014 Microsoft Master Data Management (MDS), Biztalk, an Azure database, and integration services. The MDS acts as a data integration hub between operational systems that either supply or consume master data. The MDS is also a policy and a solution to keep the customer and other master data up-to-date and cleaned, and a practice to keep the critical master data in the best possible shape. For example, if duplicate customer information is entered in the system, the person entering the information will get instant feedback — this will affect the ways of working.
Siili was the lead architect in designing the MDS conceptual solution, architecture, and integrations with other systems, such as ERPs, the web-based self-service OmaVeho, and the data warehouse. Siili’s team was also responsible for implementing the required data quality (DQS) rules and policies, and configuring and running the MDS solution in primary versions. We also designed and built integrations to other systems with SlqServer Integration Services (SSIS) or BizTalk, and developed log and control reports to help the master data personnel in their daily routines.