Sr. PeopleSoft Technical Consultant Resume Profile Boston, MA - Hire IT People

TECHNICALSKILLS:

ORACLE 7X - 11G Performed oracle upgrades of all servers including widows and AIX L-pared .
Set up R-man backup - recovery systems as both stand alone and as part of CommVault enterprise backup - recovery system.
Tuned all oracle instances at the database, storage, and sql level. Made heavy use of TKPROF to identify problem statements.
Implemented Dataguard to set up a reporting server.
Performed numerous database refreshes, usually 2 per week, utilizing both Datapump and R-man.
Used SQLLoader to to load data into archival data from legacy system being discontinued.
Set up RAC as proof of concept on AIX servers.
Utilized OEM to monitor and help tune database instances. Utilized Datapump to move tuning enhancements between databases. Also used OEM to schedule Oracle jobs. Set up health checks and reports using OEM,
PeopleSoft 7 - 9.X Both FINancials and HCM environments.
PeopleSoft - PeopleTools Upgrades: Instrumental team member of all upgrade projects. Performed database backups as indicated by Upgrade Assistant. Modified database memory parameters to accommodate long running processes, often put tables in parallel mode to facilitate loading, modified scripts that could be run in parallel, and ran directly on the server. Ran numerous DataMover scripts as part of the upgrade project. Built temporary indexes as needed for performance issues
PeopleSoft tuning: Utilized Application Developer to find and modify PeopleDode that was identified as performance issue. Performed numerous traces on Application Server to identify performance issues. Used Process Monitor to identify process scheduler jobs that were going to error. Modified Application Engine to add hints to use specific indexes.

EXPERIENCE:

Confidential

Sr. PeopleSoft Technical Consultant

Implemented Oracle Internet File System with Oracle 9I, used to store policies procedures for the entire health system.
Designed Disaster Recovery Program with twice yearly testing of each system to comply with external auditing requirements Also provided complete step by step documentation along with check off list that could be followed by someone only familiar with Oracle in event that DBA was not available due to disaster, vacation, etc.
Performed twice yearly disaster recovery tests at external recovery site.
Completed installation upgrades to PeopleSoft databases and applications serving 13 hospitals served by TEMPLE UNIVERSITY HEALTH SYSTEM.
Managed over 20 environments to support both FINancial and HR services across the entire health system of 5,000 users.
Performed cross platform migration of FIN environments from Digital True64 Unix environment to AIX platform along with a database version upgrade .
Performed cross platform and database conversion from Sybase on HP-UX platform to Oracle on AIX.
Implemented Oracle Data Guard to create reporting environment on development server from production environment.
Migrated legacy flat file database to Oracle using SQLloader.

Confidential

Sr. PeopleSoft Technical Consultant

Compaq Multiprocessor 4 servers, Windows NT Server as both DB Server and App Server, Win95 clients PeopleSoft Public Sector Financials V6 Oracle 7.X 8.X.
Performed on-going database tuning, identified tables that would benefit from Oracle parallel query option. Modified Application Engine to perform a complete rollback on error. Worked extensively with explain plans generated from cobol pgms, sqr reports, application engine pgms, nvisions to optimize use of indexes.
Conducted class for sqr programmers - How to structure programs that make the best use of indexes.
Participated in upgrade project from Oracle 7.3 to 8.0
Helped troubleshoot and correct problems associated with E.D.I.
Performed extensive compare reporting to doccumment changes made to production that will need to be addressed during next upgrade. Also used this process to document differences between various environments.

IConfidential

Set up Oracle Enterprise Manager, re-compiled invalid packages, knowledge transfer to apply updates, helped with sizing for new server, reviewed and corrected bid specs for new server
Compaq Multiprocessor servers - MS-Windows NT Server, Win95 Clients PeopleSoft Private Sector Financials V6, SQL Server V6.X
Tuned Data Base - Indexing, Clustering, Multi-Threading, ODBC, etc.
Helped tune SQR reports, Crystal reports.
Resized tablespaces and datafiles to minimize fragmentation.

We provide IT Staff Augmentation Services!

Sr. Peoplesoft Technical Consultant Resume Profile

Boston, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship