Fundstream
data. Insights. results.
Helping Financial Service Companies with Data Enablement
Cloud Data Warehouse
Fundstream Data Manager is a revolutionary platform allowing management of multiple cloud databases from a single application.
Data Engineering
Our expert team of data engineers create secure and cost effective integration pipelines that run on Azure or AWS.
Software Development
Our team of 15 software developers create bespoke solutions for asset management and finance companies, on time and on budget.
Consulting
We have more than 20 years experience within the asset management industry at both very large and smaller boutique companies.
About us
Our Experience
We have 20 years experience managing data within the asset management industry. We have worked with multiple -back and -middle office systems, reports and regulations and understand how to cut through the noise and create real value.
The team have a collective 60 years experience with:
- Trading and Accounting Systems
- Performance, Risk and Analytics
- Compliance and Regulatory Reporting
- Investor Reports, Fund Fact Sheets
- Data Warehousing and Data Management
- Power BI
Zelda Kloppers (Senior Business Analyst)
Education: Diploma in Business Analysis (FTI), Associate in Management Practice (UCT GSB).
Experience: 23 years’ in the financial services industry with 15 years’ experience as a Technical Business Analyst with knowledge of both retail and institutional sales and operations processes.
Work: Ninety One Asset Management
Brian Mynhardt (Senior Developer)
Education: Bachelor of Computer Science and Games Development (UCT), Udacity Data Engineer Nanodegree.
Experience: A mid-level software developer with 4 years of experience in full stack development on the Azure cloud platform. .
Work: Fundstream, Hobby Games Developer
KEY people
Tarquin Vaughan-Scott (Director/Architect)
Education: Bachelor Of Veterinary Science (Hons) (Masters), Diploma in Business Administration, Diploma in Computer Programming, Microsoft MCSD, Udacity Machine Learning Engineer Nanodegree, Several courses in data-warehouse theory.
Experience: 15 years’ experience in data-warehouse and data integration projects (at least 40 data warehouse projects), 4 years’ experience in Azure Cloud Solutions, Experience in multiple asset management systems such as compliance, performance, accounting and trading.
Work: Founder of Infovest, sold to Statpro UK in 2017. Work experience at several managers such as Investec, Old Mutual, Cadiz, Brait, PPS, Prescient, M&G, Bank of New York, CIBC, etc.
Emile Langeveldt (Business Development)
Education: Bachelor of Commerce Honours in Information Systems (UCT)
Experience: 16 years’ experience in the investment management industry, Experience with Business Analysis, Implementation, and Sales for globally recognized brands. Delivered projects in the United Kingdom, the United States, the Middle East and other parts of Africa
Work: State-Street, JTC, FIS Systems, Bloomberg, Morningstar, Infovest.
Charl Etsebeth (Business Analyst)
Education: BCom (Hons) Financial Analysis & Portfolio Management (UCT)
Experience: 10 years’ of experience in various roles within the asset management industry from client services, technical data analysis, supporting investment administration systems and developing data feeds and reports.
Work: JTC Fund Services, Allan Gray, Quintessence
10 more data engineers and software developers..
products
Fundstream Data Manager
Meet FDM, our cutting-edge data management platform for asset management and financial companies. FDM allows you to setup and manage multiple data warehouses in the cloud or on-premise from a single “pane of glass”. Pre-built templates allow the setup of a complex data warehouse that can handle any type of asset management data within hours.
FDM is based is based on 15 years experience in working with asset management data and saves months of development time
Azure Reference Architecture
Features
Financial Data Warehouse in a Box
- Creating an asset management data warehouse can be challenging as it involves many technical decisions.
- FDM contains a set of templates that can be used to create a data warehouse in the cloud or on-premise within a few hours.
- FDM ships with a best practice data model for asset managers, but can also be customised using a low code user interface.
Manage Multiple Cloud and On-Premise Databases
- FDM has the unique ability to manage multiple databases from a single platform.
- FDM can connect to databases within the Azure or AWS ecosystem or on-premise databases.
- This powerful feature allows a single view across the entire data landscape.
Master Data Management
- Asset managers struggle with managing the instrument and portfolio master as data is sourced from many providers.
- FDM allows linking instruments to create a master record, background jobs fix invalid data by pointing instruments to their master record.
- Portfolio codes can also be translated and matched during load or extract.
Monitor Data Pipelines
- Data pipelines can be monitored and re-run from a single dashboard.
- Pipelines can be developed with any ETL tool such as Synapse Data Factory, Amazon Glue and Apache Airflow and then integrated into the pipleline dashboard.
- Configure expectations and receive alerts if pipelines don’t load on time.
- Re-run failed pipelines after correcting errors or fixing source data.
Check Data Quality
- Both data completeness and data quality can be visualised on dashboards to show “whats in the data warehouse”.
- Check data quality before running reports to ensure data has been fully loaded.
- All background data jobs are configurable to run hourly, daily or weekly.
Integrated Reporting
- FDM has a fully integrated reporting system that can be used to manage commentary, images, attachments and colour schemes.
- Reports can be developed using various third party tools such as Devexpress or Telerik report designers (no SSRS is required).
- Reports run at scale using Azure elastic servers and can generate hundreds of reports in minutes.
- Generate print quality paginated reports such as PDFs, Excel or flat files.
CoNSuLTING
We’re committed to elevating your data initiatives to new levels of success.We consult on data & integration projects from inception all the way to testing and deployment. We ensure your data projects fly to new heights.
We can help with:
- Data Warehouse and System Integration.
- Custom Software Development.
- Power BI, Investor Reports, Fund Fact Sheets.
- Data Management and Best Practice.
- Setting up and managing instrument and portfolio masters and classifications.
projects
PPS Asset Management, Data Warehouse & Power BI
Created an Azure Synapse data warehouse to store and report on asset management data, handled 1.3 billion records, developed multiple power bi reports, forms the core of the enterprise data warehouse, feeds multiple data marts .
Synapse Analytics, Azure Data Factory, Python Notebooks, Papermill, Azure Function Apps,. Azure Logic Apps, Event Grid, Azure Blob Storage
Fundhouse Discretionary Fund Managers, DFM Platform
In process of re-developing the core platform allowing for rebalancing of model portfolios and allocation of funds.
Azure Static Web App, Angular, HTML, CSS, Azure Function Apps,. Azure Logic Apps, Azure Blob Storage, Azure SQL
Incompass, Forex Workflow Automation
Created a cloud based workflow solution to process client payments and forex trades. Saved 10 000 pages of paper per month. Enabled maker- checker auditing to meet compliance regulation.
Azure Static Web App, Angular, HTML, CSS, Azure Function Apps,. Azure Logic Apps, Azure Blob Storage, Azure SQL
M&G Asset Management UK, Value Assessment Platform
Created a cloud based value assessment platform that compares share classes across seven pillars to evaluate value offered compared to the market. This is a regulatory requirement in the UK and the first automated platform of its kind available in Europe.
Azure Static Web App, Angular, HTML, CSS, Azure Function Apps,. Azure Orchestrator Functions, Azure Blob Storage, Azure SQL
Riscura, Databricks Data Lake
Created a Databricks data lake with over 150 pipelines from market data and client portfolios. Enabled high performance analytics.
Databricks Delta Lake (Lakehouse), Data bricks workflows, Pyspark Jupyter Notebooks
RE Capital, Investor Reporting
Web platform that allows managing of investor data such as loans & transactions plus the geenration of high quality PDF report packs. Several hundred report packs generate in a few minutes using Azure elastic scale.
Azure Static Web App, Angular, HTML, CSS, Azure Function Apps,. Azure Orchestrator Functions, Azure Blob Storage, Azure SQL
Khumo Capital, Data Warehouse & SARB Reports
Datawarehouse to capture holdings and generate transactions using bespoke businerss logic, Generation of SARB reports in both PDF and Excel format.
Synapse Analytics, Azure Data Factory, Python Notebooks, Papermill, Azure Function Apps,. Azure Logic Apps, Event Grid, Azure Blob Storage
Prepaid Company, Airtime Voucher Validation
Validation of millions of airtime vouchers to check validity and data completeness.
Azure SQL Datawarehouse , Azure Function Apps,. Azure Logic Apps, Azure Blob Storage
research
Fundstream lowers the cost of data pipelines by 80% using Papermill and Python notebooks
Read about our innovative research where we were able to lower the cost of data pipelines using the same tool that Netflix uses for its data analytics. Papermill and Azure function apps have allowed us to create scalable data pipelines that run at a fraction of the cost of Spark clusters. We can run data pipelines or a few hundred rand a month ($30) instead of thousands.
Fundstream configures advanced security for Azure resource groups using Private Link Service and Private End Points
One of our clients required us to connect data pipelines to a Sql Server database hosted on an Azure VM with no public IP address. This complex requirement is not documented on the Microsoft website and required a serious research effort to get right. We are the first company to document the end to end process and make it publicly available. The same principles can be used to configure a secure network between other Azure components.
Contact us
Main Office
1st Floor Dean Street Arcade
Dean Street
Newlands
Cape Town
South AFrica
General
Schedule a Chat
+27 82 824 2474
Sales
+27 83 426 9260
