Senior system administrator,Peoplesoft Administrator

John Mark Chella

Sacramento, CA *****

Cell: 530-***-****

Email Id: ****.*****@*****.***

Summary:

Over 8 years of experience as a PeopleSoft Administrator supporting mainly PeopleSoft HRMS, ELM, IH, Financials and CRM applications on Oracle, DB2 and SQL Server databases.

Involved in full life cycle implementations, upgrades, database platform migration from SQL Server to Oracle, and various conversion projects and data migration from legacy systems to the PeopleSoft ERP System.

Involved in various People Tools and Application Upgrades.

Excellent understanding of the PeopleSoft technical architecture including process scheduler, web and application servers, databases and underlying technologies.

Extensive experience in installation, configuration, setup and maintenance of the PeopleSoft environments and its third-party suites.

Created and maintained environmental documentation by updating documentation, in a timely fashion, to reflect infrastructure changes, Performance Tuning procedures, and new implementations.

Expertise in applying Oracle database security updates as per business requirement.

Strong expertise in performance tuning was developed and designed.

Installed PeopleSoft Internet Architecture (PIA) instances for various PeopleSoft/Oracle Database Instances which includes Web Servers (WebLogic, Web sphere), Application Server, Process Scheduler and configuration of report distribution.

Experience in Planning and Deployment of Tuxedo Application Server, Weblogic Server on VmwareESXi server.

Expertise in setting up Change Assistant for PeopleSoft Application/Tools Upgrades and patches/bundles/Maintenance Packs.

Extensive experience in Object Migration and Data Migration using App Designer/Stat/Phire, Data Mover, Oracle Export/Import.

Extensive experience in PeopleSoft Troubleshooting, Performance tuning, debugging and Tracing.

Expertise in Change Assistant Tool.

PeopleSoftHRMS with Campus Solutions installed.

Extensively Involved in Refreshing Development, Test from Production database and other databases.

Extensively Involved in resolving Performance issues and Database tuning.

Installed, Configured and integrated vertex Oseries tax calculation application with PeopleSoft FSCM.

Involved in Single Signon setup and integration activities between various PeopleSoft Financials, HRMS, ELM, CRM, IH and FSCM environments.

i)PeopleSoft Administration, PIA

ii)PeopleSoft Financials/HCM/CRM and EPM

iii)Weblogic, Web sphere, Oracle 10g/11g.12c,19c, DB2, SQL Server

iv)Single Singon, DB Artisan, Stat, Phire.

Education:

Master of Science in Information Technology Management from Campbellsville University, KY.

Technical Environment :

PeopleSoft

Peopletools8.5x/8.4x/8.1x/8.22/7.x, PeopleSoftHRMS9.2,9.1,9.0/8.9/8.8/8.3/8.0/7.5, PeopleSoft Fin 8.8/9.0/9.1, PeopleSoft EPM 9.0, PeopleSoft Installations and Upgrades, PeopleSoft System Administration, PeopleSoft Internet Architecture (PIA) and Performance Tuning

People Tools

Data Mover, Application Designer, Configuration Manager, Application Server, Process Scheduler, Performance Tuning, SQR, Crystal Reports, nVision Reports, PeopleSoft Utilities, Application Engine, PS Query, PeopleSoft Security, Object Security, Query Security, Tree Security, Security Administrator, Report Manager, Process Monitor, Change Assistant, People Tools test frame work, Application Upgrade, Upgrade Assistant Tool, Import Manager, Integration Tools, (Integration Broker/App Messaging), Component Interface and Business Interlinks

Security Tools

Security Administrator,

Operating Systems

Windows NT Server/Workstation 2000 Server, 2003/2008,2012,2016 server & XP, MS-DOS, UNIX, HP-UX 11/10.20, Sun Solaris 10/9.0/8.0, AIX 6.1, Linux.

Application/Web Servers

BEA Web Logic 10/9.0/8.1/6.1, BEA Tuxedo 9.0/8.1/6.5,Vmware ESX/ESXi 3.0.x-5.x, IBM Web-Sphere Application Server (WAS) 4.0x/5.1

Database Systems

Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005, DB2

Other Tools

Toad, STAT, Phire, IBM DB2 Command Editor, DB artisan, Control-M, Autosys, IIS, Oracle UPK, camelflouge, OEM.

Training

PeopleSoft/Oracle Core HR training, oracle 11g performance training.

Vertex

Installed and upgraded Vertex Oseries 6,8,9 applications and integrated with Peoplesoft FSCM

Professional experience :

Tata Consultancy services

Client: Kaiser Permanente, CA

Oct 2020 – Till Date

Lead PeopleSoft Administrator

Project Description:

The project is to build a new PeopleSoft environment/infrastructure and support a new version. and helping in that design and architecture, all while keeping the old environment up and running . They were currently running on version 9.2 Image 37 and upgrade to 9.2 Image 41

Responsibilities:

Installed and upgraded to 9.2 HCM/ELM/IH applications with people tools 8.61

