Security Manager
Resume:
Garry D. Campbell
PeopleSoft Security
Cypress, TX 77433
**************@*******.***
Summary:
DOD Secret
Over 20+ years of IT experience with a full understanding of the Systems Development Life Cycle (SDLC) specifically within PeopleSoft applications starting from v6.0 and most recently v9.2
Experienced Team Leader and Manager for application development and Customer Support.
As a Security Architect designed complex security scenarios including permissions, roles and user IDs.
Technically proficient in Application Designer, PeopleTools, PeopleCode, SQL, on SQL Server, and Oracle
A Senior PeopleSoft Functional & Technical Consultant with expertise HRMS and Financial/SCM Security Best Practices.
Change Management (STAT and PHIRE)
Incident Management (Cherwell and SharePoint)
9.2 Fluid, Dashboard, and Workcenters
Big 4 Consulting Experience.
Oracle University- Fluid User Interface, PeopleTools 8.56, PeopleCodeSecurity 9.2, and Portal
Skills Summary
Programming Languages
Crystal/Query
SQL
Engagement Experience
Fit/Gap Analysis
Testing
Conversion
Audit documentation
End User Training
Configuration
Post Production support
Single Sign on (SSO)
Experience:
R2 Technology Mar 2018 – Present
University Texas Dallas & University Texas Systems
Security Administrator – UT Dallas
Upgrade 9.2 HCM and FI, Support 9.1 HCM, FSCM, and CS. PeopleTools 8.56. Manage application security across the entire PeopleSoft production and support environments. Create and maintain PeopleSoft security roles, permission lists and user profiles. Review current security configurations and discussed best practice guidelines in role-based, row-level, operator, query, definition, tree manager and process group security for all business processes. Assign security roles to user profiles in accordance with approved Segregation of Duties. Support for Duo's two-factor authentication (2FA). Utilize Cherwell, JIRA, and PHIRE for documentation and change management.
Security Administrator – UT Systems
Upgrade 9.2 HCM and FI, Support 9.1 HCM, FSCM, and CS. PeopleTools 8.56. Manage application security across the entire PeopleSoft production and support environments. Create and maintain PeopleSoft security roles, permission lists and user profiles. Review current security configurations and discussed best practice guidelines in role-based, row-level, operator, query, definition, tree manager and process group security for all business processes. Assign security roles to user profiles in accordance with approved Segregation of Duties. Support for Duo's two-factor authentication (2FA). Utilize Cherwell, STAT, and PHIRE for documentation and change management.
Ascension Health Aug 2017 – DEC 2017
Lead Security Administrator
9.2 HCM, Designed/upgraded roles and permission lists for 9.2 upgrade integrating new Fluid, Dashboard, and Workcenters. Act as liaison between the customer and the technical team, using teamwork and collaborative skills to Identify and validate business objectives, and generate solutions that align with Best Practices
Northwell Hospital/ALKU Jan 2017 – April 2017
9.2 PeopleSoft Security FSCM
9.2 Security FSCM 9.2. Created the Security approach documents establishing the PeopleSoft applications (Financials, SCM, Built S ecurity upload for mass change of outdated user id profiles to match new standards in a way that the user preferences and other config settings, i.e. requester info, did not have to be manually updated. Evaluate 9.0 standards and make modifications for new 9.2 standards. Updated Permission Lists and Roles. Identify and validate business objectives and provided solutions that align with Best Practices.
Pantex/ALKU
Lead Security Administrator July 2012 – Dec 2016
DOE Q Security Clearance.
9.2 Security FSCM and 9.2 HRMS. Created the Security approach documents establishing the PeopleSoft applications (Financials, SCM, and HRMS) security. Evaluate and modify permission lists, and role standards for PeopleSoft 9.2 utilizing best practices and segregation of duties (SOD). Designed security for FSCM and HRMS upgrades to 9.2 and provided SME’s and users with Security Matrix in Excel for automating load of Permission Lists and Roles, verification of access to PS applications and documentation for Audits. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Implemented SSO to PS IHUB utilizing LDAP as source for account activation/deactivation along with dynamic roles to provide general user access. Act as liaison between the customer and the technical team, using teamwork and collaborative skills to Identify and validate business objectives, and generate solutions that align with Best Practices.
Green Mountain Coffee Rosters April 2012 – June 2012
Lead Security Administrator
Financial 9.1 Security for GMCR PeopleSoft Project. Created the Security approach documents establishing the PeopleSoft applications (Financials and SCM) security. Design/create permission lists, and role standards for PeopleSoft 9.1 utilizing best practices. Designed security provided SME’s and users with Security Matrix in Excel for automating load of Permission Lists and Roles, verification of access to PS applications and documentation for Audits. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Act as liaison between the customer and the technical team, using teamwork and collaborative skills to Identify and validate business objectives, and generate solutions that align with Best Practices Design Business Unit Security in FIN and SCM.
Ascension Health April 2010 – Feb 2012
Lead Security Administrator
Implemented a PeopleSoft application security model in a large organization with multi-company model/configuration. FSCM and HRMS 9.1 Security for Ascension Health, Symphony Project. Created the Security approach documents establishing the PeopleSoft applications security. Design/create permission lists, roles (dynamic and statistic), and User ID’s for PeopleSoft 9.1 utilizing best practices. Designed security provided/work with SME’s and users to provide a Security Matrix in Excel for automating load of Permission Lists and Roles, verification of access to PS applications and documentation for Audits. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Work with IDM team to provide assignment of roles based on Job codes. Act as liaison between the customer and the technical team, using teamwork and collaborative skills to Identify and validate business objectives, and generate solutions that align with Best Practices Design Business Unit Security in FIN and HRMS. Design STAT security for migrations.
Deloitte April 2009 – Nov, 2009
Lead Security/Portal
Financial 9.0 Security and Portal Team Lead for NY State Government (FOCAS Project). Created the Security and Portal approach documents establishing the FOCAS PeopleSoft applications (Financials, EPM, Portal) security will be configured and security roles defined. Design/create permission lists, roles, and User ID’s for PeopleSoft 9.0 utilizing best practices. Designed security provided SME’s and users with Security Matrix for verification of access to PS applications and documentation for Audits. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Design Single Signon, integration with LDAP, Sun One’s Directory Server and STAT for migrations. Provided testing, guidance, and knowledge transfer to State employees that will maintain PS security.
Oracle Corporation June 2007 – January 2009
PeopleSoft Security Architect
Security architect for Higher Education, Aerospace and Manufacturing clients and designed/created permission lists, roles, and User ID’s for PeopleSoft clean up after implementation. Redesigned security provided users with Security Matrix for verification of access to PS applications and documentation for Audits. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Review Work Flow for issues after go-live. Provided documentation for managing Work Flow after go-live and trained user on Managing Work Flow.
Designed/created permission lists, roles, and User ID’s for PeopleSoft 9.0 implementations. Provided users/managers with Security Matrix for verification of access to PS applications. Breakout PS Query for users that can create public queries private queries, and users that are only allowed to process queries. Have experience working as a Security Architect within the PeopleSoft Campus Solutions, Financial, HRMS, and ELM modules.
Entergy Corporation April 2007 – June 2007
PeopleSoft Financials Consultant
Entergy Corporation was splitting Entergy Gulf States Utilities into two companies within the PeopleSoft Financials applications. Was responsible for designing the mapping process for the closing of one business unit and the opening of two new business units for its replacement. Defined the business requirements so that AR/Billing and Contracts will have a one-to-one relationship established and will return the appropriate business unit owner. Identify and document interfaces that may require modifications or testing for the AR/BI/CA modules. Provided Data Model such as: data flow diagram, entity relationship diagram and process flow.
Abeam Consulting, Irving TX November 2006 – April 2007
Manager Client Services
Review and Identify Improvements to existing processes. Inventory and assist with prioritizing improvements identified for a major security firm. Meet with functional users and managers to evaluate processes on current system (Win Team), identify deficiencies and plan for corrective action as either a PeopleSoft implementation or if the processes needed modified. Prepared documentation for presentation to the Board of Directors on action items that require action.
Accenture, Houston, TX February 2006 – November 2006
Manager Products/Health Life Sciences/ERP
Review and Identify Improvements to existing processes and operations. Inventory and assist with prioritizing all Improvements identified for a major financial institution. Assist in creating a schedule and associated work plan to support improvements implementation. Support questions and research items throughout the transition time period. Serve as day-to-day liaison to Center lead to assist in daily issue management focused on but not limited to PeopleSoft issues. Cost savings included 8 million a year and a reduction in force of 10. PeopleSoft Accounts Payable (AP) functional lead for 8.9 implementation for the state of Ohio with Commitment Control (KK). Lead functional “as-is” and “to-be” analysis and manage state and Accenture resources to accomplish implementation for 32 agencies.
CSC, Houston, TX May 2005 – February 2006
PeopleSoft Financials Consultant
Lead Financials V8.8 functional AP and PO, re-implementation for Covanta Energy Created System Design Lab documents, interviewed current and future users of the system. Specific responsibilities for the AP/PO implementation include:
Conduct workshops, hold interviews, and review materials to determine release scope and application requirements
Validate system requirements
Document and resolves project issues
Configure PeopleSoft applications
Coaches team members in configuration
Develop functional design specifications for customizations,
conversions, interfaces, forms and workflows
Perform as operational business process and PeopleSoft Application (SME)
Guide Covanta Super Users in the establishment of batch processing schedules
Guide Covanta Super Users in developing test scripts and scenarios
Develop Deployment Plans
Participate in unit, system, integration testing
Guide super users with User Acceptance testing
Nationwide Insurance
Developed security for PeopleSoft 8.8 GL & EPM. At Nationwide Insurance and provided documentation for the Focus Team on Security issues. This Documentation included detailed Permission Lists and Roles that was determined by the reorganization of the company and the creation of the Service Center for the company.
Analyzed requirements documentation from external SOX audit and meeting with the Internal audit Department to determine requirements. Created over 100 PeopleSoft queries that were identified as needed for new installed version 8.8 financials running on DB2. Identified issues with the configuration files as records exceeding allowed was common while processing queries. Researched and submitted resolution to the DBA.
MRE Consulting August 2002 - May 2005
Techno/Functional PeopleSoft Consultant
Worked at Ferrell North America during its implementation of PeopleSoft Financials V8.0 (AP, AR, GL). Designed procedures for tracking issues. Created new SQR’s and Crystal Reports and PS-queries to enhance user’s functions. Developed and prepared test plan/scripts for manual testing. Conducted System tests for release to production. Code migration between development, Test and productions. Execute the test scripts, logging defects. Resolved issues and problems for the Customers. Maintain Security for users and developed security report to satisfy SOX requirements. Apply PeopleSoft upgrades and patches. Configured/enhanced AP Check Printing. Developed new panels, Panel groups, and process definitions in PeopleSoft. Maintained PeopleSoft Security for AP, GL, AR, and PS Query.
LYRA Technologies – Mechanicsburg, PA January 2001 – August 2002
Lead PeopleSoft Consultant for one US Government projects, on and off site.
Lead PeopleSoft Consultant: Focused on maximizing the value of these applications to the U.S. Mint and its customers. Analyzed and reviewed procedures of the US Mint and made recommendations to re-engineer and upgrade PeopleSoft applications for PO, IN, AP, Workflow, and GL for PeopleSoft 7.53. Conducted weekly-status and problem resolution meetings with the Directors of Purchasing, Finance, and a multidisciplinary staff comprised of functional analysts, developers, and systems administrators.
Interviewed 100+ US Mint Staff located throughout the United States to gather requirements. Analyzed and evaluated their problems and issues and recommended installation of the PeopleSoft Budget module. Other recommendations include combining the Purchasing and Numismatics Departments as they were duplicating each other’s efforts and using the same vendors. Recommended specialized PeopleSoft Query classes for the end-users to enhance the use of data and make them more self-sufficient. Designed new accounting reports for to allow the users easier reconciliation of accounts. Designed, programmed, and tested a new interface in GL for FTE reporting in SQR.
Highmark (Blue Cross Blue Shield of PA), Camp Hill March 1998 - January 2001
PeopleSoft Financial Analyst
Worked as Financial Analyst for Purchasing, AP, GL and AM. Defined security and Workflow procedures. Designed and modified nVision, Crystal Reports and Queries utilizing PeopleSoft Query Tool for multiple Business Units. Designed SADBUS reports for the Purchasing department. Analyzed existing SQRs for enhancement, Designed layout for new SQRs. Team Lead for upgrade, made recommendations in breaking-up the work, work with team to coordinate test schedule, wrote scripts for testing and documentation for PeopleSoft Upgrade from v 7.5 to v 8.0. Performed GAAP analysis for v 7.5 to 8.0 upgrade. Prepare test plan/scripts for manual testing conducted System tests to release for production. Request code migration at the appropriate time. Execute the test, logging defects and working with business and developer to resolve them. Retest as needed. Obtain written sign-off on test results. Clear the code for migration to production.
Team Lead to upgrade PeopleSoft version 6.0 to 7.5. Prepare test plan/scripts for manual testing to test upgrade and Y2K compliant. Performed analysis for upgrade from version 6.0 to 7.5 for PO, AP and AM. Implemented Business Unit Security. Designed and developed new Views and Tables. Implemented and tested functionality of Express Check Processing for multiple business units. Designed new PL/SQL queries to enhance performance and achieve desired results. Provided consultation to BlueCross BlueShield subsidiaries for new implementation. Provided ad hock support to Account Payable, Purchasing and General Ledger. Identified potential problem area and suggested problem resolution related to PeopleSoft, Oracle 8i and PC/Network. 6.0 Implementation designed requirements for Purchasing, workflow, requisitions, and match rules for AP.
EUR Datacenter, Mechanicsburg, PA July 1996 - March 1998
Systems Analyst: Responsible for a wide range of clients, applications, hardware, Software and network. Designed new SQL queries to enhance performance and achieve desired results set up ODBC for clients for data transfer to and from mainframe to Lotus Notes, Excel and MS Access. Clients were:
L.B Smith (East Coast Quarry Operation):
Responsible for Accounts Payable, Notes Payable, General Ledger and Budget. Provided design and guidance for Y2K upgrade and DB2 changes for Y2K. Provided daily support for operations and monthly review of procedures and processing checkpoints. Bi-monthly review of customer enhancements and then provided design and guidance to programmers on changes and enhancements. Major changes included redesign of Notes payable on how interest was calculated. Setup ODBC and trained client to use with Excel and MS Access.
MCI Telephone:
Provided many systems upgrades and maintain CABs processing. Provided design and guidance for Y2K upgrade and DB2 changes for Y2K. Provided daily support for operations and monthly review of procedures and processing checkpoints. Review of customer enhancements and then provided design and guidance to programmers on changes and enhancements.
AT&T:
Maintained and implemented an upgrade to Rated Messages Returns (RMR) processing. FTP across multiple platforms to satisfy multiple processing requirements. Redesigned processing and checkpoints to allow for less operator intervention and for easier problem determination cutting programmer and systems analysis of issues to go from 20 hours a week to 1 hour a week.
Mifflin County School District, Lewistown, PA July 1993 - July 1996
Director of Information Systems:
As Director of Information Systems and Technology Coordinator supervised staff of computer operations, accounting functions (GL, AP and Budget), and Payroll department. Developed long-range plans School district. Established standards for future operations and implement PC technology for the administration.
Implemented survey software for statistical reports and surveys. Project Management on new software installations utilizing DB/400 and OS/400 for HR, Payroll, Budget, GL, and AP. Coordinated training for user personnel. Performs the development & administration of the HRIS, including upgrades, table maintenance & custom report generation. Project Management on implementing student software on the AS/400 to provide better state reporting for child accounting and other state reports, and install upgrades keeping with current version of software. Installed Ethernet connections and ISDN lines to the AS/400 to improve response time between the system and users in other buildings. Established training programs for new PC users in WordPerfect for windows and Excel for Windows. Provided Project Management on the Installation of the IBM AS/400 200 series to replace model B45. Developed a long-range plan for district operations, security procedures, job scheduling, backup and recovery procedures, end user support, and maintaining software revisions and updates to the operating system. Presented periodic updates to the school board.
South Western School District, Hanover, PA August 1989 - July 1993
Director of Computer Services:
Managed the computer operations of the School District and supervised General Ledger, Budget and Accounts Payable Department. Responsible for the integrity of data, quality control, and systems coordination. Guided and managed the District's Computer Operations on an IBM AS/400, and PC workstations. Project Management on new software installations for HR, Payroll, Budget, GL, and AP. Coordinated training for user personnel. Performs the development & administration of the HRIS, including upgrades, table maintenance & custom report generation. Project Management on the installations and operations of 2 NOVELL Networks with 128 workstations and a Macintosh Network of 32 workstations. Established training programs for teachers and computer coordinators. Trained computer users in WordPerfect, LOTUS 1-2-3, and query operations. Frequently called on by neighboring School Districts for consultation on installations, problem resolutions, and programming. Responsible for preparing and monitoring the budget for computer operations and repairs. Developed a long-range plan for district operations, security procedures, job scheduling, backup and recovery procedures, end user support, and maintaining software revisions and updates to the operating system.
Contact this candidate