Overview
A long-running investment management platform for a private equity team, covering deal pipelines, portfolio data, and reporting against evolving business rules.
Challenge
Complex domain logic that changes regularly, heavy reporting workloads against mixed MySQL and SQL Server data, and a need to keep the system fast and maintainable across multiple years and team changes.
My Role
Tech lead — full-stack architecture, performance, and long-term maintainability.
Solution
- Used FastAPI and Pyramid services with clear seams between transactional flows and reporting paths.
- Optimized critical reporting queries and data access patterns instead of patching slow paths in the application layer.
- Built React UIs around the actual decisions investment teams make, not generic table views over the database.
- Maintained a long-term architecture that absorbs new business rules without compounding tech debt.
Outcome
- Sustained acceptable performance on heavy reporting workloads as data volume grew.
- Kept the platform evolvable across multiple years and successive feature waves.
- Reduced the cost of onboarding new business rules into both transactional and reporting paths.