SUMMARY:

• Expertise in implementing and upgrading of PeopleSoft applications, PeopleTools and Oracle databases to latest versions. Experience in implementing/redesign of Peoplesoft security until 8.56.
• Experience in Confidential and Confidential of PeopleSoft HCM 9.2, Financials 9.2, CRM 9.2, Campus Solutions 9.2, and Enterprise Portal 9.1.
• Expertise in Confidential of People Tools up to 8.56.
• Has worked extensively in integrating external systems using PeopleSoft Integration Broker, SOA and 3rd party vendors.
• Expert in design, install, end to end configuration & performance tuning of PeopleSoft Internet Architecture (PIA), Oracle databases and several platforms.
• PMP & ITIL Certified, trained Scrum Master is team oriented leader possessing excellent analytical, presentation & interpersonal skills.

TECHNICAL SKILLS:

ERP: PeopleSoft HCM 7.5/8.3/8.8/8.9/9.0 ,9.1,9.2 (HRMS/Benefits/Payroll/Time/Labor) & FSCM 7.5,8.4,8.9,9.0,9.1,9.2 (AR/AM/AP/BI/GL), CRM 8.4,8.9,9.0,9.1,9.2 Marketing 8.9, Sales & Support, Enterprise Portal 8.8,8.9,9.0,9.1

PeopleSoft Tools: People Tools 7.5/8.14,8.15,8.43,8.44,8.45,8.47.07,8.48,8.52,8.53,8.54,8.55 Change Assistant Assistant, PeopleSoft Update Manager, PeopleSoft Test framework, PeopleSoft Configuration Manager, PeopleSoft Performance Monitor, PeopleSoft Performance Tuning, Query Manager, Tree Manager, Application Designer, Data Mover

PeopleSoft Technologies: Oracle Secure Enterprise Search, PeopleSoft Mobile, PeopleSoft Interaction Hub, GreyHeller Firewall, ClamAV Virus Scan Engine, PeopleSoft Security, Peoplecode, Application Engine, Component Interface, Business Processes, Work Flows, Application Packages, SQR

Peoplesoft Security: Roles, Permission lists, Process Security, Query Security, Query Security, Row Level Security, Portal Security, Security Migrations, Definition Security, LDAP Authentication, Password Controls, Dynamic Role Creation, Single Sign - On, IDM, LDAP, Encryption Technologies

Databases: Oracle Security, TDE, OID&OAM, Oracle Cloud, Oracle 12c,11g,10g,9i,8i DBA, Oracle Exadata, RAC, OEM, RMAN(single instance and RAC), Oracle Data Pump, EMCTL, SRVCTL, DGMGRL, Export and Import Utilities, Oracle Net Manager, SQL Loader, Oracle Partitioning, VPD, PL/SQL, SQL*Plus, SQL Server, MySQL, MS Access, JDBC, ADO, OLEDB SQL, Informix

Methodologies: PMP, Agile Management, ITIL Expert, OOA, OOD

PROFESSIONAL EXPERIENCE:

Confidential, Chapel Hill, NC

PeopleSoft Consultant

Responsibilities:

