Formed through a series of mergers, Oi is the largest telecommunications company in Brazil, with 10,000 employees, more than 31 million customers, and annual revenues of $14.5 billion.

“We needed a single view of the customer and faster updates to our enterprise data warehouse to support our programs. Informatica gave us the single platform we needed, and the agility to continue to lead in our market.”

Vera Duarte

Enterprise IT Manager, Oi
Business Need
  • Marketing and Sales needed a single view of the customer to drive and manage up sell, cross sell and other marketing campaigns.
  • Product management needed to integrate various systems to bring products and services to market quickly and to support them effectively.
  • Management also needed high performance access to trusted data to minimize fraud and comply with mandated service level agreements.
  • Customer service required a unified customer view to respond quickly to customer requests.
  • Management needed an up-to-date and comprehensive data warehouse to quickly respond to changes in market conditions and opportunities.
Challenges
  • Consolidate 17 customer databases into one 20-terabyte data warehouse.
  • Government rules on number portability and fraud prevention demanded that the national database be updated every six hours with customer changes—OI’s legacy database could only achieve this in 13 hours.
  • Fast-growing data volumes led to unacceptable delays in the time taken to consolidate and load information into the data warehouse.
Solutions & Results
  • Supported launch of aggressive marketing campaigns to capture new customers and increase its share of wallet with existing customers.
  • Increased volume of historical data available to users by 20%, helping Oi to identify market trends and new potential revenue opportunities.
  • Reduced credit recharge process time by 60% and increased response capacity by 400%.
  • Cut warehouse loading process time in half, from ten hours to five.
  • Lowered the time to provide number portability and fraud prevention data to government agency from 13 hours to three hours.

Products & Services

Informatica PowerCenter

Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hand coding.
LEARN MORE

Informatica PowerExchange

Accesses mission-critical data and delivers it throughout the enterprise wherever it’s needed, on any schedule.
LEARN MORE

PowerCenter Pushdown Optimization Option

Optimizes database assets by “pushing down” data transformation processing into any relational database.
LEARN MORE

Informatica Enterprise Grid

Exploits grid computing architectures for data integration.
LEARN MORE

Informatica Real Time Option

Integrates and provisions operational data in real time.
LEARN MORE

Informatica Metadata Manager

Integrates and provisions operational data in real time.
LEARN MORE

Success Stories

Illinois State University

LEARN MORE

Illinois State University

LEARN MORE

Western Union

LEARN MORE

Western Union

LEARN MORE

M.D. Anderson Cancer Center

LEARN MORE

M.D. Anderson Cancer Center

LEARN MORE

read more success stories