Data Management

Improved data management and governance for a large insurance company

Company Overview
  • US-based insurance provider
  • $56B annual revenue
Tech Overview
  • 16M Customers
  • 30 Petabytes of data
  • 100M+ Transactions annually

Business & Technical Challenges

  • 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

Canterr's Solution

  • 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

Results

  • 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