2400 Meadowbrook Parkway, Duluth, GA 30096 | +1 770-493-5588 Follow Us
Select Page

Case Study

Data Integration drives better HEDIS ratings and improved incentives for a leading healthcare payer

Client Background

The client is one of the largest health insurance payer in New York State with 1.5 million+ members, a network of 67,000+ providers and presence in all 62 counties of New York

Client Need

  • Monitor the ETL jobs which run round the clock and work towards their resolution during offshore hours
  • Handle multiple vendor requests for sharing data extracts as per the requirements
  • Analyze, optimize and migrate the existing ETL jobs as per the requirements
  • Support feature upgrades and changes for key client applications and projects
  • Handle ad-hoc business requests for customized data, job set-up or job automations
  • Maintain accurate key metrics in management dashboards and reports

Our Solution

  • Implemented a customized audit mechanism for all incoming and outgoing files from client to vendors
  • Optimized ETL jobs for better performance and short execution times enhancing the efficiency of overall support functions
  • Supported multiple FACETS upgrades
  • Automated numerous jobs end-to-end and scheduled them for easy data integration across multiple environments and applications
  • Analyzed member data from different provider groups and created extracts that help analyzing the quality metrics and achieving accreditation from state authorities

Tools & Technologies

Greenplum Database, Microsoft .NET, SQL Server, IBM InfoSphere DataStage, Information Builders WebFOCUS, SAP Sybase IQ, Denodo, Talend

Key Benefits

  • Decreased overall RCA effort and time through constant monitoring and quick resolution
  • Migrated client applications and IT infrastructure as per the current mandates helping them to standardize the processes
  • Helped plans to achieve better HEDIS ratings thereby facilitating better incentives
  • Provided central documentation of all jobs, involved DB components and architecture for easy access
  • Enabled comprehensive insights into operational efficiencies of the processes through metrics available on an operational dashboard
Key Benefits of Data Integration for an American Healthcare Payer

Let's Connect

Talk to us and know how our over two decades of experience and a strong global presence can transform your business.


Digital Product Engineering

Cloud Services

Data & Analytics

Intelligent Automation

Cyber Security

Build Operate Transfer

Talent Solutions


Communication & Media


Healthcare, Life Sciences,
and Insurance

Banking & Financial Services

Energy and Utilities



Transportation and Logistics

Innovation @ Work

Blogs and Insights

Research and Whitepapers

Case Studies


Webinars & Tech Talks
US Employment Reports


About Us


Strategic Partnerships

Office Locations

News and Events

The Foundation


Open Positions

Life @ Innova Solutions

Candidate Resource Library

Let's Connect