Lily&Taylor
Ecommerce Merchandising and Brand Management
Aug to Dec 2025
New York, NY
- Independently built the brand’s Shopify store from scratch and took 300+ styles live with product copy, imagery, SKUs, sizes, and attributes
- Analyzed delivery and sell through by account and built allocation and replenishment rules to guide reorders
- Wrote SQL queries in Google BigQuery to pull sales, traffic, and conversion data for weekly reporting
- Migrated inventory data from a legacy MAS 90 system using a custom OCR script I wrote
- Set up promo codes and Klaviyo and Mailchimp email campaigns, A/B testing both and tracking results in Google Analytics
- Ran on page SEO with SEMrush keywords and alt text, and tracked rankings in Google Search Console