Integration and merge of MDM Systems in the Automotive sector

Scenario

Technology Reply was hired to manage the data and process migration for a major automotive company, whose legal entity now results from the joint venture of two automotive giants, each of which had a different MDM system for customer data management. Following a challenge between the MDM systems of the two companies (one developed by Technology Reply and the other by a competitor), the system developed by Technology Reply was found to be superior in terms of reliability, accuracy, and configurability. Therefore, we were tasked with overseeing the analysis and feasibility of data and process convergence within the implemented MDM infrastructure.

With its decade-long experience in MDM, particularly in the automotive sector, Technology Reply effectively supported every phase of analysis, architectural design, and project planning. During the rollout phases for each country, several challenging aspects were addressed, both in terms of timelines and data volumes to be managed. The scenario in which the solution is framed also imposed stringent terms regarding data quality, in terms of usability and consistency, following what had already been implemented and appreciated in the existing MDM solution.

The project, in all its phases, covers data management and transformation, focusing on improving the quality of contact information to identify and correct errors and inconsistencies. Additionally, the data deduplication module, developed by Technology Reply, was used to ensure that during the convergence process between two different data sets, unique contact information was archived with the highest possible data quality based on data freshness and the relative importance of the feeding source.

The data deduplication module, through similarity algorithms and a highly configurable component, allowed for excellent results and passed all the UATs (User Acceptance Tests) of the different countries, whose requirements were highly complex and diverse based on prevailing regulations. The complexity of the project is heightened by the central role of this component within the company's strategic business processes, which require accurate data management and privacy protection to ensure the most precise and correct communication with the customer.

Solution

The solution that Technology Reply presented to the client is rooted in strong Oracle expertise and process management experience, which enabled the optimization of operations and ensured minimal service disruption.

For handling a data volume of approximately 7TB, Oracle process tuning techniques and features capable of delivering high-performance standards were employed.

The optimization of processes was achieved through the use of high-parallelism streams, query management based on the best data aggregation/movement techniques, partitioning, and indexing.

The meticulous design of the data convergence activity and process management allowed for a significant reduction in release times and ensured seamless integration with the other legacy systems.

Advantages

The advantages of using Oracle technology are various and include:

  • High Performance and Scalability: Oracle Database is renowned for its high performance and its ability to scale to meet the demands of complex business workloads. It can handle large volumes of data with rapid response times, even in environments with many simultaneous users.
  • Reliability and Security: Oracle Database is a highly reliable and secure platform that offers a wide range of features to protect sensitive data. These features include encryption, access control, auditing, and intrusion detection.
  • Continuous Innovation: Oracle continuously invests in the development of new features and improvements for Oracle Database. This ensures that clients always have access to the latest technology for managing their data.


Our Team

Technology Reply offers its experience and expertise to our customers for implementing and monitoring Oracle solutions for their processes, with a particular focus on MDM (Master Data Management) projects.

In the automotive sector, Technology Reply has acquired comprehensive 360° expertise over time, enabling us to provide competence not only in technology but also in automotive processes related to the customer journey—from initial contact to subsequent quotation and sale, and continuing with aftersales and satisfaction surveys.

This knowledge and capability have been successfully acquired through decade-long projects in the automotive field, garnering notable recognition and appreciation from clients, which has contributed to the ongoing longevity of these projects.