Back to Developers
Shubham Kumawat

Shubham Kumawat

Data Analyst

78
Profile Score

About

Results-driven Data Analyst with 2+ years of experience in SQL, Python, Advanced Excel, Power BI, and AWS-based analytics solutions. Expertise in data cleaning, transformation, ETL development, data modeling (Star Schema), and business intelligence reporting. Proven ability to analyze large-scale datasets (8M+ records), optimize SQL queries (30% performance improvement), and deliver KPI-driven dashboards supporting fraud analytics and stakeholder decision-making. Strong background in data warehousing, customer analytics, and cloud-based data lake architectures.

Skills & Expertise (13)

SQL Intermediate
8.1/10
2
Years Exp
AWS (S3, Glue, Athena, Lambda) Intermediate
8.0/10
2
Years Exp
Python Intermediate
7.9/10
2
Years Exp
Power BI Intermediate
7.8/10
2
Years Exp
PySpark Star Schema SCD Type 1 & 2 Amazon QuickSight Data Validation Reconciliation Frameworks KPI Monitoring Advanced Excel Power Query

Work Experience

Data Analyst

Tata Consultancy Services

Jan 2024 - Present

Processed and examined 8M+ transaction records to support fraud analytics, KPI monitoring, and business intelligence reporting. Improved and streamlined complex SQL queries, improving reporting performance by 30% through query tuning and partition optimization. Designed and maintained fact and dimension tables using SCD Type 1 & Type 2 methodologies for accurate historical trend analysis. Built automated data reconciliation frameworks ensuring data accuracy, completeness, and data integrity across reporting layers. Performed data validation, transformation, and Exploratory Data Analysis (EDA) using SQL and Python. Delivered stakeholder-ready Power BI dashboards highlighting fraud trends, customer behavior, and operational KPIs. Collaborated with cross-functional teams to resolve data discrepancies and enhance reporting reliability.

Education

Bachelor of Engineering in Electronics and Telecommunication (B.E) - MET’s Institute of Engineering, Nashik (Pune University)

2020 - 2023 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 18/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 78/100

Profile Overview

Member sinceMar 2026

Skills (13)

SQL AWS (S3, Glue, Athena, Lambda) Python Power BI PySpark Star Schema SCD Type 1 & 2 Amazon QuickSight Data Validation Reconciliation Frameworks +3 more