Back to Developers
Ankit Kumar Pandit

Ankit Kumar Pandit

Data Analyst

Delhi, India 85 · Excellent

About

Data Analyst with hands-on experience in SQL, Python, and Power BI. Worked on real-world datasets across retail, food, and telecom domains, performing data cleaning, analysis, and building dashboards to generate business insights. Strong in problem-solving and analytical thinking. Although my degree is in Cloud Computing, my coursework and independent project work are fully focused on data engineering, analytics, and machine learning — directly aligned with data analyst role requirements.

Skills & Expertise (35)

SQL Expert
9.0/10
7
Years Exp
Python Advanced
8.6/10
5
Years Exp
Power BI Advanced
8.4/10
4
Years Exp
CTEs stakeholder communication Window Functions Query Optimization Indexing Logistic Regression Random Forest Hypothesis Testing Probability Statistical Analysis Git GitHub Jupyter Notebook ETL Problem Solving Analytical Thinking Subqueries Joins Dashboard Development Data Visualization XLOOKUP VLOOKUP Pivot Tables Excel KPI Dashboards Power Query DAX Data Validation Reporting Business Intelligence Exploratory data analysis Data Cleaning

Work Experience

Data Analyst

Customer Churn Analysis (Telecom)

Apr 2026 - Apr 2026

Built churn analysis model for 7,043 customers with 78% accuracy and 0.847 AUC. Performed feature engineering and data validation to improve model precision by 12%. Developed customer risk segmentation to support targeted retention strategies.

Data Analyst

Superstore Sales Dashboard (Retail)

Mar 2026 - Mar 2026

Developed a 4-page interactive dashboard analyzing 9,994 orders using drill-through and dynamic filters. Automated data transformation and reporting workflows, reducing manual effort by 80%. Identified $207K revenue with $18K loss in Furniture category, improving pricing strategy.

Data Analyst

Pizza Sales Analytics (Food)

Mar 2026 - Mar 2026

Analyzed 21,350 transactions generating $817K revenue and built KPI dashboards. Identified peak sales window (5–7 PM = 31% revenue) and top-performing products (42% contribution). Optimized SQL queries using CTEs and indexing to improve reporting efficiency.

Education

Bachelor of Technology (B.Tech) in Cloud Computing and Automation - VIT Bhopal University

2022 - 2026 · India

Certifications

HackerRank SQL (Intermediate)

· 2026

Deloitte Data Analytics Simulation (Forage)

· 2026

Power BI Certification

· 2026

Interested in this developer?

Profile Score Breakdown

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

Profile Overview

Member sinceApr 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation