SUMMARY:

• 15 - year PeopleSoft Technical architect experienced on HRMS and Financial systems. Project responsibilities included both individual contributor and leadership roles on multiple full lifecycle projects.
• Completion of 20 HCM/FSCM upgrades from versions 7.0 to 9.2
• Installation and application of PeopleSoft technical tools, including PUM, Application Engine, PeopleTools, PeopleCode, SQR, Data Mover, Upgrade Assistant, Change Assistant, Query, and SQL to solve upgrade challenges and new development opportunities.
• Design, implementation and testing throughout the development and upgrade life cycle.
• Excellent written, verbal, and interpersonal communication skills to effectively work with project stakeholders at all levels. Work with functional, technical and management team members to provide guidance and knowledge transfer.

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Technical Upgrade Lead, Corcoran, CA

Responsibilities:

• Upgrade HCM from 9.1 PT 8.51.25 to 9.2 PT 8.55.13. Upgraded applications include HR Human Resources, PY Payroll for North America, TL Time and Labor
• Install and apply patches from HCM PUM 20, 21, 22, 23
• Set up and run Change Assistant jobs
• Stage 1: Upgrade PT 8.51.25 tools to 8.55.13 in Linux, Oracle 11g
• Stage 2: Migrate data to new Linux VM and upgrade to Oracle 12g
• Stage 3: Upgrade HCM 9.1 to 9.2
• The entire 3 stage process was repeated for four TMTP passes before go-live.
• Re-apply of all customizations
• Duties included Initial upgrade planning, set up of 1 physical PUM machine and 1 Upgrade VM, planning and creation of new production support environment (DEV, TEST, UAT), installing and patching new release demo database, installing entire PS software stacks on both Linux and Windows, running all upgrade passes, creating and maintaining availability of all new App Server, Web Servers, and Process Schedulers, evaluating compare reports, installation and use of PUM to identify and apply Tax Updates, Required for Upgrade patches, all outstanding patches as of PUM 21, and CA Upgrade templates.

Remote PeopleSoft Technical Support

Confidential, Tustin, CA

Responsibilities:

• Provide ongoing remote support for 9.1 HRMS Core. Duties include writing and correcting PSQUERY reporting and PSQUERY interface output files, TSQL and App Engine programs to create flattened data stores for reporting, additional edits for JOB DATA component, Database support.
• Modify PERSONAL DATA pages to accept iCIMS Applicant Tracking IDs. Created 5 complex SQL queries (up to 9 tables) to create weekly iCIMS interface files.

PeopleSoft Technical Upgrade Lead

Confidential, Amarillo, TX

Responsibilities:

• Upgrade PeopleTools from 8.51.25 to 8.54.19 in a highly secure environment with extreme separation of duties. Project was originally to be FSCM 9.1 to 9.2 upgrade, but staffing shortages reduced the scope to tools upgrade only.
• PowerShell/DPK installation and use of FSCM PUM19 to identify required for upgrade patches.
• Upgrade from Oracle 11g to 12c
• Set up and run Change Assistant jobs
• Train DOE personnel on use of Change Assistant

Application Development

Confidential, Chicago, IL

Responsibilities:

• Gather, define, and document requirements from end users
• Create 2 new AE programs to calculate Years of Service for different pay groups
• Create and execute test plan. Use Toad for database access.
• Create supporting Menus and Run Control Records
• Move components through Phire Architect change control process

PeopleSoft Technical Upgrade Lead

Confidential, Chicago, IL

Responsibilities:

• Upgrade HCM from 9.0 to 9.2 PT 8.53.19. Upgraded applications include BA Benefits Admin, EC eCompensation, ECM eCompensation Mgr Desktop, EF eBenefits, EL eProfile, ELM eProfile Mgr Desktop, EY ePay, HR Human Resources, PY Payroll for North America, TL Time and Labor
• Project included consolidation of previously acquired companies
• Set up and run Change Assistant jobs
• Installation and use of PUM 11 to identify and apply Tax Updates and Required for Upgrade patches.
• Integrate ongoing code changes from current 9.0 Prod and ongoing new target 9.2 development from offsite development team into the upgrade pass.
• IScript debugging using Google Developer Tools
• Modify delivered AE programs to correct deficiencies
• Develop SQL scripts for data cleanup
• Develop Excel spreadsheet and VBA scripts to generate Windows batch files

PeopleSoft Technical Migration Lead

Confidential, Century City Los Angeles, CA

Responsibilities:

