SUMMARY:

• 15+ Years of Overall IT Experience as PeopleSoft DBA / Administrator in FSCM, HCM, EPM, CRM, CS, which includes full time corporate training experience on oracle & PeopleSoft, currently pursuing PMP training.
• Migrations using Quest STAT tool, Phire tool, App Designer
• Lead Disaster Recovery Exercise by coordinating with System Administrators and Application teams.
• Change management using BMC Remedy tool
• Applying Patches (Web, Tuxedo Rolling Patch, DB CPU)
• PeopleSoft Compare, Copy and Environment Refresh
• Working with Change Assistant and Upgrade Assistant
• Install, configure, trouble - shoot, performance tuning and administration of PeopleSoft Web, App and Process Scheduler Servers
• Working with Web Logic Admin Console
• Customize and implement Process Scheduler Purge SQR process
• Develop, customize and implement Application Messaging Archive and Purge Application Engine process
• Configure, implement and work with Integration Broker, Change Assistant, Environment Management Hub / Agents, Performance Monitor
• Configure Messaging Gateways
• Developed and deployed Monitoring scripts for Message queues
• Portal and Security Administration
• PeopleSoft Workstation install and support
• Refreshing PeopleSoft lower environment databases with Production using Oracle export/import, automated refreshes, including data mover.
• Working with HR tax updates
• Developer and Online Business User support
• On-call support for PeopleSoft Production databases
• PeopleSoft Trace for issue identification and resolution
• PeopleSoft Portal implementation of SingleSignOn for Production & Non-Production instances
• Up-gradation of PeopleTools & Application HRMS, FSCM, EPM, CS, SES to latest 9.2 (Physical & PeopleSoft Cloud Architecture)
• Creation of services (Windows environment)
• Implementation of AMP (Application Management Pack)
• Working with PeopleSoft Customer Connection and GSC
• Good experience with AWS, (DNS setup), setting of different components of PeopleSoft like Web / APP / PRCS / SES / DBs on AWS environments for production and non-production environments, High Availability architecting.
• Shell scripting in UNIX
• Served as interview panelist, participated in several recruitment drives
• Trained by Oracle on PeopleTools 8.50 Installation and Server Administration
• Lead a team for creation of global training databases for IBM on HCM/ELM/FSCM/EPM/CS
• Implemented Hardening of PeopleSoft instances (Web/App/DB)
• Experienced in Backup and Recovery using Hot backup, Cold backup, Export and Import. Recovery of tables, data files, rollback segments, redo log files and control files whenever required.
• 5+ years of experience in coding and testing PL/SQL stored procedures, functions, packages, triggers, tables, complex SQL queries and views.
• Experienced in Cloning, replication of Production database to create Q/A, system test databases in numerous no’ of occasions.
• Applied numerous Patches for Oracle including Security patches, coordinated with Application teams for downtime and smooth rollover. worked with implementing Oracle TDE (Transparent Data Encryption) 12C
• Worked with TOAD, OEM, Techtia (SSH2, SFTP2), Quest STAT

TECHNICAL SKILLS:

ERP Packages: PeopleSoft HRMS 8.8, 9.0, 9.1, 9.2/Financials 8.9, 9.0,9.1,9.2/CS 9.1

PeopleTools: 8.44/8.45/8.47/8.48/8.49/8.50/8.51/8.52/8.53/8.54/8.55

Database Oracle: 9i/10g/11gR2/12c (TDE), Data Guard, DB2

GUI Tools: TOAD, OEM, Techtia (SSH2, SFTP2), Quest STAT (Migration tool), PUM (PeopleSoft Update Manager), PeopleSoft Cloud Architecture

Languages: SQL, PL/SQL, C, HTML

Operating Systems: Solaris 9/10, IBM AIX 5.x,/6.x/7.x, UNIX, RedHat Linux 5.x/6.x/7.x, Windows 2012Server (Data Center), 2K/2K3Server/NT/98/95, Windows 3.1, DOS, Mac Mavericks 10.9, Mavericks server, El Capitan 10.11, AWS (Amazon Web services)

Oracle Tools: SQL Plus, RMAN, EXP/IMP, Mainframes

Middleware: Tuxedo & Web Logic 8.1 SP1, SP2, 9.2, 10.2, 10.3.3, 12.1.2.3.0.0 64- bit, Patch Level 078

Change management: BMC Remedy tool, Service now

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

PeopleSoft Administrator

Responsibilities:

