Nagarajan Venkatesan email: accgkp@r.postjobfree.com

Mobile: 847-***-****

SUMMARY:

• 10 years of experience in PeopleSoft Administration/DBA/Upgrades skill set. Involved in performing

PeopleSoft Upgrades across HRMS/Campus Solution/Financials, PeopleSoft installations, application of

patches/bundles/tax upgrades, configuration of application servers, process schedulers and web servers,

Maintenance Support, database creation, database backups, disaster recovery, application tuning,

monitoring servers, security setup and capacity planning activities across the servers.

• He has played the role of a PeopleSoft Administrator/PeopleSoft DBA/ Upgrade Specialist/Performance

Architect across projects.

• Demonstrated abilities in a HRMS support project, the scope of which includes application of

Multilingual Maintenance Packs; received the ORACLE Customer Services ‘Pacesetter Award Q3 FY08’ for

this project.

• He has experience working in the following countries – US, India, Australia, Singapore and Malaysia.

PREVIOUS EMPLOYERS:

Oracle Corporation, Infosys and Hexaware Technologies.

TECHNICAL SKILLS:

Tools PeopleSoft Change Assistant, PeopleSoft Upgrade Assistant,

Integration Broker, Weblogic, Tuxedo, PeopleSoft Update Manager

(PUM)

PeopleTools Versions People Tools 7.63, 8.42, 8.46, 8.47, 8.48, 8.49, 8.50, 8.51, 8.52, 8.53

PeopleSoft Applications PeopleSoft HRMS 8.0, 8.3, 8.8, 8.9, 9.0, 9.1, PeopleSoft Financials 8.0,

8.4, 8.8, 8.9, 9.0, 9.1, 9.2, PeopleSoft Campus Solutions 7.6, 8.0,

8.8SP1, 8.9MP1, 9.0 and EPM 9.0

Operating Systems Windows (95, 98, 2000, 2003, 2008, 2008 R2, XP, NT, 7), Oracle Linux

5, RedHat 5.4, HP Unix 11i V3 (Itanium), HP Unix 11i V3 (PA_RISC),

Solaris

Databases and Other Tools Oracle 9i. 10g, 11g, MS SQL Server 2005/2008, DB2, Data Mover,

Oracle Export/Import utility, SQR, Crystal Reports, PS/Query, COBOL

PROFESSIONAL EXPERIENCE:

Quintiles, Raleigh-Durham, NC July2013-Till date

Description: PeopleSoft Financials Upgrade from application v9.0 to v9.2 & PeopleTools 8.53

Role: PeopleSoft Administrator/Upgrade Specialist

Environment: OS – Oracle Linux 5 and MS Windows 2008 64-bit.

Responsibilities:

• Install PeopleSoft 9.2 Financials application on PeopleTools 8.53

• Setup Change Assistant on PeopleTools 8.53 for performing the Upgrade

• Perform end to end PeopleTools/Application Upgrade from application v9.0 to v9.2 & PeopleTools 8.49 to 8.53

• Apply the patches from PS Financials 92 Image 02, Image 03 and Image 04 using PUM.

• Setup the 3 tier architecture for Financials 9.2 and performance tuning of application on v9.2

• Provide support for PeopleSoft Financials 9.0/9.2 and project migrations across instances

• Install and Setup PeopleSoft Portal 9.1 Version 2

Career Education Corporation, Schaumburg, IL Feb2013-April2013

Description: PeopleSoft PeopleTools upgrade/Post-Production support of HRMS 9.0 and Financials 9.1 systems

Role: PeopleSoft Administrator/Upgrade Specialist

Environment: OS – MS Windows 2008 64-bit for Database Server, Web Server, Application Server and Batch Server.

F5 Load Balancer used. Database – MS SQL Server 2008 R2 64-bit

Responsibilities:

• Perform a Dry-Run upgrade pass and Go-Live of PeopleTools upgrade from V8.49 to 8.52 on PeopleSoft HRCS 9.0

• Perform a Dry-Run upgrade pass and Go-Live of PeopleTools upgrade from V8.50 to 8.52 on PeopleSoft Financials 9.1

• Fix any post-upgrade issues

