Online Job Cards

Posted in Slider Item, Solutions on Jul 30. Tags: automation, integration, internet, mobile devices, NextG, Ruby on Rails, SQL Server

The system is designed to improve response times when operations are flowing smoothly so that issues can be resolved faster when they occur. Drivers are able to view and update their run sheet as soon as the job is done using their data enabled mobile devices. Jobs are displayed in the order of importance and can be marked as having been done or having issues that need to be resolved.

The Online Job Cards system is integrated directly into the existing legacy booking system, providing a fast reliable link between the drivers performing the services and the operations staff overseeing each division. General job status is provided visually using colour coding on the operations mangement screens in real time. When a new job is allocated to a driver, it will appear on their mobile device as soon as they refresh their Online Job Card.

Another excellent situation for data enabled mobile devices. Further updates are planned, including obtaining customer proof-of-completion signatures for invoicing purposes and using Location Services to pinpoint where the jobs are being performed.

This solution uses:

Microsoft SQL Server
Ruby on Rails
Telstra NextG
HTML4+ enabled web browser (iPhone/Android/iPad)

Membership System

Posted in Slider Item, Solutions on Apr 09. Tags: Access 2007, solution

The association needed to replace it’s outgrown membership database without losing any data or functionality. Weekly member lists are generated to provide simple forms for treasurers to record payments as they are received. Member statements, which include tax exempt notifications and customisable reminders, can be generated as required. Summary reports enable the executive to monitor the status of their constituency without getting bogged down in details.

The solution needed to replace and expand upon the existing system that had reached it’s user limit. All the existing functions were replaced/recreated before creating additional functionality. A new series of detailed financial reports allow for reconciliation and fast data entry into the accounting package; instead of entering individual transactions for each member the client is now able to make summary transactions for the total amounts to be allocated to their different destination accounts. A date driven approach has allowed for continued expansion of payment methods, specifically direct payment via internet banking, without compromising the traditional collection process.

The solution is complete, occasional development of new functions is undertaken when the clients business model changes. In fact, the system has been so popular it’s now being used by quite a few affiliated associations in the south west of Western Australia and Tasmania.

This solution uses:

Microsoft Access 2007

Recruitment Database

Posted in Slider Item, Solutions on Apr 09. Tags: Access 2007, SQL Server

Global Health Source aims to provide their clients with a short list of high quality candidates for review, ideally within a few days. Candidate details, such as primary professions, skills and their proficiencies, accreditations, and visa history are all recorded and instantly searchable. Client details, including candidates presented for interview and their outcomes are also recorded to get a complete picture of their success rates over time.

Supplying allied health professionals to locations in Australia and New Zealand. The database tracks members from all over the world (Australia, Ireland, New Zealand, South Africa and the United Kingdom to begin with); their current qualifications; future plans; visa arrangements; and local accreditation progress. Placement officers are constantly in contact with candidates and clients throughout the day so data entry must remain a simple process. The search form allows for very detailed criteria so that the least number of enquiries can be made while finding candidates who are available, and interested, in the position.

This system has recently been migrated from an Access 2007 back end over to SQL Server 2008, the process was done in-situ over a period of weeks (and while it was being used in a live environment!). A more detailed search function is being investigated, along with increasing the list of details being stored for clients and candidates.

Technology used

Microsoft SQL Server
Microsoft Access 2007