• Performed PeopleSoft application upgrade 9.1 to 9.2 tools upgrade from 8.44 to 8.55.10, moved entire HR ERP to AWS
• Supported HRMS Application as primary Apps DBA on 24*7 basis.
• Responsible for PeopleSoft infrastructure, maintenance and support.
• Migration of projects from various environments using customized Phire migration tool.
• Process Scheduler, Application Server and webserver startup, shutdown, and troubleshooting in case of issues.
• PeopleSoft Pre and Post Refresh activities of Support environments from Production environments.
• Performance monitoring (Query performance, DB performance, PIA performance)
• Installed security certificates for integration broker to communicate with third party application.
• Assisted development team in testing ( Functionality , Regression , and Acceptance) testing of the application. worked with PUM (PeopleSoft Update Manger), PeopleSoft lifecycle / update management tool
• Setup of Remote desktop on AWS for change assistant needed for upgrade
• Worked in AWS migration, DNS setup, overviewing AWS load using AWS management screens, setup PeopleSoft environment on AWS on different templates like very large / large / small, setting of different components like Web / APP / PRCS / SES / DBs on AWS environments for production and non-production environments, worked in designing High Availability of PeopleSoft.
• AWS experiences as stated below:-
• EC2 - Elastic compute cloud (virtual server hosting)
• SG - Security groups, with inbound rules, ip address routings
• ELB - Elastic Load balancers (App server / Web server / Database layer levels) worked with cloud team on Auto scaling with python scripts
• AMI - Amazon Managed Image
• Route 53 - DNS management
• Cloud Watch - alerting system / analytics / reporting of AWS
• S3 - Amazon Simple Storage Server worked with cloud team to automate spinning of new instance with new tier Web server / Web IB server / APP server / DB server setup new environments with automated scripts of AWS at its different tiers WEB/APP/PRCS/DB worked with cloud team to establish PeopleSoft standardizations in creating AMTs needed to spin more instances of different tiers worked along with DB team on fail over testing, swapping of database from primary to secondary & swapping back to primary database, help analyze PeopleSoft all tiers, ensuring its optimal performance while performing the swaps from primary to secondary then back to primary production database worked on refreshes of Production Instances on AWS on to lower environments like DEV/TEST/SHADOW/GoldenGate

Environment: PeopleSoft 9.2/9.1/9.0 (PeopleSoft on AWS), People Tools 8.55, 8.4, Oracle 12c 10.2.0.4, Core - HRMS, Oracle Tuxedo, Version 12.1.3.0.0, 64-bit, Patch Level 078.

Confidential, Foster city, CA

Senior PeopleSoft Administrator / Architect

• Supporting HRMS Application as primary Apps DBA on 24*7 basis.

• Responsible for PeopleSoft infrastructure, maintenance and support. worked with DR team on annual DR exercise, conducting DR meetings / DR scheduling / DR pre-post reporting / DR lessons learnt / DR documentation
• Migration of projects from various environments using STAT tool.
• Process Scheduler, Application Server and webserver startup, shutdown, and troubleshooting in case of issues.
• PeopleSoft Pre and Post Refresh activities of Support environments from Production environments.
• Performance monitoring (Query performance, DB performance, PIA performance)
• Applied Product Patch for PeopleTools, Maintenance pack for Application and several Tax patches including Global payroll UK, Swiss and NA tax updates.
• Installed security certificates for integration broker to communicate with third party application.
• Assisted development team in testing ( Functionality , Regression , and Acceptance) testing of the application. worked with PUM (PeopleSoft Update Manger), PeopleSoft lifecycle / update management tool
• Worked in AWS migration, DNS setup, overviewing AWS load using AWS management screens, setup PeopleSoft environment on AWS on different templates like very large / large / small, setting of different components like Web / APP / PRCS / SES / DBs on AWS environments for production and non-production environments, worked in designing High Availability of PeopleSoft.
• Ran Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments.

Environment: PeopleSoft 9.2/9.1/9.0/8.9/8.8 (PeopleSoft Cloud), People Tools 8.54, 8.53, 8.49, Oracle 11, Core - HRMS.

Confidential

PeopleSoft Admin Manager

Responsibilities:

• HCM PeopleTools 8.52 HRMS application 9.2 Production support manager