• From PT 8.47.11 to PT 8.52.04 to PT 8.53.09    
• From HCM 8.9 to 9.1 to 9.2
• From Solaris to Oracle Linux 6.5
• From Oracle 10g to 11g  
• Stage 1: Upgrade PT 8.47.11 tools to 8.52.04 in Solaris, Oracle 10g environment
• Stage 2: Migrate data to new physical datacenter and upgrade to Oracle 11g
• Stage 3: Upgrade HCM 8.49 to 9.1
• Stage 4: Upgrade HCM 9.1 to 9.2 and PeopleTools from 8.52.04 to 8.53.09
• The entire 4 stage process was repeated for four TMTP passes before go-live.
• Duties included Initial upgrade planning, set up of 3 upgrade virtual machines, planning and creation of new production support environment (DEV, TEST, UAT), running all upgrade passes on three servers (each upgrade Stage was on different VM), maintaining availability of all new App Server, Web Servers, and Process Schedulers, evaluating compare reports, installation and use of PUM to identify and apply Tax Updates and Required for Upgrade patches.
• Install Oracle VM VirtualBox with OEL (Oracle Enterprise Linux) as sub-task on Windows 7.
• Install Oracle 12c Database on Windows 7

Project manager and Technical Lead

Confidential, Corcoran, CA

Responsibilities:

• Track employee training for purposes of personal injury and property damage risk mitigation and for personnel reviews.
• Project manager responsibilities included:
• Create feasibility study and project plan for integration of existing employee training data from MS Access into PS Enterprise Training module. Schedule and lead requirements gathering and fit gap analysis meetings.
• Demo capabilities of both the delivered and modified PS EL system to stakeholders
• Status reporting to upper management.
• Technical Lead responsibilities included:
• Prototype and demonstrate control table recommendations.
• PeopleCode and system modifications to remove unneeded features and requirements.
• Create Application Engine CI Component Interfaces to load historical data.
• Create user training materials.

­­­PeopleSoft Technical Migration Lead

Confidential, Corcoran, CA

Responsibilities:

• Hardware and OS migration, plus Database upgrade.
• Migrate PS HRMS, PY, TL 9.1 from HPUX 11.31 to Oracle Enterprise Linux v.6
• Re-host PeopleSoft HRMS PY TL 9.1 production and production support environments from HP SPARC hardware running HPUX 11.31, Oracle Database 10, to Blade servers running Oracle Enterprise Linux v.6, Oracle Database 11.
• Complete re-install of PT 8.51.8 on Linux to support HRMS PY TL 9.1 for Prod, UA, Test, Development and Demo. Create Application Servers, Web Servers and PIA for all environments. Coordinate multiple database conversion refreshes and verify functionality of PY system. Coordinate production go-live deployment.
• Create full production clone of HRMS PY TL 9.1 on single failover box. Coordinate testing/validation of Oracle DB failover process. Test and validate functionality of HRMS PY TL 9.1 on failover system.
• Create 2nd full production clone of HRMS PY TL 9.1 on a single box for testing of OEL 6 Linux OS patches.
• Build and test Prod, UA, Test, Development, and Demo servers and PSHOMEs on Windows Server 2008 Change Assistant support machine.
• Convert all supporting HPUX 11.31 UNIX scripts to OEL 6 Linux and test.
• Create interactive OEL 6 BASH script to manage deletion of obsolete log files.
• Create interactive OEL 6 BASH script using Zenity to manage starting and stopping of servers for 5 PS environments.

PeopleSoft Technical Upgrade Lead

Confidential, Chicago, IL

Responsibilities:

• Upgrade FSCM 8.9 to 9.1. Upgraded applications include IN Inventory, GL General Ledger, EPO eProcurement, EB eBill Payment, SPL Supply Planning, RS Resource Management, PO Purchasing, PC Project Costing, AP Accounts Payable, FP Flow Production, CA Contracts, AM Asset Management
• Plan technical upgrade schedule.
• Install Demo FSCM 9.1 and apply all Required for Upgrade fixes.
• Work closely with DBAs to plan Database/Storage Group organization.
• Use TSO/ISPF based ASG-TMON for DB2 to diagnose storage issues.
• Resolve fit gap issues. Run 4 Change Assistant upgrade passes.
• Create GREP, SED and REGEX scripts to summarize log file error reports.
• Use PSSTAT tool to generate DDL to place 50 tables per tablespace
• As replacement for a contractor who left after completing update of test environments, performed PeopleTools Move to Production pass for three production PeopleSoft environments.
• Oct 2011 - Update Peopletools 8.49 to 8.51.10 for production EDD Employee Portal
• Nov 2011 - Update Peopletools 8.49 to 8.51.10 for production FSCM Financials database
• Dec 2011 - Update Peopletools 8.49 to 8.51.10 for production HCM Human Resources database

