EXECUTIVE SUMMARY

PMP with Oracle and PeopleSoft certified administrator with over 20 years of experience in public sector, financial, educational, telecommunication and consulting industries. Expert in PeopleSoft Administration, PeopleSoft Upgrade Specialist, Oracle DBA, Oracle EBS Financials/SCM, Golden Gate, PeopleSoft Database Cloud Architect, SQL Server DBA, WebLogic administration, performance tuning, 24X7 production support, data center migrations. Managing PeopleSoft on Oracle Cloud OCI including DBaaS, AWS, MS-Azure. Oracle Cloud Architect managing Oracle (OCI), PeopleSoft (OCI and AWS) and MS-SQL Server (Azure), MS-SQL Server Performance tuning including query optimization, SQL client code optimization, database index management, Dynamic Management Views (DMVs), System Catalog Views, SQL Server Profiler, Database Tuning Advisor, and Server-side traces. Comprehensive experience as Oracle DBA, especially in Exadata and Oracle Goldengate proficient in Oracle 11g/12c/19c software installations, migrations, database capacity planning, architect, automated backup implementation, performance tuning on Linux/Unix and windows platform. Lead the architect group in designing logical and physical model of the complete enterprise level databases. Manages complex projects and leads high performing teams, skilled architect, designer and strategic thinker, delivers effective and sustainable IT solutions. Serving as the technical PM for various projects reporting straight to project sponsors, managing resources and timelines and all project related activity. Worked as an Oracle instructor, I am excellent at assisting other members of the project team. I have been involved in multiple PeopleSoft installations and multi-step upgrades for Campus Solution, Financials, HCM, Payroll, Benefits on Oracle and MS-SQL Server platforms.

CAREER HISTORY

Lead PeopleSoft Administrator St. Lawrence College 2019 – Present

Sr. PeopleSoft DBA/Cloud Architect IntraSee Inc. 2018 - 2019

Sr. Oracle/PeopleSoft Tech Lead

City of Brampton

2008 – 2018

Sr. Oracle/PeopleSoft Tech Lead

IBM

2005 – 2008

Oracle/PeopleSoft Technical Resource

Choice Hotels Intl

2004 – 2005

PeopleSoft Technical Team Lead

Computer Science Corporation

1999 – 2004

Oracle/PeopleSoft Technical Resource

Complete Software Solutions

1997 – 1999

PeopleSoft Specialist

Software Specialist

1996 – 1997

EDUCATION & PROFESSIONAL DEVELOPMENT

Education

BS, Electrical and Electronics Engineering

Certifications

PMP, Oracle Certified Professional, PeopleSoft Certified Professional

Continuing Ed

Successful Project Management, PeopleSoft Server Administration, PeopleTools, SQL Server Always-ON, WebLogic Administration, Oracle Performance Tuning

CORE COMPETENCIES

Products

PeopleSoft Financials, HCM, Payroll, Benefits, eRecruit, CRM, Student Administration, Apache, PIA, Tuxedo, Application Servers, IBM WebSphere, WebLogic, PUM Server, Change Assistant, Integration Broker, Quest STAT, Hadoop, Big data analytics

Databases

Oracle 19c/12c/11g/10g, SQL Server 2012/2014/2016/2017, SQL Server Always-ON

Component Interface

PeopleTools, SQR, Business Object, Application Engine, Workflow

Oracle Tools

Golden Gate, Exadata, Oracle Streams, RMAN, RAC, OEM, TOAD, Data Guard

OS

Linux, Sun Solaris, HP-UX, AIX, Windows

PROFESSIONAL EXPERIENCE

St. Lawrence College 2019 - Present

Sr. PeopleSoft DBA

Managing multiple PeopleSoft application and PeopleTools upgrades simultaneously.

Upgrade PeopleSoft Campus Solutions application from 9.0 Bundle 33 to 9.2 to latest available PUM.

Upgrade PeopleSoft Financials application from 9.1 to 9.2 with latest PUM 34.

Upgrade PeopleTools in multi-step from 8.54.14 to 8.56.18 and then to 8.57.09 with available certification.

Apply all required patches including Required for Upgrade, Tax Updates, PUMs.

Resolved all encountered issues during upgrade especially with data conversion.

Install, configure, manage ElasticSearch 6.1.2 with user-based role access to search definitions.

Managing, configuring multiple databases of PeopleSoft on Oracle Exadata with optimum performance.

First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

Provide and implement performance tuning recommendations of all components in Exadata database machine.

Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.

Solid skills to configure Exadata to meet company internal security requirement.

Involved with the architect group in designing the logical and physical model of the enterprise level databases.

Install, upgrade, maintain and secure the integrity of the College databases.

Execute and maintain secure backup and recovery procedures for all databases.

Troubleshoot, monitor and tune databases making recommendations and taking action to ensure optimal performance.

