Solution: Engineering Cost Planning

Client: Oil & Gas

We were engaged to develop a cost and schedule database for an engineering department responsible for planning and managing oil & gas platforms.

We developed the solution on the IBM Cognos TM1 software platform. The solution enables users to add or update oil & gas project information and cost. The solution also allows users to perform benchmarking across projects and perform scenario planning.

Solution: Investment risk analytics

Client: Retirement fund management organisation

We collaborated with Riskmetrics Inc and Wilshire Associates in completing the engagement, IBM Cognos TM1 ("TM1") was positioned as the investment risk data mart, as well as the reporting engine to the risk and performance attribution results computed by the Riskmetrics and Wilshire engines.

The solution entailed extracting data from multiple investment systems and market data providers into TM1. TM1 provided the repository of investment data and position information on its investment portfolio. Thereafter, these data were transformed to be fed into the risk and performance attribution engines.

This enabled users to prepare analytical reports required for investment risk reporting and monitoring. The solution also allows the organisation to analyse the risk adjusted profitability of the respective asset classes, securities and traders.

We also built a solution to track the fund's exposure limit on stocks, as well as its total investment exposure on group of investee companies and individuals.

Solution: Budgeting and planning

Client: Document management

We were tasked to build and deploy a financial planning solution for the company using IBM Cognos TM1 software.

The solution enabled users to perform in-depth analysis of their periodic financial reporting results and develop financial budget numbers for the company. Furthermore, those results are shared to their Asia Pacific headquarters for consolidation.

Solution: Production and planning

Client: Flour mill

We were engaged to develop a planning solution for one of the largest integrated wheat buying, flour milling and marketing organisation in South East Asia. The client possessed mill operations across the South-East Asia region.

Previously, the financial planning for the mills and stock levels were preformed using Microsoft Excel spreadsheets. However, there were limitations to the spread sheets to cater for product costing due to variability of exchange rates, changing wheat prices and moving stock levels.

The planning solution was developed using IBM Cognos TM1 software platform. The solution entailed the production costing and planning of raw materials for input and blending them at the mills. The solution also included a pricing model for each product produced by the mills.

We also developed a reporting module, which includes standard reports and dashboards as well as remote and offline key-in templates for the organisation's distant offices.

Solution: Financial reporting

Client: Bank

We were tasked to develop a financial reporting solution for a bank, in view of their intention to automate the financial reporting process.

The project entailed the extraction of the General Ledger (GL) accounting information, whixh contains the aggregated accounts balances, as well as data from 5 other banking systems.

The solution enabled the reconcilation of balances between the banking systems and the GL accounting system to determine whether the extraction was correctly performed. The solution also included a cost allocation feature. Finally we developed a segmented financial profit and loss statement by business units. We also built a financial reporting dashboard as part of the solution.

The Bank managed to automate a significant portion of the process and reduce the financial reporting cycle to 5 days after period end, with the use of our solution. Prior to the our engagement, the Finance Department was having difficulties in producing a segmented financial report by business unis, as it took them close to 3 weeks and with less accuracy in order to do so.

Solution: Financial reporting

Client: Logistics

The customer is a well renowned global logistics company. We were engaged by one of its global technology centres in Malaysia which serves users across Asia Pacific, Eastern Europe, Middle East and African countries.

The project involved the delivery of the IBM Cognos TM1 software platform for the company's financial reporting solution. The solution was deployed to users across the region, as well as countries in Eastern Europe, Middle East and Africa, through its office in Cyberjaya.

Solution: Economics data management

Client: A central bank

We developed a solution to facilitate the management of its economic data sets as well as enable users to perform reporting and various analytics based on its economics analytics framework.

We used the IBM Cognos TM1 software platform for the development of an economic data management solution. In developing the solution, we were required to extract data from more than 17 different data sources, ranging from various relational databases, OLAP cubes of differing software platforms, text files, flat files, and Microsoft Excel worksheets. The solution also required for the inclusion of data input mechanisms to be built for data gathered by the Bank's economist, which were not contained in any electronic format.

The project involved the migration of their existing economics data warehouse into the TM1 software platform.

We also developed an economics dashboard comprising of more than 60 indicators for the senior management and the automation of the periodic reports which are available on the Bank's website.

Solution: Engineering Cost Planning

Client: Oil & Gas

We were engaged to develop a cost and schedule database for an engineering department responsible for planning and managing oil & gas platforms.

We developed the solution on the IBM Cognos TM1 software platform. The solution enables users to add or update oil & gas project information and cost. The solution also allows users to perform benchmarking across projects and perform scenario planning.

Solution: Budgeting and planning

Client: Document management

We were tasked to build and deploy a financial planning solution for the company using IBM Cognos TM1 software.

The solution enabled users to perform in-depth analysis of their periodic financial reporting results and develop financial budget numbers for the company. Furthermore, those results are shared to their Asia Pacific headquarters for consolidation.