Peoplesoft Dba Resume Profile
MN
SUMMARY:
- 12 years of hands-on experience in PeopleSoft Architect, Administrator/DBA using PeopleSoft PeopleTools 8.53.11/8.50.07 upgrade, PUM PeopleSoft Update Manager Portal 9.1, SCM 9.2, CRM 9.0, HCM 9.2, Campus Solutions 9.0, and EPM 9.1 using WebLogic 10gR3/9.2, Tuxedo 10gR3 and Oracle 11g/10g, SQL Server 2k5, DB2 database environments. Expertise in administration, installation, maintenance, tax updates, performance tuning, upgrading, DST patches and production support for large PeopleSoft environments.
- Administration expertise in PeopleTools 8.53.11/8.50.07 /8.49.10 SCM 9.2 GL, AP, AR, PO Billing, HCM 9.2 Payroll HR, Time and Labor, Benefits Administration, change management, Campus Solution 9.0, CRM 9.0 helpdesk and support and EPM 9.1 Enterprise Warehouse, Funds Transfer Pricing FTP Workforce Analytics and Forecasting using Red Hat Linux, HP-UX, AIX, Sun Solaris and IBM Regatta RS6000 environments.
- Expertise in Oracle Database Administration, Oracle 11g, installation, upgrade, patching, RMAN, import/export, general RAC database administration, setting up Oracle DataGaurd for DR and failover database.Configuration of ETL tool Data stage 7.5, Ascential Data stage Administrator, Data stage Designer and InformaticaPowerMart 8.1, OBIEE, OLAP Tool Cognos 7.1, COGNOS 8 BI, ReportNet, Framework Manager, NDS, Access Manager, Power Play Enterprise Server PPES Upfront Server, Integration and IWR using NT and UNIX servers, Business Objects 6.1, Supervisor, Designer, Web Intelligence, Carbon Copy, Citrix, Sun Solaris, Linux and AIX Environments.
EXPERIENCE
Confidential
PeopleSoft DBA
- Successfully completed 2 step PeopleSoft HCM 9.2 / PT8.54.05 upgrade project from PeopleSoft HCM 8.9-9.2 using PT 8.49.16 - HCM 9.1 to HCM 9.2 using PeopleTools 8.51.11, Oracle 12c Solaris 11 servers working as PeopleSoft admin to upgrade, support and monitor PeopleSoft environments.
- Successfully completed PeopleTools 8.54.05 upgrade for PeopleSoft Portal 9.1 environments from PeopleTools 8.52.11, Oracle 12c and Solaris 11 servers in DEMO, DEV and Test PeopleSoft Portal 9.1 environments.
- Used Oracle PeopleSoft Upgrade Source Image 9 as source demo for HCM 9.2 upgrade configured the image 9 into Virtual Box virtual machine Windows server 2012 R2 server.
- Configured PeopleSoft HCM 9.2 upgrade environment to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager PUM , PeopleSoft Image 11, downloading template from oracle support, creating change assistant 8.54.05 job and follow through all the steps in change assistant job to finish the upgrade.
- Applied PeopleSoft updates into upgraded HCM 9.2 environments using Image 11 to HCM 9.2 DEMO, DEV and Test environments using PeopleSoft Update Manager PUM .
- Installed and configured new Demo PeopleSoft HCM 9.2, PT 8.54.05 binaries, PeopleSoft Update Manager PUM Installed Tuxedo 12c configured application servers, configured PIA using WebLogic 12c web servers.
- Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles, applied Tax updates from PUM in HCM 9.2 upgraded environments.
- Successfully fixed on performance tuning on upgrade long running jobs to shorten the cutover upgrade timeline, fixed long running data conversion jobs by running Oracle AWR reports, finding long running SQL ID, using Oracle SQL tuning advisor and implementing the recommendations. Created Oracle database indexes, SQL profiles, run STATS to improve SQL performances.
Confidential
PeopleSoft DBA
- Proving PeopleSoft DBA support for PeopleSoft Portal Solutions 9.1, FSCM 9.1, HCM 9.1, EPM 9.1 and Campus Solution 9.0 using /PT 8.53.11for development Test, QA and production environments using Oracle 11g ASM RAC and non-RAC databases on RHEL Linux 6.1 servers.
- Involved in PeopleSoft Campus solution split from HRMS 9.0 with PeopleSoft developers architects.
- Performing PeopleSoft database refresh/cloneas per the developer's request using RMAN duplicate database and restoring from RMANprod database backup.
- Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating Oracle users, granting roles, executing sql scripts, refreshing PeopleSoft databases using RMAN/ import export in RAC and non RAC databases
- Installed, configured and upgraded Oracle Enterprise Manager Cloud Control 12c for administration, performance tuning and monitoring over 200 oracle 11.2.0.4 databases.
- Implemented RMAN backup strategies and developed various shell scripts to take RMAN cold and incremental databases backup with backup success or failure email notification in shell scripts.
- Providing support for HCM/9.1, Portal 9.1 with PeopleTools 8.48.15, 2 WebLogic 9.2 multi-server using Oracle 10g databases on Linux 6.0 on ASM file system.
- Performed production and non-prod oracle 11.2.0.4 11g upgrade using upgrade assistant and scripts to Oracle 11gR2 11.2.0.4 for PeopleSoft HR, FSCM and EPM databases on Linux servers.
- Expertise in performance tuning of PeopleSoft batch processes with AWR, SQL Plan Management, SQL Tuning advisor, SQL Access advisor, Memory advisor, Segment Advisor and SQL Trace.
- Configured environment needed to start upgrade process i.e. setting up change assistant, downloading template from customer connection, creating change assistant job and follow through all the steps in change assistant job to finish the upgrade.
- Configured PeopleSoft Portal 9.1 with PeopleSoft Campus Solution applications using SSO and configuring local and remote nodes with exposure to Interaction Hub.
- Created pagelets and links in PeopleSoft portal 9.1 to integrate with other PeopleSoft HCM, SCM and campus solutions applications.
- Resolved all upgrade related issues encountered during Change Assistant upgrade processes in timely manner to meet scheduled production upgrade.
- Providing support for FSCM/Financials 9.1/EPM 9.1, Portal 9.1 with PeopleTools 8.53.11, 2 WebLogic 10gR3 multi-server using Oracle 10g/11g RAC databases on AIX 6.0 on ASM file system.
- Configured load balanced app servers using Tuxedo 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using Oracle 10 RAC databases.
- Configured load balanced web server and multi servers PIA using Weblogic 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using a hardware switch.
- Expertise in Tuning app server configuration files for Max clients per handlers , no of handlers and max PSAPPSRV and other processes and configuring app server load balancing.
- Expertise in Tuning web server/load balancing for optimal performance of HCM and SCM applications using appropriate PIA heap size configurations in multiserver web server environment and configuring VIP.
- Configured SSL, active directory, configured certificates, Single signon, apply Tax updates, bundles, and configuring application messaging using Integration broker for all PeopleSoft environments.
- Migrated legacy data from mainframe databases into Oracle PeopleSoft databases using PeopleTools DataMover.
- Using Quest STAT for PeopleTools data object migrations and CSR tracking.
- Helped users with Informatica 8.1/DataStage 7.1 user support, creating new accounts, migrating mappings from DEV to QA to PROD Informatica repositories/Projects.
- Installed DataStage / Informatica client tools DataStage Informatica Power Center Designer on users' desktops.
Confidential
PeopleSoft DBA
- Expertise in PeopleSoft objects migration using application designer, file copy on windows and unix servers, used Quest STAT and Phire.
- Configured PeopleSoft HCM 9.2 upgrade environment needed to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager PUM , downloading template from oracle support, creating change assistant 8.53.11 job and follow through all the steps in change assistant job to finish the upgrade.
- Successfully completed first initial and MTP pass PT 8.53.11 upgrade from PT8.52.13 in Demo and development on Oracle Linux 6.1 Exadata and windows server 2008 servers.
- Successfully completed first initial and MTP pass FSCM 9.2 / PT 8.53.11 upgrade from PT8.52.13 / FSCM 8.9 in Demo and development on Oracle Linux 6.1 and windows server 2008 servers.
- 2 step PeopleSoft HCM 9.2upgrade project forPeopleSoft HCM 8.9/ 9.1 using PT 8.53.11 - HCM 9.1 to HCM 9.2 using PeopleTools 8.53.11, Oracle 11.2.04 Linux servers working as PeopleSoft DBAto upgrade, support and monitor PeopleSoft environments.
- PeopleTools 8.52.13 to 8.53.11upgarde
- FSCM 8.9 to 9.2 upgrade
- 2 step HCM 8.9 to 9.2 upgrade
- Working on3 upgrades simultaneously
- Installed and configured new Demo PeopleSoft HCM 9.1/HCM 9.1 / PT 8.53.11 binaries, Installed Tuxedo 11g 10.3.6 configured application servers, configured PIA using WebLogic 11g web servers.
- Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles.
- Installation, Setup and Configuration of Physical Standby database using Oracle DataGaurd for prod and DR environments.
- Implement Backup and Recovery Procedures using RMAN for Oracle Databases and test regularly in conjunction with operations. Configuring scripts for backups Level 0 and Incremental .
- Installation, Upgrade and Configuration of Oracle 11gR2 binaries, databases and optimizing all database performance including the design, creation and structural integrity of database objects in the production environment.
- Used oracle 11.2.0.4 data pump to export and importPeopleSoft data from PeopleSoft / non PeopleSoft production to non-prod environments.
Confidential
PeopleSoft DBA
- Expertise in Oracle DBA skills in cloning and refreshing PeopleSoft Oracle 11g databases using RMAN duplicate database and from restoring RMAN backup, created copy of production and copy of current demo HCM 8.9 and new Demo. HCM 9.2 for upgrade steps.
- Providing general PeopleSoft Oracle DBA support in Oracle database upgrade, applying database CPU, PSU patches and PeopleSoft environment upgrade.
- Refreshed non-prod Oracle 11g databases using data pump import / export utility to various non-prod environments.
- Completed PeopleSoftHCM 9.2upgrade project forPeopleSoft HCM 9.1 PT 8.52.13 / 9.2using PeopleTools 8.53.11, working as PeopleSoft HCM Administrator / DBA to upgrade, support and monitor PeopleSoft environments.
- Installed and configured new Demo PeopleSoft HCM 9.2/ PT 8.53.11 binaries, Installed Tuxedo 11g 10.3.6 configured application servers, WebLogic 11g web servers.
- Successfully completed HCM 9.2 upgrade from PT8.51.08 / HCM 8.9 in Demo, development Test, QA and production on UNIX Linux 6.1 and windows server 2008.
- Configured PeopleSoft HCM 9.2 upgrade environment needed to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager PUM , downloading template from oracle support, creating change assistant 8.53.11 job and follow through all the steps in change assistant job to finish the upgrade.
- Successfully configured PeopleSoft Update Manager PUM on a dedicated windows server to apply all the required for upgrade updates and fixes using new PeopleSoft Image filesin Demo, Development, Test, QA and production environments.
- Installed and configured Oracle SES on Linux servers with all PeopleSoft 9.2 applications documentation and PeopleSoft search from inside application.
Confidential
PeopleSoft DBA
- Installed and migrated IBM DataStage on Linux 6.1 servers, restored PeopleSoft EPM projects, users and ETL maps.
- Configured Crystal Reports for HCM and FSCM reports on windows 2008 servers.
- Installed and configured Crystal reports for HCM 8.9 and FSCM 8.9 modules on windows 2008 servers'reports.
- Installed and migrated IBM DataStage 7.5.2 on Linux 5.8 servers, restored PeopleSoft EPM projects, users and import/export DS jobs.
- Configured HCM 8.9 modules payroll, HR and Benefits Administration, FSCM, AP, PO, ePro, GL and EPM modules.
- Worked on Data Ware housing environment using SQL Server 2008 database servers with ETL tools DataStage and Informatica jobs.
- Successfully completed / restored all Non-Prod environments for HCM 8.9, FSCM 8.9 and EPM 9.0/PT 8.51.08implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases over 1 Terabyte in size.
- Configured PeopleSoft EPM environment using DataStage 7.5.2 i.e. setting up DataStage client / Server, export DataStage projects, testing DataStage jobs and follow through all the steps in configuring DS jobs with EPM 9.0 to finish the migration.
- Worked with developers to tune PeopleSoft batch processes and PeopleSoft queries, used explain plan, ran statistics on heavily used tables, and created sql profile to get optimal performance on queries and batch jobs.
- Corrected PeopleSoft online navigation performance by tuning app server processes, handlers, clients per handlers.
- Configured apache configuration file httpd.conf to communicate with Webserver, Worked on performance testing after PeopleSoft applications HCM, SCM and EPM migration on to the new servers.
- Used apache proxy server with WebLogic 11g PIA servers to protect direct attacks on the prod webserver.
- Performed production and non-prod oracle 10.2.0.4 10g upgrade using shell scripts to Oracle 11gR2 11.2.03 for PeopleSoft EPM databases on Linux servers.
- Providing support for HCM/9.1, Portal 9.1 with PeopleTools 8.48.15, 2 WebLogic 9.2 multi-server using Oracle 10g databases on Linux 6.0 on ASM file system.
- Expertise in Oracle DBA skills in cloning and refreshing PeopleSoft Oracle 11g databases using RMAN duplicate database and from restoring RMAN backup.
- Configured Oracle database DR environments using Oracle DataGaurd functionality using primary and standby databases.
- Implemented Oracle RMAN NetBackup solutions and implemented backup strategy i.e. daily, weekly and monthly backup
- Providing support for FSCM/Financials 8.9, EPM 9.0 with PeopleTools 8.51.08 WebLogic 10gR3 multi-server using Oracle 11g databases on Linux5.8 on RHL file system.
- Assigning work to different team members as per their skills and capabilities.
- Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles.
- Installation, Setup and Configuration of Physical Standby database.
- Implement Backup and Recovery Procedures using RMAN for Oracle Databases and test regularly in conjunction with operations. Configuring scripts for backups Level 0 and Incremental .
- Installation, Upgrade and Configuration of Oracle 11gR2 and optimizing all database performance including the design, creation and structural integrity of database objects in the production environment.
- Migrated, installed and configured PeopleSoft Oracle 11.2.0.3, HCM 8.9, FSCM 8.9, EPM 9.1, and DataStage 7.5.2 / PT 8.51.08 binaries on target RH Linux servers 5.8, Installed Oracle 11.2.0.3 binaries, Tuxedo 10gr3, WebLogic 10gR3, Java JDK 1.6 configured application servers, WebLogic web servers and configured PIA on destination servers.
- Worked on PeopleSoft DataCenter migration, PeopleSoft HCM 8.9, FSCM 8.9 and EPM 9.0server migration using PeopleTools 8.51.08 upgrade project, working as PeopleSoft EPM Administrator / DBA to implement, support and monitor PeopleSoft environments.
- Used Oracle 10g/11g data pump to export/import data between source and target data centers to complete the migration.
Confidential
PeopleSoft DBA
- Worked onPeopleSoft Replatforming PeopleSoft Oracle databases and PeopleSoft FSCM 9.1server migration and PeopleTools 8.52.14 and FSCM 9.1 upgrade project, working as PeopleSoft HCMDBA to implement, support and monitor PeopleSoft environments.
- Installed and configured PeopleSoft Oracle 11.2.0.3 binaries on DB server, FSCM 9.1/ PT 8.52.14 binaries on new Linux servers, Installed Tuxedo 10gr3 configured application servers, WebLogic 10gr3 web servers and reapplied Unix customizations.
- Expert Oracle DBA skills in Creating, refreshing PeopleSoft Oracle 11g 11.1.0.7.0 databases using RMAN / import export in RAC and non RAC databases.
- Recommended Linux 6.0 servers with PeopleSoft recommended RAM, CPU count, IO and ASM file system for Oracle RAC databases.
- Expertise in applying Oracle database security updates as per business requirement.
- Configured apache proxy server with WebLogic 11g PIA servers to protect direct attacks on the prod webserver.
- Applied SSL certificates on proxy and WebLogic servers.
- Successfully completed PT 8.52.14/FSCM 9.1 upgrade from PT8.48 / FSCM 8.9 in Demo, development Test, QA and production on UNIX Linux 6.1 and windows server 2008.
- Configured PeopleTools upgrade environment needed to start upgrade process i.e. setting up change assistant, downloading template from oracle support, creating change assistant 8.52job and follow through all the steps in change assistant job to finish the upgrade.
- Successfully completed / restored all FTP FSCM 9.1/PT 8.50.07 implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases.
- Exposed to OBIEE environments using Oracle 11g databases on Linux 6.1 64 bit servers.
- Installed and configured PeopleSoft EPM delivered maps with developers.
Confidential
PeopleSoft DBA
- PeopleSoft HCM 9.1 implementationproject, working as one and only PeopleSoft HCM 9.1 DBA Architect, to implement, support and monitor PeopleSoftHCM 9.1 environments.
- Expert Oracle DBA skills in Creating, refreshing PeopleSoft Oracle 11g 11.1.0.7.0 databases using RMAN / import export in RAC and non RAC databases.
- Installed Oracle binaries on DEMO, DEV, TEST, QA and prod servers and applied Oracle database CPU and PSU patches/updates as per Oracle recommendations.
- PIA, single sign-on, SSL certificates and load balancing.
- Created kornUNIX shell scripts for PeopleSoft administration and helped developers creating shell scripts for PeopleSoft business jobs.
- Expertise in upgrading Oracle 10g databases to 11g using Oracle Database upgrade Assistant.
- Implemented Oracle RMAN NetBackup solutions and implemented backup strategy i.e. daily, weekly and monthly backup.
- Implemented Oracle RMAN NetBackup solutions and implemented backup strategy i.e. daily, weekly and monthly backup.
- Configured Oracle database DR environments using Oracle DataGaurd functionality using primary and standby databases.
- Configured Oracle Enterprise Manager OEM to monitor PeopleSoft Oracle databases in DEV, TEST, QA and production environments.
- Configured Oracle Enterprise Manager OEM to send critical Oracle database alerts to be aware of an upcoming database issue.
- Configured environment needed to start upgrade process i.e. setting up change assistant, downloading template from customer connection, creating change assistant job and follow through all the steps in change assistant job to finish the upgrade.
- Configured HCM9.1 payroll, HR and Benefits Administrationmodules on Oracle 11g databases.
- Successfully completed PT 8.52.10 upgrade from PT8.50.07 in HCM 9.1 development Test, QA and production on UNIX and windows server 2008.
- Used Oracle Enterprise Manager to administer PeopleSoft database for size, alerts and users management.
- Installed and configured Oracle Enterprise manager, grid control to manage all DEV, TEST and production databases.
- Successfully completed HCM 9.1/PT 8.50.07 implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases.
- Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles.
- Configured application messaging using Integration broker, IB gateway, IB nodes, channels, IB Domains, PUBSUB servers for PeopleSoft environments.
- Providing support for HCM/Financials 9.1, with PeopleTools 8.50.15, 2 WebSphere9.2 server using Oracle 11g databases on Linux 6.0 on ASM file system.
- Installed and configured IBM DataStage ETL tools for PeopleSoft EPM 9.1, configured DataStage clients for developers and helped them to restore delivered PeopleSoft EPM 9.1 ETL maps.
- Providing support for HCM 9.1, PeopleTools 8.51.07, WebSphere 7.0 using Oracle 11g databases on AIX 6.0 and windows servers file system.
- Cloned/refreshed PeopleSoft environments from production as per business need using RMAN and import/export.
- Installed PeopleSoft databases, application servers, process schedulers, report repository,
Confidential
PeopleSoftDBA
- Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating, refreshing PeopleSoft databases using RMAN/ import export in RAC and non RAC databases.
- Installed Oracle binaries on non-prod and prod servers and applied Oracle database CPU and PSU patches/updates as per Oracle recommendations to build PeopleSoft campus solutions environments.
- Successfully completed EPM 9.1 /PT 8.51.06 upgrade from EPM 8.9, in development Test, QA and production environments from PT 8.49.17 EPM 8.9.
- Configured environment needed to start upgrade process i.e. setting up change assistant, downloading template from customer connection, creating change assistant job and follow through all the steps in change assistant job to finish the upgrade.
- Helped users with Informatica 8.1 user support, creating new accounts, migrating mappings from DEV to QA to PROD Informatica repositories.
- Installed DataStage / Informatica client tools DataStage Informatica Power Center Designer on users' desktops.
- Performed Informatica repository backups using a shell scripts.
- Installed and upgraded Informatica 8.1 from 7.1 on Oracle 11g databases in DEV, Test and prod environments.
- Resolved all upgrade related issues encountered during Change Assistant upgrade processes in timelymanor to meet scheduled production upgrade.
- Providing support for FSCM/Financials 9.1/EPM 9.1, Portal 9.0 with PeopleTools 8.51.07, 2 WebLogic 10gR3 multi-server using Oracle 10g/11g RAC databases on AIX 6.0 on ASM file system.
- Configured load balanced app servers using Tuxedo 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using Oracle 10 RAC databases.
- Configured load balanced web server and multi servers PIA using Weblogic 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using a hardware switch.
- Providing support for HRMS 8.9 with PeopleTools 8.49.17, 2 WebLogic 9.2 multi-server and Tuxedo 9.1 using Oracle 10g RAC databases on AIX 6.0 on ASM file system.
- Expertise in Tuning app server configuration files for Max clients per handlers , no of handlers and max PSAPPSRV and other processes and configuring app server load balancing.
- Expertise in Tuning web server/load balancing for optimal performance of HCM and SCM applications using appropriate PIA heap size configurations in multiserver web server environment and configuring VIP.
- Configured SSL, active directory, configured certificates, Single signon, apply Tax updates, bundles, and configuring application messaging using Integration broker for all PeopleSoft environments.
- Installed ETL tool DataStage server and client tools.
- Exposure to Oracle wallet, quest foglight, and oracle datagaurd.
Confidential
PeopleSoft DBA
- Successfully completed CS9.0 implementation for NYU using PT8.50.07 on Oracle 11g RAC database environment.
- Successfully completed Campus Solutions 9.0/PT 8.49.21 implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases.
- Creating, refreshing PeopleSoft databases using RMAN/ import export in RAC and non RAC databases.
- Provided production support for Campus Solution 9.0, maintaining a huge 24 application server and 28 WebLogic multi-servers PIA with a 3 node ASM RAC Oracle 11g databases environment.
- Installation, deign, testing, performance tuning, capacity planning, user, security, space management, migration and administration of PeopleSoft Oracle RAC 11g/10gdatabases environment on ASM file system.
- Involved in assessment of prod and non-prod Unix and Windows servers for PeopleSoft Campus solutions implementation at NYU.
- Recommended Linux server with PeopleSoft recommended RAM, CPU count, IO and ASM file system for Oracle RAC databases.
- Involved in splitting PeopleSoft Campus solution 9.0 from PeopleSoft HRMS objects.
- Performed extensive testing on PeopleSoft Web and app servers to achieve 4000 concurrent users in NYU's PeopleSoft Campus Solution, Tuning app server configuration files for Max clients per handlers , no of handlers and max PSAPPSRV and other processes and configuring app server load balancing.
- Created load balancing application servers and WebLogic 8.1 Web Server to point proxy PIA
- Used apache proxy server with WebLogic 11g PIA servers to protect direct attacks on the prod webserver.
- Expertise in Tuning web server/load balancing for optimal performance of HCM and SCM applications using appropriate PIA heap size 2GB max limit configurations in multiserver web server environment and configuring VIP.
- Providing production support for Campus Solutions 9.0/Portal 9.0 with PeopleTools 8.51.06, 2 WebLogic 10gR3 multi-server 10 PIA /server using Oracle 11g/10 RAC databases on Red Hat Linux 5.0 on ASM file system.
- Expertise in PeopleSoft object migration, move objects from DEV, Test, QA and prod environments.
- Expertise in setting up application messaging using Integration Broker, gateway and setting up integration. properties configuration file.
- Applied SCM Maintenance Packs 6 through 11using Change Assistant.
- Provided production support for FSCM 9.1 and Campus Solution 9.0 using PT 8.49.17, Oracle11g databases on Linux.
- Troubleshot web servers PIA or any application related issues. Configured app/web, report repository, batch servers for Campus Solution 9.0 environments.
- Cloned/refreshed PeopleSoft environments from production as per business needs using RMAN and import/export, installing PeopleSoft databases, application servers, process schedulers, report repository, PIA, single sign-on, SSL certificates and load balancing.
- Troubleshot production /development environment issues, performance tuning of long running jobs in a timely manner to keep production /development environments up and running for smooth development/ production system.
Confidential
PeopleSoft Administrator
- Successfully completed the PeopleSoft PeopleTools upgrade to PT849.21 from PT846.10 using Change Assistant with Oracle 10g CRM 8.8 databases on Sun Solaris 9 environment.
- Successfully completed the PeopleTools upgrade from PT844.17 to PT846.10, installed demo environment for HRM and SCM 8.4 sp2.
- Production support for SCM 8.9, CRM 8.8 and HRMS 8.8 with PeopleTools 8.49.17 using WebLogic 9.2, Tuxedo 9.1 and Oracle 10 databases on Solaris 9.0 / Red Hat Linux 4.0.
- Applied CRM bundles on a predefined schedule in CRM 9.0 environments starting from DEMO, DEV, TEST, Stage and production.
- Applying tax updates, dst patches, bundles, fixes and patches and performing PeopleSoft migrations.
- Installed and configured CRM 9.1 Demo environment, configure app/prcs /web server with PT8.50 for future upgrade using WebLogic 10gR3 / Tuxedo 10gR3 using Red Hat Linux environment.
- Successfully completed SCM 8.9 upgrade from SCM 8.4sp2 with PT849.10 from PT847.15. Configured Change Assistant job ran all the automated and manual steps.
- Configured app/web, report repository, batch servers for upgraded environments.
- Successfully upgraded ImageNow / WebNow in dev test and production environment from 4.x to 5.x.
- Helped developers in setting up ImageNow clients / WebNow on desktops.
- Monitored PeopleSoft production databases for long running queries, datafile size and database availability on 24/7 basis.
- Configured and load balanced PeopleSoft SCM 8.9using apache RPS for WebLogic 9.2/WebSphere 6.1.
- Providing production support to PeopleSoft HCM 8.8, SCM 8.4 and CRM 8.8 using PeopleTools 8.47 on Oracle 9i databases using Solaris 9 environments.
- Set up new PeopleSoft environments requirement gathering analyzing space requirement, setting up web Server, single sign-on, PIA, application server/process schedulers on NT and Solaris
- Setting up app messaging, Integration Broker, Gateway, nodes, channels and Integration properties file.
- Tuning app server and web server/load balancing for optimal performance of HCM and SCM applications.
- Worked with PeopleSoft HCM developer to configure OIM, created and configured app messaging nodes and tested it with OIM.
- Created load balancing application servers and WebLogic 8.1 Web Server to point proxy PIA
- Applied PeopleSoft Financials patches fixes and Bundles as per requirement.
- Refreshed / cloned PeopleSoft Oracle databases / environments dev, test, QA and Stage databases from production as per business requirement.
- Production support for PeopleSoft Oracle 10g databases on a rotation basis.
- Used apache proxy server with WebSphere PIA server.
- Configured Application-Messaging servers configures Application Messaging Gateway, creating channels, and messaging nodes using Integration Broker utility and monitoring messages with Application Message Monitor.
- Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory,LDAP integration, and Single Sign on implementation.
- Successfully installed PeopleBooks on WebLogic PSOL server with context sensitive help enabled.
- Create and troubleshot Mercury LoadRunner scripts to Load Test PeopleSoft SCM and HRMS applications.
Confidential
PeopleSoft Administrator
- Provided PeopleSoft maintenance and Production support for Time Warner Cable, TWC have PeopleSoft live from last 2 years with HRMS 8.3 and Financial 8.4, EPM 8.8 and Portal using PeopleTools 8.43 and 8.18 using Oracle 9i databases on Linux and Solaris environment.
- Set up Informatica Server 6.1 administration and support Informatica Server Start/Shutdown, Cleaning Cache, Disk Space Management, Repository Backup for different PeopleSoft EPM environments.
- Supported PeopleSoft environments using SQL Server 2000 databases, used T-SQL and little bit database administration.
- Integrated the application servers, process schedulers, Tuxedo 6.5, and WebLogic 6.1 servers using Oracle 9i Solaris environment.
- Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory,LDAP integration, and Single Sign on implementation.
- Tuned Tuxedo 6.1/8.1 and WebLogic 8.1, tuning max handler / min handlers, increasing tuxedo queue size, tuning OS level kernel parameters, turning ON load balancing in tuxedo which is turned off by PeopleSoft, tuning heap size in WebLogic for optimal performance of PeopleSoft applications.
- Set up Single Sign-On for Portal using Netscape Directory Server 6.01 LDAP Lightweight Directory Access Protocol for Peoplesoft applications.
- Set up and creating Links between different Portal applications includes PeopleSoft and HRMS, Financials.
- Applied Tax Updates 04A to HR environment and applied application Updates and Bundles fixes and patches as per the functional needs.
- PeopleSoft general day-to-day administration responsibilities for PeopleSoft Project, SQR, nvision Migration between different environments.
- Creation and Management of users, roles and profiles in the Oracle 9i environment for database access.
- Created Database storage structures User Tablespaces, Index Tablespaces and Undo Tablespaces. Allocate system storage and plan for future storage requirements for the databases.
Confidential
PeopleSoft Administrator
- Supported developer's team for PeopleSoft CRM 8.8, HRMS, EPM and Financials Implementation.
- Responsible for setting up development, testing and production database environments.
- Granted and managed necessary system, user, and object privileges to the respective users and roles.
- Expertise in migration of PeopleSoft Projects, running Compare Reports and sync, SQR's, Crystal Reports and nVision reports between environments.
- Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory, NDS, LDAP integration, and Single Sign-on for Portal implementation.
- Provided Production support for PeopleSoft CRM 8.8, HRMS 8.8, Portal 8.8 and Financials 8.4 and resolved day to day production issues.
- Created database storage structures User Tablespaces, Index Tablespaces and Undo Tablespaces. Allocate system storage and plan for future storage requirements for the databases.
- Administration support for PeopleSoft Financials A/P, G/L, A/R and HRMS Benefits admin, Payroll etc and PeopleSoft EPM FTP, ABM and workforce Analytics.
- Expertise in performing migrations PeopleSoft projects, SQRs, and crystal/ Nvision reports between environments.
- Configured Application-Messaging servers, configure Application Messaging Gateway, creating channels, and Messaging Nodes using Integration Broker utility and monitoring messages with Application Message Monitor.
- Configured WebLogic, Tuxedo and Jolt on UNIX/NT, PeopleSoft Web Servers WebLogic 6.1 on Sun Solaris and PeopleSoft application servers Tuxedo and Process Schedulers using NT and UNIX environments.
- Configuration experience in creating Report Server, Report Repository, Integration Broker, Batch Server and
Confidential
PeopleSoft Admin PeopleSoft/DB2 Mainframe OS390
Experienced as PeopleSoft administrator at BCBS, responsibilities includes setting up and maintenance of PeopleSoft HRMS Payroll, T L and Financials AP, AR GL applications environment, usingDB2 databases for HR/Financials Tech, Functional and Testing environments for developer's.
- Installed, configured and maintained the PeopleSoft HRMS 8.0/8.3 and Fin 8.0/8.4 Process scheduler and application servers.
- Installed and maintained PIA using IBM AIX 5.1/Citrix/CarbonCopy environment.
- Successfully installed and configured Web Servers using WebLogic 5.1/6.1 and PeopleSoft Internet Architecture on AIX 5.1 using IBM Regatta RS 6000 p670.
- Successfully upgraded PeopleTools 8.18 to 8.43 using PeopleSoft delivered template and Upgrade Assistance for Financials and HRMS environments.
- Supported PeopleSoft environments using SQL Server 2000 databases, used T-SQL and little bit database administration.
- Implementation of Business Objects 6.1 applications, created and modified universe, joins, resolved loops, and Business Objects reports.
- Successfully installed PeopleBooks and PeopleTools 8.17/8.18 8.41/42 for HRMS and Financials environments.
- Successfully installed and developed Batch Process scheduler servers for HRMS 8.3 and FIN 8.4