Soumitra Rai

Software Developer with hands-on production experience building high-throughput REST APIs, ETL data pipelines, distributed integrations, and GenAI workflows. Skilled in Python (FastAPI, Flask), Node.js, React, PostgreSQL, MongoDB, Redis, and AWS. Demonstrated expertise in query optimization, database schema design, third-party CRM automation, and local RAG architectures. Successfully shipped features serving 100+ enterprise retail clients. GATE 2025 qualified B.Tech CS graduate (2026 batch).

Software Developer at Avishkar AI (2026-07 – Present)

• Engineered AdVital AI engine using Gemini API to process multi-format voice call audio into structured JSON payloads (duration, key intent, reason).
• Built resilient pipelines routing AI outputs to Google Cloud storage and real-time operational dashboards for healthcare clinic management.
• Integrated Gemini-driven voice agents with GoHighLevel (GHL) webhooks and APIs to automate live patient scheduling, CRM triggers, and workflow updates.
• Synchronized state across asynchronous CRM workflows, AI processing queues, cloud storage, and client dashboard interfaces.

Full Stack Engineering Intern at AdeptMind.ai (2025-08 – 2026-06)

• Developed production REST microservices in Node.js/Python and UI modules in React for SaaS serving 100+ enterprise brands (Ulta Beauty, Reebok, Decathlon).
• Automated multi-region ETL pipelines connecting AWS S3 bucket identifiers stored in PostgreSQL to automate mall catalog ingestion.
• Refactored redirect API from sequential O(P × C) lookup to batch O(P ) query using MongoDB $in operator, slashing latencies by 28%.
• Implemented OAuth2 authentication, JSON-LD schema generation, data validation, and GitHub Actions CI/CD automation.
• Resolved 37+ PRs and 45+ Jira tickets by debugging production Error 500s across backend services and database layers.

Trainee at DGRE, DRDO (Govt. of India) (2025-05 – 2025-07)

• Built a data pipeline processing 80,000+ meteorological records via Pandas and Random Forest models for real-time risk classification.

Database & Backend Intern at SMVDU (2025-04 – 2025-06)

• Designed normalized PostgreSQL schemas, optimized indexed SQL joins, and enforced data integrity for 3,000+ records.

SOC Analyst Intern at ISEA, MeitY (Govt. of India) (2025-03 – 2025-04)

• Analyzed network logs using statistical anomaly detection for government operational intelligence reporting.

B.Tech in Computer Science – Shri Mata Vaishno Devi University (2022 – 2026)