Summary:

Over eleven years of experience in relational database installation, configuration, tuning, maintenance and user management involving PeopleSoft database system administration, architecture and upgrades. Extensive experience as a lead PeopleSoft database/systems administrator, application/database tuning expert and system architecture specialist.. Expertise with RDBMS like Oracle , DB2 and SQL Server. Proficient in database refreshes, performance tuning, backup recovery, scheduling cron jobs and appserver/web server performance tuning. Experience with code migrations across various environments. Managed, administered and coordinated complete life cycles of multiple system and application projects across multiple indutries including Pharma, Health Care, Public sector and Finance. Experience with planning/testing disaster recovery for production databases.

PeopleSoft Experience:

• Strong experience in gathering requirement analysis, project planning and design skills.
• Applied patches, bundles and maintenance packs.
• Extensively worked on different versions HCM, FIN, CRM, EPM Campus Solutions PeopleSoft Installations 8.3, 8.8, 8.9 and 9.1 .
• Expertise in configuration and maintenance of PeopleSoft applications 8.3, 8.8 ,8.9 and 9.1 .
• Successfully performed 2 PeopleSoft Application upgrades, HRMS 8.8 to 9.1 and CRM 8.8 to 9.1.
• Successfully performed 4 PeopleSoft People Tools upgrades.
• Device project plan and execute data migration projects for migrating data from PeopleSoft 8.3 to PeopleSoft 8.9 HR.
• Expertise in configuring integration broker between third party applications and Peoplesoft application.
• Download and apply tax update, install patches periodically when they are released.
• Monitoring of PeopleSoft web servers, application servers, process schedulers and system health checks.
• Configured PIA for the environment.
• Contributed in all phases of the software life cycle, including analysis, design, implementation and maintenance.
• Expertise in cloning and refreshing development, test databases with production data.
• Migration of PeopleSoft code from development databases to test databases and then to production databases.
• Configuring LDAP.
• Expertise on incident and problem management related to the PeopleSoft system administration and batch processing.
• Installed and configured Oracle 10G on AIX and Windows.
• Expertise on change management and control.
• Performed logical/physical database backups using various methods, including exports, cold backups, hot backups.
• Maintaining the documentation for the production patches, bundles and migrations.
• Expertise on backup and recovery management.
• Developed and automated shell scripts to monitor the application server and process scheduler performance.
• Developed and automated shell scripts to delete the cache for application server and process scheduler and update DBMS statistics for production and test environment.
• Expertise on tuning of PeopleSoft application server and process scheduler.
• Extensively worked on install and configuration of PeopleSoft server hosts, components, and clients for tier II and III.
• Configuring application server , batch server and web server alerts and notifications.
• Create windows client profiles for various development, test and production users and install.
• Implement load balancing for web servers and application servers.
• Maintain integrity and consistency of the database using DDDAUDIT/SYSAUDIT reports periodically.
• Installation of mqm adapter.
• Expertise in Citrix Netscaler.
• Excellent interpersonal and communication skills.

Skills:

Professional Experience

Responsibilities:

• Tuning application server performance issues.
• Tuning webserver performance issues.
• Load balancing the webserver server using NetScalar.
• Performing migrations using STAT.
• Performing the post refresh tasks to configure the environment, security and report repository.
• Troubleshooting and providing support for the day-day environment issues.

S/W Environment:

People Tools 8.52.07/HRMS 9.1, People Tools 8.52. 07/FSCM 9.1,Weblogic Server 11g, People Tools 8.52. 07/Portal 9.1, Tuxedo 10.3, Oracle 11g.

Operating System:

Aix 7.1, Windows 2008 R2.VMware

Confidential

Responsibilities:

• Tuning application server performance issues.
• Tuning webserver performance issues.
• Load balancing the Integration gateway for the Integration broker.
• Monitoring and troubleshooting performance issues using RUEI tool.
• Troubleshooting and providing support for the day-day environment issues.
• Building the performance testing environement and load balancing the application server and webserver.

S/W Environment:

People Tools 8.52.10/HRMS 9.1, People Tools 8.52.10/FSCM 9.1,WebSphere 7.0, Tuxedo 10.3, Oracle 11g.

