We provide IT Staff Augmentation Services!

Peoplesoft Upgrade Specialist Resume

Germantown, MD

SUMMARY:

  • I have over Ten years of hands - on experience as a PeopleSoft Administrator and Oracle Database Administration which involves activities like application installation, administration, maintenance, upgrades, migrations from operating systems to another and performance tuning.
  • I possess complete life cycle knowledge including Installation, Configuration, Development, Testing and Deployment of PeopleSoft HRMS, Enterprise Financials/SCM, ELM, CRM & Enterprise Portal product lines.
  • Have extensive experience in performing PeopleTools Only Upgrades and Application Upgrades of PeopleSoft Financials & SCM, HRMS/ HCM and Enterprise Portal applications.
  • Migration experience includes Patches and Fixes, Bundles, Maintenance Packs, Tax Updates and Service Packs across PeopleSoft environments manually and using Quest STAT product.
  • My Responsibilities also include PeopleSoft Administration/Security Administration, installing & configuring Change Assistant, App servers, Web servers, Process Schedulers, PeopleSoft Internet Architecture (PIA) and Portal on Windows and UNIX (Linux, Solaris, HP-UX flavors).
  • Network architecture plan was created with the help of the network team (F5 & Cisco Content Switch & ACE) which involved logical design of load balancer and network switch setup.

TECHNICAL SKILLS:

ERP: PeopleSoft Financials/SCM (version 8.4, 8.9, 9.0,9.1), HRMS/HCM (8.3, 8.8, 8.9, 9.0,9.1), PeopleSoft Enterprise Portal (8.8 & 9.0,9.1), PeopleTools 8.22, 8.43, 8.45, 8.48, 8.49, 8.50, 8.51, 8.52

PeopleTools: Configuration Manager, Application Designer, Data Mover, Process Scheduler, Process Monitor, Application Messaging Monitor, Upgrade/Change Assistant, RenServer, Integration

Databases: MS SQL Server 7.x, 2000, 2005, Oracle 8i, 9i, 10g R2, 11g

Database Tools: Grid Control, Toad Xpert (SQL Optimizer)

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX, Linux )

Hardware: Sun SPARC M4000, M3000, T5220, T2000, Sun Fire 15K, Sun 6320 StorEdge, Sun Enterprise Servers 890/880, Hitachi, EMC-VMAX, EMC-DMX, Dell Servers, Compaq Servers 6000/3000/1600

Middleware: BEA Tuxedo Application Server 6.5, 8.1, 9.2, 10.2

Web Servers: BEA Weblogic 5.1, 6.5, 8.1 SP5, 9.2, 10.3

EXPERIENCE:

Confidential, Germantown, MD

PeopleSoft Upgrade Specialist

Responsibilities:

  • Performed PeopleTools upgrade from Peopletools 8.4 .20 simultaneously on both CRM 8.8 and Portal 8.8 in a very heavily customized environment
  • Implemented best practices as it related to OS kernel parameter setup (RHEL 6.1)
  • Configuring the Integration Broker setup between Portal and CRM environments ad also integrations via WSDL integrating with other third party applications.
  • Performed a complete infrastructure migration from Windows server 2003 to RHEL 6.1 for web, application server and process scheduler tiers.
  • Created custom Unix shell scripts which are used to start/stop/confirm status of the application server domains and process scheduler domains and webserver domains
  • Performed capacity analysis and planning to determine future hardware requirements and/or configuration changes.
  • Mentor the PeopleSoft Administrative staff.
  • Performed sticky bit implementation on the netscaler to facilitate issues incurred during webserver load balancing
  • Implemented firewall rules to facilitate the use of the DMZ and custom integration broker setup
  • Performed upgrade from oracle 9i to oracle 11.0.2.3 using dbua
  • Responsible for validating the Report Nodes, and confirming that reports post successfully within all demonstration, development,, test, uat/qa, and loading environments.
  • Responsible for tuning the oracle memory segments within the Oracle shared pool (library cache, buffer cache, redo cache).
  • Responsible for tuning, configuring, and placement of the oracle database files, redo logs, control files.
  • Responsible for automating/streamlining the PeopleSoft/Oracle refresh process.
  • Complete the modification of database structures, as necessary, from information given by application developers
  • Developed UNIX shell, SQL Plus, PL/SQL, MS Dos scripts/routines to help manage remote systems with less manpower and to reduce downtime.

