Siebel Data Warehouse Implementation
Siebel data warehouse implementation at a major telecom client in the San Francisco Bay Area.

Objective
To transform the data contained in the enterprise system(s) into a decision support system for executives, managers and employees.

Solution
  • Data transformation from disparate systems in near real time
  • Built a usable data store with historical information dating back in time from the inception of the business
  • Extracted selected data from the financial system (Oracle Financials) and the order Entry System (Siebel) and put them together in the data warehouse
  • Integrated the data from the two systems and made them consistent
  • Simplified the data by dropping unwanted data elements, introducing new ones, and combining data (i.e. data massaging/ETL) to give composite and meaningful views to users
  • Formatted queries for quick reviews
  • Provided all of the above capability and functionality from a web browser eliminating the need for fat clients to be loaded and updated on individuals systems
Result
Successfully built a data warehouse to support the growing analytical needs of the business. Solution provided the ability to look at the data through multiple sets of eyes and be able to slice and dice in multiple dimensions and drill down to the lowest grain of data in the operational system. Users now have access to near real time information regarding the overall health of the company including on demand P&L varied analysis of the revenue, expenses, orders placed and number of customers.

Technology
Oracle 11i, Siebel 6.x., Brio, PL/SQL, SQL


Did You Know ...

According to a recent IDC study, business consulting will be an area of increasing focus and innovation for services providers, as well as greater user spending. IDC expects worldwide business consulting spending to increase at a compound annual growth rate (CAGR) of 3.9% from 2005-2010. The study attributes this upward forecast primarily to the accelerating convergence of business and IT processes. This increasing link between business and IT is in part causing nearly all general management consultancies (GMCs), advisory firms, and consulting niche players to significantly build up their technology-focused capabilities, intellectual property (IP), and talent. (Source: IDC)