case study - data management - integration and warehousing

Download Case Study - Data Management - Integration and Warehousing

If you can't read please download the document

Upload: cj-fulton

Post on 16-Jul-2015

15 views

Category:

Documents


0 download

TRANSCRIPT

  • 433 South Main St., Suite 203 | West Hartford, CT 06110 | p: 1.800.653.3144 | f: 1.860.676.8848

    20

    15 S

    CIO

    Hea

    lth A

    naly

    tics

    . All

    right

    s re

    serv

    ed.

    R

    Case Study

    Results

    SCIOservesasclientsprimaryanalyticsupportteamformaintenanceofthecomprehensivedatawarehouse

    Developedoutcomesanalysisbasedonindustrystandardmethodologyfordiseasemanagementprogram,reconcilingprogramimpactwithperformanceguarantee

    Business Value

    WithSCIOsassistance,theemployerhastheabilitytomakefact-drivendecisions,utilizinganintegrateddatasetinwhichtheycanhavefullconfidence.

    The Client

    AlargenationalemployerteamedupwithSCIOtointegrateinformationfromvariouscarriersinordertoaddresskeydatagapsandinaccuraciesandprovideanalyticstosupportdecisionsregardingemployeehealthcare.

    Clients Challenges

    Confrontedwiththedifficultyofhavingmultiplecarriersforenrollment,medicalandpharmacyclaims,retirementCOBRA,caremanagement,andHRA/surveydatasources

    Struggledtogenerateactionableanalysesandreports,duetocomplexityinlinkingdatafromvarioussources

    Lackedtheabilitytoaccuratelyandeffectivelyassesscaremanagementprogramsandvendors

    SCIOs Solutions

    BuiltrobustETLprocessforintegrationofdisparatedatasetsandsupportofongoingdataprocessing

    Provideddetailedvalidationworkbookstotheclient,whichareapplicabletohistoricalandcurrentvendorsforreconciliation

    Providedinteractivereportingdashboardthatallowsclienttoevaluatecaremanagementprogramsandvendors

    Identifiedhigh-riskpatientsforvariouscasemanagementvendorsoutsideoftheemployerscarrier

    Data Management, Integration and Warehousing

    Analytics Model

    Dataintegration Benchmarkcomparisons QCsummary&vendor

    reconciliation

    Engagement Model

    Datamartdeliveryoptions Hostedsoftwaresolutions

    Technology/Platform

    SCIOVantage Multi-dimensionalSQL

    databases