Sales Project Manager

PROFESSIONAL SUMMARY:

I possess an extensive amount of knowledge, expertise and skill in Supply Chain Management, Logistics, Procurement, Inventory and Materials Management, Sales and Distribution, Production Planning and Finance. I have developed my knowledge and skill with over 11 years of hands-on experience as a Functional/Technical Business Analyst, Project Functional/Technical Lead and Small Project Manager.

SAP ECC 6.0 Enhancement Pack 7.1 environment (ERP), NCR DAX and DCR solutions along with JDA TMW, Cisco, Informix WMS, Manugistics, SQL and MS Access are just a few of the systems I know and use regularly.

I am extremely motivated, organized, thoroughly enjoy working in fast-paced, high-stress positions and projects and I am looking to advancing myself in the industry. I have been recognized for my achievements, proficiency, designs, projects and solutions to the companies’ automation and technology roadmap that have rendered higher revenues and lower labor cost.

TECHNICAL SKILLS:

SAP Functional Analyst – 11 yrs.

Quality Assurance Analyst – 13 yrs.

VB/C#/HTML/XAML/XML – 13 yrs.

Project Implementation Lead – 11 yrs.

Logic Design / Change – 11 yrs.

MS Data Querying / Analysis – 13 yrs.

Business Analysis – 13 yrs.

Project Management – 5 yrs.

SQL Data Querying / Analysis – 13 yrs.

Functional Writing – 13 yrs.

Systems Analysis – 11 yrs.

Read and understand ABAP and BAPI

Areas of Business Knowledge:

Logistics Execution

Shipping

Retail Store

Finance

Transportation

Master Data

Sales and Distribution

Warehouse Management

Finance

Procurement

Inventory Management

PROFESSIONAL EXPERIENCE:

Brookshire’s Grocery Company Tyler, TX

Senior Business Systems Analyst

Accomplishments/Achievements: Mar 22, 2017 – Jul 2006

SAP ECC 6.0 Implementation Project: Supply Chain and Logistics Functional/Technical Lead on SAP ERP implementation project responsible for the successful design, functional/technical documentation, testing and implementation of numerous interfaces and custom ABAP enhancements.

Perpetual Inventory Project: Functional and Technical Team Lead for PUR, IM and MM on Perpetual Inventory project. Responsible for identifying necessary interfaces and components, documentation for development of components, and DEV and QA testing of components to implement NCR DAX for retail forecasting and procurement. Forecasts all retail store orders to warehouses eliminating need for employees walking isles ordering with scan guns.

Help Desk Project: Project Manager and Functional/Technical Lead on FootPrints help desk solution implementation for use by 12,000 end users, over 200 retail stores, 6 warehouses and 4 manufacturing plants. Responsible for all project member activities and assignments, enhancement development, weekly update meetings with stakeholders and management, issues, and timeline status, coordination of resources for consulting and development, conversion of existing ticket and change order databases into FootPrints.

JDA Transportation Management Project: Project Manager and Functional/Technical Lead replacing Transportation Manugistics application with JDA TMW. Responsible for all project members, assignments, Interface development and completion of project on time.

McLane Distribution Project: Project Manager and Lead to discontinue warehouse inventory of all tobacco products, stamps, stamping machine and design and implement entire process for direct order from McLane Distribution cross dock daily incoming product from McLane to stores with deliveries for same day.

McKesson Pharmacy Project: Project Manager tasked with the design and development of new process to make pharmacy operations more efficient and generate more revenue while incorporating an ordering system from McKesson. Ensure strict NDC tracking and DEA reporting from McKesson to distribution center and on to retail stores. Resulted in first year revenue increase of $2.5 million dollars. Currently up to $25 million more in revenue last year.

