Pramod C

About

Backend engineer focused on building production-ready Python services (Flask/FastAPI) with strong performance and scalability instincts—Celery/Redis background processing, robust multi-tenant isolation (Postgres RLS), and pragmatic CI/Docker operations. Demonstrated measurable DB optimization impact (cut a critical analytics query from ~1–2s to ~100–150ms) and has hands-on experience integrating LLM/ML workflows (OpenAI, LangChain, embeddings, Redis/FAISS vector stores) without degrading API responsiveness.

Key Strengths

• Productionized a Flask prototype into a scalable service with clean separation of concerns (service layer)
• Designed responsive APIs by offloading heavy work to Celery workers with Redis broker
• Queue stability under load: rate limiting, concurrency tuning, retries with backoff, and idempotency controls
• Database performance tuning with evidence-driven indexing and EXPLAIN ANALYZE (reduced query from ~1–2s to ~100–150ms)
• Avoids ORM performance pitfalls (N+1) using selectinload/joinedload and uses Core/raw SQL when needed
• Practical AI/LLM backend integration (OpenAI, LangChain, embeddings, vector stores) with modular architecture and predictable latency
• Multi-tenant data isolation using tenant context, PostgreSQL RLS, schema/DB separation when needed, and tenant-scoped caching

Experience

Education

Skills

Languages