Telecommunication

Case Studies – Telecommunication Implementation

#

1

Customer

Groupo ICE, Costa Rica

Details of Customer

Grupo ICE is a Costa Rican state-owned holding company that controls assets in electric energy and telecommunications sector. In telecommunications, it has a telephony coverage of 95% of the population. It offers national telephony services through fixed and mobile lines, public pay phones, international telephony and internet connection through ICE Telecommunications. ICE modernized the telecommunications system, producing a comprehensive and affordable telephone network

Challenges

  • No real time decision making capabilities and customer segmentation.
  • No telecommunication Data ware house or reports present.
  • No Billing or Revenue Analytics
  • No Customer visibility and customer churn was very high after Govt opens the market.

Solutions

  • Integrated Amdocs Billing systems into the OCDM.
  • eBIW assisted ICE in developing analytics in the areas of customer acquisition, customer churn.
  • Analytics on acquisition forecasts and churn prediction provided by OCDM is helping the users to plan promotions and retentions programs.
  • Integrating OCDM with SIBEL CRM.

EBIW Offers

  • Industry: Telecommunication
  • Oracle Products & Solutions:
  • Oracle Communication Data Model
  • Oracle Data Integrator
  • Oracle Exadata solution
  • eBIW Solution:
  • Dimensional data model
  • Data mining solution with OCDM
  • KPI and Billing analytics
  • OCDM implementation

#

2

Customer

Claro, Ecuador

Details of Customer

Claro Telecommunications headquartered in Edificio Centrum; Guayaquil. Claro is a brand of mobile phones belonging to the Mexican company America Movil, and operates in several countries in Latin America. CLARO is the Ecuador’s leading telecom operator, with almost 12 million subscribers. Claro provides telecommunication services such as mobile, fixed, Internet and television.

Challenges

  • CLARO wanted to build and deliver reports for the Telecom Ecuadorian Regulatory Authority and needed an agile solution.
  • How to utilize the market leading telecom solution OCDM, used as target data warehouse, for the purpose of generating the Regulatory reports.
  • Enterprise-wide reporting infrastructure, using OBIEE, to support reporting and analytics required for the regulatory reports

Solutions

  • Integrate data sources BSCS, RTX, AXIS, Collector for Postpaid customer.
  • Integrate TecnoTree (Netezza) and other applications for Postpaid.
  • OCDM used as a Enterprise-wide data warehouse to support reporting and analytics needs of the business and functional users across Business Units, Global Sales, Corporate Finance and Executives
  • Provides a platform in which Finance and Business Units can combine data from other applications.

EBIW Offers

  • Industry: Telecommunication
  • Oracle Products & Solutions:
  • Oracle Communication Data Model
  • Oracle Data Integrator
  • Oracle Exadata solution
  • eBIW Solution:
  • Dimensional data model
  • Data mining solution with OCDM
  • KPI and Billing analytics
  • OCDM implementation

#

3

Customer

Cable & Wireless, Panama

Details of Customer

Cable & Wireless Panama is the largest communication service provider in Panama. Central data warehouse system was implemented using OCDM for the different lobs like fixed line, mobile ( both pre & post paid) , broadband and cable TV.  OCDM was implemented for Customer Management, Revenue Management and Billing. Data Mining, OLAP were also implemented.

Challenges

  • Complex Data Model not easy to manage
  • 5 OOTB data model for Data Mining
  • 13 OOTB for OLAP
  • 52 OOTB BI reports using OBIEE with the required customization
  • More than 100 KPIs
    • (OOTB : Out of the Box)

Solutions

  • Central BI reporting solution
  • Real-time data loading to OCDM Stage,
  • Advance BI Analytics Layer for adhoc Reporting in subscriber level
  • Improved end-users trust on data quality of BI report
  • Strong ETL architecture and management
  • Mining and OLAP solution

EBIW Offers

  • Industry: Telecommunication
  • Oracle Products & Solutions:
  • Oracle Communication Data Model
  • Oracle Data Integrator
  • Oracle BIEE

  • eBIW Solution:
  • OCDM Dimensional data model
  • Telecom Data Warehouse
  • CWP Analytics

#

4

Customer

Digicell, Jamaica

Details of Customer

Digicel is a mobile phone network provider operating in 32 markets across the Caribbean, Central America, and Oceania regions. The company is owned by Irishman Denis O’Brien, is incorporated in Bermuda, and based in Jamaica. It has about 13 million wireless users. Digicel provides Mobile networks, Telecom services, WiMAX Broadband and founded on April 19, 2001.

Challenges

  • Central BI Reporting Platform for 17 Caribbean Countries /Market out of 32 markets
  • 200+ source feeds from 20+ OSS/BSS systems
  • 900+ KPIs delivery as of now planned from OCDM
  • Full OOTB data model with required customization

Solutions

  • Central BI reporting solution
  • Near Real-time data loading to OCDM Stage and Foundation
  • Central BI reporting for Jamaican Hub to server 17 markets.
  • Improved end-users trust on data quality of BI report
  • Strong ETL architecture and management
  • 200+ ODI interfaces with strong process flow control
  • Migration of 4000+ BO reports to BI platform

EBIW Offers

  • Industry: Telecommunication
  • Oracle Products & Solutions:
  • Oracle Communication Data Model
  • Oracle Data Integrator
  • Oracle BIEE


eBIW Solution:

  • OCDM Dimensional data model
  • Telecom Data Warehouse

#

5

Customer

ETHIO TEL, Ethiopia

Details of Customer

Ethio telecom, previously known as the Ethiopian Telecommunications Corporation (ETC), is an integrated telecommunications services provider in Ethiopia, providing internet and telephone services. Ethio telecom is owned by the Ethiopian government and maintains a monopoly over all telecommunication services in Ethiopia. Based in Addis Ababa, it is one of the “Big-5” group of state owned corporations in Ethiopia, along with Ethiopian Airlines, the Commercial Bank of Ethiopia, Ethio-Insurance, and the Ethiopian Shipping Lines.

Challenges

  • Complex Data Model not easy to manage
  • Huge number of Customer Reports (#1000) & KPI’s (#2500)
  • 400 BI reports using OBIEE with the required customization
  • More than 3000 KPIs
    • (OOTB : OCDM Out of the Box)

Solutions

  • Central BI reporting solution
  • OCDM (OOTB + Customization) advance analytics solution provide
  • Business Requirement collection from different ETHIO departments and provide best practice scenario for that

EBIW Offers

  • Industry: Telecommunication
  • Oracle Products & Solutions:
  • Oracle Communication Data Model

eBIW Solution:

  • OCDM Dimensional data model
  • OCDM Business & Technical Requirement Solution
  • Telecom Data Warehouse