PROFESSIONAL EXPERIENCE:

PeopleSoft HCM Upgrade Specialist/Technician/Developer

Confidential, Aurora, CO

Responsibilities:

• Upgrade Lab Environment utilizing PUM methodology/technology
• Technical Project Manager - define project plan, schedule, milestones and allocation of resources
• PeopleSoftUpgrade HCM 8.8/PT 8.48.08, Microsoft SQL Server 2000 -> HCM 9.2/PT 8.53.09Microsoft SQL Server 2012 -> Double Pass through HCM 9.0
• Installation/setup of PeopleTools 8.53.09, including change assistant, webserver, application serverprocess scheduler, PUM infrastructure (Pass 2), etc.
• Compare report generation/analysis
• Isolation and retrofitting of necessary customizations/bolt-ons, including security migration
• Analysis and re-mapping of security to accompany new HCM functionality

Open Enrollment Lead

Confidential

Responsibilities:

• Analysis/design for creation/enhancement of custom benefit interface programs for 3rd party carriers
• Analysis/design for creation/enhancement of custom Confidential GUI

PeopleSoft HRMS Developer/Support/Integration Specialist

Confidential, Littleton, Colorado

Responsibilities:

• PeopleSoftHRMS 8.8/PeopleTools 8.43 on Microsoft SQL Server 2000
• Customization/configuration/support of 2012/2013/2014 Open Enrollment, including eBenefitsBenefits Administration, and Benefit vendor interface file enhancements
• Application/maintenance of Tax Updates 2011 - D through 2013-?, including Payroll and year-end support
• Analysis/design/development of Retirement extract/interface to 3rd party vendor

PeopleSoft HRMS PSAdmin/Developer/Support/Upgrade Specialist

Confidential, Denver, CO

Responsibilities:

• Creation/configuration/maintenance of ALL necessary upgrade environments
• Compare report generation/analysis
• Isolation and retrofitting of necessary customizations and security
• Analysis and re-mapping of security
• PeopleSoftPSAdmin/Development/Support on Oracle 11g HRMS 9.0/PeopleTools 8.49.25
• Production Support including:
• AppServer/WebServer maintenance Security Environment refreshes Tax Updates/Maintenance Packs application Kronos/Payroll integration/interfaces, HR, BenAdmin, TAM troubleshoouting and issue resolution

Conversion/Migration/Upgrade Specialist, DBA and Developer

Confidential, Peoria, IL

Responsibilities:

• Database/OS, PeopleTools/PeopleSoft HRMS/FSCM Applications HRMS 8.8 SP1/PT 8.45.05 on DB2 8.1/z/OS 1.7 - >HRMS 9.1/ PT 8.51.06 on SQL Server 2008 R2/Windows 2008 R2
• FSCM 8.9 SP1/PT 8.47.02 on DB2 8.1/z/OS 1.7 -> FSCM 9.1/ PT 8.51.06 on SQL Server 2008 R2/Windows 2008 R2
• Analysis/design/development of DB2 -> MS SQL Server conversion: creation of database shell including DDL structure export scripting via DataMover for DB2 import scripting via DataMover for MS SQL Server 2000 SQL scripting to correct for syntax differences batching of processes for optimal performance/timing
• Perform DBA tasks necessary to support SQL Server 2008/PeopleSoft upgrade: server/database setup, security and maintenance performance tuning and monitoring
• Re-application of custom/bolt-on modules and enhancements via PeopleTools
• Retrofit PSQuery for SQL syntactical differences and record/table structural changes
• Assist in-house developers with PeopleTools 8.51 enhancements and new functionality
• Support User Acceptance Testing

PeopleSoft HRMS Developer/Support/Integration Specialist

Confidential, Shoreview, MN

Responsibilities:

• Extensive SQR programming for data conversion, integration, and interfacing of Compliance
• Integrity and Benefits external integration
• Agreement and training requirements
• Analysis/design/coding/automation of various customized HRMS 8.3/HCM 8.9 Compliance/Training application modules for merger/integration
• Maintained SOX compliance thru GSM testing/documentation methodology

PeopleSoft HCM Upgrade Specialist/Technician/Developer

