SUMMARY

• Over 10 years of working experience as PeopleSoft Admin with expertise in PeopleSoft Upgrade, Implementation and Maintenance.
• Experienced in handling multiple PeopleSoft Environments like HCM, EPM and Portal, Applications hosted on both UNIX and Windows NT Operating System.
• Working experience on version of Application version HCM 8.9, 9.1 and recent version of People Tools version 8.52
• Applied People Tools patching, bundles, maintenance packs and Tax Updates in multiple support/maintenance projects.
• Hands on experience in troubleshooting Peoplesoft Application Server and Webserver logs for any kind of performance issues.
• Very good experience in migrating customized objects between the environments using Application Designer and STAT.
• Worked on Data Mover tool to export/import data between Peoplesoft environments.
• Expertise in performing database refreshes & cloning of Peoplesoft Instances.
• Involved in setting up Integration Broker and configuring application messages, also troubleshooting any issues related to Integration Broker messaging system.
• Ability to configure and setting up 2 - tier / 3-tier Workstation Application Designer connectivity for the developers to work on Peoplesoft Instance.
• Well-versed in database related performance tuning, applying DB patches and version upgrade.
• Worked on Upgrade project plans which include identifying tasks, resources required, estimation of time and effort.
• Worked on multiple PeopleSoft upgrades from various Tools and Application releases with different databases and platforms
• Expertise in service delivery with excellent client management skill, conducting periodic project performance reviews, preparing/executing training plans and mentoring team.
• Worked on Disaster recovery (DR) & Continuity of Business (COB) plans to ensure Business is normal and ready to deal with catastrophic events.
• Successfully implemented LDAP integration with Peoplesoft Applications.

TECHNICAL SKILLS

PeopleTools: (8.4x, 8.5x) & Applications (v8, v9.1 / 9.2) HCM, EPM and PORTAL.

Databases: Oracle (11g/10g/9i), SQL Server (2008/2005) and DB2 UDB (v8.x, v9.x, v10).

UNIX systems: AIX, Oracle Enterprise Linux and Solaris.

Microsoft: Windows 2003/2008 Server Standard, Enterprise and Advanced.

Peoplesoft tools: Application Designer, Data mover, Configuration manager, Change Assistant.

Third Party Tools: Informatica Business Objects, SFTP Connect Direct Autosys4.5, 11.3.5, Stat 5.6.1

PROFESSIONAL EXPERIENCE

Confidential, MI

Technological Lead, Production Support

Responsibilities:

• Working as 24X7 Primary production support DBA for all Peoplesoft HRMS environments
• PeopleTools 8.52/06/09, PeopleSoft Campus Solutions 8.9/9.1, DB2 UDB 9.5
• Perform the Fit Gap Analysis for application/tools upgrade and document the findings.
• Upgrade to People tools 8.52.09 from 8.48/8.50 for HRMS & Campus solutions.
• Apply patches and bundles
• Install People Books for HRMS 9.1
• Supported People Tools 8.48/8.50/8.52
• Created Application Server Domains and Process Scheduler Domains
• Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST, STG and PROD databases
• Involved in tuning Databases for better performance
• Perform PeopleTools on all the environments
• Perform Data migration on the entire PeopleSoft payroll an HR environments for upgrade
• Validate the migrated data and prepare a test result document
• Support the PeopleSoft development team on the object migration, environment setup and database management
• Interact with Peoplesoft vendor on the Service packs
• Performing reorg and run stats for the table objects periodically and when there was data change in the tables
• Involving in performance tuning for the SQL's, databases and operating systems by analyzing the setup
• Involving in database refresh for DB2/UDB databases for syncing the production data in the offshore development environment.
• Creating the Migration report for all the PeopleSoft objects which has been migrated to Production on Weekly and Monthly for SOX review.
• STAT Patch upgrade done from 5.5.2 to 5.5.4 and 5.5.6 to 5.6.1
• Automated process using Unix Shell Scripting
• Implemented the RC Shutdown/Start-up Scripts in Development and Production Servers
• Configure Web server Security using SSL certificates
• Upgrade Autosys 11.3.5 from 4.5/4.5.1
• Working closely with Infrastructure Director/Manager to provide the latest tools/technology availability.
• Working with Work Stream leads to explain the new patches/fixes and MP's release notes.
• Working with Client/Customer managers to add/update the Upgrade process with Client modified Objects.
• Troubleshoot any issues with App/WEB/Process scheduler and provide solutions timely.
• Create Cronjobs for scheduling shell scripts on regular time intervals ( minutes, hours, daily, weekly, monthly, quarterly, yearly )
• Implementation of SSL on all PeopleSoft Production and UAT environments using VeriSign certificates
• Implement and Configuration of RENSERVER for HRMS
• Participated yearly corporate wide Disaster Recovery Exercise
• Worked with Network groups for implementing Hardware level Webserver load balancing
• Implementation of Datapump for regular logical exports/imports on all PS environments
• Customize and create Lower environment refresh script for weekly full database refreshes using Datapump.