Confidential

PeopleSoft Administrator/Upgrader

Responsibilities:

  • I provided technical support for Oracle customers using the PeopleSoft products.
  • Operations, as the name indicates, handle Change, Incident, Release & Problem management for all customers in Production and Implementation/Upgrade phases. I provided technical support for Oracle customers using the PeopleSoft products.
  • Operations, as the name indicates, handle Change, Incident, Release & Problem management for all customers in Production and Implementation/Upgrade.
  • I was primarily responsible for Peoplesoft Implementations/ Migrations and Upgrades, and assisting with change management/Incident management tasks, PMP program management and scheduling, Customer interaction for major activities such as Maintenance Packs/Upgrades/Implementations/Migrations and Co-ordinating with offshore team to ensure all customer activities are being performed in a timely fashion.
  • Attending the weekly status call with our customers’ and also the internal team meetings to discuss how to still build our team stronger.
  • Troubleshooting various issues related to Web Server instances, Application Server and Process Scheduler domains.
  • Setting up single-signon between Enterprise Portal and Content Provider Environments (Financials/SCM, HCM, ELM environments).
  • Configuring the Integration Broker setup between Financials/SCM and Human Resources environments.
  • Set Blackout utilizing Oracle Enterprise Manager (OEM) to eliminate notifications during patching/upgrading.
  • Implemented Oracle Parallelization so as to maximize host resources and reduce data conversion time during upgrade.
  • Provided infrastructure recommendations based on max concurrent users and customer specific procedures.
  • Provided a migration/upgrade path from DB2 to Oracle utilizing oracle import export mechanism and also upgrading from Financials/SCM 8.46/8.8 to Financials/SCM 8.51/9.1
  • Performed patching/upgrade in multilingual environments
  • Utilized software based load balancing using Weblogic RPS (Reverse Proxy Server)
  • Performed PeopleSoft upgrades in environments in which development is unable to be halted
  • Provided recommendations for implementing mass email notification for a large amount of users concurrently (25000 user)
  • Rectified nvison issues that involved faulty Microsoft office install by utilizing the "Visual Basic for applications" option
  • Performed Performance Analysis activities as well as Instance Validation Tasks (IVT) activities to provide verification for the customer environment
  • Worked with Oracle GSC to provide fixes to bugs encountered with the PeopleSoft suite of Products
  • Performed PeopleSoft upgrade whilst maintaining customer security changes
  • Produced and analyzed Oracle AWR reports to address performance bottlenecks
  • Performed Oracle upgrades from 10.2.0.3 to 11.2.0.3 while simultaneously performing a People tools upgrade from 8.4 .11

Confidential, MI

PeopleSoft Administrator/Production Support

