We provide IT Staff Augmentation Services!

Peoplesoft Architect / Administrator / Dba Resume

Brisbane, CA

SUMMARY:

  • 17 Years of experience in IT and over 12 years of experience in PeopleSoft System Administration with Oracle, Microsoft SQL Server and UD DB2 and having strong experience in Installation, Upgrade, Administration and Maintenance. Oracle 9i Certified Database Professional.
  • Installed and supported many PeopleSoft applications.
  • Successfully performed Upgrade of PeopleSoft FSCM 8.8SP1/FSCM 9.2 PI25, PeopleTools 8.50.27/PT8.56, HRMS 8.3/9.0,PeopleTools 8.19/8.48 and Financials 8.4/8.8, PeopleTools 8.44.
  • Performed 4 - step upgrade from FSCM 8.8 SP1 /8.50 to FSCM 9.2PI25 / PT 8.56.
  • Performed PeopleSoft PUM Product Update Manager implementation and configuration. PUM Virtual image setup.
  • Applied latest bundles using PeopleSoft Upgrade Manager PUM and Oracle Virtual Box.
  • Configured PeopleSoft Test Framework.
  • Installed Oracle Secure Enterprise Search and configured it.
  • Expertise in administering PeopleSoft Server components, Report Repository Servers, PIA (PeopleSoft Internet Architecture), Integration Broker, SQL Server, Oracle, troubleshooting application and technical issues.
  • Installed and configured BEA Web Logic Server, installed Web Server components and created Web Server domains. Installed and configured both Single Server and Multi Server domain.
  • Installed Tuxedo and configured Application Server domains.
  • Configured Process Schedulers on both NT Batch Servers as well as UNIX batch servers.
  • Involved in implementing Quest STAT for Change Management enabling to migrate PS Project and File Objects with ability to rollback to the previous archive sets if needed.
  • Expertise in Performance tuning, troubleshooting & connection issues of PeopleSoft Application Server, Process scheduler, Web Server and Database Servers instances.
  • Expertise in Installation, Configuration and troubleshooting of Change Assistant.
  • Performed Application Updates and Fixes, PeopleTools Patches and PeopleTools Upgrades.
  • Expertise in Version control, Change management, Data Mover.
  • Extensive experience with Integration Broker handling both PeopleSoft to PeopleSoft and PeopleSoft to 3rd party Application messaging.
  • Implementation of Single Sign On (SSO) setup for PeopleSoft application.
  • Installation of Peoplebooks, Verity search, Crystal Reports, COBOL compiler/licenses.
  • Migrated PeopleSoft objects both internal objects (PeopleCode, records, panels/pages etc) and external objects (COBOL, SQR) using Quest STAT as well as Application Designer.
  • Archived system transaction data using Peoplesoft Data Archive Manager Tool .
  • Implementation of PeopleSoft Security Matrix.
  • Ability to troubleshoot complex technical and logical issues and adapt quickly to changes.
  • Extensive experience in performing database refreshes / cloning.
  • Worked with PeopleSoft GSC on critical issues and documented the resolutions.
  • Supported PeopleSoft Development team, QA team and Production End-users.
  • Expert in relational database concepts and design. Involved for maintenance and support for OLTP environment.
  • Performed tasks associated with tuning of database systems for performance and efficiency enhancements, reviewing the logs, available space, configuring the initialization parameters based on application requirements, optimizing complex SQL queries.
  • Very comfortable with all the flavors of UNIX (Solaris, AIX, HP UNIX), Linux and Shell Scripting. Have good knowledge of basic Unix Administration and file systems concepts.
  • Strong written and verbal communication skills. Effective team player and Ability to learn new skills/tools on demand and deliver excellent productivity in short time. Self-motivated and enjoy working in a technically challenging environment.

TECHNICAL SKILLS:

PeopleSoft Applications: Financials 9.2/8.9/8.8SP2/8.8/8.4SP1/8.0/7.5, HRCS9.0, HCM 8.9/8.8/8.3SP1/8.3/8.0,CRM 8.4, Portal 8.9.

PeopleSoft People Tools: V 8.56/8.53/8.50/ 8.49/8.48/ 8.47/ 8.46/ 8.44/ 8.43/ 8.42/ 8.2 x/ 8.1x/ 7.5x.

Reporting Tools: SQR, Crystal Reports, PS Query, nVision, Tree Manager.

Integration Tools: Component Interface, Application Messaging, Integration Broker, File Layout, Business Interlinks.

