*** **** ******* **** ******* 586-***-**** C

Nashville, TN 37221 abl5f9@r.postjobfree.com

Noteable Skills:

Diverse and progressive experience in Working knowledge of area specific tools,

Sales, Marketing, Customer Service, Manugistics for Demand, Avaya Centrevu for

Operations, and Demand Planning. CRM Analysis, IRI for Customer Data

Proficient in all MS Office Applications. Analysis.

Project oriented and experience in ERP

Database Creation, Reporting and Querying environments.

experience in Qlik View, Business Experience trouble shooting and analyzing

Objects, AS400 Query, Access, Excel and root cause situations.

ODBC Reporting Tools

Professional Experience:

2006 - Mars Petcare US, Franklin, TN

Present Consumer Packaged Goods Company, Pet Products

Sales Reporting and Systems Integration Manager (2008 - Present)

Manage and Transition Sales Department Data and Reporting Environment

Serve as Lead for Sales in transition of Reporting for ERP transition from

legacy system. This effort involves collaborating on processes with other

Leads in functional areas including Customer Care, Finance, Supply,

Logistics and Demand Planning.

Manage analysis of internal data and system issues that affect reporting

standards and risk data integrity cross functionally by using multiple data

sources and resources to find issue resolution quickly and efficiently.

Manage hierarchies for Reporting and serve as Sales connect for hierarchy

development across company.

Manage development of new Reporting Tools for company wide use. Examples

include Daily Business Position, Sales Metrics Reporting, Customer Detail

Analysis, Indirect data allocation from third party Brokers and

Distributors, among others used for planning and customer management.

Automate reporting in Sales Analytics department to maintain time

efficiency and integrity. This effort has saved over 20 hours of the

analyst's time weekly.

Manage training of analysts on new tools, techniques and best practice

procedures.

Manage Sales Administration Procedures used in Trade Management System.

This effort involves customer set up, routing table set up, and customer

help desk support for check issuance for Promotions, Events and other Trade

Marketing payments.

Manage Vendor Relationship with outsourced programmers to assist with

report automation.

Demand Planning Manager (2007 - 2008)

Managed Reporting and Relationship between Global Demand and Internal Sales

Managed reporting for Demand Planning and provided reporting support to

Sales, including trend analysis, bias analysis, pricing analysis, customer

offtake versus shipment analysis, and product life cycle analysis at

several levels based on a bottoms up approach.

Served as Functional Expert, and participated in Global and Regional Demand

collaborative conference calls

Maintained reporting procedures in Manugistics to support Demand Planning

Managers using Manugistics exceptions and providing reporting solutions.

Provided support in analysis of issues with customers and products

affecting Demand processes, involving collaboration with Sales, Supply,

Customer Care, and Activity Management.

Managed data and process support for internal Account Planning processes.

Prepared documentation on processes and procedures for Demand Planning

Department use.

Sales Analyst (2006 - 2007)

Analyzed and Maintained Reporting for all Internal Departments and Key

Reports for Field Sales

Managed analysis of shipment and offtake data for internal and external

Sales teams

Transitioned and automated key reports from former reporting team.

Assisted in development of Standardized Daily Business Position to satisfy

Global Reporting needs.

Trained and provided technical support to fellow Sales Analysts with

Business Objects as current reporting tool.

Standardized hierarchy used in Sales reporting and created process to train

fellow Sales Analysts.

2005 - ClientLogic, Nashville, TN

2006 Telecommunications/Customer Service Management Company

Business Objects Project Analyst

Transitioned company to Business Objects as primary Reporting Tool

Analyzed and evaluated reporting needs at several company sites across the

US, India, Philippines and Panama.

Practiced advanced languages and reporting techniques in databases,

specifically Business Objects, to replicate reporting.

Transitioned all manual reporting to Business Objects, and travel to sites

to train and prepare the employees to use Business Objects.

Prepared training materials using PowerPoint, Word, and most often Adobe