Responsibilities:

  • Attending the weekly status call with our customers’ and also the internal team meetings to discuss how to still build our team stronger.
  • Troubleshooting various issues related to Web Server instances, Application Server and Process Scheduler domains.
  • Setting up single-signon between Enterprise Portal and Content Provider Environments (Financials/SCM, HCM, ELM environments).
  • Configuring the Integration Broker setup between Financials/SCM and Human Resources environments.
  • Applied Maintenance Packs, Bundles and Fixes to Financials/SCM and Human Resources environments.
  • Created Global Support Center (GSC) cases and worked with them extensively in troubleshooting issues.
  • Preparing action plans for any action items to be carried out by the next shift coming in.
  • Generated Environment Manager Report (EMR) for the various customers to view and decide on what updates they want EDS to apply.
  • Installed COBOL compiler to execute both 32 and 64 bit PeopleTools versions whilst utilizing one license database.
  • Performed PeopleSoft database migrations/upgrade from Oracle databases from 10.2.0 Oracle Single Node to 10.2.0.3 Oracle RAC.
  • Performed PeopleSoft environment migrations from Linux to Solaris.
  • Performed single instance migration from file system (EMC 6140) to ASM (EMC Clariion).
  • Performed a several server health checks, and tested failover scenarios, used LoadRunner for performance tests and benchmarks to facilitate a successful 10.2.0.3 Oracle RAC migration.
  • Performed Database and PeopleSoft Health Checks and upgraded CRS from 10.2.0.1 to 10.2.0.4.
  • Assisted in the migration of integral PeopleSoft interfaces during hardware migration.
  • Researched and implemented Hardware specifications based on estimated environment growth projections.
  • Revised sitescope (monitoring tool) implementation to better assist with the troubleshooting efforts with the PeopleSoft/Oracle Administration team.
  • Assisted with the implementation of Guardium (activity monitoring tool).
  • Resolved Oracle RAC issues as it relates to a PeopleSoft environment by pinning objects to help reduced shared pool fragmentation and increase performance on these objects.
  • Resolved issues relating to Oracle cluster services not being able to start up using the Oracle cluster tools.
  • Resolved issues as it relates to using round robin as a preferred choice for use with Cisco Content Switch.
  • Resolved issues as it related to the journaling file system and its interaction with the PeopleSoft application
  • Modified parameters within Oracle to reduce CPU cycles on the database server
  • Implemented best practices techniques with regards to timeout settings on all tiers of the PeopleSoft Application
  • Increased the manageability of Weblogic webservers with the PeopleSoft Environment.
  • Modified semaphore settings as it relates to Solaris within the PeopleSoft Environment.
  • Assisted in the modification of firewall rules to alleviate issues with a PeopleSoft Portal 9.0 environment.
  • Utilized OSWatcher during load testing performed by LoadRunner to alleviate OS related bottlenecks within the PeopleSoft Application.
  • Installed and configured a Portal 9.0 with PeopleTools 8.51.09 to facilitate a PeopleTools only upgrade.
  • Completed the initial pass of a PeopleTools only upgrade from 8.4 .09 within a PeopleSoft 9.0 environment.
  • Troubleshooting and Performance Tuning: This is one of my major tasks to troubleshoot problems either at oracle software level or PeopleSoft technology or performance or printing or any process scheduler program. I performed tracing at PeopleSoft level, oracle level, debugging and then provide solutions.
  • Performance testing of tuxedo Application Server, Weblogic and PIA setup
  • Apply patches to different components of PeopleSoft applications (Application Server, Web Server, Batch Server)
  • Created Startup and Shutdown scripts for the WebLogic WebServer (9.2) and Tuxedo Application Server Domains and Process Scheduler servers for various versions, to be used during the maintenance windows.

Confidential, Chersterfield, MO

PeopleSoft Architect/ Upgrade Specialist

Responsibilities:

  • Assisted with frequent project developers’ needs/requests for system configuration and database administration, and institute standard guidelines to streamline resource management
  • Worked as a PeopleSoft System Administrator and was responsible for the complete upgrade (full cycle) of PeopleTools 8.46.03 HCM 8.9 to PeopleTools 8.49.16 HCM 9.0 MP7.
  • Performed Upgrade, which includes creating new environments, upgrades, performance testing, migration to production and stabilization of production.
  • Installation of PeopleSoft Software, BEA Tuxedo, BEA Weblogic, configuring PIA and creating DEMO and SYS databases
  • Configuring PeopleSoft environment including Tuxedo, PeopleSoft Application Servers, Process Scheduler Servers, Web Servers, PIA, Report Repository, and Report Nodes etc.
  • Installed and configured Change Assistant to apply the PeopleTools and Application upgrade and Maintenance Packs.
  • Configured Environment Management Agents on Application Server, Process Scheduler, and File Servers and post management information to the Environment Management Hub
  • Ran the compare reports between DMO & Upgraded Copy of Production and present them to the technical team/end users, and assisted them to review and make decisions on the appropriate actions.
  • Importing and Exporting security, queries onto upgraded database and maintaining permission lists in sync with new development efforts.
  • Configured the dedicated e-Recruit websites.
  • Performed database refreshes from the production environments to development and testing environments
  • Created, tested and maintained the staging, testing, and development databases.
  • Configured Integration Broker/Application Messaging setup, defining Gateway, creating and configuring remote and local nodes for HRMS and Finance/SCM.
  • Applied Patches & Fixes, Tax Updates, Bundles, and Maintenance Packs to non-production and production environments.
  • Involved in upgrade of PeopleSoft Finance/SCM 8.48.02/8.9 MP1 to Finance/SCM 8.49.10/9.0 MP1.
  • Configured PeopleSoft LDAP authentication between Financials and HCM directory and prepared documentation required for LDAP.
  • Migrated SSL s from WebLogic 6.1 version to WebLogic 9.2 during the upgrade process and documented the procedures.
  • Documented the steps of requesting and renewing the SSL s for WebLogic 9.2 versions from the signing authority.
  • Performed tasks such as update statistics, re-indexing and backup-restore jobs during upgrade.
  • Excellent Performance Tuning skills on PeopleSoft delivered/customized processes, SQL Tuning, Application Server Tuxedo Tuning, Process Scheduler Tuning and WebLogic Web Server tuning, etc
  • Turned on the trace for the stress testing and monitored the hardware usage such as CPU, memory and network response time and SQL retrieval time. Analyzed the trace file and took necessary action.
  • Installed PeopleBooks and configured the WebServer to access PeopleBooks.
  • Involved in documenting procedures for database cloning/refreshing procedures and troubleshooting for separate environments (DEV/TST/QAT).
  • Provided Production support 24x7 on HRMS, Financials as a Senior PeopleSoft Administrator.
  • Created Startup and Shutdown scripts for the WebLogic WebServer and Tuxedo Application Server Domains and Process Scheduler servers for various versions, to be used during the maintenance windows.

Confidential, Philadelphia, PA

Senior PeopleSoft/SQL Server DBA

Responsibilities:

  • Installed, configured and tuned PeopleSoft’s Financials 9.0 application PeopleTools 8.49.05 and all related middleware on Windows 2003 and SQL Server 2005 environment.
  • Demonstrated knowledge of Multi-tier PeopleSoft Architecture, Tuxedo, and WebLogic.
  • Experienced in PeopleSoft Technical Architecture Design, System Sizing, and Application Installation/Configuration/Administration of different PeopleSoft product lines.
  • Apply and maintain inventory of Patches/ Bundles/ Maintenance Packs for PeopleTools, Applications, and SQL Server 2005.
  • Migrated objects between database environments.
  • Tuning database- performance and perform capacity planning
  • Assist with PeopleSoft Financials migration from Oracle 9i to SQL Server 2005.
  • Provide support for Financials on SQL Server.
  • Managing multiple database environments
  • Applying Patches/ Bundles/ Maintenance Packs
  • Prepare a DBA HandBook
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Developed and optimized database structures, stored procedures, views and user-defined functions.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Optimization and automation of data loading procedures for accounting, pricing, and catalog, implementation of test and staging servers, and creation of policies to guide use of same.

Confidential, Adelphi, MD

Senior PeopleSoft/Oracle DBA

Responsibilities:

  • Installed, configured and tuned PeopleSoft’s Financials 8.9 application and all related middleware on Solaris 9 and Oracle 9i environment.
  • Demonstrated knowledge of Multi-tier PeopleSoft Architecture, Tuxedo, and WebLogic.
  • Experienced in PeopleSoft Technical Architecture Design, System Sizing, and Application Installation/Configuration/Administration of different PeopleSoft product lines at UMUC.
  • Working knowledge of PeopleSoft middleware platforms, and message queuing systems.
  • Performed PeopleSoft and Oracle administration and ensuring the global PeopleSoft production, testing, and development environments are performing to meet the requirements of its customers (external students/faculty and internal staff/developers)
  • Integrated UPK within PeopleBooks
  • Installed Oracle Application Server as the web server of choice for a PeopleTools 8.48 installation
  • Implemented performance tuning mechanisms on all tiers and aspects of the PeopleSoft Architecture
  • Retrofitted the upgrade template for financials 8.4 -8.9 to eliminate the need for a copy of current demo so as to reduce downtime during the upgrade process.
  • Implemented stress testing strategies using apache JMeter and Mercury/HP Load Runner products.
  • Configured the REN Server along with WebLogic 8.1 sp5 Proxy Server for use with SSL.
  • Performed application of regular patch/fix updates from PeopleSoft in a high-availability infrastructure, along with major upgrade initiatives as needed.
  • Performed Integration broker setup in a PeopleTools 8.48 environment on Financials 8.9
  • Performed job-related duties which required 24x7 support on-call rotation
  • Performed upgrade tasks from PeopleSoft’s Financials 8.4 to 8.9.
  • Performed upgrade tasks from PeopleTools in a PeopleSoft Portal 8.8 environment.
  • Migrated SSL s from WebLogic 6.1 to WebLogic 8.1
  • Performed STAT installation and administration, which is used for change management.
  • Provided Technical support/trained/mentored, addressed/suggested Design and Architectural issues to System Administrators and DBAs.

