case study - data management - integration and warehousing
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