Allocation Automation: Assigned to resolve issue of only being able to paste 12 rows of articles and sites in SAP Standard Allocation Program. Devised, designed and implemented an SAP ABAP custom program for uploading an Excel spreadsheet into WA01. Spreadsheets contain an unlimited number of articles (items) and sites (plants), is imported creating and saving the table in a single step from a selection screen. This enhancement resulted in the reduction of personnel solely committed to manually creating allocations by 95%. (From 50 employees to 3) Created batch job in SM37 that runs daily and generates the Stock Transport Orders with WA08.

Lost Revenue: Designed, documented, tested and implemented custom enhancement to update Purchase orders and Stock Transport Orders with new pricing conditions, warehouse allocation conditions, Count-Recount conditions, deals and agreements prior to delivery (Goods Issue) being generated. Resulted in the recovery of $1 million per year of lost revenue from incorrect pricing, deals and agreements.

RESPONSIBILITIES:

Project Planning: Develop initial project plan on small and medium sized projects to turn over to Project Management Department. Determine project size and time frame, Identify feasible and measurable objectives, develop project monitoring method for implementation progress, meet with and brief stake holders and gather input, establish initial project team including cross-functional members needed, identify required tasks and components, identify risks and establish risk management, establish backup system for project work and production, estimate skill levels needed as consultants and programmers.

Supply Chain Manager Stand-in: Stand-in for the Supply Chain Manager during times of absence, business travel or vacation. Attend all meetings briefing higher level management, directors, and VPs on progress status of projects, change implementation, change orders, group member’s statuses, and project or change deadline statuses. Conduct weekly SCM BSM group meeting with 14 members to ascertain their progress on assigned tasks and projects.

Analytics: Research and analyze procurement data to determine areas that need improvement. Design and suggest to higher level management possible resolutions to improve the efficiency and reduce costs while raising revenues on all procurement activities.

Research and analyze all Sales and Distribution data to identify areas in process and procedures that can be improved, changed or replaced with more efficient cost effective process workflows.

Segregation of Duties: Analyze SAP positions and security roles ensuring that personnel in SCM BSM areas of responsibilities are assigned the minimal number of roles needed to perform their duties. Ensure that each security role does not contain access to transactions that will allow them to complete a process at all points from start to finish. For example: Create a Purchase Order/Stock Transport Order, create delivery/goods issue, receive purchase order/post goods issue and create goods receipt.

Warehouse Management System: Research and determine cause of all failures in retail store ordering process by trouble shooting all interfaces from NCR DAX to SAP, SAP to WMS for load creation, WMS to SAP for Goods Issue/Goods Receipt posting, including ASNs. Make an effective decision and implement any corrections to resolve issues then reprocess or restart ordering, delivery, or posting processes.

Error Handling: Devise, document and support error handling procedures and methods for troubleshooting errors occurring in supply chain systems and procedures.

New store/Plant configuration setup: Configuration for Transportation Zones, Route Determination, Shipping Points, Shipping Conditions, Loading Groups and One-Step Automated Deliveries. Unloading Points (Delivery schedules) for all retail and warehouse deliveries.

Configuration Transports: Create configuration transports containing all development from DEV landscapes to Quality landscape for testing and then transport to Production landscape if no further configuration is required.

SAP Enhancement Service Packs: Organize, assign tasks and conduct the biannual testing in Dev and Quality Assurance for all SCM BSM transactions, interfaces, and enhancements via Panaya reporting any errors, bugs, or fixes needed prior to transport to production landscape.

Technology Advancement: Member of the “Technology Futures Roadmap” team responsible for seeking out new technologies, learning and demoing 3rd party software solutions and applications that will interface to or from SAP, DAX, DCR and other major solutions, increasing or enhancing the proficiency and performance of the “Technology Advancement Vision”. Install vendor demos, research, analyze and report to upper management all Pros and Cons of purchasing and implementing or seeking other solutions.

Allocations: Support all allocation table creation activities including purchase order and stock transport order generation. Trouble all table, PO, STO, delivery issues that Category Managers or Buyers may encounter, determine cause and immediately initiate a solution.

