webinar: wealth management reporting- leveraging bpm and ccm to drive customer centricity

Wealth Management Reporting

Solutions for Business Process, Customer Communication & Content Management

Typical Wealth Management Scenario

Caters to investment

products for one or

more client in a

Banker’s relationship

portfolio

Investment Counselor

Operational Support

works with one or more

banker s to support client

reporting requirements

Support Team

Member of banker

support team works

with one or more

bankers

Owns relationship

with clients for all

types of asset and

liability banking

products

Relationship

Banker

HN

I , Ultra

HN

I an

d C

orp

ora

te C

us

tom

ers

Equity,

Fixed income

and

Mutual funds

Derivatives

and

Alternative

investments

Loans &

Deposits

Work

sheet

Market

Intellige

nce

Legacy Systems

CRM

Third Party System

Multiple Data

Sources

Data

Extra

ctio

n

Sta

tem

en

tsR

ep

orts

Info

rma

tion

Data

Pro

cessin

g

Info

rma

tion

http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=_C1GFqLqMFcphM&tbnid=FRUptnp4snX1rM:&ved=0CAUQjRw&url=http://www.icondig.com/icondetails/6290/256/&ei=1thDU_SACcaGrgeLuIGYAg&bvm=bv.64367178,d.bmk&psig=AFQjCNF0elUuBS5GVJmOMvebnZIPoBFiJA&ust=1397041592107957



Are these your challenges ???


Personalized Report on Customer Demand

1. Consolidation of data

from various systems like Deposits, Equity, Equity, Fixed income , Mutual funds, Derivatives , Alternative investments, Deposits , Insurance etc.

2. Errors in data consolidation

3. Data Quality issues

4. In time Data availability

5. Standard Reports are not helping

6. Personalization involves a lot of back office support

7. Multiple approvals required

8. Customer complains that delays in report Impedes investment decision

This bulky report contains information

which is of little interest to me. I urgently

need a consolidated report on

1. Realized Gain/Loss

2. Exchange Traded Funds

3. International Equity

Sure Sir !!

Since this is a

personalized report will

get this compiled and

sent to you in 5 Working

Days…

Issues Faced


Detail Report Personalization &

Localization

Customized Report

with Customer

Specific Marketing

Precise

Report

Comprehensive

Report

Data

Security

Mass Customization yet Compliant

Summary Report ( With Masked

Personal Information)

InvestmentPerformance

Report

Relationship

Banker

Portfolio Performance

Report

Market Movement

Report

Report in Native Language, Domestic

Currency , Color Scheme etc

Sample Statement

Holdings and

Transactions Report


Development Efforts in Personal Report Creation

1. High

Development

Effort cost

2. Inflexible

temple

modification

and

customization

process

3. High TAT with

custom report

generation

4. Major support

from backend

teams

5. High

maintenance

cost.

Standard template

Multiple Data Source

Development Team

Personal Reports

( Personal Templates)

Development

EffortIssues Faced

Operation/

Support Team :

Personal

Report/Template

creation


Manual Report Creation

Standard Reports

( Pre Defined Templates )

1. Consolidation of

data from various

systems

2. Errors in data

consolidation.

3. Data Quality

issues

4. SLA Violations for

Data availability

5. High TAT for report

generation

Issues Faced

Operation/

Support Team :

Manual report

creation using

standard template

Equity,

Fixed income

and

Mutual funds

Derivatives

and

Alternative

investments

Loans &

Deposits

Work

sheet

Market

Intellige

nce

Legacy Systems

CRM

Third Party System

Multiple Data

Sources




Meeting Regulatory Compliance

1. Difficult to cope

with changing

regulatory

requirements based

on countries &

states

2. Workarounds

getting complicated

over time

3. Bespoke solution to

cater to Regulations

Disclaimer

Risk Exposure

Capital & Liquidity

Definitions

Report Terms

Issues Faced

Mandatory

Disclosures


Huge Risk

1. Chances of missing regulatory notes / disclaimers

2. Spreadsheets can be outdated

3. Cut / Copy / Paste errors

4. Missing sections while collating report

5. Manual calculations or entry errorsMarket Analytics

User Spreadsheets

Core Data Sources

Other Data Sources

Issues FacedAnalyst Reports


New Way of Working….

Let’s combat your challenges together ..!!!


Redefining Reports

Report to be viewed as an aggregation of components

Component is a reusable logical grouping of data columns, computations, static text

and layout

Example of components could be: Customer Profile, Relationship Summary, Portfolio

Return, Cash & Short Term Investments, Realized/Unrealized Gain etc.

Dynamic data in these components gets automatically fetched and rendered based on:

Customer ID

Reporting Levels (Relationship or Group, Entity, Account )

Date Range

Country / Geography

Currency

Data display option (Tabular or Graphical: Charts, Graphs)

Component level disclaimers

Component level filters


Wealth Management Reporting- Solution Overview

Various Data Sources

Base Report Creation

3rd Party System

(Client/Banker Portal)

Personalized

Reports

Create components and add to Library

Portfolio

Return

Template Design

Report Generation

Portfolio

Report

Wealth Management Solution

can generates wide range of

Wealth Management Reports for

Ultra High Net worth Individuals

as per their individual

requirements and preferences.

Features

• Flexible Report Creation Engine

• Create/View/Regeneration

Customized Reports

• Custom Templates Storage and

Retrieval

• Workflow Driven Collaboration

• Access to Heterogeneous

Databases.

MQ

CRM

Assets & Liabilities

http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=Dl0JZc-38gM7jM&tbnid=7W-iKjrnQmU2xM:&ved=0CAUQjRw&url=http://www.marblewebsites.co.uk/databases.php&ei=aNhDU6_yEYWNrQfgsYGoCw&bvm=bv.64367178,d.bmk&psig=AFQjCNF0elUuBS5GVJmOMvebnZIPoBFiJA&ust=1397041592107957



Equity, Fixed income

and Mutual funds

Loans &

Deposits Worksheets CRM Market Intelligence

Data

SourcesDerivatives and

investments

Data

Consolidation

Data

Reconciliation,

Quality check and

Pre Calculation/

Aggregation

ETL – Extraction, Transformation and Loading

Staging Base File

Base File

Base Report

Creation

Wealth Management Reporting- Data Consolidation

Legacy Systems Third Party System

A Base Report contains structured data

which is collected from various

applications and systems.

This data is used for creating various

decision-making and analytical reports.



http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=qBP1R-iij-g7HM&tbnid=sRSsG9kjKZ7ssM:&ved=0CAUQjRw&url=http://www.sqlsoldier.com/wp/sqlserver/schemaonlybackupsandrestores&ei=ZMhCU9zcMMKCrgeB44GQAg&bvm=bv.64367178,d.bmk&psig=AFQjCNFwZDm19JqzTlA5jNiB6BDTx6ZK3w&ust=1396971985374511

http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=qBP1R-iij-g7HM&tbnid=sRSsG9kjKZ7ssM:&ved=0CAUQjRw&url=http://www.sqlsoldier.com/wp/sqlserver/schemaonlybackupsandrestores&ei=ZMhCU9zcMMKCrgeB44GQAg&bvm=bv.64367178,d.bmk&psig=AFQjCNFwZDm19JqzTlA5jNiB6BDTx6ZK3w&ust=1396971985374511



http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=b4MOI38zqGO38M&tbnid=seK0JDz8ga25lM:&ved=0CAUQjRw&url=http://www.bcpiweb.com/database-solutions-using-alchemy-oracle-sql-access.php&ei=scpCU8j0GomBrgfp6YGIDg&bvm=bv.64367178,d.bmk&psig=AFQjCNGQ5gLNhV9xEjcWSMAQmktshZxx1Q&ust=1396972557249145

http://www.google.co.in/url?sa=i&rct=j&q=&esrc=s&frm=1&source=images&cd=&cad=rja&uact=8&docid=b4MOI38zqGO38M&tbnid=seK0JDz8ga25lM:&ved=0CAUQjRw&url=http://www.bcpiweb.com/database-solutions-using-alchemy-oracle-sql-access.php&ei=scpCU8j0GomBrgfp6YGIDg&bvm=bv.64367178,d.bmk&psig=AFQjCNGQ5gLNhV9xEjcWSMAQmktshZxx1Q&ust=1396972557249145


Base File

Base

Report

Portfolio

ReturnCash Flow Unrealized Gain Portfolio

Comparison

Approver

Component Library

Approver does a rigorous testing of the components using sample data for all possible permutations and combinations. Once approved these become part of certified component gallery for quick report designing

Portfolio Return

Cash Flow

Unrealized Gain

Portfolio

Comparison

Component Creation

Data Set Creation

Wealth Management Reporting- Component Design




Portfolio ReportPortfolio Report

Approved

Template

LibraryTemplate is approved and

sent to template library to

facilitate quick report

generation as per customer

preferences

Portfolio Report

Customer Type 1

Component Library

Formattin

g Gallery

Entitlement Group

Summary Report

Disclaimer:This is a computer generated report..

Portfolio Allocation

Summary Report

DisclaimerJkmdkl ldkkdk dkdkksk kdkal sk alkkskdkka

kdkkal;amd kakdkkdka dkkd the hheen sooom

sjdodn.


Wealth Report

Associated Group

Wealth Management Reporting- Template Design


Portfolio Report

Summary Report

Disclaimer .


Wealth Report

Relationship

Banker

On Demand Request : Frequently asked Reports

Customer request a

frequently requested report :

Portfolio Report

Relationship Banker

selects the predefined

report temple from the

library

Portfolio Report

Relationship Banker triggers report

generation on real time basis

On Demand Request : Custom Reports

Customer Request

Customized Report

