Overview
Developed during my internship at COPAG, this Master Data Management (MDM) platform was built to centralize and automate the creation, validation, and synchronization of critical business data. By replacing manual, fragmented processes with a dynamic web application, the system ensures data consistency across the organization and significantly accelerates the master data lifecycle.
The Problem
Prior to this system, master data requests at COPAG were handled manually, leading to slow turnaround times and a heavy dependency on direct IT intervention. The lack of a centralized validation workflow resulted in inconsistent data quality and delays in synchronizing new records across various business systems.
The Solution
The solution is a configurable, generic MDM web application that allows administrators to define dynamic data models and validation rules. It features a canvas-based entry system for flexible parameter input, robust approval workflows, and automated synchronization tasks that update target databases immediately upon validation.
Architecture
MVC design pattern with Angular frontend, Node.js REST API, and SQL Server database, designed via UML conceptual modeling.
Engineering Challenges
Designing a generic master-data structure using models, canvases, and parameters
Building configurable data-entry screens for different business cases
Managing validation, de-validation, approval, and cancellation states clearly
Keeping traceability through status views and history consultation
Integrating synchronization of validated data into target systems
Tech Stack
Key Features
- Dynamic, configurable data models and input canvases
- Parameter validation and de-validation workflows
- Approval flow for validated records
- Status-based data tracking
- History consultation and audit logs
- Authentication and role-based access control
- Automated synchronization after approval