Customer Need

Qualcomm Enterprise Services (QES) offers a suite of software products to help shipping fleet customers manage their drivers, vehicles, and end customers. One of the main reasons clients lost customers in competitive situations was due to a lack of an integrated reporting and analysis system across their many applications.

An effort was formulated to create an application titled QES Analytics manager to better position the business competitively within the market.

The client's objective was to generate revenue from licensing QES Analytics Manager to customers via the QES Customer Portal, as well as using QES Analytics Manager to help bring new customers to QES and generate revenue across many applications.

Solution Overview

KPI Partners collaborated with the client to develop a complete end-to-end data warehouse and business intelligence system. OBIEE is embedded in the custom portal on one end and integrated with a single sign-on (SSO) solution. End users access the portal and the portions of QES Analytics Manager that they are licensed to see. Each customer has access to only their data, but a key innovative feature is an ability to allow customers to compare themselves against the larger industry. Thus, every metric in the system is comparable to the larger industry as a whole.

The client's Oracle BI solution is built on top of a 3-layer data warehouse platform. At the lowest level is a real-time layer developed using Informatica Change Data Capture (CDC). Here, tables are replicated from each of the source systems in a real-time manner. This real-time layer is also used as the source for a traditional data warehouse layer refreshed in a batch mode 2 times per day. Finally, on a daily basis, the data mart layer is refreshed from the aforementioned data warehouse layer. The data-mart layer uses a traditional star schema model to support Oracle Business Intelligence queries.

Business Impact

After go-live, new uses for the system are continually identified; it is growing beyond its initial plans. Qualcomm Enterprise Services is adding new functionality that was previously licensed to various business partners. This new functionality produces direct cost savings, eliminating the need for external licensing.