Summary
Overview
Work History
Education
Skills
Timeline
Generic

Kailey Castellano

Atlanta,GA

Summary

Proactive and motivated business analyst with 7 years of experience in e-commerce analytics. Skilled in utilizing creative strategies and advanced analytics to drive customer loyalty and brand performance. Excellent planning competencies and successful management of complex, high-priority projects.

Overview

7
7
years of professional experience

Work History

Senior Brand Advocate Analyst

The Home Depot
04.2021 - Current
  • Analyzed sales, conversion, online traffic, competitive landscape, and customer journey to provide actionable insights and performed A/B testing to determine strategic impacts on ecommerce performance
  • Monitored online traffic data to support SEO initiatives, drive product discovery, and reduce cart abandonment through strategic keyword placement and enriched product listings
  • Extracted and analyzed data from multiple sources, utilizing data visualization and story-telling methods to present complex data sets
  • Routinely presented customized business performance reviews and advanced analytics among cross-functional partners and key stakeholders
  • Coordinated with Product, RTA, and Customer Experience teams to develop optimized product, reporting, and analytics processes
  • Created comprehensive project plans, implemented best-practice models, and monitored milestone progress
  • Served as a subject matter expert and led training sessions for Item Data Management (IDM), troubleshooting, assortment groupings (SSKU), and enhanced analytics processes

Online Merchandising Analyst

The Home Depot
02.2020 - 04.2021
  • Supported assortment growth by developing streamlined onboarding processes, monitoring new product launches, and optimizing data accuracy, leading to a 73% reduction in priority onboarding SLA
  • Cultivated positive relationships with 150+ vendors through white-glove support for SKU creation and content optimization
  • Analyzed assortment growth data and historical sales trends and presented actionable recommendations to improve product offerings among Interconnected Merchandising teams
  • Managed high-priority ecommerce projects from inception to completion, including COVID Essential Items (PPE + Cleaning) project and Live Goods category launch
  • Coordinated with Merchants and performed individual market research to identify and secure new vendor opportunities within new and emerging categories
  • Served as a subject matter expert and established training sessions for assortment onboarding, vendor management, troubleshooting, and trend analysis

E-Commerce Account Manager

Southwire Company
08.2017 - 01.2020
  • Provided data-driven insights to internal Sales Managers and Demand Planners, assisting them in making informed decisions about their e-commerce strategy.
  • Managed multiple e-commerce accounts and conducted comprehensive analysis of sales performance, COG margins, OTIF rates, basket AOV$, and post-purchase metrics
  • Supported sales goals through assortment curation, channel management, SKU creation, PO processing, and copywriting
  • Maintained routine account reporting and performed ad-hoc purchase order analysis
  • Ensured seamless integration of new products into existing catalogs by working closely with inventory managers and merchandisers.

Education

Sociology

University of West Georgia
Carrollton, GA

Skills

  • Advanced Excel & PowerPoint
  • Google Big Query & SQL
  • Adobe Analytics
  • E-Commerce Analytics
  • Market Trends Analysis
  • KPI Reporting & Forecasting
  • Digital Marketing & SEO Strategy
  • Creative Content Optimization
  • Strategy & Brand Development
  • Stakeholder Relations
  • Project Development
  • Product Management

Timeline

Senior Brand Advocate Analyst

The Home Depot
04.2021 - Current

Online Merchandising Analyst

The Home Depot
02.2020 - 04.2021

E-Commerce Account Manager

Southwire Company
08.2017 - 01.2020

Sociology

University of West Georgia

Similar Profiles

CREATE PROFILE
Kailey Castellano