Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Data Entry,Google Docs,Microsoft Excel freelancer for Customer Database Consolidation job

Posted at - May 9, 2019

Toogit Instant Connect Enabled


We currently operate 3 different golf courses and are in the process of moving to a new point of sale/crm platform.

Unfortunately, our current point of sale does not share the customer profiles across the different courses. So, for a customer who plays all 3 courses, they have 3 customer profiles (3 row entries) in the aggregate list.

For some background, these lists are compiled from customers of Courses A, B and/or C. So, customers who play at all 3 of the courses have 3 rows corresponding to their data rather than just 1. In some cases, there may even be a few more with things like typos, Tom/Thomas, etc.

Here's what we are hoping to accomplish:

Ideally, we would like to be able to condense this all into 1 clean aggregate list where each customer's information is essentially merged within a single row.

Some customers have @example.com emails entered. The email field was required, so for those customers that do not have email or want to provide one, that's what was used. For customers who only have the @example.com email(s) listed, we would like those to be deleted as our new system will allow for this to be an empty field.

If a customer does have an email address within some but not all of their rows, we are hoping to be able to keep the email address on file.

The total customer count on the combined database is just over 45,000 rows. Course A has 26,000 profiles, Course B has about 12,000 profiles and course C has about 7,000 profiles.

We are hoping to turn this over with 7-10 days to be able to more easily implement our new point of sale/crm platform.

About the recuiterMember since Sep 28, 2017 Lovina Saxena
from Madhya Pradesh, India

Skills & Expertise Required

Data Entry Google Docs Microsoft Excel 

Candidate shortlisted and hired
Hiring open till - May 9, 2019

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$350.79
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Network And System Administration category.


Related Jobs


Latest In Data Entry Jobs


Latest In Google Docs Jobs


Latest In Microsoft Excel Jobs