Specialised Databases.

Reporting to foreign parent companies

An Australian subsidiary of a foreign manufacturer is required to massage operating reports to formats required by the parent companies. The resulting database saved the company several staff days each month and produced reliable results.

 

Legal and statutory documentation

Essential service providers must ensure that deadlines are met and certificates are produced when required. We have implemented automated document retrieval systems ensure that nothing is overlooked and regulatory requirements are met.

back to the top back to the top

 

Recording fraud and pilfering

A well established family run business discovered that a trusted employee had been engaged in pilfering and embezzling for several years. They needed to prepare a complex claim for legal purposes. They saved a substantial amount of legal expenses and were able to successfully prosecute for recovery.

back to the top back to the top

 

Tracking and reporting on shared plant

A plant hire company hires its own plant and plant owned by third parties. Contra hires to and from the third parties can occur. Plant was difficult to track and costs were not always apportioned. This lead to tensions and misunderstandings. The result of the database implementation was that all plant is now easily tracked and costs are apportioned to the satisfaction of all parties.

back to the top back to the top

 

Shared diary, message and note system

An importer and wholesaler had a problem with internal communication. Staff could be absent for irregular periods. There was also a need to filter information by department and product group. An internal message system was developed to achieve this interface to jobs and customers. The resulting message log allows review of staff activities.

back to the top back to the top

 

Employee benefit schemes

Several applications have been developed to track monetary and non-monetary staff benefits. Generally the databases incorporate details of extra effort and inputs by staff as well as benefits provided to staff.

back to the top back to the top

 

Sales and stock usage statistics drawn from several data sources

A national marketing group have the need to maintain multiple sales teams. These developed as result of loose partnerships, joint ventures and other cooperative activity. The resulting databases saved hours upon hours of effort and allowed meaningful statistical analysis.

back to the top back to the top

 

Replacement of multiple word documents

A trades and service company was undertaking repetitive jobs for a number of clients. They were storing copies of the client work orders in a complex system of folders and sub folders. The work was time consuming, recall of information was slow. A database was implemented to store and retrieve the information more efficiently. The result was a reduction of 75% of the staff processing the work orders.

back to the top back to the top

 

Simple cost controls for branch and site staff

An engineering contractor with a number of remote construction sites required the site staff to monitor certain costs. The resulting database allowed site staff to react very quickly to cost overruns. The estimated payback period was less than 3 months.

back to the top back to the top

 

Run scheduling for delivery and sales activities

A provider of household services had been using a manual job run schedule system for several years. An application was developed keep the run details electronically. This allowed more efficient scheduling and allowed more management time. As a result of this and other innovations, the business has grown by 300% in 12 months while administration costs have been contained.

back to the top back to the top

 

Truck scheduling

A national freight operator was using up to three staff to manually track their fleet of trucks, trailers and drivers. At peak times, the workload became unmanageable and runs were overlooked. These had to be serviced with premium cost. The resulting database allowed staff time to be reduced by 50%; the information was more reliable and timely. Management was able to reduce costs substantially by early intervention. A by-product was a log of truck and driver movements, which satisfied industrial and OH and S requirements.

back to the top back to the top