Tanay Mehendale

View Resume

About Me

Tanay Mehendale

Hi, I’m Tanay! I build data and backend systems that power analytics and AI products. I work with Python, SQL, AWS, streaming pipelines, and LLM based agents. I enjoy breaking systems, fixing them, and making them scale. When I am not building, you will find me listening to EDM, following F1 or reading sci-fi novels!

Follow me on:

Projects

ApartmentFinder AI

A Multi-Agent AI System that simplifies relocation moves.

#AI Agents #RAG Pipeline #MCP #Google ADK

Real Time Data Streaming

End-to-end real-time data pipeline using Airflow, Kafka and Spark

#Data Engineering #Spark #Airflow #Cassandra

Data Warehouse for Retail Analytics

Comprehensive data warehouse implementation using SQL Server.

#Data Warehousing #SQL Server

Experience

August 2025 – Present

Texas A&M University

Data Engineer Intern - Research

    Skills: Python, ETL, AWS, Data Pipelines, Data Modeling, 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
April 2024 – May 2025

Texas A&M University

Graduate Teaching Assistant

    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 (ERP): 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, improving submission quality and reducing repeated rework
January 2021 – June 2023

LTIMindtree

Software Engineer

    Skills: SQL, Python, ETL, AWS, S3, Glue, Data Modeling, Root Cause Analysis

  • 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

Education

Mays Business School (Texas A&M University)

Aug 2023 - May 2025

Master of Science - Management Information Systems

GPA: 3.83

Head of Marketing & Communications at Business Information Technology Students (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)

Aug 2017 - May 2021

Bachelor of Technology - Electronics and Telecommunications

Achievements:

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

Skills

Python
Python
SQL
SQL
R
R
Git
Git
AWS
AWS
Apache Spark
Apache Spark
Cassandra
Cassandra
MongoDB
MongoDB
SSIS
SSIS
Tableau
Tableau
Excel
Excel
Power BI
Power BI
Python
Python
SQL
SQL
R
R
Git
Git
AWS
AWS
Apache Spark
Apache Spark
Cassandra
Cassandra
MongoDB
MongoDB
SSIS
SSIS
Tableau
Tableau
Excel
Excel
Power BI
Power BI

Get in Touch

or send me a Connect request on LinkedIn:

Connect on LinkedIn
View Resume