Data warehouse and Oracle Business Intelligence solution helped the customer save more than $240000 on an annual basis.

“CCSI consultants created a data warehouse that helped us consolidate data from multiple data sources, streamline our reporting, and improve our security, which lead to significant cost and time savings.”

Data Warehouse and Oracle Discoverer implementation - developed for a leading 3rd party mortgage company- was designed and developed to provide the following functionality:

• A central location for all company data from Informix, Oracle, and SQL data sources.
• Oracle Cube Views for improved query performance leading to faster reports.
• Streamlined process for reports.
• Single technology implementation for all enterprise reporting.
• Reduce licensing cost and overhead for disparate technologies.
• Users did not have to request IT for most of their minor to mid level report changes.
• Better control over “Who gets to see what data and Report” by centralized authorization and management process.

SITUATION

Over the years multiple databases had been introduced into the customer’s enterprise due to acquisitions and application development. Most of these databases were on different RDBMS such as Informix, Oracle, SQLServer, and even Access in some cases. Each department had created their own reporting solutions using various technologies such as Excel, Oracle Reports, and Crystal reports with assistance from IT department. For any changes to the existing reports, users were forced to request IT resource time. This caused a huge overhead in terms of maintenance costs, in addition to a severe security risk concerning sensitive consumer data that could be accessed by multiple users across divisions without centralized control of any sort. In addition, some reports caused significant load over production databases causing noticeable delays during business hours

SOLUTION

CCSI personal proposed an integration of all enterprise-wide data from multiple databases to a centralized Data Warehouse. This would allow all the reporting to be consolidated to a single technology from a single source.

A detailed analysis of all the existing reports across divisions was performed and all the required data elements were identified. This analysis also assisted in establishing an appropriate data model for the Warehouse.

Custom ETL were then written to extract the data off the source databases and populate them into the centralized database.

Subsequently, Oracle Business Intelligence tool (Discoverer) was deployed and configured to re-create all the existing reports required by the various divisions. Oracle Application server and database instances were already part of the customer’s enterprise and so in house expertise was available for maintenance purposes.

Training material and classes were conducted for the users to acquaint them with the BI tool and its usage.

ADDED VALUE

The following advantages were gained from inclusion of a centralized reporting database:

• Single reporting technology to maintain
• Reduced Licensing Costs
• Reduced maintenance resource costs
• Centralized data security to determine “Who gets to view What?”
• Report consolidation across departments
• More flexibility for the user
• Minimal dependency of business on IT
• Reduced production database load and risk