420 likes | 510 Views
EP116 Building a Global Financial Portal. Ernest Bako Practice Director Financial Services Solutions Sybase, Inc. ernest.bako@sybase.com. Financial Portal Basics Financial Portal Example Financial Portal Applications. Agenda. Financial Portal Basics
E N D
EP116Building a Global Financial Portal Ernest Bako Practice Director Financial Services Solutions Sybase, Inc. ernest.bako@sybase.com
Financial Portal Basics Financial Portal Example Financial Portal Applications Agenda
Financial Portal Basics Our vision and the Sybase Enterprise Portal platform Agenda
A single, integrated interface to business information, events, and applications Providing personalized access to content, user communities and services Enabling e-business transactions any place, any time, from any device So What is a Portal?
A Personalized User Experience Commerce Search Community Roles Profile Feedback Personalized Content Integration
A platform to: Integrate and interact with existing operational and decision support systems Organize and manage complex content from diverse sources Deliver personalized content to customers, employees, and partners The Sybase Enterprise Portal
The Sybase Enterprise Portal provides infrastructure components and services Financial Fusion delivers financial industry specific protocols, business objects and applications Partners provide additional horizontal and vertical solution components Customer specific functions are implemented on an integrated platform Financial Portal Strategy Customer Specific Applications Partner Solutions External Systems
Portal Solution Examples Compliance Reporting Internet Banking Trading Profitability Treasury Management
Financial Portal Example Implementing a trading portal hub Agenda
e-Portals: Enabling Global Services Global Users, Local Context Global Access, 24 x 7 Operation Access Devices Portal Content Providers Service Providers Financial Institutions
Financial Portal Interfaces Mobile Devices Workplace Devices Financial and Telecom Infrastructure Portal Servers Content Providers Integration Servers Service Providers Financial Institutions
User authentication, access control, profiling, security Content search, management, personalization, distribution Application, mainframe, event and data integration Data exchange & transformation, message and protocol adapters Application templates, user profiles, portal metadata Published content, marketing ads, user profiles, click-stream Portal Building Blocks Portal Servers Integration Servers Database Servers
Trade Execution and Settlement Investment Manager Broker/ Dealer Clearing Corporation Depository Investor’s Custodian Broker’s Custodian Execution Agent The Traditional Approach: individual, point-to-point interfaces Order Order Confirmation Execution Execution Trade Notice Trade Notice Settlement Instruction Settlement Instruction Instruction Settlement
Typical Requirements: Access control based on explicit user profiles and authentication Personalized content based on explicit user profile and access control lists Straight-through processing to financial institution back-end systems Information exchange using financial protocols Event-driven and workflow- enabled processes Securities Trading Portal Investment Manager Broker/ Dealer Buy Side Sell Side Investor’s Custodian Broker’s Custodian Execution Agent Clearing Corporation Depository
A Straight Through Processing Hub Execution Agent TIB/RV TIB/RV MQ TIB/RV MQ MQ FIX FIX FIX FIX FIX FIX SWIFT SWIFT SWIFT SWIFT SWIFT CMS XML XML XML XML XML XML Broker’s Custodian Broker/ Dealer Clearing Corporation Investor’s Custodian Investment Manager Matched trades Settlement details Accounting details Orders Executions Orders Executions Allocations Confirmations Net amounts Financial Portal Hub Instructions Trade notices Matched trades Matched trades Settlement details Accounting details
Order Loop via a Trading Portal Hub Execution Agent TIB/RV TIB/RV MQ TIB/RV MQ MQ FIX FIX FIX FIX FIX FIX SWIFT SWIFT SWIFT SWIFT SWIFT CMS XML XML XML XML XML XML Broker’s Custodian Broker/ Dealer Clearing Corporation Investor’s Custodian Investment Manager Matched trades Settlement details Accounting details Orders Executions Orders Executions Allocations Confirmations Net amounts Financial Portal Hub Instructions Trade notices Matched trades Matched trades Settlement details Accounting details
Financial B2B Server handles integration with financial institution systems Can be deployed on portal site, in a service bureau, or at the financial institution Deployed in a high availability cluster configuration Message broker handles: message validation protocol conversions rule-based message transformation and routing Message repository XML-based Protocol engines: OFX, FIX, SWIFT Securities Trade Processing Investment Firm Broker’s/ Investor’s Custodian Execution Agent Clearing Agent Broker/ Dealer Investment Manager Broker/ Dealer FIX supports: Orders, Allocations, Indications of Interest, Quote Requests, Execution Reports Settlement Instructions • SWIFT supports: • Trade confirmation • Clearing &settlement • Custodial operations • Liquidity management • Risk management • STP Financial Portal Financial Server FIX SWIFT SWIFT FIX
Sell-side Trade Processing TIB Business Objects SWIFT APP1 APP2 APP3 CMS FIX Message Broker MQ Core Application and Transaction Services SQL Adapter TIBCO Execution Agent Broker enters trade Trader notified of execution Trade sent to ECN for execution via FIX Trade reviewed by desk manager for compliance/limits - approved Financial Portal Server Execution report returned via FIX Trade captured & logged to trading desk database Event Broker TIBCO Adapter SQL Adapter propagates transaction to Event Broker which sends it to the order management system via the TIB/RV Adapter Execution report returned to trading system via TIBCO & EEB Financial Server
Sell-side Trade Processing - Alternative TIB/RV Business Objects SWIFT APP1 APP2 APP3 CMS FIX Message Broker MQ Core Application and Transaction Services SQL Adapter TIBCO Execution Agent Trader notified of execution Trade reviewed by desk manager for compliance/limits; - approved Execution report returned via FIX Trade sent to ECN for execution via FIX Financial Portal Server Trading System SQL Adapter propagates transaction to EEB, which sends it to back-office accounting system via MQ Series Trade published on TIB/RV bus; picked up by Financial Portal Server Broker enters trade Trade captured & logged to trading desk database MQ Adapter Event Broker Broker/ Dealer
The Trading Portal – Protocol Level Investment Firm Custodian Execution Agent Clearing Agent Broker/ Dealer Investment Manager Broker/ Dealer Financial Portal Dictionary & Rule Database Logging Database Integration Server FIX SWIFT SWIFT FIX FIX
The Trading Portal Architecture TIB Protocol mapping & conversion Rule-based message routing Business objects Business logic Portal Server Process mapping Message routing Transformation Event Broker Integration Server Database Server Message capture Message transformation TIB/RV Adapter SQL Adapter MQ Adapter Rules & Routing Database Logging Database Message delivery Safe store & forward ORCL DB2 SYBS MQ Existing Systems
Partners already support required protocols Portal deployed at an ASP All integration is done at central location Central management Shared costs Trading Portal Deployment – Option A ASP Portal Server Buy Side Sell Side Integration Server Investor’s Custodian Broker’s Custodian Execution Agent Clearing Corporation Depository
Lead party - broker/dealer - decides to host portal Other parties need custom back-end integration Some partners do not support protocols Integration server deployed on hub spokes at partner sites Trading Portal Deployment – Option B Buy Side Sell Side Broker’s Custodian Broker’s Custodian Integration Server Integration Server Portal Server Integration Server Integration Server
Financial Portal Applications - Content Aggregation - Content Search - User Profiling - Personalization - Targeted Marketing Agenda
Performance indicators Investment tools Market analysis Stock quotes Investment Research
Single login and access to multiple accounts Content aggregated from multiple sources Role-based access to personalized content Investment planning and monitoring tools Targeted marketing and product promotions Personal Finance
Dynamic assembly of content based on individual profile and preferences Role-based personalization drives content using pre-assigned user roles Explicit personalization assembles content based on user-stated preferences Automatic or implicit personalization adapts the site’s presentation and navigation based on user behavior Personalization
Personalized Web Page Targeted Ads Messages, Alerts Custom content
User visits portal site Portal server authenticates user, retrieves profile, sends it to content servers Content aggregation server retrieves content from 3rd party content providers Content delivery server retrieves template, merges content, sends customized page to web server Web server delivers web page with customized content Content Aggregation Web Server Content Server Portal Server Database Server Aggregation Server Profile Template Content Providers
Natural language, concept-based search Search and categorize over 200 file formats Extracts concepts, creates hyperlinks to relevant information Categorizes information based on user profiling Eliminates very expensive manual document tagging Supports multiple languages Search & Categorization Web Server Content Server Portal Server Database Server Search Engine Profile Content Content Providers 200+ file formats
Profiling refers to the collection of information about a user’s behavior Explicit profiling uses user stated preferences Implicit profiling tracks user interaction with the portal Enables effective targeting and cross-selling Enables delivery of targeted ads and personalized content Enables customer enrollment and application for financial services and products Profiling
An existing customer… Father of two pre-school children High savings account balance Does not own a home … would see these messages: … but not this one: Targeted Marketing • Learn about special offers for first-time home buyers
Financial targeting based on: Account balances Spending profile Credit history Risk rating Demographic targeting: Family and marital status Gender, age, income Geographic targeting: State, residence area Targeted Marketing
Web site destination Direct ads on affiliate sites Co-marketing campaigns Co-branded products Examples Credit card / airlines Private label cards Targeted Marketing
Web content personalized for specific customer segments based on: Demographic profile Financial profile Lifecycle status Targeted messages can include text and images: Product promotions Custom messages Banner ads Content delivered to specific locations on portal or to affiliate web sites Profiling and Targeted Marketing Templates Ads Profiles Customer receives targeted ads and messages This customer is excluded… Web Server Content Server Database Server Portal Server Profiling Engine
Checking accounts Savings accounts Credit card accounts Account statements ACH and wire transfers Home equity lines of credit Home equity term loans Consumer loans Mortgage loans Business loans Internet Banking
Consumer and utility bills Financial institution bills Recurring payments Bill Presentment and Payment
Service requests Account management Application administration Customer Enrollment
Event capture: database, timed, TIBCO, MQ Series Data transformation: row-set to XML, SQL to message Event filtering & processing Custom process logic can be linked to events Guaranteed message delivery Enables workflow and process automation Event Integration TIB Web Server Content Manager Event Broker Portal Server Database Server TIB/RV Adapter SQL Adapter MQ Adapter ORCL SYBS DB2 MQ
Financial Portal Architecture Web Server Investment Firm Broker’s Custodian Investor’s Custodian Execution Agent Clearing Agent Broker/ Dealer Service Providers Content Providers Investment Manager Broker/ Dealer Financial Application Server Financial Portal Server Content Manager Profiling Server Mainframe Integrator Event Broker Financial Server Security, Profile, Clickstream, Templates, Application db. Search Engine Aggregation Server Information Warehouse
System Configuration Example Internet Big/IP Big/IP Firewall Firewall Switch Router To internal network To business partners Switch Switch Switch • Web server cluster: • Web servers • Content manager • Static content files • Portal server cluster: • Financial portal servers • Integration servers • Aggregation server • Event broker • TIB/RV adapter • - FIX, SWIFT engines • Database server cluster • Portal database servers • Replication server • Event broker • SQL adapter • MQ adapter