Ayan Khan

Data Analyst

Urban Space

Jun 2024 - Present

Abandoned Cart Analysis - Data Collection, Cleaning & Trend Analysis: Identified a ₹6.1 Cr business problem by collecting and cleaning large datasets from multiple sources, identifying trends and patterns that had gone undetected, and presenting data-driven recommendations to leadership. Revealed 74% of abandoned carts were from new customers through structured data analysis, identifying a business opportunity that reshaped the acquisition and retention strategy. Uncovered a 38.2% drop-off at the payment page, tracing the root cause and driving a fix that improved conversion performance. Proposed regional Meta campaigns after finding Bangalore led abandoned carts with a 56% share, translating a data pattern into a clear, actionable business recommendation for stakeholders. E-Commerce Channel Ownership & Growth - Dashboards & Performance Reporting: Scaled Nykaa channel revenue from ₹6-7L to ₹19L per month by developing and maintaining automated Power BI dashboards that tracked channel KPIs and surfaced growth opportunities for leadership. Reduced commission from 25% to 8% plus logistics by performing ad hoc analysis to identify a margin opportunity, documenting findings clearly, and supporting a data-backed renegotiation. Reduced RTO by 10% by analysing operational data, identifying a trend, and collaborating with cross-functional teams to implement a measurable process improvement. Design Performance Analysis - Visualisation & Insight Documentation: Led the brand’s first design-level performance analysis across 4 major categories, going beyond category-only tracking to uncover winning design patterns. Found Warm and Cool colour palettes drove 75% of total sales (58K units in OND'24), influencing product development and shifting marketing toward top-performing designs. Process Automations - Saved 500+ Hours Annually via Automation with Accuracy: Built a Python script automating daily work for two employees, saving 24 hours monthly and 288 annually. Made a formula-led report for 10 channels to auto-track key KPIs, saving 15–20 hrs/month per manager.