Cleared and mastered the Spreadsheets module as part of the Professional Certificate Course in Data Science at Newton School. Achieved 100% in lectures and assignments, 85% in Module Contest, and 90% in the Module Project. Covered advanced spreadsheet skills including data organization, formulas, pivot tables, and dashboard creation for business analysis.

Spreadsheets — Cleared and Mastered

Completed IBM Data Science fundamentals covering SQL, data analysis concepts, analytics basics, and an introduction to machine learning and data-driven problem solving.

Data Science (DS0101EN)

Completed the TCS iON Career Edge Young Professional program covering communication skills, presentation, interview preparation, resume writing, and workplace readiness.

TCS iON Career Edge – Young Professional

Title: Discipline Coordinator – College FestDescription: Coordinated with students and faculty to manage discipline and ensure smooth execution of college fest activities. Recognized for leadership and coordination skills. Title: Ad Mad Show – First Place (College Fest)Description: Participated in and won first place in an Ad Mad competition, demonstrating creativity, teamwork, communication, and presentation skills.

Bachelor of Business Administration

Management

Intermediate (Class XII)

Arts

Matriculation (Class X)

Not Applicable

- Promoted from BDE to Team Leader within&nbsp; &nbsp;4 months based on consistent performance. - Leading a sales team while personally&nbsp; &nbsp;managing key B2B client relationships. - Overseeing end-to-end sales operations —&nbsp; &nbsp;from lead generation to deal closure. - Mentoring junior team members and ensuring&nbsp; &nbsp;team targets are met every month. - Analysing client data and past interactions&nbsp; &nbsp;to build better pitching strategies for the team.

Sales

Team Leader

•&nbsp;Worked with import-export clients on B2B sales — right from finding leads to pitching services and closing deals.•&nbsp;Managed CRM entries, logged every client interaction, and kept the data clean and organized.•&nbsp;Followed up with clients regularly, understood their requirements in detail, and kept the pipeline moving.•&nbsp;Helped clients onboard onto e-commerce platforms (Amazon, Flipkart, Blinkit) by identifying suitable solutions.

Sr.Business Development Executive

Chhatrapati Shahu Ji Maharaj University, Kanpur

India

I am a Data Analyst with good working knowledge of Excel, SQL, and Power BI. I enjoy working with data — finding patterns, cleaning messy datasets, and turning numbers into something that actually makes sense for a business. I have built an Excel dashboard from scratch that analyzed nearly 1 lakh IT support tickets and helped identify where things were going wrong. I also hold IBM certifications in Data Science. Before moving into analytics, I spent over a year in B2B sales where I regularly worked with clients, understood their needs, and kept detailed records — which honestly made me a better analyst because I understand how businesses think. I am looking for an entry-level Data Analyst role where I can contribute, grow, and keep learning.

Analysed 9 seasons of IPL data (37,000+ ball-by-ball records)&nbsp; using MySQL to build a data-driven auction strategy for Royal&nbsp; Challengers Bangalore's 2017 Mega Auction.Key highlights: - 18 tables, 255 matches, 469 players analysed - 20+ complex SQL queries using CTEs, Window Functions &amp; JOINs - 5 custom KPIs derived (Composite Score, Death Economy, Dot Ball %) - Built complete Dream XI with statistical backing - Identified root cause of RCB's 3 final losses — bowling declineTech: MySQL | Advanced SQL | Sports Analytics

RCB IPL Auction Strategy 2017 — SQL Data Analysis

Developed an interactive Excel Dashboard to analyze 97,498 IT support tickets from 2016 to 2020.Key Highlights: • Ticket volume increased by 123% (from 13,051 to 29,088) while keeping average resolution time stable at 4.55 days • Identified major bottlenecks: Hardware (7.63 days) and System (6.62 days) • Login Access tickets resolved fastest in just 0.31 days • Built a fully interactive dashboard with slicers for Year, Request Category, Severity, Priority &amp; Issue Type • Analyzed agent performance and customer satisfaction trendsProvided clear business recommendations: → Upgrade Ticket Management System first (highest ROI) → Targeted training for underperforming agents → Hiring only after process optimizationSkills Used: Advanced Excel, Pivot Tables, Interactive Dashboards, Data Cleaning, VLOOKUP, Business AnalysisGitHub Repository: https://github.com/Shivamgupta6388/Excel-IT-Ticket-Analysis

Shivam GuptaIndia

Social Accounts

Achievements

Projects

RCB IPL Auction Strategy 2017 — SQL Data Analysis

IT Support Performance Dashboard

Experience

Team Leader

Sr.Business Development Executive

Education

Vision College of Management Affiliated CSJM University

Kendriya Vidyalaya Cantt Kanpur

Kendriya Vidyalaya Cantt Kanpur

Certificates

Spreadsheets — Cleared and Mastered

Data Science (DS0101EN)

TCS iON Career Edge – Young Professional

Skills