We provide IT Staff Augmentation Services!

Peoplesoft\oracle Dba Resume

4.00/5 (Submit Your Rating)

MilwaukeE

SUMMARY:

  • 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.
  • Training & Development
  • Complex Upgrades
  • Needs Assessment
  • Customizations
  • Integration Testing
  • Client Management
  • Leadership
  • Conversions
  • Problem Analysis/Resolution
  • 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.

TECHNICAL SKILLS:

PeopleSoft Technical Skills: FMS 8.0-8.9, 9.0, 9.1, 9.2 eProcurement, T&E, General Ledger, Accounts Payable, Purchasing, Receiving, Workflow, Commitment Control, Projects, Grants, Contracts, Billing, Procure To Pay, Asset Management, SCM 8.0-8.9, 9.0, 9.1, 9.2

Billing, Inventory, Project Costing: HCM 8.0-8.9, 9.0, 9.1, 9.2, Payroll, Benefits, eRecruit, HR, Self-Service HR, Time & Labor, CRM 8.0 - 8.9, 9.0, 9.1

Sales Management System, Help Desk: EPM 8.9, 9.0, 9.1, Financials Warehouse & Marts, HCM Warehouse & Mart, Ascential Datastage, Budgeting, 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

Technical Process: Upgrades and application of Maintenance Packs using Upgrade Assistant, Change Assistant and PeopleSoft Update Manager, Integration Broker and Application Messaging, DataMover, Project Migration, Tax Updates, Patches and Fixes, Security Administration 7.6 - 9.2., PS Finance and Maximo Integration

Business Process: Purchasing, Accounts Payable, General Ledger, Commitment Control, Travel and Expenses

Database Administration Experience: SQL Server 6.5, 7.0, 2000, 2005, Oracle RDBMS 7.3, 8.0, 9.2, 10g, 11i, DB2/UDB, Sybase, Microsoft Access

Upgrades and Conversions: Database Administration Oracle 7.2 - Oracle 11i, SOA Oracle 10g, 11g Fusion Middleware, Oracle Recovery Manager (RMAN), PL/SQL

Industry Experience: Federal, State and Municipal Government, Transportation, Financial Services, Manufacturing, Service Industry, Medical Services, Higher Education, Healthcare, Leisure, Telecommunications, Energy

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee

PeopleSoft\Oracle DBA

Responsibilities:

  • 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

Responsibilities:

  • 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

Senior Technical Consultant\Upgrade Specialist

Responsibilities:

  • 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
  • Applied code changes for bug fixes and performed unit testing of PeopleSoft provided solutions.

Confidential

Senior Technical Consultant

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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, Phoenix, AZ

Senior PeopleSoft Solutions Architect

Responsibilities:

  • 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

Responsibilities:

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

Confidential

Sr. PeopleSoft Solutions Architect

Responsibilities:

  • 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

Responsibilities:

  • 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\DBA

Responsibilities:

  • 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\Upgrade Specialist

Responsibilities:

  • Installed, configured and maintained weblogic servers, application servers, and process schedulers for client’s HRMS environments for HCM PeopleSoft Upgrade.
  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

PeopleSoft Database Administrator

Responsibilities:

  • 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.

We'd love your feedback!