PeopleSoft Technical Upgrade Lead

Confidential, Corcoran, CA

Responsibilities:

• Upgrade heavily customized HR, PY, TL 9.0 tools 8.49 to 9.1 tools 8.51.08 in Oracle 10G database in an HP-U­­nix 11.31 PA-RISC(64-bit) environment.
• Install HCM 9.1 tools 8.51.08 and full PIA in Windows Server 2008. Build AppServer, WebServer, and Process Schedulers for Demo, Dev, Test and Prod.
• Install HCM 9.1 tools 8.51.08 and full PIA in HP-Unix 11.31 environment. Build AppServer, WebServer, and Process Schedulers for Demo, Dev, Test and Prod.
• UNIX shell scripting/debugging to manage calculation of overtime outside of PeopleSoft.
• Modified XML paycheck, pay advice and deposit advice XML forms to include custom data. Modifications to PAY003.sqr and DDP003.sqr.
• Solve issues uncovered during testing.

PeopleSoft Technical Upgrade Lead

Confidential, Corcoran, CA

Responsibilities:

• Upgrade heavily customized HR, PY, TL 8.3 tools 8.21 to 9.0 tools 8.49 (double upgrade) from Oracle 9.0 to Oracle 10G database in an HP-Unix 11.31 PA-RISC(64-bit) environment.
• Install HRMS 8.9 as required by upgrade path
• Install HRMS 9.0 tools 8.49 and full PIA in HP-Unix 11.31 environment. Includes AppServ, WebServ, and Process Schedulers for Demo, Dev, Test and Prod.
• Install HRMS 9.0 tools 8.49 and full PIA in Windows Server 2008 environment. Includes AppServer, WebServer, and Process Schedulers for Demo, Dev, Test and Prod.
• UNIX shell scripting/debugging to manage calculation of overtime outside of PeopleSoft.
• Designed and built entirely new PeopleSoft Security roles and permission lists.
• Customized MSS TIMESHEET pages.
• Created custom AE program to run Oracle SQL Packages to load T&L Combo Accounting codes and Chart of Account codes from Oracle R11 E-Business Financials GL. Reapply all 8.3 online and batch SQR customizations to 9.0
• Train tech staff on use of Change Assistant
• Reapplied and documented 8.3 customizations on 9.0 to restrict viewing of highly compensated employees.
• Install HRMS 9.1 tools 8.50 and full PIA in Windows Server 2008 for user training
• Install Red Hat Linux 5.3.1, Windows Server 2008, Sun Virtual box as sub-tasks on Windows Vista laptop
• Install HRMS 9.1, PeopleTools 8.50 and SQL Server 2005 on Windows Server 2008
• Build AppServer, WebServer and Process Scheduler

PeopleSoft Technical Upgrade Lead

Confidential, Chicago, IL

Responsibilities:

• Upgrade of PeopleSoft HCM 8.8 Tools 8.49.09 to HCM 9.0 MP5 Tools 8.49.20
• Upgraded applications include BA Benefits Admin, EC eCompensation, ECM eCompMgr, EF eBenefits, EL eProfile, ELM eProfile Mgr, EY ePay, HR Human Resources, PY Payroll for North America, TL Time and Labor.
• Database upgrade from DB2 Z/0S V8.0 to V9.1
• Extensive SQL coding to support data conversion.
• Extensive DB2 tuning required for AE Data Conversion SQL statements.
• Worked with DBA to configure database to honor RunStat requests from App Engine programs.
• Solved issues with IBM USS incorrectly parsing delivered SQL.
• Re-architected Web Server to more fully support and utilize EMH Hub and Change Assistant features.
• Completed 4 upgrade passes.
• From project start to go live - 9 months.
• Define technical design requirements for planned extensions to Manager Self Service transactions.
• Identify upgrade requirements for existing Manager Self Service transactions in a Linux/Oracle environment. Present upgrade options to CIO.

Confidential

PeopleSoft Developer, Los Angeles, CA

Responsibilities:

