William R. Peterson

*** ********** ***

DURHAM, NC 27707

acvafr@r.postjobfree.com

919-***-****

OBJECTIVE

Seeking fulltime or contract position with an energetic company that will provide me the opportunity to share my knowledge, gain new skills and provide the desired deliverables for our customers.

Relevant Experience Summary

Cransoft Data Staging Warehouse, Cransoft DataGarage, Cransoft EZMap

Four years working with FI, CO, PM, SD and MM modules.

ERP Software: SAP R/3 4.6, 4.7, ECC6

Microsoft SQL Server 7.5, 2000 & 2005

FileMaker Pro 2010

Microsoft Windows 8.1, 8, 7, XP

Microsoft Windows 2000 Server

Microsoft Windows 2003 Server

Microsoft Office Professional 2007-2013, Office 365

Symantec Endpoint Protection and other virus/spyware products

Active Directory management tools

Apple OS X

Sequoia Inventory Management System

Professional Experience & Certifications - Summary

Apple Certified Mac Technician (ACMT)

Certified Apple Sales Professional

Certified Consultant in BackOffice Associates Data Migration Toolset and Methodology

TechEngage SQL Server Administration and Database Design using T-SQL Course – 3/2005

Introduction to ISO 9000 Internal Auditing at North Carolina State University – 4/2005

EXPERIENCE

Lead IT Specialist Feb 2014 - Present

Company Name, Duke University

Provide consulting services for laptops, computer peripherals and accessories in the Technology Center retail

operation, evaluate comparable computer peripheral and accessory products and make recommendations to

management as to which items to stock and at what inventory levels, taking into consideration compatibility with

computer hardware standards and other inventories products, stays abreast with emerging technology products through research and networking with IT counterparts.

Serve assistant to store manager as lead technical consultant

Consult with customers in person and on the phone to assess their needs for computer hardware, peripherals and accessories.

Provide first level technical support for Mac and Windows customers

Evaluate comparable computer peripheral and accessory products to determine which brand (s) to carry in the Technology Center, taking into consideration compatibility with computer hardware standards and other stocked inventory items as well as published industry reviews, make recommendations to management based on this data.

Assist customers with purchases of computer hardware, peripherals and accessories, including completing the sales transaction and taking payment at the register, also assist customers with purchases of USPS products and services, fully explaining options as needed.

Maintain current knowledge of emerging computer-related products through research, networking with IT counterparts.

Assist in developing strategies to maintain organizational standards and SOPs for in-store inventory management.

Provide customer service and technology training to coworkers

Sales Support Associate Oct. 2013 – Feb. 2014

Company Name, Technekes, LLC

Complete account related activities related to Agricultural, financial service, or non-financial service projects. Complete outbound/and or inbound calls to client customers and prospects. Communicate effectively with targets, peers, and management personnel, both through written and verbal methods and perform related work as required.

Complete assigned activities of the account operations function; directly responsible for maintaining a positive calling experience, and successfully reporting customer complaints and issues.

Ensure compliance with company policies and procedures.

Collect information from the target to meet account expectations

Process records through system appropriately, capturing and documenting appropriate information.

Proactively communicate risks or issues to management staff.

Business Consultant July 2004 - Present

Company Name, Peterson Consulting Group

Provide IT consulting services to small and midsized business in the RTP area in NC. Our focus is in assisting our clients in managing their master data by way of evaluating their current business processes, making determinations as to which areas need to be addressed, putting together recommendations for solutions then assisting in the planning and implementation of the solutions.

Services provided:

Business needs assessment

Hardware and software recommendations, installation

Data Profiling

Data Migration

Inventory Management Solutions

Cloud Software Solutions

Data Migration Consultant February 2008 – July 2009

Company Name, BackOffice Associates

Provided data dialysis and migration consulting services for the Cargill TARTAN project in Hopkins, MN. As a member of the BackOffice Data Profiling team I was responsible for providing the following deliverables:

Responsible for establishing ongoing communication with the Cargill technical staff for establishing successful connections to legacy database systems using ODBC connections when applicable and to resolve connectivity issues as required.

