Senior PeopleSoft Consultant

Production Support / Implementation / Database Administration / Application Upgrades / Security Design / Performance Tuning Troubleshooting PeopleSoft Servers

SUMMARY:

• Over 10 years experience in Information Technology.
• 9 years of extensive experience as a PeopleSoft Administrator and Database Administrator using HR and Financial portal modules which includes maintenance and upgrades of PeopleSoft
• Over 4 years of experience in Oracle Database Administration supporting various PeopleSoft Applications like HCM HRMS , Finance FSCM , CRM, EPM, Portal, Student Administration
• Multiple full PeopleSoft life cycle implementations. Expert with DB2,SQL Server, Oracle - 8i, 9i, 10g,11g with PeopleSoft 7.X, 8.X 9.X products
• Expertise in Installation Configuration of PeopleSoft applications
• Hands on experience with Upgrade assistant and change assistant for PeopleSoft upgrades.
• Involved in applying Tax Updates on PeopleSoft Financials
• Involved in Installation of Taxware on UNIX system.
• Involved in the tuning PeopleSoft environments
• Created and maintained the Oracle and SQL server databases.
• Managed database structures, storage allocation, tablespaces, tables/index segments, rollback segments, constraints, database access, and privileges.
• Handled the management of space and rollback segments.
• Maintained Database integrity and consistency primary key, foreign key constraints .
• Planned and monitored regular backups RMAN, expdp .
• Experience in Capacity Planning and proactively monitoring the alerts and determine future growth requirements like Database size, users to support the functionality of application.
• Involved with Database backup and recovery specifications, design and test.
• Contacting Oracle-PeopleSoft Corporation for technical support.
• Expertise in Database backups, recovery and refreshes and maintaining PeopleSoft environments
• 24/7 Production support experience and Onsite-Offshore support model
• Excellent oral and written communication skills.
• Hands on experience with Data Migration, Data Management Tools, Security Administrator and reporting tools.
• Hands on Experience on new PeopleSoft Technology like Integration Broker
• Excellent knowledge working with multiple operating systems
• ERP Tools: PeopleSoft7.X, 8.x, 9.X, People Tools 8.4.x, Weblogic, Websphere
• OS: HP-UX, Linux, AIX, Windows NT, Windows 2000, and SUN Solaris

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Administrator

Responsibilities:

• Involved in PeopleSoft Re-plat forming Project from Z-Linux to AIX.
• Involved in initial review of implementation of e-Recruit project.
• Performing Apps DBA role for the entire system. PeopleSoft installations, configuring process schedulers, Control M, monitoring and maintaining Hyperion system. Responsible for maintaining all PeopleSoft databases
• Job responsibilities includes, day-to-day migration, enhancement requests, process management, validating procedures and documenting, trouble shooting issues for DEV team and responsible for providing 24X7 coverage schedule between teams in India and US.
• Duties include installation and configuration of PeopleSoft applications, tuxedo WebLogic, day-to-day maintenance, support, project migrations, refresh of databases, applying patches, Bundles Maintenance Packs, configuration of Integration Broker, Batch Server and People Books.
• Developed standards for PeopleSoft installations, setting up PeopleSoft Ids, setting .profile and environment files for multiple PeopleSoft environment setups on same physical servers.
• Involvement in the application management includes - Applying Tax Updates. Installations PeopleSoft, Database Web servers Configuration Management Configuring Editing Application Servers, Process Scheduler Web Server.

Confidential

PeopleSoft Upgrade Specialist

Responsibilities:

• This project is PeopleSoft FSCM Upgrade from 8.9 to 9.1 including PeopleTools Upgrade from 8.48 to 8.51 with General Ledger, Payables and Asset Management modules.
• .Performing Apps DBA role for the entire Upgrade systems. PeopleSoft installations, configuring Application Servers, Process Schedulers, Control M System and setting up of clients PeopleSoft nVision and Crystal Reports 2008 for users.
• This Project also included applying of Required for Upgrade fixes and Bundles related to PeopleSoft 9.1
• Duties include installation and configuration of PeopleSoft application, tuxedo and WebLogic on Sun UNIX 5.1 with Sybase Database.

