ARNAV PURI

Jammu, IN.

About

A business enthusiast who is up for learning as much as he can. Proficient in processing, visualising and analysing data using Python, SQL and PowerBI.

Education

Indian Institute of Information Technology, Design and Manufacturing

→

B. Tech

Electronics and Communication Engineering

Grade: 7.9

Awards

Qualified National Talent Search Examination round 1 in 2018, cleared International Maths Olympiad and National Science Olympiad Exams

Skills

Technical Tools

MySQL, MS Excel, MS PowerBI, Python.

Libraries

Pandas, Matplotlib, Numpy, Seaborn.

Methodologies

Agile Methodology, Waterfall Methodology.

Soft skills

Analytic mindset, Leadership, Strategic Thinking.

Interests

Musical Competitions

flute, guitar.

Chess Competitions
Karate

Projects

Sales Optimisation Project

Summary

Designed an interactive Power BI dashboard to analyze 82,000+ pizza sales, tracking core KPIs such as total revenue, order volume, and average order value to support data-driven decision-making.. Leveraged donut charts, funnel visuals, and bar graphs to visualize order distribution, sales conversion stages, and revenue by product category and size, enabling clear performance insights. Identified top 5 best-selling pizzas, contributing 28 per cent of total revenue, and flagged bottom performers with <1 per cent sales, informing menu refinement and promotional focus.

Customer Experience Enhancer

Summary

Analyzed 55,000+ customer transactions to uncover demographic purchase trends across states, age groups, and professions, highlighting key segments driving Diwali sales. Processed and cleaned 100,000+ data rows using Python (Pandas, NumPy), addressing missing values, outliers, and inconsistent categories to ensure high-quality, reliable analysis. Designed data-driven strategies to enhance the customer experience and boost revenue, including targeted marketing campaigns and personalized product recommendations based on buyer behavior.

Multi-Strategy Trading Performance Dashboard

Summary

Developed an interactive Power BI dashboard analyzing 5,000+ trades across multiple strategies, enabling clear visualization of total PnL, win/loss distribution, and hourly trade performance. Applied advanced data transformation techniques in Power Query (data type correction, locale handling, cumulative calculations) to ensure accurate and user-friendly reporting experience. Transformed and cleansed large datasets using Power Query (including date-time formatting, cumulative PnL calculations), ensuring high data integrity and insightful reporting.