PROFESSIONAL OVERVIEW

• Around 7.5 years of experience with 1.2 years of onsite experience as a PeopleSoft Administrator / DBA, supporting mainly PeopleSoft environments running on Oracle and MSSQL databases.
• Experience in HCM 8.9, 9.0, 9.1, 9.2 FSCM 8.9, 9.0, 9.1, 9.2 PIH 9.2
• Experience PeopleSoft Tools 8.4, 8.48, 8.49, 8.50, 8.51. 8.52.8.53 and 8.54
• PeopleSoft Upgrade Experience 8.9 to 9.2
• PeopleSoft Implementation - Initial analysis, Strategy Planning , Design, Implementation, Development Support, Migrations, Testing Support, Refresh, Deploy, Post Go Live Support
• PeopleSoft Server Administration - Expertise in installation, configuration, setup and management of the Database, Process Scheduler Server, App Server, Web Server and PeopleSoft Internet Architecture PIA. PUM Product Update Manager, Secure Enterprise Search, Change Assistant, UPK Tool, PTF PeopleSoft Testing Framework,
• SSO and Kerberos AD Authentication setup .
• Oracle and MSSQL databases installation, configuration, performance tuning, troubleshooting, backup and recovery.
• Experience in site to site VPN implementation
• Experience in Office 365 Migration and administration
• Experience in managing and training onsite and offshore teams.
• Database migration MSSQL to oracle
• Possess excellent troubleshooting abilities to maintain corporate PeopleSoft infrastructure systems components Oracle, BEA Weblogic, Tuxedo Servers and Process Scheduler etc.
• Migrating changes from development to test through Production, valuating the required service packs, installing patches, fixes, bundles and applying them to the PeopleSoft system on a timely basis using Change Assistant.
• Verity Search Installation and Search index creation
• SES Secure Enterprise Search Installation and configuration.
• F1 Help Configuration.
• Experience in Installation of 3-tier and 2-tier components of the PeopleSoft.
• Experience in maintaining the databases at high availability and failover point.
• Created multiple Tuxedo and Web Logic PIA Server domains on separate host systems to access one database.
• Worked with PeopleSoft Customer Connection to resolve the PeopleSoft issues.
• Applied Patches/Fixes/Bundles/Tax Updates/Maintenance Pack to DEMO, DEV, TEST, UAT and PROD environments.
• Experience in Citrix Metaframe Server 4.0
• Experience in network administration.
• PeopleSoft Security.
• ISO 27001 Implementation and Internal Auditing Experience.

SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Operating Systems: Windows Server 2008

Role: PeopleSoft Administrator

Responsibilities:

• Install, Configure, manage MSSQL database, Manage MSSQ Database, Data Backup, PeopleSoft Installation, configuration and maintenance, Double click database migration.
• Fully automated PeopleSoft refresh process to single click automation.
• Production and Lab Support.
• Project and third party objects migration.
• Environment patching and maintenance, Maintenance Pack Implementation.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options UPGOPT project, update statistics and freeze PeopleTools.
• Created PeopleSoft Demo and System Databases and Applied related Database patches and application Patches
• Implemented Application Server Load balancing
• Worked in Process Scheduler to run the Process, define the process definitions and schedule the jobs
• Install PeopleSoft Application, tools, web server, app server, PeopleTools etc.
• Refreshing instances
• Shell Scripting Power Shell
• Application and Web server installation and configuration.
• Work with customer connection to resolve the issue.

Confidential

Database: Oracle 11g

Applications: HRMS 9.0, FSCM 9.0, AWS

PeopleTools: 8.51

Role: PeopleSoft Admin/DBA

Responsibilities:

• Analyze the current in-house PeopleSoft server infrastructure.
• Design AWS infrastructure for migrating the in-house PeopleSoft environments.
• Build Amazon Relational Database Service RDS for PeopleSoft.
• Customize the PeopleSoft delivered implementation scripts according to the AWS security policies
• Build the AWS Linux and Windows servers.
• Build security policies and access control on AWS for server external access.
• Implement PeopleSoft environment in the cloud
• Backup the in-house PeopleSoft databases and migrate to AWS file server.
• Clone the current PeopleSoft databases to RDS
• Build PeopleSoft App Server, Process Scheduler Server and Webserver in AWS environment.
• Configure integration broker.
• Build the Database Backup and Server backup policies
• Setup the AWS server monitoring and alert for the Servers and Database.

Confidential

Database: Oracle 11g

Applications: HRMS 8.9, 9.1, 9.2 and PIH 9.2

PeopleTools: 8.49, 8.51, 8.53

Role: Upgrade Specialist

Responsibilities:

• Initial upgrade analysis, Strategy Planning
• Infra-structure Design
• Implementation, Development Support, Migrations, Testing Support, Refresh, Deploy, Post Go Live Support.
• PeopleSoft PUM Product Update Manager implementation and configuration
• PUM Virtual image setup
• Updating PeopleSoft environments with PUM
• Environment planning.
• Move to Production planning for different MTPs
• Change assistant configuration for PUM and upgrade
• Upgrading PeopleSoft Application and Tools using Change Assistant
• Configure PeopleSoft Test Framework
• Configuring PIH PeopleSoft Interaction Hub for multiple environments
• Migrations to TEST, UAT, and Production environments
• Environment refresh, cloning for gold copies.
• Performance tuning for upgrade scripts.
• Upgrade Troubleshooting
• Upgrade Documentation

