Aaron Sever Email & Phone Number

South Lake Tahoe, Ca, Us

Ventura, California, Us

North America Pricing Manage ERP United States and Canada discount pricing for Pro, Ecommerce, and Retail channels Provide analysis of financial planning, sales, and pricing to Merchandise Financial Planning team (MFP) to determine retail outlet financial planLead promotional strategy in all Patagonia retail outlets in accordance with financial planData and ReportingCreated and manage North America Allocation Dataset for 37 Patagonia North America retail stores Forecast retail outlet product demand in Python and Microsoft ExcelBuild and maintain Tableau/Excel reports for KPI trackingQuery and transform data from Snowflake database using SQL, Tableau Prep, and/or Alteryx Model and analyze data using Python/SQL/Excel to derive Retail business insightsVisualize and present insights to stakeholders using Excel/Tableau/PowerBIRetail Planning & AllocationPlan seasonal North America Retail Outlet demand and supply forecast, allocation, and off-price product sale strategy in accordance with MFPForecasted sales plan and organized off-price sales under which Outlets achieved the 2 highest net sales for a fiscal year (FY23, FY24)Present insights and create buy-in with Retail Operations Management and Merchandising through clear communication of allocation, pricing, and off-price sale strategyOutside Vendor Buyer (Oct. 2020- Aug. 2022)Placed purchase orders based on sales and inventory for outside vendor product and ProvisionsCreated, managed and maintained outside vendor items, inventory and assortment in ERP systemWorked with Merchandising, Provisions and Books teams to allocate according to sales goals and inventory

Ventura, California, Us

Managed East Coast wholesale accounts ranging from $10K-$2.5 million in sales Analyzed data sets and built Excel reports for wholesale managers and sales representativesIntroduced new excel tool using VBA to automate previously time intensive process, preventing significant sales lossActed as shipping advisor to Dealer Service Specialty Department Analyzed supply chain shifts and adjusted dealer accounts accordingly