The Client
Global Power Company building and manufacturing power stations in all parts of the world.

Business Challenge
The client needed to collect data relating to shipment of materials from remote parts of the world unable to get network access or from small specialist suppliers who did not have sophisticated systems of their own.

Solution
A small-footprint system was designed for use on construction sites in remote parts of the world where network links may not easily be accessible. It used an Oracle POLITE (Power Objects Lite) database to collect the information via an integrated input screen and/or spreadsheet loader. Once the data was complete the system compressed the database so it could be sent back to the Head Office where it was replicated with the main database. The revised database was then re-extracted for the particular supplier or site and returned to them should further input be required.

The Client
A well known company who produces and operates traffic-management equipment.

Business Challenge
The client needed a database capable of storing vast amounts of data collected from numerous cameras situated along major highways and the capability to control the warning signs attached to the gantries above the road.

Solution
HALO designed and built an Oracle database to record real-time traffic flow statistics, used to control traffic signals on a new highway project in the far-east. The database processed up to 7000 records per second and summarised this data into 1, 5, 10, 15 , 30 minute, 1 hour and 1 day snapshot statistics which were used for trend analysis and predicting peak flows of traffic.

The Client
A fund and portfolio information management company

Business Challenge
To be able to group Funds and Portfolios from various providers into Sectors and then compare and rank them based on common attributes to better inform investors.

Solution
A database and reporting tool was developed using Oracle and Crystal Reports which analysed a number of different Portfolios and Funds and grouped them into appropriate Sectors. The Portfolios/Funds were then compared (using defined sector attributes) with each other and in reference to Sector Averages, top 10, bottom 10 etc. as desired.

The Client
Global Power Company building and manufacturing power stations in all parts of the world.

Business Challenge
To monitor all the insurance policies and claims across hundreds of projects and ensure that the company was getting the claims they had submitted processed in a reasonable time. Typically insurance companies will delay claims by requests for information and documentary evidence so a solution was needed.

Solution
An Oracle database and Oracle Forms application was developed to record details of all Insurance Policies, Claims and Payment Receipts (relating to insurance claims) broken down by Business Unit/Department and/or individual projects. A secure vault was incorporated allowing storage of associated documentation and sophisticated account security implemented to allow individual users to only have visibility on the correct data. The system was rolled out worldwide and identified the added benefit of collective negotiation covering a number of projects and claims with individual insurers saving time and effort.

The Client
Chemical Company operating plant in the UK.

Business Challenge
To create a maintenance schedule covering all the operating plant on site identifying the type of maintenance required, the frequency, the appropriate personnel who can perform the maintenance and identify missed maintenance and reschedule.

Solution
Microsoft Access system developed to take information from spreadsheets or other database systems and create an automated list of maintenance tasks used to service plant and machinery. Lists could be allocated to Groups or Individuals and can be updated to record any additional feedback from the maintenance performed and allow re-scheduling of missed tasks if required.