Confidential

PeopleSoft Admin

Responsibilities:

• PeopleSoft Administrator and Technical Support for HRMS 8.3 and 8.8
• Tools Upgrade for HRMS .12
• Development Support of Sony, Medco, Baylor and Goldman Sacs.
• Administered and configured STAT migration software.
• Performed extensive tuning on Application Servers.
• Managed PeopleSoft HRMS on DB2 UDB databases on UNIX.
• Providing expertise in PeopleSoft Architecture Administration and Security Administration.
• Performing extensive application support for all modules.
• Performing patch installations, stabilization of production systems and batch processes.
• Assisted in troubleshooting Web Server production problems
• Setting up the n Tier web environments for various clients, which involve creating the
• Connectivity between the workstations (clients), web servers, Application Servers and Database servers.
• Setting up the Tuxedo application server domains, which involve establishing connectivity to the Database server, assigning the various processes for handling messaging and queue the queries with the database and Assigning the network ports for the application server domains (JSL) to establish the connectivity with the web servers by the client
• Creating the Process scheduler domain for PeopleSoft environment to run the SQL's repeatedly and also for query involving a huge repetitive transaction.
• Configuring the Debugging Mode for the domains to enable the users to debug their code.
• Analyzing the application server, DB server and O/s level log files for any performance issues or infrastructure related issues.
• Analyzing the performance of the application servers and DB servers and act accordingly of PeopleSoft and act accordingly.
• Co-coordinating with the users to solve their day-to-day issues both on the PeopleSoft issues and UNIX issues.
• User account administration like adding the UNIX IDs to the secondary groups appropriate to the clients and password management for the users. Also account administration on the PeopleSoft domains and attaching roles and privileges to the users.
• Maintaining the IBM Tape Library and defining the Backup strategy using CAs ARC serve 11.0 software for the UNIX servers and Windows servers.
• Administrating, Maintaining Active Directory.
• Administration and maintenance of Symantec Antivirus Corporate Edition 10.1.5. Daily monitoring of virus information, Security threats, risks and latest updates of virus definitions of computers
• Creating, Modifying and deleting backup Jobs for all the development Servers and scheduling it accordingly.
• Creating the media pools for maintaining the Tape inventory using Save set and scratch set.
• Exporting and importing the 100/200 GB tapes for daily/Weekly/Monthly backups
• Restoring the required files with the ARC serve using backup tapes
• Maintain the Active directory domain for the users to log on to their desktop and to have access to the fileserver.
• Creating users, Distribution Lists and maintaining their records in AD and Exchange. This involves new hire creation, modification of user groups and also termination of user accounts.
• Group policy implementation for restricting the access to CD, USB and Floppy drive.
• Installed and Configured WSUS for the entire domain and periodic updates done through pushing over WSUS for the computers. WSUS Installation, Configuration and Administration.
• Maintaining desktops and servers through remote monitoring tools like, RDP, Dame Ware and Control IT.

Confidential

PeopleSoft DBA

Responsibilities:

• Installation of HRMS Application 8.9 and People Tools 8.46
• Install & Implementation of PeopleTools & PeopleSoft application and other required components like Tuxedo, Java, WebLogic, Verity etc.
• Working with PeopleTools and Application upgrade with Application Development team.
• Install and configure change assistant for PeopleSoft upgrade or patches.
• Create and deploy application server, webserver, process scheduler.
• Performing migrations through Quest STAT.
• Apply PeopleTools and WebLogic patch.
• Apply Tax updates for HCMS application
• Implementation of User Productivity Kit (UPK) and integration of PeopleBooks.
• Implementation of WebLogic cluster with multiple application servers.
• Coordinating with other support teams in setting up the environment.
• Administer Application server, Web Server, Process Scheduler.
• Troubleshooting issues in Application server, Process Scheduler and PeopleSoft related Issues