LEGAL & GENERAL - INSURANCE CASE STUDY

Using the Schematiq Discovery service, Legal & General were able to use Data links to move data to controlled stores such as databases or cloud, systematically reducing risk across the business.

The Problem

  • Rigid legacy systems had not kept up with evolving business requirements across whole group​

  • Around 500,000 spreadsheets existed around the business supporting all aspects of business creating high operational risk and lack of scalability​

  • Existing project to reduce spreadsheet risk had no idea of scale of problem, or where to start​

Our Solution

  • Schematiq Discovery scanned, analysed and reported on 500,000 files in a few days​

  • L&G used Schematiqto detail current state issues and track improvement over time​

  • This enabled rapid audit of GDPR compliance by identifying any sensitive personal data items across entire spreadsheet estate​

Our Delivery Differentiators

  • Analysis with SchematiqDiscovery allows the development of a strategic plan for remediating spreadsheet issues​

  • We focus on the largest problems first and track improvement over time​

  • Auto-analysis focuses on potential business issues caused by spreadsheets at a process level rather than individual files​

Results

  • L&G were able to structure projects to systematically resolve spreadsheet risks​

  • HTI assisted with pilot projects to rapidly create robust, scalable, compliant processes enabling business to scale​