Project work in the design and development of a frontend for entering the data required to generate new power deals by means of a contract optimization model. The first version of the frontend is in Excel, subsequently the functionality is separated into a backend application built on ASP .net WebAPI with .NET Core and a thin client (Excel or a new web application). Data is exchanged using JSON with REST APIs and saved as a document in a CosmosDb instance. The backend passes the data to the central optimzation model. The whole environment is hosted on Azure. The project is organized using Scrum, whereby the Business users define the user stories to implement.
Supplement
One of the main requirements of the ASP .net backend is to retrieve the market data from the internal source system. Market data could be price or volatility forecasts, also interest or foreign exchange rates. In all cases the data format is similar, being returned as timeseries. The users are able to modify the market data in the frontend before passing it to the model. Through this iterative process, contract data can be optimized for different market scenarios, thus supporting negotiations with business partners.
Subject description
The frontend is used to enter the parameters required for the model calculation on the backend. The user can pull an existing deal from the trading system; the calcualtion also requires the market data. The model calculated an optimized result which is reviewed and stored in the energy trading system.