Match names in a csv file with contacts in a Salesforce Database & Create records

CLOSED
Bids
13
Avg Bid (USD)
$438
Project Budget (USD)
$250 - $750

Project Description:
Bank deposit records in a csv file need to be imported into a Salesforce custom table called Debtors.

The Contact who made the deposit has to be identified before the Debtor record is saved.

The reference in the bank deposit record has to be matched with the contact name, alias and/or phone number. These are not always accurate and often have spelling errors

A sample file from the bank is attached.
Records with codes JCRTI, TCR15, JCR10, DEP01, TCR07 are to be imported
The date format needs to be changed to an acceptable SF format
Zulu time needsto be added to deal with the time zone in Australia so the imported date is not incorrect by one day,
A custom object debtor record needs to be created including information like amount, date, reference, code
The Contact who paid this amount needs to be identified by matching the name or phone number from columns F & G with contact records
If a definite match is not available the debtor record should be saved with Contact name "Unresolved"

Question - how will you create and test this code in my SF instance when we dont yet have a trusting relationship ie we dont want you to have administator rights

I look forward to your answers. This will be the first of many SF projects

Skills required:
Salesforce.com
Additional Files: BBL+5+Jan+13+to+13+Jan+13.CSV
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 300
in 3 days
Hire NishantBamb
$ 400
in 5 days
$ 600
in 25 days
$ 400
in 5 days
$ 350
in 7 days
Hire sfdc2013
$ 500
in 3 days
Hire chandanburnwal
$ 250
in 10 days
$ 750
in 6 days
Hire subramanyamsubu
$ 350
in 5 days
$ 750
in 14 days