The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

EDM Releases Progress Update on Faulty Data Pilot and Details of Semantic Repository Project

Share article

It has been a busy month for the EDM Council, not only has it released an interim report with IBM on the findings of its project to measure the performance implications of missing or faulty data on key functions within financial institutions, it has also released details of plans for a new online semantic repository.

The report highlights the results of the data variance pilot, which has been designed to measure the data quality of 42 data elements needed for trade confirmation and has so far involved 51 fixed income securities across nine financial institutions.

“Our project with IBM is part of our core metrics initiative and it is one of the original objectives that the EDM Council was set up to achieve,” explains Mike Atkin, managing director of the EDM Council. “When the EDM Council was set up we talked about finding out the ROI and impact on an institution of investing in EDM. We have since organised metrics to measure the impact of EDM on institutions and the interim report is an update on that.”

The data elements studied in the report were drawn from interviews with 25 of the EDM Council’s member institutions, which were each asked to pinpoint the data attributes that were critical to the day to day running of their business.

“We came up with key performance indicators to measure the value of EDM. We conducted a data variance pilot with a number of firms to see where there was variance in terms of data across the institution. The data elements we looked at were supposed to be the same across the institution but we saw 20 to 30 per cent variance in those elements in our pilot. We saw the data gap that exists and the next step was to quantify the impact of the bad data on various business processes,” Atkin elaborates.

This pilot is based on the EDM Council’s analysis of data flows concerning nine core data attributes that feed calculations and may cause problems downstream: coupon rate, current factor, dated date, day count convention (method), first coupon date, maturity date, next call date, rating and valuation. Participants in the pilot were asked to provide values from their securities master database for analysis.

According to the report, the results confirmed a significant level of inconsistency, which varied as much as 30 per cent, on a number of critical data attributes. For example, there were 20 instances of coupon differences, 81 mismatches for issue date, plus many other elements where the discrepancy rate was initially expected to be much lower.

As a result of the findings, the group has decided to expand the size of the pilot group with regards to the number of firms involved, the instruments and types of security covered, and beyond the original 41 data elements measured. It is also looking at analysing the root causes of this variance and the potential costs of inconsistent data. “By using test scenarios you can actually calculate your value at risk and gain a quantified perspective on the impact of inaccurate data,” says Atkin.

As well as this ongoing pilot, the EDM Council has just released the details concerning the first draft of its semantic repository. The repository will identify all data attribute terms and definitions used by financial institutions for business processing, investment decisions, scenario modelling, risk management and portfolio valuation. The initial draft of the repository is due to be released at the end of June and it aims to tackle the problem of ambiguity within data terms used in the financial markets.

“We are talking about achieving consistency in the terms, meanings and definitions in the context of business reality for the data that sits in everybody’s master files. All we are talking about is really a dictionary of data terms in the market,” explains Atkin.

The EDM Council believes that the repository will reduce the amount of manual reconciliation required and streamline institutions’ business processes, as well as making it easier to create consistent benchmarks and perform risk analysis.

The project is under the direction of Mike Bennett, director of consultancy firm Hypercube, and has been designed as a collaborative publishing activity in the vein of internet encyclopaedia Wikipedia. It will therefore enable all interested participants to edit or add to an entry on their subjects of expertise.

It will be hosted on the EDM Council’s website and will be divided into two areas: material that is under review and material that has been validated by industry experts. The EDM Council hopes that the repository will be used as a common set of business terms by financial institutions, vendors and regulators to reduce the amount of mapping required during data transference.

“So far we have got the project funded and initiated and we have used all the source material that we have access to come up with draft repository. We used about six or seven source documents from which we compared and normalised the data to come up with our own definitions. We are now asking people to comment and change the entries in the draft with a full audit trail. We are also setting up subject matter expert groups to look through the amendments and get agreement on the definitions,” says Atkin.

Related content

WEBINAR

Recorded Webinar: How to run effective client onboarding and KYC processes

Increasing cost, complexity and regulatory change continue to challenge firms implementing client onboarding and Know Your Customer (KYC) systems. With an effective strategy and a clearly defined pathway, it’s possible to gain a valuable competitive advantage whilst meeting those all-important compliance requirements. But how to get there? With a myriad of different options out there...

BLOG

And the Winner Is….

The results are in, and A-Team Group is delighted to announce the winners of our annual RegTech Insight Awards, celebrating the very best and most innovative solutions and providers within the fast-growing RegTech space. Now in their fourth year, the prestigious annual awards recognise both established solution providers and innovative newcomers, seeking to herald and...

EVENT

Data Management Summit USA Virtual

Data Management Summit USA Virtual will explore how sell side and buy side financial institutions are navigating the global crisis and adapting their data strategies to manage in today’s new normal environment.

GUIDE

Regulatory Data Handbook 2020/2021 – Eighth Edition

This eighth edition of A-Team Group’s Regulatory Data Handbook is a ‘must-have’ for capital markets participants during this period of unprecedented change. Available free of charge, it profiles every regulation that impacts capital markets data management practices giving you: A detailed overview of each regulation with key dates, data and data management implications, links to...