SUMMARY:

• Over 13 years of result oriented professional experience in Analysis, Design, Development, Implementation, Database Administration, Security Administration and Production Support.
• Over 9 years of experience as a PeopleSoft Application and Database Administrator supporting mainly PeopleSoft HCM, HRMS, CRM, FSCM, EPM applications on Oracle, SQL Server and DB2 databases.
• Performed 2 full life cycle implementations, transition from the legacy system to the PeopleSoft ERP System.
• Successfully performed 5 upgrades to PeopleSoft system version 7.0 to 7.5x and 7.5x to 8.x and 8.xx to 8.xx, and 8.xx to 9.0
• Worked on PeopleSoft 9.1 and 9.2 Applications.
• Design and Implementation of PeopleSoft Security Models and Security Administration.
• Performed numerous People Tools upgrades and installs, including Linux scripting (Automation); Oracle databases on Linux; PeopleSoft on Linux; Oracle management tools (GRID/OEM installation and configuration).
• PeopleSoft Server Administration - expertise in installation, configuration, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
• Experienced PeopleSoft Applications and Security Administrator including performance problems with SQR reports, App Engine, tuning SQL, index creation, migration, version control, change management, Roles and Permission Lists.
• On call/On Demand assistance and support 24/7 for PeopleSoft Applications, Production and other Databases onsite as well as remote engagements.
• Successfully installed and configured Web Logic Server, Application Server components and Database Servers on UNIX (HP, AIX, Solaris and Linux)/ NT operating systems
• Installed and configuration of PeopleSoft Change Assistant (Agents and HUB)
• Created multiple Server domains on separate host systems to access one database and applications, an effective strategy for performance and tuning.
• Extensive experience in refreshing development & QA from Production database, migrating changes to QA and Production, evaluating the required patches and applying them to the PeopleSoft system on a timely basis.
• Configuration and Administration of third party version control (Quest) STAT for PeopleSoft.
• Administration of Job scheduling tools such as AUTOSYS, TIVOLI, NSM.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++, Pro*C, Shell and AWK

RDBMS: Oracle 11g, 10g, 9i, 8i, MS SQL Server 2000, 2005, 2008 R2, DB2 (UDB), MS-Access

Operating Systems: MS-DOS, Solaris 2.X, AIX 4.X, 5.X, Linux 5.0, 6.0, HP Unix and MS Windows 2000, 2003, XP

ERP Applications: PeopleSoft HCM, HRMS, FMS, FSCM, EPM, CRM and Portal

Tools: Oracle Enterprise Manager (OEM), Toad & Server Manager, Recovery Manager (RMAN), Oracle Datagurad, Tivoli, VERITAS NetBackup, Autosys, Developer 2000 (Forms 6i, Reports 6i and Graphics 6i), Designer 1.3, Server Manager, SQL*Loader, Export/Import, Visual Basic, EJB, XML, HTML, JavaScript, Web Logic, Tuxedo, Change Assistant, PeopleSoft Performance Monitor

Reporting Tools: SQR, Crystal Reports, nVision Reports

Web Servers: BEA Web Logic, IBM Web Sphere

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

PeopleSoft Security Administrator

Responsibilities:

• Working as a PeopleSoft Security Administrator.
• Working with 7 different University of Texas Schools.
• Implementation of HCM 9.1 and FMS 9.1 and PeopleSoft Portal 9.1 on PT 8.53
• Support of PeopleSoft EPM 9.1 Application.
• Security Matrices and Design of Security models for shared environments.
• Creation of Permission Lists and Roles.
• Creating Excel to CIs to mass load users and permission lists.
• Migration of Content References from HCM and FMS to Portal
• Row Level Security configuration for HCM environments.
• Scripts for running User Preferences in the FMS environments.
• Time and Labor and Nvision Security Configuration.
• Work with the Reporting and OBIEE team.
• FMS Primary Permission List security.
• User Profile Sync between HCM, FMS and Portal environments.
• Working on Tabs and navigation collections in the Portal environments.

Environment: HCM 9.1 FMS 9.1 EPM 9.1, PeopleTools 8.53, Oracle 11g RAC, Linux 5.0 and Windows Server 2008 R2.

Confidential, Kearney, NE

PeopleSoft Administrator