Confidential

Applications: HRMS 8.9

PeopleTools: 8.49

Role: PeopleSoft Administrator

Responsibilities:

• Production and Lab Support.
• Project and third party objects migration.
• Environment patching and maintenance, Maintenance Pack Implementation.
• Maintenance pack implementation.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options UPGOPT project, update statistics and freeze PeopleTools.
• Created PeopleSoft Demo and System Databases and Applied related Database patches and application Patches
• Setup trace logs at various levels like the Log fence parameter in the appsrv.cfg file, trace logs in Configuration Manager for SQL, PeopleCode, AE, etc and EnableTrace parameter in configuration.Properties file on the Web Server.
• Implemented Application Server Load balancing
• Worked in Process Scheduler to run the Process, define the process definitions and schedule the jobs
• Install PeopleSoft Application, tools, web server, app server, PeopleTools etc.
• Refreshing instances
• Application and Web server installation and configuration.
• Work with customer connection to resolve the issue.

Confidential

Applications: FSCM 9.1

PeopleTools: 8.51

Operating Systems: Windows XP, Vista, Windows 7, 2000, NT Servers, Windows Server, 2003, 2008

Role: PeopleSoft Administrator / DBA

Responsibilities:

• Install and configure Maintenance Pack for FSCM 9.1
• Implementing Maintenance Packs in FSCM 9.1 DEMO, DEV, TEST, UAT and PROD environment
• Taking Database and application Backup
• Understanding the pre-requirements for Maintenance Pack
• Configuring EM Agents, EM Hub
• Installation and configuration of change assistant
• Running DDDAudit , SYSAudit and cleaning the database
• Configuring Update Gateway
• Downloading required bundles from customer connection
• Configuring EM Hub and Environment in change Assistant
• Running the Change Assistant job for implementing the Maintenance Pack
• Performing Post implementation Module Setup
• Fixing the build issues during change assistant job
• Migrating projects from DEV to Test ->UAT -> PROD
• Bouncing the servers and checking the connectivity after implementation
• Running Portal Sysc
• Chartfield Configuration

Confidential

Database: Oracle 10g, MSSQL 2005

Applications: DoubleClick Advertising Manager 6.5. 7.5, Win SCP

Operating Systems: Windows Server 2003, Cent OS 5.6 Linux

Role: Database Migration Specialist/ Double click Upgrade Specialist

Responsibilities:

• Install, Configure, Upgrade and manage Oracle database, Manage MSSQL Database, Data Backup, Data Migration,
• Migrated Double Click database from MSSQL 2005 to Oracle 11g in DEMO, DEV TEST, UAT and PROD
• Evaluated the Hardware Software Requirements for Double Click Add Manager 7.5
• Installation and configuration of Cent OS 5.6
• X-Terminal configuration on Cent OS 5.6
• X-Terminal Client Configuration on Windows
• Installing and configuring oracle 10g database on Cent OS 5.6
• Creating Double Click instance on oracle Database
• Create DoubleClick User and Table space
• SQLDeveloper Configurations to connect Oracle and MSSQL database
• Installing and configuring Oracle and MSSQL Clients in windows machines
• Backup and recovery of MSSQL and Oracle database
• Create repository in SQLDeveloper for capturing MSSQL database
• Create MSSQL capture model in SQLDeveloper
• Create MSSQL converted model in SQLDeveloper
• Filtering the unwanted tables from the model
• Making the data type change mappings
• Generating Download Script for MSSQL and download the MSQL data to local directory for migration
• Setting up Cent OS permissions for migration.
• Migration of MSSQL 2005 database to Oracle 11g database
• Setting up YUM repository

Confidential

Applications: FSCM 8.9, HRMS 8.9, DoubleClick Advertising Manager 6.5. 7.5

PeopleTools: 8.49

Operating Systems: Windows Server 2003

Role: PeopleSoft Administrator

Responsibilities:

• Refresh procedure automation.
• Install, Configure, manage MSSQL database, Manage MSSQ Database, Data Backup, PeopleSoft Installation, configuration and maintenance, Double click database migration.
• Fully automated PeopleSoft refresh process to single click automation.
• Production and Lab Support.
• Project and third party objects migration.
• Environment patching and maintenance, Maintenance Pack Implementation.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options UPGOPT project, update statistics and freeze PeopleTools.
• Created PeopleSoft Demo and System Databases and Applied related Database patches and application Patches
• Implemented Application Server Load balancing
• Worked in Process Scheduler to run the Process, define the process definitions and schedule the jobs
• Install PeopleSoft Application, tools, web server, app server, PeopleTools etc.
• Refreshing instances
• Shell Scripting Power Shell
• Application and Web server installation and configuration.
• Work with customer connection to resolve the issue.