Data Cleansing for

1
Data Cleansing for Corporate Actions
2
Topics

• Background
• Environment today
• Challenges faced
• Reliable sources of data
• Automated data cleansing catalysts
• Targeted benefits
• Technology environment
• Automated data cleansing illustration
• Process complexities

3
Background

• Industry participants
• Investment Banks/Brokers
• Wealth/Fund Managers
• Custodians/Clearers/Third Party Administrators
• Registrars/Transfer Agents
• Substantial external market pressures
• Corporate actions volumes increasing
• Greater volume volatility
• Increasingly complex events
• Few have yet to adopt automated data cleansing
  techniques

4
Corporate Actions
5
Process Issues

• Data received from multiple sources at different
  times
• Format and quality of content is often
  inconsistent between sources
• Considerable amount of data received in
  non-electronic form
• Considerable manual checking and re-keying to
  core systems
• Difficult to manage latency/bottlenecks
• No correlation between errors and loss

6
Automated data cleansing catalysts

• ISO15022 and normalisation of data
• Pro-active management of process vital
• Clerical checks are expensive and slow
• Volumes, locations and organisation scale now
  make it economic
• Potential loss far exceeds cost of solutions
• Vendor recognition of Vertical Market and its
  requirements
• Recognition of broader opportunities

7
Targeted benefits

• More rapid and accurate processing
• Improved productivity and capacity
• Notification alerting and escalation
• Real-time information for supervisors
• Increased process transparency
• Once captured, data available to all systems
• Segregation of duties
• Process/Vendor metrics and audit trail

8
Key technology requirements

• Users defined rules to detect errors
• Automatic or manual repair user defined
• Variety of methods to repair data available
• Data vendor independent
• Alerting capabilities
• XML capabilities
• Web browser based GUI
• Interaction with Middleware and Worklow

9
Strategic target environment
10
Automated data cleansing illustration
11
Data cleansing opportunities
Data Marts
Business Processing
12
Summary

• Automated data cleansing has direct application
  to Corporate Actions
• Benefits will be both tangible and soft
• Guaranteed control and productivity improvements
  quickly attainable
• Improved quality assurance and speed
• Will need IT integration effort to get true
  benefits

13
Data Cleansing for Corporate Actions