UTKARSH KUMAR

Data Analyst

Noida, Uttar Pradesh 0+ yrs exp 81 · Excellent

About

Data Analyst and B.Tech Computer Science graduate (NIET, 2026) who turns raw data into dashboards and decisions. At Capgemini, built 5 Power BI dashboards on an Oracle SQL data layer, delivered recurring MIS reports to 15+ stakeholders, and raised data accuracy to 99.8% with Python validation that saves 260+ hours a year. Comfortable across the full workflow: SQL extraction, cleaning, modeling, visualization and clear written insight for business teams.

Skills & Expertise (39)

Excel Advanced

6.0/10

0.25

Years Exp

EDA Intermediate

5.3/10

0.25

Years Exp

Pandas Intermediate

5.3/10

0.25

Years Exp

IF formulas Intermediate

5.3/10

0.25

Years Exp

Index-match Intermediate

5.3/10

0.25

Years Exp

VLOOKUP Intermediate

5.3/10

0.25

Years Exp

XLOOKUP Intermediate

5.3/10

0.25

Years Exp

Pivot Tables Intermediate

5.3/10

0.25

Years Exp

NumPy Intermediate

5.3/10

0.25

Years Exp

Power BI Intermediate

5.3/10

0.25

Years Exp

SQL Intermediate

5.3/10

0.25

Years Exp

T-SQL Intermediate

4.8/10

0.25

Years Exp

Seaborn Intermediate

4.8/10

0.25

Years Exp

Regression Intermediate

4.8/10

0.25

Years Exp

Hypothesis Testing Intermediate

4.8/10

0.25

Years Exp

A/B testing Intermediate

4.8/10

0.25

Years Exp

Trend Detection Intermediate

4.8/10

0.25

Years Exp

Anomaly Detection Intermediate

4.8/10

0.25

Years Exp

Forecasting Intermediate

4.8/10

0.25

Years Exp

Power Query Intermediate

4.8/10

0.25

Years Exp

Data Modeling Intermediate

4.8/10

0.25

Years Exp

DAX Intermediate

4.8/10

0.25

Years Exp

Data Models Intermediate

4.8/10

0.25

Years Exp

Oracle Intermediate

4.8/10

0.25

Years Exp

MySql Intermediate

4.5/10

0.25

Years Exp

Documentation Intermediate

4.5/10

0.25

Years Exp

Agile Intermediate

4.5/10

0.25

Years Exp

Jupyter Intermediate

4.5/10

0.25

Years Exp

GitHub Intermediate

4.5/10

0.25

Years Exp

Git Intermediate

4.5/10

0.25

Years Exp

Google Cloud Intermediate

4.5/10

0.25

Years Exp

AWS Intermediate

4.5/10

0.25

Years Exp

Azure Intermediate

4.5/10

0.25

Years Exp

Postgresql Intermediate

4.5/10

0.25

Years Exp

SQL Server Intermediate

4.5/10

0.25

Years Exp

BigQuery Intermediate

4.5/10

0.25

Years Exp

Power Automate Intermediate

4.5/10

0.25

Years Exp

SSIS Intermediate

4.5/10

0.25

Years Exp

Tableau Intermediate

4.5/10

0.25

Years Exp

Work Experience

Business & Data Analyst Intern

Capgemini

Apr 2026 - Jun 2026

Built and maintained 5 Power BI dashboards tracking sales conversions, revenue trends and team productivity, with drill-throughs and dynamic slicers; cut reporting cycles by 20%. Queried and validated Oracle SQL datasets and delivered daily, weekly and monthly MIS reports to 15+ stakeholders for real-time KPI tracking. Partnered with Sales, Operations and Management to gather requirements and identify 8+ process gaps, helping the business recover $2M+ in revenue. Automated reporting and validation in Python (Pandas), raising data accuracy to 99.8% and saving 260+ hours a year. Documented reports and workflows, coached teammates on using them, and reviewed peers' work in Agile sprints.

Data Science Intern

CODTECH IT Solutions

Jul 2024 - Aug 2024

Collected and cleaned 50K+ transaction records in Python to 99%+ data quality for downstream analysis. Ran EDA on sales and revenue data to find trends and regional anomalies; presented findings with trend charts, heatmaps and scatter plots.