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​