Pranav Gauttam profile photo 1 on Tal

Pranav Gauttam

AI Engineer | Data Scientist | LLM · Generative AI · ETL Pipelines · Python · SQL | Full Stack Developer | SDE Intern @ Mphasis | TIET CSE

Bengaluru

2+ years of work experience

Jun 20264 moPresent

Remote

Mphasis
Feb 20264 mosMay 2026

Hyderabad, Telangana, India

• Architected and shipped InsightIQ — an end-to-end sales analytics platform processing raw CSV/Excel uploads through a full data pipeline: schema validation → Pandas ETL → async Celery jobs → PostgreSQL → REST API → Chart.js dashboard • Engineered an async processing engine with Celery + Redis workers, offloading all heavy data transformation from the request cycle; added exponential backoff retry logic and structured task logging for production reliability • Designed a multi-tenant PostgreSQL schema with row-level data isolation per user, indexed aggregation paths, and query-optimized table structures — enabling fast time-series and KPI analytics across large datasets. • Built an AI forecasting module combining Linear Regression and Moving Average models to generate automated sales trend predictions; developed a rule-based NLP query engine enabling plain-English data querying without SQL. • Fully containerized the entire stack with Docker Compose (Django + Celery worker + Redis + PostgreSQL + Nginx + Gunicorn) — achieving one-command local setup and production-parity deployment. • Shipped an automated report scheduler using Celery Beat for daily/weekly/monthly CSV/Excel export generation; implemented Redis caching for repeated analytics queries, reducing redundant DB load • Secured the platform with hybrid JWT + session authentication, API rate limiting, and role-based access control; wrote a pytest suite covering unit, API, data validation, and edge case tests • Delivered an interactive analytics dashboard with Chart.js — animated KPI cards, time-series charts, and multi-axis filters (date range, region, product) with real-time API-driven data refresh
SERVIZ
Dec 20242 mosJan 2025

Remote

• Sole engineer for a complete HR Management System — designed and shipped the entire product (frontend + backend + database) handling employee records, leave management, and payroll workflows; built multi-role access control from schema to UI • Defined the full-stack architecture using Angular, Next.js, MongoDB, and REST APIs — modelled the data schema, designed the API contract, and built both layers simultaneously across a 2-month solo sprint • Built an Inventory Management System frontend with Angular + Bootstrap; ensured full responsive behaviour across mobile, tablet, and desktop breakpoints, eliminating layout breakage on smaller viewports • Integrated REST APIs for real-time data sync across all HR modules — removing manual data reconciliation and reducing update latency from minutes to milliseconds
GirlScript Summer of Code
May 20244 mosAug 2024

Remote

• Contributed code across multiple open source repositories over a competitive 4-month program — submitted PRs for bug fixes, feature additions, and documentation improvements reviewed by project maintainers • Navigated real-world collaborative engineering workflows — branching strategies, async code review cycles, and iterative refinement across distributed teams
Microsoft Learn Student Chapter, TIET
Aug 20231 moAug 2023

MudraSociety_db
Jul 20231 yrJun 2024

On-site

• Led operations and strategic direction for a student-run organization — coordinated events, managed team responsibilities, and scaled community engagement across the academic year • Progressed from Member → Head of Management in under 6 months, taking on organizational ownership ahead of peers
Microsoft Learn Student Chapter, TIET
Jun 20232 mosJul 2023

MudraSociety_db
Jan 20236 mosJun 2023

Pranav’s AI Stack

antigravity
antigravity
claude code
claude code
codex
codex
cursor
cursor
gemini
gemini
opencode
opencode

Education

Thapar Institute of Engineering & Technology

Cse, Computer Science

Thapar Institute of Engineering & Technology

DAV international school Amritsar

Join Pranav and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Pranav Gauttam on Tal

Headline

AI Engineer | Data Scientist | LLM · Generative AI · ETL Pipelines · Python · SQL | Full Stack Developer | SDE Intern @ Mphasis | TIET CSE

About

