MAHAKRISHNAN SUBBIAH

Feed Hero

• Administered and supported SQL Server databases (2008–2016), including setup, configuration, and performance tuning for improved efficiency.
• Optimized SQL queries and stored procedures, reducing query run-time by up to 40% for key reporting modules.
• Handled backups, user role management, and health monitoring to ensure 99.9% system availability.
• Participated in database version upgrades and coordinated with application teams for seamless rollouts.
• Strengthened data security protocols and implemented disaster recovery procedures, reducing recovery time by 50%.

HeyTrisha (AI-based NLP Product)

Technologies: Python, SQLite, MSSQLMySQL, AWS Lambda, Laravel, React, TypeScript

• Developed a natural language processing (NLP) AI system to process user queries and generate SQL/MySQL queries dynamically.
• Version 1: API-only solution using Python and SQLite in AWS Lambda (serverless architecture).
• Version 2: Enhanced API with SQLite and Python; developed a TypeScript-based Chatbot UI.
• Version 3: Migrated to Laravel (backend) and MySQL, with a React-based WordPress plugin for improved functionality.

HeyTrisha (AI-powered WhatsApp Order Processing Bot)
Technologies: n8n, WhatsApp Cloud API, MySQL, Webhooks, Dialogflow, Laravel
Developed an AI chatbot solution integrated with WhatsApp to automate customer ordering and tracking processes.

• Enabled customers to place and track orders through natural chat interactions using WhatsApp.
• Built using n8n for workflow automation, integrating AI responses with database operations and webhooks.
• Real-time order processing, status updates, and customer support powered through WhatsApp Cloud API.
• Integrated with backend (Laravel) and MySQL for storing and managing order data.
• Designed to handle end-to-end customer interaction, including order confirmation, delivery tracking, and FAQs.