Data Management

Improved data management and governance for a large insurance company

Customer data spread across 100+ databases and apps, causing consistency and maintainability issues
Lack of single source of truth impacted data driven decisions in their rapidly growing business functions
Technical
Data integrity and security posture were weakened because of data spread and lack of well-defined IDAM policies
Lack of availability of critical talent significantly limited the ability to drive required improvements
New application development was challenged by the need to corral data and verify its accuracy / freshness

Conducted extensive stakeholder interviews to understand the existing enterprise data architecture and data storage policies
Provided 24/7 database management and remote DBA capabilities to continuously tune database performance and improve security posture
Supported a mixed database environment (e.g. Cassandra, PostgreSQL)
Migrated to Dynamics 365 by:
Designing new data architecture to consolidate, simplify and standardize access
Establishing data governance principles based on best practices
Developing a process to enforce data quality
Optimizing IDAM policies to secure data access
Migrating business logic in stored procedures to business layer

Standardized measuring, monitoring and tracking data accessing real time
Lowered operational costs, reduced risk and drove faster innovation with continuous 24/7 monitoring by experts
Overall data quality improved by 50%
# of active users maintaining the master data reduced by 45%
Storage needs reduced by 30% overall
Consolidation of databases resulted in 10M+ annual savings
Established Information Lifecycle application
Storage needs reduced Standardized processes for data governance, disaster recovery, and proactive monitoring by 30% overall