Data Analyst with 1+ years in Business Intelligence & SQL/Python
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Highly motivated junior professional with 1.4 years of experience specializing in Data Analytics and Business Intelligence. Proficient in SQL and Python for data manipulation, statistical analysis, and machine learning model development. Skilled in building automated ETL pipelines, creating interactive dashboards with Power BI and Tableau, and delivering actionable insights to drive business optimization. Adept at identifying root causes of performance issues and recommending data-driven solutions. Seeking to leverage analytical expertise in a challenging data-focused role.
Lovely Professional University
B.Tech · Computer Science & Engineering
August 1, 2022 – June 30, 2026
Moonpreneur
Project Guide Intern
February 1, 2025 – Present
India
Dark Store Network Optimization — Geospatial Expansion Model
June 1, 2026 – June 1, 2026
Mapped optimal placement for 52 dark stores across Bengaluru, Mumbai & Delhi NCR using K-Means + Haversine distance on 501K orders, achieving max displacement of 0.545 km from actual positions. Surfaced 5 high-priority expansion zones via composite opportunity scoring and flagged 55.8% demand cannibalization in Bengaluru core - directly informing store placement decisions relevant to Blinkit, Zepto & Swiggy Instamart. Simulated a 500m store relocation for the Koramangala hub and quantified a 91% rise in avg. delivery distance, validating location sensitivity thresholds for site selection and SLA compliance.
View ProjectFood Delivery Intelligence System — SQL Analytics Engine
March 1, 2026 – March 1, 2026
Designed a production-grade normalised schema spanning 1M+ orders, 100K+ customers, 20K+ riders across 8 cities mirroring real-world food delivery platform architecture. Reduced query latency by 800× (5.7s → 7ms) through covering and composite index redesign with execution plan analysis - enabling operational dashboards to run at scale. Built RFM segmentation and cohort retention models to surface high-value customer segments and churn risk; engineered SLA breach detection and revenue leakage diagnostics from order-level failure patterns.
View ProjectE-Commerce Sales & Customer Insights Dashboard
February 1, 2026 – February 1, 2026
Built an automated ETL pipeline processing 100MB+ multi-table e-commerce data (sessions, pageviews, orders, refunds) - improving data quality and ensuring reproducible downstream analysis. Identified a 36% drop-off at Product → Cart via SQL funnel analysis; diagnosed a traffic-led conversion decline and flagged underperforming acquisition channels as root causes. Developed a 5-page Power BI dashboard (DAX-based KPIs) tracking Revenue, AOV, Conversion Rate, and Retention - surfaced mobile conversion lag and delivered channel optimisation recommendations.
View ProjectGoogle Cloud Data Analytics Associate Skill Badge
Google Cloud
June 1, 2026 – Present
Google Cloud Arcade Program
Google Cloud
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's academic projects are diverse, covering geospatial analysis, food delivery intelligence, and e-commerce insights, indicating a broad interest in applying data analytics to various business domains. The internship role, while not directly technical, shows experience in a structured, collaborative environment, which is positive for team integration. The focus on practical, real-world problems in projects aligns well with a results-oriented culture. The pursuit of Google Cloud certifications demonstrates a proactive learning attitude and adaptability, which are valuable for cultural fit.
Soft Skills & Operational Fit
The candidate demonstrates good organizational skills through managing student batches and monitoring progress in their Project Guide Intern role. Collaboration with content, evaluation, and audit teams indicates an ability to work effectively in a structured environment. The project descriptions highlight problem-solving and critical thinking in diagnosing issues like demand cannibalization and conversion drop-offs. The candidate's academic background and project work suggest a strong analytical mindset and attention to detail.