MTM, Value at Risk (VaR), and Invoice Reports Validation

Issue

For system changes, the client needed to agree or reconcile key reports (mark-to-market, VaR and invoicing) before and after the change. Visual comparison of each report’s outputs took too long and wasn’t always reliable.

Solution

MidDel’s consultant automated the process so that the underlying report output tables were compared directly in the database.

Result

By automating the process, time required to compare results was greatly reduced and compliance with SOX requirements was ensured.