• Created PeopleSoft Security Plan for PeopleSoft Applications as part of IT Security plan to tightening security.
• Experience working on Security Design, User Profile Setup, Role & Permission List Setup, Process Security, Query Security, Row Level Security, Portal Security, Security Migrations, Definition Security, LDAP Authentication, Password Controls, Dynamic Role Creation.
• Replaced existing Job based role design with new task based role design including assessment and redesign of permission lists and assign new roles to users.
• Setup PeopleSoft Single Sign-On for PeopleSoft Interaction hub, PeopleSoft LDAP authentication, integration with IDM.
• Used PeopleSoft Encryption Technologies to mask data i.e.: SSN, Credit Card information for PCI compliance.
• Implemented SSL for encryption of data involved in SOAP based Web Services and PeopleSoft Integration broker.
• Worked with PeopleSoft developers to customize sign-on Peoplecode for Dynamic Role assignment.
• Participate in Penetration testing and closely worked with PeopleSoft Support and Developers to fix the security issues.
• Good knowledge of Shibboleth and worked on integration of Shibboleth with Peoplesoft.
• Implemented vulnerability fixes for SSL certificates as needed.
• Proactive work on PeopleSoft system level and application security at all the layers from end-to-end (OS, Webservers, Application servers, Database, firewall and proxy) to tighten security.
• Worked on On/Off boarding, temporary access, analysis and resolution of security issues pre and post Confidential .
• Wrote SQL scripts to query PeopleSoft Security tables for security information. Communicate with security team to setup firewall rules for PeopleSoft Application to interact with third party.
• Scrambled data after production refreshes to protect data in non-production environments.
• Ran Initial Pass, Trail MTPs for PeopleSoft application Confidential for HCM 9.1 to 9.2.0.16, FSCM 9.1 to 9.2.0.16, ELM 9.2 to 9.2.0.11
• Downloaded and installed PeopleSoft Images HCM 9.2 Image 16, FSCM 9.2 Image 16, ELM 9.2 Image 11.
• Installed and Applied required at Confidential patches before Confidential, for data conversion and between upgraded passes. Applied required PRP’s to the Confidential source image.
• Downloaded and installed necessary Confidential Templates, Confidential documentation, Confidential scripts and Confidential Projects (UPGCUST & UPGOPT) necessary to run the Confidential . Used PUM to load source database info to Change Assistant, setup Confidential template and documentation in change assistant to run the Confidential .
• Ran the Confidential process using Change Assistant and delivered online browser based compare reports.
• Troubleshoot and fix issues with PeopleSoft Confidential and Data Conversion. Fine-tuned Data Conversion SQL scripts process to reduce time for running Confidential process.
• Applied Retrofits, Customizations, Patches, tax updates at the end of Confidential .
• Ran PeopleTools Confidential from 8.53.11 to 8. 55 for 12 0 different domains which were part of Non-production and Production environments.
• Installed and Configured WebLogic server 12c,Tuxedo application server 12.1, process schedulers, Master scheduler, NT schedulers, Integration broker in load balancing and high availability environments.
• Installed and Configured Micro focus COBOL compiler, Oracle XML publisher, N-vision reports
• Configured PeopleSoft Test Framework, REN server, Grey Heller firewall, Performance monitor.
• Setup, configure and install with Single Sign-On, PeopleSoft Interaction Hub. Install and Configure PeopleSoft Environment Management Hub, Agent and Viewer.
• Performed database refreshes and automated post refresh PeopleSoft steps.
• Played a major role in Production Go-Live, working closely with HR, Finance, Campus solutions and Portal Development Teams, Portfolio/Project management Team, Testing Team, Enterprise Systems Team, Networking and Security Team to successfully Go-Live with Connect Carolina Finance and HCM systems.
• Run Change Assistant for Confidential of PeopleTools from 8.48 to 8.53.11 for PeopleSoft FSCM 9.1, HCM 9.1, Campus Solutions 9.0, ELM 9.0 Enterprise Portal 9.1.

Confidential

Responsibilities:

