Oracle Financial Services Data Warehouse

The Oracle Financial Services Data Warehouse provides financial institutions a proven, practical platform that can manage data for analytical applications used for risk, finance, compliance and customer insight. It can manage the sourcing of data and the preparation of reports that provide managements the insight that they require. Its comprehensive financial services data model draws upon over fifteen years of implementation and “real world” experience from around the world. Institutions that use this data foundation can deploy an analytical data warehouse in a fraction of the time required to develop a warehouse from a conceptual or logical data model.

Institutions can develop and deploy advanced computational models as well as conduct stress testing and scenarios analysis within the warehouse. It offers full-lifecycle metadata management, business-driven data quality checks, reconciliation with the general ledger, data mart management and workflow capabilities. It uses an industry-leading analytical application infrastructure together with application frameworks to help manage the end-to-end lifecycle of data within the warehouse.

CIOs can enable their businesses to perform complex “what-if” scenarios and enterprise level analytics previously thought to be impractical or impossible – a true “win-win” scenario for business and IT. By combining the simplified architecture of Oracle Financial Services Data Warehouse and the raw power of Exadata they can simultaneously provide the fastest possible query response for time sensitive ad-hoc analytics and reporting and cut operating costs by combining siloed functional warehouses across business lines.

Oracle Financial Services Data Warehouse is pre-integrated and ready to work with over 30 Oracle Financial Services Analytical Applications including award-winning applications for Enterprise Risk Management, Governance, Risk, and Compliance, Enterprise Performance Management and Customer Insight. In addition, third party or applications developed in-house can also capitalize on this common, unified approach

• Proven, unified and comprehensive data model for reporting and business intelligence based on extensive experience in Global Tier I institutions
• A common staging area architecture
• End-use driven and pre-defined physical data model for sourcing and provisioning
• Thousands of pre-built data quality checks contextualized to end use
• Fully integrated capabilities for data quality, metadata and reconciliation with GL
• An open, extensible platform which also supports external analytical engines, applications and models developed internally or from third parties
• A platform ready for use with Exadata

• Readily deployable solution reduces implementation time
• Fully supports all key analytical use cases for Financial Services in the areas of Risk, Compliance, Customer Insight and Performance Management
• Deploy new and advanced analytics with unprecedented ease
• Simplify ETL and achieve the shortest possible load times and batch windows
• Provide the fastest possible query performance across all business domains
• Eliminate accuracy and consistency issues with contextual data quality checks
• Eliminate inconsistencies across ledgers, books and marts for confident and auditable reporting
• Provide the capability to handle high-volume, what-if computations across all business domains to support
• Ensure clean, GL reconciled data for analytical processing/reporting
• Easily meet emerging or changing cross-functional business and regulatory mandates
• Reduce the complexity and cost of maintaining multiple data marts
• Enable consistency, transparency and auditability across all analytical domains