Category Archives: Mid office
DEVSTORY #11 : Counterparty Knowledge Graph (CKG) for up to date information on your trading counterparties
Before you know it counterparty information and other reference data is out of date. As the data ages, a larger proportion of the data gets out of date. The CKG is a collaborative robotic process to keep all ETRM systems in sync using a single Knowledge graph updated by each counterparty in a trading network. Robotic process automation then keeps all ETRMs in sync using event driven automation
DEVSTORY #12: Using function as a service (faas) to retrieve data from a knowledge graph
A trading firm stores its reference information in the Counterparty Knowledge Graph (CKG). Settlement contacts are one category of information of interest and queryable from the Counterparty Knowledge Graph (CKG). To expose the list of contacts related to the settlements role, for a particular commodity at the trading firm, there is a need to provide an endpoint that is manually or programmatically queryable.
DEVSTORY #8: Greenfield natural gas portfolio mid-office profit & loss platform for startup natural gas trading desk
mid office required a system to capture trades, capture trader marks and report daily p&l to match trader estimates. An operational, reliable, cheap system was required for this USD 30 million dollar startup portfolio. The long term plan was to migrate to a traditional ETRM system as the portfolio grew to USD 120 million. Since the startup decided to move quickly, the time and cost of evaluating and implementing a traditional ETRM would set then back several months if not a year at best.
A quick comprehensive and complete solution implemented in 2 months was delivered that met needs of desk.
DEVSTORY #14: Quantitative analysts rollout derivative pricing models globally to desktop pricers, ETRM, Accounting, and Risk systems in minutes not months
A low code, highly available, planet-scale, containerized, Kubernetes deployed, functions as a service approach, that allowed the quant and IT teams to roll out models using a Jenkins-based CI/CD process several times a day. Models were deployed as stateless functions called using simple HTTP get requests accessible from software clients such as spreadsheets, javascript, python, Java, C++, C#, and Golang programs. Several research quant groups could leverage these models from tools like R, SAS, and Matlab.
DEVSTORY #11 : Counterparty Knowledge Graph (CKG)
Schedulers, Settlement analysts, and AR/AP professionals at a commodity trading operation need up-to-date operational reference data related to counterparties and service providers. Most systems of record used today by personas in these operational roles are out of date as soon as they are deployed as data changes quickly and the systems are reliant on people to keep them up to date.
Keeping reference data up to date across multiple firms calls for a central repository of this information. The information is updated once by the responsible party. Notifications of change can be sent to other business entities that can elect to update their systems of record manually or programmatically on some or all notifications.
DEVSTORY #1 : Ingest Nymex settles using open source tools
A startup natural gas trading desk within a large midstream energy company, needed a simple repository to warehouse Nymex settlement prices among other data sets for a large number of traded products that rivaled capabilities of the investment bank that the principals were accustomed to. This Dev Story provides a quick 2 minute read on how this need was addressed using open source software.