Customer Management Program - repost

  • Status Closed
  • Budget $1500 - $3000 USD
  • Total Bids 32

Project Description

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 [url removed, login to view] and SQL Server. If you have other options, please state in your bid.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online