Background
Cherry Health is a large Federally Qualified Health Center in Grand Rapids, Michigan, serving 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.
Use Case
Due to an extensive network of patients, healthcare professionals, and medical centers, Cherry Health incurred substantial costs in managing data for its comprehensive electronic recordkeeping process and sought solutions to streamline this process.
Cherry Health’s needed to transform incoming data from production and reporting databases and transfer it to their data warehouse for further analysis. As data was in two different databases, it was difficult to make data driven decisions without a full picture of operations.
They also wanted a platform that allowed them to integrate data from electronic scanned forms (submitted via mobile devices) into the Cherry Health Electronic Health Record system, which contained electronic patient charts. Cherry Health searched for a user-friendly interface that would not require extensive training in SQL code and SSIS.
“Having Astera Data Pipeline Builder in our toolset means that we are virtually unlimited in our ability to perform data integration projects in our systems.”
– Andre Beaumont, Senior Database Manager at Cherry Health
Enter Astera Data Pipeline Builder
Considering the specific business needs, Cherry Health searched the market for suitable data management solutions. After reviewing several products, they selected Astera’s Data Pipeline Builder.
As Astera Data Pipeline Builder offers a high-performance, scalable data integration platform, it allowed Cherry Health to keep up with advanced data needs. Powered by an enterprise-grade, parallel processing engine, Astera Data Pipeline Builder offered Cherry Health data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform.
Profile
Cherry Health, a health center in Michigan, serves a patient population of 79,000, and boasts a network of 900 employees with over 300 providers spread across 26 physical locations in Michigan.
Industry
Healthcare
Challenges
Cherry Health struggled to manage its complex recordkeeping process, which was expensive and time consuming to maintain.
Product
Astera Data Pipeline Builder
Use Case
Astera Data Pipeline Builder was used to move data from their various databases to a single data warehouse. Additionally, they used it to extract data from scanned forms.
Results
Cherry Health saw significant cost savings from not having to print, ship, scan, and shred patient forms. Additionally, they were able to achieve quick turnaround times.
Cherry Health uses Astera Data Pipeline Builder to create ETL jobs as part of the data transfer process, in which the data from production and reporting databases is moved to a data warehouse for analysis. The data comes from various sources and formats, including text, reports, log files, PDF, Excel, and several databases. This eliminates the manual handling of patient forms. This also saves the time and money spent on additional steps and enables users to create a readable PDF version of patient charts for future reference.
Cherry Health also uses Astera Data Pipeline Builder for transforming and integrating data from its payroll system into the external learning management system. Cherry Health now enjoys quicker turnaround times for executing new projects, thanks to Astera Data Pipeline Builder’s ability to streamline workflows for automated data movement.
