SUMMARY

• TEMPHas over 12 years of IT experience, of which includes 10+ years in PeopleSoft/Database Administration, Designing and Development of Software in Client/Server environment, Full Life - cycle Implementation, Upgrades and Production Support.
• TEMPHas over 7 years of DBA experience in Oracle and SQL Server.
• TEMPHas worked on PeopleSoft Applications like FINANCIALS (FSCM), HRMS/HRIS (HCM), Portal (EP), CRM, EPM and Student Administration and Campus Solutions (SACS).
• TEMPHas installed, configured and setup PeopleSoft HR/FS/EP/CRM 9.1 on peopletools 8.51.11.
• Hands on experience wif HCM Upgrade from 8.9MP1/PT 8.47 - 9.1/PT8.51.11.
• Is motivated, detail-oriented, and articulate professional wif expertise in ERP side of PeopleSoft Application, PeopleSoft Tools and TEMPhas sound noledge in configuration and installation of PeopleSoft, related applications and is an Oracle certified professional.
• Proven record of design, implementation, installation, migration, upgrade and support of database designs, Peoplesoft/Oracle server Installations and migrations.
• Expertise in Peopletools/Application and Maintenance pack upgrades
• Worked extensively wif Oracle Enterprise Manager 10G/9.x
• Setup Peoplesoft Enterprise Portal 9.x
• Performing Oracle/SQL Server DB refreshes
• BMC Patrol for production Database monitoring.
• Proactively monitoring teh alerts, Capacity Planning, determine future growth requirements
• Peoplesoft Application Tuning and troubleshooting
• Design and test Database backup and recovery specifications
• Setup Active Directory (LDAP)
• Setup Integration Broker
• Setup PeopleSoft Security
• Worked on third party tools like BEA Tuxedo, Web logic, WebSphere, Crystal and COBOL compilers.
• Configuring Renserver/Forgot password and context sensitive peoplebooks help.
• Knowledge of Ascential DataStage Administration for EPM and Finance environments, DataStage project builds and Migrations.
• Installing User Productivity Kit for HRMS 8.9 and publishing teh content into UPK Developer

TECHNICAL SKILLS:

Products/Languages: Peoplesoft Applications (7.5x to 9.1), Oracle 11G/10G/9i Application Server, PL/SQL, SQL*Plus, Developer 2000, SQL, C, C++, SQR, Java, UNIX Shell Scripting.

Databases: ORACLE 11G/10G/9i, SQL SERVER 2000, 2005, IBM DB2

DBA /Tools: Oracle Enterprise Manager, Oracle Applications Manager, RMAN, Toad, QL Backtrack, Shareplex

Operating Systems: Sun Solaris 2.x, HP-UX 11.x/10.2, Red Hat Linux Advanced Server 3.0/4.0/5.3, SUSE Linux SLES9, IBM AIX 5L, Windows 2000/2003/2008/NT 4.0

Hardware: Sun Sparc E4500, HP 9000, IBM RS6000, IBM eServer (P5 590/595/575), Compaq Proliant 3000, Dell Power Edge 4200/6200, EMC, IBM Tivoli Storage Management, Storage Area Networks, Veritas Cluster.

PROFESSIONAL EXPERIENCE:

Confidential, AZ

DBA/Sr. PeopleSoft System Administrator

Responsibilities:

• Installation of Demo databases for PeopleSoft CRM 9.1/Peopletools 8.51.10 and HRMS 9.1/Peopletools 8.50.25 on Linux 5.3-64 bit.
• Installed WebSphere 7.0.0.0 and applied fix pack 23 to WAS.
• Configuring Application Servers, Process Scheduler, Web Server and troubleshooting issues related to various PeopleSoft components
• Applied patches and fixes for tools, application and other 3rd party vendors like tuxedo, weblogic, jrockit.
• Applied Maintenance packs to CRM 9.1 MP2 and HRMS9.1 MP5
• Setup Integration Broker between HCM and FSCM
• Configured HR Helpdesk 360 view.
• Setup Active Directory for single signon.
• Production support of Amex HR, Time and Labor and CRM systems.
• Installed new demo for Peopletools 8.52.

