* ***** ** ********** ** PeopleSoft Database and System administration and PeopleSoft Upgrade
In-depth knowledge of PeopleSoft architecture with a vast experience in installing, configuring and troubleshooting. Played a pivotal role in many breakthroughs. Below are some of them:
1.HA configuration: Have successfully implemented high availability on PeopleSoft application with load balancer for the first time on a customer system which was earlier running on a non - HA configuration.
2.Crystal check print with MICR fonts: Configured crystal reports with secured printer to print checks with MICR fonts. This was a breakthrough as this enabled customer to print checks directly from printer
3.Disaster recovery setup: Provided a complete DR solution to customer with full integration to external and internal interfaces in case of a disaster and making sure the continuity of business after disaster.
4.Troubleshooting and performance tuning: Build up an entire system of integrated PS applications (EPM, HR and FSCM) with configuration from scratch and resolved performance issues by tuning the web server, application server and database.
5.Candidate gateway setup for external (non-employee) candidates for HRMS - This required a public facing interface with limited access.
6.SSL configuration for PIA, integration broker, report node, REN server.
Extensive experience with PeopleSoft security – roles, permission lists and row level security. Acted as security admin to review, audit and develop security.
I have designed and delivered the entire PeopleSoft upgrade solution with PUM and non PUM applications. My upgrade experience expanse from 8.50 to 8.55 and from application 8.4 to 9.2 – FSCM, EPM and HCM.
Acted like an SME and constantly updated on latest technologies, updates and support information.
Hands on experience on working with various server platforms, have formulated strategies at the server level to support the PeopleSoft application on the windows platform, including configuring many functionalities like ftp, ftps, sftp and SSL certificates required by the PeopleSoft application to deliver its module based functionalities.
Capacity planning and scalability on system storage and future storage requirements, memory requirement and processor requirement, hardware and software requirements.
Expertise in Oracle Administration, Backup and Recovery procedures. Performance tuning of oracle database to support various PeopleSoft application.
Implementation, maintenance of Phire tool for change management
PeopleSoft Application version: FSCM 9.1, HRMS 9.2 and EPM 9.1
PeopleTools Version: 8.51, 8.52 and 8.53
Operating System: IBM – AIX, Windows 2003, 2008 R2, 2012 R2
Tools: Application designer, data mover, sql developer, TOAD, Windows task scheduler, PeopleSoft performance monitor, Change Assistant
Programming: PeopleCode, Application designer, SQL, Change Assistant, PUM (PeopleSoft Update Manager)
Database: Oracle 10g, 11g and 12c
Operating Systems: IBM AIX 6.1, Windows server 2008 R2, 2012 R2, Linux 5-7 flavors
DineEquity Inc. August 2016 – Present
Sr. PeopleSoft System Administrator and Oracle DBA
PeopleSoft FSCM 9.2 maintenance and upgrade (Peopletools 8.54)
Administration, capacity planning and monitoring of PeopleSoft application
PeopleSoft maintenance through PeopleSoft Update Manager (PUM)
Server sizing and resource foot print monitoring
Subject matter expert for
oPeopleSoft change management – Object migration
Data Centre migration
PeopleSoft database refresh
PeopleSoft database and application server cloning.
PeopleSoft Architecture – reimplementation, modifications, additions
Implementation, configuration of Oracle Enterprise Manager (OEM)
Lexmark International March 2016 to August 2016
PeopleSoft upgrade HCM 9.1 to 9.2 and Peopletools 8.53 to 8.55
Installation and configuration of PeopleSoft Update Manager (PUM) and Upgrade source images using Oracle virtual box and also through DPKs (Native OS method)
Design and implementation of 9.2 (PT 8.55) system
Reviewing test strategy from SIT, UAT to load testing and performance testing. Reviewing the test cases
Identified upgrade path, target pathc levels for Oracle database, tuxedo, WebLogic, Peopletools 8.55 and HCM 9.2
Integration with third party applications.
Planning and support
Configuring PUM and upgrade source image from DPKs and change assistant.
San Mateo County District Transit, San Mateo, CA March 2014 to March 2016
Re-implementation of PeopleSoft Human Capital Management, Finance & Supply Chain and Enterprise Performance Management applications.
Worked for the design and maintenance of the application in the build phase.
Planned, coordinated and executed the entire implementations from the Initial Pass to mock passes and final move to production.
Set up all PeopleSoft infrastructures for the Move to Production phase of the upgrade. Set up production servers ensuring application readiness for testing and production (go-live).
Installed new FSCM, HRMS and EPM 9.1 instances on 8.53 tools for UAT, training, development, SIT, data conversion and production.
Configuring the web, app and process scheduler domains and WebLogic profile for optimal performance.
Performance tuning of oracle database 11g primarily for running PeopleSoft jobs. The turnaround time was reduced for Finance conversion jobs from 12 hours to 3 hours after the tuning.
Configured addition third party and remote machines specific to client needs like check printer for printing crystal checks, Spear interface across IB, FTP/S for HR recruitment and Finance Billing interfaces and bank interfaces.
Migration strategy for PeopleSoft and non-PeopleSoft objects. Ensuring best practices are followed, standard operating procedure and proactively monitoring the migrating objects to keep the environments in sync
Application of PeopleTools patches, application updates, tax updates and backup of customizations before updates. Proactively coordinating with the team to identify customizations/code changes and then retrofit it after updates.
Involved in data conversion process from PeopleSoft 8.4 legacy systems to 9.1.
Database backup and application backups and maintenance. Monitoring the servers for space utilization by backups and implementing strategies to retain the backups on tapes.
Formulated disaster recovery strategy by creating a standby database server using Oracle data guard.
Laboratory Corporation of America, India January 2013 to March 2014
PeopleSoft Finance 9.1 AMS Program - Bug fix - Support -Enhancement - Upgrade - PeopleSoft Admin Support. Supporting production, UAT and lower environments.
Design and Maintenance of Application architecture.
Configuration and maintenance of PeopleSoft application, portal, tools, designer, report engines, search engines and process manuals.
PeopleSoft Security administration
Migration of objects across production and non-production environments
Periodical testing of database backups in coordination with DBA team.
Application of patches, fixes, tools patches and tax updates through change assistant.
PeopleSoft Upgrade, updates and patching.
Ensure proper documentation and knowledge sharing among the team to ensure continuity of business
Migration of PeopleSoft Objects, trees, nVision, Crystal and SQRs and controlling.
Application of PeopleSoft Performance monitor to monitor the application and analyze the reports for performance.
Data storage management, capacity planning and implementation.
Periodic testing of fail over of server, database and application as a Disaster recovery mechanism.
Capital One, India February 2011 to December 2012
Installing PeopleTools and Applications on all the AIX and Windows servers in the enterprise and their maintenance.
Troubleshooting problems with Application Server, Web Server and Process Server of each instance.
Configuration of Integration Broker between PeopleSoft HRMS & Finance application after refresh.
Data management using data mover
Applying Patches, Bundles, Updates (Tax Updates) to different instances using Change Assistant
Configuring REN server, report node, master-slave process scheduler,
Preparing activity schedule and coordinating with team members.
Managing PeopleSoft migration.
Co-ordinate with Oracle DBA team in performance tuning and database refresh activities.
B.S., Computer Science and Technology, Uttar Pradesh Technical University, India, 2009