Waystone Fund Management

HST Enables Data-Driven Decision Making
with PPM for Waystone Fund Management

Standardizing Waystone Risk Analytical Data with ETL

The PPM (Pre-Processing Module) is a Data Retrieval & Data ETL (Extract, Transform, Load) platform.

The main goal of the platform is to retrieve files from different SDPs (data providers), transform those files in flight as per the business requirement, and then push the data from those files downstream to Risk and Reporting applications.

Users of the PPM ETL tool can free up to 40% of their time previously spent managing data.

Core Frontend Technologies

.Net Core

React Js

Azure Data factory

Microservices

Azure MS SQL

CSS

jQuery

JavaScript

Their Success

About Waystone

Waystone leads the way in specialist services for the asset management industry.
Partnering with institutional investors, investment funds, and asset managers, Waystone builds, supports, and protects investment structures and strategies worldwide. With over 20 yearsof experience and a comprehensive range of specialist services to its name, Waystone is serving assets under management in excess of $2Tn.

Waystone provides its clients with the guidance and tools to allow them to focus on managing their investment goals with confidence.

The Challenge

Replacing an aging infrastructure

The Riskand Reg Reporting team at Waystoneprovidesrisk analytical content that democratizesfund admin data and helpsclients make better decisions about how to build, support, and protect investment structures and strategies. However, the users were outgrowing the existing BAU process. They had been relying on manually downloading files from multiple sources, normalizing them, and loading them into the downstream reporting portals. As Waystone has grown, that process no longer met its capacity needs and was an operational risk. Because the business unit lacked a well-modelled, centralized data repository, each team had to create and maintain its own reporting processes, resulting in fragmented and limited reporting. With all these issues, the entire infrastructure was becoming too costly and resource-intensive to support. Waystone needed a solution that could meet its increasing data management and reporting needs, allowing it to scale and adapt as needed.

Solution

A cloud solution that checks all the boxes
PPM is a scalable solution that was created for the enterprise.
It provides a modular and intuitive graphical user interface tool for ETL processes, which eliminates hand-coding (versus Python and Airflow)
Built with React JS, PPM is a modern API-first, cloud-native, and serverless Front-end application hosted in AWS Cloud Native S3 & container service.
We provide pre-built connectors that integrate with Waystone’s primary data source systems, including RDS, SFTP, Miscrosoft Exchange, G-Suite, and S3.
A scheduler running every 15 mins processing 1000 jobs at a time using Docker for containerization and RABBITMQ to centralize the queues ensures PPM is an extremely scalable solution. Scheduler instances can be added with ease as the number of processed jobs increases.

Each job can be configured and customized per the business requirements. Files can be cleansed based on custom rules eg. Delete all sheets exceptthe sheet named Statement of Net Assets, add date formatted column based on the report date, update values in a column, delete all rows containing Controlled Cash in column A, and many such rules. PPM can also perform advanced manipulations like grouping and consolidating lines based on an identifier or even a date.

The tool allows fields inside admin files like Effective Date, Base Currency, Local Currency, Market Values, Prices, and Costs to be transformed and mapped to the specifications of the relative downstream reporting applications and directly loaded in them using APIs. It can also save down transformed files to various locations to ensure Risk Managers can access them in a centralized location.

PPM ETL allowed the team to automate its data transformation, which reduces the amount of technical support required and allows the Waystone Risk and Reg Reporting team to focus on its core competencies.

The Benefits

Greater scalability and resilience

With PPM, Waystonecan find and use data more easily, and access more detailed data than it could in the past. The solution allows users to transform raw data into formats that are optimized for loading and analysis. Because PPM ETL is easy to use, the Risk and Reg Reporting teams can deploy modeled data sets for reporting and analysis faster. This speed of deployment enables teams to spot data anomalies, improve data quality, and create more insightful reports more quickly. PPM ETL has also delivered operational improvements via accelerated data extraction processes, along with automated logging.
With a cost-effective, scalable, and resilient ETL in place, Waystone now has the capacity to meet its increasing data needs.

Simplicity

Speed

Scale

Savings

TESTIMONIALS

HST Solutions is
Truly Committed
To The Clients We Serve.

Book a free call to discuss your ideas with us!
FLEXIBLE ENGAGEMENT MODELS

Find The Perfect Solutions For Your Project

Managed Team

Your product, our dedicated team. From concept to conception, we handle it all.

Staff Augmentation

Need extra hands? Our experts seamlessly join your team, providing the skills you need, when you need them.

Fixed Cost

Upfront price, guaranteed delivery. Your project completed on time and within budget.

    EXPLORE MORE WAYS WE CAN HELP

    Need a Different Approach?

    Compare All Engagement Models

    What is 5 x 5?

    What Makes Us Stand Apart

    We Have Deep
    Technical & Industry Experience

    One Team, One Dream

    At HST, there is no such thing as not my problem.

    Build Trust with Every Interaction

    We’re accountable to our clients and to each other. which means being open even when things aren’t going smoothly.

    Improve Everything

    The world of software and business moves fast so we re always learning and honing our skills.

    Own It

    We are a team of doers and we take responsibility for the success of everything we do.

    Obsessed: Over Results

    We’re obsessed with driving business value for our clients and we know that starts with gaining a deep understanding of the problems they’re facing

    Proven Excellence

    Our word is our bond. With 250+ projects delivered on time and within budget, we’ve built a reputation for keeping every promise.

    Partners in Precision

    Financial services, insurance, healthcare, retail, media. Trust built where excellence is the only option.

    Who Are We ?

    Creativity, Efficiency, & Advanced AI

    Strategy

    We've got all the big ideas and creative talent of an ad agency or creative studio except we deliver working products, not expensive presentations.

    Engineering

    We develop lean, stable code using all the best practices of any leading dev shop, except we focus on the user experience so people actually like using what we build.

    Design

    We validate, design, and prototype proof-of-concepts like any "creative technology" studio, but we do it in less time and for less money.

    Co-paired AI

    Co-paired AI development ensures twice the efficiency at a lower cost. We prioritize your software for innovative, precise, scalable, and quality-assured applications.

    Strategy

    We've got all the big ideas and creative talent of an ad agency or creative studio except we deliver working products, not expensive presentations.

    Engineering

    We develop lean, stable code using all the best practices of any leading dev shop, except we focus on the user experience so people actually like using what we build.

    Design

    We validate, design, and prototype proof-of-concepts like any "creative technology" studio, but we do it in less time and for less money.

    Co-paired AI

    Co-paired AI development ensures twice the efficiency at a lower cost. We prioritize your software for innovative, precise, scalable, and quality-assured applications.

    Contact Us

    Tell us about your custom software project

    Let our team, be your team

    Get a technical conversation about your project not a slide deck. Whether you need AI integration, a software engineering team, or a data platform, we’ll tell you honestly if we’re the right fit.

    Years in Business
    18 +
    Flawless Ratings
    5 .0
    Successful Projects
    250 +

    Please fill in the form below and we will be in touch.