SUMMARY:

• Over 10 years of result oriented professional experience with PeopleSoft applications and Oracle/SQL Server databases
• Experience with implementation projects. Implemented PeopleSoft Financials and HCM
• Expertise in PeopleSoft Upgrades involving PeopleSoft HCM 8. 9 to 9.2 at HEB, HCM 8.8 to 9.1 at Confidential, Financials 8.8 SP1 to 9.2 at Confidential Ltd and HCM 8.4 to 9.0 at Confidential . In addition, performed multiple PeopleTools Upgrade on various projects
• Experience with Integration Broker. Setup and configured Integration Broker for messaging between Financials and HCM. Also setup IB to 3rd party applications. Tuned, executed and monitored many App messages. Tuned and resolved many issues related to Integration Broker on various occasions
• Experience with PeopleSoft Installations. Installed all the server components on the corresponding tiers of the PeopleSoft Architecture. Created PeopleSoft Database, Application Server, Web Server and Batch Server. Used WebLogic on the Web Server in all the projects
• Extensive experience with WebLogic Servers. Created distributed multi - server domains to create WebLogic Clusters. Setup proxy servers, and worked on SSO setup
• Experience with PeopleSoft maintenance. Extensive experience using PeopleSoft Change Assistant for applying bundles, maintenance packs and tax updates including the latest PeopleSoft Update Manager
• Experience working on performance tuning and load balancing. Experience working with PeopleSoft Performance Monitor. Setup PPM to monitor many PeopleSoft environments
• Experience working as PeopleSoft Security Administrator; Created and maintained Users, Roles and Permission Lists. Experience working with SSL s. Installed SSL s on all the web servers. Setup REN Server and installed a separate SSL for the REN server
• Experience working with Quest STAT. Performed migrations using STAT
• Experience working with PeopleSoft Process Schedulers, SQRs, COBOL programs, nVision, Crystal Reports, Application Engine programs, and PeopleCode. Used many scheduling tools like AutoSys, Maestro, and ControlM for scheduling and running jobs
• Experience with some Database related activities with Oracle Databases. Some of the activities were, taking hot/cold backups, performing refreshes, performing export and import, monitoring the database, and running SQL trace. Experienced in cloning the database using cold and hot backups
• Excellent experience with latest Products and Upgrade of PeopleSoft HRMS 8.9/9.0/9.1/9.2 and Financial 8.8/8.4/8.4 SP1/8.4 SP2/9.1/9.2 and PeopleTools 8.1x/ 8.4/8.42/8.43/8.44/8.46/8.48/8.5 x
• 24x7 support provided during on-call schedules
• Experience in Integrating Oracle Access Manager with PeopleSoft
• Experience in Working withOracle Supportto resolve issues and open TAR / SR

TECHNICAL SKILLS:

Peoplesoft: Financials/SCM 9.2/9.0/8.9//8.8/8.4/8.0 , HCM 9.2/9.1/9.0/8.9/8.8/8.3 , CRM 8.8/8.4, and Portal 9.1/8.9/8.4; PeopleTools 8.54/ 8.53/ 8.52/ 8.51/ 8.50/ 8.49/ 8.48/ 8.47/ 8.46/ 8.44/ 8.21

Application Servers: Tuxedo 11g/ 10.3/9.1/8.1/6.5

Web Servers: BEA WebLogic 11/10.3/9.2/8.1/6.1 , Oracle Application Server, IBM WebSphere Application Server (WAS) 4.0/5.1, Apache Tomcat 4.1/5.x, and Microsoft IIS 4.0, 5.0/6.0

Databases: Oracle 11g/10g/9i/8i & MS SQL Server 2000/2008/2012

Operating System: UNIX (HP-UNX, Sun Solaris, IBM AIX) and Red Hat Linux, Windows 2000/2003/ 2008/ NT Server/Workstation

PeopleSoft Utilities/Tools: Application Designer, Data Mover, Configuration Manager, Change Assistant, PS Query, PS Security, REN server, PPM, Integration Broker

