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 […]
Issue Our client lacked expertise with the Aligne application to quickly prepare needed reports while maintaining controls set by the company. Solution Our consultant captured requirements, documented specifications, then built, tested, and deployed a solution while maintaining SOX compliance. They learned the company’s change management process, prepared documentation, and tested the output as required by […]
Issue Our client’s user security model within the Aligne trading application was not adequately addressing the SOX controls now required by the business. Solution Our consultant used their knowledge of the application combined with the client’s requirements to produce detailed documentation and a test plan for the security configuration. This implementation enabled the client to […]
Issue Our client’s primary nightly batch process ran over two hours and occasionally did not finish due to the amount of data being processed. The client expected a solution to be implemented within a short time frame. Solution The consultant met with various functional groups to determine how the existing information was utilized and how […]
Issue This client’s primary invoicing report failed overnight several times per month. In addition, users could not perform basic invoicing operations in the invoice system GUI. Solution Our consultant had a thorough understanding of the client’s invoicing process and was able to modify the reports and application configurations to prevent failures. Result MidDel’s consultant devised […]
Issue Our client had hundreds of reports under an old data model which was not meeting its business requirements. Many reports were either duplicates or unnecessary and without extensive report documentation. Report users were busy and needed assistance to revise the reporting framework. Solution Our consultant combined technical expertise and knowledge of the data model […]
Issue Our client’s daily intra-month P&L report had significant variances when compared against the month end actual P&L results. These variances contributed to loss of confidence and trust between the corporate executives and the front and back office. Our objective was to reduce variation and re-establish confidence in the process, thus increasing executive trust in […]
Issue Our client was using a large Excel spreadsheet with multiple linked tabs to calculate value at risk (VaR). The client was not measuring VaR for any of its FTR positions. The volatility and correlation calculations were not properly weighted. In addition, the delta between the published price and the non-published price was not updated […]
