• —ETRM (Energy Trading & Risk Management) apps
• —WEB applications originally written in Java 6
• —Hosted on Tomcat server
• —Client subsidiaries have access via VPN connection
• —Main purpose:
  • —Managing everyday administrative tasks related to electricity trading
  • —Generation of the reports for internal and external parties
  • —Planning and analytics
• There is a mechanism for error reporting and generation of new tasks/requests – automatic creation of helpdesk tasks (Redmine)
• —Apart from the web application, there are numerous validations and automatic reporting mechanism (Jenkins and JMS)
• —Night jobs include:
  • —Mail sending validations
  • —Non-mail sending validations
  • —Auto reporting
• —Each member of the clients trading floor receives appropriate notifications on a daily basis (validations and predefined reports) via dedicated e-mail

• —Consumer is client’s department responsible for conclusion of energy contracts with electricity producers or consumers, and also with other energy trading companies
• —There are several options for creating contracts in :
  • —Trade interface – centralized input, user notifications and connection of all contract-related data in a single user action
  • —Import of the file originating from the broker’s OTC platform – slightly modified Trade interface
  • —Direct input by the members of the client’s Settlement department
• Consumer is also client’s department responsible for daily planning (scheduling) of each traded kilowatt of electricity and related transfers of the mentioned electricity via cross-border interconnectors (cross-border-capacity)
• —Our software generates formal reports also known as schedule reports (or just schedules) which have to be sent to some concrete Transmission Service Operator (or just TSO) before strictly defined deadline
• —Aids participatng in daily auctions related to cross-border capacities
• —Most of the needed reports can be generated within/from the software—
• As mentioned before, the software enables centralized input, user notifications and connection of all contract-related data in a single user action
• —Each contract initially has Ticket status and has to be processed by the members of Settlement department in order to be promoted into valid contract
• —All relevant values related to a single trade are available at one place: contract duration, trade type, location, company, partner, broker and related data, group membership, power model (product), power, energy price, and data related to cross-border capacities
• The software generates reports intended for internal use, but also generates reports intended for external parties
• —KISS and XML daily reports – sent on a daily basis to TSOs (in other words, Schedule reports)
• —TSO and TSO by capacity – both reports could also be sent to TSOs, but they can cover longer time period
• —Trading and Company – reports containing trade data
• —Detailed by day and Master, Group & Detailed (Energy and Capacity versions) – overview of contracts and groups in several different views, by quantities or financial values, filtering by multiple search criteria
• —Broker – overview of contracts (and appropriate costs) related to some concrete broker
• Important binary documents, related to some concrete contract, can be stored in the software
• —Documents related to some concrete partner (such as General Agreements, Confirmations letters and other important documents) can also be stored as binary documents
• —All documents are always available for preview, print or eventual modification(s)
• —Finally, search functionality (by several search criteria) is also available

The software enables:

• —Mechanism for analytical and financial reporting
• —Mechanism for efficient planning of future trades, and also for efficient evaluation of all past trades
• —Related contracts should belong to the same group
• —Energy and financial data of some concrete group is available at any time
• —Within a single group, contracts are grouped by type (Buy and Sell) and by related locations – each of the mentioned subgroups has appropriate energy and financial data

The software recognizes several cathegories:

• — Users – Defining users and user roles; there are several predefined roles
• —Partners – Companies, Trading partners, TSOs, Auction offices, Banks and Brokers
• —Locations – Utility points and Border points
• —Partners-Locations filtering – defining limits related to partners and locations (e.g. which trading partners are active in which locations)
• —Journal – overview of all logged actions, tracking changes/modifications related to contracts and other important entities
• —Report configuration