Finance Actuarial

  • A specialist UK insurer of Defined Benefit Pension Funds
  • Providing industry specific guidance on approach and toolsets selection, requirements gathering, data discovery, interim and strategic solution design, data modelling, build, test and delivery
  • Provision of Industry SME, Technical Lead, L&P Business and Data Analysts, Oracle DB and ETL developer, COGNOS BI developer, Test Management and Test Analyst

PROJECT OBJECTIVE

  • To improve the quality, timeliness, completeness and automation of Scheme Policy and Reinsurance data extracts
  • To assess and make strategic recommendations on the approach to transforming the end-to-end process of delivering valuation data to Finance Actuarial; from Operational processes through to Model Point File production To realise immediate benefits within the upcoming
  • To realise immediate benefits within the upcoming valuation period

BUSINESS DATA PARTNERS’S SOLUTION

  • An initial set of workshops to capture the key deliverables, high-level requirements and existing challenges
  • Prioritisation of deliverables required for the upcoming valuation period, advancing towards a strategic position while keeping key design decisions open until detailed requirements gathering is undertaken
  • Iterative delivery of a transitional solution using incumbent toolsets to meet immediate objectives while minimising cost
  • Utilising the transitional solution as a vehicle to drive data discovery, refinement of immediate Actuarial requirements and prove key concepts of standardisation and migration of data held within operations to a single database structure containing both policy and reinsurance data, facilitating the production of Model Point Files
  • Parallel workshops , low level requirements gathering and root cause analysis activity to capture a full set of strategic requirements across the business identified as necessary to support the delivery of high quality policy and reinsurance data to Finance and Actuarial; Encompassing new business transitions, pricing, shadow scheme and reinsurance administration, longevity risk management, marketing, finance interfacing and crucially Actuarial valuation extracts, overlays, adjustments and model point file production
  • Production of strategic options, assessment of incumbent toolsets to required toolset capabilities by option and associated build estimates.
  • The transitional delivery was completed in November 2016 and B&D are continuing to support the strategic delivery

BENEFITS

  • Up-to-date data available to support the accurate assessment of the organisations 2016 solvency position
  • Additional reserves released as a result of the updated solvency position
  • Significant progress made toward the organisations Audit Committee strategic objectives
  • Significant reduction in manual intervention necessary during the 2016 valuation
  • Costs associated with transitional delivery kept to a minimum
  • The transitional solution has provided (for ‘in scope schemes’):
    • A fallback position for the 2017 valuation
    • A fully QAd test harness for the 2017 strategic solution
    • A migration path for the 2017 strategic solution
    • Conformity and standardisation of data across schemes and their associated benefits
  • A clear view of the 2017 strategic options available and the development cost associated with them

TECHNOLOGY & SKILLS

  • Oracle Database and ETL development
  • COGNOS BI Metadata Modelling and Reporting
  • Data Modelling
  • Project Management
  • Process and Technical Business Analysis

QA and Testing

By continuing to use the site, you agree to the use of cookies. More Information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close