Brian Lofgren Email & Phone Number

Ft. Worth, Texas

• Monitor and maintain a $114 million a year retail sales department of incoming merchandise to identify Stock-Keeping Units (SKUs) and current inventory needs to meet desired inventory levels. • Distribute merchandise to 900 stores utilizing allocation software from 4R Systems based on individual store gross margin optimization and average rate of sale, SKU sell-through percentage and store contribution.• Attained a positive sales retail dollar increase of 7% and a positive gross… Show more • Monitor and maintain a $114 million a year retail sales department of incoming merchandise to identify Stock-Keeping Units (SKUs) and current inventory needs to meet desired inventory levels. • Distribute merchandise to 900 stores utilizing allocation software from 4R Systems based on individual store gross margin optimization and average rate of sale, SKU sell-through percentage and store contribution.• Attained a positive sales retail dollar increase of 7% and a positive gross margin dollar increase of 5% over the previous year.• Achieved and maintained a 99% SKU in stock rate.• Plan, analyze and execute merchandise distributions for new, promotional, seasonal and clearance merchandise by using appropriate allocations logic for each type of distribution to achieve the overall company sales and gross profit plan. • Through business analysis, interpret and anticipate seasonal SKU selling pattern to optimize product flow and replenishment methods using Hyperion Essbase, Enterprise Data Content (Pivot Table based data source) and APT (Applied Predictive Technologies) software. Define target inventory levels for promotional and seasonal events by analyzing and evaluating current sales history, trends and previous promotional and seasonal sales history.• Establish, monitor and adjust minimum and maximum quantity levels for SKUs at diverse store sales volume levels. Values are based on total and average store quantities, monthly average rate of sale, internal package requirements and minimum displayable quantities.• Compiled, prepared and analyzed departmental and SKU/store sales data for 900 stores to maximize sales, gross margin, sell-through percentage and SKU productivity. • Maintained and updated Teradata allocation reports utilizing SQL (Structured Query Language). Show less

Irving, Texas, United States

• Prepared, researched and reconciled physical audit worksheets to ensure store inventory accuracy.• Daily departmental responsibilities completed were maintaining daily audit schedules, Regional Grocery Store Inventory Service (RGIS) price file uploads and inventory freezes.• Communicated with Inventory Control on accuracy of Weekly Stock Status Report (WSSR), as well as, providing verification of WSSR adjustments through Final SKU Reports from physical store audits.• Identified… Show more • Prepared, researched and reconciled physical audit worksheets to ensure store inventory accuracy.• Daily departmental responsibilities completed were maintaining daily audit schedules, Regional Grocery Store Inventory Service (RGIS) price file uploads and inventory freezes.• Communicated with Inventory Control on accuracy of Weekly Stock Status Report (WSSR), as well as, providing verification of WSSR adjustments through Final SKU Reports from physical store audits.• Identified compliance issues for operations and loss prevention teams through detailed audit research for each store resulting in corrective action taken and improved store performance.• Partnered with Loss Prevention Department to monitor shrink reduction programs, as well as, report any irregularities discovered while reviewing physical audit information.• Exceeded the Service Level Agreement of 48 hours for completion of Footstar Athletic audits by 24 hours while improving accuracy of results.• Knowledge of STS software system, which is a product merchandising, inventory control and tracking system.• Knowledge of JDA software system, which is a Bill of Lading, inventory control and tracking system. Show less

Bachelor Of Science - Bs, Political Science And Government

Master Of Arts - Ma, Political Science And Government