Shahrukh Khan

Shahrukh Khan

Senior Data & BI Analyst
UAE
English
Full-time Hybrid

About Me

Senior analyst with 6 years of experience at Tesco and Vedantu in retail, supply chain and sales analytics. I built the Tableau refunds dashboard from scratch, the Whoosh delivery on-time dashboard, a store health dashbo…

Experience

Senior Analyst – Data Analysis

Tesco · Bengaluru, India
Nov 2023 - Present · 3 years

<p>Built the Refunds Dashboard end to end in Tableau; findings led to a product being discontinued and new promotions.</p><p> Built the Whoosh delivery on-time dashboard, a store health dashboard and a DC shortage report.</p><p> Lead the ethical audit report for about 3,000 sites worldwide with 50+ KPIs and audit data from TQC and Sedex.</p><p> Support OTB, sales and stock forecasts, assortment, budget and target planning, and review packs.</p><p> Two Python automations used by other people save 100+ hours a year; a 90-minute weekly report is automated.</p><p> Present to senior leaders, including a 30-slide executive deck.</p><p> Led a team of 3 on a portal of 1,000+ reports; train new analysts and work with UK and Ireland stakeholders.</p>

Senior Learning Consultant

Great Learning · Bengaluru, India
Oct 2022 - Apr 2023 · 6 months

<p>Analysed customer and sales data to build reports and dashboards, contributing to a 15% improvement in conversion rates.</p><p> Tracked sales and conversion trends in the data and shared insights with the team to guide follow-up actions.</p>

Academic Counselor

Vedantu Innovations Pvt Ltd · Bengaluru, India
Nov 2019 - Aug 2021 · 1 year 9 months

<p>Built KPI reporting frameworks that contributed to 21% business growth.</p><p> Analysed the B2C sales pipeline from lead to conversion: stage drop-offs and lead source performance.</p>

Skills

Data Analysis Business Intelligence Tableau Power BI Looker KPI Reporting MIS Executive Presentations SQL Oracle Hadoop Alation Data Catalog Python Python Automation Excel VBA Google Sheets API Understanding ETL Star Schema Data Modelling Data Migration OTB Management Sales Forecasting Stock Forecasting Demand Planning S&OP Assortment Planning Fast / Slow-Mover Analysis Seasonal Planning Promotional Planning Budget Planning Target Planning WMS Refunds Analysis Whoosh Delivery On-Time Analysis Store Health Analysis Clubcard Loyalty Data B2C Sales Pipeline Analysis Ethical Audit Reporting Sedex TQC Contract Administration RFQs Supplier Quote Comparison Invoice Validation SLA Negotiation Requirements Gathering BRDs Functional Specs User Stories
Report this Profile?