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