SUMMARY

• Self - starting, detail orientated professional with over 16 years’ experience within Supply Chain, Analysis, Demand Planning, and Forecasting, working with large retail companies, such as:
• Walgreens, Confidential, Sears Holdings, Snap-On Tools and Eby-Brown. Holds a strong work ethic, and dedication to continuous improvement, and is able to utilize my well-rounded experience and leadership skills to assist teams in a growing company.

QUALIFICATIONS

• Forecast Analyst, Business Analyst, Inventory Analyst, Customer Service, Systems Support Analyst, Supply Planning Analyst, logistic Analyst
• Passion for learning, Effective time management skills, Manages customers’ expectations effectively
• Forecasting new product launches, Maintaining forecasting master sales data, Merging multiple sku data into sum total, Uploading forecast SAP, Pulling Sales SAP and other vendor web sites
• Forecasting tools JDA Manugistics 8yrs experience, Predictix, Mainframe ADR7, DOS, SAP training My experience is not limited to only teh retail environment
• Logistics Collect/Prepaid. Tracking Import/Domestic, Cubing trailers FTL,LTL Cross-dock, Stocking, Branch transfers
• Cut orders based off demand, OH/OO, Balance DC inventory, Work DC Returns, Miss-ships, Miss picks
• Microsoft Office- Advanced Excel skills including Sum/IF/IF-Error/v-lookups, Pivot tables, Mid/left/right, Graphs
• Microsoft Access - Open existing Databases, query data, create tables, Forms, Reports,

PROFESSIONAL EXPERIENCE

Confidential

Forecast Analyst

Responsibilities:

• Worked with several large customers such as: Advanced Auto Parts, Auto Zone, O’Reilly’s, Rayloc/Napa/Bendix/Canadian Tire Company.
• Forecasted demands to manufacture of Friction (Brake Pads ) & Steel (Rotors) lines of product (Brake Pads, Rotors and Liners)
• Collaborated with vendors on their forecasted needs (Advanced Auto Parts, Auto Zone, O’Reilly’s Canadian Tire Company
• Analyzed data/Monthly Collaboration based on POS sales versus customer projected 12 Month demands.
• Utilized advanced excel skills, Sum if formulas, compound v-lookups, Slope theory analysis, Graph presentation.
• SAP Forecasting, Sales analysis, Product Availability import and domestic.

Confidential

Demand Planner

Responsibilities:

• Responsible for Forecasting Beauty Cosmetics 8,000 stores
• Collaborate with beauty vendors/Merchants P&G Cover Girl, Neutrogena, Black Radiance, Kiss, IMAN, Cosnova cosmetic accounts
• Forecasting at item level - based off Retail, Events, Displays, Catalina’s, Loyalty, Price elasticity, Roto’s, Kickers
• Management of baseline Forecasts, Watch for Trends, BIAS, MAPE, Forecast to Sales performances
• Attended weekly S&OP review meetings
• Ad Readiness, Forecast to Sales, Incomplete Distribution Reports, Un cloned items, Forecast missed mark
• Supply Planner Tasks
• Work with DC’s and a vendor to arrange for product miss ships/damage or returns. Adjust weekly cut orders
• Create weekly high level inventory reports that were sent to Inventory VP’s /GMM’s/Directors/Managers/Forecasters

Confidential, Lake Forest, IL

Professional Support

Responsibilities:

• Global Data Management Research Analyst in teh Abbott Diagnostics Division
• GEMS Manage global database for RSM (Restricted Substance Material) Rohs and REACH
• PCN’s (Product Change Notifications) to TPM’s /OEMS.
• Worked with Abbott Mainframe, ALMS, and PSCP & MS databases data mining, extremely accurate record keeping.
• Documenting and Build of Materials from Database, & Drawings
• Projects: Canadian, Liquid / Reagents, CAS#’s and Ingredients using GEMGAS Global Database Systems
• Projects: GTIN, Product Change Notification, Create, Gather Data, Sort PDF’s, Access dumps, E-mail

Confidential, Hoffman Estates, IL

Senior Supply and Inventory Analyst

Responsibilities:

• Managed product categories with over $500M in annual sales
• Responsible for Floor care inventory in several categories (Sewing/Microwaves/,Canister/Upright Vacuums, Floor Extractors, Specialty Vacs, Vacuum Bags and accessories)
• Collaborated with 18 vendors monthly reviewing Forecast to Sales, Promotional Events, Product Transitions
• Consistently improved store in-stock from 95.5% in 2007 to 99.7% in 2010, while reducing non-productive inventory by 20% through 2011-2008.
• Replenishment to 2,000+ stores, managing transitions, vendor relations, forecasting and financial planning, financial analysis, exit plans, markdowns and promotional purchases
• Trained several new employees to become Analysts Special Promotions:
• Back to School buys, & DATG Special onetime buys or Promotional Events Seasonal buys

Confidential

Supply and Inventory Analyst

Responsibilities:

• Managed inventory from 12 international and domestic suppliers in support of business with sales over $195MM
• Improved forecasting accuracy by 72%, increasing sales by 18% and improving overall store in-stock, while reducing liability inventory
• Served as business liaison for multiple Sears formats, including Appliance Contract Sales Division, Hardware Stores and Sears Franchise Stores, for issues related to Sears Refrigeration; managing transitions working to ensure achievement of business goals