Robert Petersen

Clarkesville, Georgia

770-***-****

ac85iw@r.postjobfree.com

url: www.linkedin.com/in/robclaypetersen

BUSINESS LEADER IN PROCUREMENT AND SUPPLY CHAIN TECHNOLOGY

Versatile and results-focused Supply Chain Professional with cross-functional experience in manufacturing, distribution, defense, and technology.

Special skills in IBM Cognos/SAP/Crystal-Business Objects (BOBJ) (SQL/Stored Procedures)-systems, modeling.

Special skills in procurement (defense and technology industries)

Known for engaged and approachable management style in fast-paced, global sourcing environments. Strong analytical and problem solving skills, adept in managing change and delivering profit improvement through the application of best practices and technology.

Database ERP/MRP (Deltek-Costpoint, AS400, Lawson, Kronos, SAP, Oracle, Manhattan-WMS, DB2, MS SQL Server-2012/2014-SSMS-SSAS-SSIS-SSRS)

PROFESSIONAL EXPERIENCE

Contract work: (from 06/01/2017 thru 10/22/2018) (Customer Service/Aerospace/Toccoa)

(from 04/25/2016 thru 02/17/2017) (Food processing Industry/Gainesville)

(from 08/24/2015 thru 01/25/2016) (Pharmaceutical industry/Gainesville)

(from 05/10/2015 thru 06/30/2015) (Manufacturing environment/Dahlonega)

Strong (advanced) SQL skills ( SQL, T-SQL/M-SQL) (in MS Sql Server 2012 and 2014 management studio environment) (relational database, local as well as remote access)

Qlikview and JReports (java-based) report writing/development/analysis

Crystal report writing/analyst (Crystal version 2011 and 2013)

Stored procedures (advanced) (creation/development/analytics)

Stitch queries (SQL) creation/development/analytics (multiple fact tables utilized/complex)

Working with various databases: SAP, DB2, Microsoft SQL Server 2012/2014, Oracle, Costpoint, Kronos, Lawson,WMS-Manhattan, AS400

