John K Mitchell's Misc Blog

As part of a project for a prospective client I have been asked to look at the state of their client information. This is held across several databases and they want to combine the information into a master data-set.

I know from experience of health authority patient Admin systems and financial fund management systems that there is more than likely going to be duplicates across the different sources of data.

Having looked, briefly, into the possibility of doing the work myself I decided that time would be be better spent if this could be contracted out to a third part.

This company can provide both deduplication software and services to merge and de-dupe data from different databases, even in different formats, although for this exercise there would be no need to use them for excel spreadsheet data.

I'll get a cost from them and build this into the quote for the prospect (I think I'll even mention the fact that the work is being carried out by experts in the field - although at this stage I obviously will not tell them who it is).