Confidential, Washington, DC

PeopleSoft Administrator/Upgrade Specialist/Oracle DBA

Responsibilities:

  • Installed, configured and tuned PeopleSoft’s Human Capital Management (HCM) version 8.8, PeopleSoft’s Financials 8.8 and PeopleSoft’s Portal 8.8 applications and all related middleware in an IBM AIX, Windows 2003 and Oracle 9i environment.
  • Configured and administered multiple web and application servers,, Process Schedulers, Report Repository and Integration broker messaging.
  • Designed and architected layout design, hardware sizing and procurement.
  • Designed the physical and logical layout of the servers (3 tier architecture) was done based on user requirements, scalability needs and uptime requirements.
  • Network architecture plan was created with the help of the network team which involved logical design of load balancer and network switch setup.
  • Performed installation and upgrade on the Financials/SCM 8.8 application from Financials/SCM 8.8 as well as from PeopleTools 8.45 to PeopleTools 8.47
  • Configured Integration Broker between the Financials/SCM and HRMS applications on a PeopleTools 8.48 and 8.46 architecture as well as between Financials/SCM and the Portal applications on a PeopleTools 8.47 and 8.45 architecture
  • Configured the REN Server along with WebLogic Proxy Server for use with SSL.
  • Performed installation and upgrades on the HCM 8.9, Financial/SCM 8.8, Portal 8.8 and EPM 8.8 applications as well as upgraded from PeopleTools 8.45 HCM 8.8 to PeopleTools 8.46 HCM 8.8 MP1 through the use of Change Assistant.
  • Performed the installation of EPM 8.8 as well as the installation of the client and server modules of Ascential Datastage, and Ascential Metastage
  • Customized ETL (Extract Transform and Load) scripts for use with Ascential Datastage within PeopleSoft’s EPM8.9 environment primarily used for the Planning and Budgeting Module
  • Performed troubleshooting on system problems and implemented process improvements.
  • Retrofitted the upgrade template for financials 8.4 -8.8 to eliminate the need for a copy of current demo so as to reduce downtime during the upgrade process.
  • Provided on-going capacity analysis and planning to determine future hardware requirements and/or configuration changes.
  • Maintained system administration documents and checklists.
  • Implemented solutions for functionality improvements in the areas of performance monitoring, tuning, and systems configuration, design and implementation.
  • Implemented a virtual environment as a failover mechanism during maintenance periods
  • Implemented an automatic virus update and Microsoft windows update procedure to eliminate security breaches.
  • Implemented stress testing strategies using open source tools such as OpenSta and apache JMeter
  • Implemented and administered a Cisco load balanced web server infrastructure to meet capacity requirements
  • Performed COBOL tuning for Journal Generator and Voucher Posting
  • Performed performance tuning measures through the use of shell scripting
  • Performed application development in the EPM 8.9 module to facilitate the usage of ETL mappings through the use of PeopleSoft’s delivered process scheduler, as this feature is not delivered “out the box”
  • Performed STAT installation and administration, which is used for change management.

Confidential, Dulles, VA

Software Engineer

Responsibilities:

  • Implemented programming solutions using C++ and C#.
  • Performed analysis, debugging and troubleshooting of major issues in the Confidential client version before its official launch.
  • Designed proprietary software to help solve debugging issues.
  • Designed the framework for owner drawn components using W32.
  • Initiated, evaluated and resolved information technology problems by providing appropriate technical guidance and assistance to others
  • Defines site objectives by analyzing user requirements; envisioning system features and functionality
  • Prepared technical code and support documentation for the delivered application components.

Hire Now