Operating System:

Aix 6.1, Windows 2008 R2.VMware

Confidential

PeopeSoft Administrator

Responsibilities:

• Installing and maintaining PeopleSoft environment STG and PRD with PeopleTools 8.52 and HRMS 9.1, FSCM 9.1 instances.
• Installing WebLogic server with distributed node configuration.
• Configuring application server domains with load balancing.
• Configuring Process Scheduler domains.
• Configuring webserver domain and load balancing with F5.
• Load balancing the Integration gateway for the Integration broker.
• Installing the PeopleSoft plugin for OEM 12c.
• Deploying the targets for hosts, application server, webserver, process scheduler and middleware.
• Creating rules and monitoring target for Peoplesoft Plugin on OEM 12c.
• Performing the post refresh tasks to configure the environment, security and report repository.
• Configuring Integration Broker for PeopleSoft Integrations and troubleshooting the IB issues.
• Creating the WSDL webservice.
• Installing JRockit on linux.
• Installing the SSL certificates for UAT and Production environments.
• Handling migrations from DEV to UAT as part of daily activities.
• DDDAudit and SYSAudit cleanup as part of the upgrade requirement.
• Troubleshooting and providing support for the day-day environment issues.
• Building the performance testing environement and load balancing the application server and webserver.

S/W Environment:

People Tools 8.52.10/HRMS 9.1, People Tools 8.52.10/FSCM 9.1,Weblogic 10g, Tuxedo 10.3, Oracle 11g.

Operating System:

Linux 5.9, Windows 2008 R2.VMware

Confidential

PeopeSoft Administrator and Upgrade Specialist

Responsibilities:

• Installing and maintaining PeopleSoft environment DEV, TST and PRD with PeopleTools 8.52 and HRMS 9.1, CRM9.1, EPM 9.1 instances.
• Installing and maintaining PeopleSoft environment DEV, TST with PeopleTools 8.50 and HRMS 9.1, CRM9.1, EPM 9.1 instances.
• Running the upgrade for the HCM 8.8/PT8.45 to HCM 9.1/PT8.50 and CRM 8.8/PT 8.45 to CRM 9.1/PT 8.50.
• Successfully performed PeopleTools upgrade from 8.50 to 8.52.
• Successfully performed PeopleTools upgrade from 8.45 to 8.51 for CRM 8.8
• Configuring the change assistant for the Initial Pass, moveToProduction and Go-Live for HCM9.1 and CRM9.1 upgrade.
• Software and hardware requirements gathering for the HRMS 9.1/PT 8.50,CRM 9.1/PT8.50 and EPM 9.1/PT 8.50 databases.
• Installing the required for install updates for HCM and CRM environments.
• Installing the RFU required for upgrade patches.
• Planning and execution of Dress Rehearsal.
• Load balancing the Integration gateway for the Integration broker.
• Preparing the pre-upgrade check list to minimise the issues during the upgrade.
• Performing the post updgrade activities and generate the reports for the business.
• Performing the post refresh tasks to configure the environment, security and report repository.
• Minimize the over all run time for the PeopleTools upgrade and Application upgrade.
• Troubleshooting the data conversion issues and reduce the overall run time.
• Installing tax updates for HCM9.1 database manually and using Change Assistant.
• Configuring Integration Broker for PeopleSoft Integrations and troubleshooting the IB issues.
• Configuring Integration Broker Thrid party configuration with the MQ.
• Installing the SSL certificates for UAT and Production environments.
• Installing Verity and buiding search collection.
• Handling migrations from DEV to UAT as part of daily activities.
• DDDAudit and SYSAudit cleanup as part of the upgrade requirement.
• Troubleshooting and providing support for the day-day environment issues.
• Building the performance testing environement and load balancing the application server and webserver.
• Load balancing of the application server and webserver.
• Installing the IBM InfoSphere 8.1 on AIX for EPM 9.1

S/W Environment:

People Tools 8.52.07/HRMS 9.1, People Tools 8.52.07/CRM 9.1,People Tools 8.50.18/HRMS 9.1, People Tools 8.50.18/CRM 9.1, WebSphere 7.0, Tuxedo 10.3, DB2 8.1, IBM Z/OS 1.10 and IBM Z/OS 1.12

