Debopam Roy

Developed threaded commenting feature with user tagging, RBAC, and nested replies. Integrated email notifications with deep-linking to enable direct navigation to specific comments. Implemented in-memory caching layer in GO-ETL with four-bucket hash map partitioning for entity and category mappings. Reduced DB queries from O(N) to O(1) per entity, concurrent-safe read access. Built Vendor Dashboard API endpoints with summary data aggregation and CSV export functionality.

Architected enterprise placement platform with RBAC, RLS and using NestJS and Supabase Edge Functions for AI resume analysis and eligibility validation with ReactJS frontend, serving 17,000+ students with <300ms query performance. Engineered CI/CD pipeline with GitHub Actions orchestrating multi-tier deployments. Built end-to-end CRM with Gmail Pub/Sub integration, rate limiting, and Recall.ai for real-time call recording. Implemented OAuth 2.0 (LinkedIn PKCE, Google SSO) with PostHog analytics, Sentry error tracking, Incident.io monitoring, and Thena.ai support automation for comprehensive observability.

Developed live portfolio hedging system using asset Greeks and Beta trends with Python algorithms, achieving 80% reduction in risk exposure. Designed master-slave database architecture reducing transaction locking and improving data retrieval. Integrated Redis caching with LRU eviction policy and automated cache management scripts, reducing page render time by 50% in ISH application.