SUMMARY

• Over 9 years of IT industry experience in Peoplesoft as Administrator and DBA on Unix and Windows based platforms.
• Roles and duties ranging from Architect, Senior Consultant, Installer, Production Support Analyst on several PeopleSoft end to end Implementations and Maintenance projects.
• Experience of implementing PIA on prod and non - prod instances.
• Performed PeopleTools and application modules end to end installation, including tax updates, database cloning and refreshing, Production data change, report nodes configuration and troubleshooting of web server, application server and process scheduler.
• Day to day management of all Peoplesoft Systems like HCM/FSCM/SCM/Portal/CRM/EPM.
• Administration and maintenance of Peoplesoft servers.
• Management and maintenance of Peoplesoft Dev, Test, Uat and Prod Environments.
• Performance Tuning of Peoplesoft servers and environments.
• Ongoing maintenance and application of patches and upgrades.
• Peoplesoft and pre-requisite software installations.
• Configuration and maintenance of webserver, application server and batch servers.
• Configuration of load balancing of Peoplesoft PIA servers.
• Monitoring and maintenance of system health.
• Troubleshooting and fixing Peoplesoft performance issues and errors.
• Researching and apply Peoplesoft application and PeopleTools maintenance packs, patches and fixes.
• Upgrading PeopleTools installations.
• Migration of scheduled Peoplesoft changes from Dev->Test->Uat->Prod.
• Applying tax updates.
• Work with development teams to ensure quality developments and availability of test environments.
• Working with various Project Teams to develop requirements and decide deliverable dates for new Peoplesoft installs and upgrades.
• Providing support to users.
• Researching, Troubleshooting and opening cases SR with Oracle support.
• Tuning of Peoplesoft application and webservers parameters.
• Attending meetings with users and development teams to track progress and issues.
• Install, troubleshoot and maintain PeopleSoft Internet Architecture components including App Servers, Process Schedulers, and Web logic Servers.
• Plan and manage teh installation of application patches and maintenance releases on development, test, QA and production environments.
• Proactively plan for future capacity requirements by calculating growth of teh application in teh areas of database size, number of end-users and application functionality.
• Participate in disaster recovery and business continuity planning.
• Identify and participate in application architecture solutions for improving teh reliability, performance and availability of teh systems.
• Interact with analysts and user community to analyse, diagnose, and troubleshoot problems. Prepare and deliver recommendations to resolve issues in a timely manner.
• Provide technical administration and migration support for various PeopleSoft environments.
• Ensure application change control and migration strategy policies are followed.
• Manage systems for high availability, and satisfactory response time.
• Manage, monitor, administrate and middle tier support of teh PeopleSoft applications.
• Install, maintain and support of various third party and PeopleSoft components like Application Designer, Application Engine, Process Scheduler, PeopleCode, HTML, SQR, PS Query, Crystal Reports, Cobol, nVision and Workflow.
• Create and maintain technical documentation.
• Support and Troubleshoot Integration Broker, Message, Component Interface and third party interfaces.
• Configuration Management - Configuring and Editing Application Servers, Process Scheduler, & Web Server.
• Application Management - Applying Fixes, tax Updates and Tool Patches.
• Performing Database refresh.
• Perform Data Changes.
• Oracle Database administration which includes granting users access through SQLPLUS utility.
• Migrating projects across various environments.
• Performing Peoplesoft environment refresh.
• Troubleshooting issues in Oracle and PS related Issues.
• Responsible to provide teh 24*7 support for production databases.
• Performance tuning of SQL statements used for reporting and queries.
• Responsibilities not limited to Architect PeopleSoft environment, Installations and Administration of teh PeopleSoft PIA environment.
• Data migration and extraction.
• Backup & Recovery, Patch strategy and Procedures. Database cloning and Manageing multi-instance hosting environment.
• Perform as PeopleSoft DBA, configure Report Repository using http and ftp, copying databases and setup new PeopleSoft environments.
• Setup PeopleSoft Web server (Web logic), Application server domains, Process Scheduler, Crystal Reports, SQR, COBOL compiler installation/configuration
• Installed, configured Web server, Application server, Process Scheduler, Report Servers
• Database Tuning and PeopleSoft Application Performance Tuning
• Created PeopleSoft 8.46 databases (Demo, Development and Production). Migrate data from one database server to other
• Performed SYSAUDIT, DDDAudit, Alter audit, Data Mover, Compare Reports.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation, PS Analytic services.
• Additionally worked on tools like PVCS version control, PGP Keys - for encryption, Stat.
• Installed Verity and configured PeopleSoft Books for context sensitive help.

TECHNICAL SKILLS

PeopleTools: PeopleTools 8.46/8.48/8.49/8.50/ Application Designer, Data Mover, Configuration Manager, Application Engine, Query Manager, Tree Manager

Application: PeopleSoft HRMS, PeopleSoft Financials, PeopleSoft EPM, PeopleSoft CRM, PeopleSoft Enterprise Portal ver 8.8/8.9/9.1/9.2

Reporting Tools: SQR, Crystal Reports, PS Query, nVision, Hyperion

Webservers: Weblogic 8.1/9.2/10gR2, Websphere.

Languages: SQL, PL/SQL, C, C++, Java, .net, PHP

Upgrade Tools: Change Assistant, Upgrade Assistant

Version Control Tools: PVCS, STAT

Operating Systems: Red Hat Linux, AIX, Solaris, HP-UX, Win 9x/XP/ME/NT/2000/2008 server.

Productivity Tools: MS Office (Word, Excel, PowerPoint), Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Peoplesoft DBA / Administrator

Responsibilities:

• Installation of Oracle and PeopleTools 8.48/8.50/8.51 and application HCM/FSCM/EPM 8.9/9.0/9.1 software to create new environments.
• Creation of seed database, database refresh and cloning activities as per requirement by means of Hot and Cold backups via scripts or via RMAN.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA) servers including database server.
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Create and maintain technical documentation.
• Handling change control as per established standards.
• Performance Tunning of Webserver, Application Server and Database Server including various configuration related parameters.
• Co-ordinated with infrastructure team, Citrix team, Database admin team for resolving issues.
• Performed Database Cloning on Peoplesoft instances as per development team requirement.
• Proactively monitor teh servers and diagnosing and correction issues when required.
• Performed Database Refreshing on Peoplesoft instances.
• Development and participation during DR Drill and DR planning.
• Making sure development team requirements are met including make suggestions and recommendations to optimise teh activities and automate tasks wherever possible.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Conducting KT and noledge sharing sessions among team as required while providing technical documentation to help others.
• Configuring Change Assistant.
• Monitoring Alert log file for any database related issues.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Monitoring database health via OEM and check if any memory SGA parameter needs to be tuned.
• Installations and configuration of Crystal Reports, nVision..
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces either via ASM or via fixed allocation.
• Taking Backup’s logical and physical backup.
• Troubleshooting Integration Broker, message flow issues.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, Test servers creation.

Confidential

Senior Peoplesoft Administrator

Responsibilities:

• Installation and upgrade of PeopleTools and Applications Campus Solution 9.0 module.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA).
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Performance Tunning of Webserver, Application Server and Database Server.
• Co-ordinated with infrastructure team, Citrix team, VDI team, Database admin team for resolving issues.
• Performed Database Cloning and refreshing on Peoplesoft instances.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Configuring Change Assistant.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Installations and configuration of Crystal Reports, nVision, Application Engine.
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces.
• Taking Backup’s using Hot Backup, Cold Backup and RMAN Backup.
• Troubleshooting Integration Broker, message flow issues and configuring Ren Server.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation.

Confidential, CA

Senior Peoplesoft Administrator / DBA

Responsibilities:

• Installation and maintenance of PeopleTools 8.48/8.50 and Applications modules HCM/FSCM 8.9/9.0.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA).
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Performance Tunning of Webserver, Application Server and Database Server.
• Co-ordinated with infrastructure team, Citrix team, VDI team, Database admin team for resolving issues.
• Performed Database Cloning and refreshing on Peoplesoft instances.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Configuring Change Assistant.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Installations and configuration of Crystal Reports, nVision, Application Engine.
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces.
• Taking Backup’s using Hot Backup, Cold Backup and RMAN Backup.
• Troubleshooting Integration Broker, message flow issues and configuring Ren Server.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation, PS Analytic services.

Confidential

Senior PeopleSoft Administrator / DBA

Responsibilities:

• Responsible for teh maintenance, support, testing and tuning of teh PeopleSoft FSCM, HCM application environments including Demo, Development, Test, Training and Production.
• Installation and upgrade of PeopleTools and HCM/FSCM 8.9/9.1 application module.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA).
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Performance Tunning of Webserver, Application Server and Database Server.
• Co-ordinated with infrastructure team, Citrix team, VDI team, Database admin team for resolving issues.
• Performed Database Cloning and refreshing on Peoplesoft instances.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Configuring Change Assistant.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Installations and configuration of Crystal Reports, nVision, Application Engine.
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces.
• Taking Backup’s using Hot Backup, Cold Backup and RMAN Backup.
• Troubleshooting Integration Broker, message flow issues and configuring Ren Server.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation, PS Analytic services.

Confidential, SFO, CA

PeopleSoft Administrator/DBA

Responsibilities:

• Created a Oracle seed database and loaded demo/system databases using Data Mover.
• Installation and maintenance of PeopleTools 8.48 and FSCM 8.9 module.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA).
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Performance Tunning of Webserver, Application Server and Database Server.
• Co-ordinated with infrastructure team, Citrix team, VDI team, Database admin team for resolving issues.
• Performed Database Cloning and refreshing on Peoplesoft instances.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Configuring Change Assistant.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Installations and configuration of Crystal Reports, nVision, Application Engine.
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces.
• Taking Backup’s using Hot Backup, Cold Backup and RMAN Backup.
• Troubleshooting Integration Broker, message flow issues and configuring Ren Server.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation, PS Analytic services.

Confidential

PeopleSoft Administrator / DBA

Responsibilities:

• End to end Peoplesoft deployment from scratch including Oracle database creation and software installation.
• Installation and maintenance of PeopleTools 8.51 and Applications Campus Solution 9.0 module.
• Implementation and monitoring of Peoplesoft Internet Architecture (PIA).
• Configuration of Web Server, Application Server, Process Scheduler and Database Server.
• Performance Tunning of Webserver, Application Server and Database Server.
• Co-ordinated with infrastructure team, Citrix team, VDI team, Database admin team for resolving issues.
• Performed Database Cloning and refreshing on Peoplesoft instances.
• Applied PeopleTools Fixes, Patches, Bundles, Maintenance Packs.
• Setting up development environment for Peoplesoft Developers.
• Configuring Change Assistant.
• Report Node Configurations.
• Project Migrations.
• Performing Production Data Change PDC/RFC.
• Installations and configuration of Crystal Reports, nVision, Application Engine.
• Clearing of Caches of Webserver, Application Server and Process Scheduler.
• Auditing - Executing DDD Audit, SYS Audit, Alter Audit.
• Generating of Reports.
• Troubleshooting Web Server, Application Server and Process Scheduler.
• Installed Verity and configured PeopleSoft Books for context sensitive help.
• Creation of new databases and tablespaces.
• Taking Backup’s using Hot Backup, Cold Backup and RMAN Backup.
• Troubleshooting Integration Broker, message flow issues and configuring Ren Server.
• Troubleshooting Peoplesoft Internet Architecture, integration broker, Application messaging flow, process scheduler issues, portal administration, Test servers creation.