OBJECTIVE:

Highly experienced, hardworking and dependable PeopleSoft Administrator / DBA looking for an exciting contract opportunity.

SUMMARY:

PeopleSoft Administrator / DBA with around 14+ years of experience working in US on various HCM and FSCM implementation and upgrade projects. Have worked with a wide variety of industries and highly proficient in leading technical teams, effort estimation and work allocation, PeopleSoft upgrades and implementations, server administration, database administration, change implementation, capacity planning, performance analysis and performance tuning. Have excellent communication skills, am self - motivated and a good team player.

• Remarkable experience with upgrading to People Tools 8.55.16, HCM 9.2 PUM Image 22
• Excellent Troubleshooting and Debugging Skills
• Strong knowledge of and adherence to PeopleSoft infrastructure best practices
• Expert in Installation, configuration, and support of PeopleSoft web, application, batch, and file servers.
• Experience applying PeopleSoft PUM Images, RFUs, patches etc.
• Expertise in using the following Tools & Technologies: PeopleSoft Update Manager (PUM), Change Assistant, Application Messaging, Integration Broker, SSL Certificates, WebLogic Server, Tuxedo, Application Designer, Data Mover, Micro Focus License Manager, PeopleSoft Security, Oracle Database, Microsoft SQL Server, Windows Servers, etc.
• Ability to create and maintain excellent working relationships with other IT professionals on the PeopleSoft team as well as database administrators

PeopleSoft Administrator / Technical Analyst: Key player of PS Technologies team (10 onshore and 14 offshore). 15K+ facilities, 800+ Admin Users, 15 Sun Servers, 60+ database instances and 1 Million + employees.

Tools Upgrades: Upgraded HRMS 8.8 to 8.8SP1 Tools 8.42.09 to 8.43.17 & CRM Tools 8.16.02 to 8.22.14

Tax Updates: Applied all tax updates for the years 04, 05, 06 and also 07A

PeopleSoft Patches: Applied PeopleSoft patches including the latest DST patch across all instances

Instance Builds: Refreshes/Restores (Friendly/Hostile from Hot/Cold backups) and IVTs

Server Configuration: App server and Process Scheduler server configurations, maintenance and issue triage

Source Control: Code Syncs, Migrations, Migration Audits and Strategy, Change Control

Security: UNIX Level (users/groups/permissions), Oracle (roles/privileges), PeopleSoft (BK ups, Role Maintenance & Design, Audits, Strategy - Advise Functional Users)

UNIX File/Dir permissions - clean up and roll out, end user support (COBOL compiles, file ftp, triage etc):

Autosys: Server Configuration & Setup, Job/JIL Analysis & Design, Creation, Execution of job streams in production and non-production environments.

Application Messaging: Involved in Configuring, Analysis, Triage of Gateways/Channels/Nodes/Messages

Utilities: Developed/modified SQR, App Engine, Component Interfaces, Excel Macro utilities to help technical/functional teams

Volume/Stress Testing Batch & Online: Lead the effort to plan, configure, co-ordinate, develop processes and overall execution

HRMS and CRM Database Reductions: Development, Execution, Maintenance and Ownership

Base Table Support: modify and maintain PL/SQL procedure, generate table compare reports across databases, data export/import, SQL and DMS Updates/Deletes/Inserts

Data Conversion: Helped in converted data from legacy using SQL Loader / SQR and App Engine

Production Support: Job scheduling & execution, Issue Triage, Co-ordination with Functional Team etc

FTP Processing: Design, Development, Configuration, Application Support

Performance Tuning: Helped developers in debugging and SQL tuning for many processes using hints, indexes and scalar queries to greatly improve process run times over a long period of time. Also performed peer reviews and code audits to improve and maintain quality of code based on the development standards.

Mentoring Offshore/Onshore teams: Scheduling, Resourcing and Skill Set Development

Environment: PeopleSoft HRMS 8.9/Tools 8.46, CRM 8.0 Tools 8.22.14, BEA Web Logic 5.1 and 8.1, IPlanet 6, Windows 2000/NT Terminal Servers, UNIX SunOS 5.8 & Oracle 9i Release 9.2.0.8, Kintana (Mercury IT Governance Center 5.5), PVCS Version Management Server 6.7.11