• Responsible for HRMS / CRM / PORTAL / several and Non-PeopleSoft production instances,
• Have worked with several teams simultaneously to fix several production issues with on the spot resolution (GEMS team, Oracle internal / vendor teams and other database teams, Linux / NT server teams, GNOC teams internal / vendor teams, GP / Payroll teams, application functional / technical teams, incident management teams, respected stake holders, interfaces teams).
• Worked with several RCA calls to arrive at the actual RCA of several production issues, later on moved all the instances to PeopleSoft Cloud Architecture.
• Conducted Disaster Recovery activity and successfully completed all activities on Production
• Machines, co-relating vendor Network teams, vendor Oracle DBA teams, SCB application teams, Notification Management teams for setting blackouts, Change team, L1 support team, PORTAL / HR teams, after completion enforced sign offs from each team to ensure perfect completion and took towards issue less closure
• Identified idle space and implemented space re-allocation and freeing up of idle space on all production servers accumulating up to 500TB+ saving rent and cost up-to a million$ a year to the client.
• Lead Production team guiding them to resolve issues encountered, resolution proposals, client liaison SPOC, presented issues tracker which enabled project managers to track issues and work on closures
• Configured Integration Broker failover
• Conducted Quarterly reboot of all Production Machines and completed without issues, coordinating with vendor Network teams, vendor Oracle DBA teams, vendor application teams, SCB application teams, Notification Management teams for setting blackouts, Change team, L1 support team, PORTAL / HR teams, after completion enforced sign offs from each team to ensure perfect completion and took towards issue less closure
• Ran pre & post compare reports between UAT & production
• Performance monitoring (Query performance, DB performance, PIA performance)
• Liaison with network / GEMS / Oracle Admin / Linux / Wintel / GNOC & other teams to sort out hardware and network issues with regards to connectivity, bandwidth, firewalls
• Migrated objects using Quest STAT tool, backed up objects using STAT tool, migrated using App Designer, migrated externals using Win SCP
• Identified several bottle necks in IB & Production APP / PRCS worked with Oracle to get resolutions and implemented the same to have a stable environment without down time.

Confidential

Lead PeopleSoft Administrator

Responsibilities:

• Architected Production and Non-Production environment both on Physical & Cloud Architecture, along with sizing, partitioning

• Lead Systems Work Groups guiding the managers on the project progress, issues encountered, resolution proposals, client liaison SPOC, presented issues tracker which enabled project managers to track issues and work on closures
• Created DR Architecture / DR Diagrams, setup DR site, delivered on-site/ off shore DR documentation, performed DR with partial / complete failover.
• Installed and configured PeopleSoft HRMS 9.1/ FSCM 9.1/ CS 9.0
• Installed and Configured the PeopleSoft PIA Components (Database Server, Application Server, Process Scheduler server) for PeopleSoft HRMS/FSCM/CS application
• Configured Integration Broker, Nodes, channels to communicate with Internal and external systems.
• Ran compare reports and involved in customizations, new development and configurations.
• Configured PSEM Hub & PSEM Agent and change assistant.
• Configured PeopleSoft setup for the Workstations, Servers.
• Liaison with network team to sort out hardware and network issues with regards to connectivity, bandwidth, firewalls
• Primary SPOC for setting up VPN, managed VPN, presented reports on access, setting up user profile in VPN for off-shore and on-site VPN users connecting to production & non-production instances worked exclusively on Performance monitoring
• Worked with government institutions to generate public/private key in order to connect their machines with 2 level password authentication, required by FSCM/CG/CS to sftp files to and fro
• Supported the Development team for their Database requests/technical problems.
• Analyzed and applied the PeopleSoft Fixes and Patch (Web server Patches, Tuxedo rolling patches).
• Notify & circulate release notes of HRMS tax updates to support teams, after analysis applied tax updates
• Setup SSL on PeopleSoft installation
• Setup LDAP PeopleSoft authentication
• Fine-tuned projects specific to PeopleSoft users in Solaris OS Production so as to ideally utilize RAM, based on the current environment band width, fine-tuned non-production projects specific to PeopleSoft users, as non-prod were shared environments sharing DMO/DEV/UAT/SIT with multiple instances in the same machines
• Designed Solaris PeopleSoft userid/Guid so as to help DFS share among all environments, designed easy to understand naming convention for PeopleSoft user-ids among prod and non-prod environments
• Implemented Hardening on production App-server/Web server/DB level
• Scheduled and monitored the PeopleSoft Process Scheduler Jobs
• Migrated Projects between environments (Dev-Test-UAT-SIT-Production).
• Data and environment refreshes in all non-production environments
• Primary Production support manager for HRMS/FSCM/CS/CG environments.
• Shell scripting in UNIX
• Trained client’s support team enabling them to be self-sufficient to take care of support issues in case of contingencies, who were non-PeopleSoft experts by giving them hands on demos as a value add
• Proposed several solutions for show-stopper issues with a quick resolution and implementation based on experiences from previous projects and technical know how
• Prepared lessons learnt documentation and shared the same with the client, which would help them stabilize their environment after implementation completion

