Open to opportunities

Nehal Gupta

@nehalgupta2

Message

Data Analyst who cut manual reporting time by 70% with SQL workflows and built a Power BI dashboard for KPI tracking.

India

Message

I built a personal SQL and analytics workflow that cleans source data and schedules refreshes, cutting manual reporting time by 70%. I also created a Power BI dashboard with DAX, dynamic filters, and more than 10 metrics for performance tracking.

At TravClan, I reconciled flight booking finances across 11 suppliers and wrote Root Cause Analysis reports that informed SOPs and reduced error tickets by 40%. I also built an AI-powered Flight Quote Formatter using prompt engineering and an LLM API, which was adopted department-wide.

Experience

Work history, roles, and key accomplishments

Operations Intern

TravClan

Feb 2026 - Aug 2026 (6 months)

Reconciled flight booking finances across 11 suppliers and authored Root Cause Analysis reports that reduced error tickets by 40%. Managed offline flight bookings worth over ₹5M/month and resolved 50+ customer escalations per month.

SQL Data Reconciliation Root Cause Analysis SOP Documentation Customer Escalation Management AI Prompt Engineering LLM APIs

Electronics Intern

ELC – Thapar Institute, Patiala

Jun 2024 - Jul 2024 (1 month)

Designed electronic architecture for an autonomous ground surveillance robot, developing 10+ circuit schematics and PCB layouts. Secured university funding and reached Top 10 in Innovation Showcase 2023.

Circuit Design PCB Layout Embedded Systems Autonomous Systems Technical Presentations