SUMMARY:

• Prasad is an Oracle Certified Professional with more than ten 10 years of extensive experience as PeopleSoft Applications Administrator and Upgrade Specialist in IT industry supporting modules HCM, CRM, ELS and Financials applications on Oracle technology
• Worked on multiple PS upgrade projects for different modules: HCM 9.1 9.2, HCM 9.0 9.2, ELS 9.0 9.2, CRM 9.0 9.2, Finance 9.0 9.1. Experience in tools only upgrades. Excellent understanding of the Peoplesoft Upgrade methodology, PeopleSoft Technical Architecture, Load Balancers, Web Server, Application server, Process Scheduler, Oracle RDMS
• Experience in Oracle Software installation, Upgrade of Oracle software, Patching of Oracle software, RAC setup, Creation of DBS and Replication of DBS using RMAN, Performance tuning SQL Oracle Certified Professional in Oracle 11gR2
• Worked in the capacity of Senior PeopleSoft Lead Administrator /Architect and supporting PeopleSoft Core HRMS, CRM and Financials applications on Oracle, expertise in architecture, design, development, testing, full upgrade life cycle, implementation, administration, installation, customization, migration, patching, performance tuning, backup recovery and maintenance in Oracle 11g and 10g on Sun Solaris, HP-UX, Oracle Enterprise Linux and Red Hat Enterprise Linux
• Proficient in PeopleSoft troubleshooting, performance tuning, debugging, running traces at web, app and analyze logs for patterns and applying maintenance packs, tax updates, patches and bundles
• Upgraded Peoplesoft HR 9.0 to 9.2, ELS 9.0 to 9.2 and CRM 9.0 to 9.2 and Financials 9.0 to 9.1 and also upgrades PeopleTools
• Worked on multiple PeopleSoft upgrade projects for different modules: HCM 9.0 to 9.2, ELS 9.0 to 9.2 and CRM 9.0 to 9.2 and Finance 9.0 to 9.1, Applied patches and bundles using PeopleSoft Update Manager PUM images and installed Oracle Secured Enterprise Search database software and configuring it from within 9.2 applications
• Installed bundles PeopleSoft PUM Images using Oracle Virtual Box and configured and instruct client in use of the PeopleSoft Update manager PUM for their upgraded 9.2 HCM system. He has installed and configured of PeopleSoft Software in Dev, Customer Testing, QA and Prod regions and configured of PeopleSoft Internet Architecture PIA instances for various PeopleSoft/Oracle Database Instances in DEV, CUSTOMER TEST, QA and PRODS regions.

TECHNICAL SKILLS:

ERP Applications: PeopleSoft HCM, CRM, Financials, ELS

RDBMS: Oracle 11.x, 10.x, 9.x, SQL Server 2000/7.0

Oracle Tools: OEM, SQL Plus, SQL Loader, Import/Export, Data pump, Stats pack, AWR, Symantec Net Backup

Development Tools: TOAD, SQL Navigator, SQL Plus, SQL Developer

Change Management: Quest Stat

PeopleTools: Configuration Manager, Application Designer, Application Engine, SQR, PeopleCode, PS Administration Tools

Security Tools: Security Administrator, Object Security, Query Security and Tree Manager

Reporting Tools: Cognos v7.0, SQR, Business Objects, Crystal Reports, nVision

Web Servers: BEA Web Logic v10.x, 8.x/6.x/5.0, IBM WebSphere, Microsoft IIS 6.0/5.0

Operating Systems: RHEL v5.10, Windows --NT / 2000, Linux, HP-UX, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Administrator DBA

Tech: PeopleSoft Upgrade HCM v9.1 to 9.2

Tools Upgrade: 8.51 to 8.54

Oracle SES: 11.2.1.2

Oracle DB: 11.2.0.3

Environment: App Designer, Quest STAT, SQL Loader, Oracle Enterprise Manager, Oracle Virtual Box, RMAN, RHEL v5.10, Windows Server 2008R2

Contribution:

• Worked on PS Upgrade of HCM v9.1 to 9.2
• Key Tasks: Creation of Demo in 9.2 on Oracle v11.2.0.3
• Taking backup of prod oracle db and refreshing lower region to run Initial Pass and MTPs
• Setting up Change Assistant tool for Initial Pass and MTP
• Ran multiple trial MTPs
• Upgrade of tools from 8.51 to 8.54
• Applying latest bundles using PeopleSoft Upgrade Manager PUM and Virtual Box
• Installed Oracle SES software on Oracle Linux Server and configured SES searches from within the application.
• Prepared list of technical tasks for upgrade
• Cross-trained other PS admins about new technology
• Installed PS software Weblogic, Tuxedo, MF COBOL, and PS Binaries on linux servers and windows servers
• Configured Web, App, and Process Scheduler domains on Linux and Windows
• Setting up web and app domains in prod to serve 1000 connections at any given time