Relationship Banker selects

a blank template, drag n

drops the necessary approved

report components.

Disclaimer:This is a computer generated report.

This does not require any signature,.

Incase of any failure please contact

us on our Emergency number 1800 -

101-2302.

Market Risk are subjected to

movement mo movements we don’t

take any responsibility

Summary Report

Template

Library Formatting

Gallery

Component LibraryCustomers

Wealth Management Reporting- Report Creation


Portfolio Report

Summary Report

Disclaimer:

This is a computer generated report.


Wealth Report

Relationship

Banker

Portfolio Report

Scheduled Report Generation

Relationship Banker can

schedule reports for

different customer based

on the report preferences

and delivery mode

Based on the schedule

different reports are

generated and

dispatched to respective

customers

Template

Library Component LibraryCustomers

Wealth Management Reporting- Personalization

Formatting

Gallery


C O N T E M P O R A R Y R E P O R T I N G

Unified and Comprehensive Reporting from many

sources

Scheduled and On-Demand Reports

Personalized Information and Layout

Attractive Layouts

Individual Dashboards

Consistent Branding

Enforced Review

Automatic audit and archival

Wealth Management Reporting- Key Highlights



E A S E o f D E S I G N

Drag and Drop placement

Resizing of component

Right based access of template

Multiple Layer Support

Style Gallery

Template Gallery

Master template creation with

header, footer, logo etc.

Graph

Barcode

Dynamic Image URL

Placeholders for Database Field.

System Fields

MS Word Authoring support



Sampling and Auditing

Sequential Sampling

Random Sampling

Searching

Management rights according to

various roles :

Design Approval

Generation Approval

Distribution Approval

R I G H T S M A N A G E M E N T





T A R G E T E D P R O M O T I O N

Business Rule determined Promotional

Message

Conditional Annexure for Cross Selling

Capture Customer Interest through Dynamic

Hyperlink

Hyperlink on Image

Business Rule –

If ( CustomerType = ‘Gold’)






S E C U R I T Y

Password Protected PDF

Digital Signature in PDF Statements

https:// enabled portal

SSO and LDAP Authentication Support








Multi format resultant files PDF, AFP, HTML,

DHTML with sorting and drill down functionality.

Assured delivery of the objects in Printed or

electronic form

Acknowledgement workflow to ensure delivery

Track Undelivered statements : Track Undelivered

Statements , Integration with barcode reader.

D E L I V E R Y

S E C U R I T Y






I N T E G R A T I O NWEB SERVICES

MIDDLE WARE

Centralized and unified reporting solution

Provision of generic framework to dynamically

incorporate existing services, WSDL etc

Extensive use of XML using SOA for dynamic

generation of components/reports.


D E L I V E R Y

S E C U R I T Y







Fast SearchIndex based Search

Search on Content/field

Volume Independent Search on

same filters

ArchivalIn Built Secured Content

Repository

Adapter for DMS

I N T E G R A T I O N

D E L I V E R Y

S E C U R I T Y





A R C H I VA L A N D R E T R I E VA L


I N T E G R A T I O N

D E L I V E R Y

S E C U R I T Y





A R C H I VA L A N D R E T R I E VA L

M O B I L I T Y

Report Generation to work on iOS, Windows and Android platform to support

“Any-time Any-where” reports.

Any-time Any-where Reporting



Faster TAT in Report Generation

Wealth Management Reporting – Lets Talk Numbers

Report Generation TAT : 2-5 Day Pre WMR

implementation

Post WMR

implementation Report Generation TAT: 15-20 Min

100 % SLA Adherence

SLA Adherence : 60 %Pre WMR

implementation

Post WMR

implementation SLA Adherence : 100%

Quality: Right First Time – 100%

Right First Time: 70 %Pre WMR

implementation

Post WMR

implementation Right First Time : 100%


Quick & Easy Template Designing & Maintenance Drag & Drop based Template Designing

Web based designer to design reports using published components

Quick response to change in template designs

Predefined Template, Font and Style Gallery

Component Design & Reusability Reusable Component Designer based on parameters from various

data Sources

Workflow based approvals for the designed components

Necessary validations and auditing of the component design process

Personalized & Multilingual Report Generation Reports could be made available in different languages based on

Customer Preferences, Demographics, Country or Community etc.

Customized Reports for individual customers

Wealth Management Reporting – Intangible Benefits


Empowering the Relationship Bankers

Able to service customer’s on demand requests with minimal

TAT

Highly personalized error free reports

RM’s are empowered to schedule reports on varied frequencies

– Daily, Weekly, fortnightly

Relationship

Banker

Custom reports for Different Customers

Wealth Management Reporting – Intangible Benefits


Thank You

30

webinar: wealth management reporting- leveraging bpm and ccm to drive customer centricity

Technology

compliantsummary report

consolidated report

business process

personal report creation1

customer demand1

custom report generation4

consolidation of data

data consolidation3