SUMMARY:

• Over 15 years of professional experience as PeopleSoft Application and Database Administrator. Experience supporting PeopleSoft HRMS, ELM, Financials, Campus and CRM applications running on Oracle, DB2 UDB, MS SQL Server databases
• PeopleSoft Server Administration - expertise in installation, configuration, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
• Successfully performed 20 Plus Upgrades PeopleSoft Applications Campus/HCM/HRMS/FIN/CRM/EPM and People Tools
• Experience with - ORACLE, DB2 UDB, MS-SQL Server, databases for over 16 years.
• Performed full life cycle implementations, transition from the legacy system to the PeopleSoft ERP System.
• Hands on Experience in Windows, UNIX -Sun Solaris, Linux, HP, AIX and OS390

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

Senior PeopleSoft/Oracle DBA

Database/PS Application: Oracle12c on Exadata hardware on UNIX(Linux), CAMPUS 9.0, HCM9.2, FIN9.2, Portal 9.1, PeopleTools - 8.52/8.53/8.54 /8.55

• Analysis of existing PeopleSoft Environments (HCM9.1, FSCM9.1, CAMPUS9.0)
• Planned for upgrade for HCM9.2, FSCM9.2 - Hardware and System requirements and load balancing
• Build new release of PeopleSoft, DMO, DEV, TST, UAT, PROD databases for - HCM 9.2, FSCM 9.2 with PeopleTools 8.55.04
• Install and configure Change Assistant, download templates, created Change Assistant job and executed them for HCM9.2 and FSCM 9.2 upgrades
• Planned and executed for Complete upgrade of PeopleSoft HCM 9.2 and FSCM 9.2
• Installed and applied PUM- 01 to PUM18 for HCM9.2 using UPK’s for Native OS and Oracle Virtual VM’s
• Installed and applied PUM01-to PUM19 using UPK’s for Native OS and Oracle Virtual VM’s
• Installed and configured SES - Secure Enterprise Search for HCM 9.2 and FSCM9.2
• Involved in backups and restores of database and took care of post refresh process
• Involved in Project Migrations and data migrations between DEV,TST, UAT and PROD databases
• Executed complete upgrade of HCM 9.2 from HCM9.1 and FSCM 9.2 to FSCM 9.1 with PeopleTools from 8.53.26 to 8.55.06
• Involved in identifying customizations for HCM and FSCM upgrade - Run compare reports, migrations, updating upgrade flags etc. Project backups and imports after the upgrade process to maintain customizations for go live
• Installed Tuxedo and Weblogic middle tiers for PeopleSoft 8.55 release for all the enviornments and installed PIA
• Installed and configured MicroFocus COBOL with ULP for HCM9.2 and FSCM9.2 environments
• Installed Oracle database software and created databases for PeopleSoft HCM and FSCM
• Installed and configured n-Vision, PS-Query, Report Managers, REN Servers
• Completed initial Pass and Move to Production Passes for HCM and FSCM 9.2 upgrades
• Co-ordinate with all team members for issues in upgrade and resolving them.
• Did the smooth data conversion for upgrade for HCM 9.2 and FSCM 9.2
• Successfully went live HCM9.2 and FSCM 9.2 upgrades from HCM9.1 and FSCM 9.1

Confidential, Atlanta, GA

Senior PeopleSoft DBA /Upgrade Specialist

Database/PS Application: Oracle on Linux /DB2 on AIX CAMPUS 9.0, HCM9.2, FIN9.2, Portal 9.1, PeopleTools - 8.52/8.53/8.54

• Install, configure PeopleSoft applications - Confidential with PeopleTools 8.54.04
• Did refresh of PeopleSoft CS- DEV, TST, UAT and CONV
• Involved in Data Conversion for uploading the data for all the PeopleSoft Tables as well as custom tables
• Did Daily Migration of Projects and trouble issues of Migrations
• Installed Oracle 12g/11g on Linux OS for PeopleSoft Applications
• Involved in Planning of infrastructure and sizing for PeopleSoft Applications
• Worked with Oracle ON-Demand infrastructure team for hosting of PeopleSoft CS applications
• Setup PHIRE for Migrations and configure the workflow for Confidential
• Troubleshoot issues with Developers and functional team for the data conversions