Environment: PeopleSoft HRMS 8.8, 9.1, PeopleTools 8.48, 8.50, 8.52 Oracle 9i,11g Windows NT server (2008/2013), Oracle Solaris 10, Batch Server, Application Server BEA Tuxedo, Web Logic Web Server 10.3.3, Application Designer, Data Mover, Change assistant, Security Administration, SQR, Application Engine, Utilities, Process Monitor, Process Scheduler, export and import Utilities, Techtia (ssh/sftp)

Confidential

Senior PeopleSoft Administrator

Responsibilities:

• Configured PeopleSoft setup for the Workstations, Servers.

• Supported Development teams for their Database & application requests / technical problems.
• Analyzed and applied PeopleSoft Fixes and Patch.
• Notified & circulated release notes of GP
• Scheduled and monitored the PeopleSoft Process Scheduler Jobs
• Migrated Projects between the environments (Dev-Test-UAT-Production).
• Assisted development team working with ETL to extract data from Mainframes
• Primary Production support for FSCM environments.
• Shell scripting in UNIX
• Served as interview panelist, participated in several recruitment drives
• Lead a team for creation of global training databases for IBM on HCM/ELM/FSCM/EPM/CS and successfully built a repository of documents needed for the Employer to maintain instances permanently was a part of DR team performed in 1 DR dry run cycle

Environment: PeopleSoft HRMS 8.8, 9.1 (Physical & Cloud Architecture), PeopleTools 8.48, 8.50, Oracle 9i, 11g Windows NT server, IBM AIX 5.3, 6.1, Batch Server, Application Server BEA Tuxedo 10.2, Web Logic Web Server 10.2, Application Designer, Data Mover, Change assistant, Security Administration, SQR, Application Engine, Utilities, Process Monitor, Process Scheduler, export and import Utilities.

Confidential,Kansas

Lead PeopleSoft Administrator

Responsibilities:

• Installed and configured PeopleSoft HRMS 9.1

• Installed and Configured PeopleSoft PIA Components (Database Server, Application Server, Process Scheduler server) for PeopleSoft HRMS application
• Configured Integration Broker, Nodes, channels to communicate with Internal and external systems.
• Ran compare reports and involved in customizations, new development and configurations.
• Configured PSEM Hub & PSEM Agent and change assistant.
• Ran Compare Reports (Production Vs Demo) database helped analyze customizations.
• Configured PeopleSoft setup for the Workstations, Servers.
• Supported Development team for their Database, Application requests / technical problems.
• Analyzed and apply the PeopleSoft Fixes and Patch.
• Notified & circulated release notes of HRMS tax updates, after analysis applied tax updates per request worked on finding PIA, DB, Queries performance issues, resolved successfully all of them
• Scheduled and monitored the PeopleSoft Process Scheduler Jobs
• Migrated Projects between environments (Dev-Test-UAT-Production).
• Data and environment refreshes in all non-production environments.
• Primary Production support for HRMS environments.
• Shell scripting in UNIX & automating timely execution through cron jobs

Environment: PeopleSoft HRMS 8.8, 9.1, PeopleTools 8.48, 8.50, Oracle 9i, 11g Windows NT server, IBM AIX 5.3, 6.1, Batch Server, Application Server BEA Tuxedo 10.2, Web Logic Web Server 10.2, Application Designer, Data Mover, Change assistant, Security Administration, SQR, Application Engine, CI, Utilities, Process Monitor, Process Scheduler, export and import Utilities.

Confidential

Senior PeopleSoft Database Administrator

Responsibilities:

• Installed and configured PeopleSoft HRMS/FIN/SCM 9.0 in all production and non-production environments.

