Telecom and Media Company, Virginia, US

Problem Definition

The customer is a mid-size telecom and media company in Virginia. In 2010, they decided that the existing reporting and Decision support system, which was based off of Excel and Microsoft Access databases, was inadequate for their reporting and BI needs in a highly competitive marketplace. The company management decided to replace it with an Oracle data warehouse.

What We Did

Our team studied their requirements and came up with a solution that involved implementing an Oracle data warehouse and reporting framework using SSAS/SSIS. We designed a scalable data warehouse solution and implemented the ETL processes using SQL/PLSQL and Unix shell scripting. We also developed a framework to automate the ETL processes. Reports and Dashboards were implemented using MicroStrategy and SSAS/SSRS

The Outcome

Post implementation the customer gained better decision making capability that resulted in improved customer experience, improved ARPU, increase in revenues and customer retention. The data warehouse has since grown to multi terabyte size and yet meets the expected performance benchmarks. We continue to provide services to this customer.

Networking Equipment Manufacturer, California, US

Problem Definition

The customer is a multinational networking equipment manufacturer in California, U.S. We were approached with a requirement to develop a Data mart for the accounting and finance department. Source of data was Oracle Financial applications and reporting was to be done using BusinessObjects BI platform.

What We Did

Our Team worked with the on-site technical and functional resources and designed a finance data mart. ETL Development was done using Oracle SQL/PLSQL and Unix Shell scripting. Reports were developed using BusinessObjects.

The Outcome

The project was implemented successfully and met all the expectations of the business users