• Redesigned and Configured High availability and load balancing for existing PeopleSoft Internet Architecture.
• Installed and configured WebLogic webservers, Tuxedo application server, Process schedulers, Master Scheduler, NT process schedulers on windows 2012, COBOL compilers, Crystal report server, N-vision reports, XML publisher.
• Installed and configured GreyHeller PeopleSoft application firewall, GreyHeller mobile, PeopleSoft Testing Framework, Oracle SES, REN server.
• Created a dedicated Integration Broker gateway as message volume was high and for ease of maintenance.
• Fine-tuned End-to-End PeopleSoft PIA architecture for performance based on load testing and upscaling architecture to support more than 50 00 concurrent users during special events.
• Fine-tuned Java heap size, JVM, Garbage collector settings to increase performance of Oracle WebLogic servers.
• Analyzed PeopleSoft traces, core dumps at application server-level, WebLogic logs, Oracle logs and for performance issues and fix the issue. Fine-tuned time-out parameters at WebLogic, tuxedo and database level.
• Install and Configure PeopleSoft Performance Monitor and performance metrics.
• Troubleshoot and fix slowness for PeopleSoft Menus, Components, Pages, AE programs using performance monitor.
• Tuned PeopleSoft Component, Pages, PeopleSoft applications servers and process schedulers for slow performance.
• Analyzed bad SQL at database level causing application slowness and fix it using SQL profiles, SQL indexes, running Oracle stats and rewrite query.
• Worked on Nagios monitoring, App Dynamics and Splunk for monitoring and troubleshooting.
• Configured load balancing architecture in Non-prod and Production environments to provide homogenous architecture and 24x7 availability.
• Configured settings for Process scheduler, Report Distribution and Purging, Integration Broker Message archiving. Fine-tuned to decrease time Integration Broker archiving messages and moved different archive messages to other database using transportable tablespaces.
• Integrated Open Source ClamAV virus scan engine software with 120 PeopleSoft domains. Setup Virus database to automatically update with latest viruses, malwares and worms.
• Design & implement high availability and load balancing for Virus scan engine and PeopleSoft REN server using iRules.
• Ran PeopleTools Confidential for PeopleSoft E-Pro systems from 8.48 to 8.53.11. Migrated PeopleSoft E-Pro from Solaris to RedHat Linux operating system to support company’s policies. Worked on integrating PeopleSoft systems with third party vendors using PeopleSoft Integration Broker for PeopleSoft HCM, FSCM, Campus and E-pro.
• Installed and configured SSL certificates from vendors to encrypt IB messages with third party vendors like HP, Staples, Airgas, Marketplace, PunchOut2Go, Roche University, LawLogix, Apple, Fastenal and also internal systems like ImageNow which use Webservices.
• Troubleshoot and fix issues with synchronous and asynchronous messages between UNC PeopleSoft systems working on IB Nodes, Channels, Routes, Pub/Sub processes.
• Implemented JMS target connector for PeopleSoft Campus solutions to send IB messages to IDM JBoss AS7 system.
• Configured and troubleshoot issues with PeopleSoft Interaction Hub and PeopleSoft Network Center.
• Setup PeopleSoft Home pages, Branding, Configure pagelets and develop iScripts as part of PeopleSoft Interaction Hub.
• Integrated PeopleSoft for LDAP authentication with Microsoft Active Directory.
• Worked on PeopleSoft Database refreshes and troubleshoot, fix, tune post refresh scripts as part of automation.
• Implemented Single Sign-On between PeopleSoft Enterprise Portal and FSCM, HCM, Campus Solutions.
• Created and Configured VIP’s on Big IP-F5 switches for load balancing of webservers and proxy servers while migrating servers, new architecture redesign and decommissioning of servers.
• Worked on Quest Stat workflows, User maintenance, Rapid Migration, Migration Recovery and automate file deployment through Stat. Supported Daily, On-demand and weekly production migrations.
• Downloaded and Applied quarterly tax updates to PeopleSoft HCM.
• Applied bundles, patches and fixes to PeopleSoft Campus Solutions, Finance and HCM systems as needed. Troubleshoot and fix issues with e-Forms of Gideon Taylor for PeopleSoft HCM.
• Maintain PeopleSoft Reporting environments for Campus, HCM, FSCM using Oracle Dataguard instances of production databases.
• Support PeopleSoft development team; troubleshoot and fix issues (run traces, troubleshooting at PIA level).

Environment: PeopleTools 8.48,8.53.11,8.55,8.56 PeopleSoft HCM 9.2, FSCM 9.2, Campus Solutions 9.0, ELM 9.0, 9.2 PeopleSoft Interaction Hub, Oracle WebLogic Server 11gR1 (10.3.6),12.1.3,Oracle Tuxedo 11gR1 (11.1.1.2.0 ),12.1.1, Oracle12c,Oracle Dataguard, RMAN, OEM 12c, Big IPF-5, Microfocus 5.1, N-vision, Crystal Reports,.Net framework 4, Red Hat Linux 6.0,Aix 5.7, Windows 2012

Confidential, Princeton, NJ

PeopleSoft Administrator/Oracle Consultant

Responsibilities:

• Hands of experience on Peoplesoft User profiles, Roles&Permission Lists, Process security, Query Security, Row-level Security, Portal Security, Security migrations, Password controls, Signon-peoplecode, Dynamic Role creation.
• Redesigned and simplified existing complex architecture of client's Peoplesoft security defining roles based on segment wise.
• Proactively worked on application hardening at all levels of PIA including OS, Network, Webserver, Application server, Process scheduler, Peoplesoft file server.
• Setup Peoplesoft Single sign-on for Peoplesoft Enterprises Portal, Peoplesoft LDAP authentication, integration with IDM using IIS.
• Implemented SSL for encryption of data involved in SOAP based Webservices and Peoplesoft Integration broker.
• Worked closely with Peoplesoft developers to customize sign-on peoplecode to assign roles dynamically.
• Automated the process of provisioning of users coming on-board and leaving using Peoplesoft Security, Workflow, Application engine and User profile component interface.
• Worked on regular security issues due to Peoplesoft refreshes, Production Access issues, Temporary production access support.
• Worked on Peoplesoft User security provisioning for teams of large size.
• Scrambling of data after production refreshes to protect data in non-production environments.
• Setup SFTP, SSH to secure file transmission coming in/going out of system through different interfaces

Confidential

Responsibilities:

• Planned for phases of Confidential process (Initial phase, Trial MTPs, MTP) and Go-live. Upgraded PeopleTools from 8.49.23 to 8.54.03 for HCM, FSCM, CRM as part of PeopleSoft Confidential . Upgraded PeopleTools 8.51.07 to 8.54.03 for PeopleSoft ELM 9.2.
• Downloaded Confidential scripts, templates, UPCONVERT project, required-for- Confidential bundles, fixes, updates from PeopleSoft Confidential Resource website.
• Installed Change Assistant and configured Confidential chapters for PeopleTools and application Confidential . Ran Confidential templates and data conversion scripts for all phases of Confidential .
• Installed/configured PeopleSoft demo database for HCM, FSCM, ELM 9.2 using PeopleSoft Demo images from PeopleSoft website.
• Provided online compare reports for developers during Confidential .
• Installed and configured PeopleSoft Update Manager to create change management packages to apply updates and fixes to upgraded environments.
• Fine-tuned SQLs and UPGCONVERT ( Confidential ) application engine programs to decrease data conversion time.
• Upgraded Oracle 10g RAC databases to 11g and installed Oracle 11g client for PeopleSoft Application, process scheduler and batch server. Installed and configured Oracle WebLogic Server 11gR1 webservers on IBM AIX 7 for Development, UAT, system, staging, pre-production and production environments.
• Install & configure PeopleSoft Enterprise portal 9.1; configured Single-SignOn between Portal, HCM, FSCM and CRM. Configured Enterprise Integration Points between HCM, FSCM, CRM.
• Install / configure PeopleSoft Integration broker, PeopleSoft Performance monitor, EM hub & agents and PeopleBooks.
• Worked on PeopleSoft Integration Broker to setup interactions with PeopleSoft Systems (synchronous and asynchronous messaging) and external third-party systems using web services.
• Planned and coordinated with network team for security of PeopleSoft Enterprise portal webservers using Cisco pix firewall and relocating to DMZ zone.
• Installed and Configured PeopleSoft Testing framework, Applicant Search Index for PeopleSoft HCM. Configured Oracle Secure Search on application servers for PeopleSoft HCM, ELM.
• Installed and configured SAP Crystal reports, N-Vision and Microfocus COBOL compilers.
• Setup and configure PeopleSoft Single Sign-On to provide content on portal from content providers.
• Clone and perform PeopleSoft refresh from production databases to PeopleSoft Dev, UAT, System testing, development environments using Oracle 11g RMAN.
• Setup Oracle 11g replication to replicate HCM reporting tables from HCM to FSCM database. Maintained Oracle 11g Dataguard standby databases for HCM and FSCM reporting needs. Installed and Maintained PeopleSoft webservers, application servers, process schedulers and logical standby database using Oracle 11g Dataguard at Disaster recovery site for PeopleSoft applications.
• Worked on PeopleSoft User profiles, Roles & Permission Lists, Process security, Query Security, Row-level Security, Portal Security, Security migrations, Password controls, SignOn Peoplecode, Dynamic Role creation.
• Redesign & simplify existing complex architecture of client's PeopleSoft security defining roles based on segment-wise.
• Moved data from prod to non-prod environments using Oracle data pump utilities, PeopleSoft Datamover.
• Worked on Oracle dynamic memory management techniques to resize SGA, shared pool, PGA and Oracle buffers.
• Worked on tuning SQL using Oracle indexing, hints, partitions, query-rewrite for better performance of PeopleSoft application and reports.
• Fine-tuned Global Payroll, Billing processes and batch process application engines, SQRs for better performance.
• Implemented archiving of historical payroll data using Oracle partitioning and PeopleSoft Archiving.
• Monitor and troubleshoot database for locks, bad SQL, temporary table usage and undo tablespace management.
• Plan & support PeopleSoft applications maintenance and downtime following change management procedures.
• Implemented SSL for encryption of data involved in SOAP based Webservices and PeopleSoft Integration broker.
• Worked on PeopleSoft Security at all levels of PIA including hardening OS, Webserver, Application server, Process scheduler, PeopleSoft file server.
• Setup PeopleSoft Single Sign-On for PeopleSoft Interaction hub, PeopleSoft LDAP authentication, integration with IDM. Setup SFTP, SSH to secure file transmission coming in/going out of system through different interfaces.
• Worked with PeopleSoft developers to customize sign-on Peoplecode to assign roles dynamically.
• Automated the process of provisioning of users coming on-board and leaving using PeopleSoft security, Application engine and User profile component interface.
• Worked on security issues due to PeopleSoft refreshes, Production Access issues, Temporary production access support.
• Redesigned the disaster recovery architecture for PeopleSoft applications to reduce downtime.
• Automated process to bring up PeopleSoft PIA on disaster recovery site using shell scripts. Documented procedures, steps needed for recovery of PeopleSoft application. Upgraded PeopleSoft tier on disaster recovery site to latest version.
• Worked on PeopleSoft migrations, change control and object locking. Participate in on call rotation and provided 24X7 support. Provide training to junior DBA/PeopleSoft Administrators and Security Administrators.

