Data base assesment

Scope of work Project 1: (i) There are certain organisations name in list A and list B. There needs to be a de dupe of organization names, say for example All Better Group Ltd., may listed as ABG, All Better G, AB Group, these needs to be identified, may be through google search and merged as one appropriate organization name. (ii) Organisations name in List B needs to be mapped on list A (iii) List A may be having about 2500 organisation names, list B may be having about 5000 organisations. A excel sheet data format will be provided Project 2: (i) There is a list of organisations, through a google search organization employee size, organisations turnover to a given criteria needs to be mapped. (ii) Each line item needs to be mapped by source, if an organization name has multiple source they need to be inserted in different coloums (iv) The list needs to be de dupped. say for example All Better Group Limited., may listed as ABG, All Better G, AB Group,, ABG lt., etc these needs to be identified, may be through google search and merged as one appropriate organization name. (iii) Organisations in the list needs to be mapped to their city and country (iv) A pivot table needs to be created by Country, employee size range, Turnover range, # of companies (v) The collated data sheet may be named a list A, List B will be provided There needs to be a de dupe of organization names, say for example All Better Group Ltd., may listed as ABG, All Better G, AB Group, these needs to be identified, may be through google search and merged as one appropriate organization name. (v) Organisations name in List B needs to be mapped on list A (vi) List A may be having about 2500 organisation names, list B may be having about 5000 organisations. A excel sheet data format will be provided