SUMMARY:

• Seeking assignments in PeopleSoft Administration, Oracle and SQL Server with a technology driven organization of repute.
• To excellent in the field of database administration and contribute productively towards the growth of the organization
• Has over 11+ years of experience in PeopleSoft Administration, Oracle and SQL Server Administration.
• A highly motivated and committed person having 11+ years of experience as a PeopleSoft, Oracle Database and SQL Server Administration.
• Handle all system technical aspects of PeopleSoft including PUM, DPK, and Change Assistant, migrations, tuning migration/upgrade scripts, application/web server architecture, integration broker and general technical / DB troubleshooting.
• Sound knowledge in PeopleSoft HCM and FSCM upgrade.
• Sound knowledge in applying Maintenance Packs, Tax Updates, Patches and Bundles.
• Sound knowledge in Single Sign on Configuration
• Quick learner and excellent Team player.
• Troubleshooting the failed backups and Restoration of databases.
• PUM configuration and applying bugs to HCM/FSCM 9.2 applications.
• Scheduling Jobs/Maintenance Plans as to automate SQL Server.
• Knowledge in Data - stage Administration

PROJECT EXPERIENCE:

Confidential

Tools: & Environment: Red Hat Linux 7, Windows 2012 R2 Enterprise, PT 8.55/8.56, SPARC SOLARIS 11

Upgrade Specialist

Responsibilities:

• Performing PeopleSoft Upgrade from FSCM9.2 P24/PT8.55.16 to FSCM9.2 PI27/PT8.56.07
• Configuring PUM Image 28 to extract the Upgrade Change package template for Upgrade.
• Worked on configuring more than one Native OS in single server.
• Worked on customizing the yaml file to configure the PeopleSoft environment in custom specified location.
• Worked with multiple edge applications integrated with FSCM 9.2 environments.
• Working with functional team and technical team to resolve the issues.
• Working with Data conversion steps for tuning.
• Worked on Elastic Search Upgrade from DPK 2.3.03 to DPK 2.3.04
• DPK installation in LINUX/Windows server to configure the DEV, SIT and UAT environments.
• Worked on PeopleSoft Security to create a user with appropriate permission and roles.
• Configuring app, web and process schedulers on Unix servers.

Confidential

Tools: & Environment: Red Hat Linux 7, Windows 2012 R2 Enterprise, PT 8.54/8.56

Upgrade Specialist

Responsibilities:

• Performing PeopleSoft Upgrade from HCM9.1/PT8.54 to HCM9.2/PT8.56.04
• Configuring PUM Image 24 to extract the Upgrade Change package template for Upgrade.
• Worked on configuring more than one Native OS in single server.
• Worked on customizing the yaml file to configure the PeopleSoft environment in custom specified location.
• Worked on Elastic Search configuration.
• DPK installation in LINUX/Windows server to configure the DEV, SIT and UAT environments.
• Worked on PeopleSoft Security to create a user with appropriate permission and roles.
• Configuring app, web and process schedulers on Unix servers.

Confidential

Tools: & Environment: Red Hat Linux 7, Windows 2012 R2 Enterprise, PT 8.53/8.55

Upgrade Specialist

Responsibilities:

• Performing PeopleSoft Upgrade from FSCM9.2/PT8.53 to FSCM9.2/PT8.55.17
• Applying PUM updates from IMG 6 to IMG 23.
• Configured PUM image 23 and created a Change Package for applying the patches on upgraded instance.
• Worked on Elastic Search configuration.
• Worked on PeopleSoft Security to create a user with appropriate permission and roles.
• Worked on STAT tool for migrating projects to SIT, UAT and PROD instance.
• Installing Tuxedo, Java, WebLogic and PeopleSoft applications
• SSL certificate installation
• Configuring app, web and process schedulers on Unix servers.

Confidential

Upgrade Specialist

Tools: & Environment: IBM-AIX 7.1, Windows 2012 R2 Standard, People Tools 8.55/HCM 9.2

Responsibilities:

