VP Bank supports a sustainable approach which takes environmental, social and governance (ESG) factors into account when investment decisions are made. For this, strict sustainability guidelines and values are applied via the ESG Rating Tool when evaluating ESG data.
Up until now, VP Bank primarily used manual workflows and Excel sheets to calculate the ESG score, which was very time-consuming and prone to error. To speed up and modernize their processes, VP Bank commissioned Adnovum to develop an automated, user-friendly, and error-free cloud solution.
- The goal: A modern and easy-to-use cloud tool for the automation of manual workflows and Excel sheet calculations used weekly for VP Bank’s rating of ESG data to support the bank’s investment and go-to-market strategies.
- The process: The Adnovum team, in close collaboration with VP Bank, designed, developed, and implemented an Azure-based cloud solution in an agile manner.
- The result: A fully integrated and web-based cloud solution that allows the importation and amendment of ESG data from an external data provider (in this case MSCI) as well as the calculation of ESG scores in accordance with the bank’s values and directives. After conversion, ESG scores can be exported directly to the bank’s system and shown to clients in their portfolios.
Technologies used:
- Java
- Spring Boot
- Spring Integration
- TypeScript
- Angular
- Docker
- Kubernetes
- Solution design and tool operation based on Azure services (Azure Kubernetes Service, Azure File Share, Azure Cosmos DB, Azure Active Directory)
- OAuth 2.0
- OpenID Connect