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