Emdeon Claim Vision Gene Boerger [e-mail] 615-886-9434

1
Emdeon Claim VisionGene Boergergboerger_at_emdeon.c
om615-886-9434

• Emdeon Business Services

2
Agenda

• Issue
• Current Architecture
• Implementation
• Issues
• Results

3
Problem Statement

• Create a query tool for customer service in 3
  months that will allow access to all Claims
  Tracking Information for up to 12 months.
• Must be fast with an intent to scale to 300,000
  users
• Issues
• Current tools slow or never return results
• Customer facing tools and internal tools roll up
  results differently
• Multiple tools to access multiple systems
• No visibility into how tools are working
• Across two divisions one has data view
  limitations
• Must be fully redundant

4
Current Environment
5
Current Architecture Key Facts

• Business Objects 6.1b and Business Objects XI R2
• Data Marts Star schema designs with some
  snowflaking to enable drilling across marts
• Database Oracle 10.2.0.2
• ETL Informatica PowerCenter and custom PL/SQL
• Size Largest fact table 6.4 billion rows,
  overall size 2.5 TB
• Additions 100 million rows added per day

6
Reporting Formats and Volumes

• Sample Single Day
• 2.7 million Claims
• 115,000 Files Received
• Over 1 million Reports Daily

7
Current Mart View
Product will access the Claim, Message and
Claim Status Detail Marts
8
Implemented Solution

• Reporting
• Business Objects XI R2 specifically Crystal
  Reports

• Tool
• Java developed application

• Security
• AD and LDAP integrated with Business Objects Row
  Level Security using Universe

• Logging
• Full logging of end user activity

9
Issues
10
Strategic Solution

• Reporting and Views
• Business Objects XI R2 specifically Crystal
  Reports

• Tool
• Java developed application

• Security
• AD and LDAP Application Level
• Remove integration with BO

• Logging
• Full logging of end user activity

11
Claim Vision UsageJune 1 to September 24th
12
Claim Vision Response Time
25 of Transactions in September ran longer
than 20 seconds (end user experience). Goal is
to have 80 complete in less than 10 Seconds
13
Payer Vision
14
Screen Shots have been removed.
15
Questions?gboerger_at_emdeon.com615-886-9434