Choose your language:
Ochsner Health System opts to deploy a new EpicCare electronic medical record (EMR) system and engages TEKsystems to support its critical preliminary data cleansing and data migration effort.
In preparation for the EpicCare implementation, Ochsner needed to obtain business intelligence across multiple systems in order to gain a clearer understanding of the data stored enterprise-wide. In doing so, the company hoped to curb many of the issues it was now facing due to its data being housed in so many stand-alone systems. One such challenge was the business reports that the company required took an incredibly long time to run because each data warehouse needed a separate extract-transform-load (ETL) process to capture the requisite data for each report. To accomplish this, the ETL team manually generated reports to supply data to the different business units, and this underscored the pain associated with redundant processes. The next step was to migrate each of the stand-alone systems to a centralized electronic data warehouse (EDW). The Ochsner management team decided to accomplish this via an Oracle data warehousing tool. Ochsner also had a four-month deadline for its parallel EDW effort which required importing 80 percent of the data into the new centralized system. This conflicting priority and the company’s limited resources meant that some business units were going to have to wait the full duration of that four-month period before receiving their BI reports.
The current process was highly inefficient and time-consuming and because of the repetitive nature of the company’s reporting needs, this was a consistently frustrating challenge. Unfortunately, this lead to a stressful work environment for Ochsner’s existing staff and the company needed to take immediate action in an effort to motivate and retain its workers. The plan was to build the new centralized EDW and create specific data marts that would house each particular type of data (i.e. hospital billing, patient visit information). Having enjoyed a long history of successful projects, Ochsner once again turned to TEKsystems for human capital management (HCM) expertise, and our ability to quickly mobilize a full team of capable ETL resources.
To alleviate Ochsner’s data challenges, the TEKsystems team sought to create an electronic data warehouse (EDW) to serve as a solid foundation and an analytical platform custom built to meet the organization’s ongoing need to have the right data easily accessible by the right person, at the right time and in the right format. We began by conducting a thorough assessment of Ochsner’s internal data environment including an audit of each of the siloed databases. In order to achieve a “single source of truth” structure, we also found a need to improve data collection and governance procedures. The TEKsystems team worked collaboratively with the client-side staff to document a roadmap to achieve these goals. As a result, TEKsystems deployed a 12-person team charged with creating an integrated EDW structure capable of producing true business intelligence, real-time reporting and rich analytics.
A dedicated project manager (PM) was appointed by TEKsystems to act as the primary liaison to the client decision makers. The PM was also accountable for oversight of the entire project. The team’s lead business analyst engaged Ochsner’s key stakeholders to capture data requirements from the business units and ensure that all the data components were moved efficiently and effectively. Then our data architect provided oversight for ETL, migration and EDW development processes, while ETL developers were tasked with the actual extraction, transformation and loading functions required for mapping the legacy data from the multi-system structure to the new centralized EDW. TEKsystems deployed a small team of data modelers who, using a star schema data model and online analytical processing (OLAP) technology, built analytics to enable business units to view and manipulate graphical representations and a real-time dashboard view of its data.