SUMMARY:

• Over Eighteen years of experience in information technology with Sixteen years of PeopleSoft Administration/Oracle DBA with background of IT Systems, Database, Network and Security Administration.
• Expertise in implementing and upgrading of Peoplesoft applications, Peopletools and Oracle databases to latest versions.
• Experience in implementing and upgrading Peoplesoft HCM 7.5,8.4,8.8,8.9,9.0,9.1,9.2, Financials 7.5 8.0,8.8,8.9,9.0,9.1,9.2 CRM 8.4,8.9,9.1, 9.2 Campus Solutions 9.0,9.1,9.2, ELM 9.0,9.1,9.2 Enterprise Portal 8.9,9.0,9.1,9.2
• Expertise in upgrade of Peopletools versions 7.5 / 8.14, 8.43, 8.44, 8.45, 8.47.07, 8.48.11, 8.52, 8.53, 8.54, 8.55, 8.56
• Experience in planning, designing and implementing of high availability, load balancing and disaster recovery solutions.
• Install and Upgrade Oracle databases to latest versions from 9i,10g,11g,12c
• Trained and hands on experience in configuration of Oracle Engineered Systems - Oracle Exadata.
• Installed and configured high availability databases using Oracle11g RAC, configured standby databases and replica databases using Oracle 11g DataGuard, Oracle Golden Gate and Quest Shareplex.
• Worked on backup and recovery procedures using Oracle 11g RMAN, Time Finder, Tivoli, Netbackup technologies for Peoplesoft Production refreshes.
• Worked on installation, configuration and migration of servers, applications to Cloud computing technologies like AWS, Oracle cloud, Microsoft Azure.
• Configured latest technologies Chef, Puppet, Ansible, and Runbooks to automate installation and configuration Peoplesoft systems.
• Worked extensively in integrating external systems using Peoplesoft Integration Broker, SOA and third-party vendors.
• Expert in Design, Install, Configuration and Performance Tuning (end-to-end) of PeopleSoft Internet Architecture (PIA) and Oracle databases on different platforms, Red Hat Linux, Aix, Sun Solaris, Windows server 2008.
• Participated and Implemented PMI methodologies and Agile Project Management techniques.
• Trained and certified in PMP, Scrum Master, and ITIL Expert. Ability to work in team environment with excellent presentation, leadership, analytical, qualitative and 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 and 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

People 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

PeopleSoft Technologies: Peoplesoft Install, Peoplesoft Upgrade, Peoplesoft Update Manager(PUM), PeopleSoft Administration, Peoplesoft Change Assistant, Peoplesoft Update Manager, Peoplesoft Test framework, Peoplesoft Configuration Manager, Peoplesoft Performance Monitor, Peoplesoft Application Tuning, Peoplesoft database Tuning, Peoplesoft Environment Management Framework, Oracle Secure Enterprise Search, Peoplesoft Integration Broker, Peoplesoft Application Server, Peoplesoft Process scheduler, Batch Server, Peoplesoft Mobile, Peoplesoft Interaction Hub, GreyHeller Firewall, ClamAV Virus Scan Engine, Peoplesoft Security, Peoplesoft Application Designer, Peoplesoft Data Mover, Peoplecode, Application Engine, Component Interface, Peoplesoft Query Manager, Peoplesoft Tree Manager, Business Processes, Work Flows, Application Packages, SQR,

Cloud Computing: Amazon AWS, Azure, Oracle cloud

Automation tools Ansible, Runbooks, and Puppet:

Change Management: Quest STAT, Peoplesoft Object Locking, Visual Source safe, CVS, Chef, Puppet, Git

Databases: Oracle Exadata, Oracle 12c,11g,10g,9i,8i,Oracle DBA, RAC, Oracle DataGuard, OEM, RMAN, Oracle Data Pump, EMCTL, SRVCTL, DGMGRL, Export/Import, SQL Loader, Oracle Partitioning, VPD, PL/SQL, SQL*Plus, SQL Server 2008, MySQL, Quest Shareplex.

Monitoring Tools: Splunk, Appdynamics, Quest Foglight Transaction players, Spotlight, Nagios, Hudson and Jenkins

Clusters: Cisco Load Balancers, Big-IP F-5, Veritas Clusters 3.5

Disk Management tools: Solistice Disk suite, Veritas Volume Manager 3.5

Backup Software: Time Finder, Veritas NetBackup Business server 4.5

Web Servers: BEA Web logic 8, 8.1sp2, 8.1sp5, 11gR2(10.3.6),12c Apache web Server, Tomcat Server, IIS 4, 5, Mac OS-X web server,

Application Server: Tuxedo 6.2 to 11gR1, Oracle AS

Batch Scheduling Tools: AutoSys

Operating Systems: Linux (RedHat, CentOS), Sun Solaris 8.0, 9.0,10 AIX 5, 7.0, Windows NT 4.0, Windows Server 2000,2003,2008,7,8,10 Mac OS X

Programming Languages: C, C++, Java, Java networking, Java Mail, JMS, PERL, Korn and Bash Shell programming

Internet Technologies: JavaScript, Java Servlets, JSP, ASP 2.0, HTML, XML, XSLT

Management Methodologies: PMP, Agile Management

Service Management: ITIL, Remedy, TestTrack Pro.

PROFESSIONAL EXPERIENCE:

Confidential, Chapel Hill, NC

Lead PeopleSoft Administrator/Oracle DBA consultant 

Responsibilities:

• Ran Initial Pass, Trail MTP, Final MTP for go-live for Peoplesoft application upgrade for HCM 9.1 to 9.2.0.16, FSCM 9.1 to 9.2.0.11, ELM 9.2 to 9.2.0.11.
• Upgraded Peopletools from 8.53.11 to 8.55 for different non-prod and production Peoplesoft environments.
• Downloaded and installed Peoplesoft Upgrade source images HCM 9.2.0.9, FSCM 9.2.0.5, ELM 9.2.0.6.
• Applied required PRP’s to the upgrade source image using PUM.
• Installed PUM and applied required at upgrade updates before upgrade, during upgrade and post upgrade updates.
• Downloaded, Installed and Executed Upgrade templates, upgrade documentation & scripts, projects necessary for upgrade.
• Down loaded and installed PeopleSoft Images (PI) HCM 9.2 Image 16, FSCM 9.2 Image11, and ELM 9.2 Image 11.
• Used PUM to apply customization retrofits, patches and HCM tax updates as change packages.
• Ran upgrade process using Change Assistant template and delivered online browser based compare reports.
• Troubleshoot and fix issues with Peoplesoft Upgrade scripts and Data Conversion AE’s.
• Fine-tuned Data Conversion SQL scripts to reduce time for running upgrade process.
• Installed and Configured WebLogic server 12c, Tuxedo application server 12.1, process schedulers master & slave, Unix& NT schedulers using DPK’s and oracle virtual images.
• Installed and Configured Micro focus COBOL compiler, Oracle XML publisher, N-vision reports .
• Re-configured Peoplesoft Test Framework, REN server, Grey Heller firewall, Peoplesoft Performance Monitor, Single Sign-on, PeopleSoft Interaction Hub, PeopleSoft Environment Management Hub, Agent and Viewer.
• Installed and Configured Oracle Elastic Search for search functionality.
• Worked as Peoplesoft Portal Administrator and implemented Fluid branding using Theme Builder and Macro sets.
• Created Fluid dashboards for different Peoplesoft End users.
• Worked on post go-live issues and PeopleSoft/Oracle Performance tuning.
• Performed database refreshes and automated post refresh PeopleSoft steps.
• Redesigned and Configured High availability and load balancing for Peoplesoft Internet Architecture and Integration Broker.
• Played a major role in Production Go-Live and worked closely with HR, Finance, Campus solutions business users and Portal/development teams, Portfolio/Project management Team, Testing Team, Enterprise Systems, Networking and Security Team to successfully go-live.
• Installed and Configured Oracle Exadata on X3-4 machine
• Setup infi-band network switches and storage for Oracle Exadata machine without admin support.
• Migrated Oracle 11g RAC databases to Oracle Exadata machine.
• Performed tuning of Peoplesoft Applications Payroll, Billing and other batch processes using Exadata predicate pushing, Storage Indexes, and fast scan and hybrid columnar compression techniques.
• Performed tuning of Peoplesoft application using indexes, hints, Oracle Stats, histograms.
• Planned and worked on Oracle database Capacity, Space and memory management.
• Created Oracle materialized views and DB links as needed.
• Created oracle users, profiles and resource management.
• Worked on Data migration utilities like Oracle data pump, Export/Import, Peoplesoft Datamover.
• Performed and executed schema design changes for Oracle Peoplesoft tables.
• Worked on database datafiles, control files, OCR, voting disk, redo log files, undo tablespace, temporary tablespaces.
• Scheduled Oracle job through Oracle scheduler to collect Oracle Stats on database.
• Installed and configured Oracle OEM 12c to monitor databases and configured threshold for different alerts including paging dba’s.
• Attended to daily critical database alerts and fix the issues
• Install and configure Oracle 12c binaries and Upgrade Oracle 11g databases to 12c CDB.
• Developed provisioning process using 12c OEM for installing 12c GI, RAC-ONE RDBMS and create CDB/ PDBs.
• Worked on PeopleSoft database tuning using Oracle dynamic memory management (ADDM) techniques to resize SGA, shared pool, PGA and oracle buffers.
• Analyze SQL plans using SQL Tuning advisor, SQL Plan management, and ASH analysis.
• Ran AWR reports to find bad SQL effecting batch processing and OLTP.
• Tuned bad SQL using Oracle indexing, hints, partitions, query-rewrite 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.
• Installed and Configured Physical and logical standby databases using Oracle 11g Active Data guard for disaster recovery and faster backup.
• Automated Peoplesoft PIA startup/shutdown at Disaster Recovery site using Linux Shell Scripts.
• Maintained Oracle 11g Active Dataguard standby databases for HCM, FSCM and datawarehouse reporting needs.
• Ran Change Assistant for Peopletools upgrade from 8.48. to 8.53.11 for Peoplesoft FSCM 9.1, HCM 9.1, Campus Solutions 9.0, ELM 9.0, Peoplesoft Enterprise Portal 9.1
• Setup Peoplesoft Home pages, Branding, configure pagelets and develop iScripts as part of PeopleSoft iHub Unified Navigation.
• Configured and troubleshoot issues with Peoplesoft iHub and Peoplesoft Network Center.
• 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, Unix CUPS Printers.
• 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 5000 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, and Oracle logs and for performance issues and fix the issue.
• 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 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 re-write query.
• Setup Nagios monitoring, AppDynamics 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.
• Worked on Peoplesoft Archiving.
• Integrated Open Source ClamAV virus scan engine software with 120 Peoplesoft domains and saved money for company.
• Setup Virus database to automatically update with latest viruses, malwares and Trojans.
• Designed and implemented high availability and load balancing for Virus scan engine and Peoplesoft REN server using iRules on Big IP F-5.
• Ran Peopletools upgrade for Peoplesoft E-Pro systems from 8.48 to 8.53.11 and migrated Peoplesoft E-Pro from Solaris to RedHat Linux operating system.
• Extensively 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 third party vendors to encrypt IB messages with HP, Staples, Airgas, Marketplace, PunchOut2Go, Roche University, LawLogix, Apple, Fastenal, and ImageNow using Web services.
• Troubleshoot and fix issues with synchronous and asynchronous messages between UNC Peoplesoft systems working on Integration Broker Nodes, Channels, Routes, Pub/Sub processes.
• Implemented JMS target connector for Peoplesoft Campus solutions to send IB messages to IDM on JBoss AS7 system.
• 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.
• 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 for 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.
• Presented change tickets for changes to Change Management board and attended CAB meetings.
• Worked on Peoplesoft Change management tools like Quest Stat, Rapid recovery, Phire, Peoplesoft Object management.
• Support Peoplesoft development team to troubleshoot and fix issues by helping to run traces, troubleshooting at PIA level.
• Created Peoplesoft Security Plan for Peoplesoft Applications as part of IT Security plan to tighten security.
• Worked on Security Redesign, 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 assigning 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 like SSN, Credit Card information for PCI compliance.
• Implemented SSL for encryption of data involved in SOAP based Web Services and Peoplesoft Integration broker.
• Scrambling data after production refreshes to protect data in non-production environments.
• Worked closely with Peoplesoft developers to customize sign-on peoplecode for dynamic role assignment.
• Participated in Penetration testing and closely worked with Peoplesoft Support and Developers to fix the security issues.
• Proactively worked 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 users, temporary access, analysis and resolution of security issues pre and post implementation.
• Installed GreyHeller application firewall and configured application firewall rules.
• Wrote SQL scripts to query Peoplesoft Security tables for security information.
• Implemented Heartbleed vulnerability fixes for SSL certificates on Big IP F-5 load balancer.
• Communicate with security team to setup firewall rules for Peoplesoft Application to interact with third party.

Environment: Peopletools 8.48,8.53.11,8.55 Peoplesoft HCM0 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, Oracle11g, Dataguard, RMAN, OEM 12c, Big IPF-5, Micro focus 5.1, N-vision, Crystal Reports, .Net framework 4, Red Hat Linux 6.0, Aix 5.7, Windows 2012

Confidential, NJ

Lead PeopleSoft Administrator/Oracle DBA consultant 

Responsibilities:

• Planned for different phases of upgrade process (Initial phase, Trial MTPs) and Go-live.
• Upgraded Peopletools from 8.49.23 to 8.54.03 for HCM, FSCM, CRM, and Enterprise Portal.
• Upgraded Peopletools 8.51.07 to 8.54.03 for Peoplesoft ELM.
• Downloaded and installed Peoplesoft Upgrade Source images HCM9.2.0.9, FSCM9.2.0.5, ELM 9.2.0.6 using Oracle Virtual Box images.
• Installed Change Assistant and Configured upgrade template for Peopletools and Application upgrade.
• Ran Upgrade templates and dataconversion scripts for all phases of upgrade.
• Configured Peoplesoft Update Manager to create change management packages for applying PRP’s, required for upgrade and post upgrade updates and fixes.
• Fined tuned SQL’s and UPGCONVERT (upgrade) application engine programs to decrease data conversion time.
• Downloaded, Installed and Applied Peoplesoft Images FSCM 9.2 image10, HCM 9.2. image11, ELM 9.2.0.9
• Installed and configured Oracle WebLogic Server 11gR1 webservers on IBM AIX 7 all non-prod and production environments.
• Implemented load balancing across production web servers using Cisco Load Balancers.
• Installed and configured PeopleSoft Enterprise portal 9.1 and configured Single-SignOn between Portal, HCM, FSCM and CRM.
• Installed and configured Peoplesoft Integration Broker, Peoplesoft Performance Monitor, PeopleSoft Environment Management Hub and agents, Peoplesoft Testing framework, Oracle Secure Search, SAP Crystal reports, N-vision and Micro Focus Cobol, SSL certificates from VeriSign.
• Installed Oracle Weblogic webservers 11gR1, Tuxedo 11gR1 application server, master & slave process schedulers, process schedulers on UNIX and Windows.
• Configured PIA architecture for high availability and load balancing.
• Extensively worked on Peoplesoft Integration Broker to setup interactions between PeopleSoft applications and external third party systems using Web services.
• Configured Enterprise Integration Points between HCM, FSCM, CRM, and ELM.
• Moved Peoplesoft Enterprise portal webservers to DMZ zone and implemented necessary design changes to peoplesoft.
• Configured Microsoft Active directory services for LDAP authentication.
• Clone and perform Peoplesoft refresh to non-production databases using Oracle 11g RMAN.
• Maintained Oracle 11g Dataguard standby databases for HCM and FSCM reporting needs.
• Worked on Peoplesoft database tuning using Oracle dynamic memory management techniques to resize SGA, shared pool, PGA and oracle buffers.
• Ran database tuning reports like ADDM, AWR reports to find bad SQL during batch processing and OLTP.
• Analyze SQL plans using SQL Tuning advisor, SQL Plan management, and ASH analysis.
• Tuned bad 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, SQR's for better performance.
• Used features of Oracle Exadata to increase the performance of Application Engines.
• Implemented archiving of historical payroll data using Oracle partitioning and Peoplesoft Archiving.
• Planned and worked on Oracle database space management, memory management.
• Monitor and troubleshoot database for locks, bad SQL, temporary table usage and undo tablespace management.
• Upgraded Oracle Software, Cluster software, ASM and applied patches for Oracle 10g RAC to 11g RAC upgrade.
• Upgraded Oracle 10g RAC databases to 11g and installed Oracle 11g client.
• Configured Oracle Exadata machine including system administration and networking parts.
• Worked on OEM, Oracle RAC services, listeners, tnsnames, Oracle data pump utilities, Peoplesoft Datamover.
• Created Oracle materialized views and DB links as needed.
• Planned and supported for 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 User profiles, Roles & Permission Lists, Process security, Query Security, Row-level Security, Portal Security, Security migrations, Password controls, sign-on people code, and Dynamic Role creation.
• Redesigned and simplified existing complex architecture of client's Peoplesoft security defining roles based on segment wise.
• 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.
• Redesigned and simplified existing complex architecture of client's Peoplesoft security defining roles based on segment wise.
• 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, Application engine Component interface and Workflow.
• Worked on regular security issues due to Peoplesoft refreshes, Production Access issues, Temporary production access support.
• Supported peoplesoft security for teams of large size.
• Installed and Maintained PIA for Peoplesoft applications at Disaster Recovery site and implemented DR PeopleSoft databases using Oracle Dataguard 11g.
• Re-designed 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, sequence of steps needed for recovery of peoplesoft application.
• Participated in disaster recovery drills to fine tune the process.
• Provide network diagrams for Peoplesoft upgrade environments, Peoplesoft infrastructure using Microsoft Visio 2010.
• Worked on Peoplesoft migrations, change control and object locking.
• Participated 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, Oracle WebLogic Server 11gR1 (10.3.6), Oracle Tuxedo 11gR1 (11.1.1.2.0 ), Oracle 11g, Oracle 11g RAC, Oracle 12c,Dataguard, RMAN, OEM, Cisco Load Balancer, Microfocus 5.1, N-vision, Crystal Reports, .Net framework 4, Aix 5.7, Windows 2008 SP2