Confidential, Atlanta, GA

Senior PeopleSoft DBA /Upgrade Specialist

Database/PS Application: Oracle (Exadata), CAMPUS 9.0, HCM9.2, FIN9.2, Portal 9.1, PeopleTools - 8.52/8.53/8.54

• Install, configure PeopleSoft applications - Confidential 9.0/HRMS9.2/FIN 9.2and CRM9.2
• Install SES (Secure Enterprise Search), OLM (Online Marketing for CRM)
• Did lot of Database refreshes, creating and running the post refresh scripts(MS-SQL Server and Oracle) Involved in NEW PUM (PeopleSoft Upgrade Manager) - setting up the Virtual Machines for PUM, the last updated in PUM9 for HRMS and PUM4 for FIN.
• Troubleshoot the tickets opened by the team and fix them on the daily basis
• Configure Integration Broker between Campus/HR/FIN/CRM nodes.
• Build the databases as needed for Campus/HRMS, FIN and CRM applications
• Involved in Production support for HRMS/Financials and CRM applications
• Involved in POST and PRE refresh of PeopleSoft Databases for CAMPUS/HR/FIN/CRM
• Configure URLS for all other applications to connect and upload files
• Configure Third party URL's to communicate with other Java applications
• Involved in Data Conversions, Troubleshooting of issues, Application Engines Traces, Application Designer traces, People Code traces etc.

Confidential

Senior PeopleSoft DBA

Databases: MS-SQL Server2012/2014, 2008R2

Responsibilities:

• Upgrade People Tools (8.49/8.47 to 8.53/8.54) for FIN/CRM
• Upgrade of People Tools from 8.47 and 8.49 to 8.53and 8.54(New Install for CRM9.2)
• Install and configure Change Assistant Jobs to perform the upgrade
• Apply Patches, Fixes, Maintenance packs and Bundles
• Involved in NEW PUM (PeopleSoft Upgrade Manager) - setting up the Virtual Machines for PUM, the last updated in PUM9 for HRMS and PUM4 for FIN.
• Database Upgrade from MS-SQL Server 2008R2 to 2012 and 2014
• MS-SQL Server Backups and Restores - daily/weekly/Monthly/on-Demand refreshes
• Install and Configure Upgrade Environments for People Tools 8.53 Upgrade
• Install and configure Change Assistant, worked on Initial and MTP passes and Cut-over live activities for HRMS/FIN and CRM applications
• Did lot of Database refreshes, creating and running the post refresh scripts(MS-SQL Server)
• Configure URLS for all other applications to connect and upload files
• Configure Third party URL's to communicate with other Java applications
• Involved in Data Conversions, Troubleshooting of issues, Application Engines Traces, Application Designer traces, People Code traces etc.
• Setup and configure Load Balancing for HCM/FIN and CRM.
• Setup MS-SQL Server jobs for Monitoring and alert procedures for CRM/FIN and HCM
• Create DB Links, Permission/Roles on Applications as well as Database for MS-SQL Server and Oracle
• Involved in Planning, Infrastructure Design and implementation of complete Upgrade of People Tools and Applications

Confidential

PeopleSoft Administrator

Responsibilities:

• Lead a team of 7 consultants for the upgrade project. Involved in Project Planning, Hiring, Infrastructure design and upgrade activities
• Implementation and support of ELM 8.8 - Install, configure and support day to day activities
• Created Demo, Dev, Test, QAA, and Prod with PeopleTools 8.48, HRMS 8.9 database
• Download Template from Customer Connection, Create a Job in Change Assistant
• Run Change Assistant Steps for Tools and Application Upgrade
• Run Compare reports and take over the customization functionality for Upgrade
• Resolve upgrade issues of Business Process and applications and Data conversion issues
• Apply fixes, Updates and Patches for Demo, Dev, Test and Production Application
• Take care of the Migration of data and PeopleSoft objects
• Install Change Assistant and involved in creating copy of Production for Initial Pass and Move to Production
• Involved in complete upgrade (Initial and Move to Production) of the HRMS
• Downloaded the template and required files for HRMS 8.8 Upgrade from PeopleSoft customer connection
• Created Databases DEMO, DEV, TEST, CONFIG and PRODUCTION databases, Appservers, Process scheduler and WebServer instances for ELM 8.8 application
• Installed PeopleSoft applications - People Tools 8.45, Application (HCM 8.8 and Financials 8.8, CRM8.9), Tuxedo 8.1, WebLogic 8.1 and Microfocus COBOL
• Created Application Server Domains and Process Scheduler Domains
• Installed PIA, configured PIA for all the instances and used Web Profile for configuring Webserver settings
• Install and Configure Oracle Client and configure TNS files to get two-tier access to Developers and Users
• Tuning of the Oracle SQL’s and Initialization parameters
• Oracle Space Management, creating table spaces, Indexes, explain plans and worked on tuning of PeopleSoft pages, Interfaces, conversions and transactions
• Involved in the performance of the databases and application by creating multiple domains across the instances
• Worked on PeopleSoft Security for user setup, maintaining roles and permission lists
• Download Updates and Fixes and apply to the environments and maintain the customizations for the PeopleSoft
• Prepared and maintained the documentation on databases and applications. Provide knowledge transfer.
• Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance
• Migration of Internal and External Objects of PeopleSoft (Projects, SQR, NVision, Crystal and Cobol files)

Confidential, Dallas, TX

Sr. PeopleSoft Administrator

Responsibilities:

• Install, Upgrade (Tools and Application) Configure and maintain the PeopleSoft Databases
• Created Databases DEMO, DEV, TEST, CONFIG and PRODUCTION databases on UNIX
• Installed PeopleSoft applications - People Tools 8.45, Application (HRMS 8.8SP1 for Canada and USA), Tuxedo 8.1, WebLogic 8.1 and COBOL
• Migration of Internal and External Objects of PeopleSoft (Projects, SQR, NVision, Crystal and Cobol files)
• Upgrade PeopleSoft - PeopleTools and HRMS for Canadian Payroll, North American Payroll and benefits
• Download Template from Customer Connection, Create a Job in Upgrade Assistant
• Apply fixes, Updates and Patches for Demo, Dev, Test and Production Application
• Install Upgrade Assistant and involved in creating copy of Production for Initial Pass and Move to Production for the Upgrade Process
• Compile COBOL files and migration of SQR, NVision, Crystal files and retain the customization by compare new and old version files
• Involved in complete Upgrade (Initial and Move to Production)for the Payroll, Benefits and HR
• Install People Books for HRMS 8.8SP1 for Canadian and North American Payroll
• Supported for Online Customizations and Interfaces
• Involved in helping to create the New SetID for Canadian Payroll to get 37 ½ hours into the PeopleSoft
• Created Application Server Domains and Process Scheduler Domains
• Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST CONFIG, STG and PROD databases for Canadian Payroll and North American Payroll
• Install and Configure Oracle Client and configure TNSnames.ora Assistant to get two-tier access to Developers and Users
• Involved in setup of VIP and DNS entries for the Canadian Production Databases

Environment: People Tools 8.45.14, HRMS 8.8SP1 and Oracle / HRMS 8.0, PeopleTools 8.19 (Canadian Payroll, Upgrade of North American Payroll, HR and Benefits)

Confidential, Madison, WI

Sr. PeopleSoft Administrator

Responsibilities:

• Creating databases DEMO, DEV, TEST, CONFIG, and PRODUCTION databases on Unix
• Installing PeopleSoft Applications (HCM 8.9 and Financials 8.8), PeopleTools 8.45, Tuxedo 8.1, WebLogic 8.1, and Microfocus COBOL
• Creating Application Server domains and Process Scheduler domains
• Installing PIA, configuring PIA for all the instances of DEMO, DEV, TEST CONFIG, STG, and PROD databases
• Installing and configuring Oracle Client and configure TNS files to get 2-tier access to developers and users
• Managing the performance of the databases and application by creating multiple domains across the instances
• Installing Upgrade Assistant and configure it to run Upgrade Process
• Creating and modifying tables space as and when needed during the Upgrade Process
• Configuring Integration Broker, defining gateway, creating and configuring nodes for HR and Finance
• Migrating of internal and external objects of PeopleSoft including projects, SQR, nVision, Crystal, and COBOL files
• Prepare documentation and provide training.

Confidential, Herndon, VA

PeopleSoft Administrator / Database Administrator

Responsibilities:

• Created databases DEMO, DEV, TEST, CONFIG, and PRODUCTION databases on Unix
• Installed PeopleSoft Applications PeopleTools, CRM Application (8.4 and 8.8) Tuxedo 6.1, and WebLogic 6.1
• Created Application Server domains and Process Scheduler domains
• Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST CONFIG, STG, and PROD databases
• Installed and configured Oracle Client. Configured TNS files to get 2 -tier access to developers and users
• Troubleshot issues of the infrastructure and production support.
• Supported for testing of the databases
• Resolved performance issues and database tuning
• Scripted using Unix Shell, SQL, PL/SQL, tuning of databases both application and SQL tuning
• Created tablespaces, altered tables, and run PeopleSoft generated DDL scripts
• Modified the system from static to dynamic linked application
• Configured WebLogic server for more than 1 Application Server and created multiple domains to get rid of bottlenecks
• Administer the STAT tool and Migrated and maintained the version control of the objects using Quest STAT
• Tuned severs for databases on OS level
• Set up of stand by databases and maintenance for OLTP database systems
• PeopleSoft 8.4/ 8.8 (HRMS, FIN, CRM, Sys Admin), Oracle, Sun Solaris, Unix Shell Script, SQL, PL/SQL, Tuxedo 6.1, WebLogic 6.1, PeopleTools (RMAN, Application Engine, Application Server, Process Scheduler)

Confidential, Delrey Beach, FL

PeopleSoft Admin/ DBA/ Consultant

Responsibilities:

• Worked as a PeopleSoft Admin, Database Administrator, and Consultant for analysis, configuration, implementation, upgrade, performance, and production support of PeopleSoft Applications 8.0/ 8.1 for FDM and HRMS
• Worked on deployment and full lifecycle development of PeopleSoft Application
• Conducted meetings with users, technical/ functional team, and managers for generating specifications to accommodate Client needs and established standards while working in the capacity of a Technical Lead
• Provided a consistent user interface through simple and menu style navigation
• Developed self-service functions and integrated PeopleSoft HRMS and FDM
• Upgraded process of HRMS and FDM modules from 7.5 to 8.0/ 8.1
• Worked on database administration for production, DEV, INT, and staging environments
• Worked on increasing the performance for overall system with database, SQL, application, and server tuning
• Created, altered the tablespaces and maintained the space for large volume of data
• Configured different instances with different application and web servers
• Created database and various DB2 objects
• Monitored and tuned various PeopleSoft processes for Application Engine, SQR reports, and SQL Queries
• Wrote DMS scripts across DMO and SYS databases and wrote customized scripts for customized applications of HRMS and Financial modules
• Worked for Time & Labor module for the regular and non-regular employees
• Developed an SQR to automate the enrollment process of new hires into the STD and Confidential plan depending on the employee eBenefit program, employee type, and job type
• Created several end-user public queres such as union dues for a particular pay period and year to date deductions for the employees, and terminated employee details for a particular location
• Helped the user to run payroll processes, custom processes, and troubleshoot the Payroll error message, if any
• Helped in creating parallel test plans and helped in conducting parallel testing and comparing the results
• Participated in documentation and end user training
• PeopleSoft 7.5/ 8.0/ 8.1 (HRMS, FDM, T&L, eBenefit, PY), DB2, MVS, SQR, BEA Tuxedo, SQL, PeopleTools (Workflow, Process Scheduler, Application Engine)
• Database: DB2 on Mainframe