Brandon Allsop

• Created the testing and research process utilized by the merchandising department • Managed the development and results tracking of 20+ pilot programs per year • Leveraged statistical testing theories and forecasting to analyze piloting results • Documented and published the standard operating procedures to be utilized by the organization • Created Power BI and Alteryx reporting to track the weekly results of the pilot • Facilitated monthly leadership updates regarding the results of active merchandising tests • Provide insights and recommendations for Ad hoc requests based on the analysis of POS data

• Leveraged large data sets from multiple sources to solve business problems • Managed the category and SKU level analysis of key departments across the enterprise • Recommended merchandising and strategic changes based on real time POS and Ecom Data • Utilized SQL, Microsoft PBI, and Alteryx to analyze and manipulate large and complex data • Created Power BI and Alteryx reports and dashboards to track KPIs and fulfill Ad hoc requests • Communicated insights to cross functional stakeholders, including senior level leadership

• Create seasonal, promotional, and replenishment purchase orders from 75 vendors • Oversee the inventory health of items from import vendors in 5 merchandise classes • Manage inventory levels across 14 warehouses and 3 import redistribution centers • Forecast projected demand for upcoming seasonal and promotional items • Communicate future inventory status to management and retailers, verbally and written • Utilize SAP for order creation, SKU forecasting and analysis, and maintenance purchase orders • Construct reports using SQL and Microsoft Power BI to answer inventory questions • Service retailers through inventory allocation, status updates, and manual sales orders

• Manage 36 accounts across Montana, Idaho, North Dakota, and South Dakota • Grow wholesale and retail sales across the territory • Constructed business to business strategies using Power BI • Analyze market and demographic trends to make informed business decisions • Utilize store sales data to plan for future merchandizing • Collaborate with retailers to improve operational efficiency within their stores • Communicate strategic and operational changes using verbal and written interactions • Assist retailers with short term and long-term business strategies

• Analyze promotional and sales data • Utilize SQL and Alteryx to analyze data • Assist in market segmentation to create individualized promotional emails and mailers • Participated in cross departmental business projects • Completed data mining projects on large data files • Constructed tables and visual representations of data

• Published an informative brochure for Wyoming members • Created original video content to inform and persuade members for critical campaigns • Posted original content for social media marketing on Facebook and Twitter • Connected with over 90,000 AARP members through social media and print marketing • Collaborated with national offices to create and expand marketing campaigns • Managed Wyoming’s “Take A Stand” campaign • Wrote articles and press releases to be published in statewide and regional newspapers • Participated in community outreach programs