S

Sanjana Deo

About

Detail

Austin, Texas, United States

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Walmart
    Business Analyst – Sales Analytics
    Walmart
    Jul 2025 - Current (1 year 1 month)
    • Own category-level sales performance reporting across multiple product portfolios using complex SQL queries and structured KPI dashboards. • Designed centralized KPI framework covering GMV, contribution margin, sell-through, average order value, inventory velocity, and promotional lift. • Built SKU-level profitability analysis models to evaluate pricing effectiveness and margin contribution. • Developed cohort-based revenue tracking to analyze customer repeat purchasing behavior. • Created weekly executive business review dashboards used by merchandising and regional leadership teams. • Partner with merchandising to evaluate assortment rationalization opportunities using performance clustering analysis. • Built SQL-based anomaly detection
  • SkillGigs
    Business Analyst – Sales & Market Intelligence
    SkillGigs
    Jul 2022 - Jun 2025 (3 years)
    • Owned sales pipeline analytics covering lead sourcing, qualification stages, deal velocity, and conversion trends. • Designed Tableau dashboards tracking customer acquisition cost, deal aging, win-loss patterns, and regional pipeline distribution. • Built segmentation models using industry, revenue size, and buyer persona clustering. • Conducted territory performance analysis to identify underpenetrated market segments. • Created structured reporting templates for executive revenue review meetings. • Developed SQL queries integrating CRM data with marketing campaign metrics. • Performed churn driver analysis using service engagement and contract-level data. • Built customer lifetime value modeling framework for leadership forecasting. • C
Education verified_user 0% verified
  • C
    Certified Business Analysis Professional
    Ongoing
  • G
    Google Data Analytics Professional Certificate
  • D
    Data Analysis with R
  • V
    Visualization with Tableau
  • L
    Lean Six Sigma
  • W
    AI for Business
    Wharton
    Ongoing
  • I
    Master of Arts, English Literature
    Indira Gandhi National Open University, India
  • B
    Bachelor of Arts, English Literature
    Banaras Hindu University, India
Projects (professional or personal) verified_user 0% verified
  • S
    Global Sales & Profitability Analysis
    Select Analytics Projects
    • Built end-to-end sales analysis workflow from raw dataset cleaning to executive dashboard. • Performed regional profit driver identification using window functions and margin decomposition. • Created product category contribution analysis and ranking logic. • Designed interactive geographic sales dashboards with dynamic KPI filters.
  • S
    Customer Churn Risk Analytics
    Select Analytics Projects
    • Built churn segmentation dashboards using tenure, service level, and contract structure. • Developed risk clustering views highlighting vulnerable customer groups. • Created retention opportunity tracking panels for business teams.
  • S
    Workforce Analytics Dashboard
    Select Analytics Projects
    • Designed headcount movement tracking system by department and tenure band. • Built attrition pattern visualization for HR leadership planning. • Structured KPI cards highlighting hiring vs attrition balance.