Application/Web Servers: BEA WebLogic 12.1.3/10.3.5, 9.1/8.1/6.1/5.1, Tuxedo 12.1.3/10gR3, 9.1/ 8.1/6, IBM Web-Sphere Application Server (WAS), Oracle Application Server (OAS) and Microsoft IIS.

Operating System: Windows 2012,Windows 2008 server, Windows NT Server/Workstation 4.0, 98, 2000, 2003, XP, 2008, MS-DOS, UNIX (HP Unix, Sun Solaris, AIX operating systems) and Red Hat Linux.

RDBMS: MS SQL Server 2012/2008R2/2005/2000, Oracle10g RAC/9i/8i/7.5, MS Access, IBM UDB DB28.1.

Administration Tools: PUM, Application Designer, Data Mover, Configuration Manager, Query Manager, Change Assistant, SQL Plus, Quest Toad.

Languages: SQL, PL/SQL, UNIX Shell Programming.

Change Management Tool: Quest STAT 5.1, Kintana, ClearCase, PVCS.

Problem Management Tools: Remedy, Jeera, Webstar, Track-it, and Clear Quest.

PROFESSIONAL EXPERIENCE:

Confidential, Brisbane, CA

PeopleSoft Architect / Administrator / DBA

Responsibilities:

  • Planned for the Upgrade including tasks like reviewing PeopleSoft Customer Connection for Applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and review documentation (e.g. release notes, white papers).
  • Played an active role in deciding the Upgrade path and made recommendations on hardware and Software to meet PeopleSoft certification and maximize performance.
  • Installed the Demo environment for Application Upgrade FSCM 8.9 PT 8.50.27. Performed the Application Upgrade from Peoplesoft FSCM 8.8SP1 to FSCM 8.9. Database SQL Server 2008, OS Windows Server 2008.
  • Installed the Demo environment for the Application & PeopleTools Upgrade for FSCM 8.9/PT 8.50.27 to FSCM 9.2 PI5/PT 8.53.09. Performed the Application and PT upgrade.
  • Prepared compare reports to identify PeopleTools Customizations. Performed migration in accordance with the business rules.
  • Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT and SYSAUDIT and Alter Audit, Database Integrity checks, update statistics.
  • Figured out all the procedures and tasks that can be performed in parallel in order to speed up the process. Documented all the steps of Change Assistant, with the timings that each step takes to complete. Tried to minimize the time to fit everything in the Go-live time window.
  • Performed the database and OS Upgrade as a Pre-requisite to move to newer PeopleTools version. Database SQL Server upgraded from SQL Server 2008 to SQL Server 2012 and Operating System upgrade from Windows Server 2008 to Windows Server 2012.
  • Installed the FSCM9.2 PI25 DPK Demo to Upgrade the Application to the latest version FSCM 9.2 PI 25 using the Peoplesoft Update Manager. (PUM).
  • Performed the PeopleTools Only Upgrade PT 8.53.09 to PT 8.56.
  • Downloaded the binaries from Oracle Delivery Services and interacted with My Oracle Support for FSCM 8.9 binaries and other upgrade related issues.
  • Step up the Virtual box for the Update Image installation, configured the Change Assistant, setup the EMF,created the Change Package Definition and applied the Change Package using the CA.
  • Applying latest bundles using PeopleSoft Upgrade Manager PUM and Oracle Virtual Box.
  • Configured PeopleSoft Test Framework.
  • Worked on installing the Oracle Secure Enterprise Search and its configuration,
  • Maintained the other environments such as DEV/ Test / UAT and DEMO in sync.
  • Worked on the Performance Tuning of Long running jobs to shorten the Upgrade timelines.
  • Successfully Upgraded People Tools from 8.47 to 8.50.27
  • Fine-tuned and created templates of psappsrv.cfg files for creating future domains.
  • Configured Integration Broker in the PT 8.50 environment. Setup and configured the Cyber source for Credit card authorization.
  • Applied Maintenance Packs 8/9 and Bundles 19-28 using Change Assistant in DMO, DEV, TST, PROD.
  • Documented and performed knowledge transfer to other groups of the architectural design.
  • Worked on development tools like SQR, Application Designer, and Crystal Reports.
  • Installed and configured all the tiers in PIA setup - The File server, Application server, Batch server, Web servers and Database server to support the PIA.
  • Uploaded data between the databases using Export and Import utilities in Data mover & sql export/import tool.
  • Keeping the Peoplesoft Environment PCI Compliant by applying quarterly released patches on scheduled time.
  • Working on the Data Archival using the Data Archive Manager Tool.
  • Re-established SQL Replication between the OLTP and Reporting environments.
  • Worked on other Microsoft projects like BI and Prophix for setting up the environments and migration of objects and other troubleshooting.
  • Carried out day to day support - running data fix scripts, Migration of updates, monitoring performance, security related requests, problem resolution, performing database refreshes, cloning environment, providing 24X7 support.
  • Along with Peoplesoft, supported other in house systems such as Red Prairie ( for distribution & Shipping ), Business Intelligence (Reporting Tool ), Syteline ( ERP system implemented for China/Shanghai ),Prophix ( Budgeting tool ) in the scope of the system administrator.

