Client Background
• 40+ years in business
• 125+ Locations
• Offices in 5 countries
• 3,200 + employees worldwide
• $49.4B in assets under management
Business Need
• Data Governance Framework to establish policies, standards, architecture, decision-making structure, and issue resolution process
• Enhanced Data Integration and Quality
• Enrich data usability and analytics
• Better Data Security and Management
Challenge
• Complex data environment across applications, cloud data lake, and databases including:
• 100 + external datasets including uncategorized third-party data from vendors
• 26 data stores – structured, unstructured, documents
• Legacy Banking Application
• 1.0B+ rows
Scope of Service, Solutions & Results
• Installed, configured, and tested EDC, Axon, DPM on premise Linux platform
• Scanned and profiled all data from SQL Server, Microsoft SQL Integration Services, Microsoft SQL Reporting Services and third-party banking software with custom scanners.
• End to End Data Lineage•Identified, prioritized and standardized key metrics used in critical reports and business decisions.
• Established Data Quality process to identify root cause, prioritize and implement remediation efforts.
• Processed requests for GDPR, CCPA and state privacy laws
• The business was able to get a 360 view of the data usage and report to CCPA
