AI Engineer & Data Systems Builder

Tanay
Mehendale

HCLTech · MS-MIS @ Texas A&M · DJ & Producer
View Resume
The Person

Curious
Builder

EDM Formula 1 Sci-Fi Data Systems AI Pipelines
Tanay Mehendale

I build data and backend systems that power analytics and AI products — Python, SQL, AWS, streaming pipelines, LLM-based agents. I enjoy breaking systems, fixing them, and making them scale.

When I'm not building: EDM on the decks, F1 on the screen, sci-fi on the nightstand.

Selected Work

The
Work

01

ApartmentFinder AI

A Multi-Agent AI system that simplifies relocation moves — Google ADK, RAG pipelines, and MCP in one coherent product.

AI Agents RAG Pipeline MCP Google ADK
02

Real-Time Data Streaming

End-to-end real-time pipeline using Airflow, Kafka, and Spark — built for scale and reliability from source to sink.

Apache Spark Kafka Airflow Cassandra
03

Data Warehouse for Retail Analytics

Comprehensive data warehouse implementation using SQL Server — schema design, ETL pipelines, and a full reporting layer.

Data Warehousing SQL Server SSIS SSAS Tableau
04

ResQVision — Emergency Analytics

Interactive D3.js + React dashboard visualizing 15,000+ emergency incidents to surface response bottlenecks and resource gaps.

D3.js React.js Data Visualization Python
05

Investobuddy

Investment analysis tool combining value investing principles with LSTM + Monte Carlo — buy/sell signals via Flask + Angular.

LSTM PyTorch Flask Angular Monte Carlo
06

Customer Churn Analysis in Tableau

Tableau dashboard on 6,687 telecom customer records — churn driver analysis revealing a 26.86% churn rate.

Tableau Business Intelligence Data Analysis
07

Image Classification on FashionMNIST

Compared CNN, KNN, SVM, Logistic Regression, and Decision Trees on 70K fashion images — CNN hitting 91% accuracy.

PyTorch CNN scikit-learn Machine Learning
08

Interactive Heatmaps using D3.js

Two-level D3.js heatmap on Observable — Hong Kong temperature trends 1997–2017 with mini in-cell line charts.

D3.js Observable Data Visualization
09

Market Basket Analysis in R

Apriori algorithm on 15,000 grocery transactions in R — association rules driving store layout and promotion recommendations.

R Apriori arules Business Analytics
10

AWS Point-of-Sale (POS) System

MariaDB + MongoDB POS system on AWS EC2 — normalized schema, stored procedures, replication, and NoSQL migration.

AWS EC2 MariaDB MongoDB Database Design
11

Quote-to-Cash Analysis — Tableau Next & Salesforce

Revenue flow analytics dashboard built during the Salesforce Tableau Next Hackathon — Q2C pipeline reimagined.

Tableau Next Salesforce Business Analytics
Work History

The
Record

01

HCLTech

AI Engineer

Microsoft Agent Framework · AI Agents · LLMs

  • Developing AI Agents using Microsoft Agent Framework
02

Texas A&M University

Data Engineer Intern – Research

Python · ETL · AWS · Data Pipelines · Pandas · Medallion Architecture

  • Architected a Python based ETL pipeline to consolidate 3 data sources into a multi-layer data lake on Amazon S3, reducing data preparation time by 40% and aiding time series analysis
  • Developed scalable logic to ingest 2M+ unstructured raw text via Reddit API, implementing regex-based alias matching across 25+ subreddits to expand data coverage by 300%
  • Optimized performance by resolving API failures, resulting in 100% data capture reliability and a 34% increase in speed
  • Integrated LLM based sentiment analysis to derive 12 distinct themes, creating high-value categorical features to improve segmentation and trend modeling
03

Texas A&M University

Graduate Teaching Assistant

HCI · Systems Analysis & Design · ERP · SAP

  • ISTM 380 Human-Computer Interaction: User Experience, UI/UX, Design principles, Accessibility, Usability, Attention, Memory
  • ISTM 320 Systems Analysis & Design: Requirements Gathering, Data Modeling (ERDs, Data Flow Diagrams, UML)
  • SCMT 468 Enterprise Resource Planning: SAP, Sales & Distribution, Materials Management, Warehouse Management, Inventory Management
  • Mentored 245+ students across 4 courses through labs and office hours, clarifying requirements, debugging, and coaching presentations
04

LTIMindtree

Software Engineer

SQL · Python · ETL · AWS · S3 · Glue · ABAP · Data Modeling

  • Developed 45+ custom ERP transactions using ABAP with SQL, improving data retrieval speed by 95% for 400+ users
  • Supported SAP to AWS ETL migration by extracting ERP data, validating S3 and Glue outputs, improving Redshift load consistency across weekly cycles
  • Diagnosed and resolved 30+ technical support issues via root cause analysis, cutting average resolution time by 35%
  • Collaborated with global teams to optimize SDLC audits and change management practices, reducing SOX compliance issues by 84% across 52+ releases
Academic Background

The
Foundation

Mays Business School, Texas A&M University

Master of Science — Management Information Systems

GPA: 3.83  ·  Head of Marketing & Comms, BITS

Relevant Coursework

  • ISTM 622 – Advanced Data Management
  • ISTM 637 – Data Warehousing
  • ECEN 758 – Data Mining
  • CSCE 679 – Data Visualization
  • STAT 650 – Statistics & Foundations of Big Data

Sardar Patel Institute of Technology, University of Mumbai

Bachelor of Technology — Electronics & Telecommunications

  • Semi Finalist (Top 20 of 800+ teams) at IICDC-2019, national innovation hackathon by Texas Instruments & Dept. of Science & Technology, Govt. of India — affordable non-invasive flow meter
  • Winner — Case Study Presentation by Fire & Security Association of India (FSAI)
Technical Arsenal

The
Stack

Tools I've shipped real things with — weighted by how often I'd reach for them under pressure.

Core stack Regular use Contextual
01 Languages
Python·SQL·R·ABAP
02 Data Engineering
Apache Spark·Kafka·dbt·Airflow·SSIS·Fivetran
03 Cloud & Storage
AWS·S3·Git·Glue·Redshift·Docker
04 Databases
Snowflake·PostgreSQL·MongoDB·DynamoDB·Cassandra
05 AI & ML
LangChain·OpenAI API·scikit-learn·Pandas·RAG·PyTorch
06 Analytics & BI
Tableau·Power BI·Excel·Matplotlib
Get In Touch

Let's
Talk

I'm always up for a conversation about data systems, AI pipelines, or whatever problem you're trying to solve.

View Resume