Environment: PeopleTools 8.53.02,8.54.03, PeopleSoft HCM, FSCM, CRM 9.0,9.2, Enterprise Portal 9.1, WebLogic Server 11gR1(10.3.6), Oracle Tuxedo 11gR1 (11.1.1.2.0 ), Oracle 11g, Oracle 11g RAC, Dataguard, RMAN, OEM, Cisco Load Balancer, Microfocus 5.1, N-vision, Crystal Reports,.Net framework 4, Aix 5.7,Windows 2008 SP2

Confidential, Boca Raton, Florida 

PeopleSoft Consultant

Responsibilities:

• PeopleSoft HCM, FSCM, CRM apps from 8.9 to 9.1, PeopleTools 8.47 to 8.52 Implement PeopleSoft Enterprise Portal 9.1.
• Support and Maintain PeopleSoft HRMS 8.9 and PeopleSoft Enterprise Portal 8.9 until go-live.

Confidential, Phoenix, AZ

PeopleSoft Lead Consultant

Responsibilities:

• PeopleTools from 8.44 to 8.48 for PeopleSoft Financials, HRMS and CRM & Oracle databases 9i to 10g in PCI compliance project for data encryption.
• Design & Implement PeopleSoft HRMS reporting database (Oracle).

Confidential, Greenwood Village, CO

PeopleSoft Consultant

Responsibilities:

• PeopleSoft Financials 8.0sp2 to 8.9, PeopleSoft HRMS 8.0 SP2 to 8.9 MP, Installation of PeopleSoft Enterprise Portal 8.9, Confidential of PeopleTools 8.17 to 8.47.07, Merging of Front Office module into Financials 8.9 MP3

Confidential, Coppell, TX

PeopleSoft Consultant

Responsibilities:

• PeopleSoft CRM 8.4, Sales & Marketing 8.9,PeopleSoft Enterprise Portal 8.8,8.9.Install PeopleTools 8.43.13.
• Confidential PeopleSoft CRM 8.4 to 8.9 and PeopleTools 8.43 to 8.45.12. Confidential Oracle 8i to 9i.