HOC implements RPM to automate the Budget Forecast Variance reporting process for an asset management firm’s entire portfolio using RPM. Business is now able to easily see their future P&L’s against different version of forecasts and take strategical decisions. Automation using RPM replaced a once time consuming, error prone manual process.
RPM was implemented at an energy firm in the North East with the aim of utilizing a number of direct data feeds along with select key data inputs from the risk reporting team and create a consolidated, centralized budget/transfer and actuals performance reporting solution. This solution involves enhancing and automating the process of operations performance presentations and the associated P&L models for risk. This once was a manual intensive process involving many different data sources and multiple layers of mapping. The solution enhanced and automated the gathering of data, manipulation of data, presentation of data as well as allowing for manual text entries/notes where needed.
HOC automates Business Variance Reporting for an asset management firm’s entire portfolio using RPM. Prior to automation, the firm’s BVR reporting was outsources to a third party which was costly and error prone. Automation using RPM allowed all reporting to be done in house and eliminated most of the manual intervention needed to collect data and produce reports. RPM’s flexibility allows for the easy addition of portfolios when acquisitions are made in the future.
HOC automates monthly and quarterly Compliance Reporting Packages for major energy firm using RPM. Process included the collection of data from trading systems, data warehouses and excel files maintained by compliance analysts. Data is automatically collected, calculations are made, and presentations are created in PowerPoint format which are presented to management for monthly and quarterly compliance meetings. Automation using RPM replaced a very time consuming, error prone, manual process. This was the first implementation of RPM where the output was in PowerPoint format.
STORM (Streamlined Trade Order Management) App implemented at major energy firm in the North East for trade surveillance. The purpose of this project was to design, develop and implement a new trade surveillance solution on the RPM platform. This allowed the client to view all trades executed by their company as well as all other trades executed in the marketplace in a graphical format. Alerts were created based on client specifications that monitored suspicious/concerning trading activity. RPM automatically notifies compliance analysts of any raised alerts via email notifications. The solution was built as an “App” within RPM utilizing several of its key features and modules such as Data Interface Manager, data mapping, real-time dashboard, batch processing, business layers and alerts.
ARO (Asset Retirement Obligation) added to RPM's APP library. Developed for a generation and energy services company in the U.S., the ARO app calculates the new ARO liability and change in liability from the previous layer for each selected unit (Nuclear, Fossil, Solar, etc.). The app also allows users to calculate the monthly depreciation expense, monthly accretion expense and adjusted ARO as well as giving the ability to automatically upload the Journal Entries associated with them to the company’s accounting system.
HOC implements a near real-time Exchange Limits Monitoring (ELM) solution for an Energy Giant. ELM monitors up-to-date open positions for exchange traded products during market hours. The app. shows open positions in both tabular and graphical formats. Approved exemptions are maintained within RPM and are automatically applied to each product to help identifying false positive breaches. Email notifications are sent at the beginning of day and during the day when a threshold breach or violation is encountered.
Automation of the PJM & NEPOOL bill compiler process for an integrated generation and energy services company in the U.S. RPM was able to automate the Journal Entries for all billing posted by PJM NEPOOL on a monthly basis as well as create the final Journal Entry to be uploaded to company's accounting system. Automation using RPM replaced a once manual, time consuming process.
Broker Tool is added to RPM's APP library. After previous success automating the broker reconciliation process in RPM, HOC now offers the Broker Tool as an app built on top of the RPM platform. The Broker Tool provides a comprehensive toolkit to calculate initial and maintenance margin using the SPAN margin methodology. The availability of Broker Tool as an "app" provides a pre-built, user friendly front end access to the SPAN margin system provided by CME and ICE.
HOC automates the broker reconciliation process for a leading power company in the U.S. using RPM. This comprehensive process built around the CME and ICE SPAN engines allows for calculation of daily initial and maintenance margins for all broker accounts prior to receiving broker statements. Automation of this process has ensured that margins are sent out each day after verifying the numbers independently of the broker statements.
FTR vs Virtual Bids Loss Leading report created and generated out of RPM for U.S. Power Company. The report provides a daily and weekly snapshot of the company's Financial Transmission Rights positions overlaid upon the Virtual Bids held on the portfolio for the same nodes and flow date/time. The purpose of this report is to catch potential market price manipulation by traders by losing money on the virtual bids to increase the value of the FTR position. No such report was previously available at the power company and it proved to be immensely useful and powerful with no manual effort needed.
HOC develops a real-time Exchange Limits Monitoring solution for a major energy trading firm in the North East
HOC opens its new office at Metropark, New Jersey
HOC automates the process of calculating and generating the reports required under FAS 157 (Fair Value Level Disclosure) for a U.S. utility company. This quarterly report defines fair value as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date. Replacing an entirely manual, labor intensive process ensured that time once used for preparation of reports are now used for analysis. Automation using RPM also allowed for enough time to run this report multiple times if needed to account for changes in data or mapping.
HOC automates the process of creating quarterly reports required under FAS 161 (Balance Sheet, Income Statement - MTM and Notional) using RPM. Report discloses derivatives designated and qualifying as hedging instruments, separately discloses derivatives designated as cash flow hedges from those designated as fair value hedges, and derivatives not designated as hedging instruments (MTM). The utility company benefitted from a huge savings in time due to elimination of manual effort as well as greatly reducing the possibility of manual errors.