Ritik kumar Gupta

Data Analyst

0+ yrs exp 82 · Excellent

About

Data Analyst with hands-on experience in SQL, Python, Excel, Power BI, statistics, data cleaning, data processing, and data visualization. Experienced in transforming raw data into actionable insights through analytical dashboards, business reports, KPI analysis, and data-driven decision-making. Strong understanding of business domains with analytical thinking, problem-solving, and communication skills. Currently pursuing B.Tech in Computer Science with a Minor in Data Analytics.

Skills & Expertise (37)

Data Cleaning Intermediate

6.5/10

Years Exp

Data Processing Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.5/10

Years Exp

Data Analysis Intermediate

6.5/10

Years Exp

Problem Solving Intermediate

6.5/10

Years Exp

Analytical Thinking Intermediate

6.5/10

Years Exp

Data-driven decision making Intermediate

6.0/10

Years Exp

Communication Intermediate

6.0/10

Years Exp

Business domain understanding Intermediate

6.0/10

Years Exp

Charts Intermediate

6.0/10

Years Exp

Pivot Tables Intermediate

6.0/10

Years Exp

Index-match Intermediate

6.0/10

Years Exp

XLOOKUP Intermediate

6.0/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

Advanced Excel Intermediate

6.0/10

Years Exp

Data Visualization Intermediate

6.0/10

Years Exp

Statistical Analysis Intermediate

6.0/10

Years Exp

KPI Reporting Intermediate

6.0/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Advanced SQL Intermediate

6.0/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

Power Query Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

Dashboard Development Intermediate

6.0/10

Years Exp

Data Modeling Intermediate

5.5/10

Years Exp

DBMS Intermediate

5.5/10

Years Exp

ETL Intermediate

5.5/10

Years Exp

ELT Intermediate

5.5/10

Years Exp

relational databases Intermediate

5.5/10

Years Exp

Git Intermediate

5.5/10

Years Exp

GitHub Intermediate

5.5/10

Years Exp

VS Code Intermediate

5.5/10

Years Exp

Streamlit Intermediate

5.0/10

Years Exp

Work Experience

Data Analyst / MIS Support

RK Prime Distributor

Jan 2026 - Present

Analyze and process business data to support MIS reporting, operational analysis, and management decision-making. Perform data cleaning, validation, transformation, and consolidation using Excel and analytical tools. Prepare regular reports and analyze business performance using relevant KPIs and operational metrics. Apply Excel functions, Pivot Tables, lookups, and data analysis techniques to organize and interpret business data. Identify trends, discrepancies, and actionable insights from operational datasets. Communicate analytical findings clearly to support day-to-day business operations.

Data Analyst Intern

Edulyt India

Jul 2025 - Aug 2025

Collected, cleaned, validated, and analyzed business datasets for analytical reporting. Used Excel, Power BI, Tableau, Google Analytics, Google Colab, and Google Charts for data analysis and visualization. Analyzed cold-call success ratios to evaluate sales performance and identify trends. Performed customer spending and repayment analysis to identify meaningful business patterns. Created visual reports and dashboards to communicate findings effectively. Documented analytical findings and contributed to data-driven business reporting.