• Setup the 3 tier architecture for both PeopleSoft HR and Financials systems

• Provide support for PeopleSoft HR and Financials systems

City of Minneapolis, MN Jan2013- Jan 2013

Description: PeopleSoft architecture review and consulting for database platform migration

Role: PeopleSoft Technical Architect

Environment: OS – MS Windows 2003 for Database Server, Web Server, Application/Batch Server & Windows NT for

PeopleSoft Batch Server. F5 Load Balancer used. Database – Oracle 10g

Responsibilities:

• PeopleSoft Consulting - HRMS 8.9MP1/Financials 9.0/EPM 9.0/ELM 9.0 on People Tools 8.49 & Oracle10g database

• Review the architecture and server parameters across all the 4 PeopleSoft systems

• Look at a feasibility of database platform migration - h/w & s/w compatibility

• Put forth an approach to migrate the database platform from Oracle 10g to MS SQL Server 2008

• Identify the impact of the database platform migration

• Estimate the effort required for migration

• Suggest tuning parameters across the PeopleSoft servers

• Provide options and the recommendation for going ahead with database platform migration along with upgrade

recommendation

ITE, Singapore Oct 2012-Nov2012

Description: PeopleSoft Performance Testing and Tuning of Servers by performing a load test for 1000 and 1500

concurrent users

Role: PeopleSoft Performance Architect

Environment: PeopleTools – 8.49,OS – Sun Solaris 5.10 for Database Server, Web Server, Application/Batch Server &

Windows NT for PeopleSoft Batch Server. F5 Load Balancer used. Database – Oracle 11g 64-bit

Responsibilities:

• PeopleSoft Performance Tuning - HRCS 9.0/ PeopleTools 8.49 on Oracle 11g

• Review of the Production Architecture

• Read/Analyze the PeopleSoft Application Server/Web Server and Batch Server configurations

• Perform a load test for 1000 and 1500 concurrent users

• Tune the PeopleSoft Servers and F5 Load Balancer as per the results during the load run

• Re-test the application performance after tuning the servers

• Review the tuned parameters with client and document the same along with the final report

VIACOM, New York Jun2012-July2012

Description: PeopleSoft Application Upgrade from HRMS 8.9 MP1 to HRMS 9.1, PeopleTools Upgrade from

v8.50 to v8.52.06 and Oracle database version from Oracle 10g to Oracle 11g. Also MP6 was applied on HRMS

9.1

Role: PeopleSoft Administrator/Upgrade Specialist

Environment: PeopleTools – 8.50 & 8.52.06, OS – RedHat Linux 5.4 for Database Server, Web Server,

Application/Batch Server & Windows NT for PeopleSoft Batch Server. Database – Oracle 10g 64-bit/Oracle 11g 64-bit

Responsibilities:

• Setting up Change Assistant/ PSEM Framework

• Performed the UAT pass in the Upgrade.

• Performed the application upgrade from HRMS 8.9MP1 to HRMS 9.1 Feature Pack 2

• Performed the tools upgrade from 8.50 to 8.52.06

• Applied HRMS 9.1 MP6 (Delta) after the application upgrade.

• Documentation was prepared as per the requirements from the client.

• Post-Production support on HRMS 9.1

Canara Bank, Bangalore Mar2012-Apr2012

Description: DR implementation was for Canara Bank and the DR system was designed to act as a backup system for

the Production on PeopleSoft HRMS 9.0.

Role: Disaster Recovery Consultant

Environment: PeopleTools - 8.49, OS – HP Unix 11i V3 (Itanium) for Database Server & PeopleSoft Web Server,

HP Unix 11i V3 (PA_RISC) for PeopleSoft Application/Batch Server & Windows NT for PeopleSoft Batch Server.

Database – Oracle 10g 64bit RAC

Responsibilities:

• PeopleSoft HRMS 9.0 Disaster Recovery Implementation

• Planned the DR activities to be carried over from the PeopleSoft perspective.

• Install Tuxedo 9.1 RP 95 across all App Server HP PA-RISC boxes.

• Install Welogic 9.2 across all Web Server HP Itanium boxes.

• Install Tuxedo 9.1 RP 95 on Windows box

