Summary

• Around 7 years of experience as a PeopleSoft Administrator /DBA, supporting mainly PeopleSoft Financials and HRMS applications 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
• PeopleSoft Upgrade Experience
• 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,
• Oracle and MSSQL databases installation, configuration, performance tuning, troubleshooting, backup and recovery.
• 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.

Technical Skills:

Operating Systems: Windows XP, Vista, Windows 7, 2000, NT Servers, Windows Server 2008, IBM AIX, Cent OS, Red Hat

Database: Oracle8/9/10g, 11g

PeopleSoft Tools 8.4, 8.48, 8.49, 8.50, 8.51: Application Designer, Data Mover, Configuration Manager, Process Monitor, Integration Broker, Process Scheduler, TUXEDO , Application Server, Web Logic, Web Server,PIA, Report Manger, PeopleSoft Security, Change Assistant.

PeopleSoft Application: PeopleSoft Finance/SCM 9.0, 9.1 , PeopleSoft HCM/HRMS HCM 9.0, HRMS 9.1, HRMS 8.3,8.9

Webserver: BEA WebLogic 11g/8.1/6.1

Remote Connectivity Server: Citrix 4.0

Utilities: Remote Desktop, PCAnywhere32 8.0, Terminal Server, Citrix MetaFrame, Putty, Cute FTP, TOAD, Reflection FTP client, VSS.

Professional Experience:

Confidential

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

Environment:

Database: Oracle 11g

Applications: HRMS 8.9, 9.1, 9.2 and PIH 9.2

PeopleTools: 8.49, 8.51, 8.53

Confidential

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

Environment:

Database: MSSQL 2005

Applications: FSCM 9.1

PeopleTools: 8.51

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

Confidential

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 11g 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

Environment:

Database: Oracle 11g, MSSQL 2005

Applications: DoubleClick Advertising Manager 6.5. 7.5, Win SCP

Operating Systems: Windows Server 2003, Cent OS 5.6 Linux

Confidential

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
• 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
• Shell Scripting Power Shell
• Application and Web server installation and configuration.
• Work with customer connection to resolve the issue.

Environment:

Database: MSSQL 2005

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

PeopleTools: 8.49

Operating Systems: Windows Server 2003

Confidential

Role: PeopleSoft Administrator

Responsibilities:

• 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
• 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.

Environment:

Database: Oracle 11g

Confidential

Role: PeopleSoft Administrator / DBA

Responsibilities:

• Install, Configure, Upgrade, Migrations, Tax Updates, Security Administration, DBA, Network Administration, IT management.
• PeopleSoft Admin for HRMS and FSCM.
• Setup PeopleSoft Application Servers and Process Scheduler.
• Extensively involved in administering PS Admin Tool and setting up and correcting the configuration settings of Tuxedo, Process Scheduler, Web Server and Jolt.
• Identified, applied and tested patches/ bundles.
• Attending, analyzing and resolving the day today discrepancies which are routed from end users
• Apply fixes, updates and patches for DEMO, DEV, TEST and PROD application.
• Prepared and maintained the documentation of all the installation and configurations of databases and applications
• Creating User accounts, Roles and permission lists.
• Infrastructure design and maintaining the environments of PeopleSoft for DEMO, DEV, TEST, and Production Databases.
• Created Application Server Domains and Process Scheduler Domains.
• Created Application Server Domains and Process Scheduler Domains.
• Install and configure PIA.
• Install and Configure Oracle Client and configure TNS files to get two-tier access to Developers and Users.
• Installed People Books for HCM, FSCM and configured the Web Server to access People Books.
• Configured Application Server, Web Server Batch Process Scheduler Server.
• Configured Windows development clients to connect 2-tier or 3-tier to the database for development and administration purposes.
• Installed BEA Tuxedo AppServer, WebLogic WebServer with database Oracle and created PeopleSoft DEMO and System Databases and Applied related Database patches and application Patches.
• Extensively used PSADMIN utility to Administer, Create Delete Application Server and Process Scheduler Server.
• Checked and cleared the application server cache on a regular basis as a maintenance process.
• Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing.
• Configured PSMAIL utility to send mails from PeopleSoft.
• Installed Crystal Report 7, tested SQR and nVision Reports for developers and Scheduled jobs on with process scheduler.
• Installed and configured citrix server 4.0 for external access of PeopleSoft server.
• Published applications on citrix and given access to user according to the user level.
• Setup conference manager on citrix for onsite communication and training.
• Installed QTP 9.2/10.0 for testing purpose.
• Installed and updated Windows server 2000/2003/2008, XP, Vista RTMs,x86,x64 , Windows 7, Redhat Linux, Black Track, Ubundu, Knopics, IBM AIX.
• Managed office computer networks, computer hardware maintenance and mail Server maintenance.
• Solved daily network connectivity issues in office.
• Installed Microsoft network connectivity software such as IT Connection Manager, E-Trust, Forefront, Smart card access tools and Product Studio.
• Involved and managed the office activities such as employee Access cards, email id creation, System setup for new employees , Office network setup in multiple locations, Interaction with vendors ,setup VoIP phone connections.

Environment:

Database: Oracle 10g

Applications: HRMS 8.9/9.0/9.1, FSCM 9.0, 9.1

People Tools: 8.48/8.49/8.50/8.51

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