Confidential, Aurora, CO

Responsibilities:

• PeopleSoftUpgrade HRMS 8.9 MP1 - > HRMS 9.1 Oracle 10g/Microsoft SQL Server 2005
• PeopleTools Upgrade 8.48.08 -> 8.50.05 Oracle 10g/Microsoft SQL Server 2005
• Customization of delivered upgrade (AE) scripts to properly convert modified delivered base tables
• Re-application of custom/bolt-on modules and enhancements via PeopleTools
• Apply tax updates to most current release
• Modify/test custom PSQuery/Crystal/SQR reports according to HCM 9.1 data model changes
• Re-design/apply custom security to correspond to upgraded menu/page enhancements
• Miscellaneous Benefits Administration setup changes in preparation for open enrollment/eBenefits

PeopleSoft HCM Lead Conversion Specialist/Technician/Developer

Confidential, Lakewood, CO

Responsibilities:

• Analysis/design of job/organizational hierarchy for Position Management implementation/conversion
• Position data/setup table population thru SQR/ExcelToCI/Application Engine/Component Interface programming
• Job data conversion thru SQR/SQL scripting/programming
• Analysis/design/coding of post conversion audit reports via SQR/PSQuery
• Re - application of client customizations impacted by implementation
• Extensive PeopleCode programming for new Position Management customizations
• Ongoing as needed support/development
• Assist HRIS with reporting strategies and PSQuery support
• Maintain SOX compliance

PeopleSoft HCM Upgrade Specialist/Technician/Developer

Confidential, Aurora, CO

Responsibilities:

• PeopleSoftUpgrade HRMS 8.8 SP1 -> HCM 9.0 Oracle 10g/Microsoft SQL Server 2005
• PeopleTools Upgrade 8.47 -> 8.49 Oracle 10g/Microsoft SQL Server 2005
• Customization of delivered upgrade (AE) scripts to properly convert modified delivered base tables
• Re-application of custom/bolt-on modules and enhancements via PeopleTools
• Apply tax updates to most current release
• Modify/test custom PSQuery/Crystal/SQR reports according to HCM 9.0 data model changes
• Re-design/apply custom security to correspond to upgraded menu/page enhancements
• Miscellaneous Benefits Administration setup changes in preparation for open enrollment/eBenefits
• SQL scripting and stored procedure creation for automating reporting processes
• Various PSAdmin and DBA administrative tasks to support upgrade including creation/maintenance Application/WEB Servers and Process Schedulers, PS Security, and PS object migration

PeopleSoft HRMS Developer/Support/Integration Specialist

Confidential, Shoreview, MN

Responsibilities:

• PeopleSoftDevelopment/Support on Oracle 9i HRMS 8.3/PeopleTools 8.19
• Extensive SQR programming for data conversion, integration, and interfacing of ADP 8.9 Payroll data including demographic/tax/earnings/deduction extraction
• Analysis/design/coding/conversion of various HRMS 8.3 application modules for merger/integration with HCM 8.9 system
• Analysis/design/coding of Application Engine/Component Interface module for annual compensation data conversion/load
• Maintained SOX compliance thru GSM testing/documentation methodology

PeopleSoft HCM/FIN/FO 9.0 Upgrade Specialist/Technician/Developer

Confidential, Little Rock, AR

Responsibilities:

• Evaluated patch levels/update history of database upgrades, including compare reports and made recommendations
• Trace/analyze Change Assistant upgrade steps and compile timings
• Analysis/design/coding of various upgrade performance enhancements: ptimized import export thru BCP/SQL/ batch processes optimized data conversion AE processes by tuning SQL/PeopleCode
• Scripting and in corporation of custom table structures/population into Change Assistant upgrade template
• Created/built application system databases to be used as configuration repositories
• Analysis/design/coding of cumulative patch/maintenance pack/tax update scripts to apply post upgrade
• Re - apply FO/FS/HR application customizations including: PeopleTools, SQR, Query
• Analysis/design/coding/conversion of new security requirements
• Assisted DBA/PSAdmin with various database administrative tasks

PeopleSoft HCM/EP 8.9 Upgrade Specialist/Technician/Developer