Environment: Linux 5.3 64bit, Windows server 2008/R2, Oracle 11.1.0.7, PeopleTools 8.51.10, Tuxedo 10gR3, WebSphere 7.0.0.23

PeopleTools: Change Assistant, Application Designer, Integration Broker, PeopleSoft Security, Portal, Utilities, Data Mover, Process Scheduler.

Confidential, DC

DBA/Sr. PeopleSoft System Administrator

Responsibilities:

• Supported reimplementation of Brookings PeopleSoft HCM and Finance Production Application and Databases
• Designed Project and Execution plan for all PeopleSoft systems migration from Windows 2003 to Windows 2008/R2
• Designed, Developed and executed Disaster Recovery for our Production Servers
• Backup and restore techniques and Database cloning.
• Monitored user accounts and user permissions, groups etc.
• Involved in configuring Application Servers, Process Scheduler, Web Server and troubleshooting issues related to various PeopleSoft components
• Setup Active Directory for single signon
• Applied patches and fixes for tools, application and other 3rd party vendors like tuxedo, weblogic, jrockit, nVisions, Crystals etc
• Applied Maintenance Packs up to date for FSCM 9.0 and HCM 9.0
• Setup external webservers for Recruiting (Candidate Gateway) and Self Service
• Setup Menu Integration gateway in Help for Peoplebooks and UPK 3.5.1
• Configuring load balanced Web and Application server environments wif failover capability
• Performed 8.49.30 tools upgrade
• Compiling COBOL’s
• Performance tuning for all PeopleSoft systems on SQLServer 2005 platform
• Performance tuning for App, web and process schedulers
• Setup Integration Broker between HCM and FSCM
• Shrinking DBA log files when necessary.

Environment: Windows Server 2003/R2, Windows server 2008/R2, SQL Server 2005, PeopleTools 8.49.30, Tuxedo 9.1, Weblogic 9.2 MP3

PeopleTools: Change Assistant, Integration Broker, PeopleSoft Security, Portal, Utilities, Data Mover, Process Scheduler, Application Designer, Tree Manager.

Confidential, NJ

Lead Oracle DBA/ PeopleSoft Administrator

Responsibilities:

• Lead for Client facing DBA's supporting PeopleSoft HCM, Portal, EPM, CRM Production databases and other Oracle databases that are owned and managed by Confidential Research Laboratories and Confidential Manufacture divisions implemented on various applications.
• Designed Project and Execution plan for all PeopleSoft systems migration from HP-PARISC 11.11 to HP-Itanium 11.31
• Involved in configuring Application Servers, Process Scheduler, Web Server and troubleshooting issues related to various PeopleSoft components
• Configuring load balanced Web and Application server environments wif failover capability
• Scripted and automated conversion tools for faster conversion.
• Performed 8.46.04 to 8.49.15 tools upgrade for CMR 8.9
• Installed Maintenance packs for CRM helpdesk 8.9 from MP7-MP14.
• Performed tax-updates to HCM 8.9
• Compiling COBOL’s.
• Performed production support for all PeopleSoft environments on HP-Itanium 11.31
• Performed production support for all Database environments on HP-PARISc 11.11 and HP-Itanium 11.31.
• Performance tuning for all PeopleSoft systems on Oracle 10g platform
• Performance tuning for App, web and process schedulers for all PeopleSoft systems
• Setup HR-helpdesk 360 degree view integrated wif CRM application.
• Setup Integration Broker across all teh PeopleSoft systems between HCM, Portal, and CRM.
• Setup of Verity Search server for CRM applications.
• Performed as Senior DBA for all systems and applications
• Involved in database upgrade from Oracle 9.2.0.7 to Oracle 10.2.0.4 for all teh PeopleSoft databases (HCM 8.9, CRM 8.9, Portal 8.9, EPM 8.9)
• All Oracle DBA activities including troubleshooting, performance Tuning.
• Responsible for creation of Physical and Logical Structures.
• Unix Shell Scripts/ Batch Commands for housekeeping

Environment: Windows Server 2003, HP-PARISc 11.11, HP-Itanium 11.31, HP Open View, Oracle 9i/10g, Oracle Enterprise Manager 10g, PeopleTools (8.46.04/8.48.07/8.49.15), Tuxedo 9.1, Weblogic 9.2 MP3

