PROFESSIONAL SUMMARY:

• Over 10 Years of experience as PeopleSoft Administrator (Upgrades and Support Activities) for PeopleSoft Application and Databases.
• Experience to lead team of PeopleSoft Administrators for EPM, Finance and HRMS Application.
• Experience as Architect and Administrator for Confidential (Data Archival Tool).
• Experience in administrating other third - party Applications like IBM Information Server (Datastage), Pentaho, Microstrategy and OBIEE reporting tool.
• Excellent knowledge and experience in Administrating PeopleSoft Server components like Application Servers, Process Schedulers, Tuxedo, Weblogic, PIA (PeopleSoft Internet Architecture), Integration Broker, etc.
• Excellent knowledge of PeopleSoft Upgrade and applying PeopleSoft Tax Updates and PeopleSoft Update Manager (PUM).
• Experience in Unix Scripting and Process Automations.
• Excellent communication, analysis, problem-solving skills, Adaptable to change, Strong Attitude, Creativity, Analytical approach to problem solving and highly task oriented.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

PeopleSoft Application Administrator

Environment: PeopleSoft FSCM 9.2 Image 26, People Tools 8.54.15/8.56.06 , Oracle 12.2.0.4, Windows 2008, Phire. Oracle Secure Enterprise Search and Elastic Search.

Responsibilities:

• Perform PeopleTools upgrade from PeopleTools 8.5 .06
• Apply PeopleSoft Application Update IDs from Image 16 till Image 26.
• Install and Configure Elastic Search using DPK on Windows Server.
• Install Oracle PeopleSoft Update Manager (PUM) for applying latest PUM images and patches into various environments including production.
• Update PeopleSoft Customization repository in PUM environment to perform impact analysis and to calculate retrofitting efforts.
• Perform Test Moves for DEV, SIT, UAT and Production environments.
• Create PeopleSoft Demo Environment and Upgrade Image Source for PeopleSoft Upgrade on Windows 2012 R2 Servers.
• Perform and Monitor Production Weekend maintenance.
• Perform PeopleSoft Code Migration using Phire version control tool.
• Monitor and Troubleshoot Control-M scheduled jobs.
• Monitor Oracle database performance; generate AWR reports, SQL Tuning Advisor to improve SQL performance.
• Troubleshoot jobs various inbound and outbound source systems.

Confidential, Mason, OH/Lake Mary, FL

PeopleSoft Application Administrator

Environment: s: PeopleSoft FSCM 9.0, People Tools 8.49, Oracle 11.2.0.4, AIX 7.1, Windows 2008, STAT 5.7.4.

Responsibilities:

• Configure PeopleSoft Application Servers, Process Schedulers and Weblogic Web Servers on AIX and Windows environment.
• Monitor Production Weekend maintenance and Database backups using RMAN (Oracle Recovery Management).
• Refresh non-Production Databases/environments from production for User Testing Cycles.
• Create PeopleSoft Demo Environment and Upgrade Image Source for PeopleSoft Upgrade on Windows 2012 R2 Servers.
• Monitor and Troubleshoot WLM (Workload Management) and Control M scheduled jobs on Daily basis.
• Monitor Oracle database performance; generate AWR reports, SQL Tuning Advisor to improve SQL performance.
• Troubleshoot jobs various inbound and outbound source systems.

Confidential, LakeMary, FL

Application/Tool SME

Environment: s: Work Load Manager, Control-M Client, Control-M Conversion tool

Responsibilities:

• Plan migration, testing and cutover approach including resource estimation.
• Install Control-M agents on Production and Non-Production Batch Servers.
• Extract WLM Schedule and Job details in CSV format for conversion process.
• Verify Base and Special Calendars assigned to Jobsets before and after conversion process.
• Verify script details, Input Parameters, Predecessor/Successor Jobs/JobSets before and after Conversion process.
• Identify Job Dependencies between other applications to create required Bridges for Control-M and WLM Applications.
• Educate and conduct training sessions for required team about Testing/Validation approach and job monitoring.
• Create Dummy Shell script for testing Converted jobs to avoid Data Manipulation in UAT and Prod Regions.
• Extract Control-M jobs in XML File from UAT region for requested Jobs.
• Update related content to prepare exported XML file for Production region.
• Request and Coordinate File Production cutover during weekend maintenance.
• Troubleshoot Control-M conversion result issues.

Confidential, Pittsburgh, PA

PeopleSoft Application Administrator

Environment: s: PeopleSoft HCM 9.2, People Tools 8.53, Oracle 11.2.0.4, Linux, STAT 5.7.4, Harvest.

Responsibilities:

• Performed Reverse Proxy configuration for HRMS Intranet Site.
• Configure Cold Fusion Program script (cfm) to distinguish Self-Service and HRMS Users.
• Apply Tax Updates to non-prod and Prod environments.
• Perform Application/Database refresh for non-prod environments.
• Work with DBA on Oracle Transparent Data Encryption (TDE) project.
• Develop new Table Export/Import scripts using Oracle Data Pump.
• Preparation of PeopleTools 8.55 upgrade, Windows Server Upgrade.
• Perform Production Migrations on Weekly Basis.
• Monitor and Troubleshoot Weekend Maintenance Issues.
• Provide support to Citrix Servers used by Offshore Development Centers at various locations.
• Analysis of Database and SQL Performance issues.
• Troubleshoot and provide support to Connect-NDM and Mainframe scheduled jobs.
• Troubleshoot and provide support all third party applications like MyTime and Taleo.
• Perform Database Backup and Troubleshoot TSM Issues.

Confidential

Team Member and Team Lead

Environment: s: PeopleSoft EPM 9.1, PeopleSoft FSCM 9.2, People Tools 8.51, PeopleTools 8.54, DB2 9.7 FP7, AIX/Linux, Windows, Microstrategy 9.1, Datastage 9.1, STAT 5.7.4.

Responsibilities:

• Working as Team Leader for team of Seven PS Administrators.
• Perform Yearly Capacity planning for Database and Storage.
• Perform Datastage Upgrade from 8.5 to 9.1.
• Perform Citrix Server migration and configuration to new Windows Servers.
• Worked on DB2 to Oracle Exadata database migration for Finance Application using Datastage.
• Perform Application/Database refresh for non-prod environments.
• Perform Production Migrations for PeopleSoft and ETL components.
• Monitor and Troubleshoot Weekend Maintenance Issues.
• Upgrade Quest STAT Application from 5.6.4 to 5.7.4.
• Apply IBM Information Server Patches to Datastage application.
• Configuration of Application Server, Web server, File server, Batch server for New Environments.
• Perform Database Backup and Troubleshoot TSM Issues.
• Manage Day-to-Day Activities/Task between PS Admin Team.
• Database Troubleshooting and Co-ordinate between various Teams to resolve issues.

Confidential, New York, NY

Application Administrator

Environment: s: AIX 5.3/6.1, EPM 9.1, DB2 9.7, Datastage 8.5 FP3

Responsibilities:

• Working as Application Administrator and Project Lead for AIX Server upgrade.
• Installation and configuration of Datastage Application on new servers.
• New scripts for Automated Application Startup and Shutdown VERITAS Cluster configuration.
• Perform VCS failover testing for DCAT and Production servers.
• Server validation during AIX OS and Server Frame Upgrade.
• Implementation of eTrust surrogate rules for PeopleSoft and Datastage.
• Configuration of Application Server, Web server, File server, Batch server for New Environments.

Confidential

Application Administrator and Upgrade Specialist

Environment: s: PeopleSoft EPM 8.9, PeopleSoft EPM 9.1, People Tools 8.46, People Tools 8.51.06, DB2 9.7 FP7, AIX, Windows, Datastage 7.1 and 8.1 FP1.