Operating System:

AIX 6.1, Windows 2003/2008 R2.

Confidential

Senior PeopeSoft Administrator

Responsibilities:

• Installing and maintaining PeopleSoft environment DEV, TST and PRD with PeopleTools 8.47 and HR 8.9ML instance.
• Successfully performed PeopleTools upgrade from 8.47 to 8.49.
• Device Project Plan and execute Data Migration projects for migrating data from PeopleSoft 8.3 to PeopleSoft 8.9 HR.
• Expertise with Citrix Netscaler and web server load balancing.
• Installation of mqm adapter.
• Developed scripts for mqm monitoring.
• Maintaining the documentation for the production patches, bundles and migrations, preparing the installation plans and the installation reports for all the changes.
• Expertise in installation of PeopleSoft HR with application version 8.9, People tools 8.49 on AIX 5.3 and windows platforms for development environment.
• Applying Maintenance Pack and bundles for the HR 8.47/8.9 environment using Change Assistant.
• Setup and configuration of application server, web server and process scheduler domains for the DEV, TST and PRD environment.
• Configured PIA for the DEV, TST and PRD environment.
• Responsible for cloning and refreshing development, test databases with production data.
• Migration of PeopleSoft code from development database to test database and then to production database.
• Configuring and automating the jobs on Appworx scheduler V4.6.1.
• Scheduling jobs on Appworx v7 third party job scheduler
• Implementing the production changes by following the change management and control.
• Scheduling hot backup for PS environment.
• Configured Report Repository for the environment.
• Installing People Books for PeopleSoft Instances and configured help.
• Installing Tuxedo 8.1, 9.1 on UNIX and applying Tuxedo rolling patch.
• Installing Web Logic 8.1, 9.2 on windows for Web Server.
• Developed and automated shell scripts to monitor the application server and process scheduler performance.
• Troubleshoot and fix performance issues with Application server and Web server.
• Implementing Single Sign On.
• Have applied fixes, patches and Maintenance Packs for HR8.20 Instances using Upgrade Assistant Tool.
• Configured SSL for Production Instance with Verisign 128 bit SSL Certificate.
• Configured Load balancer for Web Server.
• Configured LDAP
• Adding Languages for PeopleSoft database, post installation of PeopleSoft database.
• Developed and automated shell scripts to delete the cache for application server and process scheduler.
• Developed and automated shell scripts to update DBMS statistics for production and test environment.
• Monitoring the production instance using Topaz monitoring tool and troubleshoot the performance issues.
• Maintaining PS-databases and health monitoring, proactively working on space management issues with database.
• Maintain scripts,shells using Visual Security Source for version control.
• Maintain all the hardware, software installations, modifications, implementations in Chameleon Action Request System.

S/W Environment:

People Tools 8.49.11/HR8.9ML, People Tools 8.47.04/HR8.9ML, PeopleTools 8.20.09/HR8.3.and Web logic 5.1/8.1/9.2,Tuxedo 6.5/8.1/9.1, Oracle 10g/11g

Operating System:

Unix 5.3/5.8/5.10, Windows 2000/2003.

Confidential

Senior PeopleSoft Database System Administrator

Responsibilities

• Creating and Maintaining PS 8.48/Financial and 8.9 DEV/TEST and PRD Environment.
• Applied maintenance packs for the DEV/TEST and PRD environment.
• Installed Oracle 10g on Windows and UNIX servers.
• Configured application server, web server and process scheduler domains.
• Responsible for cloning and refreshing development, test databases with production data.
• Troubleshooting application server, process scheduler performance issues.
• Configured Report Repository for the environment.
• Applied People tools 8.48.09 tools patch for the environment.
• Tuned application server. Web server and Process Scheduler performance issues.
• Configured Integration Broker and Application Messaging.
• Configured People Tools workstation clients for development team
• Exported PeopleSoft Security to preserve and import the security post refresh.
• Responsible for project migration, applying patches and fixes and tax updates, and database activities like database refresh, tuning and security tasks.
• Escalating critical issues to PeopleSoft GSC Analyst and following up the case.

