Robert Wenger
New York, NY *****
Cell: 917-***-****
**********@*********.***
OBJECTIVE
Manager or Planner in a Supply Chain position - Stock Planning, Production,
Inventory & Forecasting analysis
PROFESSIONAL EXPERIENCE:
Oxford University Press (New York, NY) October 2006 - Present
Demand Planner, Inventory & Special Projects Analyst
Manage domestic and imported stock requirements from design to dock.
Utilize ERP, MRP and Excel tools to create forecasts and replenishment
scenarios and requisition replacement. Support company objectives for cost,
service and inventory levels. Liaise with design and marketing to verify
physical & financial requirements. Actively pursue cost reduction,
inventory optimization and process improvement. Work with stakeholders
daily to resolve production, bottlenecks, scheduling and delivery issues.
Constantly seek process and quality improvement and document process.
Ensure timely stock availability within inventory and margin targets:
Manage domestic and imported product, 6000 SKUs of $6 million inventory.
Develop and implement forecasts and lot sizing models to minimize inventory
Assist manufacturing controllers ensuring specification, margin &
production schedule
Monitor production schedule and assure delivery, adjusting priorities as
needed
Maintain material data & BOMs and resolve discrepancies in a timely manner
Identify opportunities to reduce costs & define, plan and implement
process:
Increased margin 30% on flagship product, leveraging UK branch production
contract
Re-developed production process taking advantage of domestic material lead
time bottleneck versus ocean transit lead time, decreasing overall lead
time from 9 weeks to 6
Decreased lead time for sister branch from 12 weeks to 12 days
Increased gross margin and vendor rebate from higher purchase order
quantities
Created process flow documents and instructions for Design & Production
Chaired international conference call with all stakeholders in supply chain
Briefed internal departments on process change
Support product across SOP and product lifecycle:
Review forecasts and financial requirements to determine first run
production quantities.
Chair weekly meeting with manufacturing to assess rush orders and
bottlenecks
Generate weekly and monthly reports on key metrics
Liaise with warehouse, logistics and inventory planning on delivery and
inventory issues
Present 12 month product performance retrospective to division and
marketing managers; Analysis of performance to forecast and resulting
stock/overstock position
Manage offsite inventory and materials as needed
Purchase third party vendor stock as needed
The Juilliard School Bookstore (New York, NY)
Technical Manager (2000-2006) & Senior Buyer (1997-2006)
Responsible for inventory control, POS system, year end physical inventory,
and financial and budgeting reports. Position also required training and
supervising a staff of eight in POS/Inventory system processes for record
creation, maintenance, ordering and receiving and closing procedures.
Support E-commerce system.
Inventory control and reporting
Oversee inventory receipt, stocking and invoice reconciliation
Review vendor statements to insure timely payment and reconcile
discrepancies
Direct year end physical inventory
Liaison to external auditors, responsible for final inventory financials
report;
Sales & inventory levels, COGS, profitability,
Generate markdown lists and pricing
Identify process improvement, create proposal plans and promote in a timely
manner.
Create templates in Excel and other software for workflow and reporting
Train staff and document processes for future use.
E-Commerce technical support
Project leader of a design team focusing on presentation and customer
experience
Primary contact to vendors, selecting and formatting featured product pages
Format raw POS inventory data for insertion into SQL database
Design and implement support tools for order fulfillment and back office
operations
Regular site maintenance, database updates and front/back end design
changes as needed
Senior Buyer
Purchase to support annual sales and inventory goals on $1.2 million sales
Drive sales through product mix and replenishment, ensure availability.
Primary supplier contact;
Negotiate promotional terms, pricing and co-op for product positioning
Maximize discount using supplier promotion and preferred ordering
scheduling
Shelf utilization optimization; planned obsolescence & new product
introduction
Generate markdown and closeouts lists and pricing within inventory rules
SKILLS:
Enterprise tools: SAP R3, BW reporting & analysis, APO forecasting
Inventory planning; MRP, forecast adjustment, reorder point, safety stock,
min/max ordering, lot size and forecasting methods.
Productivity Tools: MS Excel, MS Power Point, MS Word, Filemaker.
Excel analysis, forecasting and reporting using formulas, functions,
graphs, pivot tables, data import & export, etc. Filemaker interface
design, relational database design and scripting.
Database: MySql table creation and maintenance, query optimization
Operating Systems: Windows, Mac OS, UNIX
Certifications: APICS, expected completion in 2010
EDUCATION:
The Juilliard School, New York, NY BM, MM
REFERENCES:
Supplied upon request