The client operated its business in two different time zones and experienced difficulty integrating the data to maintain the accuracy of the daily P&L, value at risk (VaR), and invoicing reports. In attempting to standardize the trading position, the client entered the transactions as one time zone. This created a problem when the trades were settled due to the hourly prices being incorrectly converted.
Our consultants combined their extensive business knowledge and technical competency to comprehend the relationship and impact between pricing data associated with hourly prices and its effect on P&L, VaR and invoicing reports. They used PL/SQL to prepare stored procedures and functions to make the required time zone changes. Once completed, the processes and functions were tested thoroughly.
The client was able to implement a timely interface while maintaining the accuracy of the daily P&L, VaR, and invoicing reports.