Analysis of change

Overview

Overview

Use SolveXia to create a meaningful analysis of change to better understand movements (for example, in liabilities).

The process, including creating “delta” model points, triggering Prophet runs and then collecting and producing waterfall analysis
Waterfall analysis of liabilities

Features

Features

Data collection and format
  • Input data in any delimited format (csv, text), Excel or Access database
  • Users can upload files directly into the process. Alternatively files can be collected via secure FTP or via direct connections to source systems (configured as needed)
Input data validation
  • Confirmation that source data is in the correct format (column structure and data types)
  • Profiling of source data for errors and critical changes (e.g. changes to MPF structure etc.)
Preparation of “delta” model point data and triggering of Prophet run(s)
  • Ability to apply iterative data transformation rules – such as changes to policyholder attributes or reinsurance ratio –  to create multiple “delta” MPFs – such as
  • Ability to send Delta MPFs via secure FTP to client file location
  • Ability to trigger Prophet run(s) via API call
Calculation of movements waterfall
  • Collection of Prophet results via SFTP or user upload
  • Joining of records in results files to their corresponding records in the delta MPFs
Reporting/analytics
  • Rules driven movements calculation
  • Automatic attribution of changes in liability to each delta MPF
  • Online dashboard showing waterfall of movements
  • Ability to drill down
Exception reporting and audit trails
  • Ability to generate specification document that outlines the end-to-end process
  • Full audit history and version control of all data loaded into the solution
  • Change history, showing any changes made to the process, including timestamp and user.

Getting Started

Seen enough? Want to know how to get started with the Analysis of Change using SolveXia?

The typical journey taken by many of our current customers using this solution involves:

  1. An initial meeting to understand your specific analysis of change needs (contact us to get started)
  2. A small, yet meaningful proof of concept exercise (usually focusing on a specific treaty or benefit type)
  3. Business, Legal, IT and Procurement sign-off for licensing of SolveXia and any implementation
  4. Initial analysis and design. This will most likely require stepping through your existing solution (such as reviewing Excel spreadsheets, Access databases, scripts and procedure documents) and talking to relevant stakeholders to design a solution that meets their needs
  5. Implementation of your solution.
  6. Training of your staff to use the solution in SolveXia
  7. Review, audit and parallel running of your solution.
  8. Ongoing support and maintenance.

Note, Step 4 onwards can be performed by SolveXia analysts as well as your internal resources (with training) or a third party (i.e. one of our consulting partners).

Why use SolveXia for an Analysis of Change?

Siginficant time savings

Being able to produce an analysis of change in minutes or hours (instead of days) means that you can do this analysis more frequently – e.g. monthly.

End-to-end automation

Produce your delta MPFs, trigger runs, collect results and analyse. Repeat.

Simplify your process

Transformation rules are visualised as “steps” in our virtual production line, making it super-easy to explain the process to others.

Enforce data quality & rules

Ensure that the format and structure of your model point data is correct and as expected – achieved by having automated data validation steps.

Scale for new products & transformations

Ensure that your change analysis keeps up with changes to the business such as new products as well as process level changes (such as additional changes to the model point data that can impact liabilities).

Audit trails and documentation

Changes to rules and data are recorded and can be reported on. Live/up-to-date documentation can be generated at any time which describes the end-to-end process (e.g. to an auditor or senior management).

Save time. Improve data quality. Empower your decision making.