SHOW ME THE MONEY! USING DATA TO MANAGE PAYERS04/28/2017
AnalyticsCultureData GovernanceDeploymentEventsRevenue Cycle All posts

Picture

Situation 
Who doesn’t want to make sure your payers are meeting agreed upon contracts?  Monitoring contracts is more than just having an employee reviewing large contractual write-offs or denials.  You need to be able to aggregate data to find trends and then drill into the details.  Prominence worked with a customer to do just that!
The organization wanted to gain insight into their costs, volumes, claims, and membership metrics across their payers to identify potential cost-saving scenarios and profitability opportunities. The Employee Benefits team needed the ability to analyze their Employer Plan claim files to gain insight in their providers’ utilization costs, as well as to monitor their members’ level of medication compliance required to manage chronic health conditions.

Previously they were unable to:


Task 

The Prominence team was tasked with aggregating ten different monthly files received from their payers, which included claim, pharmacy, PMPM costs, and membership files.

We were asked to:

Action 
To start, the Prominence team built an architecture to facilitate the mapping and combination of claims files, allowing the organization to trend information over time and analyze metrics across multiple payers. Next, we built an application that allows metric comparison across providers, facilities, and payers.

The goal of the application is to guide users in identifying potential problems, such as:

Result 
The organization quickly realized a return on investment:

  • Physician leadership identified a trend in physicians prescribing brand name drugs when there were generic alternatives and work with them to reduce costs by changing their prescription habits
  • Department managers were able to use the application to identify care gaps with their patients and work proactively to close them
  • Leadership was able to review scenarios where patients were seeking services in outside organizations and work to reach out to these patients to bring them back
  • The reporting team has easily maintained the extensible extract and visualization tools that allow them to make updates without actually touching the extract code should the raw claims structure ever change
If you have questions or are interested in hearing more, please email us! prominencesales@prominenceadvisors.com
Recent Posts
Tableau Conference is truly a one-of-a-kind event! Every year, our team looks forward to attending so that we can learn about new features that are c…
Healthcare organizations today have more data than ever before.  However, the majority of that data resides in disparate data sources or databases th…
Working at Prominence, we pride ourselves on helping hospitals get the most out of their data to become data-driven organizations. And while we are p…
When I watched Inspector Gadget growing up, I constantly dreamed of having a book-like computer and a watch you could ask questions to and talk to pe…
As we talked about in our recent Dear Data blogs, our Analytics team uses data in innovative ways that bring value to healthcare organizations and th…