SUMMARY:

• Confidential has over 20 years of Information Technology experience including 16+ years of PeopleSoft HCM, Financials, and CRM implementations.
• He has worked on PeopleSoft versions 7.0 - 9.2 in positions including System Architect, Infrastructure Lead, PeopleSoft Upgrade Specialist, PeopleSoft System Administrator, Oracle DBA, and PeopleSoft/Oracle Performance and Tuning expert.
• Senior PeopleSoft Architecture and Infrastructure Technical Consultant.
• Experience with all aspects of the PeopleSoft architecture up to PeopleTools 8.55.
• PeopleSoft Upgrade experience up to PeopleSoft 9.2 and PeopleTools 8.55.
• PeopleSoft experience includes PeopleSoft Online, Batch, and reporting architecture including Application Designer, Application Engine, Internet Architecture (PIA), PeopleSoft Security, Component Interface, and Integration Broker.
• Certified Oracle DBA with experience on UNIX, Linux, and Windows platforms.

TECHNICAL SKILLS:

• PeopleSoft
• Upgrades
• Interface/Conversion
• PeopleSoft Internet Architecture
• Installs
• Websphere/WebLogic
• LDAP Single Signon - SiteMinder
• Server Administration
• Application Engine
• Integration Tools (Component Interfaces, Integration Broker)
• Report Manager
• Application Sever
• Security
• CRM Online Marketing
• CRM BAM Server
• PeopleSoft Performance Monitor
• Application Designer
• Workflow
• PS Query
• Style Sheets
• Change Control
• Configuration Manager
• PeopleCode
• SQR
• Install Utility
• Database Setup Wizard
• Tuxedo (tmadmin)
• PSADMIN
• BEA WebLogic Console
• Process Scheduler
• Process Monitor
• Report Manager
• Application Designer Upgrade Tools
• Compare Reports
• Data Mover
• Upgrade Assistant
• Change Assistant
• Security Administration (HR, CRM, Financials)
• PeopleSoft Directory Interface (LDAP Interface)
• Single Signon
• HPUX
• AIX
• Solaris
• Windows (all)
• Oracle 6, 7.x, 8i, 9i, 10g, 11.x
• Sybase 4.92, 10.x, 11.x, 12.x
• SQL Server 6.5, 7.0, 2000
• DB/2
• Java/J2EE: Java Servlets, Java Beans, JSP, Enterprise JavaBeans, SOAP, Oracle JServer, Oracle JDBC (OCI8 driver, Thin driver, Server-Side), SQLJ, RMI, CORBA
• XML: DTD, DOM, Xpath, XSLT, Oracle XML Parser, Oracle XSLT Processor, XSQL, Oracle PL/SQL XML Parser, Cascading Style Sheets
• Perl: Oracle DBI and DBD
• ASP
• HTML
• Korn Shell
• C Shell
• Visual Basic
• C / C++
• PowerHouse
• SAS
• Natural (v.2)
• Miranda
• LISP
• PROLOG
• REXX
• CLIST
• DCL(VAX)
• JCL
• COBOL/2
• BEA WebLogic
• WebSphere
• Apache
• Oracle Application Server iPlanet
• JRUN
• Tomcat
• Microsoft IIS
• Tuxedo
• OCI
• Open Client/Open Server
• CICS
• ERWIN
• Rational Rose (UML)
• KnowledgeWare ADW Analysis and Design Tools

PROFESSIONAL EXPERIENCE:

Confidential

Senior PeopleSoft Administrator

Responsibilities:

• PeopleTools 8.55.05 Upgrade.
• PeopleSoft 9.1 implementation project for HCM, FIN/SCM, ELM, CRM, and Portal on PeopleTools 8.53.
• PeopleSoft 9.1 to 9.2 Upgrade Project.
• Installation of PeopleSoft HCM 9.2, FIN 9.2, CRM 9.2 on PeopleTools 8.54 for Upgrade project.
• Installation of Oracle VirtualBox, PeopleSoft 9.2 PUM PeopleSoft Instances for PeopleSoft applications on PeopleTools 8.54.
• Installation and configuration of PeopleSoft Interactive Hub 9.1 and associated Content Providers.
• Installation and administration of PHIRE Change Management including Domain and Workflow setup along with associated Security setup. Upgrade of PHIRE from 9.1 to 10.2 followed by 10.2 to 11.1.
• Installation and configuration of SCM Mobile Inventory.
• Installation and configuration of CRM DES server for Online Marketing Surveys.
• Payroll performance tuning.
• Installation and configuration of SCM eSupplier Portal Pack.
• Load Runner performance testing and sizing the HCM production environment for 3000 concurrent Open Enrollment users.