S/W Environment:

People Tools 8.48.09/ Financial 8.9, and Web logic 8.1, Tuxedo 8.1 and Oracle 10g

Operating System:

Aix 5.8, Windows 2000/2003.

Confidential

PeopleSoft System Administrator

Responsibilities

• Creating and maintaining DEV/TEST and PRD PS instances.
• Maintaining multiple PS-Instances for Development and Production like DEV, DMO, TST and PRD.
• Successfully completed the PeopleTools upgrade from 8.44 to 8.46.
• Applied maintenance packs for the environment.
• Assigning users to the particular business units and giving access to them based the requirement.
• Configured the report nodes for the instance
• Configured the context-sensitive help for the instances.
• Automating daily jobs using cron for updating statistics incrementally.
• Load balancing app server/web server domain based on User load.
• Configured SSL for Production Instance with Verisign 128 bit SSL certificate.
• Create Windows client profiles for various development, test and production users and install.
• Maintain integrity and internal consistency of the database using DDDAUDIT, SYSAUDIT reports periodically.
• Performed server admin tasks with Batch, Web and Application server.
• Reviewed IT central and development group change procedures and make recommendations for improvement.

S/W Environment:

FSCM 8.9/8.44.07,FSCM 8.9/8.46.04, HR 8.9/8.46.07, Weblogic 8.1, Tuxedo 8.1, Oracle 9i, Windows NT, Sun Solaris

Operating System:

AIX 5.8, Windows 2000/2003.

Confidential

Satyam Computer Services

Responsibilities

• Installed and configured Peopletools 8.44/HRMS Campus Solutions 8.9 and Oracle 9i on Linux, Windows.
• Installed and configured Peopletools 8.44/CRM8.9 and Oracle 9i on Linux, Windows.
• Configured PeopleSoft domain on DMZ
• Configured Integration Broker/ Messaging Servers and Channels for pumping employee data from CRM to other applications.
• Configured SSL for Production Instance with Verisign 128 bit SSL Certificate.
• Configured n-Vision report and SMTP/FTP.
• Transferring the windows Application/Batch sever environment to AIX system using the server transfer program PT821
• Installed Mobile Agent and had done uploaded changes, updated business data, updated applications.
• Troubleshooting the port conflicts for Mobile Agent.
• Checking the Health of Appserver and Process Schedulers.
• Exported PeopleSoft Security to preserve and import the security post refresh.
• Escalating Issues related to PeopleSoft Applications to PeopleSoft GSC and coordinating with analyst.
• Refreshment of development database with production.
• Complete IVT Installation Verification Test

S/W Environment:

People Tools 8.44.06, PeopleSoft CRM8.9, Web logic 8.1, Tuxedo 8.1 and Oracle 9i

Operating System:

Sun Solaris 5.3, Windows 2000/2003.

Confidential

Peoplesoft Database System Administrator

Satyam Computer Services

Responsibilities

• Installed and configured PeopleSoft 8.x HRMS/CRM/EPM/ENTERPRISE PORTAL with People Tools 8.4x
• Configured PeopleSoft domain on DMZ.
• Setup, configuration and administration of PeopleSoft Application server, Process Scheduler, Web Logic server 6.1/8.1 and Tuxedo 6.5/8.1.
• Load balancing app server domain based on User load.
• Maintaining PS tools and application backups and installing People Books.
• Responsible for project migration, applying patches and fixes and tax updates, and database activities like database refresh, tuning and security tasks.
• Configured n-Vision report for development team.
• Establish and maintain sound backup and recovery procedures. Preparing scripts to automate backup and monitoring database.
• Have applied fixes, patches and maintenance packs for CRM instances using Change Assistant Tool.
• Collecting periodical database statistics for better performance.
• Set-up and maintain documents and standards.
• Escalating Issues related to PeopleSoft Applications to PeopleSoft GSC and coordinating with analyst. .
• Installed Ascential datastage7.5 server and client, and configured with EPM instance.

Environment:

HRMS 8.4x/8.x,EPM 8.4x/8.x, FIN 8.x, Oracle 9i, DB2 AIX ,SQL Server, Windows NT, Sun Solaris,AIX.