We have multiple customer databases (5) that have been extracted into excel files. Each database has common and unique data. The objectives of the project is to merge all the data into one database, allowing us to see in a single view which databases the customers original comes from, merging the common and unique database fields together whilst showing which database the data was sourced from.
There is some complexity with the merging the data as customer names etc may not match 100% (different spelling etc) , but the successful freelancer will need to make a genuine effort in washing the database as much as possible and find as many matches as possible.
The database contains sensitive customer information and the successful freelancer will need to respect or uphold our privacy laws and delete all files once the job is complete.
The final file will have to be in a standard Microsoft Office file. Micrsoft Access is not available.