Dianna M. March

*** ****** ****** abm29x@r.postjobfree.com Home: 815-***-****

Manteno, IL 60950 Mobile: 708-***-****

Sales Analyst

Accomplished analyst with 7 years' supplier experience handling key

accounts including Walmart and Sam's Club. Quick study and problem solver

with track record of success creating technical systems that streamline

forecasting, SSO's, and in-stock analysis - ensuring top sales performance

and revenue growth. Combine strong relationship building skills with

exceptional leadership, teamwork, and multi-tasking capabilities. Open to

relocation.

Areas of Strength & Expertise

( Strategic Analysis ( Retail Link ( SWAS ( Access

( Private Label ( Modular ( CPFR ( Excel

Products Presentations ( Publisher (

( Ad Hoc Reporting ( Sales Support ( Outlook PowerPoint

( Inventory Control ( Customer Relations ( Word

Professional Experience

Hosley International Trading Corporation - Lynwood, IL 2005-2009

Leader in home d cor industry with decorative and seasonal products

including reed diffusers, candles, and candleholders.

Senior Business Analyst / Category Advisor

Served on Walmart team, monitoring 200 SKUs in approximately 2500 Walmart

and Sam's Club stores, representing sales of $60M. Created and analyzed

weekly POS and PPS reports and audits of low in-stock items to achieve

100% store in-stock, sufficient modular presentation, and good feature

sell-through for departments 17, 52, 44, and 18 containing home d cor and

seasonal items.

Supported and managed setup of Form 33's, Price Change Forms, and order

writing (SSO) for low in-stocks, modular presentations, and features.

Provided Replenishment Managers with item recommendations, collaborating

to improve system forecasting and ordering strategies. Analyzed

individual store sales and assisted senior sales staff with

presentations.

> Analyzed overseas PO process and created new item forecasting system,

significantly decreasing PO revisions / cancelations and minimizing

average stock levels from 40 WOS to 15 WOS.

> Designed and employed template for SSO's following Walmart's launch of

new 13-week home d cor modular set, improving Walmart in-stock levels

from 60% to 95% and reducing SSO development time by more than 83%.

> Streamlined analysis of in-stock levels, store outages, store counts,

damages, and POS quantity by enhancing forecasting books to eliminate

need for manual entry of Retail Link data into spreadsheets.

> Recognized need and teamed with Walmart Replenishment Managers to

decrease EDI transmissions 75%, resulting in a 1.25% freight factor

reduction.

> Enabled comparative analysis of item sales and fineline profiles by

designing and linking new workbook to forecasting system, enabling

accurate and swift identification of needed fineline updates.

> Key player in team's receipt of D19 Supplier of the Quarter.

Soraghan Moving & Storage - Tinley Park, IL 2003-2005

Moving services company and local franchise of Mayflower moving company.

Move Coordinator

Led daily operations including sales support, order registration,

scheduling, document preparation, and customer relations. Coordinated

preparation for trade shows and special events. Handled all additional

services for customers and provided critical support to drivers.

> Transitioned company from antiquated filing system to Access database,

making customer information readily available to all staff,

drastically improving service levels, and eliminating data entry

position.

> Championed more than $19K annual cost savings by bringing mailing

service in house, selecting local lead company that utilized Excel and

directing new mailing process.

> Orchestrated on-time delivery following abandonment of shipment,

swiftly recovering truck and contents to maintain customer

satisfaction.

Korsnas Packaging - Romeoville, IL 2002-2003

World's second largest multi-wall kraft bag manufacturer.

Traffic Coordinator

Oversaw all facets of inventory and production, developing and

maintaining order and item management system for all raw and finished

goods inventory. Directed shipping and receiving department, ordering,

quality control, production line scheduling, and accounts payable to

ensure efficient operations. Played key role in production planning and

worked with sales staff to fulfill customer requirements.

> Designed Excel workbook to house item specification sheets complete

with calculating function, advancing the order entry and data

collection processes while simultaneously reducing human error.

> Established inventory accuracy through the creation of raw materials

spreadsheet, tracking receipt and consumption of materials to minimize

product waste and simplify monthly inventory process.

Hosley International Trading Corporation - Lynwood, IL 1998-2001

Provider of home d cor and seasonal products including reed diffusers,

candles, and candleholders.

Merchandise Analyst

Supported sales by tracking sales data, preparing forecasts, creating

sales sheets for presentation to clients, and assisting sales team in

modular layout development. Set up and merchandised temporary and

permanent showrooms at trade shows. Partnered with overseas factories to

develop new products and met with buyers and key accounts such as

Walmart, Michael's, Garden Ridge, and Jo-Ann Fabrics & Crafts to present

products and promotions. Created and maintained company catalogue.

> Recognized need and implemented use of Excel to track sales history,

resulting in improved forecasting, ordering accuracy, and inventory

levels.

> Eliminated daily backorder checking by developing Access database that

included item arrival times and cross-referenced order numbers and

fill rates.

> Created Walmart claims processing system that resulted in the reversal

of $25K in debits in the first year.

Education & Professional Development

Indiana University Northwest - Gary, IN

BS Candidate - Criminal Justice (1 year)

Hosley International Trading Corporation

> Retail Link & New Category Roadmap Training

> Bi-Annual Summits - Departments 17 & 19

Contact this candidate