• Install PeopleTools 8.49.33/ HRMS 9.0 across all App Server HP PA-RISC boxes.

• Install PeopleTools 8.49.33/ HRMS 9.0 across all Web Server HP Itanium boxes.

• Install PeopeTools 8.49.33/ HRMS 9.0 on the Windows Process Scheduler box.

• Create App Server Domains across all App Server HP PA-RISC boxes.

• Create Web Server Domains across all Web Server HP Itanium boxes.

• Create Process Scheduler domains on all the App Server Unix boxes and as well as Windows box.

• Install COBOL compiler on all the App Server boxes

• Implement RPS on web server

• Setup Report Repositories across Web Server boxes

• Tune the App Server/ Web Server/ Process Scheduler Server domain settings.

• Push the custom SQR/COBOL files from Production App server boxes to DR App Server boxes.

• Push the custom Crystal Report objects from Production Windows boxes to DR Windows box.

• Push the Report Repository files from the Production Web Sever box to DR Web server box.

• Test the PeopleSoft DR site.

University of New South Wales, Sydney, Australia Oct2011-Mar2012

Description: The upgrade was for a University based out of Australia and they are currently using SA 7.6 for

maintaining the student’s database across various modules

Role: PeopleSoft Upgrade Specialist/PeopleSoft Administrator

Environment: PeopleTools - 7.64, 8.49, 8.51, 8.52, PeopleSoft Upgrade Assistant and PeopleSoft Change

Assistant

OS – Oracle Linux 5 for Database Server, PeopleSoft Web Server/Application Server/Batch Server & Windows

Server 2008 R2 (64-bit) for PeopleSoft File server/Upgrade workstation. Database – Oracle 11g 64bit

Responsibilities:

• Actively involved in Capacity Planning across the Linux/Windows servers used for the Initial Pass upgrade.

• Installation of PeopleSoft Demo databases – SA 7.6, HRMS8.8SP1, HRMS91MP1 and HRCS90 FP March 2011

during the Initial Pass of the upgrade.

• Creation of COP database from the client’s export dump during the Initial Pass of the upgrade.

• Setting up Upgrade Assistant and Change Assistant.

• Performed all the upgrade passes in the Upgrade.

• It is a double step upgrade – SA 7.6 to HRMS 8.9MP1 and HRMS 8.9MP1 to HRCS 9.0 Feature Pack March 2011

• Performed the tools upgrade from 7.63 to 8.49 (on the HRMS 8.9MP1 path) and finally to 8.52 (on the HRCS 90 upgrade

path) and the Application upgrade(s).

• Applied MP11, MP12, MP13 and the latest bundles after the application upgrade.

• Optimized the upgrade with every test move passes.

• Performed all database backup activities during the Initial Pass of the upgrade.

• Resolved the security issues during the upgrade and as well post-upgrade.

• Resolved the upgrade issues that were reported during the testing phase.

• Documentation was prepared as per the requirements from the client.

• Provide Production Support

PeopleSoft set up lab, Bangalore Campus, Bangalore Dec2010-July2011

Description: It was an internal assignment to setup the PeopleSoft Upgrade Labs based out of Bangalore.

Role: Technical Architect/PeopleSoft DBA

Environment: PeopleTools 8.49 and 8.51, PeopleSoft Upgrade Assistant and PeopleSoft Change Assistant, OS -

Linux 5 for Database Server & Windows Server 2008 R2 (64-bit) for PeopleSoft Web Server/Application Server/Batch

Server and File server Database – Oracle 11g 64bit

Responsibilities:

• Decided on the server/hardware requirements for setting up the Upgrade Labs to be based out of Bangalore at

Infosys.

• Decided on the Application and Tools version for setting up the initial Demo databases in the Lab.

• Created the Oracle databases HRMS89 and HRMS91 on Oracle 11g

• Installation of PeopleSoft Demo databases – HRMS89 & HRMS91 on Tools 8.49 and 8.51 respectively.

• Setting up Change Assistant on Tools 8.51

• Updating HRMS91 database with Maintenance Pack#2 (Cumulative).

• Updating HRMS89 database with Maintenance Pack#1

• Applying the required Tools patches – 8.49.27 & 8.51.04