Confidential, Greenwood Village, CO

Responsibilities:

• Analyzed state of initial pass upgrade started prior to my arrival and made recommendations
• Performed PeopleTools 8.47 upgrade on copy of production to enable the extraction of missing bjects neglected during initial pass
• Assisted DBA/PSAdmin with upgrade/change assistants to ensure the system was up to date on current patches and fixes
• Re-apply all PeopleTools customizations for testing and eventual move to production
• Modify/test all custom PSQuery/Crystal/SQR reports according to HCM 8.9 data model changes
• Re-designed/applied custom security to meet client’s requirements, including row-level
• Test numerous key Payroll/Benefits/HR processes prior to turning over to users for testing
• Documented significant functional changes and worked closely with client users to ensure smooth transition from HRMS 8.0 to HCM 8.9
• Reworked Enterprise Portal 8.9 to mimic functionality/appearance of Portal 8.0 as opposed to doing upgrade
• Responsible for setup of LDAP/single signon integration of Enterprise Portal/HCM/Finance
• Assisted other consultants/users with recoding/testing customized PSQuery/Crystal/SQR reports for
• Finance/Front Office 8.0 -> 8.9 upgrades
• Provide post-upgrade production support for all HRMS modules
• Worked closely with DBA’s and system administrator to trouble shoot and solve any system or architecture problems. This included web servers, app servers, process schedulers, etc.

PeopleSoft HRMS Developer/Support/Integration Specialist

Confidential, Shoreview, MN

Responsibilities:

• PeopleSoftDevelopment/Support on Oracle 9i HRMS 8.3/PeopleTools 8.19
• Extensive SQR programming for conversion, integration, and interfacing of data
• Customized appropriate database objects for company (s) separation/integration
• Customized appropriate SQRs/PeopleTools (including security) objects for company(s) separation/integration
• Analysis/design/coding of HRMS application merger/integration of HRMS 8.3 and HRMS 8.9
• Maintained SOX compliance

PeopleSoft Admin/MS SQL Server DBA

Confidential, Washington, DC

Responsibilities:

• PeopleSoftDevelopment/Support on Microsoft SQL Server 2000
• LDAP/single signon implementation/integration
• PeopleTools upgrade 8.43.07 - > 8.47.04
• Enforce PeopleSoft referential integrity thru PeopleCode
• Customization of PeopleSoft front-end menu system
• Enhance/enforce PeopleSoft security, specific to customer roles

MS SQL Server DBA/PeopleSoft Technical Implementation/Upgrade

Confidential, Littleton, Colorado

Responsibilities:

• PeopleSoft Implementation on Microsoft NT/SQL Server
• 70% Technical including PeopleTools/SQL/SQR/Security
• 30% Functional including Benefits/HRMS/Payroll
• PeopleSoft/SQL Server Disaster recovery including LogShipping
• Installation/setup/support of PeopleSoft HRMS/Payroll 8.81/Peopletools 8.44 (2-tier/3-tier)
• Technical Project Lead on ALL upgrades/updates HRMS/Payroll E&G 7.00 -> 7.02 -> 8.01 -> 8.8 -> 8.9 upgrades PeopleTools 7.03 -> 8.16 -> 8.44.05 -> 8.47 -> 8.48 upgrades Tax updates Technical Lead on eBenefits/Open Enrollment, ePay, eProfile implementation including security/web.
• Web/application/database server installation/setup (Web Logic/PIA/SQL) process scheduler setup data conversion/import manager SQR coding/maintenance COBOL maintenance/customization PeopleCode coding/ maintenance analysis/design/coding of custom PeopleSoft modules: retirement benefit/payout job posting applicant tracking sheriff department ‘homegrown’ T&L
• Installation/setup/support of Microsoft SQL Server
• SQL Server upgrade 6.5 - > 7.0 -> 2000
• Design/maintenance/support of various Microsoft SQL Server backend applications
• Daily maintenance/support (24x7) of SQL Server/PeopleSoft including: backup/recovery procedures threshold management/monitoring security (logins/roles) scripting of miscellaneous database utilities
• Shell scripting of miscellaneous database utilities/stored procedures