Flash and Captivate.

Documented training to create and facilitate new processes across the

company.

Operations Reporting Analyst - Lead

Managed Operations Analysts in operations improvement initiatives.

Managed all Operations Analyst's in Operations Projects involving improving

processes and data analysis.

Created and implemented project plans in operations improvement

initiatives, using MS Project and TQM Excel tools.

Coordinated communication to internal company contacts in order to resolve

client issues.

Prepared and maintained statistical reporting using Business Objects as a

reporting tool for Oracle Data Warehouse.

Provided feedback to programmers to improve development and quality of

Oracle Data Warehouse.

Troubleshooted reporting issues for Decision Support Services.

Other miscellaneous supervisory duties.

2000 - JohnsonDiversey (formerly known as DiverseyLever), Southfield, MI and

2005 Racine, WI

Consumer Packaged Goods Company

Sales Analyst and Rebate Coordinator, Racine WI (2004 - 2005)

Managed sales data analysis and rebate payments for a large sales field.

Generated accurate and timely sales reports to be distributed to Corporate

Accounts, Distributors, and internal management on a Daily, Quarterly

Monthly, Semiannual and Annual basis.

Calculated and processed Corporate Account and Distributor rebates based on

sales, while improving process to reduce variability.

Took lead in revamping accrual process for rebate payments for over 250

Corporate Accounts and over 50 Distributors.

Communicated daily with customers, vendors, management, and sales

representatives that were directly affected by sales and forecasts.

Collaborated closely with IT to ensure accuracy, provide accurate and

successful EDI transmissions, and to improve and develop better queries for

easier data management and analysis in Business Objects and AS400 Query.

Provided daily assistance to ERP team to successfully transition sales data

and rebate process from AS400 to JDEdwards

Marketing/Sales Administrator, Southfield, MI (2000 - 2004)

Responsible for technical and administrative support for a large sales and

marketing department.

Provided monthly/ad hoc product sales reporting/analysis for Senior Level

Management from AS400 and Business Objects.

Managed Quality Assurance program for the Corporate Account Executives as

used to evaluate customer satisfaction and field service quality.

Created process definition materials (mostly in Visio) for Quality

Assurance program.

Reported/analyzed results of mail surveys, incentive programs, and

innovation sales programs to be reviewed and utilized by Senior Level

Management, using Access and Excel databases.

Assisted with new product and field incentive program launch materials.

Created Corporate level PowerPoint presentations for regional/new launch

meetings.

Handled other miscellaneous administrative duties (i.e. travel, meetings,

scheduling, ordering supplies, business card creation, etc.)

1997 - Global Fax LLC, Warren, MI and Reynosa, Mexico

2000 Telecommunications Company

Client Manager/Customer Service Warren, MI (1997 - 2000)

Responsible for technical support of quality initiatives.

Monitored Quality Control and Exception Processing of data entered by

vendors based in Mexico.

Managed data organization, reporting and analysis using Excel and company

authored software.

Conformed processes and procedures with major United States banks' auto

loan divisions.

Communicated issues necessary for software enhancements and development, as

part of a Quality Control program.

Performed other miscellaneous administrative duties, as requested.

Client Manager/Quality Control/Trainer, Reynosa, MX (2000)

Assigned to the Data Entry Vendor in Mexico assisting the QC Dept for a

training project through Global Fax (utilizing bilingual ability)

Assigned to the Data Entry Vendor in Mexico assisting the QC Dept for a

training project through Global Fax (utilizing bilingual ability)..

Implemented new procedures and materials for training purposes.

Developed projects involving production projections.

Organized areas that needed improvement and structure.

Trained local employees on-site in data operations.

Education:

Tennessee State University, Nashville, TN

Master of Business Administration, Supply Chain Management

Wayne State University, Detroit, MI

Bachelor of Science, Major: Computer Science, Minor: Spanish

Contact this candidate