Senior PeopleSoft Administrator/DBA

• Self-motivated IT professional with notable success in upgrade of PeopleSoft applications with 9 major release upgrades. Experienced in HCM and FSCM product lines. Excel at communicating Technical tasks in non-technical terms to Senior Managers. Excellent written and oral communication skills and a regular speaker at North East PeopleSoft User conference. Seeking Technical Upgrade Lead position involving PeopleSoft 9.2 Upgrade.
• 15 years of experience as PeopleSoft Administrator/DBA, Technical Project Manager, Technical Upgrade Lead and Development Lead
• Recent Install experience: HCM 9.2, FSCM 9.2, CRM 9.2, PeopleTools 8.53
• Recent Upgrade experience: FSCM 9.1, HCM 9.1 and PeopleTools 8.53
• Completed 8 new PS implementations, 9 major upgrades, and 9 minor upgrades
• PeopleSoft DBA Oracle, MS SQL Server
• Blend of functional and technical experience.
• Architecture, infrastructure and integration experience

Skills

Professional Experience

Confidential

PeopleSoft DBA/Admin

CRM 9.2 HCM 9.1, PT 8.53, Oracle 11g 11.2.0.3, Red Hat Linux 6.2

• Implementation Support for CRM 9.2 Setup PUM workstation Providing support for implementation team in Demo, Dev and QA environments
• Production Support for HCM 9.1 HCM Production: WebLogic Servers 3 for internal, 2 for Careers site , Application Servers 3 for internal, 2 for Careers site and 2 Process Schedulers. HCM Dev/QA: 12 WebLogic Servers, 12 Application Servers and 8 Process Schedulers

Confidential

PeopleSoft DBA

• Provided technical leadership in many PeopleSoft related initiatives with the engagement lasting over 5 years.
• Managed fairly complex production architecture: Oracle 11g databases on Solaris 10, Siteminder and LDAP authentication using Active Directory.
• Production: WebLogic Servers 4 in US, 2 in Paris , Application Servers 2 for US/Asia and 2 for Europe and Process Schedulers 4 Unix, 6 Windows .
• Dev/UAT: 10 application server domains, 12 Weblogic servers, 20 process scheduler domains
• Migration of projects using STAT
• Setup SSL on WebLogic Servers and Application Servers REN Server
• Financials 9.1, PT 8.53, Oracle 11g 11.2.0.3, Solaris 10, size: 500 GB
• Completed PeopleTools upgrade from 8.50 to 8.53 in 2014Q1
• Installed FSCM 9.2 for evaluation
• Performed application release upgrade from FSCM 8.8 to 9.1 in 2009
• Partitioned large tables. E.g. Journal, Ledger, Voucher Acct Line, Expense Acct Line
• Performance tuning of both application and architecture
• HCM 9.1, PT 8.52, Oracle 11g 11.2.0.3, Solaris 10 since 2011Q2
• Oracle 11g database: 60gb with Database Vault installed
• Supported global implementation of HCM 9.1 Core HR, Ben Admin, Payroll Interface, eDevelopment, eCompensation, ESS, MSS
• Performed PeopleTools upgrade from 8.51 to 8.52
• Installed HCM 9.2 for evaluation
• OBIEE 11g
• Oracle Business Intelligence Admin supporting HCM Business Analytics implementation

Confidential

Technical Upgrade Lead and PS DBA

• HCM 9.0 MP5, Oracle 10g, Tools 8.49, AIX 5.3
• Technical Upgrade Lead/DBA for HCM 9.0 upgrade
• Created the new upgrade databases and upgraded them
• Completed HCM 9.0 MP5 upgrade from HCM 8.8 SP 40,000 employees and 250GB database size . Modules: Benefits Admin, North American Payroll, eApps, and Manager Self-service. Went Live on 11/17/2008.
• Used Change Assistant to run through the upgrade process. Completed 6 passes: Initial pass, systems test, UAT, Test Move 1, Test Move 2, and production cut-over. Tuned data conversion SQL statements from 11 hrs to 4.5 hrs 60 improvement .

Confidential

Senior PeopleSoft DBA Consultant

HCM 8.9, PT 8.49, SQL Server 2000

• Technical Project Lead for re-implementation of HCM 8.9. Managed data migration and conversion
• Handled performance problems and worked with server team to size various servers
• Implemented Candidate Gateway and went live on 3/24/2008.
• Implemented custom eCompensation a bolt on module. Handled both functional and technical roles. 6 AE programs, 10 Components, 35 Records, 20 Crystal Reports . Completed two cycles of eCompenation 2007 and 2008
• Responsible for PeopleSoft administration tasks including database refreshes, migration, applying patches and bundles

Confidential

Liaison Manager

• Oracle 10g, Financials 8.8
• Managed the hosting relationship between IBM and the client to implement PS Financials Modules: GL, AP, PO, BI, AR
• Successfully helped to meet the go-live date of 1/1/2007
• Created Unix shell scripts to drop files onto and to pick up files from mainframe
• Provided support for implementation Team by coordinating with IBM to build environments, to obtain VPN SSH accesses etc.

Confidential

Senior Oracle/PeopleSoft DBA

• Supported 14 Databases, 14 Application Servers, 14 Weblogic Servers, 28 Process Schedulers
• Upgraded 18 Oracle databases from 8i to Oracle 9i in 2004. Part of three member team that upgraded 18 databases to Oracle 10g and AIX 5.3 in 2006.
• Implemented version control for 10 DBA scripts and used one version of the scripts on all 5 Unix servers. Scripts used parameter file to manage the tasks. E.g. orastart, orastop, psoftstart, psoftstop, oraexport, oralisternerstart, oralistenerstop, psreports clean
• Routinely applied Oracle Security patches
• PeopleSoft Financials 8.9 and PT 8.47
• Performed Financials upgrade to Release FSCM 8.9, Tools 8.47 in 2006
• Supported Financials GL, CC, AP, PO, AM Release 8.9 , PT 8.47, Oracle 10g, AIX 5.2
• Implemented EDI X.12 transactions to from Vendors e.g. PO, Invoices, ASN .
• Implemented eProcurement module. Developed custom AE program to send HTML approval and denial emails
• PeopleSoft HCM 8.8 and PT 8.45
• Performed the upgrade from 8SP1 to HR 8.8 SP1 MP4 in 2005
• Supported HR / NA Payroll / Benefits Admin 5000 Employees Release 8.8 SP1, PT 8.45, Oracle 10g, AIX 5.2
• Coordinated with Server Team, Network team and Security team to setup the architecture of eRecruit implementation
• Supported and implemented LDAP Active Directory integration
• List of other engagements

Confidential

HR/Payroll/Benefits Consultant

• Oracle 9i, AIX
• Supported Year-End processes HR/Payroll/Benefits System 35,000 Employees, 50 states

Confidential

PeopleSoft HR/Payroll

• Benefits Releases 5.11 Sybase on Solaris
• Installed PeopleSoft HR/Payroll/Benefits Releases 5.11 Sybase on Solaris

Confidential

Oracle DBA and PeopleSoft Administrator

• HR/Payroll: Performed 2 major upgrades from 3.22 to 4 and from 4.x to 5.1.
• Tuned PaySheet, PayCalc and PayConfirm processes.