Summary
Work History
Education
Skills
Websites
Awards And Achievements
Coursework
Accomplishments
Timeline
Generic
Ansh Gautam

Ansh Gautam

Noida, Uttar Pradesh

Summary

Innovative analyst with strong skills in DAX and advanced Excel. Contributed to vendor performance enhancements through comprehensive analyses, ready to leverage expertise in data management and project tracking to drive impactful business outcomes.

Work History

Management Trainee (Supply Chain Accounts)

Jubilant Ingrevia Limited
Noida
05.2025 - 06.2025
  • Led data integrity initiative for 7,500 MSME vendors on Infer LN Cloud ERP, ensuring payment compliance and enhancing vendor relations.
  • Conducted comprehensive analysis of import supply chain, emphasizing landed cost calculations and CHA roles to optimize operational efficiency.
  • Created automated dashboards in Tableau and Power BI, saving 15 hours monthly in manual reporting and improving data accessibility.

Finance Intern

ITC Ltd
Saharanpur
12.2024 - 01.2025
  • Processed purchase orders in procurement department, ensuring timely supply chain operations.
  • Developed Power BI dashboard from 50,000+ line SAP dataset, enhancing vendor performance analysis by 30%.
  • Compared vendors' quotations and delivery systems in ITC, facilitating informed decision-making by agents.

Education

MBA - Data Science & AI

Indian Institute of Technology
Mandi
05-2026

B.Com (Hons.) - Financial Management & Accounts

University of Delhi
New Delhi
07-2023

Skills

  • Microsoft Power BI and Tableau

  • Advanced Excel and DAX

  • AWS cloud services

  • Python programming

  • Database management

  • Project planning with MS Project

  • Project tracking with Jira

  • Working capital management

  • Procure-to-pay cycle expertise

Awards And Achievements

  • Completed a live project with an MSME in Himachal Pradesh, performed receivables analysis using Power BI and SQL to track overdue payments and customer risk, segmented receivables by due periods, and flagged high-risk customers for targeted recovery, built dashboards for receivable aging and DSR performance to support improved cash flow management, served as Finance Team Lead
  • Led a marketing research project projecting a 10–15% increase in engagement for a fashion brand

Coursework

Coursework project — AI stock advisor (ongoing)

  • Developed an ML-based return prediction and portfolio optimization tool with technical and fundamental analysis
  • Integrated LLM for contextual investment insights, recommendations, and risk commentary
  • Built an interactive dashboard for allocation strategies based on user-selected risk preferences

Accomplishments

2nd place in the Case-Comm Competition at the Himalayan Business Summit 2.0, organized by IIT Mandi (2025)

Timeline

Management Trainee (Supply Chain Accounts)

Jubilant Ingrevia Limited
05.2025 - 06.2025

Finance Intern

ITC Ltd
12.2024 - 01.2025

MBA - Data Science & AI

Indian Institute of Technology

B.Com (Hons.) - Financial Management & Accounts

University of Delhi
Ansh Gautam