SUMMARY

• Over 8+ years of result oriented professional experience in PeopleSoft Analysis, Design, Development, Implementation, System and Database Administration and Production Support.
• Over 7+ years of experience as a PeopleSoft Application and Database Administrator supporting mainly PeopleSoft Financials, E Pro, Portal, CRM and HRMS applications running on Oracle, DB2, MS SQL Server databases
• PeopleSoft Server Administration - expertise in installation, configuration, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
• Experience in Installation of 3-tier and 2-tier components of the PeopleSoft
• Experience in PeopleSoft Integration Broker configurations and App Messaging.
• Upgraded the PeopleSoft Tools and Application (HRMS and Financials) using Upgrade Assistant and Change Assistant
• Configured PeopleSoft Update Manager
• Experience in maintaining the databases at high availability and failover point
• Created multiple Tuxedo and Web Logic PIA Server domains on separate host systems to access one database, an effective strategy for performance and tuning.
• Experience in Objects and data migration using Application Designer and Data Mover
• Worked with PeopleSoft Customer Connection to resolve the PeopleSoft issues
• Did applied Patches/Fixes/Updates/Tax Updates from the PeopleSoft Customer Connection to the PeopleSoft databases on timely basis
• Experience in Tuning Integration Broker
• Experience in LDAP (Lightweight Directory Access Protocol) and Active Directory.
• Performed full life cycle implementations, transition from the legacy system to the PeopleSoft ERP System.
• Experienced PeopleSoft Applications Administrator including performance problems with SQR reports, App Engine, migration and change management.
• Cloning using Hot Backup, Cold Backup, and RMAN Backup.
• Responsible for the support and maintenance of the multiple oracle databases.
• Exporting and Importing database backups using Exp & Imp and Datapump utilities.
• Ran AWR reports, STATSPACK reports.
• Knowledge on DATAGUARD and create and maintaining physical standby database.
• Excellent Communication and Interpersonal skills / Customer management skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP, 2000,2008,2012, NT Servers, UNIX (Sun Solaris, Linux, Redhat, HP, VM, AIX

Database: Oracle8/9/10g/11g/12c, DB2, SQL Server, Informix, Sybase

PeopleSoft Tools: Application Designer, Data Mover, Query, and Configuration Manager,ProcessMonitor, Integration Broker,ProcessScheduler, Report Manger, PeopleSoft Security, Upgrade Assistant, Change Assistant.

Application Server: Web Logic, Web sphere, Oracle

PeopleSoft HCM: Recruiting, TAM, Candidate Gateway, Payroll, HR, Benefits, and Time and Labor

PeopleSoft Fin/SCM: General Ledger, Account Receivables, Account Payables, Management, Purchasing, Inventory, Billing Asset Management

Utilities: Remote Desktop, PCAnywhere32 8.0, Terminal Server, Citrix MetaFrame, Putty, Cute FTP, WSFTP, TOAD, Win-SQL, winscp

People Tools: 8.19/8.20/8.40/8.41/8.42/8.46/8.47/8.48/8.49/8.50/8.51/8.52/8.53/8.54

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

PeopleSoft Administrator

Responsibilities:

• People Soft DBA for HRMS 9.2/PeopleTools 8.54 and Financials 9.1/PeopleTools 8.52
• Install, Configure, Upgrade and Production Support of PeopleSoft Databases
• Upgrading PeopleTools on Financials 9.1
• Configuration of Defining Integration Broker, Gateway creating and configuring nodes for HRMS and Finance Modules.
• Apply fixes, Updates and Patches for DEMO, DEV, TEST and PROD application
• Deleted old Change Assistant and installed new Change Assistant.
• Peoplesoft Data and object migrations using PHIRE tool.
• Ran scripts using Data Mover
• Creating User Profiles, Administering Users, People soft Access profiles
• Configuring different instances with different Application and Web Servers
• Involved in web server, Application Server configuration and set the parameters to get better performance in PSAPPSERV.CFG and configuraton.properties files
• Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance.
• Created multiple Web Logic Server instances.
• Installed and configured Oracle Database 11.2.0.4 on windows
• Created scripts to take RMAN full, incremental and cumulative backups for GRC databases on windows and linux
• Prepared recovery steps for Oracle databases
• Prepared and maintained documentation on applications and databases
• Cloning of 11.2.0.4 oracle database
• Configured Recovery Catalog on windows for oracle databases
• Worked on OEM
• Starting and stopping of weblogic

Environment: - HRMS 9.2/8.54, FSCM 9.1/8.52, SQL Server, Oracle, Windows 2012, RHEL 6.7

Confidential, Novi, MI

PeopleSoft Administrator

Responsibilities:

• People Soft DBA for HRMS /Financials 9.2, PeopleTools 8.54
• Setup PeopleSoft Application Servers and Process Schedulers.
• Extensively involved in Administering PSAdmin Tool and setting up and correcting the configuration settings of Tuxedo, Process Scheduler, Web Server and Jolt.
• Configuration of Defining Integration Broker, Gateway creating and configuring nodes for HRMS 9.2, 9.1, 8.3 to 8.9. And Finance Modules.
• Pay roll Administrator, Creating User Profiles, Administering Users, People soft Access profiles
• Creating Application Server Administrator, Creating profile Attributes, Roles, Process Scheduler Administrator Roles, options, Permission lists and combinations.
• Passwords Management, changing user passwords, locked account, unlocked account, Rest Admin Password, Purge Inactive User profiles.
• Identified, applied and tested patches/ bundles of PeopleSoft 9 SP1.
• Attending, analyzing and resolving the day today discrepancies which are routed from end users
• Upgraded PeopleSoft FSCM 9.0 to 9.2 and People Tools
• Installed PeopleSoft FSCM update image11 of 9.2 and People Tools 8.54
• Configured PeopleSoft Update Manager(PUM) and Change Assistant.
• Create and applied change package from PUM image 11 to FSCM 9.2 environments
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT,SYSAUDIT and Alter Audit, Apply Upgrade Options (UPGOPT) project, update statistics and freeze People Tools
• Download Template from Customer connection; create a job in Change Assistant.
• Ran Change Assistant steps for People Tools and HRMS Application upgrade.
• Applyfixes, Updates and Patches for DEMO, DEV, TEST and PROD application.
• Doing production support of integration broker for HRMS 9.2.
• PeopleSoft Data and Object migrations using STAT Tool.
• Prepared and maintained the documentation of all the installation and configurations of databases and applications
• Created Startup and Shutdown scripts for the Web Logic Web Server and Tuxedo Application Server and Process Scheduler Domains.
• Database Administration for Production, DEV, INT and Staging Environments
• Involved in increasing the performance for overall system with Database and application server tuning, SQL tuning
• Did analysis, trace and debug the process, which are running slow and took necessary action to get good performance
• Create, Alter the table spaces and maintained the space for large volume of data
• Configuring different instances with different Application and Web Servers
• Involved in web server, Application Server configuration and set the parameters to get better performance in PSAPPSERV.CFG and configuraton.properties files
• SQL and system monitoring and tuning.
• Monitoring/ Tuning various PeopleSoft processes for Application Engine, SQR Reports, SQL Queries etc.,
• Configured Oracle for PeopleSoft Application and configured client
• Executing PeopleSoft scripts and resolved the SQL Scripts
• Involved in Writing DMS Scripts Across DEMO and SYS Databases and wrote customized scripts for customized applications of HRMS and Financial modules

Environment: HRMS and FSCM,, Oracle, FSCM, PeopleTools 8.49, 8.52,8.54

Confidential, Omaha, NE

Sr. PeopleSoft Admin/DBA

Responsibilities:

• Install, Configure, Upgrade and Production Support of PeopleSoft Databases
• UpgradePeopleSoft - People Tools and Application (HRMS, Financials, CRM and EPM)
• Download Template from Customer Connection, Create a Job in Change Assistant
• Ran Change Assistant Steps for Tools and Application Upgrade
• Ran Compare reports and take over the customization functionality for Upgrade
• Resolve upgrade issues of Business Process and applications
• Applyfixes, Updates and Patches for Demo, Dev, Test and Production Application
• Take care of the Migration of data and PeopleSoft objects.
• Install Change Assistant and involved in creating copy of Production for Initial Pass and Move to Production for the Upgrade Process.
• Compile COBOL files and migration of SQR, NVision, Crystal files and retain the customization by compare new and old version files.
• Involved in complete Upgrade (Initial and Move to Production) of the HRMS
• Downloaded the template and required files for HRMS 8.9 Upgrade from PeopleSoft customer connection.
• Created Databases DEMO, DEV, TEST and CONFIG databases on UNIX.
• Installed PeopleSoft applications - People Tools 8.49, Application (HCM 8.8 and Financials 8.8, CRM8.9), Tuxedo 8.1, WebLogic 9.1 and Microfocus COBOL.
• Created Application Server Domains and Process Scheduler Domains.
• Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST CONFIG, STG and PROD databases.
• Install and Configure Oracle Client and configure TNS files to get two-tier access to Developers and Users.
• Involved in the Performance of the databases and application by creating multiple domains across the instances.
• Download Updates and Fixes and apply to the environments and maintain the customizations for the PeopleSoft.
• Prepared and maintained the documentation of all the installation and configurations of databases and applications.
• Involved in Knowledge transfer and for the users.
• Configuration of Integration Broker, defining Gateway, creating and configuring Nodes for HR and Finance.
• Migration of Internal and External Objects of PeopleSoft (Projects, SQR, NVision, Crystal and Cobol files).
• Installed Upgrade Assistant and Change Assistant.
• Prepared and maintained the documentation of all the installation, configurations, Upgrade and Performance tuning of databases and applications.
• Install People Books for HRMS, Financials, CRM.

Environment: People Tools 8.49 in a UNIX environment with an Oracle database.

Confidential, Albuquerque, NM

PeopleSoft Administrator/DBA

Responsibilities:

• Infrastructure design and maintaining the environments of PeopleSoft for DEMO, DEV, TEST, CONVERSION and Production Databases.
• Experienced in the full life cycle Implementation and Production Support of PeopleSoft Applications & Databases.
• Installed PeopleSoft Database and Applications on NT and Unix Operating Systems.
• Installed and configured MS-SQL Server.
• Updated databases by applying Updates/Fixes/Patches after backup on timely basis and kept the record of the updates/fixes/Patches.
• Configured Application Server, Web Server & Batch (Process Scheduler) Server.
• Configured Windows development clients to connect 2-tier or 3-tier to the database for development and administration purposes.
• Installed BEA Tuxedo App Server, Web Logic WebServer with database Oracle and created PeopleSoft DEMO and System Databases and Applied related Database patches and application Patches.
• Configured Tuxedo services for windows and UNIX operating systems.
• Extensively used PSADMIN utility to Administer, Create & Delete Application Server and Process Scheduler Server.
• Monitored the Server and Client queue status at several tuxedo domains.
• Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service.
• Changed the PSAPPSRV.CFG/PSPRCS.CFG configuration file for performance and tuning to specific environment.
• Checked and cleared the application server cache on a regular basis as a maintenance process.
• Setup trace logs at various levels like the Log fence parameter in Domain Setting Section in the APPSRV.CFG file, trace logs in Configuration Manager for SQL, People Code, AE, etc and Enable Trace parameter psappserv.cfg and psprcs.cfg files in application server and Process Scheduler.
• Created Startup and Shutdown scripts for the Web Logic Web Server and Tuxedo Application Server and Process Scheduler Domains.
• Created multiple Web Logic Server instances.
• Wrote scripts to Create table, Views, Index for a Table, Export Scripts and Import Scripts for backup and Refresh.
• Installed People Books and configured the Web Server to access People Books.
• Identified the team roles and responsibilities for the technical upgrade process.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options (UPGOPT) project, update statistics and freeze People Tools.
• Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing.

Environment: PeopleSoft Financials 8.9, HRMS 8.9, People Tools 8.4, Web logic 8.1, Tuxedo, Windows 2003, Oracle 9i.

Confidential, Mettawa, IL

PeopleSoft ADMIN / DBA / Consultant

Responsibilities:

• Worked on Deployment and full lifecycle Development of PeopleSoft Application.
• Conducted meetings with users, technical / functional team and managers for generating specifications to accommodate client needs and establish standards.
• Provided a consistent user interface through simple and menu style navigation.
• Developed Self-service functions and Integrating to PeopleSoft HRMS and E Pro.
• Database Administration for Production, DEV, INT and Staging Environments.
• Check the status of the process - Kill, Restart, re-runs the process.
• Increased the performance for overall system with Database, application and server tuning.
• Did analysis, trace and debug the process, which are running slow and took necessary action to get good performance.
• Create, Alter the table spaces and maintained the space for large volume of data.
• Configuring different instances with different Application and Web Servers.
• Worked on web server, Application Server configuration and set the parameters to get better performance in PSAPPSERV.CFG and configuraton.properties files.
• Monitoring/ Tuning various PeopleSoft processes for Application Engine, SQR Reports, SQL Queries etc.
• Creating table spaces, tables/index, views plans and packages.
• Configured Oracle for PeopleSoft Application and configured client.
• Executing PeopleSoft scripts and resolved the SQL Scripts.
• Running REORGS weekly as well as on request, Daily image copies.
• Worked on Resolving space related issues, Resolving security and authorization issues, Data Migration, DASD reclamation, Applications support.
• Worked on Writing DMS Scriptsacross DMO and SYS Databases and wrote customized scripts for customized applications of HRMS and E Pro.
• Providing user group Employees with a user Friendly User Interface to PeopleSoft Applications.
• Installed the Enterprise Portal, Content Provider Portal Pack Projects for PeopleSoft Applications Integrating from Various Sources and making PeopleSoft Pages easily accessible for users from single Source.
• Developing Customized reports for the integration of PeopleSoft HRMS and E Pro Repositories.
• Implementation of HR Workflow and developing applications for Requests and Approvals up to 5 levels.
• Running PeopleSoft Delivered DMS Scripts for the implementation of PeopleSoft (Web, Database, App Server) and Solutions.

Environment: PeopleSoft Financials 8, HRMS 8.8, People Tools 8.4, Web logic 6.1, Tuxedo 6.5, Windows 2000, SQL Server 2000, Oracle 8i.

Confidential

PeopleSoft Programmer Analyst

Responsibilities:

• Developed, implemented and provided analysis on a number of various PeopleSoft Applications. Other highlights include.
• Participated in successful upgrade from PeopleSoft HRMS 8.3 to 8.8
• Aided in the installation and configuration of the new PeopleSoft 8 environment.
• Developed and coded PeopleSoft 8 upgrade solution for required HR applications utilizing PeopleCode, HTML, SQR, and application engine, PeopleTools, SQL, Weblogic and Query.
• Manage PeopleSoft project, sqr/sqc and COBOL migration from development to production.
• Responsible for assisting in the creating of technical FIT/GAP analysis document.
• Installed Oracle software and created DB on windows environment.
• Experience in MS SQL Server Installation, Configuration PeopleSoft Database.
• Upgrade with existing functionality and enhancement around process.
• Comparing tables with PeopleSoft Tables.
• Identify changed/new fields.
• Created On-line report for Time Labor, e-Recruitment.
• Modified SQR programs as per requirements.
• Listing newly added tables-functionality enhancement.
• Analyze the new fields on insert/update.

Environment: PeopleSoft Financials 8, HRMS 8.3/8.8, People Tools 8.16/8.17/8.4 , People Code, SQR, Web logic 6.1, Tuxedo 6.5, Windows 2000, SQL Server 7.0, Oracle 8i.