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
- 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
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
- 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
- Data quality rules, Exception management, Reconciliation of source vs platform, Business rules for data enrichment, Adjustment & Close management
Questions