Environment: PeopleTools 8.56/8.53/8.50/8.47, PeopleSoft FSCM 8.8SP1/8.9/9.2, Weblogic 12.1.3.0/ 10.3.5/9.1, Tuxedo 12.1.3/10g R3/9.1, MS Sql Server 2012/2008/2005/2000, Windows Server 2012/2008/2003, Track-it.

Confidential, Palo Alto, CA

Senior PeopleSoft Administrator

Responsibilities:

  • Maintained a vast system comprising of 12 environments for Campus Solution and 8 environments for ELM.
  • Involved in the day to day support activities such as resolving jeera tickets, performing weekly migrations using Kintana, providing 24X7 system support, monitoring the system performance.
  • Implemented PeopleSoft Verity, Installed peoplebooks.
  • Applied PeopleTools patches and Application bundles in the DMO, Test, UAT and other non prod environments and the Production environment using Change Assistant.
  • Involved in Oracle DB patch upgrade from 10.2.0.3 to 10.2.0.4.
  • Maintained a number of third party systems like Kaba Clock and so on.
  • Maintained complete and precise documentation of changes in a system known as Docushare.
  • Involved in the configuration of BIGIP and firewall setup between different components of PS.
  • Performed database refreshes and created scripts to schedule them daily.
  • Created PeopleSoft Jobs using Custom Scheduler.
  • Developed interface for inbound and outbound files.
  • Grant Portal Access to Developers and Users on request basis. Run data fix scripts. Turn Trace on debug process, perform performance tuning on slow and long running processes. Provided 24X7 support.

Environment: PeopleTools 8.49, PeopleSoft CS 9.0, ELM 9.0 Weblogic 9.2 MP1 p5, Tuxedo 9.1 rp36, Oracle 10.2.0.3.0/10.2.0.4, Linux, Solaris, AsJira, Kintana, docushare, confluence.

Confidential, Dayton, Ohio

Senior PeopleSoft Upgrader / Administrator

Responsibilities:

  • Planned for the Upgrade including tasks like reviewing PeopleSoft Customer Connection for Applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and review documentation (e.g., release notes, white papers).
  • Made recommendations on hardware and Software to meet PeopleSoft certification and maximize performance. Also worked with PeopleSoft to validate HW/SW requirements for installation.
  • Successfully performed PeopleSoft HRMS upgrade from 8.8 to 9.0.
  • Successfully Upgraded People Tools 8.4 to 8.49.
  • Participated in the conversion of Non-Unicode Oracle database 9i to Unicode database 10g.
  • Prepared scripts to convert Long data type to Clob data type.
  • Ran compare reports to identify differences between source and target database before doing any migrations. Performed migration in accordance with the business rules.
  • Fine tuned and created templates of psappsrv.cfg files for creating future domains.
  • Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT and SYSAUDIT and Alter Audit, Apply Upgrade Options (UPGOPT) project, update statistics.
  • Participated in applying tax updates, bundles and fixes using Change Assistant.
  • Documented and performed knowledge transfer to other groups of the architectural design.
  • Worked on development tools like SQR, Application Designer, and Crystal Reports.
  • Installed and configured all the tiers in PIA setup - The File server, Application server, Batch server, Web servers and Database server to support the PIA.
  • Installed /configured multiple Web Servers. Generated certificates, configured SSL for the Web Servers.
  • Uploaded data between the databases using Export and Import utilities in Data mover.
  • Working with other DBA’s to get tracing turned on to trace batch processes in order to investigate performance issues. Ensure all performance modifications are identified and documented.
  • Figured out all the procedures and tasks that can be performed in parallel in order to speed up the process. Broke down some data mover scripts into smaller scripts which could be run in parallel. Documented all the steps of Change Assistant, with the timings that each step takes to complete. Tried to minimize the time to fit everything in the Go-live time window.

Environment: PeopleTools 8.4/8.49, PeopleSoft HRMS 8.8/9.0, Weblogic 9.1/8.1SP5, Tuxedo 9.1, Oracle 10g RAC, Linux 2.6.9-42.0.10. ELsmp, Webstar.

