Insurance

InsuranceCompany Background
A Large Fortune 50 Health Insurance Organization that offers a wide range of products and services. This Organization offers health and supplemental insurance plans to serve all types of individuals, families, seniors, service members, and veterans.

Objective
This Organization has hundreds of Analytics users processing on large Unix Servers with EMC storage and uses Oracle as their legacy Enterprise Data Warehouse; however, Analytics processing was taking many hours.

Resolution
Destiny Corporation evaluated this configuration as it pertained to the Analytics users. Destiny designed a new architecture to support SAS/grid execution with a new MPP (Massively Parallel Processing) environment. Analytics processing typically went from 10 hours to under 1 minute with the new MPP solution.

Benefits
The new MPP environment can now successfully support all Analytics users and processes with queries running under 1 minute. This allowed for more focus on data analysis and less on Analytics processing time.


Company Background
This Large Canadian Insurance Organization provides a wide range of travel, life, health, home, auto, wealth and reinsurance products and solutions, as well as creditor and business insurance services, to individual, business, and group clients.Insurance

Objective
This Organization was dependent on sophisticated Analytics ETL and model processing; this was being executed on large servers and storage with processing times in excess of 10 hours. These long running processes were preventing data analysis from being done in a timely matter.

Resolution
Destiny Corporation reviewed the existing architecture and design that was supporting Analytics processing. Destiny determined I/O bottlenecks and designed a new architecture specifically for the Analytics environment around a new MPP (Massively Parallel Processing) solution. Analytics processing went down to 2 minutes with the new MPP environment.

Benefits
With the new MPP Analytics solution in place, this organization is capable of real time analysis, with Analytics and model processing times down to 2 minutes.



Company Background

Founded in Hartford, CT, this Fortune 50 Health Insurance Organization is committed to providing individuals, employers, health care professionals, producers, and others with innovative benefits, products, and services.

shutterstock_142314799Objective
This Organization was in need of faster query processing time on their mainframe; they had multiple Analytic environments and applications and did not have an interest in changing existing code.

Resolution
Destiny was brought to review the mainframe infrastructure and logic. Improvements were made directly to the mainframe logic without the need for any modifications of code or logic, with subsequent improvements in speed. These modifications also resulted in mainframe processing time reductions, with processing times going down from 22 hours to 2 minutes.

Benefits
The new mainframe logic and MPP(Massively Parallel Processing) environment increased query processing, allowing the increase of analytics queries, without having to rewrite any mainframe logic or code. The organization can now focus on data analysis rather than processing times.


Company Background
This Company is a leading international insurance organization, serving customers in more than 100 countries and jurisdictions. shutterstock_144026191They serve commercial, institutional, and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. In addition, they are leading providers of life insurance and retirement services in the United States.

Objective
This Organization relied on hundreds of Analytics users who created mission critical statistical models. These models were being housed on inefficient network storage and required a more robust infrastructure.

Resolution
Destiny Corporation conducted a multiple-day onsite design session with key client stakeholders. They designed and implemented a new MPP environment with new servers, creating a stable and reliable infrastructure that was capable of housing the hundreds of Analytics users. The new Analytics environment included new servers for Dev, Test, QA, and Prod with new storage. Analytics processing times went from multiple hours to minutes.

Benefit
The Organization is now capable of running and supporting hundreds of Analytics users with a stable and well-designed infrastructure, allowing more time for data analysis and reducing operation time of processes.


InsuranceCompany Background
A large, Blue Healthcare Insurance plan that is independent, not-for-profit, locally governed with a nationwide association for its subscribers.

Objective
This Organization relies on numerous Analytics processes that were being done in a Teradata environment supported by informatics. These Analytics processes were very time consuming some running for as long as 22 hours, making Data analysis challenging.

Resolution
Destiny Corporation identified the areas of the Analytics processing that were documenting having long processing times. Once the evaluation of the system was made, a new MPP solution was designed for the Analytics workload. With the new MPP environment in place, Analytics processing times went down to 31 second from 22 hours.

Benefits
This organization can now run multiple analytics processes in less time, spending more time on analysis.


Company Background
This Organization is a leader in health care financing and has served as a not-for-profit agency for over fifty years. It has a network of independent, locally operated companies.

Objectives
This Organization is responsible for creating standard reports and graphs on a monthly basis about plan utilization rates. This was being done by six analysts, each dedicating several weeks per month towards this effort. They were using a combination of software, both in the mainframe and Windows environments. Many manual processes existed which were prone to error, including the transfer of data between various different software packages.

Resolutions
We built an intelligent software application, which operates in a client server environment between Windows NT server and MVS that automatically determines the reporting periods. This application extracts data from their DB2 data warehouse, cleans it, analyzes, and summarizes it to produce web and print based standard reports and graphs. shutterstock_280365098This is one continuous process, which eliminates the need for any other software application. An administrative person runs the job once a month. They click on a front-end GUI application and the reports and graphs are automatically published.

Benefits
This Organization used to print all their reports and graphs on paper and then route them to all the doctors and providers participating in their plans. The new application that was developed freed up the six analysts from having to engage in a manual process to create monthly reports and graphs. It automated the process and made it accessible to all individuals on a real time basis. This application prints reports and graphs in a web-based environment, using HTML and Adobe PDF formats. It automatically publishes the information on their corporate Intranet.