Objective

• Create centralized global platform for closer collaboration between treasury and business units by providing full visibility and control of positions, and help manage operational, financial and reputational risks 

Background

• Disjoint systems catering to multiple businesses; extremely difficult for users to get complete information reliably and easily. 
• Ever increasing regulatory and compliance inquiries and requirements
  

CRISIL's solution

• Capture requirements; coordinate with business teams
  
  • Establish information requirements, access rules and prioritization
  • Establish data management rules and ownership
    

• Analyze individual data source systems which covered the business process and product lifecycles
  
  • 27 Data source systems identified  across asset classes for internal and third party issuers; 
  • Automated data flow options between the systems; coordinate with technology teams of the data source systems
    
• Perform gap analysis of relevant client infrastructure available vis-à-vis the target system to deliver; identify the preferred infrastructure pieces that CRISIL could build upon
• Technology: Enhance existing client Hadoop infrastructure - objective was to create a complete ecosystem of data sourcing and management functionalities
  
  • Technology used – 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
  • Created a 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

Questions

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