• Installed and Configured PeopleSoft PIA Components (Database Server, Application Server, Process Scheduler server) for PeopleSoft FSCM, HRMS, and FIN applications.
• Configured Integration Broker, Nodes, channels to communicate with Internal and external systems.
• Ran compare reports and involved in customizations, new development and configurations.
• Configured PSEM Agent and change assistant.
• Ran Compare Reports (Production Vs Demo) database, helped analyze customizations.
• Configured PeopleSoft setup for the Workstations, Servers.
• Support ed Development team for their Database, Application requests/technical problems.
• Analyzed and Applied PeopleSoft Fixes and Patch.
• Scheduled and monitored PeopleSoft Process Scheduler Jobs.
• Created Process definition, Process, Job and Job Sets for Custom Developments.
• Migrat ed Projects between environments (Dev-Test-UAT-Production).
• Data and environment refreshes in all environments.
• Assisted developers with mapping of data using ETL (Extract Transform Loading), from Mainframes
• Primary Production support for HRMS/FSCM/EPM/OBIEE environments.
• Implemented PeopleSoft Portal SingleSignOn for Production & Non-Production instances
• Performed instance management (setup temp instances for migrations, stabilized objects /customizations and base lined objects/customizations into Gold instances, dropped all unwanted instances, thereby reducing hardware/network costs to the project and redundancy of work of developers)

Environment: PeopleSoft HRMS 9.0, PeopleTools 8.49, Oracle 9i, 10g, DB2, Mainframes, Windows NT, Batch Server, Application Server BEA Tuxedo 9.2, Web Logic Web Server 9.2, Application Designer, Data Mover, Change assistant, Security Administration, SQR, Application Engine, CI, Utilities, Process Monitor, Process Scheduler. PeopleSoft Portal, export and import Utilities.

Confidential

PeopleSoft Database Administrator

Responsibilities:

• Installed and configured PeopleSoft HRMS/FIN/SCM 9.0 in all production and non-production environments.

• Installed and Configured PeopleSoft PIA Components (Database Server, Application Server, Process Scheduler server) for PeopleSoft FSCM, HRMS, and FIN applications.
• Involved in tools upgrade from 8.47.12 to 8.48.14.
• Configured Integration Broker, Nodes, channels to communicate with Internal and external systems.
• Ran compare reports and involved in customizations, new development and configurations.
• Configured PSEM Agent and change assistant.
• Run Compare Reports (Production Vs Demo) database and helped analyze the customizations.
• Supported Development team for their Database, Application requests/technical problems.
• Involved in the Data conversions.
• Analyzed and Applied PeopleSoft Fixes and Patch.
• Scheduled and monitored PeopleSoft Process Scheduler Jobs.
• Created Process definition, Process, Job and Job Sets for Custom Developments.
• Migrated Projects between environments (Dev-Test-UAT-Production).
• Data and environment refreshes in all environments.
• Primary Production support for HRMS/FSCM/CRM environments.
• On-call support for PeopleSoft Production databases
• PeopleSoft Trace for issue identification and resolution
• PeopleSoft Portal implementation of SingleSignOn for Production & Non-Production instances
• Worked with PeopleSoft Customer Connection and GSC.

Environment: PeopleSoft HRMS 8.8 & 9.0, PeopleTools 8.44, 8.47 & 8.48, Oracle 9i, 10g

Windows NT, Batch Server, Application Server BEA Tuxedo 9.1, Web Logic Web Server 9.2, Application Designer, Data Mover, Change assistant, Security Administration, SQR, Application Engine, CI, Utilities, Process Monitor, Process Scheduler. PeopleSoft Portal, RMAN, export and import Utilities.

Confidential

PeopleSoft Database Administrator & Corporate Trainer

Responsibilities:

• Training Anubhuti’s corporate clients on PeopleSoft and Oracle administration

• Configured PeopleSoft setup for the Workstations, Servers.
• Created Processed Scheduler monitor
• Performed Query & database tuning.
• Installed Oracle Database for HRMS applications.
• Set up the different Oracle instances on the Server. Tuned the Oracle databases, I/O, memory, SQL and application.
• Performance monitoring and Backup/Recovery.
• Installed and configured PeopleSoft FIN/HRMS/EPM/CRM 9.0, HRMS 9.1
• Installed and configured PeopleTools version 8.49, 8.50.
• Installed and Configured the PeopleSoft PIA Components (Database Server, Application Server, Process Scheduler server) for PeopleSoft applications
• Installed and Configured the Oracle-PeopleSoft, PeopleSoft Database Servers.
• Migrated PeopleSoft Objects from development to production database.
• Performed extensive system maintenance and End user support
• Set-up the Users control, Process Scheduler, File Server, Database server.
• Applied PeopleSoft updates, fixes.
• Trained End-users and solved network Issues.

Environment: PeopleSoft FCM 9.0 HRMS 9.0, PeopleTools 8.49, Oracle 9i, Sun Solaris 8, Windows NT, Batch Server, Application Server, Apache Web Server, Application Designer, Data Mover, Security Administration, SQR, Application Engine, Utilities, Process Monitor, Process Scheduler.