Objective

To replace a disjointed and siloed infrastructure that made it difficult for users to obtain required data and respond to regulatory inquiries with a centralized global platform that facilitates collaboration between treasury and business units.

CRISIL's Solution

• Capture Requirements/Coordinate with Business Teams
  • Established information requirements, access rules and prioritization
    
  • Established data management rules and ownership
    
• Analyze Individual Data Source Systems
  
  • Identified 27 data source systems identified across asset classes for internal and third-party issuers
    
  • Automated data flow options between the systems; coordinated with technology teams of the data source systems
    
• Perform Gap Analysis
  
  • Benchmarked relevant client infrastructure available to systems requirements
    
  • Identified the preferred infrastructure pieces that CRISIL could build upon
    
• Assess and Upgrade Technology
  
  • Enhanced existing client Hadoop infrastructure; created a complete ecosystem of data sourcing and management functionalities
    
  • Employed Clojure, Impala, Hive and WPF.Net.
    
    • Interfaces to accept and process ftp/sftp file drops, data on EMS, pulling data using SQL drivers
    • Libraries to be able to easily create new repositories, manage changes to the data schema and carry out delete, modify or conditional data operations
    • Meta data store along with data validation, management and aggregation rules
    • Dashboard to define and access reports, pivoting, grouping and filtering tools
    • Data reconciliation workflows
    • Email report generation and scheduled dispensation services
      

Client Impact

• The new centralized global platform provided full visibility and control of positions
• Facilitated collaboration between treasury and business units
• Enhanced risk management for operational, financial and reputational risks
  

Questions

Looking for high-end research and risk services? Reach out to us at: