Problem Statement
Our client is a leading wealth management firm headquartered in the US with a significant operational footprint across Latin America. The company primarily caters to high-net-worth individuals, offering a comprehensive suite of services including brokerage, advisory, and platform solutions. Despite managing over $30 billion in assets, the firm's data was scattered across siloed systems with no centralized repository, leaving teams without a single, reliable view of operations.
Key Challenges
- Lack of a Centralized Repository: Data was scattered across various SQL databases, APIs, and siloed platforms.
- Unstructured Data Overload: Thousands of legacy KYC PDF forms, both scanned and digital, had accumulated over time.
- Manual Operations: Pipeline triggering and monitoring were entirely manual, leading to consistent daily operational challenges.
- Ineffective Governance: Gaps in data accuracy and consistency existed due to a lack of centralized data governance across custodians.
Solution Implemented
- Medallion Architecture & Integrated MDM: Built Bronze, Silver, and Gold layers on Microsoft Fabric, paired with Master Data Management to ensure data integrity.
- Robust De-duplication: Employed a robust algorithm using weighted scoring across phonetic and exact-column-level matching.
- Hybrid OCR Approach with Interactive UI: Combined Python scripts with OCR fallback and editable post-scan review through an interactive UI.
- Automated Orchestration: Established an automated environment for ingestion, transformation, and real-time monitoring with 1Platform's Data Nexus.
Architecting with the Best Tech Stack
Any Challenges ?
Our Industry Experts can solve your problem.
