Retail Analytics Specialist

Deepak Kumar Vemula

Data & Planning Analyst - Caleres

Transforming retail data into strategic insights. 4+ years analyzing $1.5B+ in revenue across Fortune 500 companies through advanced forecasting and performance analytics.

View Portfolio Get In Touch
0
Years Experience
0
Billion $ Analyzed
0
Brands Supported

About Me

Retail Analytics Expert specializing in demand planning and performance optimization

Hello! I'm Deepak Kumar Vemula, a certified Microsoft Power BI Data Analyst (PL-300) specializing in retail analytics. With over 4 years of experience at Caleres, Inc and other leading companies, I've analyzed $1.5B+ in revenue across 14+ brands.

I empower C-Suite executives and senior leadership with automated dashboards, SKU velocity analysis, category performance insights, and strategic forecasting using Power BI, SQL, Python, Excel, and SAP IBP.

My expertise spans demand planning, S&OP analytics, inventory optimization, and sell-through analysis—transforming complex retail data into actionable strategies that drive measurable growth in competitive markets.

Industry Expertise at Caleres

Currently analyzing performance across leading Caleres brands including Allen Edmonds, Sam Edelman, Stuart Weitzman, Famous Footwear, Naturalizer, Dr. Scholl's, Ryka and LifeStride, delivering insights that shape inventory decisions, pricing strategies, and seasonal planning.

Allen Edmonds Sam Edelman Stuart Weitzman Famous Footwear Naturalizer Dr. Scholl's Ryka LifeStride +6 More Brands

Experience

My journey in retail analytics and data-driven decision making

Sep 2024 - Present

Caleres, Inc

Data & Planning Analyst

Saint Louis, MO

  • Analyze weekly sales, revenue, margin, and inventory performance across 14+ brands for CEO and C-Suite
  • Track SKU velocity, style performance, and category selling trends across athletic, casual, dress, and comfort segments
  • Build automated Power BI dashboards for sell-through analysis, OH$, and TY vs LY performance metrics
  • Support merchandising teams with pattern selling analysis and Top 25 Styles reporting for seasonal planning
  • Partner with Account Executives to provide customer-specific insights for retail line reviews
Dec 2022 - May 2024

Sodexo (Starbucks - SLU)

Inventory Management Analyst

Saint Louis, MO

  • Implemented automated inventory tracking system, reducing stockouts by 20%
  • Decreased excess inventory by 25% through predictive analytics and demand forecasting
  • Streamlined weekly reporting cycles, reducing update time by 20% with lean analytics
  • Improved order accuracy and fulfillment speed through data-driven workflow optimization
Mar 2021 - Aug 2022

Capgemini (Morgan Stanley Client)

Data Analyst

Hyderabad, India

  • Built complex SQL queries and ETL workflows for enterprise healthcare and financial datasets
  • Automated reporting pipelines with Tableau, reducing turnaround time by 40%
  • Implemented data quality checks and validation processes, improving accuracy by 25%
  • Designed data models supporting KPI reporting and cost forecasting for HR analytics teams

Technical Skills

Specialized expertise in retail analytics and business intelligence

Retail Analytics

SKU Velocity & Style Analysis 95%
Category & Pattern Selling 92%
Sell-Through Analysis 90%
Seasonal Planning 88%

Analytics & BI Tools

Power BI & DAX 95%
Excel (Advanced) 98%
SAP IBP & SKYPAD 85%
Tableau 85%

Programming & Data

SQL 90%
Python (Pandas, NumPy) 85%
ETL & Data Modeling 88%

Planning & Forecasting

Demand Planning 90%
S&OP Analytics 88%
Variance Analysis 92%
Microsoft PL-300 Certification

Microsoft Certified: Power BI Data Analyst Associate

PL-300 Certification

✓ Verified

Featured Projects

Impactful retail analytics projects driving strategic decisions

Retail Analytics

Executive Sales Dashboard

Comprehensive Power BI dashboard delivering real-time sales, revenue, and margin analysis across 14+ brands with SKU velocity and style performance tracking for C-Suite decision-making.

Power BI DAX SQL SAP IBP
KEY IMPACT
  • Automated weekly reporting for CEO and SVPs
  • Reduced manual reporting time by 60%
  • Enabled data-driven decisions across $1.5B+ revenue
Inventory Planning

Inventory Optimization System

Automated inventory tracking system using advanced Excel and Python, reducing stockouts and excess inventory through predictive analytics and demand forecasting.

Python Excel Pandas Forecasting
KEY IMPACT
  • Reduced stockouts by 20%
  • Decreased excess inventory by 25%
  • Improved style assortment decisions
Retail Analytics

Category Selling & Pattern Analysis

Built comprehensive category and pattern selling reports for merchandise teams, tracking performance across athletic, casual, dress, and comfort categories with style-level insights.

Power BI SQL SAP IBP Excel
KEY IMPACT
  • Identified top-performing styles and patterns
  • Supported seasonal assortment planning decisions
  • Enabled category-specific pricing strategies
Demand Forecasting

Demand Forecasting Model

Built predictive models for demand planning and S&OP analytics, supporting pre-season and in-season forecasting across multiple retail categories and brand portfolios.

Python SAP IBP Excel Statistical Analysis
KEY IMPACT
  • Enhanced forecast accuracy by 15%
  • Supported $100M+ seasonal planning
  • Enabled proactive inventory decisions

Get In Touch

Open to new opportunities in retail analytics. Let's connect!

Location

Saint Louis, MO

Send a Message