Case Studies
 
    Finance
 
    Insurance
 
  Telco
 
    Healthcare
 
    High-tech
 
    Public Defence
 
    Retail
 
    Others
 
Download Center
 
  Company brochure
 
  Company presentation
 
  Case studies presentation
 
 
     
    Telco
     
   
Cellcom
Orange
     
 
    Cellcom
   


Customer Quick Facts

The second largest cellular provider in Israel
Subscribers – Over 2.5 Million
Employees – Over 3000
Over 400 points of sale
Infrastructure investments - Over 1 Billion $
Pioneer in 3G technology

Business Challenges

Move from market share to profit strategy

High saturation (100%+)
Many silent customers
Phantom churn

Improve retention

Customer satisfaction - Low
Churn rate - High

Increase ARPU

Cross sell & up sell
Measure profitability
Customer value

Introduce new products

I-mode – new Japanese concept from NCC
3G – was behind the competition
Fiber optics for enterprises

Comply with regulator demands

10 digit numbers
portable numbers
Call history

   


Gilon's Solution Objectives

The project will achieve the following:
  • 90% Performance improvement
  • Process over 100 Million CDR’s a day
  • 10TB of raw data >> 42TB of storage >> 84TB mirroring
  • Updated daily with 40GB data
  • 7/24 Availability
  • Near Real Time Informatica ETL
  • No effect on performance during the day loading
  • Backup & Restore with only a slight effect on performance
Gilon Implementation
     
   
     
   

Projects Results

Better understanding of customers

Profiling
Segmentation
Scoring 

Dynamic reaction to customers contact

React in real time to events
Improved time to market
Improve success rate of campaigns
Act according to value

Distributing information to integrate business processes

DW has become mission critical just as any other
operational system

Single version of the truth

Significantly reduce discussions and disputes time

Using the same data/events for multiple purposes –

Churn management system, Profitability, campaign management , revenue assurance, every one works on the same data

     
   
   
     
 
   

Orange

Customer Quick Facts
The largest cellular provider in the country
Established: 1999
Subscribers: 2,600,000
Market share: over 30%

Business objectives
Increase profitability
Improve performance

 

Strategy

Preserve investment

Preserve vast investment  made in the DWH

Support  new business initiatives

Content, media ,3G , advertising

Improve performance

Performance became unbearable upgrading the hardware would cost a fortune

Add scalability

Size of data is increasing dramatically and new sources are continuously being added

Stability recovery capabilities

Increase availability for the users , reduce night window , recover from disasters

Real-time capabilities

Have the ability to retrieve Data while loading , Trickle feed

Gilon's Solution Objectives

Database Improve data model, redesign architecture, DB tuning, handle scalability, handle performance.
ETL – Redesign ETL strategy, improve performance, robustness, scalability.
Data Quality – Data profiling, implement DQA procedures, continuous data improvement.
Methodology – Development standards, versions release procedures.

Gilon Implementation
The challenges at the company's DWH performance became critical due to the rapid growth of the company in subscribers' and thus in usage volumes.

The company started with 100,000 subscribers and grew to several million in 2-3 years. Consequently there was a significant increase in ETL processes, more complicated logics were added, the processes became unstable and the entire DWH situation became mission critical.

Gilon's approach was to develop a high level design for all processes in three different channels:

  • Build new processes correctly
  • Improve existing processes
  • Improve access to Oracle

Implementation included the following processes:

Mapping problems with a global view

  • Building processes the right way
    • Incremental load
      • Generic mechanism for identifying deltas
      • Generic mechanism for identifying target population
    • Splitting complex maps
    • Recovery mechanism from last fall
    • Reuse of generic objects

Improving performance in Informatica

  • Reduced lookups
  • Use of sorted aggregates
  • Use of joiners with sorted merger
  • Use of update strategy
  • Limit the population as early as possible

Improving performance in Oracle

  • Use of analytical functions whenever possible
  • Insist on the correct explain plan
  • Remove indexes before full load
  • Extensive use of snapshots
  • Extensive use of partitions
  • Bulk updates

The results
Improved performance, scalability and robustness which allowed the company to add processes according to business needs and significantly improve usability scope of the DWH.

     
   
 
Terms of use | © All rights Reserved.
 
 
Company
Solutions
Products
Consulting
Case Studies
Press Room