Summary:

• Over 11 years of working experience as PeopleSoft Admin with expertise in PeopleSoft Upgrade, Implementation and Maintenance.
• Experienced in handling multiple PeopleSoft Environments like HCM, FSCM, CRM and Portal Applications hosted on both UNIX and Windows NT Operating System.
• Working experience on latest version of Application version HCM 9.2 and recent version of People Tools version 8.53
• 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.
• Microsoft Certified Professional MCP and Microsoft Certified Systems Administrator MCSA .

Oracle Database Expertise:

• Installing, Creating and Configuring Oracle databases 10g / 11g.
• Expertise in Patching Oracle Database like Patch Set / CPU / PSU Patches.
• Strong hands on experience in Managing Oracle Database Space / Un-Do / Table space.
• Creating Database user / Roles and granting Privileges.
• Tracking database growth trends for capacity planning.
• Troubleshooting and resolving database / application failures.
• Performing database backup and restore using RMAN.
• Fine tuning SQL queries and scripts.
• Performance monitoring of database and resolving related issues.

Technical Skills:

• PeopleTools 8.4x, 8.5x Applications v8, v9.1 / 9.2 : HCM, FSCM, CRM, EPM and PORTAL.
• Databases: Oracle 11g/10g/9i , SQL Server 2008/2005 and DB2 UDB v8.x, v9.x .
• UNIX systems: AIX, Oracle Enterprise Linux and Red Hat Linux.
• Microsoft: Windows 2003/2008 Server: Standard, Enterprise and Advanced.
• Peoplesoft tools: Application Designer, Data mover, Configuration manager, Change Assistant.
• Performed Database migration of PeopleSoft database involving DB2, MS SQL Server and Oracle.
• Environment builds and database refreshes from Development to Production.
• Configured Change Assistant for Tools/Application Upgrade and to apply patches, bundles, MPs and Tax updates.
• Involved in administration of Application Servers, Weblogic, Tuxedo and Batch Servers for Optimum performance.

Work Experience:

Confidential

Environment : PeopleSoft HCM 9.1 / 9.2, People Tools 8.51 / 8.53, DB2 9.5

Responsibilities:

• Involved in Installation of HRMS 9.2 environments with latest peopletools version 8.53 and other recommended middleware applications like weblogic tuxedo.
• Configuring Application, Web Batch server for newly created 9.2 environments.
• Established client workstations for the developers to connect with new Peoplesoft Instance.
• Involved in the PeopleSoft application tasks such as performing project migrations using STAT and app designer, managing and troubleshooting PeopleSoft infrastructure including application servers, web/PIA services, process schedulers, etc. running on PeopleTools 8.5x
• Performance tuning, modified configuration file settings like enabling jolt session pooling in web.xml and enabling self tuning thread count in config.xml
• Migrated security related objects of the applications from the development database to unit testing and system testing and then finally to the production during rollout. This included keeping all the databases consistent and in sync.
• Applied Tax update 14A, 14B, patches and HRMS 9.1 bundle 14.
• Worked on issues reported by the application team, troubleshoot and provide resolution for different types of issues.
• Performed PeopleSoft environment refresh tasks on a weekly basis including customized security export before refresh and perform post refresh steps.
• Exported and imported PeopleSoft security using Data mover scripts to sync all non-prod environments.
• Involved in monitoring and automation of Application server, Web server and Process scheduler at the regular intervals.

Role : PeopleSoft Admin

Confidential

Responsibilities:

• Administration of People Tools and Applications installed on AIX and Windows servers.
• Involved in various PeopleTools upgrade and configured the change assistant and maintained the tool upgrade templates till MoveToProduction.
• Ran data mover scripts during the upgrade and to reset/encrypt PeopleSoft passwords after database refreshes.
• Handled large volume of migrations using STAT, data mover application designer
• Sync different environments, analyze compare reports, dddaudit, maintaining permission lists in sync with new development efforts across all Dev Test environments.
• Tuned various levels of PeopleSoft Internet Architecture for performance, some configuration files that were modified were psappsrv.cfg, setenv.sh, etc.
• Creation and troubleshooting of Web App Clustering of domains and supporting iPlanet Siteminder agent integration with PeopleSoft.
• Applied Payroll Tax updates to the demo, development and Production environments.
• Applied various HR, Payroll and Financial fixes and patches, unit tested them and assisted in migrating across different environments.
• Involved in the post database refresh procedures like resetting passwords, setting up report nodes, cleaning up the process scheduler, process monitor tables, cleaning up app messaging tables, etc
• Set up user work stations to give them access to Application Designer, Data Mover, Oracle SQL client and Configuration Manager.
• Performed monthly security audits e.g. Application Designer Access, Generic ID's, Support staff access, 'Super User' access, local accounts, etc
• Implemented shared cache feature to improve response time after initial login.
• Co-ordinate with Oracle DBA team in performance tuning and database refresh activities and also with Unix Server team for any OS patch maintenance activities.
• Installation and maintenance of OBIEE 11g data warehouse for reporting purposes Application.

