Kundan kumar Choudhary

Data Analyst

Noida, India 3+ yrs exp 86 · Excellent

About

Data Analyst with 3+ years of experience turning CRM, admissions, and digital-marketing data into dashboards and business insights. Skilled in SQL, Python (Pandas, NumPy), Power BI, and Excel for data cleaning, ETL, KPI tracking, and reporting automation. Proven track record building lead-funnel and conversion dashboards across 50+ partner colleges, automating recurring reporting cycles, and delivering data-driven recommendations that support stakeholder decision-making in a high-volume, performance-based operating environment.

Skills & Expertise (32)

Pandas Intermediate

7.3/10

Years Exp

SQL Intermediate

7.3/10

Years Exp

Python Intermediate

7.3/10

Years Exp

Dashboard Development Intermediate

7.3/10

Years Exp

Power BI Intermediate

7.3/10

Years Exp

KPI Analysis Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Funnel Analysis Intermediate

7.0/10

Years Exp

Reporting Automation Intermediate

7.0/10

Years Exp

Stakeholder Reporting Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Data Transformation Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Power Query Intermediate

6.8/10

Years Exp

DAX Intermediate

6.8/10

Years Exp

NumPy Intermediate

6.8/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

Formulas Intermediate

6.5/10

Years Exp

Pivot Tables Intermediate

6.5/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

API Integration Intermediate

6.0/10

Years Exp

Google Ads Intermediate

6.0/10

Years Exp

HLOOKUP Intermediate

5.5/10

Years Exp

ML Fundamentals Intermediate

5.5/10

Years Exp

Regression Intermediate

5.5/10

Years Exp

Classification Intermediate

5.5/10

Years Exp

Clustering Intermediate

5.5/10

Years Exp

Kafka Beginner

4.5/10

Years Exp

Spark Beginner

4.5/10

Years Exp

Docker Beginner

4.5/10

Years Exp

Work Experience

Data Analyst

CareerGuide

Aug 2023 - Present

Extracted, cleaned, and validated lead and enrollment data (up to 1,000,000 records) from Freshsales CRM using SQL (joins, subqueries) and Python (Pandas), reducing data errors through systematic validation. Built and maintained Power BI dashboards — including data modeling, DAX, and Power Query — plus Excel dashboards, tracking the full admissions funnel (Lead → Form Initiated → Paid Application → Enrollment) across 50+ partner colleges and universities. Automated recurring stakeholder and partner-university reports via Google Sheets and Power BI, reducing manual reporting effort and turnaround time. Ran multi-year (2024–2026) comparative analysis of Google Ads and Meta Ads performance across entrance-exam verticals (CUET, JEE, BITSAT, NIFT, LPU), identifying lead-quality and targeting gaps and delivering optimization recommendations. Diagnosed root causes of declining enrollment conversion despite rising lead volume — including state-level targeting gaps and low lead verification — and supported development of API-based lead-distribution and lead-verification workflows to improve downstream CRM reliability.