SAP Security, Data Migration, Data Management
Resume:
William R. Peterson
DURHAM, NC 27707
*********@*****.***
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