About Client
Honda Vietnam is headquartered in Phuc Yen, Vinh Phuc, where it operates its automobile and motorcycle manufacturing facilities, alongside a broad distribution and partner network across Vietnam.
With an ecosystem of production systems, SAP, customer service platforms, dealers, partners, mobile applications, and legacy systems, Honda Vietnam needed a centralized data foundation to connect and standardize data for analytics and management.
The challenges
Fragmented Data Ecosystem: Honda Vietnam operated 32 independent subsystems, resulting in fragmented data across multiple platforms without a centralized foundation for data consolidation.Time-Consuming Data Preparation: Producing a cross-department report required the Data Analysis team to spend 1–2 weeks collecting and consolidating data from multiple sources. The same manual process had to be repeated whenever reports needed to be refreshed.Limited High-Level Data Analysis: Fragmented data and the lack of a centralized data structure made it difficult to perform high-level analysis, particularly when combining data across departments and systems.Data Governance & Privacy Requirements: With large volumes of data coming from multiple sources, the platform needed to provide controlled data access and PII protection, while enabling users to securely consume and analyze data.Design
Replicate data from subsystems to the Data Warehouse (Oracle DB) using GoldenGate.Design the data structure for Data Marts, linking data through Global IDs such as vehicle numbers and phone numbers.Develop a tool that allows users to create out-of-the-box datasets and manage access permissions for each dataset.Build a data pipeline (job engine) to query and synchronize data into Data Marts.Implement data encryption and masking to protect PII data.Key outcomes
Centralized Data: Consolidated data from 32 subsystems into a centralized Data Warehouse.Standardized Data Foundation: Standardized and connected data across systems through Global IDs.Faster Data Preparation: Automated data querying and synchronization into Data Marts, reducing reliance on manual data consolidation.Department-Level Analytics: Provided Data Marts tailored to different departmental analytics needs.Self-Service Data Access: Enabled users to create and access datasets based on assigned permissions.Secure Data Management: Strengthened PII protection through data encryption and masking.
