Category: Projects

Project Title: Customer Database Cleansing Project Description: We have our customer and email data in separate silos: Salesforce and Dotmailer. With their licence expiry date approaching, we integrated Dotmailer and Salesforce to use Dotmailer’s marketing automation tool and segment more effectively within Salesforce. The input data contains duplicate records, out of date information, incorrect email addresses and had a lack of company information such as…

Project Title: Validating and Verifying Purchased Emails Project Description: I purchased some emails, a long time back and now I need to verify them. Once verified & validated, I need to send them out for my marketing purpose. As they are to be used for marketing purpose, we require most email to be correct and valid so that, there is very negligible bounce rates. You…

Project Title: Assessed Owners of Property Data Parsing Project Description: We will provide you with a list of “unparsed” text that represents names and addresses of assessed owners of property. You will analyze the name and address text string and copy/paste the different component parts of the name and address text string into separate data fields. You will have to divide component of names to…

Project Title: Data Scrubbing and Enrichment Project Description: We are a technology-enabled commercial real estate marketplace with over 35,000 properties listed for sale on our website. We are seeking an analyst to verify and augment a sample of 1,000 records of these properties listed on our site. The fields required are address, city, state, zip code, property type, net lease (Y/N), square footage, acres, NOI,…

Project Title: De-duplicating Spreadsheet Data Project Description: I need somebody who can assist me with a massive spreadsheet. We need to do the following. 1. Identify duplicates with one column. 2. Also, identify duplicates with a second column. 3. Remove duplicates from one column without removing the data from another(second) column. 4. Enriching data in second column wherever values are missing. If you are able…