SUMMARY

Detailed Oriented PeopleSoft System Administrator with over 12 years of consulting experience. Specializing in ERP Technical Architecture, technology assessments, client server infrastructure, database systems, performance tuning, support and troubleshooting during the entire lifecycle of the project and provide quality implementation services. Worked in the areas of architecture end-to-end , infrastructure sizing, Production Support, administration i.e., installation, configuration, upgrade, pre and post production maintenance, troubleshooting and performance tuning of PeopleSoft applications and its associated components, Expert level knowledge on Oracle database, PeopleSoft's Tuxedo based middle tier application server and Weblogic web servers. Recognized for technical mastery, superior problem-solving, leadership, quick troubleshooting, relationship building, and strategic planning skills.

Technical Skills

• Expert level knowledge on the PeopleSoft technology platform and related technologies. Versions 7 - 9.1.
• PeopleSoft Financials, Supply Chain, HRMS, Learning Solutions, CRM, EPM, and Portal.
• Extensive hands-on experience in PeopleSoft implementations and application upgrades. Have done more than 10 Tools only Upgrades and 4 full application Upgrades. Have worked on many Implementations.
• Expertise installing, configuring, maintaining PeopleSoft Application, Application Servers Tuxedo , Process scheduler servers, Web Servers WebLogic Versions 6 through 10 , file servers, data archiving,SQR, PeopleCode, App Engine, Crystal Reports, PIA, Security, Upgrade Assistant, Change Assistant
• Expert level Experience in applying PeopleSoft patches and fixes, Tax Updates, Updates and Fixes using Change Assistant.
• Experience with Performance tuning Identify and fix performance bottlenecks and tune the applications .
• Experience in proactively capacity planning and performance sizing of PeopleSoft applications.
• Expertise with networking, firewalls, Proxy servers, Load balancers.
• Setup and administer SSL and certificates.
• Version Control: - STAT, Phire administration and migrations. UC4, Control-M ,Tivoli Schedulers,
• Hands on experience maintain e-modules mohomine and TAM Resume Mirror
• Worked on Versions 7.3 11g R2
• Stress testing with Load Runner
• Experience maintaining over 60 instances on some occasions.
• Expert Level Knowledge on Oracle Performance tuning, have done multiple Oracle upgrades from Version 7 to Oracle 11g.
• Database security, Oracle advanced security, data scrambling ,Oracle data masking, Transparent Data Encryption
• Database monitoring with Oracle Enterprise Manager/Grid Control.
• Expertise in setting up DR solutions, standby databases and Data guard.
• Developed backup and disaster recovery plans. setup RMAN backup etc
• Hands on experience on Oracle Clusterware Installed CRS,upgrade and patch management of CRS
• Installed/Configured 10g/11gR2 RAC and ASM on AIX,Solaris and Linux

Work Summary

Sr. PeopleSoft Oracle DBA

Confidential

Technologies: PeopleSoft People tools 8.53, Oracle 11g rel 2,Oracle 12c , Solaris 10, Weblogic 10.3, COBOL, LDAP, RMAN, Tuxedo 10.3, ,HRMS 9.0,STAT 5.7, Control -M, OEM 12c, Foglight

• Upgraded People tools from 8.49 to 8.53 for HRMS 9.0
• Upgraded the Oracle 11g rel 2 to 12c and document it. The tools go live will not be on 12 c but on the existing database release only.
• Installed all software and third party software including java 7 and all other software like weblogic, tuxedo for new tools
• Recommended how many application server and Weblogic PIA domains needed for their current production.
• Performance tuned the architecture for 1500 user concurrency.
• Supported the load test using OATS.
• Created all the self SSL Certs for all the servers and also for VeriSign certs for Production and applied it.
• Created some materialized views for performance and tested it for improved performance.
• Created scripts for hourly status report for Production PeopleSoft.
• Configured load balanced gateway for integration broker and setup integration between HRMS and Portal. This portal is on Tools 8.51
• Fine tuned integration broker to improve performance.
• Configured virus-scan for PeopleSoft attachment on new tools replacing unixftp.Due to budget constraints they still opted to go with the old F-PORT virus scan. I customized the delivered ftp Unix script so that it will still work with new tools 8.53. Evaluated the new Virus software vendors for future implementations and delivered the document.
• Applied quarterly CPU patches but advised to go with the PSU's and delivered a presentation on PSU to the client.
• Fix the PD Library search for customized tools search. This PD search was failing after the tools upgrade due to their customized tools
• Upgraded STAT from 5.6 to 5.7 and worked on the new workflow.
• Fine tuned some of the PS processes which were taking longer time to complete.

