We help organisations to derive valuable information from their enterprise databases through Business Intelligence solutions using current generation of analytical applications and query tools. We specialise in Data warehousing, e-Business Intelligence and Knowledge Management solutions, which are based on our Data warehouse Methodology

Our solutions have helped our clients in several ways:

• Gain substantial market share through better market insight
• Retain existing customers
• Make more effective policy decisions

HCl's range of services cover the complete solution cycle in Data Warehousing, e-Business Intelligence and Knowledge Management Solutions

• Data warehouse strategy planning
• Application development
• Implementation of third party tools
• Scope Definition & Requirement Analysis
• Architecture Definition
• Dimensional/Star schema/Data Modelling
• Data Mapping and Metadata Definition
• ETL (Extraction-Transformation-Loading) programs design, specification and Implementation
• Application development using Front end tools
• Database sizing/Performance fine-tuning/Optimisation
• Quality Assurance
• Enterprise Knowledge management Portal Development
• Development/ Implementation using variety of DWH tools provided by Microsoft, Oracle

Showcase

PROVIDENT FUND AGENCY, SINGAPORE
The Singapore based leading provident fund agency taking care of retirement, home ownership, healthcare needs, and financial protection of its members and their families through its insurance scheme. Our solution enabled the customer to perform multidimensional analysis of the data with time, age group, wage group, gender etc as some of the dimensions. This assisted them in making better policy decisions.

CREDIT CARD COMPANY, USA
We developed a solution for a Credit card Industry in the areas of Marketing, Risk, and Finance using a leading ROLAP tool and REDBRICK as the backend database.

LIFE ASSURANCE COMPANY, MALAYSIA
Our Oracle-based solution enabled an analysis of Business Development and Finance Applications. Business analysis covered the full life cycle - prospecting, policy issuance, premium payments, claims, surrenders, maturity. An enterprise wide common customer database coupled with detailed capture of information enabled customer profiling, cross selling and drill down to minute business dimensions. Detailed expenses/ income heads analysis, Variance Analysis, Ageing analysis of loans / deposits helped to cut costs and improve profitability.

TRANSPORTATION COMPANY, MALAYSIA
We developed a Data Warehouse strategy for a leading Malaysia based client who is the operator of world's longest driver-less automated Train System.

::          ::          ::