Installed and upgraded to 9.2 HCM/ELM/CRM/FSCM applications with people tools 8.59.07

Installed and upgraded to 9.2 HCM/ELM/CRM/FSCM applications with people tools 8.58.03

Applied Patches through PeopleSoft Update Manager (PUM)

Installed Elastic search Server and configured.

Installing Tax updates, People Tools patches and bundles as needed.

Responsible for creating and maintaining the databases, application, web and process scheduler servers, installing tuxedo and Web logic on Linux and Windows environments.

Involved in pre and post database refresh steps on oracle database and its automation.

Applied People Tools Patches for People Tools 8.58.

Provided availability for all databases up and running, maintained tables, performance tuning.

Incorporated strategies for performance tuning.

Created Web and App server on Linux and tuned accordingly.

Excellent performance tuning skills at both the database and individual SQL levels.

Provided WebLogic 12.1,14.1 expertise in tuning the webserver for optimal performance in NT and Unix environments.

Performance tuning the database, identifying best practices on database design, improve application performance through query optimization, database system tuning, and database redesign.

Implement Oracle TDE column encryption for advanced security.

Involved in performance Tuning and traced various T&L and payroll process.

PeopleSoft Security administration tasks include the creation and maintenance of user profiles, roles and permission lists.

Executed post refresh steps to ensure desired operation of PeopleSoft systems and security validations.

Implemented Stat for PeopleSoft HR Applications deployments.

Implemented Phire for PeopleSoft HR Applications deployments

Involved in setting up and troubleshooting issues related to app messaging between HRMS and third-party applications.

Supported PeopleSoft HR applications on WINDOWS servers, MYSQL databases and Application/Web/Process Scheduler Servers.

Performed refreshes from Production to lower environments for projects and daily maintenance activities.

Wrote and modified shell scripts for booting app/web and batch servers.

Built New Linux and windows servers for PeopleSoft application as part of datacenter move and People Tools upgrade.

Setup the PIA data blocks and firewalls rules for the PeopleSoft systems to secure the data.

Automated start and stop of PeopleSoft App/web and batch schedules by writing shell scripts.

Installed IIS and configured for using FTP service for Expense Attachments.

Installed micro focus Cobol, Tuxedo and web logic on VmwareESXi servers.

Set up single sign on between PeopleSoft internal system and third-party vendors.

Involved in database upgrade from 12c to 19c.

Ran numerous queries and updated/modified data using Excel to CI.

Support STAT with issues and apply patches to be compatible with PeopleSoft systems.

Applied numerous Application, tools and security patches on quarterly basis.

Installed, configured and Upgraded Vertex Oseries6 to Oseries8 and integrated with Peoplesoft FSCM.

Installed, configured and Upgraded Vertex Oseries8 Oseries9 and integrated with Peoplesoft FSCM.

Installed, configured and Upgraded Vertex Oseries9 from SR9 to SR12 and integrated with Peoplesoft FSCM.

Installed, configured and Upgraded Vertex Oseries9 from SR12 to SR15 and integrated with Peoplesoft FSCM.

Installed, configured and Upgraded Vertex Oseries9 from SR15 to SR18 and integrated with Peoplesoft FSCM.

People Tools Upgrade

PeopleTools8.58 to 8.59(HCM, CRM, ELM, IH, FSCM).

PeopleTools8.59 to 8.61(HCM, CRM, ELM, IH, FSCM).

Environment: PeopleSoft HCM 9.1/9.2, PeopleTools 8.58/8.59, Oracle 12c,19c, Web logic 10,12,14 Tuxedo 10,12 Red hat Linux 7.1,7.5 AIX, Windows Server2003/2008/2012,2016,2019, Stat, Phire.

HS Solutions Inc

Client: Kaiser Permanente, CA

July 2017 -Oct 2020

PeopleSoft Administrator

Project Description:

The project is to build a new PeopleSoft environment/infrastructure and support a new version. and helping in that design and architecture, all while keeping the old environment up and running . They were currently running on version 9.1 and upgrade to 9.2

Responsibilities:

Installed and upgraded to 9.2 HCM/ELM/CRM applications with people tools 8.55.16

Applied Patches through PeopleSoft Update Manager (PUM)

Installed Oracle SES Server and configured.

Installing Tax updates, People Tools patches and bundles as needed.

Responsible for creating and maintaining the databases, application, web and process scheduler servers, installing tuxedo and Web logic on Linux and Windows environments.

Involved in pre and post database refresh steps on oracle database and its automation.

Applied People Tools Patches for People Tools 8.55/8.57.

Provided availability for all databases up and running, maintained tables, performance tuning.

Incorporated strategies for Performance tuning.

Created Web and App server on Linux and tuned accordingly.

Excellent performance tuning skills at both the database and individual SQL levels.

Provided WebLogic 6.1 expertise in tuning the webserver for optimal performance in NT and Unix environments.

Performance tuning the database, identifying best practices on database design, improve application performance through query optimization, database system tuning, and database redesign.

Implement Oracle TDE column encryption for advanced security.

Involved in Performance Tuning and traced various T&L and payroll process.

PeopleSoft Security administration tasks include the creation and maintenance of user profiles, roles and permission lists.

Executed post refresh steps to ensure desired operation of PeopleSoft systems and security validations.

Implemented Stat for PeopleSoft HR Applications deployments.

Implemented Phire for PeopleSoft HR Applications deployments

Involved in setting up and troubleshooting issues related to app messaging between HRMS and third-party applications.

Supported PeopleSoftHR applications on WINDOWS servers, MYSQL databases and Application/Web/Process Scheduler Servers.

Performed refreshes from Production to lower environments for projects and daily maintenance activities.

Wrote and modified shell scripts for booting app/web and batch servers.

Built New Linux and windows servers for PeopleSoft application as part of datacenter move and People Tools upgrade.

Setup the PIA data blocks and firewalls rules for the PeopleSoft systems to secure the data.

Automated start and stop of PeopleSoft App/web and batch schedules by writing shell scripts.

Installed IIS and configured for using FTP service for Expense Attachments.

Installed micro focus Cobol, Tuxedo and web logic on VmwareESXi servers.

Set up single sign on between PeopleSoft internal system and third-party vendors.

Involved in database upgrade from 10g to 11g.

Ran numerous queries and updated/modified data using Excel to CI.

Support STAT with issues and apply patches to be compatible with PeopleSoft systems.

Applied numerous Application, tools and security patches on quarterly basis.

People Tools Upgrade

PeopleTools8.53 to 8.55(HCM, CRM, ELM, IH, FSCM).

PeopleTools8.55 to 8.58(HCM, CRM, ELM, IH, FSCM).

Environment: PeopleSoft HCM 9.1/9.2, PeopleTools 8.54/8.55/8.58, Oracle11g BEA Web logic 10,12, Tuxedo 10,12 Red hat Linux 7.1,7.5 AIX, Windows Server2003/2008/2012,2016, Stat, Phire.

HS Solutions Inc

Client: Fidelis Care, NY

June 2016 -June 2017

PeopleSoft Administrator

Project Description:

The project is to build a new PeopleSoft environment/infrastructure and support a new version. and helping in that design and architecture, all while keeping the old environment up and running . They were currently running on version 9.1 and upgrade to 9.2

Responsibilities:

Installed and upgraded to 9.2 Finance applications with people tools 8.54.

Applied Patches through PeopleSoft Update Manager (PUM)

Installed Oracle SES Server and configured.

Installing Tax updates, People Tools patches and bundles as needed.

Responsible for creating and maintaining the databases, application, web and process scheduler servers, installing tuxedo and Web logic on Linux and Windows environments.

Involved in pre and post database refresh steps on oracle database and its automation.

Applied People Tools Patches for People Tools 8.53/8.54.

Provided availability for all databases up and running, maintained tables, performance tuning.

Incorporated strategies for Performance tuning.

Created Web and App server on Linux and tuned accordingly.

Excellent performance tuning skills at both the database and individual SQL levels.

Provided WebLogic 6.1 expertise in tuning the webserver for optimal performance in NT and Unix environments.

Performance tuning the database, identifying best practices on database design, improve application performance through query optimization, database system tuning, and database redesign.

Implement Oracle TDE column encryption for advanced security.

Involved in Performance Tuning and traced various T&L and payroll process.

PeopleSoft Security administration tasks include the creation and maintenance of user profiles, roles and permission lists.

Executed post refresh steps to ensure desired operation of PeopleSoft systems and security validations.

Implemented Stat for PeopleSoft HR Applications deployments.

Involved in setting up and troubleshooting issues related to app messaging between HRMS and third-party applications.

Supported PeopleSoft HR applications on WINDOWS servers, MYSQL databases and Application/Web/Process Scheduler Servers.

Performed refreshes from Production to lower environments for projects and daily maintenance activities.

Wrote and modified shell scripts for booting app/web and batch servers.

Built New Linux and windows servers for PeopleSoft application as part of datacenter move and People Tools upgrade.

Setup the PIA data blocks and firewalls rules for the PeopleSoft systems to secure the data.

Automated start and stop of PeopleSoft App/web and batch schedules by writing shell scripts.

Installed IIS and configured for using FTP service for Expense Attachments.

Installed micro focus Cobol, Tuxedo and web logic on VmwareESXi servers.

Set up single sign on between PeopleSoft internal system and third-party vendors.

Involved in database upgrade from 10g to 11g.

Ran numerous queries and updated/modified data using Excel to CI.

Support STAT with issues and apply patches to be compatible with PeopleSoft systems.

Applied numerous Application, tools and security patches on quarterly basis.

People Tools Upgrade

PeopleTools8.50 to 8.54(HCM).

Environment: PeopleSoft HCM 9.0/9.2, PeopleTools 8.50/8.54, Oracle11g BEA Web logic 10, Tuxedo 10, Red hat Linux 5, Windows Server2003/2008, Stat.

Contact this candidate