* Managed domestics & international import shipments and calculated logistics for upcoming products * Implemented in-transit report to visibility track all the shipments, coordinated with internal departments to monitor the shipments moving timely and troubleshoot delays * Analyzed selling report and inventory, coordinated with the Merchandising Team to identify hot/cold product and adjust the discount code to Maykke.com, Amazon, and Houzz monthly * Launched product monthly in E-commerce platforms in Shopify and Magento to monitor customer's promotional calendars, product price, and discounts * Collected the product compliance with federal and state laws, codes, regulations and consumer standard requirements

* Build visualization dashboards using SQL to optimize product category performance, identify consumer behavior trends and potential enhancements on merchandising plans * Analyze keyword search report in Algolia to improve SEO strategies and drive Customer Acquisition & Engagement, reducing search no-result rate from 15% to 7% * Provide ongoing data ad-hoc analysis to identify & translate business needs into operational requirements, to better understand user traffic sources, content performance, in-stock health, and consumption trends * Conduct customer behavior analysis to manage seasonal marketing campaigns and improve site experience KPIs such as visit, conversion, orders and margin in Google Analytics * Perform competitor analysis by collecting external marketing data, to optimize category pricing initiatives, improve profitability and develop promotional strategies * Propose A/B test ideas for landing page on the site to modify site taxonomy & product listing rules to better guide site traffic and improve customer shopping experience Show less

Conducted a weekly recap for categories in Home Office Furniture to find the core position and messages of margin performance for 10k+ products at Walmart/Jet/Heyneedle.com in ThoughtSpot-Managed site operation during holiday seasons by creating eye-catching visuals, content, bundles and collections to navigate customer’s site traffic, increasing the site visit year-to-date rate by 20%-Analyzed category performance and built dashboard in Tableau and Adobe Analytics to visualize key web traffic metrics to improve site visit, conversion, AUR & AOV in different channels-Performed keyword analysis in BrightEdge to improve customer search experience by optimizing product’s attributes, title normalizations and taxonomy Show less