Confidential

PeopleSoft Administrator DBA

• Install Peoplesoft software configure web, app and process domains in Dev, Test, and Prod for HCM, ELS, CRM and FIN modules. Install and Configure MicroFocus COBOL. Configuration of PeopleSoft Internet Architecture PIA instances for various PeopleSoft/Oracle Database Instances in DEV, TEST, QA and PROD regions. Experience in setting up Integration Broker IB transactions to flow from HR. Experience to configure Web Server, Application Server, Process Scheduler, and report distribution with Load Balancing Software. Experience in sizing of Web domains JAVA options, Memory, File Handlers , App server domains JOLT Handlers, Tuxedo for Production and QA environments.
• Install Change Assistant, run initial passes and MTPs, Install Oracle Secure Enterprise Search db software and configure it from within application, Install Bundles PUM Images using Oracle Virtual Box.
• Installation of Oracle software, creation of databases and refresh dbs, Supported production databases with 24X7 and on call/pager support, worked on the Performance Tuning of Production databases.
• Capacity planning, monitoring space on tablespaces, disk groups, Support to development teams like creating database objects, Schemas creation, tables, indexes, constraints. Implementing backup and recovery procedures including logical backup EXPORT/IMPORT , Physical backup Online/Off-line and integrating the backup procedures. Performed recovery from instance and media failures, Improved the performance of the existing system by re-sizing the Database objects such as Tables, Indexes and Rollback segments to make the performance at optimal levels.
• Maintained users, roles and privileges in Oracle database for development team and users, Configured and tuned Oracle Listeners in a multi-database environment using Oracle Net Net Configuration Assistant , Creating/Maintaining Appropriate Documentation for various activities within project,
• External Authentication process to PeopleSoft apps with LDAP tool and custom built Single Sign-on application via IIS Proxy Servers. Solid experience with Reverse Proxy Server Setup, Load Balancers in Web, App and Core DMZs.
• Fill out Prod Support Tickets for Change Management Process using HPSD, MIS, and Tivoli tools. Submit build requests for UNIX and Windows Servers. Follow company standards for Production moves, server re-boots and any changes related to production.
• Install and configure Web Logic Server 10.X, 9.1, 8.1, 6.1, 5.1, Install and apply rolling patches for BEA Tuxedo on Windows and UNIX environment, Extensive experience with PSADMIN utility to Administer Application and Process Scheduler Servers.
• Coded UNIX Shell Scripts for maintenance of directories, Administer PeopleSoft Portals and Setting up User Security.
• Installation and Configuration of People Books, Applied People Tools Patches and Maintenance packs.
• Check Oracle Customer Site for any latest Updates and fixes, Opening PeopleSoft Support Cases and escalation of cases to get right support, Migration of Projects from QA Database to Production after successful testing using Quest STAT.
• Experience in PeopleSoft Troubleshooting, Performance tuning, Debugging, running Traces at Web, App and Analyze logs for patterns, Expertise in applying Maintenance Packs, Tax Updates, Patches and Bundles.
• Solid Experience with External Authentication to PeopleSoft, Network Configuration, Firewalls, Prepared steps required to do after lower regions are refreshed with Production database, Worked on a Data Warehouse project to create universes, client reports and web reports using Business Objects, Cognos, Well versed in Oracle 11g RAC implementation and administration.
• Excellent Knowledge of ASM 10g 11g Automatic Storage Management , Oracle DataGuard and Oracle Enterprise Manager OEM Database Grid Control .
• Excellent knowledge of SAN, RAID technologies, RAW devices and UNIX Solaris 8, 9, 10, RHEL 3, 4, 5 .

Environment: Oracle 11g, 10g, OEM, People Tools 8.1x, 8.4x, 8.53 , PeopleSoft HRMS 9.2, 9.0, 8.9, CRM 8.9, ELS 9, Financials, Oracle 11g/10g/9i, Sun Solaris Unix v9/10, RHEL v5.10, Windows NT / 2000, WebLogic 11.x, 10.x, 9.1, 8.1, 5.1, Tuxedo 11g, 9.1, 8.1, 5.1, F5 LoadBalancer, Single Sign-on using LDAP, SQR, SQL, Business Objects, Crystal Reports, Symantec Net Backup