Environment: PeopleTools 8.53, 8.54, 8.55, Oracle 11g, Oracle 12c, RHEL 5.5, Phire 9.1, 10.2, 11.1

Confidential

Senior PeopleSoft Administrator

Responsibilities:

• Senior PeopleSoft Administrator for PeopleSoft HCM 9.1 and Financials 9.1 applications.
• Installed and configured complete PeopleSoft environment on a Virtual host in preparation for PeopleTools upgrade projects.
• Financials PeopleTools upgrade to 8.53.04.
• HCM PeopleTools upgrade to 8.53.11
• Assessed overall Architecture and redeployed web servers, application servers, and process schedulers to new hardware configuration.
• Application of HCM Maintenance Packs, HR Bundles, and Tax Updates for 2013 and beginning of 2014 (14A and 14B).
• Integration broker configuration for external node integration.
• Performance tuned PeopleSoft Time and Labor process, batch Leave Accrual process, and PayCalc process.

Environment: SQL Server 2008, PeopleTools 8.51, 8.52, 8.53, Windows Server 2003, 2008, 2012.

Confidential

PeopleSoft Technical Architect/PeopleSoft Upgrade Expert

Responsibilities:

• Completed an overall architecture road map for Confidential ’s PeopleSoft /Oracle database data center migration including the implementation of new QA and Production level hardware as well as the implementation of a new Disaster Recovery data center.
• Documented a PeopleTools 8.50 to 8.52 upgrade approach and road map incorporating the new data centers and hardware for PeopleSoft 9.0 HCM, CRM, and EPM applications. Provided Technical Architecture expertise to create an overall migration/upgrade project plan.
• Supplemented PeopleSoft Administration staff by performing the PeopleSoft CRM PeopleTools 8.52 upgrade and documenting the process. Worked with Oracle support to resolve minor issues encountered during the upgrade.
• Implemented and documented procedures to leverage Oracle SQL Plan Management feature to minimize a performance impact to production systems post Oracle 11g upgrade.
• Performed an overall technical architecture assessment of the HCM, CRM, and ELM PeopleSoft 9.0 applications at Confidential Group. Made infrastructure/architecture and tuning recommendations where appropriate.
• Provided performance tuning for the PeopleSoft Time and Labor process, PayCalc, and several Confidential developed processes including a large custom-built Application Engine data conversion process. Documented the methodology and provided training to Confidential full-time staff.
• Installed and configured the PeopleSoft Performance Monitor and developed customized SQL routines to enable pro-active notification of performance issues.
• Helped the Confidential Group Infrastructure team build an Oracle 11g and PeopleTools 8.53 upgrade assessment for presentation to IT management. Advised Confidential on upgrade procedures keeping performance considerations in mind and providing online and batch performance stability.

Environment: Oracle 10.2.0.4, PeopleTools 8.50.21; Linux 5.6; Windows Server 2003

Confidential

PeopleSoft Infrastructure Expert

Responsibilities:

• Provided PeopleSoft Infrastructure expertise for a PeopleSoft HCM 9.1, CRM 9.1, and Portal 9.1 Upgrade project involving close cooperation with several international Confidential organizations and partners.
• Infrastructure Expert tasks summary:
• Coordinated Project Infrastructure activities among several international teams in India, Brazil, and Malaysia.
• Worked with Linux, Windows Server, and Hardware teams to size, install, and configure PeopleSoft HCM 9.1, CRM 9.1, and Portal 9.1 environments on PeopleTools 8.51.
• Worked with an Oracle Performance Engineer to size and configure the production environments to meet the needs of 2000+ PeopleSoft users.
• Performed Maintenance Pack updates for HCM and CRM environments and coordinated update activity with Functional and Development teams.
• Provided PeopleSoft and Oracle Performance Tuning expertise throughout the development, integration and acceptance testing, and performance testing project phases.
• Interfaced with the Confidential Control-M Administration team to coordinate setting up automated administrative Infrastructure tasks through Control-M job scheduling.
• Wrote Linux based korn shell administrative scripts and defined Control-M jobs to automate the script processing.