Modules Used: HR, Payroll, Benefits, Ben Admin, Pension, Time & Labor, Portal, CRM.

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

PeopleSoft DBA / Upgrade Specialist

Responsibilities:

• PeopleSoft HCM 9.2 PUM Image 22 and People Tools 8.55.16 upgrade on SQL Server 2016.
• Performed Initial Pass and 4 other Move To Production (MTP) passes for their Copy Of Production using the certified upgrade path: People Tools 8.51 to 8.53 using delivered upgrade template on SQL Server 2008, People Tools 8.53 to 8.55.14 using delivered upgrade template on SQL Server 2014, HCM 9.2 Image 16 upgrade on SQL Server 2016, HCM Image 16 to PUM Image 22 and finally the People Tools Patch 8.55.16
• Migrated projects post upgrade for Bolt On and retrofitted customizations from Development to SIT test environment.
• Troubleshoot various upgrade specific issues and suggest different options to resolve those issues and their potential impact.
• Installed Micro Focus on a windows server and compiled all the COBOLs. Copied the compiled CBLBINA folder (GNT, EXE and other files) to the corresponding Development and Test environments.
• Developed Project Plan / Strategy for all the upgrade passes and also for Cutover.
• Planned the Storage allocation and Memory requirements to host the Upgrade, Development and Test servers (Microsoft Windows 2012 R2 servers).
• Took various database backups and restored / configured the various environments.
• Worked with the DBA, Networking, Technical and Functional teams to manage various activities during the upgrade.

Environment: PeopleSoft HCM 9.2 PUM Image 22 / Tools 8.55.16, SQL Server 2016, Windows 2008 R2 and 2012 R2 servers.

Confidential

PeopleSoft DBA

• Worked with Oriental Bank of Commerce as a PeopleSoft Administrator / Upgrade Specialist. Involved in working with the management on the upgrade strategies, infrastructure planning, H/W procurement, work allocation to various teams and defining milestones and timelines. Installed and configured PeopleSoft and Oracle DB client on all the Solaris and Windows servers and setting up server specific user profiles.
• Worked with the network team to get specific server ports opened on the Database, Application and Web servers for all environments.
• Applied PeopleTools patch 8.55.12 to all the environments and performed sanity testing to ensure the issues for which the patch was required were all resolved.
• Performed a Tools Only upgrade on a Copy of Production from 8.49 to 8.55 but still on HCM 9.0 just so the developer can run compares against a fully upgraded PT 8.55 and HCM 9.2 database to identify changes made to Production for retrofitting customizations.
• Migrated projects from Development to SIT test environment as and when required for all SIT fixes and UNIT testing changes.
• Installed Micro Focus on a windows server and configured Process Schedulers to run COBOL processes for Dev and Test environments.
• Developed Layout strategy with timelines, SAN storage allocation / Mount point requirements for ASM and non-ASM based DB installs / UNIX operator ids and Database RAID allocation setup for the network/DBA teams to configure the new SOLARIS 11.3 on SPARC T7 and T5 servers for Production / DR.
• Worked over a weekend in shutting down all PS applications, restarting them and doing sanity testing with the network and Oracle DBA teams for Data Center movement activity where all non-prod servers were moved from one data center in Delhi to another in Mumbai.
• Created a Training environment database using RMAN for end users using an older MTP backup and configured app/web/prcs servers.
• Worked with the technical team lead in identifying Delta changes for retrofitting customizations by running appropriate compares.
• Assisted the Functional / Technical teams in identifying and resolving issues and communicating the root cause analysis to the management / team leads.
• Defined and communicated the soft freeze and hard freeze timelines for code changes to current production
• Worked at DBS Bank in Singapore to help in their final mock run and cutover activities. Helped in performing their GO-LIVE cutover upgrade and post go-live support.

Environment: PeopleSoft FSCM 9.2 / Tools 8.54 and PT 8.55, Oracle 12g, Windows 2008 and 2012 servers, Solaris and AIX UNIX.

Confidential, Albany, NY

PeopleSoft DBA

