Closed

Customer Management Program - repost

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.

Skills: Banner Design, Graphic Design, SQL, Visual Basic

See more: vb net project management, match management, design history file, define graphic design, define graphic, covert file, compare ms project, banner pre design, know your customer, select the program design or design, define project management, sql duplicates, records management , mr y, database management project, customer management, campaign management, campaign program, project management tools, customer record management, record management system database, simple management program, complex project management, customer data, project management records

About the Employer:
( 0 reviews ) Cainta, Philippines

Project ID: #5357262