Gaurav Kumar profile photo 1 on Tal

Gaurav Kumar

Data Analyst | Business Analyst | SQL | Python | Power BI | Advanced Excel | EDA & KPI Reporting

Pune/Pimpri-Chinchwad Area

2+ years of work experience

ViralMint
Sep 20242 yrsPresent

Pune District

• Extracted, cleaned, and analyzed Amazon & Flipkart advertising data using Advanced Excel — performed EDA, trend, and statistical analysis to uncover campaign optimization opportunities, achieving a 6.3 ROI and 4.13 ROAS on ₹7L ad spend. • Conducted market research and campaign performance analysis on large datasets, identifying targeted audience segments and presenting findings to brand owners to support data-driven sales strategy. • Tracked business KPIs and analyzed the customer funnel end-to-end to identify drop-off points and growth opportunities, contributing to monthly sales revenue of ₹45–50L. • Built and automated weekly and monthly KPI dashboards using Advanced Excel, Power Query, and Power BI — improving reporting efficiency through structured data cleaning, validation, and automated workflows.

Gaurav’s AI Stack

claude code
claude code
claude
claude
gemini
gemini
github copilot
github copilot
openai
openai

Education

Lovely Professional University

Bachelor of Technology - BTech, Computer Science and Engineering

Lovely Professional University

20203 yrs2023
Lovely Professional University

Diploma, Computer Science and Engineering

Lovely Professional University

20173 yrs2020

Join Gaurav and 10k+ other professionals on

Tal Boss

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

Download Tal Boss

Gaurav Kumar on Tal

Headline

Data Analyst | Business Analyst | SQL | Python | Power BI | Advanced Excel | EDA & KPI Reporting

About

I'm a Data Analyst with hands-on experience in SQL, Python, Power BI, and Advanced Excel, focused on turning raw business data into actionable insights that drive better decisions. At Viralmint Media, I analyzed Amazon & Flipkart advertising data to optimize campaign performance, contributing to a 6.3 ROI and 4.13 ROAS on ₹7L in ad spend. I also built automated KPI dashboards tracking ₹45–50L in monthly sales, helping stakeholders monitor business performance through clear, reliable metrics. 📊 Key projects: • E-Commerce Sales Performance & Executive Business Insights Dashboard — Excel-based interactive dashboard analyzing Amazon sales and advertising performance • Healthcare Customer Funnel, Marketing & Revenue Analytics — SQL analysis of funnel drop-offs, acquisition sources, and customer journey performance • PhonePe Digital Payments Case Study — Python-based trend analysis and growth recommendations from transaction data 🔧 Skills: SQL | Python | Power BI | Advanced Excel | Statistics | EDA | Data Visualization | KPI Reporting I'm currently sharpening these skills further through Coding Ninjas' Data Analytics Job Bootcamp. 🎯 Open to Data Analyst and Business Analyst roles where I can turn data into insight and insight into measurable business results — Feel free to connect!

Location

Pune/Pimpri-Chinchwad Area

AI stack

claude code

claude

gemini

github copilot

openai

Work experience

Business Analyst at ViralMint, Sep 2024 - Present · 2 yrs, Pune District, • Extracted, cleaned, and analyzed Amazon & Flipkart advertising data using Advanced Excel — performed EDA, trend, and statistical analysis to uncover campaign optimization opportunities, achieving a 6.3 ROI and 4.13 ROAS on ₹7L ad spend. • Conducted market research and campaign performance analysis on large datasets, identifying targeted audience segments and presenting findings to brand owners to support data-driven sales strategy. • Tracked business KPIs and analyzed the customer funnel end-to-end to identify drop-off points and growth opportunities, contributing to monthly sales revenue of ₹45–50L. • Built and automated weekly and monthly KPI dashboards using Advanced Excel, Power Query, and Power BI — improving reporting efficiency through structured data cleaning, validation, and automated workflows.

Education

Bachelor of Technology - BTech, Computer Science and Engineering, Lovely Professional University

Diploma, Computer Science and Engineering, Lovely Professional University

Gaurav Kumar - Business Analyst in Pune/Pimpri-Chinchwad Area | Tal