Profiled the data for over 80 systems and 400 instances within various legacy source systems such as J.D. Edwards, Maximo, etc.

Created databases in Microsoft SQL Server for each of the Source systems and imported each of the Sources into the Cransoft Data Garage repository.

Imported and analyzed the Source data in Cransoft Data Staging Warehouse

Utilized Cransoft Data Profiler to analyze all tables in a BackOffice database, including legacy source databases, and deliver vital statistic on every field in each of the tables.

Utilized Cransoft EZMap tool to facilitate and document the mapping process from legacy fields to their corresponding SAP fields.

Identified the Data Dictionaries in most of the legacy systems and created SQL database repositories to centralize the data.

Responsible for importing legacy data into SQL databases utilizing Microsoft SQL DTS packages, Excel spreadsheets and text files for the purpose of data analysis.

Work with Cargill Material Management Purchasing team members to provide analytical reports from legacy systems using Microsoft SQL Server to determine business relevancy prior to loading into SAP utilizing the BackOffice Cransoft Toolset and presented that data to the relevant business units for confirmation that the correct data was pulled and properly mapped.

Analyzed legacy data for the purpose of cleansing prior to migration into SAP

Created cleansing exception reports in Microsoft SQL and Cransoft Data Staging Warehouse from data retrieved from the legacy systems

Provided refresher training to Cargill team members in the areas of Cransoft Methodology and Cransoft rule writing.

Senior SAP Security Analyst June 2005 – February 2008

Company Name, IBM Global Services

Contract Senior Security Analyst to VF Headquarters in Greensboro, NC.

Worked with developers and department heads in two successful SD implementation and provided Pre and Post-Go Live support for the user community in the US and abroad

Provided security support for pre-divestiture system modeling and implementation

Participated in the successful four month pre-audit S-OX compliance project. This project involved the review and rework of the production system in order to eliminate SoD conflicts in role assignments

Successfully provided 24 hour Post Go-live support the client base

Managed security for development, quality assurance, sandbox, training, and production systems

Designed and maintained SAP user roles and authorizations for development initiatives

Worked closely with internal and external audit teams in providing information, assessing findings, and work with key stakeholders in understanding and resolving findings annually

Analyzed Segregation ofw Duties (SOD) conflicts and recommended action to remediate or correct the security level

Provided day to day leadership and support needs of the ID Administration team, developers, and managers. This included answering questions, enforcing standards, troubleshooting, training, addressing issues, and managing Sarbanes-Oxley (S-OX) compliance

Utilization of tools such as SAP Notes, Microsoft SQL Server, Microsoft Access & Virsa SAP Compliance Calibrator for detailed SoD analysis, monitoring & reporting of critical transactions conflicts within the Client’s SAP systems

Regularly completed successful quarterly remediation reviews for resolving Appropriate Access and SoD issues ahead of schedule

Responsible for developing SQL queries from SAP tables for the purpose of performing analysis on users, roles and t-codes

Performed quarterly review of mitigating controls in Virsa. Updated mitigating controls as required by S-Ox coordinators

Performed first level support and analysis of end user security issues called into the helpdesk

Founder - IT Business Consultant June 2004 – June 2005

Company Name, Peterson Consulting Group

Provided solution based technical consulting and training services to small to medium sized businesses

Provided systems backup, hardware installation and software upgrade services to a major temporary employment service

Provided local technical support for a major real-estate rental agency in whose IT support staff is located in London. Assisted in the successful problem determination and resolution of a communications failure that affected their local customer base

Participated in the upgrade of Dell kiosk equipment at various mall locations in N.C

Performed ongoing Windows XP desktop upgrades, wireless network installation and support, virus and spy ware detection services for SOHO clients

Provided ongoing technical support for various small businesses in the Triangle Area

Successfully installed wireless solution for a major children’s furniture store. This solution assisted in providing the customers the ability to make online design choices from inventory not displayed in the store

Installation of Linux Servers for testing / training facilities