Oracle Utilities/Tools: Oracle Enterprise Manager DB Console, RMAN, SQL Plus

Scheduling Tools: PeopleSoft Process Scheduler, Control M, AutoSys

Reporting: Report Smith, Crystal Reports

Microsoft Tools: MS Office (Word, Excel, PowerPoint), MS Outlook, MS Project, MS Visio

Other Utilities/Tools: Quest Toad, SQL Developer and Quest STAT

PROFESSIONAL EXPERIENCE:

PeopleSoft Administrator & SQL Server DBA

Confidential

Responsibilities:

• Maintained the daily jobs running in MSSQL Server
• Performed database refresh from production to development servers
• Monitored the data file and log files
• Checked and worked on database locks
• Monitored the space issues in production server
• Performed CPU and memory monitoring for SQL Servers
• Involved in installation and configuration of SQL server 2008
• Applied patches and service packs to keep the database at current patch level
• Responsible for configuration of Microsoft Server/Client Products and implementation
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined Data Types and Functions
• Involved in analysis and design documentation, user requirements and maintained good documentation.
• Supported production and development databases
• Managed 17 databases at the headquarters running on different servers
• Developed SQL scripts for maintaining administration tasks
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures
• Created and maintained users and user groups
• Applied PeopleSoft Bundles for HR and Finance
• Applied PeopleTools Patches
• Performed PeopleSoft Migrations using STAT
• Resolved critical issues in the production and ensured customer milestones are met
• Automated Database refresh activities
• Installed and configured Performance Monitor

Environment: Application - HCM 9.1, FSCM 9.1 PeopleTools 8.50/8.52 Migrations: STAT Scheduler: PeopleSoft Process Scheduler Database: MS SQL Server Operating System: Microsoft Windows Server 2008

PeopleSoft Upgrade Specialist

Confidential

Responsibilities:

• Complex Upgrade with high customizations and addition 15 Bolt-on Modules (HR 8.9 to HR 9.2)
• Pre-Upgrade planning includes environment plan, infrastructure plan and disk space plan
• Worked on PeopleSoft HCM 8.9 to 9.2 Upgrade. Executed the Change Assistant job to perform the upgrade. Performed the first initial pass as well as many test move to production passes and the final move to production pass. Documented all the steps in the Change Assistant template. Included the timings for each step. This helped the client to decide on the go live window goals and eventually achieve the goals
• Performed migrations of projects from Development to Test to UAT to production as per the workflow defined and the business rules. Performed the compare project and set the upgrade flags as required
• Installed PeopleSoft Update Manager and used Change Assistant to apply bundles and tax updates.
• Installed and configured all the tiers in PIA setup - The File server, Application Server, Batch Server, Web Servers and Database Server to support the PIA
• Created many PeopleSoft environments. Created WebServer domains. Installed SSL s on the WebServer. Created Application Server domains. Setup load balancing for Application/Web Servers. Created Process Scheduler on the Batch server. Configured and setup Master Scheduler for various Test and Production environments
• Installed Oracle and created PeopleSoft database. Worked along with the DBA for Database analysis and sizing of Production/Test databases, performance issues, Oracle Server installation and maintenance and supporting multiple test instances. Assisted the DBA with SQL tuning and running statistics on the database. Performed database refreshes from the production database as and when required. Performed system verification after the refresh. Created a document for database refresh and system verification. Performed cold backups for all non-production type databases
• Configured Integration Broker setup. Activated messages, configured Nodes and Integration Gateways, modified the Integration Gateway properties file and turned on the PUB/SUB processes on the Application Server
• Made recommendations on hardware and software to meet PeopleSoft and maximize performance. Also worked with PeopleSoft to validate HW/SW requirements for installation. Ensure all performance modifications are identified and documented
• Installed and Configured Oracle SES
• Installed and Configured People Books
• Applied PeopleTools and third party patches
• Configured app/web server failover
• Prepared a document for the post go live activities and a very detailed Hand Over Document, handed the production environment to the Operational Support PS Admin Team to support the environment post go live. Worked hand in hand with the Operational Support PS Admin Team on any issues post go-live, until they were comfortable supporting the new environment

