Data Analyst with 3+ years in data management & analytics.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented Data & Business Analyst candidate with 3.5+ years of professional experience in data management, MIS reporting, and ETL workflows. Proficient in SQL, Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, and Advanced Excel. Demonstrated ability to translate complex datasets into actionable business insights through 4 end-to-end analytics projects. Experienced in KPI design, data storytelling, trend analysis, and cross-functional stakeholder communication - with a certified foundation in data analytics (2025).
The iSCALE
Master of Data Analytics (Certification)
August 1, 2025 – June 30, 2025
Vatel Hotel & Tourism Business School, Sushant University
B.Sc. Hotel Management & Catering Technology · Hotel Management & Catering Technology
August 1, 2017 – June 30, 2020
Shushant University
MIS Executive / Data Coordinator
November 1, 2020 – November 1, 2024
Gurgaon, Haryana, India
Customer Behavior End-to-End Analytics
June 19, 2026 – Present
• Designed and executed a full end-to-end analytics pipeline: data ingestion, ETL, relational modeling, EDA, and Power BI dashboard delivery. • Cleaned and transformed 50,000+ transactional records using Pandas - resolving missing values, outliers, and schema inconsistencies. • Authored advanced SQL queries (joins, subqueries, window functions) to extract KPIs on customer loyalty, purchase frequency, and segment contribution. • Outcome: Identified 3 high-value customer cohorts accounting for 60% of total revenue; delivered interactive Power BI dashboard with stakeholder recommendations.
Zepto E-Commerce Inventory Analysis
June 19, 2026 – Present
• Restructured and normalized a retail inventory database - standardizing pricing schemas and resolving null/invalid entries. • Conducted SQL-based EDA to quantify pricing variances, stock-out risk, and per-category revenue leakage. • Outcome: Delivered gap analysis report with inventory KPIs covering stock availability, price variance, and category-level revenue contribution.
Hotel Booking Cancellation Analysis
June 19, 2026 – Present
• Analyzed 80,000+ guest booking records to isolate cancellation drivers lead time sensitivity, pricing thresholds, and deposit type patterns. • Outcome: Data-driven recommendations projected to reduce cancellation rates by 15-20% and improve revenue predictability.
Online Store Annual Performance Dashboard
June 19, 2026 – Present
• Built an interactive Excel dashboard with pivot tables, dynamic slicers, and trend charts to surface actionable marketing and inventory insights. • Outcome: Identified top 3 revenue-generating channels and seasonal patterns; informed inventory planning and promotional timing.
Cultural Fit Analysis
The candidate's project portfolio showcases a diverse application of data analytics across different domains (e-commerce, hotel bookings, online retail), indicating adaptability and a broad interest in problem-solving. Their pursuit of a Master of Data Analytics certification (even if future-dated) reflects a commitment to continuous learning and professional development. The experience in an MIS role with cross-departmental coordination suggests a collaborative approach, fitting well into team-oriented environments.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical thinking, problem-solving, and data storytelling abilities through their project descriptions. Their experience in standardizing data collection processes and coordinating with multiple departments suggests good organizational and cross-functional communication skills. The focus on delivering actionable insights indicates a business-oriented mindset, crucial for an operational data analyst role.