• Setting up Web Server, Application Server & Process Scheduler/Report node for HRMS89 & HRMS91.

Lowes, USA May 2010- Dec2010

Description: The customer is a one of the top 5 Retailer based out of US and has many retail outlets spread across the

globe. They were using PeopleSoft Financials 8.4 and 8.9 applications.

Role: Technical Architect

Environment: PeopleTools 8.47 and 8.51, OS – IBM z/OS, UNIX (AIX) and Windows Database – DB2

Responsibilities:

• PeopleSoft Financials Upgrade - Financials 8.4 to 9.1, Financials 8.9 to 9.1 and Tools Release 8.47 to 8.51

• Installation of Tools 8.51 and Tools 8.47

• Production support for various PeopleSoft instances

• Performing project migrations

• Troubleshoot the issues in the instances

• Fetching the App Server/ Process Scheduler server trace files

• Running Project Compares and analyzing the compare reports

• Analyzing the impact of the customizations on the upgrade

HUDSON, Australia Sept2009-April2010

Description: The customer is a permanent recruitment, talent management and related staffing services and solutions

provider based out of Australia.

Role: Configuration Controller

Environment: OS – Windows. Database – Oracle 11g

Responsibilities:

• PeopleSoft Implementation - HRMS, Global Payroll and Absence Management (AUS and NZ) 9.0

• Involved in the migration of Rule and Non-Rule Packages for GP and Absence Management across various

instances.

• The Package migration includes Creating, Exporting, Importing, Comparing and Upgrading the package

and also fixing the errors that show up in the package elements compares.

• Reviewed/modified the test plans for Absence Management in the SIT phase.

• Involved in executing the test cases in the SIT phase.

University of Auckland, Auckland, New Zealand Feb2009- Aug 2009

Description: The upgrade was for a University based out of New Zealand and they are currently using SA 7.6 for

maintaining the student’s database across various modules

Role: PeopleSoft Administrator/Upgrade Specialist

Environment: PeopleTools 7.63, 8.48 and 8.49, PeopleSoft Upgrade Assistant and PeopleSoft Change Assistant, OS –

Windows. Database – Oracle 10g

Responsibilities:

• PeopleSoft HR Campus Solutions Upgrade - Student Admin 7.6 to HRCS 9.0 & Tools Release 7.63 to 8.49

• It was a double step upgrade – SA 7.6 to CS 8SP1 and CS 8SP1 to CS 9.0

• Performed the tools upgrade from 7.63 to 8.48 and finally to 8.49

• Analyzed the vanilla compare reports to get the impact of customizations during the upgrade.

• Applied MP5 and the bundles after the application upgrade.

• Resolved the issues during testing

University of Southern Queensland, Queensland, Australia Jun2008-Jan2009

Description: The upgrade was for a University based out of Australia and they are currently using SA 7.6 for

maintaining the student’s database across various modules

Role: PeopleSoft Administrator/Upgrade Specialist

Environment: PeopleTools 7.63 and 8.48, PeopleSoft Upgrade Assistant and PeopleSoft Change Assistant, OS –

Windows. Database – Oracle 10g

Responsibilities:

• PeopleSoft HR Campus Solutions Upgrade - Student Admin 7.6 to HRCS 9.0 & Tools Release 7.63 to 8.48

• Performed the Technical Upgrade

• It was a double step upgrade which in-turn has 3 segments – SA 7.6 to CS 8.8, CS 8.8 to CS 8.9 and finally CS 8.9 to 9.0

• Performed the tools upgrade from 7.63 to 8.48

• Analyzed the vanilla compare reports to get the impact of customizations during the upgrade.

• Applied MP5 and the bundles after the application upgrade.

• Resolved the issues during testing.

• Provide Post Production support

Hygiene Solutions Firm Feb 2008- May 2008

Description: The customer is a US based hygiene solutions firm and they were using HRMS 8.9MP1

Role: Upgrade Consultant

Environment: OS – Windows. Database – Oracle 10g, Change Assistant

Responsibilities:

• PeopleSoft HRMS 8.9 Support – application of MPs

• Applied the Maintenance Packs (Multilingual) 6, 7, 8, 9 and Bundle 13 through Change Assistant.

