Gaurav Kumar Gupta

Results-Driven Professional: Highly analytical Python Developer with 3+ years of experience building backend web applications, scalable REST APIs, and automated ETL data processing pipelines. Expert in Python, Django, FastAPI, SQL, and Data Wrangling (Pandas/NumPy). Adept at transforming complex business requirements into robust, high-availability software solutions while optimizing database queries for maximum performance.

Python Developer & Data Analyst Intern at Meritshot (2025-01 – Present)

• Designed and deployed high-performance RESTful APIs using FastAPI / Django REST Framework to deliver core analytics metrics to executive dashboards.
• Engineered automated data ingestion and transformation pipelines with Python (Pandas, NumPy) and advanced SQL, accelerating dataset prep times by 35%.
• Optimized database queries and indexing in PostgreSQL/MySQL, reducing query execution latency by 25%.
• Actively participated in Agile sprint ceremonies, managing task tracking in Jira and utilizing Git for collaborative version control.

Python & Data Operations Analyst at Textiles & Retail Sector (2022-06 – 2024-12)

• Developed custom Python scripts for daily stock and sales aggregation, reducing manual reporting workload by 40% (saving 10+ operational hours weekly).
• Architected relational database schemas and ORM routines to optimize supply chain tracking, decreasing inventory variance by 15%.
• Crafted automated unit testing and validation scripts to verify data consistency prior to production system deployment.

Master of Arts in M.A. – CSJM University, Kanpur (2017)

Bachelor of Arts in B.A. – CSJM University, Kanpur (2015)