home page
about us
services
solutions
contact us
  S.M.A.R.T.
Global Materials Shipment Management system
read more
  Equipment Costing Database (ECD)
Cost estimating system for plant and materials for power plants.
read more
  Traffic Management Database
Highway signage control integrated with safety cameras.
read more
  Financial Benchmarking
Fund and portfolio analysis to support investment.
read more
  Insurance Claims System
monitor all the insurance policies and claims.
read more
  Maintenance Schedule Database
A maintenance schedule system covering all operating plant on site.
read more
S.M.A.R.T. (Materials Shipment Management System) (1998)

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.

Equipment Costing Database (ECD) (2000)

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

Business Challenge
To produce an estimate very quickly to cover cost of plant and materials for a given power station project and be able to do scalable “whatif” scenarios.

Solution
A system was developed which rapidly produced cost estimates for complex manufactured plant and materials. It used previous documented estimates (building up a history of previous projects) and used multiple factors for various facets of each area of the plant. It then produced breakdown of the costs for the new design and provided various levers to perform whatif scenarios. This information proved invaluable when compiling bids for projects where accurate cost breakdowns were essential to the confidence in the bid.

Traffic Management Database (1997)

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.

Financial Benchmarking (2006)

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.

Insurance Claims System (ICS) (2002)

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.

Maintenance Schedule Database (MSD) (2004)

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.


Copyright © HALO 2010 Home | About Us | Services | Support | News | Contact Us