Astera Case Studies Cherry Health Enjoys Significant Cost Savings Through Centerprise’s Data Extraction and Integration Capabilities

Edit This Case Study Record

	Cherry Health Enjoys Significant Cost Savings Through Centerprise’s Data Extraction and Integration Capabilities Astera

Cherry Health Enjoys Significant Cost Savings Through Centerprise’s Data Extraction and Integration Capabilities

Astera

Technology Category	Application Infrastructure & Middleware - Database Management & Storage Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Healthcare & Hospitals
Services	Data Science Services
Challenge	Cherry Health, a large Federally Qualified Health Center in Grand Rapids, Michigan, was facing substantial costs in managing data for its comprehensive electronic recordkeeping process. The institution used SQL Server Integration Services (SSIS) for data transfers, but the code-based environment required a specific skill set for performing data management tasks. The process of handling patient-related information was time-intensive and required manual effort. The forms were printed, shipped to a central scanning location, scanned, stored electronically in a PDF format, and then shredded and disposed of. Cherry Health sought a solution that could save its users from performing these steps and result in significant cost savings. Read More
About Customer	Cherry Health is a large Federally Qualified Health Center in Grand Rapids, Michigan. It serves a patient population of about 79,000 with a broad spectrum of specialties and services. Their core healthcare services include primary care, OBGYN, pediatrics, vision, dental, behavioral health, correctional residential, psychiatry, physical therapy, methadone treatment, and more. The institution has a network of 900 employees with over 300 providers, and a facility spanning over 26 physical locations in areas, such as Wayne, Muskegon, Barry, Montcalm, Eaton, and Kent counties. Read More
Solution	Cherry Health decided to integrate a data warehouse and analytic platform within its system and chose Astera’s Centerprise Data Integrator for this purpose. The solution was used for creating ETL jobs as part of the data transfer process, in which the data from production and reporting databases was moved to a data warehouse for analysis. The data came from various sources and formats, including text, reports, log files, PDF, Excel, and several databases. This eliminated the manual handling of patient forms and saved the time and money expended in the additional steps required to complete the process. The data extraction capabilities of the product helped pull out the data submitted on mobile devices and transfer relevant pieces of information into patient charts. This also enabled users to create a readable PDF version of patient charts for future reference and use. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Database Management & Storage

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Healthcare & Hospitals

Services

Data Science Services

Challenge

Cherry Health, a large Federally Qualified Health Center in Grand Rapids, Michigan, was facing substantial costs in managing data for its comprehensive electronic recordkeeping process. The institution used SQL Server Integration Services (SSIS) for data transfers, but the code-based environment required a specific skill set for performing data management tasks. The process of handling patient-related information was time-intensive and required manual effort. The forms were printed, shipped to a central scanning location, scanned, stored electronically in a PDF format, and then shredded and disposed of. Cherry Health sought a solution that could save its users from performing these steps and result in significant cost savings.

About Customer

Cherry Health is a large Federally Qualified Health Center in Grand Rapids, Michigan. It serves a patient population of about 79,000 with a broad spectrum of specialties and services. Their core healthcare services include primary care, OBGYN, pediatrics, vision, dental, behavioral health, correctional residential, psychiatry, physical therapy, methadone treatment, and more. The institution has a network of 900 employees with over 300 providers, and a facility spanning over 26 physical locations in areas, such as Wayne, Muskegon, Barry, Montcalm, Eaton, and Kent counties.

Solution

Cherry Health decided to integrate a data warehouse and analytic platform within its system and chose Astera’s Centerprise Data Integrator for this purpose. The solution was used for creating ETL jobs as part of the data transfer process, in which the data from production and reporting databases was moved to a data warehouse for analysis. The data came from various sources and formats, including text, reports, log files, PDF, Excel, and several databases. This eliminated the manual handling of patient forms and saved the time and money expended in the additional steps required to complete the process. The data extraction capabilities of the product helped pull out the data submitted on mobile devices and transfer relevant pieces of information into patient charts. This also enabled users to create a readable PDF version of patient charts for future reference and use.

Impact #1	Significant cost savings from not having to print, ship, scan, and shred patient forms
Impact #2	Quick turnaround times and a short learning curve for executing data integration, migration, and transformation projects
Impact #3	Streamlined workflows for automated data movement

Impact #1

Significant cost savings from not having to print, ship, scan, and shred patient forms

Impact #2

Quick turnaround times and a short learning curve for executing data integration, migration, and transformation projects

Impact #3

Streamlined workflows for automated data movement

Download PDF Version

Overview

Cherry Health Enjoys Significant Cost Savings Through Centerprise’s Data Extraction and Integration Capabilities

Operational Impact