513-***-**** home

Melissa A. King 513-***-**** cell

**** ****** ***** ******, *******, OH 45150 abl33k@r.postjobfree.com e-

mail

http://www.linkedin.com/in/melissaking2010

Professional Summary

Strong analytical skills that include ability to translate user requirements into

functional specifications

Technical skills that include experience with SQL Query Analyzer, multiple ERP

systems including JD Edwards, multiple Demand Planning software solutions

Accomplished in Microsoft Excel, Word and PowerPoint

Software implementation and upgrade project experience including process mapping,

design, test script preparation, testing, documentation and user training

Ability to listen well, capture key concepts and summarize them succinctly and

accurately

Proficient at written and oral communication

Experience

A. C. Nielsen

2010

Manager, Client Consulting

Developed sales forecasts and written presentations

Consulted with clients

Analyzed consumer, in-market, and client marketing plan data

Created recommendations on whether to launch a restage product already in-market

Fifth Third Bank; Cincinnati, OH

2006-2010

Sr. Business Analyst

Gathered business requirements from users that enabled optimal vendor selection for

Private Equity investment tracking and reporting software and Fed Funds Portal

software

Created process flow diagrams for Private Equity, Fed Funds Portal, and

Securitization software implementations which identified business process changes

required as a result of software implementations

Led enterprise-wide business requirements gathering session for Risk Adjusted Return

on Capital (RAROC) Pricing Tool that will be used to qualify and price loans in

accordance with the associated risk and better manage the portfolio

Provided user support for Front Middle and Back office of Commercial (specifically

for FX and Commodities Trading) enabling users to execute effectively

Gathered business requirements for real-time feed of market data needed for design

of Derivatives Trading software implementation which facilitated more accurate

pricing of positions

Subject Matter Expert on Market Data interface for Foreign Exchange Risk Management

implementation

Participated in successful expedited 8-week implementation of Commodity Trading

Software which resulted in an additional $250K of business within the first 6 months

of implementation

Subject Matter Expert on HELOC, Auto and Auto Conduit Securitization Business

Process Workflow

Responsible for business requirements gathering, functional design, test design and

execution on implementations for Capital Markets Risk Management, Commodities

Trading, and Securitization applications

Worked with Development staff to build solutions that met user requirements

Wrote and executed unit test scripts to validate that solutions were working as

designed and met the users' requirements

Structuring functionality of Securitization software delivered on time with minimal

rework due to thoughtful unit test design and effective execution

Facilitated User Acceptance Test (UAT) meetings, managed issue tracking and

resolution, facilitated training

Sara Lee US Foods Supply Chain Division; Cincinnati, OH

2004-2005

Subject Matter Expert, Demand Planning--Software Evaluation Cross Functional Team

Achieved a reduction of 90% of Manugistics user views (screens) used for the Demand

Planner Role which will simplify upgrade/migration to other software as well as

standardize planning processes

Participated in the design of Sarbanes-Oxley compliant role-based security profiles

Created both high-level and detailed process flows to be used as basis for design of

upgrade or change in software application

Wrote functional specifications for various integrations between the Manugistics

SCPO module and other applications such as the ERP system that enabled the creation

of effective interfaces

Sara Lee US Foods Supply Chain Division; Cincinnati, OH

2001-2004

Demand Manager (2003-2004)

Demand Planner (2001-2003)

Achieved average item national forecast accuracy for Breakfast products of 71.1%

within first 6 months of forecast software implementation for Jimmy Dean Foods

Managed Manugistics go-live activities (such as data validation and process testing)

for three different divisions (Hillshire, BallPark, & Jimmy Dean Foods)

Managed multiple history reloads to support mixing center rollout and distribution

strategy changes

Documented procedures to develop a basis for training and standardization of

processes

Identified error in the way order history was being extracted from the AS/400 which

when corrected improved forecast accuracy

Developed new default parameters to address particular demand patterns that when

implemented improved forecast accuracy

Aided in the development and testing of integrations between the Order Management

system (JDE) and the Advanced Planning & Scheduling system (Manugistics) to ensure

delivery of effective interfaces

Documented processes and used documentation to train new Demand Planners and

Managers

Sara Lee Hillshire Farm Division; Cincinnati, OH

Production Planner (1999-2001)

Planned production of Ham and Deli products

Expedited delivery of Ham and Deli products

Managed intercompany transfer of raw materials and finished products

Managed disposition of obsolete inventory

Standard Textile Co., Inc.; Cincinnati, OH

1996-1999

Demand Planner

Managed implementation of forecasting software which included extensive PC to AS/400

interface

Designed automated report system of inventory management that standardized review

procedure, simplified transfer of planning responsibility and improved service

levels and inventory turns

Analyzed forecast performance monthly and prepared written reports detailing

significant variances which enabled process improvements

Collected and clarified forecasts from field sales representatives to improve

forecast accuracy

Created company-wide annual forecast used for capacity planning and S&OP

Used advanced Excel spreadsheet techniques to determine the appropriate product mix

and inventory level for new Midwest Distribution Center

Additional Experience

HVC, Inc.; Cincinnati, OH

Expediter

Borden, Inc.--PIP Division; Cincinnati, OH

Buyer; Purchasing Agent; Production/Inventory Control Manager

Education

University of Cincinnati, Cincinnati, OH

MBA Operations Management

University of Cincinnati, Cincinnati, OH

BBA Marketing & Management

American Production & Inventory Control Society

Achieved Certification in Production & Inventory Management

Community Involvement

Clovernook Opportunities for the Blind

Volunteer as "Friendly Visitor"

Cincinnati Nature Center

Volunteer

Contact this candidate