RECENT PROJECTS
RECENT
PROJECTS
METAL FABRICATION
COMPANY
A customised system for a manufacturing enterprise, specialising in laser cutting, engaged in fabrication of metal components.
The system manages the entire workflow for the large number of work orders, incorporating job tracking and status monitoring, materials requirements and purchasing, outsourcing of secondary operations, invoicing, deliveries, and tracking of goods movements.
The system integrates with barcode scanning as well as an external CAD system.
LARGE FACILITIES MANAGEMENT COMPANY
Quoting and Procurement Support Database. The job was to amend, refine and complete an Access application that tracks quotes for the technical procurement team. Quotes are obtained from suppliers, then combined to a single quote for the sole customer, a major supermarket chain. The application manages the entire process and is used extensively by the technical procurement team for preparation of documents and communication with both suppliers and the customer.
The application was developed using extensive VBA programming to create the user interface, and to create functionality that interfaces with other enterprise systems to automate procedures. It uses an Access front-end over SQL Server.
VARIOUS GOVERNMENT DEPARTMENTS and NGOs
Project Tracking Systems
Many government departments and NGOs run programs in which there are sources of funding being distributed in the form of grants towards projects. A typical project tracking system records a great deal of information about each project, including briefing and background; team and responsibilities; budget and forecast; outcomes and deliverables; milestones and variations; associated contacts and stakeholders; action log; and linked documents. There are usually also a variety of reports.
We have developed such systems for many government departments and NGOs, the most recent being VicHealth, WaterAid, and DELWP. Each one is unique – some using Access alone, while others use an Access front-end over SQL Server, all requiring extensive VBA programming.
Such projects have often included training delivery and development of documentation.
CLOTHING IMPORT
COMPANY
A database application to track sales and purchase orders, as well as recording inventory levels of all stock.
Despatch and invoicing are also taken care of, and a wide variety of reports is available. A barcode scanner may be used for entering orders and producing pick-slips.
A second application, for use on reps’ portable computers, enables reps to enter sales and have access to the latest customer, sales and inventory data.
Information collected while with a client is submitted to head office via email and recorded in the main system.
Mortgage
Broking
Company
A database application which records details of clients and their loans, and keeps track of lender commission payments and how those payments are split between the various interested parties, eg. brokers, managers, agents, franchisees.
A great variety of reports have been developed and the system includes many functions to streamline staff work-flow processes.
A second application, for use on brokers’ portable computers, enables brokers to assess client loan applications and provide loan quotations. Information collected while with a client is submitted to head office via email and recorded in the main system.
Mortgage
Broking
Company
A database application which records details of clients and their loans, and keeps track of lender commission payments and how those payments are split between the various interested parties, eg. brokers, managers, agents, franchisees.
A great variety of reports have been developed and the system includes many functions to streamline staff work-flow processes.
A second application, for use on brokers’ portable computers, enables brokers to assess client loan applications and provide loan quotations. Information collected while with a client is submitted to head office via email and recorded in the main system.
Personnel Supply
COMPANY
A database application to manage the placement of casual and emergency staff servicing the medical sector and catering industry.
The application matches client placement requirements to the availability and suitability of the listed personnel.
A great variety of reports have been developed and the system includes many functions to streamline staff work-flow processes.
Network of Marketing
CompanieS
An extensive database application to manage the entire company operations for each company within the network.
It includes a vast range of functions and reports that effectively and efficiently fulfil the week to week operational requirements.
Network of Marketing
CompanieS
An extensive database application to manage the entire company operations for each company within the network.
It includes a vast range of functions and reports that effectively and efficiently fulfil the week to week operational requirements.
Educational
Institution
A database application to record details of students, courses, classes, enrolments and results.
It produces class lists, timetables, invoices, results statements, and many other reports.
Industrial
Laundry
A database application to manage all the administrative processes of the laundry.
It records customer information including scheduled delivery and stock requirements, it generates orders and invoices, records receipts, and tracks all inventory movement, as well as producing a great variety of reports.
Large National Union
Development and extension of an existing database application consisting of an Access front-end over a SQL Server database.
The database records all membership details including employment, membership terms, membership history, accounts and statistics.
A great variety of reports have been developed and the system includes many functions to streamline the work-flow processes of union staff.
Large National Retail COMPANY
A database application to receive data from the company’s main enterprise system (SAP) and provide a variety of useful and essential reports not otherwise available.
Roof Truss COMPANY
A database application to assist sales personnel in preparing detailed quotations, including costing and scheduling of a job.
HOTEL Chain
A database application which enables effective record-keeping of all necessary components of the customer loyalty program – members, point balances, hotel stays, room values, points earned, redemptions, rewards, suppliers, etc – and the presentation of this information in a user-friendly format which simplifies administrative processes and allows member queries to be answered easily.
Daily or weekly data files of hotel stay information are received from the hotels and uploaded into the database.
A great variety of reports have been developed for analysis of the data, including quarterly statements for members.