Healthcare Insurance SAAS Data Warehouse



Our client is a top health insurance provider in a central metropolitan area in the Midwest United States. It covers 32 counties in two Midwest States and offers 40 health insurance plans for individuals, families, and employers. The client had a data warehouse built on a platform used for reporting and ad hoc analysis needs. The process of updating the data warehouse involved collecting patient and insurance data from different subject areas, sending data to a third party for grouper processing, and updating the warehouse with the output coming from the grouper processing.


The legacy data warehouse platform could not support the growing ad hoc and data mining needs, and they did not have an automated ETL process to consolidate all the required data for grouper processing. Our client envisioned an analytics (OLAP) platform allowing partner access in an SaaS model. The current data warehouse platform would not be able to scale to future business needs. In addition to this, the objective was to save costs by reducing dependency on third-party grouper processing vendors. This was proposed by buying a grouper product and fully integrating it with the SaaS data warehouse platform to be used by prospective clients.


XTIVIA proposed a solution that entails selecting and deploying enterprise-class data warehouse platforms, creating the logical and physical data models, integrating industry-standard healthcare groupers and custom methodologies, and report dashboards visualizations. The proposed solution would position the company towards a retail-based business model to survive and thrive through the expected 2013 healthcare reform mandates.

As part of the pre-establish phase, XTIVIA analyzed the business problem, storage needs, processing needs, and recommended Teradata Data Warehouse Appliance 2650 for hosting the Analytics Data Warehouse. The ETL solution entails extracting data from different insurance subject area sources to the landing area where the data goes through necessary sanity checks. Data from the landing area was loaded to the staging area where the data cleansing and changed data capture were performed, surrogate keys were generated, and transformations were applied before loading the data into Grouper and the Enterprise Analytics Data Warehouse.

Teradata Highlights

The data warehouse includes entities and attributes required for grouper processing. The data was sent to grouper processing, and the enriched data from grouper processing was loaded to the Enterprise Analytics Data Warehouse. The ETL processes were fully automated and scheduled on the Linux environment to run monthly. The solution also includes a flexible and secure data model to allow SaaS clients. The ETL process includes a restart capability and audit logs. Teradata Viewpoint was used for monitoring the database activities and alerting different events related to resource usage.


XTIVIA’s solution for our client allowed them to hurdle every barrier in their SaaS and data warehouse environments. With the new infrastructure in place, the client was able to enjoy the following benefits:

  • Scalable data warehouse and analytics platform.
  • A centralized analytics platform for our client and its partners (prospective SaaS tenants).
  • A flexible and secure data model for multi-tenancy.
  • Cost savings and improved efficiency due to reduced dependence on third-party vendors for grouper processing.
  • Additional revenues to our client with each tenant signing up for access.
  • A single platform enabling the sharing of best practices between partners.

Let's Talk Today!

No obligation, no pressure. We're easy to talk with and you might be surprised at how much you can learn about your project by speaking with our experts.

304 South 8th Street, Suite 201
Colorado Springs, CO 80905 USA

Additional offices in New York, New Jersey,
Missouri, Texas, Virginia, and Hyderabad, India.

USA toll free: 888-685-3101, ext. 2
International: +1 719-685-3100, ext. 2
Fax: +1 719-685-3400