Follow us on Facebook Follow us on Google Plus Follow us on Linkedin Follow us on twitter
 
Success Stories
BSCS Data Migration
Upgrade / Migration of BI and Reporting Platforms
Business Objects Architecture Upgrade
Data Integration Health Check & ETL Optimization

Telecom Corporate Dashboard

Automotive Corporate Dashboard

 

Data Integration Health Check & ETL Optimization

BBI supporting OTA for Optimization of ETL Process To Improve Data Availability

CLIENTS



KEY BUSINESS IMPERATIVE
Re-design of ETL Methodology, Architecture and Techniques for Optimized Performance.
Focus:
Tackling design issues and handling of bottle-necks to maximize utilization of TeraData and Informatica and improve Data Availability substantially within short period (7 weeks)
 

IT INITIATIVE
DWH ETL Optimization

Project Description
ETL Re-design for Optimized Performance

THE CHALLENGE
OTA, has succeeded to build a new DWH model extracting Subscriber, Usage, Billing and Other key data from multiple source systems. While the process operates functionally well, a performance problem has manifested itself with the increase in data volume and requirements for new data models. The result of such has led to recurring delays in data availability and hence impacting the value of timely reporting.

BBI ADVANTAGE

  • BBI has highly skilled and experienced ETL / Informatica Developers profiles with Telecom and Datawarehousing strong expertise
     
  • BBI offered a quick-win plan based on targeting the key bottlenecks in the ETL process with re-design and optimization

RESULTS/BENEFITS

  • Achieved over 5 hours of reduction in extraction window (30% of Total Time Window)
  • Identified Areas of bottle-necks in DWH extraction process
  • Re-designed and optimized Long Tasks in ETL leading to tangible improvement
  • Delivered technical documentation for re-designed/optimized mappings


360 Data warehouse Assessment
Telecom Data Warehouse Solutions
360 BI and Reporting Assessment
Business Objects Latest Version Migration
BSCS Online Reporting
Applications Reporting Solutions
ODS and Online System Reporting
360 Data Integration Health Check
Concrete Data Integration Solution
BSCS Data Migration Solutions (BSCS, ERP, SEIBEL, OTHERS)
Data Quality Management
Cutting Edge Operational and Corporate Dashboards
Customer Behavioral Analytics
Customer Segmentation
Churn Prediction
Next Best Activity
Social Network Analysis
Tariff Optimization

 

 
About Us Solutions Products Success Stories
About BBI
Why BBI is Different?
BBI Offerings
Our Team
Our Methodology
Our Partners
Our Customers
Careers
Awards
Contact us
End-to-End Enterprise Data Warehousing
Reporting & Data Integration
Data Migration & Data Quality
Dashboards, Advanced Analytics & Segmentation
Data Mining Solutions
360 Data warehouse Assessment
Telecom Data Warehouse Solutions
360 BI and Reporting Assessment
Business Objects Latest Version Migration
BSCS Online Reporting
Applications Reporting Solutions
ODS and Online System Reporting
360 Data Integration Health Check
Concrete Data Integration Solution
Data Migration Solutions (BSCS, ERP, SEIBEL, OTHERS)
Data Quality Management
Cutting Edge Operational and Corporate Dashboards
Customer Behavioral Analytics
Customer Segmentation
Churn Prediction
Next Best Activity
Social Network Analysis
Tariff Optimization

 
BSCS Data Migration
Upgrade / Migration of BI and Reporting Platforms

Business Objects Architecture Upgrade
Data Integration Health Check & ETL Optimization
Telecom Corporate Dashboard
Automotive Corporate Dashboard

2011 BBI - Better Business Intelligence Consultancy - ALL RIGHTS RESERVED