Environment: Oracle 11.2, PeopleTools 8.51; Linux; Windows Server 2008.

Confidential

PeopleSoft Infrastructure Expert

Responsibilities:

• Role consisted of supporting numerous ongoing projects for PeopleSoft Financials 8.9, HCM 9.0, CRM 8.9, and Portal 9.0.
• Infrastructure Expert tasks summary:
• Helped client to plan and implement Infrastructure teams roles and responsibilities.
• Responsible for sizing and planning upcoming platform migration to Linux.
• Worked with Development/Database/PeopleSoft Admin team to design a strategy for the role out of Quest Stat 5.5.1 for the HRMS environment.
• Administered Stat security - Users, Connections, and Agents.
• Created and modified Stat CSR templates, Work Queues, Workflows.
• Wrote UNIX scripts to automate PeopleSoft domain maintenance.
• Wrote UNIX and Visual Basic scripts to automate nightly file purge processing.
• Designed and documented Disaster Recovery procedures for the PeopleSoft Financials environment.

Environment: Oracle 10.2.0.3.0 , 10.2.0.4.0 ; PeopleTools 8.49; AIX 6; Windows Server 2003 R2.

Confidential

Lead PeopleSoft/Oracle Performance Tuning Expert

Responsibilities:

• Provided expertise in PeopleSoft and Oracle Performance Tuning for a PeopleSoft Financials 9.0 implementation with interfaces from PeopleSoft HR 9.0. Provided performance expertise for all aspects of System architecture, online, and batch performance considerations for a PeopleSoft 9.0 Financials implementation.
• Performance Tuning tasks summary:
• Worked with Functional experts to data map functionality from existing legacy system into PeopleSoft 9.0 Financials functionality with performance considerations in mind.
• Batch and Online Performance tuning plan and testing strategies.
• Procedures and team training of existing database staff to support ongoing performance considerations.
• Environment tuning and optimization for Oracle RAC, PeopleSoft, and UNIX architecture components.
• Mock-up data analysis for data volumes/distributions with business experts.
• Programmed table-driven PL/SQL routines to build and load mock-up data.
• Performance-tuned PeopleSoft online pages from Online Load testing, Oracle AWR reports as well as End-User feedback during testing cycles.
• Performance tuned PeopleSoft batch for the following batch stream processes:
• Account Payable - Voucher Load, Voucher Build, Budget Check, PC AP TO PC, etc.
• Accounts Receivable/BI - AR PAYLOAD.
• Purchase Orders - Auto sourcing (PS AUTO SRC).
• Asset Management - AM DEPR CALC.
• Project Costing - Journal Edit, Budget check (FS BP), Journal Post, PC GL TO PC.
• Payroll to Finance GL (PeopleSoft HR 9.0) - FS JGEN, GL JEDIT, GLPPOST.
• Time & Labor to Project Costing - Publish Payable Time, Process Actuals (PC TL TO PC).
• Complete Performance Tuning deliverable and documentation.

Environment: Oracle RAC 11.1.0.7.0 ; PeopleSoft Financial/SCM 9.0; PeopleTools 8.49.24; SunOS 10.5.

Confidential

Senior PeopleSoft System Administrator/Performance Tuning Expert

Responsibilities:

• Provided PeopleSoft Infrastructure expertise for a PeopleSoft CTI implementation followed by Oracle/PeopleSoft performance tuning for a PeopleSoft Time and Expense implementation.
• PeopleSoft CTI Implementation:
• Worked with several Ohio state agencies to architect, design, and implement a Telephony solution across several agency boundaries including functional, database, network, data security, and agency support.
• Complete Oracle 10.2.0.4.0 database installation/configuration.
• Complete PeopleTools 8.49 installation with PeopleTools patch 8.49.19.
• Complete PeopleSoft CRM 9.0 installation/configuration including MP 8.
• Installed and configured PeopleSoft CRM 9.0 MCF for Cisco CTI/AMC Adapter.
• Configured PeopleSoft REN server for MCF/CTI.
• Designed clustered REN servers behind a RPS (Reverse Proxy Server) for failover and scalability.
• Enabled PeopleSoft REN server to work over SSL.
• PeopleSoft Travel and Expense performance tuning:
• Wrote Oracle PL/SQL batch routine to load T&E test data .simulating 240,000 travel approvals and expense sheets.
• Worked with Load Runner expert to test and tune PeopleSoft online performance.
• Batch tested the following PeopleSoft batch processes:
• Employee Profile Load (EX EE UPDATE).
• Automatic Role Assignment DYNROLE PUBL TE).
• Budget Check (FSPXBDP3) - Reduced from 6 hours to 15 minutes.
• Request Expense Processing/Expense Processing (EX TRANS PRCS).
• Pay Cycle Processing (AP APY2015).
• Journal Generation (FS JGEN).
• Employee Notification (EX EMPNOTIFY) - Reduced from 90 minutes to less than 2 minutes.

Environment: Oracle 10.2.0.4.0 ; PeopleTools 8.49.19/ CRM 9.0; PeopleTools 8.46.05 / FIN 8.8; HPUX 11.23, Windows 2003 Server R2, Windows XP.

Confidential

PeopleSoft Upgrade Expert

Responsibilities:

• Provided PeopleSoft upgrade experience with an emphasis on Oracle performance concerns. Provided PeopleSoft experience to DBA support team.
• PeopleSoft Financials upgrade from 8.8 to 9.0.
• PeopleSoft HRMS upgrade from 8.8 to 9.0.
• Upgraded Oracle OEM to 10.2.0.4 release for several AIX and Linux environments.
• PeopleSoft security scripts to merge security from two separate PeopleSoft environments.
• Provided scripts to convert data in tables from a LONG data type to a CLOB data type.
• Tuned numerous PeopleSoft custom queries.

Environment: Oracle 10.2.0.4; PeopleTools 8.49.11; AIX 5.3, Linux 4, Windows XP

Confidential

Lead Oracle/PeopleSoft Close Processing Center Architect and Performance Expert

Responsibilities:

• Responsible for architectural design of a Close Processing Center for month-end and year-end financial processing with a heavy emphasis on performance considerations.
• Responsible for tuning numerous PeopleSoft Financial components including the following:
• PeopleSoft Allocations tuning involving 20+ million allocation result sets.
• Month-End/Year-End Application Engine and COBOL closing processes including:
• Equitization
• Consolidations
• Year-End Close (GLPCLOSE)
• PeopleSoft Edit processes including:
• Edit
• Combo Build
• Combo Edit
• Post
• Front-End performance issues.
• Running PeopleSoft and Oracle traces and tuning PeopleCode SQL.
• Batch job loading plus Informatica ETL loading routines.
• Overall Oracle database sizing and tuning for both partitioned and non-partitioned parallel jobs.
• Established developer tuning guidelines and procedures.
• Optimizing ETL loads to database warehouse databases.
• Planning and optimizing Hyperion Essbase ETL routines.

Environment: Oracle 10g, 11g; PeopleSoft Financial/SCM 9.0; PeopleTools 8.48.13; Hardware: AIX, Windows XP.

Confidential

Infrastructure Lead

Responsibilities:

• Administered an HRMS 8.9/8.46 system as well as an 8.4/8.19 Financials system.
• Created new PeopleSoft environments including the database, application servers, process schedulers, web servers (load balancing), environment hub, and PeopleSoft Change Assistant.
• Planned and implemented Performance Monitoring procedures:
• Installed and configured PeopleSoft Performance Monitor.
• Developed database performance monitoring routines with automated performance alerts.
• Created post-environment refresh scripts to automate monthly environment refresh routines.
• Resolved several PeopleSoft Payroll related performance issues.
• Documented Report Repository purge procedures.
• Documented Integration Broker failover and scalability procedures.