• Implemented PeopleSoft HCM, CRM, FSCM and Portal technologies with the Confidential Retirement System.
• Involved in working with the management on the cutover strategies and work allocation to various teams and defining milestones and timelines.
• Responsibilities also included to build various instances meant for testing, training and production environments.
• Worked on production and non production migrations.
• Researched, analyzed and applied various security patches. Involved in troubleshooting specific server or data issues and also mentor the junior admins on best practice procedures to be implemented and define the road-plan for the implementation.
• Took part in production cutover tasks and was part of making certain important decisions during the cutover to accelerate the cutover timelines.

Environment: PeopleSoft FSCM 9.2 / Tools 8.54, Oracle 11g, SQL Server 2008, Windows 2008 server and Confidential AWS.

Confidential, TX

PeopleSoft DBA

• Worked on 3 different Tools and Application upgrade projects for multiple clients: FSCM 8.9 Tools 8.49 to FSCM 9.2 Tools 8.53, FSCM 9.2 Tools 8.53 to FSCM 9.2 Tools 8.54.
• Worked single handedly from installing the software, building the demo and copy of production databases, configuring the app/prcs/web servers to performing the upgrades using Upgrade Assistant and Oracle Virtual Images and applied the 1099 and other required patches/bundles.
• Also worked with Confidential AWS console to configure, take backups and restore databases for Test and Production environments.

Environment: PeopleSoft FSCM 9.2 / Tools 8.54, Oracle 11g, SQL Server 2008, Windows 2008 server and Confidential AWS.

Confidential

Competency Lead Upgrade Services

• Primary responsibility is to see that the deliverables for different clients are delivered on time and proper communication is established. Recruiting the team members, managing the resources, estimating the work on hand and allocating them appropriate work, helping and mentoring them on various aspects of PeopleSoft Development, Testing, Administration, Script Automation, managing Maintenance Schedules and Production Support are the main job responsibilities.

Environment: PeopleSoft HRMS & Financials 9.1/ Tools 8.52.09, Oracle 11g, OEL 6, Windows 2008 server

Confidential, Seattle, WA

PeopleSoft DBA

• Supporting the existing PeopleSoft production environment, setting up new servers, troubleshooting day to day issues, developing strategies to stabilize the system and improve security and performance are the main job responsibilities on this assignment.
• Worked hand in hand with the development and DBA teams and also assisted the new resources in understanding of the system over a period of time.

Environment: PeopleSoft HRMS 8.9/ Tools 8.49.27, Oracle 11g, RHEL 5.3, Windows 2008 server

Confidential, LA

PeopleSoft DBA

• Performed Database Refreshes for the DR environment. Worked on pre and post refresh activities before deploying the database to the users.
• Worked on Oracle database security.
• Troubleshoot issues pertaining to data, tablespaces, etc whenever any jobs fail and resolve them.
• Installed and Configured People Tools Change Assistant on Windows Server 2008.
• Applied Tax Updates 11D, 11E and 11F to all environments and resolved any issues that cropped up.
• Applied HR Bundles 15, 16, 17 and 18 with their pre-requisite and post-requisite updates to all environments.
• Performed ad-hoc emergency migrations to Production.
• Troubleshoot issues of Process Scheduler, Application Server and Web Logic Server.
• Resolve Oracle database and PeopleSoft application issues in non-prod regions after weekly system checks.

Environment: PeopleSoft HRMS & Financials 9/ Tools 8.49.27, Oracle 11g, AIX 6, Windows 2008 server

Confidential, Columbus, OH

PeopleSoft Administrator

• Installed and Configured People Tools 8.50 on 8 application servers and 18 Web Logic servers for production.
• Used Change Assistant to upgrade People Tools from 8.49 to 8.50.08 on development, training, testing and production databases.
• Raised service tickets for the hardware team to clone and build production application and Web Servers.
• Modified signin.html on all non-prod PIA sites to force uppercase user IDs to be entered on login page and also to include OSU specific headers.
• Configured the application, web and process scheduler servers for all environments on LINUX and NT servers.
• Applied patches using Change Assistant
• Researched WLST monitoring of Web Logic servers for real time server heap size usage and garbage collection.