working with the Supply Chain and Operations sector of Company (creating and analyzing cost sheet data, various forms of KPI's processes and indexes, etc) extracting raw data from SAP-mainframe as well as BI applications-utilizing:Microsoft Office and Project/Excel/Access (vlookup, pivot tables, macros, data source connections)

Robert Petersen Page Two

PROFESSIONAL EXPERIENCE (continued)

ANCONNECT, LLC, Winder, GA www.anconnect.net 2011 to 2015

(formerly: Anderson Merchandisers 800-***-****) (Distribution Center)

IBM Cognos and SAP-Crystal Business Objects-Report Writer/Analyst/Developer

Writing reports in Cognos/SAP-Crystal Business Objects software; mapped and wrote programs, created filters and parameters to provide customized reports for internal clients and suppliers.

Worked with Management team to identify and develop standard reporting metrics and standard reports for use by SCMS team to support Customer requirements.

Provided support to DB2-WMS/AS400/Kronos/Lawson (“system”) roll out with respect to Cognos and SAP/Crystal-Business Objects interface.

Worked closely with the management team to determine impact of changes in process and tools and adjust reporting and documents as needed.

Developed and assessed "what if" scenarios in DB2-WMS/AS400/Kronos/Lawson “system”.

Create reports with relational and dimensional data

Security cubes and other control objects; use control objects and their role in TM1; modify control objects to set and document TM1 properties and attributes; identify how control cubes manage TM1 security; use control objects to monitor TM1 performance

Working and development with Cognos Framework Manager

Utilizing SAP Business Objects with Sharepoint

Robert Petersen Page THREE

PROFESSIONAL EXPERIENCE (continued)

SELEX GALILEO INC., Norcross, GA www.selexgalileo.com 1999 to 2011

(formerly: BAE Systems) 770-***-****, ext #1107 "or" ext #1119 (Tel) (Defense/Aerospace)

Senior Buyer and Cognos Report Writer/Analyst

Developed, managed and carried out RFP/RFQ analysis

Strong negotiation and cost analysis skills (domestic as well as international)

Reviewed and provided recommendations for source selection in support of bid and proposal activities

Monitored purchase order status, resolving supplier performance issues and assisting in preparing associated modifications

Tracked and reported savings against budget and prior purchase activity, including cost avoidance

Maintained professional and compliant Procurement records in accordance with organizational procedures and government audit compliance

Responsible for meeting specifications and on-time delivery requirements of customers

Worked cross functionally to address quality, cost or manufacturing issues etc in a timely and effective manner.

Export compliance knowledge including ITAR

Responsible for collection, analysis, and reporting of company commodity spend, procurement responsiveness (cycle time), system & policy controls and vendor performance metrics

Responsible for the creation and maintenance of dashboards and procurement reports supporting the financial close cycle

Provide analytical and problem-solving support to the Procurement department with the goal of obtaining and gaining a better understanding of key operational metrics and data to support cost reduction initiatives, process improvement initiatives

Experience with managing ad-hoc report requests and/or report development projects

Javelin-program-the world's premier shoulder-fired anti-armor system (procurement of commodities for 3000-3500 units/assemblies during a five year period). Estimated procurement volume of ten million dollars during this time period; with cost savings of 10%-15% (based upon customer budgetary guidelines).

ELBIT SYSTEMS OF AMERICA, Tallahassee, FL www.elbitsystems-us.com 1992 to 1999

(formerly: Talla-Com Industries) 817-***-**** (Tel); 817-***-**** (Fax) (Defense/Aerospace)

Buyer/Senior Buyer

Responsible for working with suppliers on RFQs, purchase orders, and other procurement transactions.

As Database Administrator, developed customized reports in Crystal software to support internal clients and suppliers.

Worked with Procurement Management team to determine standard reporting metrics and standard reports for use by Procurement team to support requirements.

Robert Petersen Page four

PROFESSIONAL EXPERIENCE (continued)

Provided support to Oracle (also utilizing SAP R/3-release 4.0b for 1 year) roll out with respect to Crystal interface.

Worked closely with the management team to determine impact of changes in process and tools and adjust reporting and documents as needed.

Worked through "what if" scenarios in Oracle database.

Participated in major company initiative for United States Army, using MS PowerPoint, MS Project to support the SINCGARS (Single Channel Ground and Airborne Radio Systems) program.

SINCGARS-program (Single Channel Ground and Airborne Radio System) Combat Net Radio (CNR) used by U.S. and allied military forces (procurement of commodities for 50,000 radio systems during 6 year period). Estimated procurement volume of twenty-five to thirty million dollars during this time period; with cost savings of 15% (based upon customer budgetary guidelines).

EDUCATION

B.S., Mathematics, Florida State University, Tallahassee, FL

TECHNICAL TRAINING

IBM Cognos-8 BI Transformer:PowerCubes/Security Cubes-Control Objects/Design Dashboards/Ad Hoc Reports (32 CPE), 2011

IBM Cognos-8 BI Report Author/Programming (Report Studio, Query Studio and Analysis Studio) (16 CPE), 2008

IBM Cognos-8 BI Framework Manager: Designing Metadata Models and Advanced Programming (40 CPE), 2008

MS Access-Advanced with programming-Visual Basic (32 CPE), 2005

Oracle 8i Database Administration (40 CPE), 1998-1999

Advanced Purchasing Strategies-cost control/negotiations (40 CPE) (formerly: NAPM-now ISM), 1998

Novell Netware-3.11-386 series (Networking) (40 CPE), 1992

Programming Languages: C, SQL, Visual Basic

RFP/RFQ Development

Vendor Relations

Microsoft Office and Project/Excel/Access (vlookup, pivot tables, macros, data source connections)

Negotiation

Relationship Management

SQL and Visual Basic (T-SQL/MS-SQL), Stored Procedures-SSMS-SSAS-SSIS-SSRS

Cost Analysis

Quality Assurance

COGNOS (advanced) and Crystal Report-SAP Business Objects (BOBJ)/Qlikview; JReports (Java based)

Problem Resolution

Compliance

Database ERP/MRP (Deltek-Costpoint, AS400, Lawson, Kronos, SAP, Oracle, Manhattan-WMS, DB2)

Contact this candidate