Ruby On Rails Developer

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Freelance

WAGE / SALARY

Negotiable

HOURS PER WEEK

TBD

DATE UPDATED

Jan 12, 2015

JOB OVERVIEW

I am looking for an excellent Ruby On Rails developer for small to medium-sized web-based projects, but I will start with a short-term project script to test your capabilities and to see if we like working together.

This project will take as input a 200,000 record CSV file with these fields:

email address, order date/time, product name, price, sku

It will be sorted by email address, then by order date/time

The script should first parse the file and extract all the unique product names, sorted alphabetically, and then stored them in another csv file.

Then it should prompt the user to select one of those products and calculate the "dollars per lead" (DPL) for that product where it is the first product purchased every 30 days for up to 365 days, and then a "lifetime" value through the end of the csv file.

DPL is calculated as follows:
* If the product selected is the first product purchased, add the price to a total, then check to see if that customer purchased any other products after that - if so, add those prices to the total.
* Based on the order date/time, every 30 days, do a DPL calculation by dividing the # of unique customers by the total sales.

Finally, display a web-based line graph plotting the DPL value on the y-axis and the days on the x-axis.

I will provide sample data.

SHARE THIS POST
facebook linkedin