Project Examples

MAT Systems designed and built a bespoke application to enable the Department of Management at King’s College to track and monitor student attendance and participation at tutorials.

The application was designed to import data from the existing student database, to remove the necessity for double-entering student data.

The application produces reports to show the attendance/absence and participation of all students across all modules over the duration of the course.

HWB International consults and researches in marketing aspects of the car industry. Amongst other things, every year they publish a report on car dealer networks across greater Europe which involves the manipulation of 140,000 data points which has, in the past, proven a considerable burden.

MAT Systems designed an application that enables HWB to quickly and easily import all of the source data from the various car manufacturers, which is provided in electronic form via Excel spreadsheets, into a central database.

The application then enables HWB to automatically generate the required analysis reports ready to be included in the final report.

Red Kite Vehicle Consultants Ltd are the Uk’s leading School Minibus suppliers.

MAT Systems designed an application that enables Red Kite to track each order from initial enquiry to delivery and then to support the post sales support activities.

The application enables the sales staff to quickly and eaily capture a customers requirements, including type of vehicle, seating and options and to then quickly and easily match the requirements to vehicles in stock. The application also enables Red Kite to manage the build process for each minibus by generating parts lists, seating plans and job cards at the click of a button.

Ericsson Television manufacture equipment for the transmission of digital television. They have a number of manufacturing sites around the world, each site has test equipment to test the products manufactured. Ericsson wanted to set up a centralised database to hold all of the test result data from all manufacturing sites.

MAT Systems designed an application that enables each manufacturing location to upload their test results data to a central FTP server from where they are automatically loaded into a central database.

The application enables Ericsson to enquire and report on the test results of any range or piece of equipment.

Planned 2 Perfection organise and manage private and corporate events. They have a number of venues that they regularly use and who use them as preferred suppliers, they also have a huge number of suppliers and acts on their books that they use for the events that they organise.

MAT Systems designed an application that enables Planned 2 Perfection to manage all of their venues, contacts and suppliers including CRM facilities and the ability to send targeted marketing mailshots, letters and emails.

The application enables Planned 2 Perfection to record all of the details of each event and to track the progress of the events including the management of supplier quotes and the raising of purchase orders, invoices and contracts.

Rascals Casting are an agency for film and TV extras. Their requirement was for a database to hold all of the details of the artistes on their books, with comprehensive search facilities to enable them to match suitable artistes to the requirements of a film/tv part.

MAT Systems designed an application that enables Rascals to manage all of their artistes and to search on a wide variety of crieria pulling the matching artistes into reports, which include a number of photographs, to be sent to the film/tv companies.

The application also enables Rascals to manage the bookings of artistes for productions including the ability to send the required details to each artiste as and when required.

Tensai are Alan and Caroline Vandome, between them they have 4 magic shows including childrens entertainment, close-up magic for corporate events and a stage magic show. The Vandome’s approached MAT Systems to design and build an application to manage all of their varied enquiries, bookings and contacts.

MAT Systems designed an application that enables all booking enquiries and confirmed bookings to be logged and managed. The application includes CRM facilities to enable emails and letters to be sent to the clients, these emails and letters can be ad hoc or can be easily generated from templates to provide professional looking personalised corespondence.

The application also includes facilities to manage all of the Vandome’s contacts including CRM facilities and the ability to send targeted marketing mailshots to contacts and existing clients.

Rowney Sharman are a company that provide project management services for building and development projects. They have offices in Ascot, Jersey and London. MAT Systems designed and built a bespoke application to enable Rowney Sharman to record the details of their project managers, clients and projects. The application also enables them to record details of all sales invoices raised against each project and to record all project manager timesheets and expenses.

A number of management reports can easily be generated showing, amongst other things, the profit and loss for each project (derived from the sales invoices, timesheets and expenses entered).

