Issue Our client, a mid-sized retail power and gas company, requested that we review their existing internal systems to determine the viability of solutions and if there was cost justification to continue development. The annual development and support budget of their legacy systems was in excess of $1mm per year. Additionally, the client was unable […]
Issue A client had pricing data stored among multiple databases, ETRM systems and spreadsheets. There were too many sources of pricing data to support, which created issues in the daily P&L due to overwriting price data across systems. Solution Our consultants combined extensive trading and risk management experience to create an RFP and guide the […]
Issue Our client replaced two internally developed trade entry systems that were used by wholesale power and natural gas traders. The applications were the primary deal entry systems that were integrated with SunGard’s Aligne ETRM system. The client chose to use Allegro’s ETRM system as their replacement deal entry system with an interface into Aligne […]
Issue Our client was seeking an upgrade of its ETRM system which managed deal capture, gas and power scheduling, position and risk reporting, counterparty invoicing, and accounting. The primary objective of the upgrade project was to move to the vendor’s latest technology platform. This upgrade would also provide the foundation for several critical projects in […]
Issue Our client was considering the deployment of a portfolio risk analytics system throughout its global organization, but first wanted to prove the software’s applicability to the client’s unique set of challenges. The software needed to do the following: organize and store information obtained from multiple sources and in various formats; calculate and report exposures […]
Issue Our client’s method of reporting planned and projected power generation data consisted of five spreadsheets with VBA code to extract data from various sources. Reporting was run on a daily basis and required a user to open each spreadsheet, enter data and run the report. A separate process sent the files to an FTP […]
Issue A mid-size Northeast retail power and gas company had the opportunity, as part of their organizational strategic portfolio growth plan, to bid on two books of business that were up for auction. Books included power and gas, residential and commercial contracts, and fixed and variable price volumes. The client wanted to determine whether they […]
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 […]
Issue A client’s Risk and Trading groups were in disagreement about the valuation of certain option instruments. Proper valuation was needed for mark-to-market disclosure. Our objective was to determine the source of the discrepancy and gain agreement between Risk and Trading. Solution Our consultant combined his knowledge of the mathematical models supporting option valuation and […]
Issue 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 […]
