1 minute read
IS Data Management
by ochsnerweb
The Numbers
0 Employee Turnover
936 Service Requests Closed
$450,000 Saved by Removing the Need for Vendor Support by Creating and ISDM Solution for Ochsner Health Plan (OHP) Pharmacy Benefits Management Vendor
Payment Method – Reconcile hundreds of credit card payments that were not possible before
Same Day Messaging - reducing process runtime by 50+ minutes
The Accomplishments
IS Data Management Operations and Infrastructure Improvements:
• Improved IS Data Management Operations by Automating Informatica Failures Email. Improved Employee Engagement by Providing Process Education and Tools Needed to Perform their Role.
• Improved Database Monitoring and Management of Long Running Queries and Reduced the Number of Load Failures.
• Successful Upgrades: o Caboodle/Clarity (EPIC Database/Data Warehouse) o Slicer Dicer o Oracle Upgrade for Clarity and Enterprise Data Warehouse (EDW)
• Developed an Internal IS Data Management Advisory Group to Improve Processes:
The Projects
Ochsner Health Plan (OHP):
• Created Quick Turn-Around Solution for Ochsner Health Plan (OHP) to Provide CMS Data for Pharmacy Benefits Management Vendor.
Ochsner Health Network (OHN):
• Successful Integration of External Payer Claims for Risk Populations in Epic
• Created EPIC Extract for Quality Measures to Improve Quality Scores used for Gated Risk Contracts, such as, Humana.
• Unique Person Identifier using Profisee Master Data Management for Risk Populations
Ochsner Partner and Acquisition Support:
• Successful Support of Data Extracts for Coding Vendor, MedKoder, to improve Hierarchical Conditional Categories (HCC) Capture and Improve Risk Scores Capture and Pay for Performance Metrics and Payments.
• Developed Parsing Methodology and Integration of Legacy 835/837 Pre-Adjudicated Claims Data to Transition Operations from New Ochsner Acquisitions to Centralized Ochsner
• Developed Multiple RVU Data Model to Support RVU Reporting for Ochsner and Ochsner Partners/Acquisitions
• Integrated Active Directory Data from Partner Domains
Ochsner Health Plan (OHP) Go-Live Support
Data Warehousing for Research and Grants
Support of New Payment Models through Data Integration into EPIC