Environment: Oracle 9.2 on Sun Solaris; PeopleSoft Application Servers, WebLogic web servers hosted on Windows NT.

Confidential

Senior PeopleSoft Administrator

Responsibilities:

• Technical lead for PeopleSoft HRMS 8.3/8.19 TO 8.9/8.47 upgrade project.
• Installed HRMS 8.9/8.47 PeopleSoft environment for HRMS 8.3/8.19 upgrade project in preparation for environment certification.
• Installed and configured PeopleSoft Environment Management Hub and Change Assistant for post installation updates as well as the HRMS upgrade template/job.
• Ran several ‘Move to production’ upgrades to completion including final production run.
• Technical lead for interfacing with Confidential ’s corporate security team to integrate the PeopleSoft environment with the IBM Tivoli WebSEAL security policy server.
• Installed SSL on existing WebLogic 5.1 web servers as well as the new WebLogic 8.1 web servers.
• Installed PeopleSoft Performance Monitor for new 8.47 PeopleTools environments.
• Designed and implemented automated production performance procedures.

Environment: AIX 5.3 for database, web server, application server, and UNIX process scheduler; Wintel machines for the NT process scheduler

Confidential

PeopleSoft Performance Tuning Expert

Responsibilities:

• Hired to resolve performance issues associated with month-end and year-end financial periods.
• Performed overall PeopleSoft architecture review for Financials /SCM 8.4 on PeopleTools 8.4.3.
• Planned and sized a new Financials architecture that would address Expedia’s growing environment and performance demands.
• Tuned existing PeopleSoft Queries, nVision reports, and Application Engine programs.
• Reduced an nVision report book runtime from 12 hours to 1 hour.
• Worked with DBA team to plan and implement database migration from Windows 2000 to Windows 2003 Advanced Server.

Environment: SQL Server 2000 on Windows 2000 and Windows 2003 Advanced Server; all PeopleSoft components on Windows 2000.

Confidential

PeopleSoft Administrator

Responsibilities:

• Technical lead for a hardware migration project.
• Migrated production web servers from an NT environment to UNIX Sun Solaris.
• Installed PeopleSoft Performance Monitor for performance benchmarks and trouble shooting on PeopleTools 8.45 for recently upgraded 8.9 Financials system.
• Upgraded Unicenter Autosys Job Management software for PeopleSoft 8.8 Financials on PeopleTools 8.45.
• Installed and configured HRMS 8.3 environment on PeopleTools 8.19.
• Assisted with Disaster Recovery planning, implementation, and testing for newly upgraded PeopleSoft 8.8 Financials system.

Confidential

PeopleSoft Administrator/Oracle DBA

Responsibilities:

• Administered an environment of over 50 PeopleSoft databases including PeopleSoft HRMS, CRM, and Financials on both Informix and Oracle.
• Worked on the Oracle DBA team at this site supporting 150+ Oracle databases including installation of Oracle Software, creating and configuring new database instances, RMAN backups, and Oracle performance and tuning.
• Technical Upgrade lead for Fairchild's upgrade of the existing Financials system from Informix to Oracle.
• Installed numerous SYS and DMO PeopleSoft environments including CRM 8.9 PeopleSoft Online marketing and BAM server.
• Performed PeopleTools upgrades for several environments and PeopleTools versions.
• Upgrading RDBMS environments from Oracle 8.1.7.4 to Oracle 9.2.0.4.
• Installed and configured PeopleSoft Performance Monitor.
• Created and maintained numerous Oracle databases in both Oracle 8i and Oracle 9i for CRM, HRMS, and FDM environments.
• Worked with Control-M Enterprise Manager batch scheduling software and developed Korn Shell automating administrative tasks.
• Performance tuned using BMC Patrol Central 7.1 as well as both HPUX and Oracle tuning utilities.
• Tuned numerous PeopleSoft N-Vision reports.

Environment: CRM 8.4 (PeopleTools 8.42), CRM 8.9 (PeopleTools 8.45); HRMS 8.3 (PeopleTools 8.43); FDM 7.07 - Informix, FDM 8.4 (PeopleTools 8.41), FDM 8.4 (PeopleTools 8.44); Oracle 8i, 9i, and 10g on HPUX; Windows 2000.