• Worked with HR VP and Payroll Manager to identify changes required for rollout of ePay Employee Self Service module. Responsible for implementing changes and coordinating testing.
• Modified layout and fields showing on employee BI Publisher XML paycheck and paystub using XML Word plug-in. Modifications to PAY003.sqr and DDP003.sqr.
• Worked with hardware vendor and clearing bank to print MICR number on paychecks.
• Integrated employee view only access to PDF check image into ESS Employee Self Service. This involved implementing a 9.0 ePay feature into an 8.9 application release.
• Added link in ESS to ADP check history website using a translate table to convert PS EMPLID to ADP FileId.
• Developed Application Engine process to upload csv format Kronos time system earnings directly into PeopleSoft Paysheets. The process included error correction pages and complete diagnostic reports. Other external earnings, either hours or amounts, were also processed by this interface.
• Developed Application Engine process to upload general Deductions stored in csv format directly into PeopleSoft Paysheets. The process included error correction pages and complete diagnostic reports.
• Developed 4 Benefits SQR reports to replace reports from the dropped ADP services.
• Data mapping from ADP to PeopleSoft Payroll.
• Developed queries and cursors in MSSQL Server 2000 database to augment Component Interface data conversion from ADP to PeopleSoft.

PeopleSoft Technical Upgrade Lead

Confidential, Santa Ana, CA

Responsibilities:

• Upgraded HR, PI, PY, eProfile, eProfile Manager from v8.8 to v8.9, including database upgrade from MSSQL Server 2000 to MSSQL Server 2005.
• PeopleSoft Administrator for HR development environment of seven PeopleSoft environments on three server machines. Create and manage App and Web servers.
• Change management control coordinator for application code and data changes between development environments.
• Identified client customizations in a format facilitating distributed reapplication effort. Reapplied customizations and guided and assisted client staff with reapplication of customizations.
• Installed and used Change Assistant tool for 5 upgrade passes. Applied 100+ patches to demo and production system. Provide knowledge transfer to client technical staff for best practices of ongoing patch application.
• Design, build and document new customizations. SQL tuning for problem queries.
• Customization of select pages in MSS Manager Self Service.
• Modified Core HR Training Admin tables and pages to add priority sequencing to training certifications.
• Created Application Engine data migration program to interface Canadian employee/supervisor reporting relationships.
• Upgraded HR, TL, PY, Global Payroll Switzerland, Currency Conversion, eBenefits, eCompensation Manager, and eProfile modules from v8.3 to v8.9, Oracle 8.17 to Oracle 10g.
• Identified client customizations in a format facilitating distribution of reapplication effort. Guided and assisted client staff with reapplication of customizations.
• Provide technical guidance for installation and maintenance of multiple Environment Hubs on separate physical test and production environments.
• Installed and used Change Assistant tool for 7 upgrade passes. Applied 150+ patches to demo system. Provide knowledge transfer to client technical staff for best practices of ongoing patch application.
• Build and test client defined customizations to Case components and Case pages.
• Design and build new views, new audits and new pages to the RC CASE component.
• Add and hide fields from RC CASE page and component.
• Modify App Package code and create test scripts for 8 minor client defined customizations.
• Modify Case Note and Case Attachment display behavior per client specification.
• Upgraded HR, BA, eBenefits, eCompensation Manger, and eProfile modules from v8.3 to v8.9.
• Developed architecture plan for test and production environments.
• Installed and configured Environment Hub and patched the Demo system.
• Installed and used Change Assistant tool for all upgrade passes.
• Configured all App Servers, Web Servers, File Servers, Process Schedulers.
• Reapplied and modified customizations as required. Directed testing effort.

PeopleSoft Technical Upgrade Lead 

Confidential, Glenview, IL

Responsibilities:

• Project managed the upgrade effort for GL, Inventory, Order Management, AP, PO, and Budget modules from v7.5 to v8.8 SP1.
• Coordinated efforts of the infrastructure support team programming staff, and lead users for successful production implementation.
• Provided analysis and recommendation for GL archiving strategy.
• Provided knowledge transfer of techniques for management of PeopleSoft technical environment.

PeopleSoft Technical Upgrade Lead

Confidential, Irving, TX

Responsibilities:

• Upgraded the BI, OM, AP, AR, GL, EX, and Projects modules from v8.0 to v8.8.
• Directed and executed reapplication and modification of client customizations to a highly modified AR system, which included the redesign of heavily used Customer Conversation subsystem.
• Provided direction and performed analysis, design, development and troubleshooting of interfaces into PeopleSoft’s AM, BI, OM, AP, AR, GL, EX, and Projects modules.
• Developed architecture plan for upgraded production system.
• Managed and executed an effort to reapply and redesign customizations.
• Post upgrade performance tuning for critical AR cash processing.
• Upgraded GL, AP, PO, IN and AM modules from release 7.5 to 8.8.
• Generated and directed the usage of change analysis reports regarding client customizations.
• Applied PeopleSoft Maintenance packs to demo and production databases.
• Planned, scheduled, executed, and managed the upgrade pass to the production database.
• Provided direction and performed analysis, design, development and troubleshooting of interfaces into PeopleSoft’s GL, AP, PO, IN and AM modules.
• Analyzed and performed modifications to SQR Billing Reports.

