Earlier this year Advanced Mailing Solutions has been awarded the contract to merge, standardise and de-duplicate Scottish Natural Heritage's contact data in part to ensure the organisation's data is available for a wider audience as part of the Scottish Government's SEARS/SRDP programmes.
The project involved the merging of multiple contact databases each with its own distinct data format and data requirements. This data then had to be standardised to model the organisation's central corporate data structure. Further cleansing was then undertaken to de-duplicate the data to both an organisation and contact level, whilst preserving all data for organisations and contacts that are attached to identified duplicates. Finally, to improve the quality of the remaining data, the data had to be PAF cleansed to ensure each of the addresses were accurate to Royal Mail Standards.
The project was delivered on-schedule and within budget.