• Ran the Compares to identify the customizations.

• Applied the MPs on Demo environment.

• Ran the compares and identified the customizations affected by the MPs.

• Analyzed the objects affected and completed the estimate required to carry forward the MP objects to Production and other

environments.

• Applied MPs on Training, Test and Production environments.

• Re-applied the customizations on the above mentioned environments.

• Completed Unit testing and discovered the enhancements required.

DiGi Telecommunications Oct 2007-Jan 2008

Description: The upgrade was for a Telecom provider based out of Malaysia and they were using HRMS 8.8 for

maintaining the employee’s data across various modules

Role: Upgrade Specialist

Environment: Upgrade Assistant, OS – Windows. Database – Oracle 9i

Responsibilities:

• PeopleSoft HRMS Upgrade - HRMS 8.8 to 8.8SP1 (Core HR and Global Payroll Malaysia)

• Installation of Oracle database on 9i

• Installation of PeopleSoft 8.8SP1

• Ran the Compares to identify the level of customizations.

• Worked on the CEMLIs and the estimate required for the upgrade project.

• Analyzed the patches and the Maintenance Packs to be applied during the upgrade.

• Discovered the inconsistencies (with Patches) in the customer’s existing PeopleSoft application.

• Planned the workaround to fix the inconsistencies.

• Performed the upgrade using Upgrade Assistant.

• Prepared the Technical Design document for the required Customizations and reapplied them

PeopleSoft Upgrades at PeopleSoft Upgrades Lab Aug 2004- Sept2007

Description: The PeopleSoft Upgrade Labs had its own servers to perform the Upgrade activities for client based out of

US and APAC.

Role: Upgrade Lead -Specialist/PeopleSoft Administrator

Environment: PeopleTools 8.42, 8.43, 8.45, 8.47, 8.48, 8.49 and Upgrade Assistant, Change Assistant, OS – various

versions of Windows. Database – Oracle 9i,10g

Responsibilities:

• Performed a PeopleSoft Enterprise Upgrade from FSCM 8.0 SP3 to FSCM 8.8 SP1 for the upgrade service offered by North

America Upgrade labs for one of the largest affiliation of health-care Plans in the US - REGENCE.

• Performed a PeopleSoft Enterprise Upgrade from HRMS Release 8.8 SP1 to 8.9 for the upgrade service offered by North

America Upgrade labs for one of the largest US based Cable Provider – COX CABLE.

• Performed a PeopleSoft Enterprise Upgrade from FSCM 8.0 SP2 to FSCM 8.8 SP1 for the upgrade service offered by North

America Upgrade labs for an electrical company in Alaska – FAIRCHILD SEMICONDUCTOR.

• Performed a PeopleSoft Enterprise Upgrade from FSCM 8.4 SP2 to FSCM 8.9 for the upgrade service offered by North

America Upgrade labs for a US based University – University of Rhode Island.

• Performed a PeopleSoft Enterprise Upgrade from HRMS Release 8.01 to 8.8 SP1 for the upgrade service offered by North

America Upgrade labs for one of the largest US based Postal Service – US Postal Service.

• Performed a PeopleSoft Enterprise Upgrade from FSCM 8.4 SP1 to FSCM 8.9 for the upgrade service offered by North

America Upgrade labs for a US based Automobile Association – American Automobile Association .

PeopleSoft Upgrades Lab Jun 2004-Aug2007

Description: The PeopleSoft Upgrade Labs had its own servers to perform the Upgrade activities for client based out of

US and APAC.

Role: Upgrade Lead/Specialist

Environment: PeopleTools 8.42, 8.43, 8.45, 8.47, 8.48, 8.49 and SQR/PS Query, OS – various versions of Windows.

Database – Oracle 9i,10g

Responsibilities:

• Performed over 14 SQR/Query Upgrade projects for various clients across the HRMS and Financials Domains

over a period of 3 years.

EDUCATION:

• Bachelor of Engineering in Computer Science - Vellore Institute of Technology, University of

Madras

CERTIFICATIONS:

• PeopleTools 8.42 from Oracle Corporation in the year 2004

• PeopleTools 8.48 from Oracle Corporation in the year 2008

Contact this candidate