RW

Roger Willis

Regional Merchandise Planner · Sports Authority

Highlands Ranch, CO

In My Own Words

• Efficient analysis of sales, inventory and pricing performance utilizing 3 different database platforms (MicroStrategy, Access, & proprietary).
• Skilled in Microsoft Office including Excel; using pivot tables and formulas to efficiently create actionable reporting.
• Liaison between Region VP, District Manager and Buying team.
• Work closely with IT department to create field reporting.
• Created Regional reporting which was then adapted for company wide distribution.
• Member of Corporate Task Force to create and improve corporate reporting.

Work Experience

Regional Merchandise Planner

Sports Authority

2015 – 2016

• Manage communication between Merchandising, Planning & Replenishment (PAR) and Field teams regarding merchandise callouts, inventory levels and assortment changes. Meet cross-functionally with management to resolve issues and support the stores to drive sales. • Review New/Remodel Store inventory levels in relation to the targets to ensure targets are met prior to Grand Opening. Communicate merchandise needs identified. Review Ad-Instocks for the Grand Opening ads to verify in stock. • Review and analyze Region sales by store (3 Region’s 160 Stores $1.3 billion annual sales). Identify top performing items by store. Work with Planning and Allocation to replenish as needed to maximize sales. • Identify underperforming SKU’s by store, work with DM’s to transfer as needed to improve sales and minimize markdowns. • Created weekly dashboard performance review recap (using Microstrategy & Excel) to quickly identify top and bottom trends by Dept and Store. Dashboard recap rolled out thru the

Regional Director of Merchandise Assistant (Sales & Inventory Analyst)

Bed, Bath & Beyond

2001 – 2015

• Direct and review weekly store replenishment orders. Identify & communicate over / under builds for immediate inventory correction actions and coaching of store managers. • Provide ordering and sales guidance through trend analysis to Region (183 stores / over $1.4 billion in annual sales). • Work with Buying Office to identify and communicate down trending programs / SKU’s. • Regional reporting of special event and seasonal sales performance. • Responsible for timely collecting and accurate review of store space change requests, pushback inaccuracies and follow up with corporate to ensue updates are complete. • Review OH’s and direct movement of merchandise after disasters & special events. • Utilize advanced Excel skills to efficiently identify sales and ordering opportunities.

Pricing & Sales Analyst

driveoff.com (division of Microsoft's Carpoint)

2000 – 2001

• Evaluate eComm pricing across markets. Identify competitive issues and report to sales team to review with dealer partners. • Responsible for ensuring that dealer pricing is updated in system on new model roll out. • Publish quarterly sales performance, including evaluation of pricing on customer purchase decision. • Liaison between sales team and IT for system functionality enhancements. • Identify and provide performance reporting for call center management. • Create provide sales and dealer performance reporting for executive level management. • Provide ad hoc reporting to executive level management and corporate partners.

District Basic Logic Merchandise Manager (District Buyer)

JCPenney CO, Inc

1986 – 2000

• Responsible for building sales, managing inventory levels & Plan-o-grams for multiple locations across 3 states (16 stores over $27 million annual sales). • Create store assortments for Men’s reorderable merchandise. • Set annual sales goals, SKU minimum order points, plan merchandising direction to achieve sales and turn goals. • Using Excel, accurately forecast each store’s inventory position with calculated total District stock position 4 months out. • Utilize company database to research and purchase appropriate merchandise mix as well as manage inventory levels for 16 stores across three states. • Create store plan-o-grams using cad program to ensure proper set up at store level. • Analyze sales to quickly identify fast selling items in order to capitalize on potential. • Travel to stores to work with store management and employees to ensure proper set up of merchandise, identify presentation issues and train as needed. • Work with vendors to review new merchandise

Education

Bachelors

Eastern New Mexico University

1981 – 1985

Bachelors

Industries

BikeGolfDiveCreative AgenciesFashionFishingLifestyleMoto & PowersportsMusicOutdoorRunSkateSnowStreetwearSurfSwimTechTriathlonWakeYogaHealth & Fitness