Peoplesoft Server Administrator Resume Profile
SUMMARY
- Over 10 years of experience in IT and around 6 yrs of experience in PeopleSoft System Administration for HRMS/HCM, EPM, Portal, CRM, Student administration and Financials applications on a client/server environment.
- Pretty good experience in PeopleSoft new implementation, Conversion, Upgrade, Maintenance, Production support, Change Management and Application Security.
- Expertise in installation, configuration, setup, security and management of the PeopleSoft Internet Architecture PIA environment and related processing objects.
- Installed PeopleTools 8.50, 8.49, 8.48, 8.4x, Applications 9.1/9.0/8.9/8.8/8.3.
- Upgraded PeopleTools and Applications to subsequent versions.
- Worked on PeopleSoft Security on PeopleTools 8.50,8.4x/8.1x.
- Involved in implementing Segregation of Duties, which lead to Migrator Role and Executor Role.
- Successfully installed and configured BEA WebLogic Server 10.3/9.2/8.1/6.1/5.1, Application Server components namely Tuxedo 9.1/8.1/6.5/Jolt 1.2 and PeopleSoft 8 Processes
- Expertise in configuring and setting up Application Server domains, Process Scheduler domains, WebLogic, Web Sphere Tuxedo, Jolt, installing PIA.
- Comprehensive experience in setting up security in HRMS, Financials, EPM and Portal environments.
- Created multiple Application Server domains on separate host systems to access one database, an effective strategy for performance and tuning.
- Evaluating the required patches and applying them to the PeopleSoft system on a timely basis.
- Experienced PeopleSoft Applications Administrator including performance problems with SQR reports, App Engine, tuning SQL, Index creation, worked with DBA to tune the Database configuration parameters
- Extensive experience in PeopleTools Application Designer, Data Mover, Configuration Manager, PeopleSoft Security, PS Query, PeopleCode and Application Engine
- Have good understanding of Change Management, Change Control, Release Management and Configuration Management methodologies.
- Expertise using Quest STAT for PeopleSoft Change Management, performing migrations from the STAT Repository to several databases in the migration path with ability to rollback to the previous archive sets if needed., Creation of Archive Sets, Changing workflow, Configuration setup, helping developers and other STAT users to setup STAT client, troubleshooting issues related to configuration and accessing File Servers, Application Servers, Batch Servers and Database Servers.
- Extensive experience in applying PeopleSoft Updates, Patches Fixes, Tax Updates, Maintenance Packs and Service Packs.
- In-depth working knowledge of the following PeopleSoft Administration activities Tuning of Application Server, Process Scheduler, Web Server, Turn on Traces, Applying PS updates, patches fixes for several environments, Building SQL objects, cleaning up DDDAUDIT, SYSAUDIT, SQL Alter Audit Reports, Perform Database Refresh, Modify PS Security
- Hands on experience in setting up Single Signon, Integration Broker, LDAP Security and SSL authentication
- Worked and helped Developers, Testers, Functional Analysts, End users, DBAs, OS Administrators, Project Managers, and other technical team members to support and ensure PeopleSoft system availability and optimum performance
- Experience in migrating security in PeopleSoft using projects and data mover scripts and other automated utilities.
- Have excellent data modeling, analytical and problem solving skills and very good team player with excellent communication skills.
Technical Skills:
Languages | : | People Code, PL/SQL, C, C , Java |
Databases/ File Access | : | Oracle 8i/9i/10g/11g, Sybase, MS Access, SQL Server 2000/2005, DB2 ver7.0. |
Operating Systems | : | Windows 2000,2003,XP NT,HP-UX 11,AIX, Linux, Sun Solaris, Os/390, MVS |
Reporting Tools | : | SQR6.4, Crystal Reports 7.0/8.0, PS/nVision and PS Query. |
Web/Developing Tools | : | HTML, XML, VBScript, Java2, JVM, Java Servlets , TOAD |
ERP | : | PeopleSoft HRMS/HCM App- 9.1/9.0/8.8/8.3/8,PTools-8.50/8.48/8.47/8.4x,8.1x PeopleSoft Financials App-9.1/9.0/8.9/8.8/8.4PTools 8.49/8.468.42/8.1x PeopleSoft EPM, HR/FIN Budgeting App-9.0/8.9/8.8/8.3, PTools 8.49/8.4x PeopleSoft Portal Application 9.1/9/0/8.9/8.8/8.4 , PeopleTools 8.50/8.4x PeopleSoft Student Administration PeopleSoft CRM 9.1/9.0/8.9/8.8. PeopleSoft ELM 8.8, 8.9,9.0 |
People Tools | : | Application Designer, Data Mover, Configuration Manager, Application Engine, Query Manager |
Upgrade Tools | : | Change Assistant, Upgrade Assistant |
Application Servers | : | Tuxedo 9.1/8.1/6.5/,Jolt 1.2 |
Web Servers | : | WebLogic Server 10.3/9.2/8.1/6.1/5.1,Web Sphere |
Testing Tools | : | Quality Center, Clear Quest and Clear case. |
Others | : | Quest STAT, Informatica 6.1/5.1,Remedy |
Professional Experience:
Confidential
Role: PeopleSoft Server Administrator
Responsibilities:
- Perform PeopleSoft Server Administration Maintain Webs Servers, Application Servers, and Process Schedulers for the PeopleSoft environment for the In-Scope Applications.
- Provide 24x7 supports for PeopleSoft Server Administration
- Inform Horizon and/or recommend when an upgrade/renewal for PeopleSoft related software is suggested.
- Inform Horizon when configuration management is necessary, such as for installing Service packs, for software agent deployment, for configuring quota management software, or for patch management.
- Inform Horizon when problem management is necessary, such as for providing problem resolution, providing disk defragmentation, disk quota for VMware management, for Antivirus management, or for SAN Storage Area Network administration.
- Provide input regarding PeopleSoft security standards and best practices.
- Perform monthly security audits e.g. Application Designer Access, Generic ID's as per the defined Horizon's audit policies.
- Add / Update query trees in development, test and production environments.
- Installed and setup Change Assistant to apply application updates to the PeopleSoft applications on PeopleTools 8.48, 8.49 and above
- Applying Tax updates for Payroll.
- Resolving end user request with the PeopleSoft server components.
- Monitoring Web server logs
- Monitoring Disk space and Clearing log files.
- Interacting with IBM Midrange group, DSM group, Developers and Users to resolve the issues.
- Applying .dotpatches to People tools, clone or copy instances, backup instances.
- Refresh instances, periodic data refresh for instance, restore instances
- Annual performance tests and subsequent tuning, monitor PS Process Scheduler, WebServer, Application Server, Install, configure and maintain change assistant.
- Environment: HRMS/HCM 8.9, ELM 8.81, FN 9.0, PeopleTools 8.47/8.48/8.49, WebLogic 9.2/8.1,
- Tuxedo 9.1/8.1, Oracle 10g, AIX 5.3, Windows 2003 server, COBOL Server Express 4.0 SP2,Site Scope.
Confidential
Role: PeopleSoft Administrator
Responsibilities:
- Installed and configured Change Assistant to perform the Service Pack upgrades and Application Upgrades for Applications running on 8.8 and PeopleTools 8.46
- Installed PeopleSoft PeopleTools 8.48, HCM 8.9, Tuxedo 8.1, WebLogic 8.1.
- Deployed PeopleSoft Servlets PIA on WebLogic, created and loaded DEMO and SYS databases
- Installed Application Server, Process Scheduler, Web Server and PeopleSoft Internet Architecture.
- Installed and setup Change Assistant to apply application updates to the PeopleSoft applications on PeopleTools 8.48 and above
- Setup File Server for PeopleTools and PeopleSoft Application Modules HRMS, EPM and Portal
- Tuned SQL, PeopleCode Tracing on Application Server and the SQL, PeopleCode and AE Tracing on the Process Scheduler to help users troubleshoot issues related to their SQL, PeopleCode and Application Engine Programs
- Created multiple Application Server Domains to spread load across several hosts for optimal performance and to support more concurrent users
- Booted up additional server processes and tuned PSAPPSRV server process and JOLT as needed
- Monitored the queues and statuses of Application Server domains, Process Scheduler domains for troubleshooting purposes
- Extensively performed PeopleSoft Project, File Objects, and Data Migrations from one PeopleSoft environment to another
- Maintained Informatica 6.1/5.1 for older releases of EPM applications
- Tuned the PeopleSoft Application Server Configuration psappsrv.cfg for better performance
- Efficiently used the App Server memory by turning off the 6 Publish/Subscribe services in the environments where Application Messaging wasn't being used
- Tuned the Process Scheduler Configuration psprcs.cfg for optimal performance. A few parameters that were modified were, Logfence, Tracing settings, Enable Server Caching, Server Cache mode, Max In Memory Objects
- Increased the size of JVM Heap size for WebLogic
- Created a detailed performance tuning documentation to obtain optimal performance for all PeopleSoft Server components.
- Environment: HRMS/HCM 8.8/8.9, Enterprise Portal, EPM, PeopleTools 8.46/8.48, WebLogic,
- Tuxedo, SQL Server 2000, Windows 2003 server, Light Speed 4.8.4
Confidential
Role: PeopleSoft Upgrade Administrator
Responsibilities:
- I was responsible in the PeopleSoft HRMS Upgrade to 9.0 on PeopleTools 8.49 from HRMS 8.8 running on PeopleTools 8.46. Extensively performed the duties of a PS Admin for the Upgrade project.
- Installed a new Demo environment of HRMS 9.0, PeopleTools 8.49, Tuxedo 9.1, WebLogic 9.2 and related third party products.
- Created a Demo and Sys and the other databases using Data Mover in bootstrap mode.
- Configured the Application Server, Process Scheduler, WebLogic Server PIA for the new 9.0/8.49 release.
- Downloaded the Upgrade Documentation, Upgrade Scripts and Templates, Required for Upgrade patches/bundles and Tax Updates.
- Performed Upgrade Planning by applying the contents of UpgradePlanning.exe to the current old HRMS 8.8 codeline and database.
- Applied UPGCONVERT Project to the demo database immediately after installation and copied contents of required for Upgrade to into the new PeopleSoft release.
- Installed and Configured Change Assistant on the Upgrade Workstation and mapped corresponding Source and Target PS HOME file systems and databases.
- Created a Copy of Production database COP1 and performed first Initial Upgrade pass against this copy.
- Resolved and documented multiple issues related to data conversion and other performance problems in the first pass. The completion of which took close to 2 weeks.
- Involved in the application testing thoroughly enabling the developers and business analysts access the system.
- Created a Copy of Production database COP2 and performed Test Move to Production.
- Extensively worked with the technical team members, developers, technical and functional managers, permanent DBAs, UNIX Admin's, Network Engineers to resolve several issues.
- Made every effort to reduce the time taken for each subsequent test move to Production.
- After 4 successful test moves to production, the Final Move to Production was executed.
- Created all the PIA components and configured load balancing and failover for WebLogic Web Servers, Application Server/Tuxedo and Batch Servers.
- Configured LDAP Security Authentication for PeopleSoft 8.49.
- Reconfigured Integration Broker, single sign on and SSL for PeopleTools 8.49.
- Identified bottlenecks and took necessary measures for performance tuning the different layers involved in PeopleSoft pure Internet Architecture.
- Environment: HCM 8.8/9.0, Portal, EPM, Financials, People Tools 8.46/8.49 and UNIX.
Confidential
Role: PeopleSoft Infrastructure Administrator
- I was diligent in the Production Support of HRMS and Portal infrastructure. Extensively performed the duties of a PS Admin and a Migration Specialist for the maintenance and upgrade projects.
- Installed new Demo/Development/Test/UAT/Production environments of HRMS 8.8 SP1, PeopleTools 8.44, Tuxedo 6.5, WebLogic 6.1 and other third party products.
- Successfully upgraded the PeopleSoft application HRMS from 8.3 to 8.8 and tools from 8.13 to 8.44.
- Configured the Application Server, Process Scheduler, WebLogic Server PIA for the new 8.8/8.44 release.
- Performed Application Server, Tuxedo, Process Scheduler, WebLogic Server tuning for the optimal performance for all the HRMS environments.
- Installed and merged PeopleBooks for PeopleTools and Applications
- Installed and configured the Budgeting/BAM application in PeopleSoft EPM environment
- Installed BAM Software on Windows 2000 Server and configured multiple instances of IIS web server virtual directories for load balancing
- Responsible for performing all PeopleSoft and other third party product migrations using Quest STAT.
- Extensively used Quest STAT for managing PeopleSoft environments to be in Synchronization with the developed code.
- Monitored the Queues of other PeopleSoft Migrators and processed migrations efficiently when needed.
- Assisted with the patch application to the STAT tool.
- Ensured the smooth transition to the STAT product from the customary Application Designer and FTP, XCOPY processes.
- Attended Enterprise level Change Management meetings and coordinated with the PeopleSoft Infrastructure teams on upcoming events and prepared to accommodate them.
- Facilitated meetings in the absence of Management and ensured the project deadlines were on schedule.
- Worked on PeopleSoft Security - Created Permission Lists, Roles, User Profiles, and Process Groups and maintained them.
- Created all the PIA components and configured load balancing and failover for WebLogic Web Servers, Application Server/Tuxedo and Batch Servers.
- Configured LDAP Security Authentication for PeopleSoft 8.44.
- Upgraded EPM 8.8 to 8.8 SP1 using Upgrade Assistant
- Upgraded WebLogic Server 6.1 SP2 to SP4
- Created separate Integration Broker/App Messaging App Server domain
- Created Integration Broker Message Nodes for the Source and Target PeopleSoft Applications
- Configured IntergrationGateway.properties file to include the Node Names of the Default and Remote Nodes.
- Setup the Environment Variables and modified psconfig.sh and .profile in accordance with the environment
- Modified several parameters in the PIA configuration file configuration.properties
- Setup Report Repository, made recommendations as to how large the Report Repository should be, where it should reside and archival Purge procedures
- Monitored the Server and Client queue status at several tuxedo domains
- Setup trace logs at various levels like the Logfence parameter in Domain Setting Section in the APPSRV.CFG file, trace logs in Configuration Manager for SQL, Peoplecode, AE, etc and Enable Trace parameter in configuration.properties file on the Web Server
- Involved in setting up PeopleSoft Security as a part of Business Production Support
- Created multiple WebLogic Web Server instances for load balancing and fail over
- Created Data Mover Scripts DMS for Import and Export to Various Environments.
- Environment: HCM 8.3/8.8, Portal, EPM, Financials, People Tools 8.1x, 8.4x and Sun Solaris.
Confidential
Modules: PeopleSoft HRMS8.3, Portal, Financials 8.x
PeopleSoft Technical Consultant
Responsibilities:
- Created reports in Benefits based on the benefit vendor details. Created report for event rules for benefit plan types. Ran the Benefit Admin process for event change to test the reports.
- In Time and Labor created a rule to monitor incorrect payment of overtime when a full time employee has reported STD hours during the same week.
- Creating panels, records, menus, interface/conversion programs, and reports using People Tools, People Code, and SQR
- Interacting with users in meetings for fixing the bugs in different Financial Modules and case logs using People Code and SQRs while supporting the product
- Modifying and customizing delivered SQRs for interface reports in the Asset Management, Account Receivables, Order Management, and Billing modules
- Creating process definitions and attaching the custom/modified SQRs to the Process Scheduler to transfer the data
- Worked extensively with Benefit Administration process .Set up the Ben Programs and Plans.
- Performing migration of data using Import Manager from Legacy Systems to PeopleSoft Tables Performing customization of existing PeopleSoft Panels using People Code and People Tools
- The output from PS/Query can be got either in a list box form or it can to routed to Crystal Reports from where more comprehensive reports and charts can be generated
- Worked on HR, Benefits, Payroll and Time and Labor related processes and reports
- Gather the information from the users and analyzed the requirement. Involved in creation of Functional and Technical documents. Created flow charts and Technical design of the requirement.
- Wrote many Interfaces, Conversion programs for Data Migration.
- Created different types of SQR process and reports in Time and Labor. Which includes
- o Develop a report that can be run by Managers, Payroll and HR, which details vacation and personal time
- o An automated process created to be put in place for Non exempt employees only that will round up the fractional vacation end balances to a whole number once all of the grants have been given
- o Vacation rounding process and unused vacation report
- Created Run control pages and wrote the people code for validation.
- Converted the data from Legacy system and loaded into PeopleSoft system. Loaded the Time reported by employees and Employees personal information. Mapped the data with people soft tables. Used Component interface to load this data in to PeopleSoft tables.
- Created Component Interface API to integrate with Java Application used for self service application.
- Converted existing Application Engine program to SQR, because of performance issue.
- Created and tuned Application Engine programs and SQRs to improve the performance.
- Row Level Security is implemented using SQL Views to control the rows of data and Field Level Security has implemented using People Code.
- Created more than 150 queries to pull the information like Paycheck, Compensation, Job details, Benefits, Time and Attendance and other HR information to display on the Self-Service Portal Pages.
- Created SQRs to load the data into the Portal Staging tables used by Pages for security.
- Environment: People Tools, People Code, SQR, Application Engine, Data Mover, PS Query, Tree Manager, Oracle8i, PeopleTools, People Code, nVision, Crystal Reports, SQR, SQL, UNIX, Windows NT