Sr. PeopleSoft Admin

Confidential

Technologies: PeopleSoft Peopletools 8.52, Oracle 11g, Redhat Linux 5.7, Weblogic 10, NVision, COBOL, LDAP, RMAN, ASM, Tuxedo 10.3,FSCM 9.0 ,HRMS 9.0,STAT 5.6

• Upgraded Peopletools from 8.50 to 8.52 for HRMS, ELM and FSCM
• Applied bundles using change assistant on HRMS environment.
• Performance tuned the architecture for 3,000 user concurrency.
• Created scripts for hourly status report for Production PeopleSoft.
• Setup the new report repository server for HRMS and tested the reports on the new server.
• Configured load balanced gateway for integration broker and setup integration between HRMS and FSCM.
• Fine tuned integration broker to improve performance.
• Configured virus-scan for PeopleSoft attachment on new tools replacing unixftp.
• Created 4 node data guard RAC standby on Linux configured data guard broker and tested the fail over and switch over
• Converted the databases to advanced compression and tested the performance
• Performance tuned the time and labor and some financials jobs.
• Setup the databases with the TSM tape backup and configured it on RMAN
• Applied PSU rolling upgrades on all the Grid and databases homes.
• Created the procedure to clone PeopleSoft databases from production RAC to non-RAC ASM. This will automate the PeopleSoft security export, remove all the production links and update the refreshed environment with the existing URL's, security import etc.
• Partitioned the large financial and HRMS tables over 5 million rows which were identified in the long running queries and created the procedure so that the builds will be done using application designer.
• Upgraded STAT from 5.6 to 5.7 and configured the work-flow.
• Fine tune the application server and helped on the new load balancer F5 setup and configuration. created new PIA and configured for this new hardware loadbalancer.
• Fine-tuned some of the sql queries using hints, profiles which were continuously shown on the AWR reports.
• PeopleSoft Production Support 24/7.

Sr. PeopleSoft Systems Admin

Confidential

Technologies: PeopleSoft Peopletools 8.48.17- 8.51, Oracle 11g/10g, Redhat Linux 5, Weblogic 10.3, NVision, COBOL, LDAP, Linux Red Hat 5, RMAN, ASM, Tuxedo 10.3,FSCM 8.8,Revenue Mgt 8.9,FSCM 9.1,Foglight,Autosys,TWS,STAT

• Plan, Architect, Installed and configured PeopleSoft from scratch on all the new servers including tools, microfocus COBOL, Weblogic, Tuxedo and created all the PeopleSoft Production,dev,test and DR environments.
• Migrated PeopleSoft database Oracle 10g from Solaris 10 to Red hat Linux 5.9
• Upgraded PeopleSoft FSCM 8.9 PeopleTools 8.48.07 to FSCM 9.1 PeopleTools 8.51.07
• Upgraded Oracle from 10g to Oracle 11g and migrated existing Demo and all the instances from Oracle10.2.0.4 to 11.2.0.3
• Provided Production support 7x24 for Tier-3
• Setup RMAN for backup and Recovery used flash recovery area.
• Applied Oracle database quarterly patches CPU patches on all dev, test and production environments
• Applied PeopleSoft Required-for-Install patches including maintenance packs, bundles as required.
• Applied weblogic and tuxedo patches
• Addressed the application vulnerability scan report with the Unix and security team
• Setup Data-guard for 2 standby databases and opened one DR db for daily reporting purposes. Created shell scripts for process scheduler, application and web servers.
• Performed extensive tuning on Application Servers and Web Servers for both FIN and Revenue Management
• Assists team in analyzing requirements, change request, does impact analysis and provides estimation. Initiates change requests.
• Automated the PeopleSoft nightly refresh for reporting purposes
• Created all monitoring scripts for PeopleSoft Application server, Web and Process Schedulers
• Performed tuning on all Tiers:- Web and Application servers based on Load-runner results
• Implemented automated RM Process by integrating PeopleSoft Revenue management with the federal treasury pay.gov

