FINACLE OPERATIONAL DATA STORE Get the most out of data, cost effectively! Banks grapple with colossal amounts of data, often dispersed across disparate systems in their environment. The arising challenges include:
• • • •
Collation and consolidation of information with minimal manual intervention Transformation of data into meaningful enterprise-wide reports and undertaking data analysis for business effectiveness measurement Unified presentation of data Leveraging data to drive up revenues and profitability
Decision makers are constantly driven to reduce the time taken and the costs incurred to mine and leverage the wealth of information available on customers, markets and operations. Consistent reports generation is deemed critical to empower end-users with relevant information, to better segment understanding, increase cross sell opportunities, personalize products, identify emerging opportunities, manage risks better and create differentiation. A proven means of addressing these challenges is a technology enabler that ably manages the bank‟s data.
Finacle operational data store Finacle operational data store empowers banks with a secure and reliable technology infrastructure to derive optimal value from data, and meet a whole range of operational, business and strategic objectives. This is enabled through support for data access and retrieval on demand. The store can be effectively leveraged to meet the bankâ€&#x;s demand for reporting, risk management, analytics etc. The easy-to use operational data store provides decision makers an anytime-anywhere unified view of the bankâ€&#x;s structured operational data. It supports consistency of data, playing a pivotal role in transforming key institutional data into measurable performance indicators.
Functional architecture Source System Non Finacle Applications (For illustration)
Finacle Family
Finacle Core
General Ledger
Finacle CRM Human Capital Management Finacle Treasury Supply Chain
Finacle e-Banking
Data Layer
ETL & Staging Area
Finacle ODS
Downstream Applications Partner Solutions
Analytics (Finacle Analyze)
Rich Pricing
Customer Analytics
Regulatory
Credit Analytics
Risk Management
Operations Analytics
Uni ed View
Enterprise Customer View
Enterprise wide Risk
Layer architecture
• Finacle
Finacle
Products Homogenized Transactions &Integrated Data
Sourced Data RDBMS Dump Flat Files
Other RDBMS Applications
Account
UI Data
User Interfaces
minimal and flexible interdependencies
Indicative Subject Areas CRM
Core Products
e-Banking
WMS
Trade Finance
Treasury
Flat Files CIF
E TL
amongst 600+ ETL jobs
•
Semantic Layer User Management Data Security Management
Erroneous Data Dump Finacle
Flat Files
RDBMS
UI Data
Data error and audit management: prebuilt, configurable and comprehensive
Other Entities ETL
Parallelized ODS ETL help achieve
Dispatch Management
Uni-Directional Data Interfaces Downstream Extracts Rich Pricing Regulatory Risk Management
•
Well documented and integrated metadata, which also drives scheduled ETL loads
Canned Reports
Business benefits
Metadata
Ad-Hoc Reports Dashboards Error Reports
Data “push” and “pull” possible from source systems Hierarchical structures for summarization and navigation across region, zone, branch etc Ability to perform historical and trend analysis Supports complex data tranformations Can act as a system of record Integrated metadata
Increased business agility Finacle operational data store provides banks an efficient and effective means
Aligned with Finacle roadmap Extendible data model (business area model) Tool agnostic metadata solution Comprehensive error and reconcilliation process Extensive audit management
of meeting their regulatory, analytical Legend
Out-of-the-box features Solution part ready to deploy with minor changes
and MIS reporting requirements. This streamlines data dissemination processes and enables decision-makers to respond to business imperatives with greater agility.
Key modules Data provisioning
•
Comprehensive data provisioning across different subject areas (Loans and deposits, operative accounts, trade finance, wealth management, CRM,
•
• •
leveraging of Soft Referential Integrity
Finacle operational data store takes on
(SRI) constraints for relationships
the rigors of managing operational data,
Flexible and highly customizable
relieving OLTP and other transactional systems at the bank off the load. This eliminates the need for access to the
e-banking, treasury, payments, pricing
sources and to provide additional data
production database for generation
and regulatory related data attributes)
elements
of reports, significantly enhancing
Extracts to support regulatory asset liability management, risk
Technology features
•
performance of the transactional infrastructure.
Industry standard best practices on
Greater reuse and lower maintenance costs
management solutions and
Extraction, Transformation and Load
relationship-based pricing
(ETL) implemented at architecture,
Comprehensive business and technical
design and base code levels
Coupled with its integrated metadata,
Well integrated and seamless data
elements for data governance and ability
sourcing from Finacle UBS
to integrate multiple data sources, Finacle
metadata including provision on
•
ownership, stewardship details
Data model structure
•
Improved performance Support for entity-based definition and
Extensibility to accommodate new data
reporting, MIS reporting systems,
•
•
•
Pre-built ETL patterns and enforced data governance allow non-Finacle
Standardized data model, tuned for
data sources to be added in a
core banking systems, for yielding
standardized way with equal ease
operational BI
operational data store enables a relatively cost efficient means of managing the maintenance of multiple downstream extracts.
About Infosys Finacle Infosys Finacle partners with banks to transform process, product and customer experience, arming them with „accelerated innovation‟ that is key to building tomorrow‟s bank.
For more information, contact finacleweb@infosys.com
www.infosys.com/finacle
© 2013 Infosys Limited, Bangalore, India. All Rights Reserved. Infosys believes the information in this document is accurate as of its publication date; such information is subject to change without notice. Infosys acknowledges the proprietary rights of other companies to the trademarks, product names and such other intellectual property rights mentioned in this document. Except as expressly permitted, neither this documentation nor any part of it may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, printing, photocopying, recording or otherwise, without the prior permission of Infosys Limited and/ or any named intellectual property rights holders under this document.