Confidential

PeopleSoft Administrator and Oracle DBA

Responsibilities:

• This project is of offshore support nature which involves Installation of New version of PeopleSoft, Application of Patches, Performing Refreshes, Creation of scheduled jobs, Monitoring services, processes.
• This Project also had HCM 9.1 upgrade feasibility assessment involved in installation, configuring and applying tools patches, compare reports from New Demo to Copy of Current production.
• Performing Apps DBA role for the entire system. PeopleSoft installations, configuring process schedulers, Control M, Cognos system and setting up remote client in offshore. Responsible for maintaining all PeopleSoft databases
• Job responsibilities includes, day-to-day migration, enhancement requests, process management, validating procedures and documenting, trouble shooting issues for DEV team and responsible for providing 24X7 coverage schedule between teams in India and US.
• Duties include installation and configuration of PeopleSoft applications, tuxedo WebLogic, day-to-day maintenance, support, project migrations, refresh of databases, applying patches, configuration of Integration Broker, Batch Server and PeopleBooks.
• Developed standards for PeopleSoft installations, setting up PeopleSoft Ids, setting .profile and environment files for multiple PeopleSoft environment setups on same physical servers.
• Involvement in the application management includes - Applying Tax Updates. Installations PeopleSoft, Database Web servers Configuration Management Configuring Editing Application Servers, Process Scheduler Web Server. Database Management Refresh, Backups Recovery.
• Involved in the tuning PeopleSoft environments Build Verification Test To check proper installation and running of all PeopleSoft components, processes reports.

Confidential

PeopleSoft Administrator and Oracle DBA

Responsibilities:

• Involved in PeopleSoft Conversion Project. This is a Database Conversion project from DB2 to Oracle 11g
• Performance Tuning for all PeopleSoft Systems on Oracle 11g database
• Database and environment refreshes and other regular Day to day DBA activities like proactively monitoring the alerts, Capacity Planning, determine future growth requirements like Database size, users to support the functionality of application.
• Troubleshooting and correcting both PeopleSoft infrastructure and application problems/errors.
• Involved in managing Finance, HRMS and Portal environments.
• Involved in setting up of New environments for conversion and PeopleTools and Application Upgrade FSCM 9.1 .
• Managing around 20 environments.
• Working on UAT and Integrations test cases.
• Creating DMS scripts and SQL's for conversion go-live.
• Configured Hermes JMS to test the messages between PeopleSoft and MQ Server.
• Involved in configuring Integration Broker using PIA .

Environment: AIX 5.3, DB type: DB2 and Oracle, PeopleSoft Application: HRMS 8.9,PeopleSoft FSCM 8.8/9.1 People Tools: 8.47.06/8.50

Confidential

PeopleSoft Consultant Administrator

Responsibilities:

• Involved in customization and configured PUNCHED TIME for PeopleSoft T L
• Involved in setting up of Work Rules and State Rules for validating Punch Time.
• Configured Hermes JMS to test the messages between PeopleSoft and MQ Server.
• Involved in configuring Integration Broker using PIA.
• Extensively worked on the Integration broker with people soft systems for the Inbound and outbound messages with Third party Systems
• Developed and configure the proof of concept for the Integration Broker for Inbound messages, out bound messages, web services and CI based web services with Third party systems.
• Participated in Integration Broker PeopleSoft Customer Connection cases.
• Configured the People soft Systems for Integration broker by setting up the nodes, services, service operations, Routings.
• Extensively used the send master tool in order to unit test with in people soft system.
• Involved in monitoring and trouble shooting issues with integration Broker.
• Developed and configured the Employee Interface for the Integration Broker.
• Configured on Load balancer PUB/SUB server for Production environment.
• Involved in debugging Integration broker Logs.
• Involved in preparing test cases, documenting/ analyzing test results of Unit testing, System Testing, Integration Testing and User Acceptance Testing, Issue Tracking and resolutions.
• Involved in the Setting up the Integration broker for the user profile sync.
• Involved in applying Maintenance Packs
• New environment setup and configuring DB and PS T L application for Development, Testing and Production environments

