Robert Petersen
Clarkesville, Georgia
***************@*****.***
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)