Oi

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.

Customer service required a unified customer view to respond quickly to customer requests.

Product management needed to integrate various systems to bring products and services to market quickly and to support them effectively.

Management needed an up-to-date and comprehensive data warehouse to quickly respond to changes in market conditions and opportunities.

Management also needed high performance access to trusted data to minimize fraud and comply with mandated service level agreements.

Challenges

Consolidate 17 customer databases into one 20-terabyte data warehouse.

Fast-growing data volumes led to unacceptable delays in the time taken to consolidate and load information into the 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.

Solutions & Results

Supported launch of aggressive marketing campaigns to capture new customers and increase its share of wallet with existing customers.

Cut warehouse loading process time in half, from ten hours to five.

Increased volume of historical data available to users by 20%, helping Oi to identify market trends and new potential revenue opportunities.

Lowered the time to provide number portability and fraud prevention data to government agency from 13 hours to three hours.

Reduced credit recharge process time by 60% and increased response capacity by 400%.

Technologies Used

Informatica PowerCenter

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

Informatica PowerExchange

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

PowerCenter Pushdown Optimization Option

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

Informatica Enterprise Grid

Exploits grid computing architectures for data integration.

Informatica Real Time Option

Integrates and provisions operational data in real time.

Informatica Metadata Manager

Integrates and provisions operational data in real time.

Success Stories

Access Health CT

Access Health CT drops uninsured rates by 50 percent

Western Union

Western Union built a data platform based on Hadoop and Informatica Big Data Edition

M.D. Anderson Cancer Center

Informatica empowered scientific and clinical collaboration at this renowned cancer center by turning data into knowledge and facilitating self-service business intelligence