Breakpoint Resolution: Constantly work to improve the seamless integration of applications and workflow processes and/or decrease number of breakpoints in processes by eliminating them and improving automation.

Inbound Orders: Support all interfaces and enhancements used in the processing of incoming store orders. Ensure any errors are corrected and interfaces function properly generating STOs and Deliveries to WMS.

Outbound Orders: Monitor and support the outbound store order delivery processes ensuring interfaces function properly, errors are immediately corrected and all load close and goods receipts are generated and posted.

Written Communications: Write clear, concise and detailed Functional/Technical Specifications documentation for interface/enhancement development for programmers. Write BPPs, Business Process Procedures, Training manuals, Step-by-Step Instructional documents in a manner that they are easily understood by the end users.

Oral Communications: Schedule, prepare for, and conduct meetings with business owners, stakeholders and end users to gather needs and information on custom enhancements, interfaces, and programs to minimize or totally eliminate manual processes and procedures.

Consult and advise management and suggest new solutions and improvements to existing solutions by providing detailed reason, budget, resources, go-live forecast, functional integration and improvement and value-added over existing solutions.

Training: Train all end users and business owners as well as supervisors on all SAP transactions, enhancements, reporting, or other UIs they will be using on a regular basis.

Conduct classes to train “Subject Matter Experts”, SMEs, in the use of all application solutions they will perform daily tasks in. Write and supply detailed documentation as BPPs (Business Process Procedures) for their Step-by-Step instruction and use.

Conduct long-term training program with all new experienced hires, college graduates and interns for a period of 1 year per individual. Often training multiple individuals while still accomplishing own tasks.

Database Applications: Research, analyze SAP databases by creating queries in SQVI, export and break down data into smaller more manageable MS Access database Applications or SQL databases. Query using table joins, logical databases, and single table queries to retrieve data as raw data files for export.

Research large scale financial tables and design custom applications in SAP and NCR for use by accounts receivable, accounts payable, general ledger groups, and various other finance departments.

Testing: Effectively write developmental testing and quality assurance scenarios and UATs, implement complete “Start” to “Finish” workflow processes for inbound and outbound procurement, inventory, sales and distribution, logistics. Must be clearly and easily understood with minimal questioning by multiple groups for cross-functional testing.

Microsoft Access Database Application Developer: Developer for approx. 2,000 users. Designed, developed, tested and implemented databases for import of extracted table data from a number of different enterprise solutions for analysis and evaluation.

Help Desk Tickets: Monitor help desk browser for open tickets assigned to SCM BSM group. Self-assign open tickets and contact end user for information on issue. Investigate issue, gather information, troubleshoot, make a decision on resolution of issue and implement resolution in a timely manner prior to SLA expiration.

Fielding customer calls: Field multiple telephone calls from users seeking resolution to an issue. Open ticket for tracking and explain issue. Investigate, gather facts, and implement a timely resolution prior to SLA expiration.

Change Orders: Open change orders for all development work required and document all steps through the lifecycle of the change order. Design and refer development to programming team then test and transport to production. Close change order prior to SLA expiration.

Update Delivery Schedules: Any change request to the customers unloading points are implemented and tested prior to making changes in Production Site Master.

Big Data Analysis: Write queries in Microsoft SSMS and Tableau to perform analysis on large amounts of data. Export the results of the queries and import into MS Access databases or Microsoft Excel Workbooks. Analyze data for trends in retail purchasing, locate and determine cause of excessive product costs in procurement tables, search for illegal characters in fields causing errors or crashes, track and report procurement costs of products, expenses to procure, fuel price fluctuations, loss due to product damage, freight costs, etc.

SAP OSS NOTES: Responsible for researching any SAP bugs or defects in the applications standard programming and submitting OSS Notes in the SAP Network and submission of needed SAP OSS NOTES in the SAP Support Portal at: https://support.sap.com/home.html to include testing and transport of any OSS Notes applied to our areas of responsibility.

