<ul><li>Demonstrated advanced SQL proficiency in CTEs, subqueries, joins, aggregations, window functions, and set operations for data analysis and reporting.</li><li>Solved complex SQL and database problems involving data extraction, transformation, analysis, and query optimization for accurate and efficient results.</li></ul>

SQL (Advanced)

<ul><li>Applied spreadsheet-based data analysis using Excel, including data cleaning, formulas, Pivot Tables, Pivot Charts, vlookup/xlookup and data visualization.</li><li>Developed dashboards and KPI reports to organize, analyze, and present data for business insights.</li></ul>

Google Sheets

<ul><li>Completed training in Excel, SQL, Power BI, Python, and data visualization for data analysis and reporting.</li><li>Applied data cleaning, exploratory data analysis (EDA), dashboard development, and business intelligence concepts through hands-on projects.</li></ul>

Data Analytics Certification

Bachelor of Technology

Other

Intermediate (Class XII)

Matriculation (Class X)

Harcourt Butler Technical University, Kanpur

India

Data Analyst with hands-on project experience in SQL, Advanced Excel, Power BI, DAX, and Python. Skilled in data analysis, EDA, data visualization, dashboard development, KPI reporting, and generating actionable insights from business data.

<ul><li>Analyzed 10,000+ customer records across 7 integrated tables using SQL and Power BI to evaluate churn, customer segmentation, retention trends, and regional performance.</li><li>Cleaned, transformed, and validated data using Power Query, established data relationships, and created a structured data model for reliable analysis.</li><li>Developed 3 interactive Power BI dashboards using DAX measures and calculated columns to track Churn Rate, Active Customers, demographics, credit score, account balance, and product usage.</li><li>Used SQL joins, aggregations, subqueries, and conditional logic for segmentation and churn analysis; identified 520 high-risk customers and key patterns, including a 32% churn rate in Germany, higher churn among female customers and Product 1 and 2 users, and increased churn across specific age segments.</li></ul>

Bank Customer Churn Analysis | SQL, Power BI, DAX

<ul><li>Analyzed music store sales data using SQL and Advanced Excel to evaluate revenue trends, customer purchasing behavior, genre performance, and sales across countries and employees.</li><li>Performed data cleaning, validation, and exploratory data analysis using SQL queries, Pivot Tables, and Pivot Charts to identify sales patterns, top-performing artists, genres, and revenue segments.</li><li>Identified Rock as the highest-selling genre, contributing 53% of U.S. sales, and analyzed top-performing artists, albums, customers, and revenue-generating countries.</li><li>Generated data-driven recommendations for marketing, inventory optimization, and customer engagement based on sales trends, customer behavior, and revenue insights.</li></ul>

Chinook Music Store Sales Analysis | SQL, Advanced Excel

<ul><li>Analyzed 97,000+ IT support tickets across 50 support agents to identify trends in resolution time, customer satisfaction, ticket priority, backlog, and agent performance.</li><li>Cleaned and transformed ticket data using Pivot Tables, Pivot Charts, Conditional Formatting, Slicers, VLOOKUP/XLOOKUP, and DATEDIF to support accurate analysis and operational reporting.</li><li>Developed an interactive Excel dashboard with KPI reporting to monitor ticket volume, resolution time, backlog, CSAT, priority distribution, and agent performance for performance tracking and trend analysis.</li><li>Identified 6 underperforming agents and key service gaps, including severity-priority misalignment and a 4.5-day average resolution time; provided data-driven recommendations for process improvement, training, and automation.</li></ul>

Ritik Katiyar

Social Accounts

Achievements

Projects

Bank Customer Churn Analysis | SQL, Power BI, DAX

Chinook Music Store Sales Analysis | SQL, Advanced Excel

IT Ticket Analysis | Advanced Excel

Education

Harcourt Butler Technical University (HBTU), Kanpur, Uttar Pradesh.

Mantora Public School

Mantora Public School

Certificates

SQL (Advanced)

Google Sheets

Data Analytics Certification

Skills