Environment: AIX 5.3, DB type: DB2, PeopleSoft Application: HRMS People Tools: 8.47.06, Hermes JMS

Confidential

Lead PeopleSoft Administrator

Responsibilities:

• This project is of offshore support nature which involves Installation of New version of PeopleSoft, Application of Patches, Doing Upgrades, Performing Refreshes, Creation of scheduled jobs, Monitoring services, processes.
• This Project has FSCM, HCM portal application upgrade. This project involved 3rd vendor for application upgrade, as a Application DBA Team lead coordinated with application upgrade project plan, day-to-day activities , setting up of new instances.
• Planned and implemented Daylight Saving changes for all PeopleSoft Application.
• Performed configuration, documentation, and testing of the warehouse processes. This included resolution of errors with PeopleSoft GSC and testing of associated application updates, or the development of relevant workarounds.
• Gain I3 knowledge for monitoring Databases and creating database alerts.
• Leading the Apps DBA team for the entire. PeopleSoft installations, configuring process schedulers, SQL client and setting up remote client in offshore. Responsible for maintaining PeopleTools upgrade project plan, setting up milestones, which includes capacity planning sizing of PeopleSoft databases
• Team lead for 5 PeopleSoft Administrators. Job responsibilities includes, day-to-day migration, enhancement requests, process management, validating procedures and documenting, trouble shooting issues for DEV team and responsible for providing 24X7 coverage schedule between teams in India and US.
• Responsible for installation, maintenance, upgrade of PeopleSoft systems for Portal. Duties include installation and configuration of PeopleSoft applications, tuxedo WebLogic, day-to-day maintenance, support, project migrations, refresh of databases, applying patches, configuration of Integration Broker, Batch Server and PeopleBooks.
• Developed standards for PeopleSoft installations, setting up PeopleSoft Ids, setting .profile and environment files for multiple PeopleSoft environment setups on same physical servers.
• Involvement in the application management includes - Applying Fixes, Updates and Upgrades. Installations PeopleSoft, Database Web servers Configuration Management Configuring Editing Application Servers, Process Scheduler Web Server. Database Management Refresh, Backups Recovery.
• Creating Alerts in VERITAS to monitor database.
• Involved in the tuning PeopleSoft environments Build Verification Test To check proper installation and running of all PeopleSoft components, processes reports.

Environment: PeopleSoft Portal, PT 8.4.X, PeopleSoft FSCM GL,AP,AR,BI,IN,PO , PeopleSoft HCM HR,Payroll Change Assistant , SQL Server 2005, WebLogic, IIS, Windows 2000/2003 servers

Confidential

Senior PeopleSoft Administrator with Oracle DBA

Responsibilities:

• Duties include project migration, bundles, custom SQRs migration, applying patches and trouble shooting the long run jobs for PeopleSoft modules.
• Work involves refresh of environments, auto exports of sysadm schema and automatic grants on sysadm objects for roles. Responsible for installation and maintenance of PeopleSoft/oracle instances. Installing client work stations, Handling all connection issues and providing solutions to onsite and offshore team.
• Fine tune the scripts for better performance. Performance tuning for the 8.8 environment, Prepared Performance Tuning Checklist
• Involved in testing of reports in both Test instance and System Test Instance, Supporting and assisting all PeopleSoft Quality Assurance and review procedures. Verification, Quality Analysis, Delivery and Documentation.
• Responsible for installation and maintenance of DMO, CNV, UAT, TST, and PRD environments for PeopleSoft FSCM which includes configuring and setting up application server, process scheduler and web server on Windows servers. Involved in go live schedule for production rollout.

Environment: PeopleSoft Financials 8.8 Implementation, PeopleSoft 8.4, Oracle 9i,Unix

Confidential

PeopleSoft Administrator/Analyst

Responsibilities:

• Requirements gathering, distribution of tasks.
• Field Mapping, identifying unused fields after discussions with client.
• Creating Views
• Involved in testing of reports in both Test instance and System Test Instance
• Involved in developing Adhoc Queries in EPM.
• Involved in User Training.
• Verification, Quality Analysis, Delivery and Documentation
• Involved as a Techno-Functional Team Lead

