PeopleSoft Administrator/Technical Upgrade Specialist Oracle Database Administrator

• Highly skilled and recognized Senior Level PeopleSoft Administrator with diverse experience in installations, implementations and upgrades for several large clients.
• Managed and performed several technical upgrades using PeopleSoft Change Assistant across the entire PeopleSoft Suite of applications
• Oracle Certified Professional with extensive and seasoned expertise in technical proficiency, track record of success, and solid work ethic.
• Acknowledged as a subject matter expert coupled with diverse industry experience in Federal, State and Municipal Government, Transportation Financial Services Manufacturing Service Industry Medical Services, Higher Education, Leisure, Telecommunications, and Energy.

Strength in communication skills, presentation ability and troubleshooting critical issues.

Provide performance tuning across many Operating Systems, databases and throughout the PeopleSoft suite of applications.

Thirteen years experience implementing, upgrading and managing FSCM, HCM, CRM, ELM, Portal and EPM PeopleSoft environments, as well as managing all levels of the PeopleSoft architecture on UNIX, LINUX and Windows. Oracle Certified Professional with fifteen years DBA experience on Oracle and SQL Server. Twelve years UNIX experience on Solaris, AIX, HP-UX and LINUX.

• Campus Solutions 8.9, 9.0
• Enterprise Learning Management 8.9, 9.0, 9.1
• PeopleTools, Crystal, PeopleSoft Query, SQL, Security, Workflow, Process Scheduler, Weblogic, Tuxedo installation, Application Engine, nVision, XML, Integration Broker, COBOL, PeopleCode, Developer

Oracle Technical Skills

Confidential, PeopleSoft Oracle DBA

• Improved the performance of several critical PeopleSoft Campus solutions processes including a customized GL Interface and Credit History processes.
• Analyzed processes and overall performance of processes using Oracle Automated Workflow Repository. This resulted in the elimination of custom indexes which were hurting performance.
• Created stored execution plans to improve performance of poorly executing sql queries.
• Built Linux/Oracle RDBMS 11g servers and migrated Production and Test databases to new servers using Oracle replication methods.
• Used RMAN duplication process to replicate Production database for a standby failover database environment
• Provided production support and managed several Oracle Service Requests to resolve issues in PeopleSoft environments.

Confidential. PeopleSoft Administrator

• Managed complete suite of internal PeopleSoft environments on Windows Servers.
• Managed environments on VMWare virtual servers.
• Applications managed include PeopleSoft FSCM, HCM, ELM, Portal, EPM and CRM.
• Responsibilities include installation of environments as well as applying all patches as they become available and upgrading environments as new versions become available.

Performed technical upgrades across entire PeopleSoft Suite of applications

Confidential Upgrade Specialist

• Assisted on technical upgrade from PeopleSoft FSCM 9.0 to 9.2 using PeopleSoft Change Assistant and PeopleSoft Update Manager.
• Installed, configured and managed updates using PeopleSoft Upgrade Manager PUM
• Provided tuning expertise of queries and nVision reports.
• Analyzed Compare Reports and provided advice on determining upgrade actions of customized objects.
• Researched data issues between PeopleSoft Commitment Control and documents in Purchasing, Accounts Payable, General Ledger and Travel Expenses.
• Performed testing scenarios to replicate cause of issues in these modules and managed the Oracle Support Service Requests through the development, testing and implementation phases.
• Provided delivered solutions as well as scripts to correct data issues
• Created and analyzed Requisitions, Purchase Orders, Receipts, Vouchers, Journals, Travel Authorizations and Expense Reports in test environments to replicate issues occurring due to extreme volume in New York's Statewide Financials System
• Applied code changes for bug fixes and performed unit testing of PeopleSoft provided solutions.

Confidential, Senior Technical Consultant

• Assisted with design and development of customizations to meet business requirements of PeopleSoft FSCM environment.
• Executed Integration Testing scripts for modules of Grants and Project, General Ledger and Procure To Pay modules.
• Authored Administration guides to assist in the management of PeopleSoft application after deployment.

Confidential, PeopleSoft Administrator/Technical Consultant

