Homebased early childhood company (300 homes, 400 children). Uses SaaS app to administer records but SaaS app is set up to operate for centres and Kindergartens. Need to extract data as follows:
The successful freelancer will develop process for this extract and deliver datasets for Feb, Mar, Apr 2017, and will deliver their code for the exercise. A second project will look at future analyses including May analysis and transitioning ability to the company for future use.
The output needed lists for each child (indexed) for each day in a month (or could set parameters for beginning of period and end of period):
* Child details (Service name, NSN, Child name, Home_name, DoB, Start date, leaving_date)
* times booked
* attended time
* funding details (mins funded at 20 hrs free rate, mins funded at +10 rate, status of attendance, funding-type, rule invoked(T/F))
Outputs:  datasets for Feb, Mar, Apr 2017 (see sample);  code
Freelancers have to use the modes in the attached Ruby JSON API. Sample output is also attached.
The successful freelancer will be asked to sign a commitment to maintain privacy of information.