Mumbai, Maharashtra, India
Summary
Led full-stack development and optimization initiatives for core inventory systems, significantly enhancing performance and scalability for a leading platform.
Highlights
Actively managed the legacy inventory system and optimized SQL queries in React-Admin, Hasura, and PostgreSQL, improving overall performance by over 25%.
Developed the backend for a new inventory system using Nest.js, PostgreSQL, Redis, and Docker, ensuring a scalable and efficient data architecture.
Created an internal join feature leveraging Redis and PostgreSQL, reducing the load on Postgre DB and increasing API performance from 300-400 ms to 30-90 ms.
Implemented an advanced caching class by extending the existing Redis class for all GET APIs to eliminate redundancy, coupled with a global pagination class and universal search using TsVector and database triggers, maintaining API response times under 100-150 ms.