PeopleTools: Change Assistant, Integration Broker, PeopleSoft Security, Portal, Utilities, Data Mover, Process Scheduler, Application Designer, Tree Manager.

Confidential, Delray Beach, FL

PeopleSoft Security Administrator

Responsibilities:

• Maintained PeopleSoft Security like Creating roles, Dynamic roles, Profiles, Users and managing permissions, Active Directory, Single Signon.
• Maintained Row-Level, Data permissions using Query tree and Query Access Managers.
• Managed departments to teh Security tree and also assigning them to teh Row Security Permission lists based on teh SetID’s.
• Assigning teh tables to teh Query Tree.
• Maintained page level permissions for roles that are based on teh components which are attached to teh respective Menus.
• Creating Group ID’s and setting up security by group.
• Refresh teh transaction records on Nightly basis using SJT refresh process.
• Ensuring all teh development, test, and production environments are correctly configured and available.
• Troubleshooting and correcting both PeopleSoft infrastructure and application problems/errors.
• Demonstrated ability to perform complex database and system analysis, design, development, testing, implementation, documentation and problem solving of web based and client server applications and associated technology components.
• Interacting TEMPeffectively wif customers, developers, and peers ensuring teh successful delivery and implementing PeopleSoft updates and modifications into teh production environment.
• Working wif Functional Users, End Users, Integration Testers, Acceptance Testers, Technical Leads and Projects Managers in teh day to day activities.
• Demonstrated extensive ability in managing time and work wif others to accomplish competing priorities.

Environment: Windows Server 2003, PeopleSoft Application (8.9), PeopleTools (8.47.05)

PeopleTools: PeopleSoft Security, Portal, Query Manager, Tree Manager, Data Mover, Process Scheduler,Application Designer, Integration Broker, Renserver, Utilities, Application Engine.

Confidential, Warrenville, IL

Senior Oracle/PeopleSoft Administrator

Responsibilities:

• Involved in configuring Application Servers, Process Scheduler, Web Server and troubleshooting issues related to various PeopleSoft components
• PeopleSoft application patching Bundles/fixes, TaxUpdates using Change Assistant
• Migrated day-to-day projects migrations from development to test and to production environments.
• Experience wif setup and maintain proper function of PIA, Tuxedo, WebSphere
• Setup and Maintenance of Single Signon
• Working noledge of HTTPD servers.
• Configuring IBM WebSphere server
• Setup for PS Integration Broker
• Configuring load balanced Web and Application server environments wif failover capability
• Make use of UNIX Shell Scripting for automation
• Knowledge of performance and stress testing
• Knowledge of Ascential DataStage Administration for EPM and Finance environments.
• DataStage project builds and Migrations and table loads for PeopleSoft.
• Installing User Productivity Kit for HRMS 8.9 and publishing teh content into UPK Developer
• Coordinated wif PeopleSoft in researching issues and their resolutions.
• Updated documentation for all processes & methodologies.
• Has positive working relationships and a strong rapport wif team members during Onsite/Offshore co-ordinations and as an Individual.

Environment: Windows Server 2003, HP-UX B.11.11, Oracle 9i/10g, PeopleSoft Application (8.9), PeopleTools (8.47.12/8.49.05), Tuxedo 9.1, WebSphere 6.1.1.12, Ascential DataStage 7.5, HRMS UPK 8.9

PeopleTools: Data Mover, Process Scheduler, Application Designer, Change Assistant, Integration Broker, Renserver, Utilities, Application Engine.

Confidential, Lexington, KY

Lead Oracle/PeopleSoft System Administrator

Responsibilities:

• Leading teh System Administrator activities required for PeopleSoft Upgrade.
• Gatheird requirements for hardware and software compatibility for teh releases.
• Installed, configured & supported Oracle, PeopleSoft Application Servers, Process Schedulers, Tuxedo, Web Servers, Integration Broker nodes (Internal and External) and Cobol Compilers.
• Configured Change Assistant.
• Execute and manage all technical upgrade tasks using Change Assistant.
• Downloaded all teh necessary Patch Applications required for Upgrade and applying them.
• Applied Tax updates from 05B to 07D.
• Applied Upgrade bundles.
• Performed PeopleTools Upgrade.
• Participated in teh compare report analysis.
• Performed Application Upgrade.
• Interact wif teh Lexmark Users to gather requirements and analyze and design customizations to teh delivered applications.
• Logged all technical issues.
• Created SQL scripts to resolve teh technical issues faced during initial and MTP passes in teh Upgrade.
• Reported completed tasks, issues, and risks to teh Change Assistant
• Performed debugging on application and processes
• Created projects to migrate customized objects.
• Knowledge of STAT for migrating PeopleSoft objects across all environments.
• Migrated Custom configuration setup and security setup from one environment to other
• Data migration from their DB2 database to Oracle database using PeopleSoft datamover and hence got little exposure to DB2 database.
• Migrated teh tested system to stage environment for User Acceptance testing
• Coordinated wif PeopleSoft GSC in researching issues and their resolutions.

Environment: Windows Server 2003, Sun Solaris 5.10, IBM-AIX, DB2, Oracle 9.2.0.7, Toad, PeopleSoft HRMSApplication (8.3/9.0), PeopleTools (8.20.01/8.49.05), JRE 1.5.0, Tuxedo 9.1, Weblogic 9.2, MicrofocusCOBOL 4.0 SP2, STAT.

PeopleTools: Data Mover, Process Scheduler, Application Designer, Change Assistant, Integration BrokerInternational Truck and

Confidential, Warrenville, IL

Senior Oracle/PeopleSoft Administrator

Responsibilities:

• Involved in configuring Application Servers, Process Scheduler, Web Server and troubleshooting issues related to various PeopleSoft components
• PeopleSoft application patching Bundles/fixes, TaxUpdates using Change Assistant
• Migrated day-to-day projects migrations from development to test and to production environments.
• Experience wif setup and maintain proper function of PIA, Tuxedo, WebSphere
• Setup and Maintenance of Single Signon
• Working noledge of HTTPD servers.
• Configuring IBM WebSphere server
• Setup for PS Integration Broker
• Configuring load balanced Web and Application server environments wif failover capability
• Make use of UNIX Shell Scripting for automation
• Knowledge of performance and stress testing
• Knowledge of Ascential DataStage Administration for EPM and Finance environments.
• DataStage project builds and Migrations and table loads for PeopleSoft.
• Installing User Productivity Kit for HRMS 8.9 and publishing teh content into UPK Developer
• Coordinated wif PeopleSoft in researching issues and their resolutions.
• Updated documentation for all processes & methodologies.
• Has positive working relationships and a strong rapport wif team members during Onsite/Offshore co-ordinations and as an Individual.

Environment: Windows Server 2003, HP-UX B.11.11, Oracle 9i/10g, PeopleSoft Application (8.9), PeopleTools (8.47.12/8.49.05), Tuxedo 9.1, WebSphere 6.1.1.12, Ascential DataStage 7.5, HRMS UPK 8.9

PeopleTools: Data Mover, Process Scheduler, Application Designer, Change Assistant, Integration Broker, Renserver, Utilities, Application Engine.

Confidential, Raleigh, NC

Oracle DBA / PeopleSoft Upgrade SpecialistHRMS Upgrade 8.3 - 8.9 MP1

Responsibilities:

• Installed, configured & supported Oracle, PeopleSoft Application Servers, Process Schedulers and Web Servers.
• Planned and monitored regular backups (Export, Cold and Hot backup).
• Handled teh management of space and rollback segments.
• Involved in SQL tuning and troubleshoot other performance related issues.
• Execute and manage all technical upgrade tasks using Change Assistant.
• Configured Change Assistant
• Downloaded all teh necessary Patch Applications required for Upgrade and applying them.
• Applied Tax updates from 05B to 06B.
• Applied Upgrade bundles (1 through 7).
• Performed PeopleTools Upgrade.
• Participated in teh compare report analysis.
• Performed Application Upgrade
• Performed Database refreshes.
• Maintained PeopleSoft Security like creating roles, profiles, users and managing permissions, Active Directory, Single Signon and Maintaining teh Data permissions using Rowlevel Security.
• Logged all technical issues
• Reported completed tasks, issues, and risks to teh Change Assistant
• Performed debugging on application and processes
• Created projects to migrate customized objects.
• Migrated teh tested system to stage environment for User Acceptance testing
• Coordinated wif PeopleSoft GSC in researching issues and their resolutions.