• Performed PeopleSoft Upgrade from HCM9.0/PT8.53 to HCM9.2/PT8.55.07
• Configured PUM image 17 and created a change package for applying the patches on upgraded instance.
• Extracted Change package for Tax-Update 16-D from PUM image 19 and applied in DEMO, DEV, UAT and PROD.
• Created HCM92 demo instance using DPK.
• SES and LDAP configuration.
• SSL certificate installation
• Working on DB2 database for DDL and DML operations
• Configuring app, web and process schedulers on IBM AIX servers.

Confidential

Tools: & Environment: People Tools 8.51/HCM 9.0

PeopleSoft/Oracle/Data-stage Admin Support

Responsibilities:

• Working on Oracle database for DDL and DML operations
• Worked on IBM web application server creation and launching website

Confidential

Tools: & Environment: Windows 2008/2012 R2 Standard, People Tools 8.53/HCM 9.2/FSCM9.2/Portal 9.1

PeopleSoft Admin/Oracle Admin/Infra Support

Responsibilities:

• Implemented HCM, FSCM and Portal Applications with People tools 8.53.
• Worked on file watcher shell script to monitor the file generating in UNIX server.
• Worked on SQL queries to improve the performance of late running queries.
• Configured Single sign on between these PeopleSoft applications.
• Configured 360-degree IB messaging between HR, FSCM and portal.
• Worked on PeopleSoft security to configure the single sign-on b/w HCM, FSCM and PORTAL
• SSL certificate installation
• GPG encryption and scheduling
• Worked on shell script to schedule the SFTP transfer using cronjob.
• Worked on SQL queries to improve the performance for long running queries.
• SFTP configuration and file transferring
• PUM configuration and applying latest patch using the image #16.

Confidential

Tools: & Environment: People Tools 8.51/HCM 9.0/EPM9.1, Data stage, AIX, Windows 2000

PeopleSoft/Oracle/Data-stage Admin Support

Responsibilities:

• Health checkup on Oracle Database backup, File system alert on space issue, application server, web server, Database, Data stage server and assigned tickets.
• Maintaining various instances (HCM, EPM, GDWP, and ESBPROD).
• Working on PeopleSoft project migrations, script execution, Data stage DSX file import with the proper approval from business as well as application owners.
• Worked on SQL Server DBA activities.
• Worked on SFTP configuration and scheduling the jobs.
• Created oracle/PIA users and given appropriate read/write permissions.
• Have applied Multilingual Tax update for Canadian French on HCM instances.
• Worked on IBM Data stage admin activities.

Confidential

Tools: & Environment: People Tools 8.51/HCM 9.0/EPM9.1, Data stage, AIX, Windows 2000

PeopleSoft/Oracle/Data-stage Admin Support

Responsibilities:

• Installed People tools on IBM-AIX, configured App server, batch server, webserver for DEV and UAT instance.
• Created Oracle Databases for SIT, UAT and parallel instances using Production Data pump export.
• Installed Digital Certificate for various environments and configured Single Sign On.
• Worked on Data Stage Admin activities for Data loading from Legacy systems to HCM 9.0 applications.
• Created oracle/PIA users and given appropriate read/write permissions.
• PeopleSoft Project Migrations from DEV to SIT, UAT and parallel instance.
• Recycling Data stage services

Confidential

Tools: & Environment: Windows 2008/2012 R2 Standard, People Tools 8.51/HCM 9.1

PeopleSoft Admin/Oracle Admin

Responsibilities:

• Worked with Database refresh from production to UAT and Portal Database.
• Worked with PORTAL configuration with HCM for single sign on.
• Worked with Forgot Password Configuration in sign on page.
• Configured Web server, Application server, Process Scheduler.
• Created HRMS91 and PORTAL91 with People Tools 8.52 in Linux environment.

Confidential

Tools: & Environment: UNIX, People Tools 8.52/HCM 9.2 /Portal 9.1

PeopleSoft Admin/Oracle Admin

Responsibilities:

• Worked with Database refresh from production to UAT and Portal Database.
• Worked with PORTAL configuration with HCM for single sign on.
• Worked with Forgot Password Configuration in sign on page.
• Configured Web server, Application server, Process Scheduler.
• Created HRMS91 and PORTAL91 with People Tools 8.52 in Linux environment.