Responsibilities:

• Worked as a lead PeopleSoft Administrator.
• Involved in Integration of FSCM 9.0 and CRM 9.0 for Customer relations.
• Involved in Successful implementation of multiple deployments in CRMS and FSCM.
• Involved in People Tools upgrade from 8.48 to 8.51.
• Worked on deployment of Order entry in People soft.
• Conversion of data related to customers from Legacy AS400 to PeopleSoft CRMS 9.0
• Pricing and Products conversion and loading in PeopleSoft.
• Daily monitoring the system using Oracle Enterprise Manager.
• Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing using App Designer and QUEST STAT.
• Configured Multiple Application Servers, Web Servers & Batch (Process Scheduler) Servers.
• Customer and Order Conversion between FSCM and CRMS applications.
• Intense work on PeopleSoft Integration Broker.
• Changing PUB/SUB configurations to accommodate high messaging volume.
• Configured and maintenance of PeopleSoft Configurator server.
• Worked with Foglight monitoring tool.
• Provided 24/7 support for all Call Centers.
• Troubleshooting and Worked on Helpdesk tickets on daily basis.
• Managing Roles and Permission Lists for all the developers and Call Center Agents.

Environment: CRMS 9.0, FSCM 9.0, PeopleTools 8.48/8.51, Oracle 10g RAC, Oracle 11g, Linux 5.0 and Windows Server 2003, 2008 R2.

Confidential - Columbus, OH

PeopleSoft Admin/ DBA

Responsibilities:

• Involved in the upgrade of PeopleSoft HRMS 8.3 to 8.9 to 9.0 and People Tools 8.42 to 8.48.
• Administration and maintenance of PeopleSoft Application servers, web servers.
• Supported EPM 8.9 and 9.0 instances and worked with the reporting team in building reports.
• Upgrading Oracle 9i to 10g.
• Applying tax updates using Change Assistant on a regular basis.
• Migration of PeopleSoft objects.
• Configured Single Sign-on and Load Balancing of application and web servers.
• PeopleSoft application and query security.
• Support of Training environments along with the DEV, TST and PRD instances.
• Integration Broker configuration and setup.
• PeopleSoft clone procedures implementation and documentation.

Environment: HRMS 8.3/8.9/9.0 EPM 8.9/9.0, PeopleTools 8.46/8.48, Oracle 10g, Windows 2003, HP UNIX, and Linux.

Confidential - Portland, OR

PeopleSoft Admin/ Security Admin

Responsibilities:

• Administration and maintenance of PeopleSoft FSCM 9.0.
• Installing PIA on windows 2003 server and Linux servers.
• Installing Integration Broker and configuring Gateways.
• Configuration of EM Hub and Agents for Change Assistant.
• Maintenance of Production environments and troubleshooting errors.
• Creation and configuration of 9.0 DEV, TST, CFG environments.
• Running Audit reports regularly.
• Security changes and change control.
• User Preferences and Primary Permission security.

Environment: FSCM 9.0, PeopleTools 8.47, and SQL Server 2005.

Confidential, Tampa, FL

PeopleSoft Admin/ DBA

Responsibilities:

• Involved in the Upgrade of PeopleSoft HRMS 8.8 to 9.0 and PeopleTools 8.46 to 8.48.
• Installed Tuxedo App Servers and Weblogic Web servers on UNIX and Windows servers.
• Production Support of PeopleSoft FMS 8.8.
• Created environments during different test moves.
• Was responsible for PeopleSoft Security in Production servers.
• Migration of PeopleSoft objects between PeopleSoft environments.
• Installation and configuration of PeopleSoft Change Assistant.
• Applying Patches, tax updates and bundles for PeopleSoft environments.
• Performance tuning long running processes.

Environment: FMS 8.8, HRMS 8.8/9.0, PeopleTools 8.48/8.46, Oracle 9i/10g, and AIX-UNIX.

Confidential - Coopersburg, PA

PeopleSoft DBA

Responsibilities:

• Installed and configured PeopleSoft HRMS 9.0 on SQL server 2005.
• Installed PeopleTools 8.49.
• Configured all three tiers App Server, Web Server and Database and optimized the parameters for performance.
• Created PS 9.0 DEMO, SYS and DEV databases.
• Installed PeopleSoft change assistant and configured the EM hub and Agents.
• Configured PeopleSoft Search, and verity collections using PSOL manager.
• Setting up Performance Monitoring in People Tools.
• Configuring application designer for different client machines.

Environment: HRMS 9.0, PeopleTools 8.49, SQL Server 2005, and Windows Server 2003.

Confidential - Richmond, VA

PeopleSoft DBA

Responsibilities:

• Installed Oracle Dataguard for the PeopleSoft CRM 8.4 and E-Commerce databases.
• Involved in the design and architecture of Standby databases.
• Configured App, Web and process scheduler servers for Standby operation.
• Testing PeopleSoft Application and Database Failover.
• Maintenance and administration of highly available database, application and web servers.
• Regular patching and maintenance.

Environment: CRM 8.4, PeopleTools 8.46, Oracle 9i, UNIX, and Linux.

Confidential - Seattle, WA

PeopleSoft Admin/DBA

Responsibilities:

• Involved in the Upgrade of PeopleSoft Application FSCM 7.5 to 8.8.
• Upgraded Oracle database from 8i to 10g.
• Upgraded Peopletools from 8.40 to 8.46.
• Configured all tiers of PIA including Appservers, Webservers, and Process Schedulers.
• Maintenance of appserver processes and webserver connections.
• Worked on UNIX shell scripting and created cronjobs.
• Analyze and tune SQLs from App Engine Programs.
• Worked as a Primary and secondary DBA and provided 24/7 on-call support.
• Regular PeopleSoft Project Migrations using App Designer as well as Quest STAT.
• Database Monitoring and backups using RMAN.
• Job scheduling using a third party tool NSM.
• Troubleshooting issues as they arise.

Environment: FSCM 7.5/8.8, People Tools 8.40/8.46, Oracle 8i/10g, UNIX, and MS Windows.

Confidential, fl

PeopleSoft Admin/DBA

Responsibilities:

• Managed and administered FSCM 8.8 HRMS 8.8/8.9 EPM 8.8 PeopleSoft applications and databases running on Oracle.
• Installed and configured 9i and 10g databases for PeopleSoft Applications on AIX.
• Upgraded People Tools from 8.40 to 8.46.
• Configured Tuxedo appservers, Weblogic webservers and process scheduler servers.
• Maintenance including database patching and patches and bundles for PeopleSoft application.
• Created startup and shutdown scripts for appserver and webserver domains.
• Installed Peoplebooks and configured Verity search.
• Monitored databases for performance using Oracle Enterprise Manager.
• Regular Audit report generation and clean up.
• Roles and Permission lists creation and maintenance of user security.
• Regular backups of databases and refreshes when needed.

Environment: FIN 8.8 HRMS 8.8/8.9 EPM 8.8, PeopleTools 8.40/8.46, Oracle 9i/10g, Windows Server, and UNIX.

Confidential - Richardson, TX

PeopleSoft Admin/DBA

Responsibilities:

• Involved in Upgrade of FSCM 8.4 to 8.8 applications on Oracle 9i database.
• Involved in People Tools upgrade from 8.42 to 8.44.
• Administered and maintained HRMS 8.3/8.8 CRM 8.8 Applications.
• Configured PIA including Tuxedo appservers, Weblogic webservers and process scheduler servers.
• Management, Maintenance and Administration of Oracle databases.
• Managed PeopleSoft Security including Roles and Permission Lists.
• Database Backup, refreshes and restores.
• Migration of PeopleSoft projects between DEV, TST, QA and PROD environments.
• Creation of scripts during the upgrade process as well as post refresh of database.
• Performance tuning application and database.
• Maintained PeopleSoft HRMS 8.0 and FSCM 8.0 applications on Oracle 8 database.
• Installation of People Tools 8.14 and later upgraded to 8.17.
• Daily Backups of different PeopleSoft environments like DEV, TST, QA, and Prod.
• User Security at database level as well as application level.
• Refresh Databases.
• Developed scripts for start and shutdown, data collection.
• Troubleshooting user and performance issues.

Environment: HRMS 8.0 FSCM 8.0, PeopleTools 8.14/8.17, Oracle 8, Sun Solaris 2.1, and Windows NT.