RECENT PROJECTS
RECENT
PROJECTS
HOSE MANUFACTURING COMPANY
This project started out with the aim of amending and enhancing an existing application. The purpose of the application was to track quotes and sales orders, and allow for allocation of stock to orders. Over time the project grew to completely replace the original database application with a new and better approach, together with functionality extended to include purchase orders, engineering orders, better stock and inventory control, and a host of reports. The system consists of an Access front-end over a SQL database.
NATIONAL TRANSPORT COMPANY
This company runs a metropolitan delivery, courier, and taxi truck service in several capital cities. They required a database application to manage the onboarding process of their drivers. Sounds simple right? No! Coping with the large turnover of drivers with such a company, and the extensive onboarding requirements for new drivers, is quite a challenge. The application we have developed for them is complex and rich in features and functions. It includes features such as: CRM functionality that automates the contacting of various parties throughout the process; import of facebook contact data as leads to be followed up; an advanced follow up diary system. The system consists of an Access front-end over a SQL database.
SHEEPSKIN PROCESSING PLANT
This company receives skins from various abattoirs. The skins are sorted and graded, and then sold mainly to overseas buyers. We developed an application in MS Access that replaced their old spreadsheets and automated much of the flow of information used to control and track the process. Functions include receipt of goods, classing, packing, shipping, invoicing, and a wide range of reports. Just as with the previous two examples, the application we have developed is completely indispensable to this company. They are extremely satisfied with it and could not operate without it.
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.