Confidential, Orlando, Florida

Senior PeopleSoft Administrator

Responsibilities:

  • Installed PeopleTools 8.49, FSCM 9.0/8.9.
  • Installed BEA Tuxedo on the Application/Batch server. Installed BEA Web Logic on the Web server.
  • Build many PeopleSoft environments for Demo, Prototype, Conversions, Development, UAT Testing, Performance Testing, Training and Production database instances.
  • Configured the Web Server, configured single server as well as multi server domains and created multiple Web Logic Web Server instances for load balancing and fail over.
  • Installed People Books and generated search collection for the entire site. Configured Help URL in the PIA Web Profile so that online users can use Help.
  • Configured Application Server domains and Process Scheduler Servers and tuned the configuration parameters based on the type of usage.
  • Installed Micro Focus Net/Server Express COBOL compiler on the NT and UNIX Batch Servers.
  • Ensured Data integrity by running SYSAUDIT and DDDAUDIT reports on a regular basis and before and after applying any patches or bundles.
  • Worked on PeopleSoft Security, - Created Permission Lists, Roles, User Profiles, and maintained them.
  • Extensively used Data mover utility for running many DMS scripts for exporting, importing PeopleSoft security and encrypting passwords.
  • Installed Change Assistant to apply patches and bundles.
  • Created Database Performance related scripts. (Re-indexing/Updating Statistics.)
  • Extensively used UNIX servers (Sun Solaris and Red Hat Linux) for Application Server, Web Server, Database Server and Process Scheduler. Implemented many scripts in UNIX server to Monitor Application Server / Process scheduler status, Reboot scripts.
  • Performed Db refreshes / Cloning of databases.
  • Performed 24x7 Production support on an ongoing basis.

Environment: PeopleTools 8.49, PeopleSoft FSCM 9.0/8.9, Weblogic 8.1SP5, Tuxedo 8.1, MS SQLSERVER 2000 SP4, Sun Solaris, Red Hat Linux, Windows 2003, Webstar.

Confidential, NJ

Senior PeopleSoft DBA

Responsibilities:

  • Maintained and supported 55 PS system databases supporting more than 50K global users.
  • Performed the role of a Senior PeopleSoft DBA and executed duties like Appraisals, shift schedule design, mentoring.
  • Responsible for all phases of the HCM 8.3 to 9 (PT 8.19/8.48) Upgrade Project from the infrastructure side including the initial infrastructure design, Installation/ configuration of Development, Testing, Pre-Prod and Production box, performance tuning & testing, deployment and Production support.
  • Lead the HCM 8.9 MP Implementation project.
  • Responsible for Production support of HRMS, Portal, Finance and CRM Applications.
  • Designed the physical and logical layout of the servers based on user requirements, scalability.
  • Implemented Lightweight Directory Access Protocol (LDAP) Authentication.
  • Implemented security for PeopleSoft environments (SSL).
  • Applied Patches & Fixes, Tax Updates, Bundles and Maintenance Packs to non-prod & prod env.
  • Involved in performing the Initial Upgrade, Test Move to Production before a Final Move to Production. Tuned and optimized system to reduce time needed for running upgrade scripts.
  • Experience with Integration Broker. Troubleshooting causes for Integration broker messages in Queued status, Report Not Posting, Subsequent process failures, Site not accessible, Deadlock issues, Database agent unable to connect to DB.
  • Developed and maintained UNIX shell scripts for automating administration.
  • Worked extensively in Security by designing & developing Roles, Permission List & User Profile.
  • Installation and Configuration of PIA on Windows NT/2000 and UNIX Boxes.
  • Installed People Books for online availability for all the users.
  • Migrated projects between PeopleSoft Instances using Application Designer and Quest STAT. Worked as a STAT Admin for creation of Users profiles and accesses.
  • Worked on development tools like SQR, Application Designer, and Crystal Reports.
  • Involved in performing database refreshes /database cloning at the request of the developers.
  • Database administration tasks like creating permission to users and services accounts for third party applications and PeopleSoft applications.
  • Involved in database performance tuning and SQL scripting.
  • Involved in tuning the table spaces, updating the statistics (re-org) of tables and indexes and SQL query tuning based on the execution plan and the I/O.
  • Proven ability to effectively troubleshoot systems administration issues and communicate.
  • Trained the Staff on PeopleSoft Internet Architecture concepts.
  • Provided 24X7 Production Support.