Environment: Application - HCM 8.8, PeopleTools 8.47, Tuxedo 9.x, WebLogic 9.x Database: Oracle 10g Operating System: RHEL 5/6, and Win 2003

PeopleSoft Upgrade Specialist & SQL Server DBA

Confidential

Responsibilities:

• Pre-Upgrade planning includes environment plan, infrastructure plan and disk space plan
• Worked on PeopleSoft FSCM 8.8 to 9.2 Upgrade. Executed the Change Assistant job to perform the upgrade. Performed the first initial pass as well as many test move to production passes and the final move to production pass. Documented all the steps in the Change Assistant template. Included the timings for each step. This helped the client to decide on the go live window goals and eventually achieve the goals
• Performed migrations of projects from Development to Test to UAT to Production as per the Workflow defined and the business rules. Performed the compare project and set the upgrade flags as required
• Installing Source and Target database
• Installing and configuring Change Assistant template
• Downloading all Upgrade related documents and templates
• Apply all required for Upgrade fixes
• Performing Audit cleanup activities
• Executing initial pass and iterative passes
• Troubleshooting and resolving issues during application data conversion
• Analyze compare reports and assist customer in Keep-Drop decision
• Assisting technical team during retro-fitting
• Assistance during Testing and UAT
• Configuring Integration Broker
• Creating multiple Application Servers domain for load balancing and Fail over
• Installed and configured PeopleSoft Update Manager
• Installed and configured Oracle SES
• Installed SQL Server on Windows 2008 Server
• Upgraded SQL Server
• Responsible for General SQL Server Database Administration
• Prepared a document for the post go live activities and a very detailed Hand Over document, handed the production environment to the Operational Support PS Admin Team to support the environment post go live. Worked hand in hand with the Operational Support PS Admin Team on any issues post go-live, until they were comfortable supporting the new environment

Environment: Application - FSCM 8.8, PeopleTools 8.47, Tuxedo 9.x, WebLogic 9.x Database: SQL Server 2000/2008 Operating System: Win 2003/2008

PeopleSoft Administrator

Confidential

Responsibilities:

• Installed and supported many PeopleSoft Applications
• Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 10g & 11G) in production, testing and development environments hosted on UNIX servers (HP, Linux) and Windows servers
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump and hot backup scripts
• Troubleshoot and resolve database and/or application problems encountered by end users
• Performed Tools Upgrade from PT 8.51 to PT 8.52
• Performed Application Upgrade from HR 8.8 to HR 9.1
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 10g & 11g in HP-UX Unix environments
• Ensuring successful and periodical Backup, Restoration & Tuning of databases
• Used Import, Export, SQL*Loader, and other tools to load and backup data
• Good experience in handling RAC production environments
• Configuring and Administering Oracle 10g/11g Automatic Storage Management (ASM)
• Managing Space Management and User management
• Monitoring the Database growth and Tables growth and increase the table space size in production databases
• Logical Backups using Data Pump, Exp/Imp
• Created various PeopleSoft databases running on Oracle
• Implemented scripts in UNIX server to schedule backups
• Done many refreshes and restores of databases
• Incorporated strategies for tuning the environment and good performance
• Created Permission Lists, Roles, User Profiles and maintained them
• Implemented Quest STAT for Change Management enabling migration of PS Project and File Objects with ability to roll back to the previous archive sets if needed
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases and Replication using Oracle Streams
• Implemented uni-directional table level replication using Oracle Streams
• Design, implement and support Oracle advanced replication and Oracle streams to provide a replicated database environment to support internal GM’s business sites
• Installed and configured Performance Monitor to capture long running SQL’s and Application Performance

Environment: Application - HCM 9.1 Migrations: Quest STAT 5.6.1 Scheduler: ControlM, PeopleSoft Process Scheduler Database: Oracle 11g Operating System: HP UNIX

PeopleSoft Administrator & Oracle DBA

Confidential

Responsibilities:

