Technologists

Facilitate devops and accelerate application delivery through a combination of dataops and deep domain expertise

 

At FWD View, we work directly with CIOs and CTOs, and fully appreciate the unique set of challenges they face in driving innovation and transformation across the organisation.

  • Application Owners
  • Development Teams
  • Testing Teams

Case Study: International Investment Manager

Tool selection and data centric security model implementation – Risk Data Warehouse

We were engaged by our client, and international investment and asset manager, to execute a General Data Protection Regulation (GDPR) exercise to identify Personally Identifiable Information (PII) on their most business critical Risk Data Warehouse and then mask the identified data. 

 

The data was contained within SQL Server RDBMS and also CSV files on Linux OS.Our client uses the Delphix Data Platform for the virtualisation of data and  was looking to extend the product to include the data masking toolset. This toolset has a basic profile of financial datasets that can be used to identify the relevant information, though is not comprehensive. FWD View developed the PII dictionary specifically for the capital markets industry, that is used to compliment the Delphix Masking profile. 

 

As part of the exercise FWD View introduced the functionality of a data cataloguing tool, which would enable us to design and build a GDPR workflow, that would then automatically crawl terabytes of data; identifying, tagging and profiling the relevant PII. 

We implemented Waterline Data as the Cataloguing tool, designing a data centric security model which allows for enhanced security and compliance at the data level without impacting agility from a reporting, development or testing perspective. 

Combination of Delphix profiling and masking tool and customized scripting

Our client now has the ability to dynamically tag, profile and mask sensitive data with a crucial step at the end of the process, which validates and gives confidence in the masking results.

 

As well as advising on the appropriate tooling and implementing the solution, we ensured the technology was supported with corresponding business processes. We developed a GDPR workflow that can be harnessed across many different types of database technologies and areas across the enterprise.

Improve your data management

If your data fulfillment cycle is not providing your business with fast, automated or secure management of data, then get in touch with FWD View today. We aim to work closely with every client to ensure we can eliminate points of friction, by enhancing the way your business leverages data.