Project Manager Customer Service

David B. Johnson *** East Berkley Lane, Hoffman Estates, IL 60169

[pic]

*************@*****.*** . Cellular 847-***-**** . Home 847-***-****

Summary

To obtain a career opportunity within an organization where I can utilize

my extensive experience in all facets of purchasing and forecasting.

Experience

OfficeMax Inc., Naperville, IL

10/2008 to Present

Demand Planner

Responsible for forecasting and replenishment of 3000 sku's of office

supplies for 3 national warehouses that support 930 retail stores in the

US, Mexico and Puerto Rico; maintain a 98.5% fill rate and 3 turns

annually; work closely internally with Merchandising, Logistics and Stores

to make sure high fill rate is maintained and externally with Suppliers

collaborating weekly on forecasting and upcoming promotions.

Currently use SAP and Manugistics

Sara Lee Inc., Downers Grove, IL 11/2005 to 10/2008

Demand Planner

Objective was to establish a collaborative forecasting process between

Demand Planning Sales, Marketing and Operations for 2900 Coffee sku's.

Develop a statistical baseline forecast by researching and understanding

one-time demand spikes and promotional history.

. Project manager for the warehouse closing and redistribution of 23

million pounds of Coffee annually.

. Project manager for New Orleans Louisiana hurricane & California

earthquake contingency plans.

Used J.D Edwards and ForecastX Wizard forecasting tool.

Omron Healthcare Inc., Bannockburn, IL 4/2004 to 11/2005

Supply Chain Analyst

Create Sku level forecast for 150 healthcare related items by developing

relationships with customers to understand current trends and future needs;

Analyze history and past promotions; Research and smooth one-time demand

spikes; Meet internally with Buyer and Sales to review forecast; Work with

Customer Service to help solve any back order situations or customer

issues.

. Project manager for the implementation of Futurion forecasting and

replenishment system.

. Implemented collaborative forecasting process between Supply Chain,

Sales and Customer Relations.

. Provided forecast for and oversaw production of promotional displays

for key customers.

Wilton Enterprises, Woodridge, IL 12/2003 to 4/2004

Demand Planner

Duties include forecasting for 3500 Sku's of bakeware and cake decorating

items for the grocery and drug

store channels. Create statistical Sku level forecast by developing

relationships with customers to understand current trends and future needs;

Analyze history and past promotions; Research and smooth one-time demand

spikes; Meet internally with Buyer and Sales to review forecast; Work with

Customer Service to help solve any back order situations or customer

issues. Used Lucas Bear and J.D. Edwards software in forecasting demand.

Fellowes Inc., Itasca, IL. 11/2001 to 11/2003

Demand Analyst

Responsible for forecasting demand for 700 Sku's / 6300 individual records

of Record Storage, Media Labeling and Office Desk accessories. Create

statistical Sku level forecast by developing relationships with customers

to understand current trends and future needs; Analyze history and past

promotions; Research and smooth one-time demand spikes; Meet internally

with Buyer/Planner, Materials Manager and Sales to review forecast; Work

with Customer Service to help solve any back order situations or customer

issues and involved heavily with annual budget process. Used Demand

Solutions and Oracle in forecasting demand

Homelife Furniture, Hoffman Estates, IL. 2/2001 to 7/2001

Replenishment Manager

Duties include the replenishment of 500 Sku's of furniture for 9 regional

warehouses throughout the United States as well as 700 Sku's for 5 express

stores; developed forecasts to help reduce inventory and increase annual

turns without hurting service levels; expediting late or crucial

replenishment orders; solved problems occurring with product / vendors;

open order reconciliation.

Webvan Group Co., Carol Stream, IL. 5/2000 to 2/2001

Buyer

Managed inventory and replenishment of over $10 million dollars annually,

including over 9,000 items; key member of a start-up team for stocking and

replenishing new distribution center; sourced product from vendors and

helped select assortment of product to stock; forecasted sales to determine

initial and replenishment orders; solved problems occurring with product/

items while replenishing stock.

Midland Paper Company, Elk Grove Village, IL. 4/1996 to 5/2000

Purchasing Supervisor

In charge of a 4-person department that replenishes 3 regional warehouses

while maintaining 95% fill rate and 12 turns annually. Work closely with

managers in all departments to understand and accomplish objectives; In

charge of item maintenance and cost files that are crucial to the

publication of a bi annual catalog, cd rom and web page; Purchased

commodity paper as well as envelopes.

United Stationers Supply Co., Des Plaines, IL. 1/1990 to 4/1996

Inventory Analyst

Responsibilities included the purchasing of 1500 Sku's of electronic and

office related supplies for 40 warehouses throughout the United States;

maintaining a 93% fill rate and 7 turns annually; forecasting; expediting;

item maintenance; open order reconciliation.

Centrella Grocers, Franklin Park, IL. 1/1988 to 1/1990

Frozen Food and Candy Buyer

Responsibilities included purchasing of 2,200 Sku's of frozen food and

candy for 250 Chicago area stores; maintaining proper inventory levels;

expediting late orders; vendor related problems

Warshawsky & Co., Chicago, IL. 11/1986 to 1/1988

Rebuyer

Replenished 2,500 Sku's of automotive accessories; forecasting;

expediting.

Education

Northern Illinois University, Dekalb, IL. 1986

B.A., Economics

William Rainey Harper College, Palatine, IL. 1983

A.A., Business Administration

Institute of Business Forecasting & Planning

Studying for CPF Certification (2 out of 3 exams completed)

Contact this candidate