Environment: PeopleSoft HRMS, Financials 9/8.49, Oracle 10g, LINUX 5, Unix Solaris, Windows 2008 server, STAT 5.2.1

Confidential, Overland Park, KS

PeopleSoft DBA / Administrator

• Black and Veatch Corporation is a leading global engineering, consulting and construction company and specializes in infrastructure development in energy, water, telecommunications, federal, management consulting and environmental markets.
• This is an upgrade project focused at upgrading their current PeopleSoft HRMS 8.8SP1 PT 8.4 application to the latest HRMS 9.1 PT 8.50 and also implementing eProfile Manager Self Service as part of the upgrade. Working with a team of 3 onsite (2 BAs + PM) and 6 offshore (technical and functional) iGATE resources and the HP team who maintains the infrastructure and provides DBA and Network support, single handedly spearheaded the upgrade project. Performed an Upgrade from PeopleSoft HRMS 8.8 SP1 People Tools 8.44 on Oracle 9.2.0.4 database and AIX 5.1 to PeopleSoft HRMS 9.1 PeopleTools 8.50.08, Oracle 11gR2 database on Unix AIX 5.3.

Environment: PeopleSoft HRMS 9.1 PeopleTools 8.50.08, Oracle 11gR2, UNIX AIX 5.3, Windows Server 2008, Internet Explorer 8

Confidential, State of NY

Associate PeopleSoft Administrator / Desktop Support

• Worked as an Associate PeopleSoft Admin with added responsibility of a Security Administrator supporting their applications.
• The project is about combining different accounting systems of various state agencies to one combined PeopleSoft Financial application.
• Worked on Oracle Data Integrity (ODI) prototype on how to mask data elements on PeopleSoft pages and also control what data is displayed when users use non PeopleSoft reporting tools like SQL Plus, TOAD etc. Developed PL/SQL procedures to define policies and business logic while working with delivered packages for that purpose.
• Also worked on a prototype configuring and testing LDAP connectivity between PeopleSoft and State directory services.
• Reported the pros and cons of deploying the LDAP connectivity (authentication and authorization) to the management.

Environment: PeopleSoft Financials 9/8.49, Oracle 10g, UNIX AIX 5.3, STAT 5.2.1

Confidential, NY

PeopleSoft Administrator

• Worked on the PeopleSoft 8.3 - 8.8SP1 - 9 upgrade on Tools 8.4x and streamlined business procedures/processes.
• Installed/Configured/Deployed ELM 9 Tools 8.49 under Oracle 10g and Unix AIX 5.3 environment
• Installed/Configured/Deployed 4th Tuxedo Application Server in HCMS production environment.
• Applied Tax Updates for all environments using Change Assistant and STAT.
• Lead the Stress Testing effort for OE 2008.
• Successfully lead the DR exercises. Developed project plans and documented essential steps for manual failover to ensure minimal downtime. Coordinated with all teams involved for all their relevant tasks. Performed all the prep tasks, distributed PSADMIN tasks among team members and documented lessons learned for future reference.
• Troubleshoot various Production issues involving IPlanet, Web Logic and Tuxedo app servers or data issues.
• Used STAT for Prod and Non-Prod migrations as well as the Tivoli Maestro console to troubleshoot maestro jobs that are run in the batch trails every day.
• Involved in system performance monitoring and tuning, storage management, database backup and disaster recovery etc
• Worked with the DBA team in applying database patches.
• Worked with development team to implement FTP processing from within the PeopleSoft application.
• Organized/scheduled meetings to discuss various issues with DBA and Development teams.
• Recommended and Implemented Service-Now for managing service requests thereby drastically reducing emails and improving team productivity.
• Skillfully addressed day-to-day activities (DB Refreshes, Migrations, FTP Requests, UNIX Permissions, Space Mgmt., etc.).
• Managed / distributed off hours tasks to offshore team members.

Environment: PeopleSoft HCMS 9/8.49, CRM 8.8SP1/8.44, ELM 8.8SP1/8.44, Oracle 10g, UNIX AIX 5.3, Financials, EPM, Maestro Job Scheduler, STAT.