The application also enables Rowney Sharman to enter projected fee schedules for each project and has facilities for each project manager to plan their time using a resource planning tool. A projected profit and loss report can be run for each project using the fee schedule and associated resource plans.

Oxford Indices is a data strategy firm, specialising in quantitative analysis systems for media companies.

They had a requirement to analyse the sales data from John Menzies, one of the UK’s largest magazine distributors, in order to determine the optimum distribution of all magazines across all outlets in the UK. The volume of data involved was huge and the complexity of the analysis algorithms was significant.

MAT Systems designed and built a bespoke application to enable the sales data to be loaded into a database, analysed and the results output to a number of Excel spreadsheets in a form suitable for inclusion in reports to be presented to John Menzies.

Hi Spirits are a company that import spirits from various suppliers within Europe into several bonded warehouses throughout the UK. They then sell them onto a number of UK based customers.

MAT Systems designed and built a bespoke application to enable Hi Spirits to set up and maintain all of the details of their various suppliers, warehouses, shipping companies and customers.

The application enables Hi Spirits to raise and manage purchase orders, shipping orders, goods in advices and sales orders, and to track and manage their stock held at each warehouse. The application also enables Hi Spirits to produce reports such as profit and loss and volumes of sales by customer.

Trusol Services are a company that offer ICT support for schools and small businesses. They offer a range of support service level agreements (SLAs). Each SLA has a different pricing structure and entitles the customer to different amounts of on-site support, provided in fixed support periods.

MAT Systems designed and built a bespoke application to enable Trusol to set up and maintain their various SLAs, to manage their customers (name, address, contact details and relevant SLA) and to record the support purchased by each customer, alongside that provided to each customer. Detailed reports can easily be generated for each customer, showing the support purchased, provided (including a detailed breakdown of each support visit) and available. 

Leading Edge organise and manage events and trade shows. As a business they have thousands of contacts that they need to make regular contact with. They needed a CRM based application to enable their staff to maintain details of every contact, to be able to categorise them by a number of criteria and to record details of the events attended by the contacts and in what capacity, e.g. Vistor, Exhibitor, Speaker.

MAT Systems designed an application that enables Leading Edge to manage all of their contacts including CRM facilities and the ability to send targeted marketing mailshots, letters and emails to contacts. It also includes the ability to record other contact’s such as telephone conversations, faxes sent/received and meetings attended.

The application also contains a task management tool, similar to Outlook Calendar, which enables the users to quickly and easily set up tasks related to contacts, such as sending an email, making a telephone call or attending a meeting. Each task is given a date and time and can have a reminder set to prompt the user when the task is due (or at a specified time before the task is due), at which point the full details of the task and contact are available to the user.

Due to the large number of existing contacts and associated information, the application also contains facilities to import contact details from Outlook and Excel and also to import existing contact email correspondence from Outlook into the application. 

The National Centre for Eating Disorders are a company that offer training to eating disorder councillors. In addition to this they organise workshops and seminars and provide a councillor referal service to anyone looking for an eating disorder councillor in their local area.

MAT Systems designed an application that enables the National Centre to manage all of their courses/workshops, bookings (including payments), course attendees and councillor network.

London Village Estates are an estate agent based in London that deal in both sales and lettings.

MAT Systems designed and built a bespoke application to enable London Village Estates to set up and maintain all of the details of their various sales and lettings properties as well as all of their applicants, vendors and landlords.

The application enables London Village Estates to accurately record the requirements of each of their applicants and to then automatically match them to any suitable properties on their books. The applicants can be automatically notified of any matches by Email, SMS (text message) or Letter.

The application also contains a full contact management suite that enables London Village to record details of all correspondence to and from their applicants, landlords and vendors, whether by Email, Letter, Fax or Telephone.

The marketing details for each property can also be managed from within the application, including links to various property portal web-sites such as Prime Location and Right Move.

The application also contains a viewings diary to enable viewing appointments to be made and maintained, this includes automated links to populate an Outlook calendar with the viewings.