Vendor Managed Inventory (VMI): Support all VMI processes for Campbell’s, ConAgra, Johnson & Johnson and trouble shoot any IDOC failures, effect an immediate resolution and contact vendor to communicate again.

Master Data: Support all article failures in SAP by researching article configuration setup and identify any incorrect fields. Assign corrections to Master Data group for immediate correction and reprocess failed IDOCs.

On-Call Manual: Wrote and maintain the Supply Chain on-call manual containing all error handling resolutions to apply in HTML and JavaScript. Maintain manually by receiving all new processes and procedures from the group and update manual with them.

Local Applications: Write and maintain desktop application in Visual Basic using Visual Studio to reprocess failure XML files in NCR DCR.

Ability to read most programming languages with enough knowledge to understand what the code is performing. SAP ABAP, VB, C#, JavaScript, HTML, SQL, XAML, XML, SOAP, etc.

Ability to write intermediate apps and desktop applications in Visual Basic, CSharp, HTML, HTML/JavaScript, and Universal Windows Platform Apps in Visual Studio.

Brookshire’s Grocery Company Tyler, Texas

Transportation Specialist I - III July 2006 – June 2003

Transportation Specialist III - IV

Functional lead on Manugistics project to upgrade and reconfigure application. Optimized trailer weights, volumes, and routes configuration resulting in company owned tractor and trailer reduction as well as number of routes needed per day saving over $400,000 per year.

Designed, suggested to management and implemented process of backhauling. Leveraged the use of drivers returning from store delivery runs by sending drivers close to vendor locations empty and return to warehouse with loads of product eliminating the freight costs of the vendor using a third party to ship to our warehouses.

Configure Manugistics and Geocode new retail store locations in Manugistics maps establishing delivery routes and schedule windows to include in daily route planning.

Design, create and maintain specialized Microsoft Access databases to be used for statistical data in the efficiency of the routing department.

Design, create and maintain specialized Microsoft Access databases to be used for statistical and historical data on tractor and trailer usage, reefer and tractor idle times, and driver accident records.

Enter, track, and maintain all driver DOT information using XATA. Arrange and assign backhaul loads to routes and drivers coordinating through the appropriate vendors.

Calculate, process and submit to accounting, all driver payroll information each week using custom MS Access database and interface.

Import store orders from Order Porter, process and generate routes to all retail stores with scheduled deliveries for the day using Manugistics. Print Manugistics planners and determine the most cost effective route to be used by company drivers from the distribution center to the retail store. Edit routes in Manugistics by changing, moving, or deleting stops in the load building windows. Recalculate and export route groups for import into Informix WMS and Microsoft Access.

Transportation Specialist II

Import store orders from Order Porter, process and generate routes to all retail stores with scheduled deliveries for the day using Manugistics. Print Manugistics planners and determine the most cost effective route to be used by company drivers from the distribution center to the retail store. Edit routes in Manugistics by changing, moving, or deleting stops in the load building windows. Recalculate and export route groups for import into Informix WMS and Microsoft Access.

Design, create and maintain specialized Microsoft Access databases to be used for statistical data in the efficiency of the routing department.

Design, create and maintain specialized Microsoft Access databases to be used for statistical and historical data on tractor and trailer usage, reefer and tractor idle times, and driver accident records.

Transportation Specialist I

Import store orders from Order Porter, process and generate routes to all retail stores with scheduled deliveries for the day using Manugistics. Print Manugistics planners and determine the most cost effective route to be used by company drivers from the distribution center to the retail store. Edit routes in Manugistics by changing, moving, or deleting stops in the load building windows. Recalculate and export route groups for import into Informix WMS and Microsoft Access.

Brookshire’s Grocery Company Tyler, Texas

Security Officer I - III June 2003 – Nov 2001

US Army U.S.A and Europe

Military Police May 2001 - July 1991

Platoon Sergeant Schofield Barracks: Rank/Grade: SSG / E-6

