BeStDAtAQUALitYSeRVice/initiAtiVe
WinneR
ShoRtLiSt
Duluxtrade
hMRevenueandcustoms dRagency
cDMStransactisGroup Segmentationanddataqualitywith
opencaseclearanceaccelerationprogramme decoratorcommunications
HMRChasabacklogofopencaseswherereturnsdonotmatchrecordsand i-level
havetobemanuallyinvestigated.Toidentifythecauseandreducecosts,it pistemap
undertookadataqualityinitiativewhichallowedittoidentifymorematches
andreducethenumberofopencases.Doublethetargetnumberofcaseswere theReaDGroup
resolvedautomaticallyintheprocess. Meta-Morphix
Abacklogof1millionopencaseshadbeencreatedwherereturnsfrom onlineBureau
employersandemployeescouldnotbematchedexactlytoindividualrecords
withinHMRC.Manualinvestigationhadbeentheonlymethodtoresolvethese,
leadingtohighercostsofcollectingrevenue.
AninitialdataqualityprogrammehadbeenusedtohelpensureHMRC
achievedmailingdiscountsbyhavingproperlydeliverableaddressdata.
Multiplesystemsanddatabses,togetherwithaprocessfocusedonthe
employerratherthantheindividual,wererootcausesofproblems.
Itwasrecognisedthatchangesintaxandemploymentmeantmorepeople
withmultiplejobs,ariseinself-assessment,shorterjobtenure,moreself-
employment,increasedmobilityandrisingimmigration.Toreflectthis,a
flexibleprocesswasneededthatcouldrapidlyaddinnewdatafeedsand
changedefinitionstoallowasingleviewoftheUKtaxpayerwithoutrewriting
orchangingprocesses.
Aproprietarydatacleansingtoolwasusedtobringtogethermultipledata
sets.Thisalsoyieldedcomplianceintelligenceandallowedadataaudittobe
done.Recursivematchingroutinescomparedeverycharacterineveryfieldin
everyotherdataset.Thisidentifiedwheremissingandincorrectdatawas
leadingtoanopencase.
Allowingmissing,invalidorincorrectdataintosystemswasidentifiedasa
majorcontributortothegrowthofopencases,compromisingtheabilitytotrace,
matchandaligninformationacrossdatabases.MatchingwascarriedoutonP1
taxrecordswherenationalinsurancenumbersorotheridentifiersweremissing,
effectivelycreatingasingleviewof1.2billionrecordsacrosstenHMRCdatabases.
Identifyingdataqualityasthecauseofopencasecreationhasledtoprocess
changes.Anadditional15millionopencaseswerematched,with10million
clearedautomatically.Thenumberofopencasesrequiringmanualresolution
hasbeenreducedbynearly50percent.
Sponsoredby:
thetRADinGFLooR
2008’sDataProvideroftheYearTheTradingFloorhascontinuedtoinnovateinthemarketplacewiththelaunchof
enhance™,thenewdataappendingservicecontainingauniqueblendofkeytransactionalandlifestyleinsightonover
20muniqueindividuals.Utilisingthedataacrosscustomerandprospectdatasetsenablesclientstocarryoutmore
preciselytargetedcommunicationswithvaluablecross-sellingopportunities-increasingconversionrates,reducingthe
costofcustomeracquisitionandenrichingthelifetimevaluesofyourcustomers.www.enhance.thetradingfloor.co.uk
0|DAtAStRAteGYAWARDS2009
Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22  |  Page 23  |  Page 24  |  Page 25  |  Page 26  |  Page 27  |  Page 28  |  Page 29  |  Page 30  |  Page 31  |  Page 32  |  Page 33  |  Page 34  |  Page 35  |  Page 36  |  Page 37