<ul><li>Completed intensive training in Excel, SQL, Power BI, Data Visualization, Data Modeling, Dashboard Development, and Business Analytics, with hands-on experience gained through real-world projects and practical case studies.</li></ul>

Professional Certification in Data Analyst & Artificial Intelligence

<ul><li>Built foundational knowledge in SQL, Data Analysis, Data Science concepts, Analytics Fundamentals, and Data-Driven Problem Solving, with exposure to machine learning principles and analytical thinking frameworks.</li></ul>

IBM Data Science Fundamentals (DS0101EN)

<ul><li>Developed professional skills in business communication, presentation delivery, interview preparation, resume building, and workplace readiness for corporate environments.</li></ul>

TCS iON Career Edge – Young Professional

Awarded Star Employee of the Month for two consecutive months (November &amp; December 2024) at Global Trade Plaza for exceptional performance and contribution to business growth.

Bachelor of Business Administration

Management

Intermediate (Class XII)

Arts

Matriculation (Class X)

Not Applicable

<ul><li>Analyzed 2,000+ monthly lead records to identify conversion trends, funnel bottlenecks, and opportunities for improving lead performance. &nbsp;</li><li>Monitored key KPIs including lead volume, conversion rate, follow-up performance, and target achievement through Google Sheets dashboards and weekly reports. &nbsp;</li><li>Managed end-to-end lead funnel data across Bitrix24, Zoho Mail and CRM365, tracking lead movement, customer interactions, and conversion status with high data accuracy. &nbsp;</li><li>Prepared MIS reports and performance dashboards to support management reviews, business planning, and decisions contributing to ₹4,00,000+ monthly revenue.</li></ul>

Sales

Team Leader — Revenue & Data Analytics

<ul><li>Analyzed 50+ B2B prospect profiles across Agriculture, Clothing, Minerals, and Oil &amp; Gas sectors using Excel to assess market fit, customer requirements, and business opportunities.</li><li>Evaluated business and onboarding data for international clients, supporting qualification processes and contributing to successful onboarding of clients with contract values of up to $8,000.</li></ul>

Sr. Business Development Executive

Chhatrapati Shahu Ji Maharaj University, Kanpur

India

Data & Business Analytics professional with 2 years of experience in KPI reporting, CRM analytics, and business performance tracking. Proficient in Advanced Excel, SQL, and Power BI, with hands-on experience building dashboards and analyzing business data. Worked on projects involving 113K+ e-commerce orders, 97K+ IT support tickets, and 37K+ IPL records to identify trends, monitor performance, and support decision-making. Passionate about turning data into actionable business insights.


<ul><li>Analyzed 113K+ e-commerce orders using SQL, Power Query, DAX, and Star Schema modeling to evaluate revenue trends, customer behavior, regional performance, and return patterns.</li><li>Developed KPIs including ₵107M revenue, 113K orders, 31K returns, and 9.53-day delivery time; identified that 47% of revenue came from two regions and that product description mismatch was the primary driver of returns.</li></ul>

Amazon E-Commerce Sales Analytics Dashboard | Power BI, SQL

<ul><li>Analyzed 37K+ ball-by-ball records across 255 matches, 469 players, and 18 tables using Joins, CTEs, Window Functions, and Subqueries to evaluate team and player performance.</li><li>Identified RCB's overdependence on top-order batting and weak death bowling through analysis of Win %, Strike Rate, Wickets, Venue Performance, and All-Rounder Contribution; recommended a data-driven auction strategy focused on all-rounders and death-over specialists.</li></ul>

RCB IPL Auction Strategy 2017 | MySQL

<ul><li>Analyzed 97,498 IT support tickets to monitor ticket volume, resolution time, customer satisfaction, and agent performance through interactive KPI dashboards and automated reporting.</li><li>Identified key operational bottlenecks in Hardware (7.63 days) and System (6.62 days) requests; recommended process optimization and targeted agent training after observing 123% ticket growth with stable service quality.</li></ul>

Shivam Gupta

Social Accounts

Achievements

Projects

Amazon E-Commerce Sales Analytics Dashboard | Power BI, SQL

RCB IPL Auction Strategy 2017 | MySQL

IT Support Performance Analysis Dashboard | Advanced Excel, Google Sheet

Experience

Team Leader — Revenue & Data Analytics

Sr. Business Development Executive

Education

Vision College of Management Affiliated CSJM University

Kendriya Vidyalaya Cantt Kanpur

Kendriya Vidyalaya Cantt Kanpur

Certificates

Professional Certification in Data Analyst & Artificial Intelligence

IBM Data Science Fundamentals (DS0101EN)

TCS iON Career Edge – Young Professional

Skills