Kelly R. Johnson
**** ****** ****** **. ******: 678-***-****
Marietta, GA 30008 Email: *************@*****.***
Professional Profile
A Supply Chain professional, with proven excellence in performance; an
established 10 plus years of experience in all aspects of Supply Chain and
Demand Management; Manufacturing, Imports, Retail and Transportation.
Successfully managed accounts in excess of $100 million dollar inventory
plans from forecast planning to store set. Implemented account transition
processes and established best practices using cross functional teams to
help lead the charge, driving errors down by 75%. Accompanied best in class
teams to transform vendor turn time, resulting in a decrease of 7 days by
establishing order days across all store markets.
Professional Experience
The mergis group 04-2011 /
Current
Coca- Cola Refreshments
Supply Planner II- Atlanta, GA
Provide support to the Chattanooga and Baton Rouge Supply Planning teams,
by ensuring all hot fill redistributed product is in stock and within
saleable dates at the warehouse facilities. Partner with the Supply
Planning Manager on all product and raw material requests from other hot
fill Coke plants; as well as request to other plants. First point of
contact for customer service, warehouse and transportation teams for all
CCR hot fill customer product load issues.
. Utilize SAP planning and forecasting modules to ensure timely and
accurate supply planning of all non-plant produced product into the
Chattanooga and Baton Rouge warehouse facilities. Creating optimal loads
at minimal cost.
. Weekly monitoring of two plant location inventories to identify issues
with product shelf life expiration; actively searching for faster
movement to minimize product write offs.
. Participate in weekly calls with the Chattanooga warehouse team and
Transportation to ensure timely resolution of all issues as well as
establishing action plans for future promotional planning and high peek
shipping seasons.
. Liaison between several customer service groups, Chattanooga, Baton
Rouge and the supply planning team, communicating all product stock
issues, product transition plans and discontinuations plans.
. Work closely with other hot fill facilities supply planners; responsible
for approving and completing all product requests as well as initiating
all sourcing request when needed.
. Responsible for all CCR hot-fill product orders; purchase order
adjustments and return delivery processes for the Chattanooga and Baton
Rouge supply planning teams.
. Responsible for establishing and maintaining all SAP system parameters
for redistributed product into the Chattanooga and Baton Rouge warehouse
facility.
Home Depot - retail
01- 2006 / 12- 2010
Central Automated replenishment - Atlanta, GA
Supply Chain Analyst-Domestic- Import
Provide analytical support to product merchants supporting
recommendations for merchandising plans, using current and historical
data; market and trend analysis for timely and flawless rollout
execution. Manage $120 million dollar inventory plans for well over
100,000 store item combinations during regular and seasonal profiles.
. Partner with vendors through a detailed on boarding process to establish
ordering parameters for new items into 2000 stores by using sister item
information coupled with both store volumes and item velocity level
grouping.
. Establish and managed viable relationships with vendors as well as stores
and internal partners to help maintain company sales goals, in-stocks,
safety stocks and turn metrics.
. First point of contact for stores, providing direction and insight on
current store inventories as it relates to store ordering parameters,
store merchandising plans and space constraints.
. Provide operational support for merchants and managers; execute stores
orders, tracking sales of all promotional programs during seasonal and
non seasonal times for future planning.
. Visit stores monthly to understand space planning as it relates to
minimum on hand quantities needed to maximize sales opportunity, minimize
inventory and to build strong store relationships.
. Monitor daily financials, of orders, reconciling with the open to buy
financials to make sure orders are within the plan.
. Managed a $55.1 million dollar import business into 11 US distribution
centers, for hard and soft flooring department with fill rates that
exceeded 98% consecutively for 10 months.
. Partner with merchant to develop and implement buy plans for new stocking
and promotional one time buy items.
. Collaborated with Import operations to ensure timely execution of
purchase orders for highly seasonal merchandise; establishing time lines
and benchmarks to support execution plans.
. Utilized international logistics to help with best shipping options for
extreme demand and late shipping containers
. Developed and implemented monthly ordering strategies for US distribution
centers which maximized container efficiency; reduced out of stocks by
25% and help to maintain fill rates targets.
. Partnered with store replenishment and field associates for everyday
allocation of product flow, as well as crisis management, in areas of
overstocks, shortages and promotional demand.
. Trained and managed 30 users in Logility Forecasting for Inventory
Planning and Replenishment team.
Master foods usa., a mars Inc. company 02- 2001 / 01-
2006
supply chain VMI analyst - Chicago, IL
Provided leadership in supply chain by managing a top domestic
distribution partner with sales plans in excess of $140 million dollars
over two categories, used daily sales data and seasonal profiles to help
establish forecast and future sales plans.
. Utilized IBM Vendor Managed Inventory systems to analyze customers'
perpetual inventories and sales information, including promotional
demand, to generate daily replenishment orders for customer needs.
. Negotiate viable alternatives to demand issues with manufacturing, supply
logistics and customers
. Collaborated with clients on business requirement definition and sales
plans, budget solutions for shortages and/ or overages.
. Delivered customized support by utilizing cross functional teams which
resulted in all goals exceeding expectation in areas of on- time delivery
and fill rates for heavy seasonal categories.
. Designed and analyzed statistical models using current and historical
sales data to establish forecast to help support service level goals.
. Utilized in house reporting for optimal planning decisions concerning
product movement and availability
. Work closely with Demand Manager to monitor inventory and production
schedules, assisting sales team with establishing and maintaining sales
goals, identifying issues and work around alternatives immediately.
. Assumed an integral part in establishing all safety stock levels using
turn frequency as the key component.
Education
1999 Associate of Applied Science in Marketing, Pellissippi State
Technical College, Knoxville, Tennessee
2005 Bachelor of Applied Science in Marketing, American Intercontinental
University, Atlanta, Georgia
2014 MBA, International Business, Strayer University, Atlanta, Georgia
Technical Skills
SAP Planning and Forecasting Modules, APO, SharePoint, Windows 98/2007/XP,
Microsoft Office Suite 2007, 2010 IBM Base Tables, Customer Service Systems
(CSS), Finished Goods Systems (FGS), Logility Forecasting System, DCM
Forecasting System, Micro Strategy Reporting, ProClarity Analytics
Reporting
Personal and Professional references available upon request