IDS Company Profile - IDS GmbH - Analysis and Reporting Services

Haider Mannan
High-Quality Reports:
Vision or Mission
TSAM Europe
25 March 2014
2
Ill-defined data management jeopardizes all subsequent
analysis and reporting processes.
© IDS GmbH – Analysis and Reporting Services
2
3
Excessive challenges require current operating models
to function beyond their capabilities.
Tighter regulation for AM
UCITS IV/V
AIFMD
EMIR
FATCA
MiFiD II
Increasing IT costs
…
Demanding clients
Optimization of data management
Extension of controlling systems
Need for business intelligence
technology
Automation replaces manual
processes
New reporting requirements, e.g.,
CRR / CRD IV
Solvency II
Hard competition
Need for innovation
Harmonized markets
Emergence of international providers
New competitors
Market consolidation
Investment consultants in play
New products
New instruments
Stronger sales pressure
Clients more sensitive to price
Higher price transparency
Net outflows during the financial
crisis
© IDS GmbH – Analysis and Reporting Services
3
4
Example: Typical data quality issues in source systems
for performance attribution
Error
Consistent security data, but still inconsistent cash data (check: cash reconciliation)
Correction of Corporate Action
Investment values have been converted to portfolio currency using wrong rates or have not been converted at all
Impact (bps)
0 - 300 bps
0-5 bps
0 - 200 bps
Forex are wrong
up to 30 bps
Margin payments of futures are wrong (check: lead to gain on future cash in INV-currency)
up to 30 bps
Future positions: Missing price or nominal leads to exposure not being calculated
NAV check fails
Transactions appear twice
Transactions have been missing (issue with positions reconciliation)
up to 500 bps
3 - 100 bps
1 - 20 bps
3 - 100 bps
Transaction values (Set or Market Value) are wrong
1 - 20 bps
Transactions have been sent with wrong sign (issue with positions reconciliation)
1 - 40 bps
Unknown issue with correction security
1 - 100 bps
The market value of one position is wrong (e.g. calculated using a wrong price)
1 - 20 bps
Transactions have been sent with wrong settlement currency (issue with cash reconciliation)
1 - 40 bps
© IDS GmbH – Analysis and Reporting Services
4
5
The solution is a managed service platform using a vertical
integration approach.
Reporting on Results of
Specific Analyses
Performance
Attribution
Regulatory
Calculations
Other
Analytics
Analytics Engines
Software
Solution
Software + BI Tool
Enterprise Reporting Solution
Full Managed Service
Integrated Reporting with
Results of Different Analyses
Specific Datamarts
Standardization, Revaluation
Golden Source
Data Import, Validation,
Cleansing and Enrichment
70% of total effort for
high-quality
performance attribution
spent up to this point1
Data Management
Data Governance
Data Acquisition
© IDS GmbH – Analysis and Reporting Services
Data Sources
1analysis
carried out by IDS
5
6
Case Study: Swisscanto required a solution to meet
their high standards for performance attribution.





Joint venture and asset manager of the Swiss Cantonal Banks.
Leading investment fund provider (#4), asset manager and provider of occupational and
private pensions solutions (#2) in Switzerland.
Regularly recognized for excellence by leading national and international rating agencies for
its performance as fund provider.
AuM: 51.2 bn CHF*
121 investment funds
Requirements
 Performance attribution reports for portfolio management and client reporting.
 Uniform decision-oriented reporting across all asset classes.
 Attribution process adapted to Swisscanto’s individual investment process.
 Coverage of daily portfolio and customized benchmark data at individual position level.
 Minimize workload for data management, data enrichment and quality control.
*as at 31 December 2013
© IDS GmbH – Analysis and Reporting Services
6
7
Case Study: All project goals were reached within
6 months.
June 2011
IDS selected as
provider
September 2011
Interfacing IDS
December 2011
Prototyping,
Reporting,
Testing; Quality
control
Productive reports
for first funds
Go-live
Performance
attribution reports
for 50 funds
2 monthly report
sets per fund
Ongoing
Extension of
services
Rapid and
individual adoption
of additional
services to account
for new strategies
and investment
concepts
Added regulatory
reporting for banks
and insurers on
same data set
© IDS GmbH – Analysis and Reporting Services
7
8
Case Study: Implementation and enhancement of services
was easily accomplished by IDS’s operational model.
Reporting
One workflow, one dataset based on a highly scalable
Portfolio analytics based on
Client defined content
and flexible platform
state of the art applications
scheduled and ad hoc
Other Software
Performance
Attribution
Preprocessed
Client Data
Golden
Records
Technical
Compliance
Cross
Referencing
GRIPS
Client’s
systems
Market Data
Sources
Business Platform
Portals
Analytics
Reporting
Business Process
Master Record Keeping
Financial Library
Data Management and Governance
Analytics
Reporting
about 50 data vendors
361 source systems
10,400 portfolios in total
253,000 instruments identified monthly
26,600 reports on a monthly basis
4.2 million instruments in data warehouse
50 million client holdings monthly processed
over 1,000 bn EUR assets under reporting
(as at December 31, 2013)
© IDS GmbH – Analysis and Reporting Services
8
9
Takeaways
Highly competent and service-oriented
contact persons and focus on the
interpretation of results.
Certified procedures, permanent quality
controls, transparent processes and
long-term experience in the business.
High Quality Reports
with IDS Performance
Attribution
Solid platform as a basis for qualityassured and cost-efficient
improvement of services and
satisfaction of future requirements.
© IDS GmbH – Analysis and Reporting Services
Implementation of interfaces from
various sources to a high-performance
platform and capability to provide
standardized and customized solutions
according to current regulatory
requirements.
9
10
Contacts
Haider Mannan
Director International Business Development
+44 750 66 75 102
[email protected]
IDS GmbH – Analysis and Reporting Services
Koeniginstrasse 28
D-80802 Munich
Bockenheimer Landstrasse 42-44
D-60323 Frankfurt/Main
www.InvestmentDataServices.com
© IDS GmbH – Analysis and Reporting Services
10