State Auto Insurance Companies: Boosting productivity with advanced analytics

About State Auto Insurance Companies

State Auto offers insurance products including auto, home, and business, through independent insurance agents. Based in Ohio, State Auto operates in 33 states.

Industries: Financial Services & Insurance
Location: United States

About Datametica

Datametica assists with EDW to GCP migration through innovative frameworks that automate planning, code conversion, data migration, and validation during modernization.

Daily tasks at State Auto include running complex actuarial analysis and reports. When staff sought to move away from the company's legacy solution, reducing operating costs and improving platform performance were top priorities. Administrators also wanted to eliminate problematic data siloing to optimize network efficiency.

Google Cloud Results

  • Cuts development time on new platform by 45% and maintenance costs by 55%
  • Reduces query execution times for most queries by up to 90% via BigQuery migration
  • Improves team effectiveness by introducing AI and advanced analytics through Google Cloud Platform

50% increase in customer engagement speed

Enabling Change

Solutions: Data Analytics
Workloads: Data Warehouse; Streaming Data Analytics

BigQuery is the primary data lake solution for State Auto Insurance Companies ("State Auto"), offering substantially faster query times for employees compared to its previous data lake solution within Netezza. For instance, an 800GB query that previously took three hours on the company's legacy solution can now be executed in seven minutes.

The performance gains from BigQuery and Google Cloud Platform allow actuaries to efficiently evaluate and process customer insurance policies, leading to additional opportunities for revenue and customer growth. Cloud Dataproc provides auto scaling and manages Apache Spark jobs, while Cloud Storage offers a unified back-end location for internal data. This in turn helps State Auto use its resources efficiently without sacrificing performance.

By moving to Google Cloud Platform, State Auto benefited from simpler platform management resources, reduced costs, and improved data security for high-value customer information. Having its platform hosted on a single location eliminates data siloing, simplifying its IT architecture and allowing the company to explore machine learning applications to further advance its analytics abilities.

Google Cloud Premier Services Partner Datametica played a vital role in the data warehouse migration process to BigQuery, helping to seamlessly implement the new processes and technologies without disruption. Datametica continues to support State Auto in its endeavors and its move to the cloud for data management and analytics capabilities.

"After moving to Google Cloud Platform, we've seen query times go down from hours to minutes. From an IT standpoint, these types of material gains are exciting and make it easy to see the upsides of migrating to Google."

Krishna Tummalapalli, Enterprise Data Architect, State Auto Insurance Companies

About State Auto Insurance Companies

State Auto offers insurance products including auto, home, and business, through independent insurance agents. Based in Ohio, State Auto operates in 33 states.

Industries: Financial Services & Insurance
Location: United States

About Datametica

Datametica assists with EDW to GCP migration through innovative frameworks that automate planning, code conversion, data migration, and validation during modernization.

Google Cloud Platform logo

12 Months FREE TRIAL

Try Kubernetes Engine, BigQuery, and other Cloud Platform products with $300 in free credit and 12 months.

TRY IT FREE
Google Cloud Platform logo

12 Months FREE TRIAL

Try Kubernetes Engine, BigQuery, and other Cloud Platform products with $300 in free credit and 12 months.

TRY IT FREE