Project Engineer March 2003 – June 2004

Company Name, Insight/KForce Staffing

Contract technical project engineer for a major financial institution. Provided engineering service for deployment of 5000+ new desktop systems as part of a national rollout team. Supervised multiple teams of technicians during deployment of new systems resulting in 100% accurate desktop installation

Established work assignments and deployment plans

Coordinated resolution with national command center issues that affected target migration deadlines

Supported migrations from MS Exchange 5.5 to Lotus Notes Email and Domino server applications

Implemented engineered solutions for migration of legacy desktop systems to Windows XP professional products

Configured Lotus Notes desktop application and provided end user desktop support for brokerage firms software applications

Developed migration strategies using automated backup and restoration scripts, ensuring accurate migration of desktop applications, databases, email and critical financial applications to new computer systems

Isolated and corrected issues with users network connectivity authentication, and software applications

Network Engineer/SAP Basis Admin November 1999 – March 2003

Company Name, Ajinomoto USA, Inc.

Responsible for the support of a customer base of approx. 150 clients in the Windows NT/2000 environment for a global manufacturer of pharmaceutical and food grade Amino Acids. Duties included evaluating, purchasing and installation of all network / computer related hardware and software on the plant site, client desktop support, developing training programs and to assist clients in the use of the computer systems, development of SOP procedures for the IS department.

Performed SAP Basis administration tasks such as user management, role building in order to support the manufacturing operation

Lead the project team to reduce international travel cost by implementing an ISDN based video conferencing system. The result was a savings in travel expenses of approx. $75,000.00 per year

Successfully led the Windows NT to Windows 2000 conversion project on 102 customer systems and 5 IT servers. Project completed ahead of schedule

Successfully performed upgrades of our Microsoft SQL Server hardware and software

Successfully upgraded our Microsoft Exchange 5.5 Server hardware and software

Successfully migrated all email clients to Exchange 2000

IT project leader for the successful system integration of a product weighing process into Microsoft SQL Server and an upgrade to NEMA4X compliant hardware platform that interfaced with Metler Toledo Scales system

In an effort to provide consolidated system management and reduced maintenance costs I successfully upgraded and consolidated IT department servers from 15 to 7

Established the IT Help Desk Hot Line for immediate response to critical problems thus providing our customer base with a more organized and timely response to service calls

Assisted in the testing and implementation of the Wireless Connectivity Infrastructure

Appointed as IS technical lead in the successful implementation of The Learning Manager training system used in providing ongoing cGMP and Safety related training to plant employees

Successfully implemented the use of Track-It! Call management software on the plant site

IT Consultant June 1997 – April 1999

Company Name, MJR Associates, Inc.

Contract Project Lead for software rollout to Guardian Life Insurance Company, NY

Successfully lead software installation team to rollout in house software to multiple locations throughout the United States.

Provided support to hardware rollout project team for the purpose of upgrading user desktop computers during software installation lulls.

Recognized by IT General manager for providing outstanding customer relations to the executive officers

Traveled to various agencies in the US to re-establish good customer relations with the IT department.

IT Consultant June 1993 – June 1997

Company Name, MJR Associates, Inc.

Contract Network Engineer to MetLife insurance, NY

Responsible for the support of a customer base of approx. 75 clients in the Banyan Vines / Windows NT environment. Our duties included evaluating, purchasing and installation of all network / computer related hardware, client desktop support, developing training programs and to assist clients in the use of the computer systems, troubleshooting end user problems and providing progress reports to management. I was later assigned to lead the support group for a special software development project in a satellite office

Assisted in the installation and training of the Lotus Notes Groupware system

Developed network maps and IT support guidelines in Lotus Notes

Site IT manager for special software development team

Successfully managed the conversion from Banyan Vines to Windows NT Server

Successfully converted network infrastructure from token-ring to Ethernet

Developed call tracking database in Lotus Notes to assist in the timely response and management of service calls

General Information

United States Air Force Reserves

1979-1985

NDT Specialist

Honorable Discharge

Citizenship

US Citizen

Contact this candidate