Data Warehouse Implementation for a large US based Healthcare Payment Cycle Management Companies

Hemesh Thakkar

One of the largest financial and administrative healthcare networks in the United States wanted to consolidate data from multiple Business Units into a company wide consolidated Data Warehouse for their Business Intelligence applications.

Accion Labs built a Data Warehouse and consolidated data from multiple Business Units within the company to enable consistent reporting of KPI metrics. The client built multiple Business Intelligence applications that read data from this Data Warehouse resulting in improved decision making through actionable insights.

CHALLENGES

Data integrity issues due to fragmentation of data across different data stores
Cumbersome manual process in collating data using excel spreadsheets
Repetitive manual tasks computing and pivoting data to generate reports
Inconsistent KPI reporting across Business units

SOLUTION

Transform staging data and place it into the Product Analytics Data Mart
Build and deliver a logical and physical data model for the Data store
Build and deliver data ingestion routines that pull the datasets from the data exports/source systems to populate the designed integrated data store at scheduled intervals
Assist Operations team in rollout activities and knowledge transfer
Assist Support teams with post rollout maintenance and support

BUSINESS BENEFITS

Ready availability of actionable data for improved decision making

Data accumulated over time to be utilized to lead change by enabling smarter healthcare

Enable visualization and transparency into the working of the clients various business units.

Reduce wastage and improve process efficiency to simplify administration and enhance payment processing for the client’s customers