Environment: Windows 2003, Red Hat Linux Advanced Server 2.1/3.2, Oracle 9i/10g, PeopleSoft Application (8.3 - 8.9), PeopleTools (8.18 - 8.47.06), Tuxedo 9.1PeopleTools: Data Mover, Process Scheduler, Maintain Security/ Security Administration, Application Designer, Change Assistant, Utilities, Application Engine.Teh project involved in PeopleSoft HRMS Upgrade from their Current Application Version 8.3 - 8.9MP1 and Tools 8.18 - 8.47.06

Confidential, MD

PeopleSoft Administrator/Upgrade Specialist and Oracle/SQL Server DBA

Responsibilities:

• Handled Major Upgrade from Financials (FSCM) 7.5 to 8.4SP1 and 8.4x to 8.9 wif Peopletools 8.1x to 8.46
• Installed, configured & supported Oracle, PeopleSoft Application Servers, Process Schedulers and Web Servers.
• Planned and monitored regular backups (Export, Cold and Hot backup).
• Involved in SQL tuning and troubleshoot other performance related issues.
• Execute and manage all technical upgrade tasks using Change Assistant.
• Reported completed tasks, issues, and risks to teh Change Assistant
• Performed debugging on application and processes
• Created projects to migrate customized objects.
• Migrated teh tested system to stage environment for User Acceptance testing
• Coordinated wif PeopleSoft GSC in researching issues and their resolutions.
• Handled Major upgrades from HRMS (HCM) 7.5x, 8.1 xs and 8.3 xs to 8.8x and 8.9 and Tools 8.44.06 to 8.46.02. This TEMPhas given exposure to all teh newest version tools related to PeopleSoft.
• Implemented new PeopleSoft environments and created a similar copy of teh installations that are already present.
• Customized teh PeopleSoft delivered components. (PeopleSoft Objects, People code, SQR).
• Involved in configuring Application Servers, Process Scheduler, Web Server and Application Messaging Gateways, troubleshooting issues related to various PeopleSoft components.
• Handled Tax updates from 02A to 06B.
• Applied fixes and patches, unit tested them and assisted in their migration to teh development & test environment.
• Installed, configured & supported PeopleSoft Application Servers, Process Schedulers and Web Servers.
• Configured and managed PeopleSoft Internet Architecture.
• Maintained PeopleSoft Security like creating roles, profiles, users and managing permissions, Active Directory, Single Signon and Maintaining teh Data permissions using Rowlevel Security.
• Migrated day-to-day projects migrations from development to test and to production environments.
• Performed Database refreshes.
• Installed PeopleTools client, Crystal, and Oracle clients on developers work stations.
• Refreshed development and test environments wif Production.
• Setup logs/traces as and when required.
• Executed scripts daily to restore backup from production database to production copy database.
• Installed and configured Oracle instance/database and application.
• Tuned Application Servers, Web Servers for performance improvements.
• Retained customizations as an integral part of upgrades.
• Provided Production support 24x7 as PeopleSoft Admin/DBA.
• Handled teh management of space and rollback segments.
• Planned and monitored regular backups (Export, Cold and Hot backup).

Environment: PeopleSoft Financials (FSCM) 8.4x/8.9, HRMS (HCM) 8.1/8.3/8.9, Windows NT/2000/2003/XP, Sun Solaris, HP-UX B.11.00,, Tuxedo 8.1, Red Hat Linux Advanced Server 2.1/3.2, Oracle 8/8i/9i/10g, MS- SQL Server 7.0, PeopleTools (7.5x, 8.1x to 8.47)

PeopleTools: Data Mover, Process Scheduler, Maintain Security/ Security Administration, Application Designer, Upgrade Assistant, Change Assistant, Utilities, Application Engine.

Confidential, Princeton, New Jersey

PeopleSoft DBA and Upgrade Specialist

Responsibilities:

• Handled Application Management tasks like Applying Patches & Fixes, Tools Upgrades, Application Upgrades and Service Pack Upgrades.
• Involved in Configuring Application Servers, Process Scheduler, Web Server and Application Messaging Gateways, troubleshooting issues related to various PeopleSoft components.
• Performed Database Refreshes, Imports, Exports and Backups.
• Handled Security Management tasks like creating new user profiles, roles, permission lists and granting privileges.
• Customized teh PeopleSoft delivered components (PeopleSoft Objects, People code, SQR)
• Prepared Research and Analysis documents (Objective, Process, Assumptions and Labor Time).
• Handled troubleshooting various issues related to PeopleSoft components.
• Participated in review meetings and to compare report analysis.
• Executed and managed all technical upgrade tasks using Upgrade Assistant.
• Logged all technical issues.
• Maintained PeopleSoft Security like creating roles, profiles, users and managing permissions, Active Directory, Single Signon and Maintaining teh Data permissions using Rowlevel Security.
• Reported completed tasks, issues, and risks to teh upgrade Assistant
• Configured Upgrade Assistant.
• Downloaded all teh necessary Patch Applications required for Upgrade and applying them.
• Performed debugging on application and processes.
• Resolved sysaudit and dddaudit issues. Created projects to migrate customized objects.
• Tested teh non PeopleSoft Objects like SQR and Crystal Reports.
• Handled teh retrofitting of SQRs / Crystal /nVision reports in teh new versions.
• Reapplied PeopleCode customizations.
• Migrated teh tested system to stage environment for User Acceptance testing
• Deployed Security by creating user profiles, ID’s and passwords, designated roles and permission lists.
• Configured and managed PeopleSoft Internet Architecture.
• Configured Integration Broker gateway, nodes, channels and messages both between HRMS and Financial environments.
• Executed Scripts daily to restore backup from Production Database to Production Copy Database.
• Completely responsible for configuring, monitoring, and administering teh Production and Development databases.

Environment: PeopleSoft (7.x/8.x), PeopleTools (7.62/8.4x), Tuxedo 8.1, Oracle 8i/9i, Microsoft SQL Server 2000, Windows NT/2000/XP, Sun Solaris.

PeopleTools: Application Designer, Upgrade Assistant, Process Scheduler, SQR Provided PeopleSoft Administration support to several clients including USi, Corio, Hilton Hotels, Sunburst Hospitality, Senco and Milacron.

Confidential

PeopleSoft Student Administration

Responsibilities:

• Following are teh activities being executed as part of this project:
• Gatheird requirements for hardware and software compatibility for teh releases.
• Installed, configured & supported Oracle, PeopleSoft Application Servers, Process Schedulers, Tuxedo, Web Servers, Integration Broker nodes (Internal and External) and Cobol Compilers.
• PeopleSoft application patching Bundles/fixes,
• Interactions wif teh Confidential users on teh analysis, scoping of new requirements, suggest teh Best Practice methods to improve teh efficiency of teh system.
• Logged all technical issues.
• Created SQL scripts to resolve teh technical issues faced during teh implementation and Support activities.
• Reported completed tasks, issues, and risks during Support.
• Performed debugging on application and processes
• Created projects to migrate customized objects.
• Migrated Custom configuration setup and security setup from one environment to other
• Provide user materials and enhance teh user on teh new functions usage in teh upgraded version.Coordinated wif PeopleSoft GSC in researching issues and their resolutions.

Environment: PeopleSoft Student Administration and Campus Solutions 8 SP1, People Tools 8.18, Windows 2000 Server, SQL Server 2000.

Confidential

Oracle Database Administrator

Responsibilities:

• Created and maintained teh Oracle databases.
• Created and maintained users and roles.
• Managed database structures, storage allocation, tablespaces, tables/index segments, rollback segments, constraints, database access, and privileges.
• Handled teh management of space and rollback segments.
• Maintained Database integrity and consistency (primary key, foreign key constraints).
• Planned and monitored regular backups.
• Monitored user access to teh database.
• Monitored and optimized teh performance of teh database.
• Handled teh Test plan preparation for Backup and Recovery.
• Involved wif Database backup and recovery specifications, design and test.
• Sized teh database for future growth.
• Maintained archived data on tape and disk.
• Loaded flat files into Oracle database by using SQL*LOADER.
• Imported and Exported data.Installed, tuned PL/SQL packages.
• Handled complete Database backups and DR Site setup/maintenance.
• Involved wif performance tuning and troubleshooting as required.

Environment: Oracle 8.1.7, Developer 2000, Linux