I build systems where raw data becomes real decisions. At Mphasis, I designed and shipped InsightIQ — a production-grade sales analytics platform, built end-to-end: CSV/Excel ingestion → async ETL pipeline → multi-tenant PostgreSQL → REST API → AI forecasting → interactive dashboard. Fully containerized with Docker. Forecasting with Linear Regression + Moving Average. Rule-based NLP engine for plain-English data queries. Before that, I was the sole engineer on a full HR Management System at SERVIZ — frontend, backend, database schema, API layer — shipped in 2 months using Angular, Next.js, and MongoDB. What I build with: • Data & Backend: Python, Django, PostgreSQL, Celery, Redis, Pandas, ETL, REST APIs • AI/ML: LLMs, Generative AI, Prompt Engineering, RAG, Forecasting, NLP • Infra: Docker, Nginx, Gunicorn, JWT Auth, Rate Limiting • Frontend: Chart.js, Angular, Next.js, JavaScript What makes me different: I don't just study AI — I integrate it into real systems. InsightIQ's forecasting module and NLP query engine are production features, not demo code. I think in pipelines, not scripts. Currently looking for: AI Engineer · Applied AI Engineer · Data Scientist · Data Analyst · Backend Engineer → Connect if you're building something worth shipping.⚡🤌

Location

Bengaluru

AI stack

antigravity

claude code

codex

cursor

gemini

opencode

Work experience

AI Consultant at Pratnova Infotech LLP, Jun 2026 - Present · 4 mo, Remote

Software Engineer Intern at Mphasis, Feb 2026 - May 2026 · 4 mos, Hyderabad, Telangana, India, • Architected and shipped InsightIQ — an end-to-end sales analytics platform processing raw CSV/Excel uploads through a full data pipeline: schema validation → Pandas ETL → async Celery jobs → PostgreSQL → REST API → Chart.js dashboard • Engineered an async processing engine with Celery + Redis workers, offloading all heavy data transformation from the request cycle; added exponential backoff retry logic and structured task logging for production reliability • Designed a multi-tenant PostgreSQL schema with row-level data isolation per user, indexed aggregation paths, and query-optimized table structures — enabling fast time-series and KPI analytics across large datasets. • Built an AI forecasting module combining Linear Regression and Moving Average models to generate automated sales trend predictions; developed a rule-based NLP query engine enabling plain-English data querying without SQL. • Fully containerized the entire stack with Docker Compose (Django + Celery worker + Redis + PostgreSQL + Nginx + Gunicorn) — achieving one-command local setup and production-parity deployment. • Shipped an automated report scheduler using Celery Beat for daily/weekly/monthly CSV/Excel export generation; implemented Redis caching for repeated analytics queries, reducing redundant DB load • Secured the platform with hybrid JWT + session authentication, API rate limiting, and role-based access control; wrote a pytest suite covering unit, API, data validation, and edge case tests • Delivered an interactive analytics dashboard with Chart.js — animated KPI cards, time-series charts, and multi-axis filters (date range, region, product) with real-time API-driven data refresh

Engineering Intern at SERVIZ, Dec 2024 - Jan 2025 · 2 mos, Remote, • Sole engineer for a complete HR Management System — designed and shipped the entire product (frontend + backend + database) handling employee records, leave management, and payroll workflows; built multi-role access control from schema to UI • Defined the full-stack architecture using Angular, Next.js, MongoDB, and REST APIs — modelled the data schema, designed the API contract, and built both layers simultaneously across a 2-month solo sprint • Built an Inventory Management System frontend with Angular + Bootstrap; ensured full responsive behaviour across mobile, tablet, and desktop breakpoints, eliminating layout breakage on smaller viewports • Integrated REST APIs for real-time data sync across all HR modules — removing manual data reconciliation and reducing update latency from minutes to milliseconds

Contributor at GirlScript Summer of Code, May 2024 - Aug 2024 · 4 mos, Remote, • Contributed code across multiple open source repositories over a competitive 4-month program — submitted PRs for bug fixes, feature additions, and documentation improvements reviewed by project maintainers • Navigated real-world collaborative engineering workflows — branching strategies, async code review cycles, and iterative refinement across distributed teams

Joint Secretary at Microsoft Learn Student Chapter, TIET, Aug 2023 - Aug 2023 · 1 mo

Head Management at MudraSociety_db, Jul 2023 - Jun 2024 · 1 yr, On-site, • Led operations and strategic direction for a student-run organization — coordinated events, managed team responsibilities, and scaled community engagement across the academic year • Progressed from Member → Head of Management in under 6 months, taking on organizational ownership ahead of peers

Member at Microsoft Learn Student Chapter, TIET, Jun 2023 - Jul 2023 · 2 mos

Member at MudraSociety_db, Jan 2023 - Jun 2023 · 6 mos

Education

Cse, Computer Science, Thapar Institute of Engineering & Technology

DAV international school Amritsar

Public links

portfolio-taupe-rho-60.vercel.app: https://portfolio-taupe-rho-60.vercel.app/