Golden Data Repository for centralized finance and regulatory reporting for a large European Investment Bank

 

Objective

 

  • A large European Investment bank wanted to build a new integrated and unified system in place of existing fragmented system for the purpose of eliminating key man risk, better control and regulatory compliance
    • The big data model approach to have a completely new system which can cater to the various groups within CFO organization for financial and regulatory reporting
    • System Design, Data modelling, Data enrichment, Validations, Adjustments, Data sourcing and reporting and support development in agile environment

 

Challenges

 

  • Catering to a challenging vision in building a single platform for multiple group leads to complex data modelling and design challenges
  • Aligning the program’s vision with the user requirements is a challenge for BA's to balance and provide an acceptable solutions
  • Documentation of current state analysis with as-is model with validation checks and creating POC’s for critical control validations
  • Identifying a right mix of talent across different area’s within change function

 

CRISIL's solution

 

  • Solutioning &  Documenting the Requirement
    • Gap and impact analysis
    • BRDs & solutioning
    • PoC's
  • Development Support, Testing & Validation
    • Mock-ups & User Stories
    • Test cases & scenarios
    • Functional testing
  • Dry Run, Parallel Run & Go Live
    • Dry, Parallel run and Go-live support & User education
    • Variance analysis and presentation to business
  • Project Management, Governance & Control
    • Support to OpCo, working group, design forum etc.
    • RAID logs, standardisation of sprint planning and reporting

200+ reports for Group Disclosure, Provided support across functions within finance change team, documentation of the end to end business process etc.,

 

  • Data Modelling
    • Physical data modelling and logical data modelling in big data platform to cater to the multiple reporting group within CFO Organization
  • Sourcing & Reporting
    • Front to back data flow of the existing vs. proposed structure, identifying required attributes, documentation of reporting logic, analysis & validations
  • Common Services
    • Data quality rules, Exception management, Reconciliation of source vs platform, Business rules for data enrichment, Adjustment & Close management

Request for services

Error Msg
Error Msg
Error Msg

Questions



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

 

United States
1-855-595-2100/
+1 646 292 3520

 

United Kingdom
+44 (0) 870 333 6336

India
+91 22 33 42 3000 /
+91 22 61 72 3000