Responsibilities:

• Worked as PeopleSoft Admin/DBA (Upgrade Specialist).
• Configuration of PeopleSoft Upgrade Assistant.
• Perform Keep-Drop and Fit-Gap Analysis.
• Configuration of Application Server, Web server, File server, Batch server for PeopleSoft EPM 8.9 and 9.1.
• Installation and configuration of Datastage 8.1 and related Projects.
• Implementation of Datastage Security.
• Performed SIT, UAT Test Moves.
• Apply PeopleTools Patches using Change Assistant.
• Creation of Data Conversion scripts with respect to PeopleSoft 8.9 MP1 and 9.1 for custom records.
• Running audit reports (SYSAUDIT and DDDAUDIT) and cleans the audit results.
• Retrofitting of Security related objects like Permission List, Roles, etc.
• Troubleshooting of various issues related to upgrade process and PeopleSoft Installation.

Confidential

Application Administrator and SME

Environment: s: Confidential 5.1, Oracle 11g Exadata.

Responsibilities:

• Working as Optim Application Administrator and Design Architect.
• Conversion of existing History data to Optim Archives.
• Create Data archival rules and retention policy for archived data.
• Configure adhoc relationship between tables for dependency.
• Automate Archive and Delete Request on Production Environment.
• Restore Archived Data in Production as per Business Requirements.
• Perform Optim Production Migrations.
• Troubleshooting Optim Archival Database Performance Issues.

Confidential, New York, NY

Application Administrator and SME

Environment: s: Confidential 5.1, DB2 9.7 FP1, Oracle 11g.

Responsibilities:

• Implemented Archive Requests and Access Definitions.
• Conversion of existing History Database to Optim Archives.
• Map DB2 ODBC Nicknames with Optim Archive Data Collections.
• Run Archive and Delete Request on Production Environment during conversion.
• Worked on Automation of Archival and Delete Process for weekend maintenance.
• Restore Archived Data in Production as per Business Requirements.
• Troubleshooting Optim Archival Database Performance Issues.

Confidential, New York, NY

Application Administrator

Environment: s: DB2 9.7 FP7, AIX, Datastage 8.1 FP1, Datastage 8.5 FP3

Responsibilities:

• Working as Application Administrator and Project Lead for Datastage Upgrade Project.
• Installation of Datastage 8.5 Application on existing servers.
• Apply Fix packs to Datastage 8.5 Application.
• Reconfigure Datastage environment variables and Project parameters.
• Import all Datastage Jobs to Datastage 8.5 Project and compile them.
• Reconfigure PeopleSoft Process Schedulers for Datastage 8.5 Application.
• Configure Unix Shell Script for automated execution of DS Jobs and Sequencers.
• Setup DS Project and File System security based on OS Authentication.
• Setup DS 8.5 project backup using shell scripts during weekend maintenance.
• Performance and SIT testing for DS 8.5 Application.
• Uninstall Datastage 8.1 Application from all Servers.

Confidential

Application Upgrade Specialist

Environment: s: PeopleSoft HCM 8.9 MP1, PeopleSoft HCM 9.1, People Tools 8.49.15, People Tools 8.50.06, Oracle 11g, Windows, UNIX.

Responsibilities:

• Worked as PeopleSoft Admin/DBA (Upgrade Specialist) for the team of 2 in onsite and 5 in offshore.
• Apply Tax updates and PeopleTools Patches using Change Assistant.
• Creation of Data Conversion scripts with respect to PeopleSoft 8.9 MP1 and 9.1 for custom records.
• Running audit reports (SYSAUDIT and DDDAUDIT) and cleans the audit results.
• Retrofitting of Security related objects like Permission List, Roles, etc.
• Created Integration Broker gateway and message nodes for the Source and Target PeopleSoft Applications, configured report nodes.
• Troubleshooting of various issues related to upgrade process and PeopleSoft Installation.