• Assisted in the installation of PeopleSoft FSCM 9.1, HCM 9.1, EPM 9.1 and Portal 9.1 with PeopleTools 8.52 environments.
• Trained staff in installation and configuration of PeopleSoft software and environment administration.
• Helped configured Portal environment to integrate with FSCM environments using PeopleSoft Integration Broker and installed and configured Change Assistant software.
• Advised on each phase of FSCM, HCM and Portal upgrades.
• Assisted with management of PeopleSoft databases on MS SQL Server.

Confidential, Technical Lead Upgrade Specialist

• Assisted client in the administration of 24 PeopleSoft FSCM 8.9 and 9.1 environments
• Performed technical and functional upgrade tasks for PeopleTools 8.49 to 8.51 and Financials 8.8 to 9.1 upgrade.
• Performed EPM 9.1 demo database install and technical and functional upgrade tasks for EPM 9.0 to 9.1 upgrade.
• Created and co-authored several project deliverable documents including Environment Management Plan, Development Standards Document, Conversion Plan and Development Freeze Plan Document.
• Assisted in management of 24 Oracle 11g databases, performing replication, backup and recovery and performance tuning tasks.
• Performed tuning of long running queries and reports.
• Managed team of developers through technical design and development of solutions to clients interface, gap, conversion, and reporting requirements.
• Researched and resolved issues encountered by functional team during configuration and testing tasks.
• Conducted analysis of Compare Reports to provide recommendations for the retention or removal of existing customizations based on requirements after Financials upgrade.
• Performed manual and automated technical upgrade tasks as per upgrade template in PeopleSoft Change Assistant.
• Managed customizations through the development lifecycle using Quest STAT.
• Developed customized solutions to meet clients' business needs.
• Provided planning and technical support during upgrade of Oracle database, PeopleTools and FSCM application of Maintenance Packs after initial FSCM upgrade.

Confidential, Sr. PeopleSoft Solutions Architect

• Using PeopleSoft Query, PeopleSoft Application Engine, and Crystal Reports, developed several Grants and Billing Invoices for client.
• Authored technical design documents and assisted with creation of functional design documents for various Application Engine and Billing Invoice implementations.
• Providing technical support during DB2 to Oracle conversion of PS FSCM environments.
• Developing Application Engine programs for conversion of PS FSCM environments from DB2 to Oracle.
• Providing technical, database and functional support during PS HCM implementation.
• Providing support with implementation of PS security.
• Performing database tuning to optimize database performance.

Confidential, Sr. PeopleSoft Solutions Architect

• Assisted client staff in performing tasks related to FSCM 8.8 to FSCM 9.0 upgrade in PeopleSoft Change Assistant.
• Performed troubleshooting of issues that occurred during performance of upgrade tasks and developed retrofit of client Customizations to work with upgraded version of applications
• Developed scripts to analyze and determine corrections needed to fix data issues with Requisitions, Purchase Orders, Vouchers and Receivers.

Confidential, Technical Lead

• Led technical effort on installation, implementation, and administration of LINUX, Oracle RDBMS and PeopleSoft Enterprise Performance Management application.
• Assisted in administration of PeopleSoft EPM environments.
• Trained client staff in Oracle database management and PeopleSoft environment administration.
• Applied PeopleSoft maintenance packs and patches.

Confidential, Technical Lead

• Led the development of a custom developed Application Engine program to capture pertinent information from Purchasing and Accounts Payable modules to determine the appropriate status and remaining dollar amounts.
• Conducted extensive research and analysis of the functional and technical PeopleSoft delivered functionality to assess and determine the appropriate corrective action for these modules.
• Provided technical and data analysis and consultation for the Data Archiving project. Provided technical and data analysis for the Purchase Order and Requisition reconciliation efforts.
• Performed PeopleTools upgrades and trained the staff to perform upgrades using the PeopleSoft Change Assistant.
• Applied Maintenance packs to the PeopleSoft Financial environments using PS Change Assistant and installed the PeopleSoft Financials demo environment for PeopleSoft Certification.

Confidential, Senior PeopleSoft Solutions Architect

• Analyzed issues in the PeopleSoft eRecruit implementation, worked with Arizona Public Services APS technical staff and PeopleSoft support staff to resolve several technical issues to help the company meet go-live deadlines.
• Supported APS technical staff during go-live and post-go-live activities.

Confidential, Sr. PeopleSoft Solutions Architect

• Resolved issues in the clients Financials application.
• Developed custom solutions for the client for project activities.

Confidential, Sr. PeopleSoft Solutions Architect

• Analyzed and resolved several issues in Universities Campus Solutions application.
• Helped IT staff understand the different parameters in the Web Servers and Application Servers to fine tune their environments resulting in proper sizing of environments so that client did not need to purchase additional hardware to accommodate future application implementations.

Confidential, Technical Lead

• Analyzed, tested, and recommended fixes to resolve budget checking issues in PeopleSoft Commitment Control 8.8.
• Analyzed and recommended fixes to non-delivered COBOL program being used by customer.

Confidential,PeopleSoft Administrator

• PeopleSoft administrator, installed, configured, and maintained weblogic servers, application servers, and process schedulers for client's Financial, EPM and Portal environments for PeopleSoft Financials Implementation. Also completed the following:
• Performed complete PeopleTools upgrade using PeopleSoft Change Assistant. Implemented Application Messaging and Single Signon and installed Financials 8.9 and PeopleTools 8.47.
• Performed PeopleTools upgrade from 8.46 to 8.47 and FMS upgrade from 8.8 to 8.9. Applied several bundles and patches to FMS and EPM applications using PeopleSoft Change Assistant.
• Created and submitted to the client several technical design documents and addressed issues with documents through the client's documentation process.

Confidential, PeopleSoft Administrator

• Installed, configured and maintained weblogic servers, application servers, and process schedulers for client's HRMS environments for HCM PeopleSoft Upgrade. Other activities included:
• Performed complete PeopleTools and HCM upgrades through several iterations.
• Conducted extensive SQL and Application tuning in UNIX and Windows environments, as well as other routine database administration tasks.
• Trained the client staff in PeopleSoft server configuration and administration.

, Confidential, PeopleSoft Database Administrator

• During this project, installed, configured, and maintained weblogic servers, application servers, and process schedulers for the client's HRMS, Financial, Portal and EPM environments for Multi-suite PeopleSoft Implementation.
• Performed complete PeopleTools, HR and Financials upgrades as well as several Oracle 8i to 9.2 upgrades.
• Implemented application messaging, single Signon and report repositories in UNIX and Windows environments.
• Performed extensive SQL and application tuning to resolve performance issues. Performed configuration management tasks and migrated enhancements to the PeopleSoft applications through Quest Stat.
• Managed over one hundred and sixty Oracle and SQL Server databases for the client by writing, implementing and monitoring output of health check shell scripts.
• Consolidated Oracle/PeopleSoft HCM and FSCM environments into one environment.
• Supported batch-processing system in FSCM and HCM payroll and financials environments.
• Created and supported automated testing scripts for use with WinRunner and LoadRunner software testing tools.
• Performed upgrades to Business Engine time tracking application.
• Created and customized several Crystal, SQR and nVision reports as per client requirements.

Confidential,PeopleSoft DBA and Developer

• Provided Application Engine development support for the client's CRM implementation.
• Developed Application Engine programs to convert Contact and Opportunity data from Vantive to PeopleSoft CRM 8.4 for PeopleSoft Corporation.
• Responsible for resolving all data issues and tuning poorly performing SQL queries.

Confidential, International ,PeopleSoft Database Administrator

• Administrator for this project, installed and monitored 15 Oracle 8i databases in a 120,000 employee PeopleSoft HRMS payroll system implementation.
• Provided database administration tasks including implementing patches, task updates, and system upgrades in addition to performing database and SQL query tuning duties.
• Performed database backups and restores as the client deemed necessary.

Confidential, PeopleSoft Database Administrator

• Provided database administrator support for twenty Oracle 8i later upgraded to 9i databases and PeopleSoft HRMS Payroll implementation. Other responsibilities included:
• Installed PeopleSoft components including Client Tools, Application Servers, Process Schedulers, Tuxedo, Jolt, and Weblogic.
• Created backup real-time support databases, performed all backup and restore procedures using database cloning and inbuilt database technology.
• Performed various upgrades, applied patches and tax updates, and maintained the client's PeopleSoft security.

Confidential., Software Consultant

• While supporting the client's implementation by providing Oracle DBA support for various sites, provided SQL tuning and database administration, and created automated tasks to simplify database and software implementation.
• Developed Oracle user documentation for client sites and created ad hoc queries for system data requests.
• Created, managed, and implemented remote Database Administration initiatives at customer sites.