Hello, I'm
Pavitra Mandal
Currently leading two major AI initiatives at Sony — an enterprise AI Sales Data Agent (conversational analytics on Snowflake) and an AI Demand Forecasting platform in production ops across 280+ product lines. I architect end-to-end data & AI systems from ingestion and RAG pipelines to LLM observability and MLOps.
Active at Sony
Two major AI initiatives I am currently leading in production and development.
Featured Projects
A selection of projects that showcase my expertise in AI engineering, data pipelines, and MLOps
Mind Map Web App
Interactive mind mapping tool for visual thinking and brainstorming. Built with a Python FastAPI backend and a D3.js-powered frontend.
Open Source Time Series Forecasting System
Production-grade MLOps pipeline using Apache Airflow for demand forecasting with Prophet, SARIMA, and DeepAR models. Built for retail SaaS applications.
RAG API Support AI Chatbot
Conversational AI chatbot that answers API documentation queries using RAG-based semantic search. Runs locally on Ollama with Django, PostgreSQL + pgvector, and Docker.
AI Demand Forecasting Development at Sony
Developed & deployed an AI-driven demand forecasting platform at Sony. System is now in production — currently leading performance optimization and operational delivery across 280+ product lines globally.
Sales Data Agent - Enterprise AI with Snowflake Intelligence
Currently leading development of an enterprise conversational AI agent that enables business users to query Snowflake sales data in plain English — no SQL required. Built on Snowflake Cortex Intelligence with RAG, Text-to-SQL, and AI Observability.
Cisco MyID Group Data Migration Project
Enterprise-scale data migration project transferring group management data from legacy Cisco Groups (MS SQL Server) to modern MyID Groups (PostgreSQL), involving complex hierarchical relationships, validation mechanisms, and rollback capabilities.