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

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

• Supported Global HR Repository 110,000 Employees, 60 countries
• Developed AE programs to validate and load Global data received in XML format.
• Global Financial: Helped with Employee Vendor Data Conversion and Employee Expense Voucher Interfaces.

Confidential

PeopleSoft

• upgrade from Financials 7.5 to 8.4 Modules: GL, AP, PC
• Only Technical Consulting Resource to help the entire upgrade process.

Confidential

PeopleSoft

• Upgrade from HRMS 7.5 to 8 SP1 Modules: HR, Benefits, and Payroll Interface
• Tuned upgrade conversion AE programs from 26 hours to 4.5 hours

Confidential

Oracle DBA Financials 8, HRMS 8, Oracle8i 8.1.7, Siebel ePharma 7

• Created RMAN database and repository. Performed hot-backups using RMAN and logical backups. Created Standby databases for both Financials and HRMS.
• Installed Siebel Servers Gateway server, Application Servers, Report Servers, Database Servers for ePharma implementation.

Confidential

Database Administrator Oracle Sybase

• Managed PeopleSoft Financial Database Oracle 7.3.4 on Solaris 2.5.5
• Sybase DBA: Provided support for building Data Warehouse Sybase 12 on Solaris 8 .