Environment: PeopleTools 8.19/8.2x/ 8.42/8.43/8.46/8.48, PeopleSoft FSCM 8.0/8.4/8.9, HCM 8.0/8.3/8.9/9, Portal 8.9, CRM 8.4, Websphere 5.1, Weblogic 8.1/6.1/5.1, Tuxedo 8.1/9.1, IBM UDB DB2 8.1 FP10, MS Sql Server 2000, Oracle 9i/10g RAC, STAT 5.13, Unix AIX-5.3, NT2000,Remedy.

Confidential, OH

PeopleSoft Administrator /Security Administrator

Responsibilities:

  • Performed PS Upgrade for FSCM 8.4 (PeopleTools 8.44) to FSCM 8.8 (PeopleTools 8.44).
  • Performed installation of PeopleTools, Applications, evaluated the existing hardware and software configuration and tuned according to the recommendations.
  • Installed and setup Change Assistant to apply application updates to the PeopleSoft applications on People Tools 8.44 and above.
  • Applied the People Tools 8.47 Product Patch and applied the Maintenance Pack 1 thru Maintenance Pack 4 for Financials 8.9 using Change Assistant.
  • Applied Maintenance Packs and Tax Updates to HRMS 8.9 applications.
  • Applied PT patches and Application specific patches, Bundles and Service Pack upgrades.
  • Involved in system testing and bug fixing during the initial and move to the Production phases.
  • Designed the Security Matrix in accordance to SOX Compliance. Created the Permission List, Roles, User Profiles and granted Query access, Process execution access as per the Security Matrix.

Environment: PeopleTools (8.44/8.47), PeopleSoft FSCM 8.4/8.8/8.9, HRMS8.9, Oracle9i, WebSphere 5.1, Tuxedo 8.1, UNIX Sun Solaris 10, STAT 5.13, ClearQuest.

Confidential

PeopleSoft Administrator / Oracle DBA

Responsibilities:

  • Implemented the Data Archival project using OuterBay product for PeopleSoft 7.5.
  • Set up demo environment for PeopleSoft 7.5 installed Oracle 8.1.7 software and created fresh databases to be used as DEMO databases for PeopleSoft 7.5.
  • Used Data Mover for migrating AE and mass change customizations. Run database refreshes.
  • Monitored CPU, shared memory and I/O statistics for UNIX and Windows NT PeopleSoft boxes.
  • Performed Debugging and customizing SQR programs.
  • Created Shell scripts to automate server startup, shutdown process and cache clearance.
  • Performed Oracle DBA activities on Development databases; create schemas, tablespaces, referential integrity, data quality assurance, table creation, views, backups and so on.
  • Worked on Database Security, Performance Tuning, Database Optimization.
  • Modified Control File for database cloning, reset logging and default archiving.
  • Implemented hot and cold backups, online backups, export backups and restorations.
  • Worked on resolution of various Database Recovery scenarios using RMAN.
  • Performance tuning for long running queries.
  • 24X7 Production Support.

Environment: PeopleTools 7.52, PeopleSoft Finance 7.5, Tuxedo 6, Oracle 8.1.7, AIXv4.3, Clearcase, Remedy.

Confidential

Software Consultant / Oracle DBA

Responsibilities:

  • Provided Support to the Legacy systems.
  • Designed the Web Pages. Developed the module which transfers data using flat files.
  • Scheduled and monitored the routine and monthly Jobs.
  • Developed SQR programs to generate KPI Reports monthly.
  • Involved in the rollout of the module which facilitates transfer of Legacy data to ERP System.
  • Installed Oracle 9i, 10.1.0.2 on Windows 2000 server, Solaris 8, Fedora Core -4.
  • Reorganized the data using Import and export utilities. Created remote database links.
  • Involved in System administration activities like maintaining security, adding the system users.
  • All backups for ORACLE are automatically taken at different time during the day through Unix Cronjob utility. Responsible for configuring the crontab files.
  • Performed Backup and recovery of the database which included taking backup on tape drives through UNIX, recovered /restored the files through operating system (UNIX). Maintained the schedules for daily, weekly and monthly backup for both logical as well as physical backup. Created RMAN script for backup and performed RMAN backup.
  • Performed SQL tuning using Tkprof, SQL Trace and Explain plan. Used OEM for tuning the SQLs.
  • 16X7 Production Support.

Environment: HTML, JavaScript, PL/SQL, ORACLE 7.x/8/9i/10.1,MS Access, SQLloader, SQL*Plus, UNIX, Solaris 8, Shell Scripts, Oracle Web Application Server, Forms 3.0, PL/SQL 2.24, SQR 2.28,Win 98/NT/2000.

Hire Now