ETRM Price Conversion

Issue

A client had a program equipped to calculate complex price data conversions between schemas, but it had not been tested. A number of differences had been noted, but the full extent was not known. Our objective was to determine the scope of differences and provide an accurate solution.

Solution

Our consultant combined extensive understanding of risk knowledge and price data methodology to recognize the schema change and how the conversion application was expected to function. He used tools within the risk engine to produce testable data in the old and new systems, reconciled the results to identify differences, analyzed the differences to group them into error classes, and developed a conversion matrix.

Result

The new application was easy to see and resolve. The price conversion application was successfully corrected and fully tested and the project was completed much sooner than the client expected.

Request PDF