Confidential

Tools: & Environment: UNIX, PeopleSoft PT 8.50, HRMS 9.1

PeopleSoft Admin/Oracle Admin

Responsibilities:

• Worked with Database refresh from production to DEV, TST and UAT periodically.
• Worked with PHIRE tool for project migration from PHIRE repository to DEV, TST, UAT and PRD.
• Worked on PeopleSoft security to create user with appropriate permissions and roles.
• Have taken compare report for analyze the impact analysis.
• Configured Web server, Application server, Process Scheduler.
• Worked with Excel to CI for loading Data.

Confidential

Tools: & Environment: Windows 2008/2012, UNIX, People Tools 8.53/HCM 9.2/FSCM9.2/Portal 9.1

PeopleSoft Admin/Oracle Admin/Infra Support

Responsibilities:

• Worked on PeopleSoft Application and Tools upgrade and have done upgrade (TOOLS 8.48 TO 8.50) and Application (9.0 to 9.1) in training environment.
• Worked on shell script to schedule the SFTP transfer using cronjob.
• Worked on SQL queries and procedures to improve the performance for long running queries.
• Installation of BEA Products (Weblogic & Tuxedo) and Configuration of Appserver, Process Scheduler and DB servers.
• Worked with Confidential internal systems (HRMS/FIN/CRM) as part of PeopleSoft APPSDBA services
• Worked on FSCM Upgrade (FSCM 8.9 to 9.1).
• Worked on PHIRE to migrate the PeopleSoft project to SIT, UAT and Production using PHIRE repository
• Applying Maintenance Packs, Bundles, Patches/Fixes as delivered by PeopleSoft
• Compare Report for Copy of PROD & DEMO (HRMS/FIN) of 8.48,49 & 50.
• Have worked on Confidential Probe for PeopleSoft to estimates the effort, schedule, and number of test moves required.
• With output of Probe I have the knowledge about Customization Inventory Reports, Complexity Reports and Component Tree Reports.
• Migration of PeopleSoft objects (Project, DMS, DAT, SQL, and SQR) across the environments

Confidential

Tools: & Environment: UNIX, PeopleSoft PT 8.50, HRMS 9.1

PeopleSoft Admin/Oracle Admin

Responsibilities:

• Have applied Maintenance Packs & bundles for HRMS Instances using Change Assistant Tool and also manually.
• Have taken compare report for analyze the impact analysis.
• Applied Tax updates for North American Payroll.
• Installed, configured Web server, Application server, and Process Scheduler.
• SSL implementation for DEV, SIT, UAT and PROD instances.

Confidential

Tools: & Environment: Windows 2008/2012, UNIX, People Tools 8.53/HCM 9.2/FSCM9.2/Portal 9.1

PeopleSoft Admin/Oracle Admin/Infra Support

Responsibilities:

• Worked on PeopleSoft Application and Tools upgrade and have done upgrade (TOOLS 8.48 TO 8.50) and Application (9.0 to 9.1) in training environment.
• Worked on shell script to schedule the SFTP transfer using cronjob.
• Worked on SQL queries and procedures to improve the performance for long running queries.
• Installation of BEA Products (Weblogic & Tuxedo) and Configuration of Appserver, Process Scheduler and DB servers.
• Worked with Confidential internal systems (HRMS/FIN/CRM) as part of PeopleSoft APPSDBA services
• Worked on FSCM Upgrade (FSCM 8.9 to 9.1).
• Worked on PHIRE to migrate the PeopleSoft project to SIT, UAT and Production using PHIRE repository
• Applying Maintenance Packs, Bundles, Patches/Fixes as delivered by PeopleSoft
• Compare Report for Copy of PROD & DEMO (HRMS/FIN) of 8.48,49 & 50.
• Have worked on Confidential Probe for PeopleSoft to estimates the effort, schedule, and number of test moves required.
• With output of Probe I have the knowledge about Customization Inventory Reports, Complexity Reports and Component Tree Reports.
• Migration of PeopleSoft objects (Project, DMS, DAT, SQL, and SQR) across the environments