Skip to main content Skip to main navigation Skip to search Skip to footer

DW Appliance implementation leveraging HCL's Global Reporting & Analytical Framework (GRAF)

DW Appliance implementation leveraging HCL's Global Reporting & Analytical Framework (GRAF)

Client

One of the leading telecom providers in APAC.

Services offered

DW Appliance implementation

Domain

Telecom

Application environment

Oracle Exadata, SAS EBI, Informatica Power Centre Advanced Edition and Informatica Metadata Manager.

Location

APAC

Client background

The client is a one of the leading telecom providers in APAC, with a combined mobile subscriber base of 368 million customers. It is also the largest company by market capitalization on the Singapore exchange.

Business challenges

  • Non-existence of a centralized data warehouse catering to various reporting needs
  • No single version of information
  • Manual process used to generate reports
  • Stove-Pipe Architecture leading to duplication in terms of data extraction, consolidation and reporting
  • No support for unstructured data coupled with frequently changing business rules
  • Repetitive data being used in multiple reports across various groups
  • Non-supported technology Stack
  • The database is Oracle 8i which is no longer supported by Oracle
  • IBM recommends all its customers to migrate to latest version of Cognos Enterprise

HCLT solution

  • HCL’s proposed solution to the client is highly scalable and a completely performance-driven best-of-breed solution.
  • This offers best-in-class components in the industry and offers the highest ROI and reduces the TCO. The following are the solution highlights:
    • DWH Appliance Solution -- Massively Parallel Processing (MPP) platform to handle large data volumes with best possible parallel processing capability for crunching ever increasing volume of the client’s data. HCL is involved in the data warehouse migration from Oracle 8i to Oracle Exadata.
    • Efficient Data Integration solution using Informatica – The solution is completely metadata driven and GUI based, adheres to key principles of SOA and is capable of utilizing the parallel processing power of the DWH server using “Push-down optimizer” technology
    • High performance BI solution using business objects and SAS BI
    • SAS Advanced Analytics solution to promote easy and sure adoption of advanced analytics for the client with all the necessary foundation analytics capabilities such as statistical analytics, data modeling, data scoring, forecasting and optimization in place to bring the analytics within client to the next level.
    • HCL’s Global Reporting & Analytical Framework (GRAF) framework to provide technology independent and functionally scalable packaged solution and enabling faster time-to-market.
    • HCL’s proposed solution delivers powerful data cleansing, data profiling and reporting capabilities in a single solution.

Benefits in business operations

  • Single Version of Information - Centralized data warehouse catering for various reporting needs
  • Framework-based implementation – HCL’s GRAF ensures success of the implementation and faster time-to-market
  • Real-time Data Warehousing – Helps leverage mission-critical operational data by making it available to people and processes without requiring manual coding of data extraction programs
  • Ease-of-use: All the development and user-based tools are GUI-based with point and click functionality. This reduces the high learning curve that users have to overcome.
  • Reduced churn and increased customer satisfaction
  • Effective campaign management
  • Service-based product basket analysis
  • Reports rationalization and Adhoc capabilities for self service

DOWNLOAD THE SUCCESS STORY

Contact Us
MAX CHARACTERS: 10,000

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.