Work with security teams to ensure system access, auditing, and security controls are compliant with college security policies.

Maintain PeopleSoft system performance by performing system monitoring and analysis, performance tuning, and system load/stress testing.

Assist PeopleSoft application developers in the design, development, testing, and suitability of database interactions and in their efforts as needed.

Develop and maintain scripts in PowerShell, bash, python, Perl, etc. to automate startup, shutdown, maintenance, monitoring, and data transfer processes.

IntraSee Inc. 2018 - 2019

Senior PeopleSoft DBA/Oracle Cloud Architect

Lead PeopleSoft Upgrader, technical upgrader, and Upgrade PM for PeopleSoft 9.2

Completed multiple PeopleSoft upgrade with latest PeopleTools 8.57.06 and PeopleTools 8.55.27 in OCI.

Install latest PUMs and apply selective application updates for bug fix or to implement new features, patches, tax updates to PeopleSoft environments.

Plans, coordinates, and implements system-wide updates, upgrades, and patches for PeopleSoft ERP system.

Responsible for PeopleSoft DPK's, PUMs, and Elastic Search technology.

Managed PeopleSoft application on MS-SQL Server 2016 with Always ON HA.

Managed multiple PeopleSoft customers cloud hosted solutions in OCI and AWS.

Maintain Oracle EBS Financials, Supply chain management, and HCM.

Work with functional users to troubleshoot issues with Oracle EBS SCM, Financials, HCM.

Check and troubleshoot MS-SQL Server database deadlocks, blocking, I/O bottlenecks, fragmentation.

Create, configured, maintain PeopleSoft instances in Oracle cloud including DBaaS systems.

Created, managed Oracle DBaaS RAC databases in OCI including patching.

Created, managed DNS configuration, firewall rules, security list in OCI as well as AWS.

Worked extensively with PeopleSoft integration broker between internal and external systems.

Solid hands-on experiences in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle to Oracle and MS SQL Server to Oracle.

Primary technical resources to upgrade Oracle Goldengate from 11g to 12c in Exadata machine environment design Goldengate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.

Worked with datastage to transform data from source to destination in reporting databases and for external datafiles.

Work to customize PeopleSoft yaml scripts, puppet scripts and PeopleSoft DPKs.

Configure Single Sign-On between multiple PeopleSoft systems.

Worked in detail with install, configuration of HTTPS security, SSL certificates, openSSL, Apache.

Installed, configured, deployed latest Elastic Search 6.1.2.

Managed and performed WebLogic administration for multiple installations.

Installed Nagios and configure monitoring for PeopleSoft WebLogic, tuxedo, Apache, database backups, external systems.

Implemented PeopleSoft system auditing with multiple scenarios and customer requirements.

Responsible for end to end system wide patching including Linux OS, WebLogic, Oracle Database patching including OCI console.

Provided 24X7 support for all components of PeopleSoft systems.

Created multiple PeopleSoft support documents for other team members.

City of Brampton 2008 – 2018

Senior PeopleSoft/Oracle Database Lead

Successfully completed multiple upgrades for PeopleSoft Financials, HCM with latest PeopleTools.

Worked to support PeopleSoft and Oracle system for corporations’ various internal departments including City long term health services in collaboration with peel regional health services.

Design, deployed, manage PeopleSoft system integration between City of Brampton and Peel regional health services.

Apply all required patches including Required for Upgrade, Tax Updates, PUMs.

Implemented changes to make the upgrade process run faster during production cut-off.

Responsible for applying patches and fixes to all Oracle/MS-SQL Server/PeopleSoft and other corporate applications including providing 24X7 production support.

Responsible for installing, managing, and patching of all PeopleSoft components including Tuxedo, webservers, application server, and process schedulers.

Worked for different RAC related issue such as hang check, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss, etc.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

Maintain, upgrade, troubleshoot issues related to Oracle EBS, Financials, and HCM.

Setting up High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments.

Implementation, troubleshooting of integration broker, LDAP/LDAPS, single sign-on, profile management.

Automated refresh of PeopleSoft reporting database from production every night.

Automated shutdown/startup of databases, WebLogic, and other application components during regular quarterly patch application.

Managed successful implementation of new modules of PeopleSoft financials system.

Implemented PeopleSoft Integration broker between HRMS and Financial application.

Trained team members with new PeopleSoft/databases product, technologies, and industry best practices.

Created PeopleSoft system operations guide for team which help new members to understand system and custom configuration and in troubleshooting.

Install, configured, monitor Oracle/MS-SQL Server/PeopleSoft database and application activities including data masking using Oracle Enterprise Manager (OEM) and Quest Foglight for monitoring and performance tuning of MS-SQL Server Databases.

Successfully completed Oracle database upgrade to 12c for in excess of 30 production applications.

