Success Stories
Design an Executive Information System for a Governing Body of the Singapore Government
The customer is a governing body of the Singapore Government that plans and manages the public transport infrastructure of Singapore and controls the functioning of bus and rail operators.
Customer Need
The customer needed an Executive Information System that would help in addressing the following:
- Help the users in decision-making on new services; change of routes, and in general improvement in services
- Provide formatted data as inputs to the network analysis tools
- Process Control to manage data loading and maintain the multi terabyte warehouse with minimal or no manual intervention
- Propose and provide data mining and other advanced analysis
- To provide high security of data as the people accessing are often from competing corporates and operators.
- Design a scalable and high performance system that provides response in seconds to the end-user
Solution Highlights
HCL offered the following as a part of its solution:
- State-of-the-art analytical solution designed to analyze information from their Enhanced Integrated Fare System (EIFS)
- High performance decision support system designed to enhance the decision-making ability of middle and operational level members of the organization
- Designed the solution to reinforce focus on critical operational areas such as ticketing, revenue, and public affairs
- 2.4 TB DW, 7 hours daily data processing, 12 User Groups, 70 OLAP Analysis, 22 Fact Tables
- Daily processing of 5 million Source Records, 10 million detail records
- Key coding to avoid unnecessary table joins and minimal use of indices (low size, high performance)
- Completely automated solution with process and job control
- Oracle 8i, Oracle Discoverer, Oracle Express, Oracle Warehouse Builder, Oracle Reports, Oracle Portal, SAS Enterprise Miner
- Increased operational efficiency and better decision making
- Provides ridership details, travel expense pattern of the commuters at a click of the mouse
- Provides information on unused and dormant cards
- Provides revenue and rebate analysis for comparing the revenue figures against the transfer rebates offered by different service provider
- Provides origin and destination analysis and detailed analyses on the various payment/refund methods
- Provides decision support that helps to respond to ad-hoc customer (commuter) complaints
- Provides information on capacity utilization of buses and clustering of buses
- Provides revenue compensation patterns for concession tickets and transfer rebates
