Kabir Malhotra
Data Analyst
kabir.malhotra@example.com
+91 98765 41028
New Delhi, India
linkedin.com/in/kabirmalhotra
Summary
Data analyst with practical experience using SQL, Python, Excel, and Power BI to clean complex datasets, build decision-ready dashboards, and explain performance trends to business teams.
Skills
Programming & querying: SQL, Python, pandas
Visualization tools: Advanced Excel, Power BI, Tableau
Analytical methods: Data cleaning, EDA, Descriptive statistics, Insight generation
Experience
Data Analyst Intern
Apr 2025 – Jun 2025
PulseMetrics Analytics
Remote · Excel, SQL, Power BI
- Standardized 120,000+ transaction rows across five regions for weekly revenue and retention reporting.
- Built reusable Excel templates with lookup and pivot logic, reducing reporting preparation by 42%.
- Developed four Power BI pages covering revenue, product mix, returns, and monthly performance.
- Partnered with six analysts and managers to define seven KPI rules and improve report consistency.
Projects
Subscription Churn Analysis · Python · pandas · seaborn
Mar 2025 – Apr 2025
- Analyzed 8,240 customer records to identify churn patterns by tenure, plan, and monthly spend.
- Engineered tenure bands and engagement features to improve segment comparison.
- Produced 12 visualizations and identified a 35% churn concentration among new monthly subscribers.
Regional Sales Performance Dashboard · SQL · Power BI
Jan 2025 – Feb 2025
- Joined four sales tables covering 32,000 rows and 18 months using documented SQL transformations.
- Built 11 dynamic measures with drilldowns for region, category, channel, and time.
- Found a 16% post-campaign decline in one region and presented a recovery opportunity.
Awards & certifications
- Power BI Data Analyst Associate — Microsoft (2025): Completed practical assessments in data preparation, modeling, visualization, and analysis.
- Advanced SQL Skills Certification — HackerRank (2024): Demonstrated advanced joins, window functions, aggregation, and query optimization.
- University Analytics Challenge — Finalist — Delhi Data Society (2025): Built a forecasting dashboard and placed among the top eight of 140 participating teams.
Education
BSc, Statistics & Data Science
University of Delhi, New Delhi, India
2022 – 2025
CGPA: 8.4/10 · Final-year analytics distinction
Resuvee · Professional