Build in excess of 20 production servers and in excess of 40 non-production Oracle and SQL Server database servers in cloud and on-prem (hybrid solution).

Expert in design, configuration, administration of Oracle and SQL Server database including PeopleSoft on physical and virtual servers in cloud.

Successful migration of Oracle including PeopleSoft, SQL Server databases from in house physical data center to public cloud, private cloud, IaaS, PaaS and to vendor hosted SaaS solutions.

Implemented data guard for database cloning and active standby configuration for PeopleSoft databases.

Implemented Oracle database and GIS application single sign-on with cost effective solution using Kerberos.

Migration of data centers involving multiple locations specializing in PeopleSoft, Oracle, MS-SQL, CLASS, Amanda, Hansen, TXM, IWMS Archibus, and ITSM.

Responsible for complete database administration for Oracle and MS-SQL Server including SQL Server Always-ON.

Configured and Managed Oracle RMAN backups on Linux and MS-SQL database backups on Windows to disk and to tape using TSM Tivoli.

Helped team to write scripts to automate non-production database refresh from production database.

IBM 2005 – 2008

Senior PeopleSoft Admin Technical Lead

Completed successfully PeopleSoft implementation on Oracle for various clients in Financials, HCM 9, Benefits, Payroll, Pension, Time and Labor on multiple PeopleTools versions.

Conducted parallel payroll runs and matched payroll results cent-to-cent. Responsible for explaining differences in parallel payroll run to business partners and get sign-off from business users.

Responsible for ensuring timely and accurate payroll processing for all 36 companies, 4,524 active employees that partner with ADP.

As Technical Lead responsible for supporting multiple clients for production support and upgrade of Oracle databases, SQL databases, and PeopleSoft applications (Student Admin, Financials, HCM) including 3rd party software’s.

Successfully upgraded PeopleSoft Financials from 8.4 to 8.8 MP1 on PeopleTools 8.47.05

Upgrade Oracle databases from 9i to 10g on AIX and Windows environments.

Responsible for DB2 databases including backups and recovery as and when required including disaster recovery.

Provide 24X7 on-call support to all designated clients.

Developed and proposed new backup strategies in accordance with customer needs.

Apply database releases, PeopleSoft tools and application patches.

Extensive in hand knowledge of Autosys for scheduling PeopleSoft batch jobs, databases nightly backups, troubleshooting, adding new jobs, changing existing jobs.

Worked extensively with configuring Integration broker between PeopleSoft financials and HR/Student Admin application including setting up page out if any channel is stuck or in error.

Worked on creating troubleshooting documents for production support as reference document for other members of the team.

Automated refresh of non-production databases and PeopleSoft file system from production environment.

Create new PeopleSoft databases for new application upgrades or for new application testing.

Worked extensively on Unix and windows scripting.

Provide cross training to new team members.

Choice Hotels Intl (CHI) 2004 – 2005

PeopleSoft Technical Resource

Upgrade PeopleSoft FSCM from 8 SP1 to 8.8 SP1 MP1 and PeopleTools from 8.19.12 to 8.45.14

Installed, configure, tuning of Webserver (WebLogic 8.1), Application server and process schedulers.

Successfully configured new Financials PeopleTools 8.45 Integration broker with existing HRMS PeopleTools 8.19 Application messaging.

Performed timely and accurate preparation of semi-monthly on-cycle and off-cycle payroll runs while ensuring employees are paid in compliance with state laws and company policies.

Tuning and running simultaneous data conversion app. engine programs during upgrade to reduce the total time to be taken for upgrade.

Applied required PeopleSoft bundles, patches and fixes using Change Assistant.

Configured production and QA databases with new PeopleSoft performance monitor database.

Worked extensively with internal and external auditors to get Sarbanes Oxley certification.

Team Lead for vanilla implementation and configuration of new PeopleSoft budgeting BAM & ABM application.

Successful implementation of EPM 8.8 budget.

Extensively worked with Ascential ETL mappings for EPM 8.8 in reference to creation of ODS and correcting errors for FSCM destructive/incremental loads.

Meet with the customers to define requirements.

Create new PeopleSoft release demo, dev and QA databases. Also refresh of PeopleSoft non-production databases from production database.

Installation, configuration, managing Quest STAT for version and change management tool for PeopleSoft/Oracle applications.

Provide necessary maintenance and upgrade to new versions of STAT.

Provide necessary training to new team members and troubleshoot issues for developers.

PREVIOUS PROFESSIONAL EXPERIENCE

Instructor, Oracle

Georgetown University, George Washington University, Virginia Tech

2000-2005

PeopleSoft Technical Team Lead

Computer Science Corporation (CSC)

1999 – 2004

Oracle/PeopleSoft Technical Resource

Complete Software Solutions

1997 – 1999

PeopleSoft Specialist

Software Specialist

1996 – 1997

Contact this candidate