-
90%
Automated solution for data sourcing, processing addressing manual errors and anomalies
-
95%
Automated report generation and publishing
-
100%
Scalable data platform for all other application integrations
CLIENT CHALLENGES
- Manual errors and anomalies for data sourcing and processing
- Inefficient report generation and publishing
- Lack of a structured process for data handling and validation
OUR APPROACH
- Deployed a team of six (6) experienced subject matter experts to support data mapping validation & verification, data mapping & lineage documentation as per CECL requirements, out-of-process transformation, adjustments, and their documentation, in addition to assisting in ETL and/or data design while reviewing and ratifying the overall process
- Supporting ETL design and development for all out of turn adjustments currently performed manually to data elements/attributes
- Built an approval form to approve model data using Microsoft PowerApps
- Team Size: 6 - 1 Architect, 2 ETL developers, 1 UI expert and 2 Domain experts
- Functions Supported – Development
- Data loading and data aggregation to generate the refined data for CECL Validation
- Validation Process setup
- Documentation
- Support
- On going CECL Maintenance and support
- Documentation and Data support for External Audits
- Documentation
- Governance
- Data Quality rules to detect and notify data issues
IMPACT DELIVERED
- Thoroughly studied the existing data and key attributes, classified the data and key attributes on complexity, materiality and business/regulatory considerations. The results were used for validation process setup and smooth development and testing of the solution
- Helped with defining process for CECL data validation and handled communications with CECL validators
- Provided highly qualified and experienced resources at fraction of the cost
Thank you for sharing your details
Your file will start downloading automatically
If it does not download within 1 minute,
Share this on