Confidential

PeopleSoft Technical Upgrade Specialist

Responsibilities:

• Performed 6 HRMS and 5 Financial upgrades from Tools Releases v6 thru v8.4.
• Planned, managed and executed the upgrade of an HRMS system for a major defense contractor on an Oracle/Unix environment. Eleven database instances were updated without disrupting 2 major development efforts. Responsibilities included the coordination and execution of a distributed multi-server, multi-site move to production and provided on-site post production support. Northrop Grumman, Bethpage, NY
• Managed a batch upgrade of over 400 custom HR SQRs for a major hotelier and 220 custom HR SQRs for a major utility company. Hilton Hotels and Exelon
• Implemented the first OS390/DB2 Financials 8.0 upgrade for a large property casualty insurer using a heavily customized GL, AP, PO, BU, AM, EX and Projects system as part of the PeopleSoft Early Success program. Worked directly with PeopleSoft developers improve the usability and reliability of the PeopleSoft Upgrade Assistant tool. DB2/MVS/NT. State Farm Insurance, Bloomington IL.
• Upgrade and delivery of HR, PY BA & TL release 7.51 tools 7.60 to release 8.3 tools 8.18. Two test moves performed for customer. ORACLE/UNIX environment. Richardson Electronics, LaFox, IL
• Upgrade Human Resources, Payroll, and Benefits Administration from 7.51 tools 7.58 to release 8.3 tools 8.16 on ORACLE/UNIX environment for financial services company. AG Edwards, St. Louis, MO
• Upgrade Human Resource release HR 7.51tools 7.56 to release HR 8.3 tools 8.16 in MS SQL Server for law partnership. Bryan Cave, LLP, St. Louis, MO
• Upgrade and delivery of HR and PY from release 7.51 tools 7.58 to release 8 SP1 PeopleTools 8.13. For a defense contractor on DB2/MVS/NT platform. Raytheon Corp., Greenville, TX
• Planned, managed and executed onsite upgrade HRMS 7.5 tools 7.53 to release 7.51 tools 7.55 for a major defense contractor in an Oracle/Unix environment. Eleven database instances were updated without disrupting 2 major development efforts. Coordinated and executed move to production and provided onsite post production support. Northrop Grumman, Bethpage, NY
• Double upgrade HRMS 6 to 7.5, and then 7.51 upgrade for a healthcare organization on Oracle/Unix platform. ­­­Anthem HealthCare
• Onsite upgrade and move to production of SA/HRMS 7.0 tools 7.01 to release 7.60 tools 7.58 in a DB2-UDB/UNIX environment for a large community college. This included Regs 5,1, & 2, and an AU of 128 corrections. Illinois Central College, Peoria, IL
• Application of Accelerated Update of over 300 corrections to HRMS 7.51 for a major healthcare provider running an Oracle/Unix environment. Blue Cross/Blue Shield, Detroit, MI
• Upgrade and delivery of heavily modified AM, AP, AR, BI, GL, PO, PC from release 7.52 tools 7.54 to release 8.4 SP1 tools 8.43.03 IBM DB2 environment. Wendy’s International, Columbus, OH
• Upgrade and delivery of GL and AP from release 7.52 tools 7.56 to release 8.4 tools 8.42 MS SQL Server W2K environment. Boeing Capital, Long Beach, CA
• Upgrade and delivery of Financials for Education and Government AP, PO 7.0 tools 7.03 to release 7.5 tools 7.56 in a Sybase/Unix platform for a federal agency. Bureau of Labor Statistics, Washington, D.C.
• Upgrade and delivery of Financials 7.52 tools 7.55 to release 7.53 tools 7.58 on an Oracle/Unix platform for a utility company. National Fuel and Gas, Buffalo, NY
• Application of Student Administration Accelerated Update for a major university on a DB2/MVS/AIX platform. University of Connecticut, Stoors, CT
• Application of financials Accelerated Update for a county government using an Informix, Novell Netware, Unix environment. Niagara County, Lockport, NY
• Application of financials Accelerated Update for a school district in a MS SQL Server, WinNT platform. Ritenour School District, St. Louis, MO