by Joseph Brady, Director of Business Development at Treehouse Software and Eleonora Savova, Cloud Solutions Architect at Treehouse Software

Every major insurance policy begins with the same foundation: understanding historical claims data to determine how often claims occur, what they cost, and which factors drive risk.

Data analytics has always been the insurance industry’s lifeblood, with actuarial efforts relying on sophisticated analysis of historical data – an approach that, in many ways, resembles how modern machine learning (ML) techniques are used to quantify and manage risk and uncertainty.

All insurance companies hold decades of valuable data across legacy mainframe and non-mainframe systems. Actuaries, data scientists, and other analysts need data delivered into modern analytics environments in a reliable way. Treehouse Software addresses this challenge in the most straightforward and efficient manner by connecting legacy data to today’s top analytics platforms. Our Treehouse Dataflow Toolkit (TDT) enables rapid bulk load and change data capture (CDC) from multiple data sources into Snowflake and AWS. As part of this process, TDT automatically provides the required target infrastructure, making the data immediately available for Analytics, BI, and AI/ML operations.

TDT serves as a key component within AWS-based actuarial analytics architectures, enabling insurance organizations to move away from slow, on-premises, batch-oriented processes and toward scalable, cloud-native systems. These architectures leverage high-performance computing, data lakes, and serverless technologies to automate data ingestion, modeling, and reporting, reducing processing times from days to minutes.

With TDT handling data delivery, actuaries and data scientists can access analytics-ready data through platforms such as Snowflake, Amazon Redshift, etc. TDT operates in the background, ensuring that the most recent data is consistently available without manual intervention.

TDT Value and Benefits

Beyond delivering your data, TDT is MUCH more than a mere “connector”. It is a fully configurable end-to-end solution designated to manage the complete data delivery lifecycle. TDT’s advanced crawler capabilities automatically prepare landing tables, views, and staging infrastructure required by the target.

TDT is built in alignment with AWS’s and Snowflake’s best practices, ensuring proper security and performance. This consistent adherence to best practices is a key differentiator that sets TDT apart from many other “connectors” on the market.

From an actuary’s perspective, effective dataflow tooling with TDT delivers tangible benefits:

• Fewer reconciliation issues with Finance
• Greater confidence in analytical results
• Faster turnaround on urgent questions from leadership

In short: better data → better actuarial judgment. 

Treehouse provides highly-detailed CloudFormation Templates which automate and accelerate the process of installing and configuring the complete TDT application (including AWS Lambda functions and a number of other AWS resources) in your AWS account(s). The TDT CloudFormation Templates create stacks consisting of all principal framework components, along with related IAM policies and roles which are carefully engineered to comply with “best practices” (such as a “least privileges” approach to permissions).

The TDT CloudFormation Templates also optionally provide for automatic creation of a VPC, its subnets, and all required standard VPC-oriented resources, as well as optional creation of a source database cluster (consisting of either a sample database provided by Treehouse for a quick trial/POC, or your own database and data).

Simply put, TDT is a Cloud-native, turnkey solution that can eliminate months (or even years) of research and development time and costs and allow customers to be up and feeding data to an actuarial analytics architecture in minutes.

Visit Treehouse Software on the AWS Marketplace for all of our Cloud offerings…

Treehouse Dataflow Toolkit (TDT) and TDT-DIRECT are Copyright © Treehouse Software, Inc. All rights reserved.

---

Contact us today to schedule a demo!