This is a Customer Management project. Customer data is offered in a text file. The program may load this text data into its database columns. The data mapping is user definable. User will also define a process to run on the data just before loading into database. Process will be as simple as converting the text to uppercase, lowercase and so on or more complex such as covert code into text e.g 01 becomes Mr, 02 becomes Ms and so on.
After load there is a de-duplication. The user can select one or more data fields for the system to compare the contents. When the contents match according to a pre-described percentage then the record is considered a duplicate of each other. Duplicates are tagged as such and only the master record remains as valid. There is a connection between master records and duplicates to enable users to see the complete profile/ history of the master.
Each record in the database is an individual. The ability to update and search records is a necessity.
Campaigns are run by defining a campaign and the criteria which will selects which customers will be selected. This will be tagged back to every customer record so that we know which customer previously in which campaign.
The preferred tools are SQL Server and VB.NET.
Skills required:
.NET, SQL, Database Administration, Visual Basic