The Client wanted to enhance legacy P&L generation platform that was plagued with multiple issues:
- Onboarding of high-volume Algo-trading customers: High-volume transactions were processed through traditional RDBMS based DB system impacting onboarding.
- Scalability: Existing architecture relied on a legacy database for all data extraction use cases. Application scaling was a challenge, and this put the database under heavy stress while processing the transactions.
- Real-time reporting: Lack of a robust reporting solution limited the visibility into various processing parameters.
- Outdated systems: Rapid fetching and loading of prices for all products was done on the legacy platform. This was becoming a challenge and laborious.