Suxiang(Anson) Sun

• Managed pricing for over 100 SKUs, including Retail and Wholesale covering 18 states.
• Simplified pricing process by data migration and automation
• Created tools to measure immediate profitability and quickly Identified areas for improvement on product acquisition cost, inventory repositioning and customer price level optimization.
• Closely worked with other teams (IT, Sales, Procurement and Product management), on pricing issues and process improvements.
• Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.

AutoNation Collision Parts, an Aftermarket Collision Part Distributor, Reported to Senior Director of Merchandising

• Led team of 3 that managed top 35 product categories of $43.5M in revenue rolling 12 months from 12 marketplaces; designed and created KPIs in Power-BI to monitor day-to-day business performance in areas of sales, returns, inventory turns and profitability.
• Successfully created Macro module in Access to convert collision industry catalog into ACES and PIES for NexPart, which represents 5% of company’s rolling-12-month revenue, and run monthly updates to manage SKU creation, supersessions, and ACES application extensions, so that broader coverage can be achieved with less SKU count.
• Developed Macro process in Access and guided team to use it daily to manage vendors’ new product announcements and quotations, and identify SKU additions, modifications, and financial impacts.
• Automated in Power-BI to monitor inventory turn ratio and identified $8.3M excess inventory with 0 inventory turns in 12 months; performed root cause analysis on slow moving items by vehicle ages, catalog interchanges, and pricing, then communicated findings to cross- functional team to follow up.
• Redesigned purchasing model and managed to increase purchase by 19.2% in quantity for SKUs with more than 4 turns per year.
• Created systematic way using Access form and Power-BI, to effectively and efficiently evaluate potential vendors’ portfolio based on SKU coverage and financial impacts which brought in 3 new vendors from Taiwan that generated on average 12-16% savings in COGS for specific product categories.
• Designed and Deployed assortment optimization process in Power-BI to turn on / off SKUs by market in assortment based on sales, market(CCC) strata, inventory turns, and Vehicle fitment in ACES, which shortens assortment review process from 40 hours to 1 hour.
• Automated Lost Sales tracking in Access form and Power-BI to quickly identify areas of opportunities lost to competitors that amounted to $8.8M YTD, 20% of revenue.
• Designed and implemented primary vendor calculation model in SQL, identifying “perfect” vendor for each SKU by market, based on scores and ranking of 5 factors : cost, lead time, Case Pack requirement, quality and fill rate.
• Built out systematic approach using AWS - Athena and Power BI to quickly identify new areas for product development by extrapolating industry demand(CCC) in different market segments, then forecast potential revenue stream which takes considerations of OE usages, aftermarket usage, market share scenario breakdowns.
• Effectively communicated with vendors overseas and domestically on product development and cost negotiations and played crucial role in communications between team and oversea vendors on critical issues; Successfully signed up 3 oversea vendors and 1 domestic vendor.

Automotive Aftermarket Heat Exchanger Manufacturer and Wholesale Distributor, for Automotive and Heavy-Duty Categories Reported to the Executive VP of the company.

• Responsible for 1580 SKUs of 1400 Automotive and 180 Heavy Duty, which generated $15M in revenue.
• Spearheaded in launching and developing its Heavy-Duty Cooling Product line that secured $6M in sales within 2 years, including 100 Class 7 and 8 vehicles’ radiators SKUs, 50 condensers and 30 charge air coolers.
• Developed VIN decoder integrated with ACES and PIES for both Automotive and heavy duty vehicles,.
• Designed and managed its B2B online catalog that is integrated with lookup features by application, interchanges and VIN decoding.
• Research VIO data and product life cycle to identify product to develop and ensure ROI in aspects of break-even quantity and profitability.
• Led its overseas product development team in Shanghai China, to prioritize development plans for US market, and keep them on track and budget.
• Communicate daily with vendors overseas and domestic to meeting 90% order fill rate.
• Worked closely with purchasing department to maintain optimal stock level and continuously fine-tune purchasing models.
• Worked closely with US sales managers on pricing, quality issues and products research.
• Analyzed market price to perform pricing review on quarterly basis and make necessary pricing adjustments for key accounts.
• Worked with US sales managers on national accounts programs to facilitate sales process; conduct customer product training sessions as well as ride-along sales blitz.
• Interpreted warranty return patterns by SKU to identify key quality problems, and discussed with overseas engineering team to find solution to improve on product quality.
• Established and maintained catalog built on ACES and PIES for automotive and heavy-duty products, which then can be published electronically