Environment: PeopleSoft HCM 8.8 SP1 , CRM 8.8 SP2 , EPM 8.8 SP2 People Tools 8.45 , Oracle 9i, UNIX.

Confidential

PeopleSoft Admin and Architect with Oracle DBA

Responsibilities:

• Involved in Database designing and Development.
• Involved in Creating new instances and environments.
• Migrated data from legacy systems to PeopleSoft System.
• Developed Table and Field Mapping documents after discussing with the client for various inputs.
• Understood the client's Legacy systems.
• Installation of ADP Taxware to integrate with PO
• Customized delivered pages and also developed new pages to meet the Business requirements.
• Used Application Engine programs and Interfaces for data migrations and real time processes.
• Build Verification Test To check proper installation and running of all PeopleSoft components, processes reports.
• involved in PeopleSoft CRM implementation as Technical Lead to provide effective and efficient solutions to the Business Processes analyzed, Development.
• Worked as Database and Data Migration Team Lead, the role involves multi skill in PeopleSoft Administration, Oracle DBA and UNIX to Maintain the PeopleSoft systems.

Environment: Windows 2000 Server, Oracle, PeopleSoft FSCM GL,AP,BI,IN,AR,PO CRM 8.8 FS,CC and People Tools 8.45, Application Designer, Process Scheduler, Data Mover, SQR

Confidential

Senior PeopleSoft Administrator with Oracle DBA

Responsibilities:

• Identifying and downloading specific PeopleSoft supplied patches to be implemented. Communicating which patches will be implemented to the appropriate project team members.
• Tracking the identified/downloaded patches via a TPR spreadsheet that assigns resources to implement the patch.
• Creating, initializing, and providing general maintenance of PeopleSoft databases identified in this document, or supporting and advising the appropriate team members for these activities.
• Reviewing all OMRs for completeness and appropriate approval.
• Performing all migration tasks associated with an OMR and signing off on the request as complete.
• Supporting and assisting all PeopleSoft Quality Assurance and review procedures.
• Supporting System Integration Testing and User Acceptance Testing

Environment: PeopleSoft Financials 8.8 Implementation, PeopleSoft 8.4, Oracle 9i,Unix

Confidential

PeopleSoft Technical Team Lead

Responsibilities:

Creating and modifying objects Modifying existing people code Writing people code for new objects and new validations. Developing SQR Creating Process Definition in Process Scheduler Manager Creating Menus to run SQR's from PeopleSoft Environment Testing Worked as Tech lead in the project which involves providing offshore support to Client Modified and created new pages and components as per the requirement, adding new validations and attaching process to process definition of Process Scheduler Manager and Creating menus to run those processes from People Soft environment

Confidential

PeopleSoft Technical Team Lead

Responsibilities:

Analyzing the Report Format and Functionality of the Report Verifying input parameters to the Report Changing the logic in the SQRs Developing SQR Creating Process Definition in Process Scheduler Manager Creating Menus to run SQR's from PeopleSoft Environment USi Inc., Ohio May 2003- August 2003

PeopleSoft Technical Team Lead

Responsibilities:

Customize the PeopleSoft delivered components Tables, Pages, Menus, SQR to meet the customer's requirement. People soft Audits Application Engineer, People Tools 7.x, 8.x, HRMS 8.xx. Enhancements to the custom developed objects as per the latest requirements. Developed new custom objects

Confidential

PeopleSoft Admin with Oracle DBA

Responsibilities:

Support around 30 PeopleSoft Clients at PeopleSoft eCenter Cardinal Health, City of El Paso, State Farm Insurance, Reliable Financials, Informatica, DHL Airways etc., Application Management Applying Fixes, Updates, Tax Updates and Upgrades. Installations PeopleSoft , Database Web servers Configuration Management Configuring Editing Application Servers, Process Scheduler Web Server. Database Management Refresh, Backups Recovery. Involved in the tuning PeopleSoft environments To check proper installation and running of all PeopleSoft, components, processes reports. Environment: PeopleSoft Fin , PeopleSoft HRMS, Oracle 9i,Unix