This is a Customer Management project. Customer data is available in a text file. The program will load this text data into its database columns. The data mapping is user definable. User can also define a process to run on the data just before loading into database. Process can 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 deduplication. The user may select one or more data fields for the system to compare the contents. When the contents match according to a pre-defined 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 link between master records and duplicates to enable users to see the complete history/profile of the master.
Each record in the database is an individual. The ability to search and update records is a necessity.
Campaigns are run by defining a campaign and the criteria which will choose which customers will be selected. This will be tagged back to each customer record so that we know which customer previously in which campaign.
The preferred tools are VB.NET and SQL Server. If you have other options, please state in your bid.