Liberty Mutual is a global insurance company that offers home, auto, and life insurance for clients around the world. It is the fourth largest property and casualty insurer in the United States. Based in Boston, Liberty Mutual employs over 50,000 people in more than 900 locations throughout the world.
CHALLENGE
Two years before Caserta was called, Liberty Mutual started a data warehouse project with a different consulting firm. Due to an evolving data strategy and complex environments, Liberty Mutual and their partner had trouble completing the project. Business Intelligence requests still took weeks or months to complete, preventing the business from creating new data-driven opportunities.
The complexity of a complete data warehouse/business intelligence solution was underestimated so Liberty Mutual engaged Caserta to bring the project forward and materialize a solution of value.
SOLUTION
Caserta worked with the business and IT to gather requirements, analyze existing systems and reverse engineer previous attempts at a data warehouse solution to provide a gap analysis and create an actionable implementation roadmap.
In just four months, Caserta designed and implemented the overall solution architecture, business requirements analysis, data warehouse design, data profiling, data modeling, ETL, data cleansing, a quality assurance sub-system, database optimization, and project management.
The Enterprise Data Warehouse captured, integrated, and presented 15 years of quotes, policies, claims, providers, member retention, and other key variables from which analysts could pull valuable information.
BUSINESS OUTCOME
Liberty Mutual now has the ability to do real-time reporting that supports cross-functional analytics, data mining, and predictive modeling across the firm’s myriad operations and locations. Caserta was able to get Liberty Mutual’s Enterprise Data Warehouse up and running in four months, showing incredible time to value after their previous two-year attempt.
Caserta is one of the finest and most experienced Data Analytics Solution Providers I have worked with. I had the privilege to work with Caserta at Liberty Mutual where they managed a complex data warehouse environment. Their sound technical knowledge balanced with a systematic approach helped the project to gain momentum and direction. Given a chance, I would definitely want to work with Caserta in the future.
Hari Srinivasan
Senior Analyst
Why Our Clients Trust Us
Read unbiased independently-verified reviews from our clients to learn more about our engagements and why our clients trust Caserta to solve their toughest data challenges.