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

A-Team Insight Blogs

Jordan & Jordan Unveils Reference Data Testing Kit

Share article

Jordan & Jordan (J&J), a New York-headquartered management and infor-mation technology consulting firm, has introduced a so-called Reference Data Testing Framework (RDTF) and will offer it to clients as part of its reference data consulting services.  

Developed by J&J over the past two years, RDTF is a customizable framework and set of tools that address the need for automated data testing and verification within reference data projects. It allows for one-time creation of test data records along with an analysis specification that is used to analyze test results. Among the data products supported are Bloomberg Data License and Reuters DataScope.

Although RDTF is primarily used during the development and integration test cycles of a reference data project, it can also help with vendor selection and offshore testing.

Essentially, it takes data in different parts of the data-processing lifecycle, compares it to expected results, and reports on exceptions. The exceptions can then be analyzed to determine whether problems lie within the systems, process or the data itself.

“When you want to validate or arbitrate your reference data, you need a test,” says Richard Shriver, managing director, technology services, at J&J. “We recognized that testing involved repeatable generic processing, and so we evolved some of the custom development software into a reusable toolkit. By using the toolkit within our consulting service, we provide clients a more efficient service – better, faster and cheaper – and give clients the confidence that they are dealing with people who understand the business processes enough to ask the right questions.”

Features of RDTF include:
Record count checks for raw records loaded into the system and reports on missed records.
User-friendly test data creation with accompanying test analysis specification on a per-record basis.
Customizable implementation-specific analysis for test results.
Excel-like reports on test results, details of exceptions and client specific report additions.

Components include a data reader/generator, data loader, analyzer and reporter. Test reports include summary pass/fail, exceptions and detail reports, as well as an array of custom reporting options.

The J&J Reference Data Consulting Service comprises domain experts for a broad range of asset and data classes, technology experts who have implemented large-scale multi-asset reference data systems for major investment banks and hedge funds, as well as a testing strategy that includes the use of RDTF. The firm also offers consulting for institutions looking to manage reference data test and support teams offshore.

According to Shriver, with any data reference implementation project, regardless of whether software is provided by third-party suppliers or developed in-house, there are a lot of business rules and data definitions specific to each client. These all need to be independently verified and tested.

He says: “If you want to change the reference data process, you need to verify data that comes into and out of the process.”

Although “there are lots of people selling software and solutions,” Shriver says each client still has a lot of work to do to ensure the system works as expected. That’s where J&J can help.

Shriver says J&J has a growing reference data consulting business. In the past two years, the company has consulted on three major enterprise reference data projects within North America, as well as smaller projects – such as content or software changes – including vendor evaluations and RFI development.
Although pricing for J&J services varies depending on the project, Shriver says a good rule of thumb is to budget 20% of the development and implementation costs for testing and verification.

 jj.jpg

Related content

WEBINAR

Recorded Webinar: Entity identification and client lifecycle management – How financial institutions can drive $4 billion in cost savings

A new model in Legal Entity Identifier (LEI) issuance has created significant opportunities for financial institutions to capitalise on their KYC and AML due diligence. By becoming Validation Agents and obtaining LEIs on behalf of their clients, financial institutions can enhance their client onboarding experience, streamline their internal operations, and open the door to new,...

BLOG

J.P. Morgan Steps Forward as First Validation Agent in Global LEI System

J.P. Morgan has become the first validation agent in the Global LEI System, signalling early interest in the scheme as a means of improving client onboarding and Know Your Customer (KYC) . The validation agent framework was introduced by GLEIF in September 2020 and is designed to help financial institutions improve customer experience, accelerate client...

EVENT

Data Management Summit Virtual

The Data Management Summit Virtual will bring together the global data management community to share lessons learned, best practice guidance and latest innovations to emerge from the recent crisis. Join us online to hear from leading data practitioners and innovators from the UK, US and Europe who will share insights into how they are pushing the boundaries with data to deliver value with flexible but resilient data driven strategies.

GUIDE

MiFID II Handbook – Second Edition

With the compliance deadline for Markets in Financial Instruments Directive II (MiFID II) just over two months away, A-Team Group has updated its MiFID II handbook to bring you the latest details on the regulation’s compliance requirements. Version 2 of the handbook, commissioned by Thomson Reuters, also includes new sections covering data sourcing and data...