Enterprise Investment Management Platform
Wealth & Investment Management (PMS / AIF)
A multi-entity platform managing assets under management, distributor structures and investor reporting for institutional portfolios.
Multi-tenant
Business entities
Excel pipelines
Data import
RBAC + JWT
Access model
Dev / UAT / Prod
Environments
Overview
A comprehensive management-information system for portfolio and alternative investment funds. It centralises master data, AUM tracking, distributor rate structures and investor reporting behind a secure, role-driven web application used across multiple branches and business entities.
The business problem
Investment operations were spread across spreadsheets and disconnected tools, making it slow and error-prone to track assets under management, reconcile distributor commissions, and produce trustworthy investor and compliance reports.
The solution
I designed a modular Flask REST backend with a normalised PostgreSQL data model and an Angular Material front office. Bulk data flows through validated Excel pipelines, while a register engine tracks every transaction, rollover and rate change with a full audit trail.
My responsibilities
- Architected the data model for clients, schemes, branches and relationship managers
- Built the AUM tracking, distributor rate-matrix and PMS register modules end to end
- Implemented JWT auth with token black-listing and granular role-based access
- Engineered validated Excel import/export pipelines for bulk operational data
Challenges solved
- Modelling distributor rate validity windows without breaking historical reports
- Guaranteeing import integrity from imperfect, human-edited spreadsheets
- Keeping AUM and register views consistent under concurrent updates
Key features
Architecture highlights
- Flask REST API with Marshmallow serialization and Alembic schema migrations
- Normalised PostgreSQL model for multi-entity, multi-branch operations
- JWT authentication with token blacklist and page-level RBAC
- Background workers for notifications and long-running report jobs
- Containerised with Docker Compose behind an Nginx reverse proxy
Technologies used
Scalability
Stateless API containers scale horizontally behind Nginx; the relational model and environment-based configuration support dev, UAT and production tiers without code changes.
Performance
- Indexed query paths for register and AUM aggregations
- Batched Excel processing to avoid request timeouts
- Server-side pagination on data-dense grids
Security
- JWT with token black-listing on logout
- Role-based access control down to page and action level
- Schema-level validation of every imported record
- Audit logging of all master-data changes
Screenshots
Product screenshots available on request (NDA-protected).
Architecture diagram
Detailed system architecture available on request.
Related work
View allPerformance & Fee Reporting Engine
Investment Analytics & Fund Performance
A calculation and reporting engine that turns raw NAV and cash movements into auditable performance and fee statements.
Cost Allocation & MIS Reporting Platform
Financial Cost Allocation & Shared-Services MIS
A rule-driven engine that allocates shared costs across business units and produces drill-down MIS reports.
Asset Tracking & Management Platform
Asset & Rental Inventory Management
Real-time, up-to-the-second visibility and financial intelligence across a fleet of rental and organizational assets.