Hello, I'm

Mohan Vamsi
Pachappagari

I'm a |

Senior Data Engineer with 6+ years of experience crafting scalable data pipelines and architecting big data solutions that drive business insights.
Exploring AI Agents and building intelligent automation for personal projects.

Get in Touch View Experience
Mohan Vamsi Pachappagari
Scroll Down
Who I Am

About Me

I'm a passionate Senior Data & AI Engineer with over 6 years of experience in designing robust data pipelines. I am now actively bridging the gap between data engineering and Generative AI, building intelligent agents that solve real-world problems.

My expertise spans across big data technologies including Hadoop, Spark, and Hive, with deep proficiency in cloud platforms like AWS and GCP. I specialize in building scalable data solutions that transform raw data into actionable business insights.

I'm well-versed in programming languages such as Python and SQL, with a strong foundation in data warehousing concepts and ETL processes. My experience includes working with modern tools like Snowflake, Airflow, and Databricks.

A collaborative team player, I've worked closely with data scientists, analysts, and stakeholders to deliver high-quality data solutions on time. I'm constantly learning new technologies to improve pipeline performance and reliability.

6+ Years Experience
50+ Data Pipelines
6 Certifications
4 Awards

Data Pipelines

Expert in building ETL/ELT pipelines that process millions of records daily

Cloud Solutions

Proficient in AWS, GCP with hands-on experience in cloud-native data services

Big Data

Skilled in Spark, PySpark, and distributed computing frameworks

AI & ML

Experience with GenAI, LLMs, RAG, and machine learning pipelines

My Journey

Work Experience

IT Analyst

Tata Consultancy Services

Sep 2024 - Present Bengaluru, Karnataka
  • Architecting and optimizing large-scale data platforms using Apache Spark and AWS for high-volume data processing
  • Leading the modernization of legacy ETL workflows to scalable, cloud-native architectures to improve reliability and maintainability
  • Leading technical strategies for data governance and collaborating with stakeholders to define enterprise data roadmaps
  • Implementing cost-optimization frameworks for cloud resources, achieving significant reduction in operational expenses
Hadoop Apache Spark PySpark AWS Python

Data Engineering Sr Analyst

Accenture

May 2021 - Aug 2024 · 3 yrs 4 mos Bengaluru, Karnataka
  • Designed and deployed serverless data pipelines using AWS Glue and Lambda, ensuring high availability and scalability
  • Led the migration of legacy data warehouses to Snowflake, optimizing schemas for performance and concurrent access
  • Developed complex PySpark transformations to process terabytes of data for critical analytical reporting
  • Mentored junior engineers and established best practices for code quality, CI/CD, and automated testing
Data Engineering AWS PySpark Snowflake Airflow

Programmer Analyst

Cognizant

Dec 2018 - Apr 2021 · 2 yrs 5 mos Chennai
  • Developed and maintained critical ETL workflows using Python and SQL, ensuring timely data availability
  • Optimized complex SQL queries and stored procedures to improve data extraction performance and reduce load times
  • Performed rigorous data quality checks and root cause analysis to resolve production data incidents
  • Collaborated with business analysts to translate functional requirements into effective technical specifications
Data Engineering Data Warehousing SQL ETL Python
Academic Background

Education

Bachelor of Technology

Sri Venkateswara University

2014 - 2018

Intermediate (12th)

Sri Chaitanya Junior College

2012 - 2014
What I Do

Skills & Technologies

AI & Generative AI

LangChain
Ollama
RAG
Vector DBs
Prompt Eng.

Big Data & Analytics

Apache Spark
PySpark
Hadoop
Hive
Snowflake
Databricks

Cloud Platforms

AWS
GCP
Airflow

Programming Languages

Python
SQL

Data Engineering

Data Warehousing
ETL/ELT
Data Lakes
Data Pipelines
Credentials

Certifications

Databricks Certified Associate Developer

Apache Spark 3.0

Databricks

SnowPro Core Certification

Data Cloud Professional

Snowflake

AWS Partner: Accreditation

Technical Accreditation

Amazon Web Services

Leading with Analytics

Northwestern University 101

Kellogg Executive Education

CS50AI

Introduction to Artificial Intelligence

Harvard University

Generative AI Certification

LLMs, Vector Databases & RAG

Databricks
Recognition

Awards & Achievements

Client Appreciation – Allianz

Tata Consultancy Services

Received appreciation from Allianz for exceptional support and contribution to their project. Recognized for delivering high-quality work under tight deadlines, offering creative solutions, and maintaining excellent collaboration throughout the process.

Tenacious Techno Star Award 2022

Accenture

Recognized for outstanding technical excellence and perseverance in delivering complex data solutions.

On The Spot Award

Tata Consultancy Services

Awarded for exceptional quick thinking and immediate impact in resolving critical issues.

Special Initiative Award

Tata Consultancy Services

Recognized for taking initiative and going above and beyond in project delivery.

What Others Say

Recommendations

"I've been working with Mohan for some time in a team of Data Engineers. It was a great pleasure to work with him. Mohan shows an excellent attention to details, keeping high consideration not only for completing assigned task but also how to make it working efficiently and how it will impact entire solution. If anyone looks for a highly skilled and solid data developer, I strongly recommend Mohan!"

Krzysztof Piotrowski

Data Engineer

"Working alongside Mohan Vamsi has been a fantastic experience. As a data engineer, he stands out for his strong technical skills, quick adaptability, and dedication to excellence. His ability to learn and apply new concepts seamlessly has contributed significantly to our team's success. I highly endorse Mohan Vamsi for any role that demands a sharp mind, a proactive approach, and a great team player."

Aman Agarwal

Colleague

Beyond Work

Interests

Apart from being a data developer, I enjoy most of my time being outdoors.

Sci-Fi & Fantasy

Exploring new worlds through movies and TV shows

Cooking

Experimenting as an aspiring chef

Generative AI

Exploring LLMs, AI agents, and open-source models

Outdoors

Enjoying nature and outdoor activities

What I Build

Personal Projects

Beyond my professional work, I'm deeply passionate about Generative AI and spend my personal time building intelligent applications and exploring the cutting edge of AI technology.

AI Chat Interfaces

Building conversational applications using Ollama with open-source LLMs for personal use—exploring models like Llama, Mistral, and Gemma for various use cases.

Email Automation Agents

Developing intelligent agents using LangChain to automatically organize, categorize, and manage emails—leveraging AI to streamline daily workflows and boost productivity.

Web Applications

Creating full-stack AI-powered applications using Flask and Streamlit—from chatbots to data visualization dashboards with LLM integrations.

Understanding LLMs

Deeply studying how Large Language Models work from scratch—from tokenization and embeddings to transformers and fine-tuning techniques.

Actively following the latest in Generative AI and working towards building advanced AI agents that can assist in both professional and personal workflows.

Get In Touch

Let's Work Together

I'm always open to discussing new projects, opportunities, or just having a chat about data engineering and technology.

[email protected]
India
Send a Message