Open to opportunities

Kamal Singh

@kamalsingh3

Message

Entry-level Data Analyst skilled in SQL, Python, Power BI, and Excel—turning large datasets into actionable insights.

India

Message

What I'm looking for

I’m looking for a Data Analyst role where I can own end-to-end analytics and build dashboards in Power BI/SQL, collaborate with stakeholders, and grow from project impact—turning messy data into decisions with measurable results.

I’m an entry-level Data Analyst and B.Tech (CS&E) graduate who focuses on end-to-end analytics—data cleaning, dashboard development, and stakeholder-ready reporting. I’ve worked with datasets up to 5M+ records, transforming messy inputs into analysis-ready outputs through strong data quality assurance.

In my PhonePe Transaction Analysis, I processed 5M+ unstructured payment records using Pandas/NumPy with rigorous quality checks, then delivered insights like 147% MoM sales growth, 30% regional transaction concentration, and a 13.88% sector inflation spike from CPI analysis. I’m comfortable with ambiguity and enjoy turning patterns into clear business recommendations for non-technical audiences.

My technical strengths include SQL (Complex Joins, Window Functions, CTEs, LAG/LEAD, Query Optimization), MySQL, and Python (Pandas, NumPy, Matplotlib, Seaborn). I also build interactive Power BI reports using DAX, Power Query, and data modeling, plus Advanced Excel dashboards with pivot tables and dynamic visual reporting—so decisions are faster, cleaner, and measurable.

Experience

Work history, roles, and key accomplishments

Data Analytics Certification

Coding Ninjas

Nov 2023 - Dec 2024 (1 year 1 month)

Completed four full-cycle analytics projects using SQL, Python, Power BI, and Advanced Excel, each delivering a dashboard or business report on datasets ranging from 500 to 5M+ records. Applied statistical analysis and foundational predictive modeling and produced interactive visualizations for business performance reporting.

SQL Python Power BI Advanced Excel Pandas Statistical Analysis predictive modeling Data Visualization Data Storytelling

Deloitte Data Analytics Simulation

Deloitte

May 2026 - Present (0 months)

Participated in a Deloitte data analytics job simulation focused on applying SQL, Python, and dashboard/reporting concepts to real-world dataset tasks.

Data Analytics SQL Python Reporting Dashboarding Data Quality

India CPI Inflation Analysis

Self-Directed Project

Cleaned 500+ rows across 10+ CPI sectors, resolving missing values and format errors to cut pre-analysis data issues by ~95%. Created a 3-year inflation dashboard showing a 6.65% peak YoY rate and Fuel & Light as the top spike at 13.88%, including rural vs. urban trend comparisons with ~0.5% urban premium.

Excel Data Cleaning Statistical Analysis Dashboard Development Time Series Analysis Comparative Analysis Data Validation Data Visualization

E-Commerce Sales Analysis

Self-Directed Project

Built 15+ complex SQL queries (CTEs, window functions, joins) across 100K+ records, reducing query runtime by ~30%. Identified a 147% July sales spike, recommended front-loading Q3 inventory, modeled 18% stockout reduction, and segmented 5,000+ customers while auditing 200+ SKUs to flag 60+ low-adoption products.

SQL Complex Queries Window Functions Query Optimization Customer Segmentation Data Storytelling

PhonePe Transaction Analysis

Self-Directed Project

Analyzed 5M+ unstructured digital payment records using Pandas/NumPy with data quality checks, producing a cleaned analysis-ready dataset. Identified Maharashtra and Karnataka as 30% of national volume, quantified 150% YoY growth in 2020, and delivered 10+ visualizations for decision-makers.

Python Pandas NumPy Statistical Analysis predictive modeling Data Cleaning Data Quality Assurance Data Visualization Trend Analysis

Retail Sales Performance Dashboard

Self-Directed Project

Developed a Power BI dashboard for 50K+ retail transactions across 4+ regions, replacing 3+ hours/week of manual reporting. Defined 4 KPIs with 5+ dynamic filters, identified top 2 revenue-driving regions (40%), flagged 3+ underperforming categories, and built an ETL pipeline using Power Query with reliable data models.

Power BI DAX Power Query Data Modeling ETL KPIs Data Visualization

Education

Degrees, certifications, and relevant coursework

Coding Ninjas

Data Analytics Certification, Data Analytics

2023 - 2024

Activities and societies: Completed 4 full-cycle analytics projects across retail, e-commerce, and financial datasets (500 to 5M+ records) using SQL, Python, Power BI, and advanced Excel.

Earned a Data Analytics Certification through Coding Ninjas (Nov 2023–Dec 2024), completing end-to-end SQL, Python, Power BI, and Excel projects.

Graphic Era Hill University

Bachelor of Technology, Computer Science & Engineering

2019 - 2023

Grade: 8.05 / 10.0

Completed a Bachelor of Technology in Computer Science & Engineering (2019–2023), strengthening skills in SQL, Python, Power BI, and Excel through project-based coursework.