Role : PeopleSoft DBA

Confidential

Responsibilities:

• Administration of the upgraded PeopleSoft Environment.
• Installed, configured supported Oracle, PeopleSoft Application Servers, Process Schedulers and Web Servers and managed PeopleSoft Internet Architecture for test environments.
• Installed PeopleTools client, Crystal, and Oracle clients on developers work stations.
• Configuring REN Server for Production and Non Production environments.
• Performed object and code migrations of customizations and maintenance patches and fixes.
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• Populated data into PeopleSoft Database via Datamover Scripts.
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles with roles and permission lists.
• Supporting User requirement for forgotten / expired passwords, account lockouts etc.
• Involved in SQL tuning and troubleshoot other performance related issues.
• Tuned Application Servers, Web Servers for performance improvements.
• Monitoring the Sessions in Production database and killing the unwanted sessions as per the request.
• Analysing AWR report to find the root cause for long running queries and get it tuned accordingly to improve the performance.
• Did analysis, trace and debugging of the processes which are running slow and took necessary action to get good performance
• Cleaning up the Stale data in Prcs scheduler tables in Production and Non-Production environment from backend to ensure that the Prcs server is working fine.
• Performed Oracle database refreshes as needed so as to facilitate the implementation of patches and fixes as delivered by PeopleSoft.
• Applied PeopleTools upgrade patch from PT8.51.05 to PT8.51.11 Financial system.

Role : PeopleSoft DBA

Confidential

Responsibilities:

• Performed Peopletools upgrade from 8.49 to Tools version 8.50.07
• Performed Application upgrade of PeopleSoft HRMS from 8.9 to 9.1
• Installed, setup and configured upgrade environments/infrastructures.
• Worked on setting up and configuring PeopleSoft Change Assistant to perform updates and upgrades.
• Performed and prepared vanilla compare report to find the customizations.
• Worked with functional analysts to determine upgrade strategy for each customization.
• Customized upgrade scripts to accommodate/capture function specific changes identified on compare reports which ensured that customized objects are carried along in the upgrade process.
• Executed both technical/database upgrade scripts in proper sequence and monitored and recorded script execution time.
• Streamlined the upgrade process to complete within the allotted upgrade window.
• Planned, coordinated and executed the entire upgrade phase from the Initial Pass to the Final Move To Production pass Go-Live .
• Installed/Maintained/Configured/Monitored PeopleSoft infrastructure components Batch Servers, Application Servers, Web Servers and the Database Server on UNIX and NT platforms.
• Configured Integration Broker on new hardware and addressed various problems for developers.
• Applied Tax updates for multiple clients.
• Performed pre-patch analysis on recent people tools and application patches.
• Deployed Application and Web Server domains after upgrading people tools versions.
• Developed custom Unix scripts to monitor application servers and web server system resource usage and for any technical issues during maintenance window.
• Provided support for systems projects, monitored data integrity, troubleshooting problems with established processes.
• Performed Oracle database creation, replication and refresh for new/existing PeopleSoft test/upgrade environments.

Role : PeopleSoft DBA

Confidential

Responsibilities:

• Involved in Peoplesoft upgrade activities for HRMS 8.8 to 9.1 and Peopletools version from 8.48 to 8.50.
• Responsible for Installing and configuring Change Assistant for upgrades.
• Creating configuring infrastructure supporting Peoplesoft upgrades in building staging database and application servers during multiple test passes.
• Performed the Cobol setups and compilations for the upgrades/setup of environments.
• Involved in setting up PeopleSoft Reporting environment for reporting.
• Provided production support for HRMS instance.
• Migrate data and PeopleSoft objects between environments as required by implementation cycle using Application Designer, Data Mover and SQL tool.
• Debugging and resolving issues related to application server web server process scheduler.
• Performed extensive shell scripting for monitoring the application and web server environments
• Perform the daily or weekly environment refreshes for the support and development environments.
• Coordinate work with other teams UNIX System Administrators for any system maintenance and upgrades e.g., storage upgrades - file system .