Responsible and held accountable for the overall health, physical welfare and morale of 48 enlisted soldiers and 5 Noncommissioned Officers (NCOs).

Responsible for providing leadership, mentorship and training to all soldiers in the platoon.

Responsible for writing and maintaining all records of training, schools, awards, and disciplinary actions.

Responsible for mentoring 5 NCOs, equivalent to manager position, in their positions, training, and performing career counseling pointing out their achievements as well as short comings.

Responsible for conducting NCO training in their civilian equivalent positions and in their combat positions, responsibilities and tactics.

Report daily to the company First Sergeant and company Commander on all soldiers and NCOs activities, achievements, training status, personal status and deficiencies.

Write awards and commendations and submit to the Department of the Army for actions of soldiers going above and beyond their normal duty expectations.

Set goals both physically and academically for all soldiers.

Write official counseling reviews of the NCOs performance both military and personal and submit them to their permanent military record with the Department of Defense.

Held accountable for the condition, function, security and maintenance of 60 automatic weapons, 60 automatic pistols, 20 High Mobility Multipurpose Wheeled Vehicles (HMMWV), 30 Military Police civilian sedans.

Required to take disciplinary actions against any soldier that has failed to perform adequately after sufficient counseling and retraining or soldiers that have committed infractions of military regulations, established civilian laws or federal laws.

Stations: Ft. McClellan, AL / Augsburg, Germany / Fort Dix, NJ / Bosnia / Fort Knox, KY / Schofield Barracks, HI

Positions of Leadership: Team Leader / Squad Leader / Platoon Sergeant / Company Training Officer

EDUCATION:

Central Texas College

31 Semester Hours 1996 – 1998

Human Behavior

Human Relationships

US History

English

Law

Computer Theory, Computer Lab

CLEPS

DANTES

Tyler Junior College

Microsoft Access Intermediate Certification May 2012

Microsoft Access Application Development Certification July 2012

Microsoft Access VBA Programming Certification August 2012

United States Army

United States Army Military Police School May, 1990 to Nov, 1990

United States Army Military Police Special Reaction Team School Jan, 1995

United States Army Primary Leadership Development School June-July 1995

United States Army Instructors Course – (Fort Knox, KY.) 40 hrs. Jan, 1997

United States Army Basic Noncommissioned Officers Course Feb-April 2000

References:

Joel Turrentine Supply Chain Supervisor 903-***-****

Melvin Dean Project Programmer Lead 903-***-****

Tamie Haskins Senior SAP BI Analyst 903-***-****

Clifton Swindell SAP Business Systems Analyst 214-***-****

Transactions frequently used in DEV, QA or Production landscapes:

ME21N Create Purchase Order / Stock Transport Order

ME22N Change Purchase Order / Stock Transport Order

ME23N Display Purchase Order / Stock Transport Order

ME21 Create Purchase Order / Stock Transport Order (Old transaction)

MM41 Create Article (ECD Dev and ECQ Quality)

MM42 Chang Article

MM43 Display Article

WSL11 Evaluation of listing condition

WSO7 Display Assortment Module Assignment to Assortment

MASS Mass Maintenance

WSL1 Listing Conditions

WSL11 Evaluation of Listing Conditions

MB01 Enter Transfer Posting

MB1C Enter Other Goods Receipts

MB1B Enter Transfer Posting

MB03 Display Transfer Posting

RWBE Stock Overview Generic Articles

MMBE Stock Overview Sites and Plants

VKP3 Display Price Calculation

SPRO SAP Modules Configuration

MEKE Conditions by Vendor

VK13 Display Condition Records

BD20 Process IDOCs

BD87 Reprocess IDOC Failures

WSOA3 Assortment Display

WSL5 Modules in Assortment

WSP4 Create Individual Listing

WSO1 Assortment Module Create Material / Assortment

WSO5 Maintain Assortment Module

