Client and staff booking system – Fluent English is highly desirable

Closed - This job posting has been filled and work has been completed.
IT & Networking Database Administration Posted 2 years ago

Fixed Price

Delivery by June 23, 2014




We are looking for a database designed from the ground up and are seeking the skills of a talented developer.  This developer or team leader needs to have fluent English.

Call on Clare is a unique specialist mobile services which provide tailored nursing service to people who are in various special health situations such as post-surgery, fractures, joint replacement, terminally ill, have a chronic illness as well as the aged and the frail.  The services are provided by qualified or retired Div.1 nurses, who have the expertise to understand physical needs, communicate/ effectively with medical personnel and provide accurate and comprehensive follow-up information.

The business has been running for around 5 years and it has developed very well since its start in 2009. The business currently has approximately 300 clients and 30 staff. It is forecast to grow to around 100 staff and take on many more clients by the end of 2013. In order to manage the increasing client and staff information and to create effective scheduling, our organization is interested in creating a database to assist in business operations.

So that I know you have read at least down to here make you greeting “Hey Clint” and not “Dear Sir/Madam”

What’s required is a business management application, which includes a database that can accurately record the detailed information of the clients and staff, and based on the database, the staff roster can be automatically generated. Other functionality, such as sending the booking service information, along with a map for the nurse(s) needs to be integrated into the system.

• Database
The database will includes detailed client information (place or residence and/or facilities, doctors, ect) Staff details and booking information etc.

• Calendar/Roster Functionality
A calendar/roster function will be used to make bookings through the office and allow staff to see their upcoming appointments. It will also allow office staff to see availabilities and schedule bookings accordingly. It will need to integrate with the database to read and write data.

• Staff Working Area
A Late change request for the ability to map staff addresses on a Google map to use as a reference when making bookings.

• Database information
o Clients
o Staff
o Bookings

• Database functionality
o recurring bookings
o Calendar
o Staff preferred work area
o Map of local staff (in relation to a client’s location)
o Exporting booking information into accounting software
o Email and SMS notification to staff of current days booking

• Clients are ether billed weekly or monthly (week is saturday to friday)
• Our weeks start Saturday and finish Friday.
• Clients are Billed each booking – time, expenses (what staff pay on behalf of clients) and travel (travel is billed at 0.75 per Km (Kilometre) )
• There are 3 different time rates for bookings
• Staff are paid fortnightly – booking time, expenses and kilometres

We would like if the database could produce a report once a week what to invoice clients and also if possible to export a csv file that we can import to Xero ( to produce the invoices.

And we would like a report what to pay the staff at the end of a fortnight
I have described before how our bookings are priced but a will just put them down again

o 3 booking types, each type has a different rate of pay (social, medical     and surgical)

o Each booking type has 3 scales (Monday to Friday 100%, Saturday 150% and Sundays and Public Holidays 200%)

Can we have an input screen for the previous week to update staff bookings (Start and Finish time, expenses and Km’s travelled)
When we make a booking we only estimate the finish time, we don’t know the actual finish time until the staff member summits there time sheet at the end of the week.

We would prefer this to be done in open source languages such as php, mysql, ajax ect

Once the project is over we would like someone available for alterations as we come across thing we may find useful as the business grows.  For example at a later date have the possibility of having mobile phone app for staff.

About the Client

(4.98) 10 reviews

Hawthorn East 08:29 AM

26 Jobs Posted
54% Hire Rate, 1 Open Job

$375 Total Spent
16 Hires, 2 Active

$6.75/hr Avg Hourly Rate Paid
24 Hours

Member Since Aug 20, 2013