• Boosted database efficiency by 30% and reduced query execution time from seconds to milliseconds by implementing Materialized Views and Redis caching for high-frequency endpoints.
• Integrated Algolia to search across the platform, achieving <100ms latency for large datasets and ensuring 100% data consistency between the primary DB and search indices. • Decoupled resource-intensive Excel generation to AWS Lambda, reducing primary server CPU load by 40% during peak traffic windows and eliminating server timeouts.
• Implemented real-time payment infrastructure using Socket.IO, ensuring real-time payment confirmations and automating invoice sync with Zoho Books for 1000+ monthly items.
