Case Study | Safety National Data Warehouse Solution


Safety NationalData Warehouse Solution | Case Study

Business Challenge

Safety National is a leading provider of alternative risk funding products such as excess workers’ compensation, deductible casualty, loss portfolio transfers, and reinsurance.  The challenge for Safety National was to create a reporting solution that allowed them to do operational, analytical, actuarial, and strategic reporting with flexible compatibility across a very complex dataset. Safety National had experienced a number of challenges in achieving this in the past, and Oakwood was brought on board to overcome those challenges and implement a successful solution.

Business Solution

The solution provides a centralized and standardized data source for reporting, audit procedures, and loading the data warehouse. This was particularly useful for audit and SOX compliance reporting needs.

The data warehouse solution provides a standard star schema that isolates report writers, business users, analysts, and actuaries from the complex business rules within the data. It accurately handles the business logic transforming the data into a very accurate and yet easy to use reporting database. The data warehouse has proven very successful and many accurate reports have been created using the data warehouse in a very short time frame.


“You guys really brought in some rock stars.” – Chris Griffith, CTO


The entire solution was streamlined.  As a result, data is refreshed multiple times per business day giving valuable flexibility during peak operational periods of the year. The historical tracking and data warehouse databases are SQL Server 2012 databases and loaded with SQL Server Integration Services 2012. The data warehouse also features a SQL Server 2012 Analysis Services cube for simpler analytical inquiries, dashboards, and the like. The solution was created in small strategic steps. Users began exploring the solution and providing valuable feedback at regular intervals early in the process.

Video Overview

Enjoy this Safety National video outlining the steps we took to develop their new data warehouse.

Next Steps

Let us tackle your biggest challenges. Reach out to Oakwood and let’s discuss your business objectives and technology needs.  Please review a few of our business success case studies here.

About Oakwood

Since 1981, Oakwood has been helping companies of all sizes, across all industries, solve their business problems.  We bring world-class consultants to architect, design and deploy technology solutions to move your company forward.   Our proven approach guarantees better business outcomes.  With flexible engagement options, your project is delivered on-time and on budget.  11,000 satisfied clients can’t be wrong.  Let’s have a discussion to learn more about your business needs and goals.


Contact Us

Email

General Questions | Request a Scope of Work
sales@oakwoodsys.com

Charles Windsor | President
cwindsor@oakwoodsys.com
314-824-3000

Phone

♦ 314-824-3000 (St. Louis)

♦ 913-232-4057 (Kansas City)

♦ 800-810-8412 (After Hours)