• Installed and supported many PeopleSoft Applications
• Build servers for PeopleSoft Financials and HCM, Installed Tuxedo and WebLogic on the App/Web servers
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts
• Troubleshoot and resolve database and/or application problems encountered by end users
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Ensuring successful and periodical Backup, Restoration & Tuning of databases
• Used Import, Export, SQL*Loader, and other tools to load and backup data
• Managing Space Management and User management
• Monitoring the Database and Tables growth; increase the table space size in production databases
• Logical Backups using Data pump, Exp/Imp
• Created various PeopleSoft databases running on Oracle
• Implemented scripts in Linux server to schedule backups
• Done many refreshes and restores of databases
• Installed and configured People Books
• Installed and configured UPK
• Configured App/WebServer Load Balancing
• Applied several bundles for HR and Finance Modules
• Applied Tuxedo and WebLogic Patches

Environment: Application - HCM 9.1 AND FSCM 9.1 Scheduler: PeopleSoft Process Scheduler Database: Oracle 11g Operating System: RHEL 5.x Installed and configured Oracle Access Manager Integrated Oracle Access Manager with PeopleSoft

PeopleSoft Upgrade Specialist

Confidential

Responsibilities:

• Pre-Upgrade planning includes environment plan, infrastructure plan and disk space plan
• Performed Application Upgrade from HR 8.4 to HR 9.0
• Performed Tools Upgrade from PT 8.44 to PT 8.49
• Installing Source and Target database
• Installing and configuring Change Assistant template
• Downloading all Upgrade related documents and templates
• Apply all required for Upgrade fixes
• Performing Audit cleanup activities
• Executing initial pass and iterative passes
• Troubleshooting and resolving issues during application data conversion
• Analyze compare reports and assist customer in Keep-Drop decision
• Assisting technical team during retro-fitting
• Assistance during Testing and UAT
• Performed production cutover activities

Environment: Application - HCM 9.0 Database: SQL Server Operating System: Windows 2003

PeopleSoft Administrator

Confidential

Responsibilities:

• Day-to-day activities such as migrations and support to the DEV, TEST and PROD environments and Upgrade of the existing environments to the new version
• Applied Tax Update, Patches and Bundles on an ongoing basis
• Processed migration to testing and production databases quickly and efficiently adhering to change management standard
• Managed PS Security Administration - Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security)
• Exported and imported PeopleSoft Security using Data Mover scripts
• Involved in meetings for the Upgrade project
• Facilitated and participated in the planning, testing, and implementation of new/Upgraded infrastructure
• Created multiple WebLogic WebServer instances for load balancing and fail over
• Creating multiple Application Servers domain for load balancing and Fail over
• Installed PIA to access PeopleSoft Applications
• Created Integration Broker Message nodes for the Source and Target PeopleSoft Applications
• Configured report nodes
• Installed software and configured NT Process Schedulers
• Planned 4 passes for the Upgrade, i.e. First Initial Pass, MTP1, MTP2 and Final MTP
• Successfully performed PeopleTools Upgrade from PeopleTools 8.47 to PeopleTools 8.48
• Successfully performed Application Upgrade from HRMS 8.9MP1 to HRMS 9. 1
• Automated and performed post refresh activities

Environment: Application - Multiple Versions Database: SQL Server, Oracle Operating System: Linux and Windows

PeopleSoft Administrator

Confidential

Responsibilities:

• Day-to-day activities such as migrations and support to the DEV, TEST and PROD environments and Upgrade of the existing environments to the new version
• Applied Tax Update, Patches and Bundles on an ongoing basis
• Processed migration to testing and production databases quickly and efficiently adhering to Change Management standard
• Managed PS Security Administration - Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security)
• Exported and imported PeopleSoft Security using Data Mover Scripts
• Installed PIA to access PeopleSoft Applications
• Created Integration Broker Message nodes for the Source and Target PeopleSoft Applications
• Configured report nodes
• Installed software and configured NT Process Schedulers

Environment: Application HR 8.3 and TOOLS 8.22 Database: Oracle Operating System: Linux and Windows