Risk Management Data Visualization For a Capital Investment Fund

SPsoft optimized the performance and data visualization of existing risk management and trading platform for a Singaporean capital investment fund.

Client

The customer is a capital investment fund based in Singapore that trades in listed stock, futures, options, commodities, and currencies. They concentrate on risk-free trading to ensure the maximum profitability of operations.

Location:

Singapore

Industry:

Capital Investment

Team size:

5 people

Project duration:

2019 - 2020

Services

Data analysis, Cloud architecture design and DevOps services, Python scripting, Quality Assurance

Tech stack:

  • Bonobo
  • Tableau
  • PostgreSQL

CHALLENGE

The main goal of the project was to redesign the risk management platform’s architecture to enable pricing engine operations in under 5 seconds and update the API integration. SPsoft had to implement data visualization with Tableau instead of an Excel-based custom module, migrate the historical data to new database schemas — and do it all in under 8 weeks.


Value Delivered

SPsoft provided a software and data engineering team that helped the customer’s in-house team redesign the architecture of their existing Excel-based pricing engine. This ensured a close to real-time completion of ETL operations, improving the platform performance, and providing better data visualization. As a result, the customer was able to utilize the platform in a more cost-effective way, thus enabling them to operate it on a much bigger scale.


The process

The project was split into two parts: firstly building a data management system, then working on Tableau integration to implement data visualization from scratch. The first step was the discovery phase, where the SPsoft team analyzed the existing data schema and .xls macros for data management. This resulted in designing a data lake for the performant and fast ETL process.

After two or three sessions with the client, the best database structure was defined, represented by Landing, Calculation and Data Marts sections. All data chunks were saved as separate PostgreSQL schemas to ensure data was isolated and there wasn’t any junk in the Data Marts.

The next step involved developing and implementing the Python scripts for ETL solutions and Pricing engine optimization. To achieve improved data visualization capabilities, Tableau was integrated into the Data Marts level to enable ad-hoc reporting and analytics.

The project took under 7 weeks to complete.

Success stories

Developing an Automated Risk Assessment, Redaction, and Anonymization (ARARA) Platform

Our client was looking for a Senior Full-Stack Java Engineer/Architect with experience of leading a development team. SPsoft has managed to provide the required specialist on short notice.

View Case

Traveling Safety and Convenience Ensurance Platform for a US-Based Automation, Analytics, AI, and Cloud Data Management Powerhouse

A unique traveling platform that notifies passengers on the traveling restrictions and conditions per country and then verifies the traveler's compliance with them.

View Case

An ERP System For the Cannabis-Based Products Distributors

Developing a multitenant supply chain management platform for medical cannabis-based products distributors, empowering efficient supply chain monitoring, purchase, processing, selling, and distribution. A fully adjustable and scalable solution that allows for customizable resources planning and usage of accounting systems.

View Case
View All Case Studies