Data Assurance Case Studies
Case studies from a top global insurance & asset management company with over £1 trillion in assets and others.
Payroll Automation for Pension Administrators
Pension Scheme On-boarding
Pension Risk Assessment: Accepting & determining risk assessment from third-party pension data the customer wants to acquire.
Pension onboarding – Time to comprehensively onboard acquired Pension data took anywhere between 2 and 10 years to take full ownership. Identifying & handling data errors like quality & completeness was a cumbersome manual effort.
Testing a variety of Express>It templates with a variety of raw data in a short period was a challenging task.
The testing team closely interacted with the business team to understand these templates’ real-time usage, helping the testing team design the scenarios and test data for template testing as a data analyst, resulting in end-to-end test coverage templates.
The 100% test coverage resulted in minimum or no production defects; this created a standard process for the Data.
An analyst can follow, and the customer can expand teams as no one in the team needs to be an expert.
Proving MSBI Frameworks by creating the complex metadata and packages based on different test scenarios
This solution leveraged Elaits FastTrack framework which automatically generates SSIS packages.
Elait designed a testing framework for verification of Metadata maintanance GUI of the .net application which allowed the source selection from multiple options, appropriate transformation rules and target load as per user’s choice.
The testing team created the complex metadata and packages based on different test scenarios to prove the frameworks. The team verified the transformations using SQL scripts, proved the rollback & recoverability, and executed performance tests.