SE38 ABAP Editor

SM60 Edit / Display Tables

WPLG Display Article in Layout Module

WSK1 Assortments

WSP6 Delete Individual Listing (Material/Assortment)

WB02 Site Change

WB03 Display / Edit Sites

WSE4 Article Discontinuation ( Article / Site Discontinuation)

SE16 Data Browser / Display SAP Tables

SE16N Data Browser / Display SAP Tables

MD05 RP List

MD04 Stock/Requirements List Receipts

ME01 Maintain Source List

ME51 Create Purchase Requisition

ME52 Change Purchase Requisition

ME59 Automatic Creation of Requisitions

MIGO Goods Receipt for Purchase Order

ME13 Display Info Record

XK02 Change Vendor

XK03 Display Vendor

ME2L Purchasing Documents per Vendor

ME28 Release (Approve) Purchasing Vendor

ME29N Release Strategy for Purchase Orders (Approve)

VL06O Outbound Delivery Monitor

VL10B Fast Display Purchase Orders - Create / Collective Processing

VL01N Create Delivery

VL02N Change Delivery

VL03N Display Delivery

VL01NO Create Output Delivery without Order Reference

MEB3 Display Rebate arrangement

MEB4 Create Settlement Document

MEB1 Create Agreement Purchase Order

ME80FN Analysis of Stock Transport and Purchase Orders

ME81 Analysis of Order Values

MIR4 Display Invoice Document

VA03 Display Sales Order

WFFUART Substitutions

VF01 Create Billing Document

VF05 List of Billing Documents

VF02 Change Billing Doc

VF04 Maintain Billing Due List

XD02 Customer Display

WPER POS Interface Monitor

WE02 Displaying Created IDOCs

FB03 Displaying Accounting Document

WVFB Simulation Store Orders: Header Document

WA01 Create allocation Table: Initial

WA02 Change Allocation Table

WA03 Display Allocation Table

WA08 Create Allocation Follow-On Documents

WA09 Delete allocation table

WA11 Allocation Table Message Bundling / Notification Creation

WA31 Search allocation tables

WMBE Stock Overview Receipts

WA21 Allocation Rule Create

WAK15 Promotions per Site

WAK14 Promotions per article with Order Reference

VL06P Outbound Deliveries for Picking

WE20 Partner profiles and Sales Data

Frequent Tables for Research and Development:

MARA General Article Data

MEAN International Article Numbers (EANs) for Article

EINA Purchasing Info Record: General Data

EINE Purchasing Info Record: Purchasing Organization Data

T001W Plants/Branches

BDCP2 Aggregated Change Pointers (BDCP, BDCPS)

WLK2 Article Master Data SAP Retail / Part POS Control Data

WLK1 Listing Conditions SAP Retail Assortments

WRSZ Assignment of assortment user to assortment

WRPL Replenishment: quantities per customer/article

KNA1 General Data in Customer Master

KNB1 Customer Master (Company Code)

LFA1 Vendor Master (General Section)

LFB1 Vendor Master (Company Code)

WAKH Promotion Header Data, IS-R

WAKP Promotion Item Data

WAKT Promotion description short text, IS-R

VBRK Billing Document: Header Data

VBRP Billing Document: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VBFA Sales Document Flow

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBPA Sales Document: Partner

MKPF Header: Material Document

MSEG Document Segment: Material

ISEG Physical Inventory Document Items

BKPF Accounting Document Header

BSEG/MSEG Accounting Document Segment

MARC Plant Data for Material

MARD Storage Location Data for Article

MBEW Article Valuation

MARM Units of Measure for Article

MAKT Article Descriptions

MVKE Sales Data for Article

MLAN Tax Classification for Article

MAW1 Article Master: Default Fields and Special Retail Fields

EKKO Purchasing Document Header

EKPO Purchasing Document Item

LIKP SD Document: Delivery Header Data

LIPS SD document: Delivery: Item data

Contact this candidate