PeopleSoft Systems Admin

Confidential

Technologies: PeopleSoft HRMS 9.0, HCM 9.0, Enterprise Portal 9.0,Benefit Admin 9.0, ELM, Payroll 9.0, Time and Labor 9.0, Campus Solutions 9.0 for University of DC, Cobol 5, Peopletools 8.49.25, Oracle 11g/10g, AIX5.3, PVCS, Dimensions, Phire, BEA Weblogic 9.1, LDAP, Filenet, Linux Red Hat 5,Oracle Enterprise Linux,UC4, Resume Mirror, TAM, RAC,RMAN, ASM

• Led the PeopleSoft Upgrade environment on PeopleSoft's HRMS, on PeopleTools 8.49.25/8.46.04 and Upgraded PeopleSoft HCM Environment from 8.8 SP1 to 9.0.
• Upgraded Oracle from 10g to Oracle 11g and migrated existing Demo and all the HCM instances from Oracle10g to 11g.
• Responsible for 24/7 database and PeopleSoft System administration Production Support of all PeopleSoft applications in HA architecture configuration.
• Capacity planning for 30k users performed for PeopleSoft environment
• Led the data center move for PeopleSoft and PASS Environments.
• Data encryption using Transparent Data Encryption for PASS environment.
• Migrated PeopleSoft from AIX to Linux Platform. Designed the new architect layout of all the servers and physical layout for HA. This Linux move was on VM Ware.
• Install PeopleSoft application 9.0 on Linux 5 and 8.8 version on AIX IBM p-series servers
• Worked as a Technical lead for PeopleSoft HRMS implementation. Worked as a PeopleSoft
• admin lead for Payroll implementation and other modules.
• Written shell scripts for refreshing/cloning of development instances, backups and restores
• from Production environment. Set up shell scripts for daily PIA maintenance and other
• monitoring scripts for Application servers.
• Configured the interfaces supported by PeopleTools 8.49.25 using the Gateway Integration
• broker, web services that removed the need for flat file transfers.
• Implemented Resume Mirror Talent Acquisition Manager for eRecruit.
• Worked on data conversion performance tuning during upgrades.
• Applied bundles/upgrades,quaterly tax upgrades as required using change assistant and then
• Synced different environments
• Applied SSL certificate on present production and maintained self signed certificates for
• other non-production environments.
• Brought down Time Labor pay roll time processes to 1/3 rd of time.
• Created training environment and masked data using Oracle data masking pack.
• Implemented Oracle 10g two node RAC for PeopleSoft and PASS. Converted single instance
• to RAC.
• Re-Architecture and Stabilize the current production environment for 3500 concurrent users
• by Recommending web-servers clustering and adding physical load balancer Used BigIP
• F5 .
• Database High availability Failover Design: Implemented data guard in maximum
• availability mode to provide reliability for disaster by implementing two different physical
• locations data centers and/or switching over to any one of these sites for maintenance
• purposes.
• Troubleshooting and Performance Tuning: This is one of my major tasks here to troubleshoot
• performance problems either at oracle level or people soft technology. I solved many
• performance and system related issues.