Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Resume: Gaurav K Ohri, MBA, B Tech
PeopleSoft & ITIL certified seasoned Professional r ecognized for ability to deliver PeopleSoft projects of
various sizes. Proven ability to conceive and implement solutions addressing a broad spectrum of business
challenges.
Profile
Managed Large Scale PeopleSoft Upgrade and Infra-Administration Support Projects. Such Projects
involved PeopleSoft Platform/Data Center Migration and Database Upgrades as well. Managed Teams Onsite
Offshore with Team sizes ranging from 7 to 40 Resources.
Recently accomplished Major FSCM 9.1 Upgrade which had 12 Modules and 10 Terabyte of Oracle
Database size.
Lead a team of Administrators with skills in PeopleSoft, Oracle on UNIX/AIX and Windows
environments as well as SQL Server on Windows.
Had enough experience and proven understanding to be an Architect for PeopleSoft Applications.
Proficiency in designing and developing strategies for setting up and maintaining Application Servers,
PIA as well as integrating with other applications or third party products.
Re-Platform PeopleSoft Application from Sun Solaris to IBM AIX 6.1
Recent Representative Experience
As a Senior Infrastructure Upgrade specialist was involved from Project assessment Phase to the
cutover phase.
Provided recommendations for PeopleSoft infrastructure needs for the FSCM 9.1 upgrade.
Laid out Strategy for FSCM 9.1 upgrade passes.
Experience in design, analysis, development, and implementation of Client/Server applications and
Relational Databases.
Experience in estimating, designing hardware for PeopleSoft new sites or upgrading sites based upon
their requirements.
Provided effective solutions for a large number of users, primarily media consultants. The upgrade
involved 11 application and 11 web servers with 4 load balancers and 3 database servers.
Experience in leading the team to setup instant failover site with near real time replication of the above
29 servers.
Experience is setting up Disaster Recovery Sites.
Experience with Oracle Licensing Model
Experience in setting up daily and weekly backup strategies with instant failover
Experience in Performance Tuning at a holistic level.
Good as a team player as well as self-motivated.
Good communication and inter-personal skills.
Like to learn new subjects quickly and efficiently.
Acted as Team mentor during the upgrade and Test Cycles.
Improved Production availability from 75% to 99%.
Proven record of excellent support in minimizing downtimes with hard work and knowledge.
The PeopleSoft upgrade project was managed and delivered at very large scale and the team was able to
accomplish a successful Cut-over. The FSCM upgrade went live in April 2015.
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Technical Skills
PeopleSoft Upgrade Specialist PeopleSoft Administration
PeopleSoft Upgrade Specialist PeopleSoft Integration
Windows Servers Batch Processing
Unix AIX/Linux Sun Solaris to AIX migration
PeopleSoft Internet Architecture (PIA) Oracle Database 9i. 10g, 11g, 12c
PSADMIN Utility MS SQL Server 2005/2008
System Conversions(Oracle Apps to PS) DB2
PS Update Manager (PUM) Microsoft Visual Source Safe
Solarwinds IGNITE Tortoise SVN
PS Process Scheduler PS/Query
PeopleSoft Internet Architecture nVision
PeopleSoft refreshes Crystal Reports
RMAN backups Cybersource integration with PS
Oracle SES PeopleSoft Security
Data mover Business Process Improvements
Application Designer Controls/Processes/Efficiencies
Capacity Planning Complex Reporting
PeopleSoft Change Asst./Upgrade Asst. Offshore/Onsite coordination
Oracle Enterprise Manager Storage allocation and sizing
PeopleSoft upgrades Performance tuning
System integrations Restructuring and Consolidation
IGNITE nVision Reporting
Oracle Application Server Internal and External Audit Support
Oracle Exp/Imp Utility Oracle RMAN backup and restoration
Oracle Cold Backup Unix Shell/Batch Scripting
Apache/Tomcat Servers MS Access
Migrations using STAT tool BEA Tuxedo, BEA Weblogic
EMC LUN migration Oracle Database Upgrades
Taxware integration with PS PeopleSoft Multi Browser Rendering
SQR reports PS SOX Audits
Quest STAT Phire Version Control
PS Time & Labor Evaluate and Train Staff
PeopleSoft Administration PeopleSoft Financials 8.0, 8.4, 8.8, 8.9, 9.0,
9.1, 9.2
PeopleTools 7.63, 8.42, 8.46, 8.47, 8.48, 8.49, PeopleSoft CRM 8.8, 8.9, 9.0
8.50, 8.51, 8.52, 8.53, 8.54
PeopleSoft Security PeopleSoft HRMS/HCM 8.0, 8.3, 8.8, 8.9, 9.0,
9.1, 9.2
PeopleSoft ELM 8.8, 8.9, 9.0 PeopleSoft Campus Solutions 7.6, 8.0, 8.8SP1,
8.9MP1, 9.0
3rd
PS integration Broker based party Fusion Application Administration
integrations and Support specialist
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Core Competency
Technical Consulting in PeopleSoft Infrastructure.
Technical Consulting in PeopleSoft Upgrade Methodologies.
Escalation Management to salvage Client site situations.
PeopleSoft Change Process and Procedures.
PeopleSoft Upgrades with PeopleSoft 9.2 / 9.1
PeopleSoft Update Manager.
Managed PeopleSoft Administration and Support.
Managed Batch Scheduling Tools.
Team Management.
PeopleSoft Projects.
Architectural designs
Plan and implement the infrastructure strategy
Leveraging the existing infrastructure to create better ROI solutions
Executed multiple roles as Principal Enterprise Architect / Senior Upgrade Specialist in PeopleSoft Domain.
Professional Experience and Accomplishments
Dexmedia (formerly Supermedia/Verizon), Dallas, Texas I T Infrastructure Support
S ervices Delivery Manager/Upgrade Specialist {Team Size 35 } (Jan 2013 Current)
One of the largest directory services (yellow & white pages) providers that deliver a multi-
dimensional platform of Print and Online Advertising products that help connecting Consumers
with Businesses in the US
Upgraded PeopleSoft Financials from version 8.9 to 9.1 supported and maintained PeopleSoft FSCM 9.1 and
PeopleSoft CRM. Performed system conversion from eBusiness suite financials to PeopleSoft Financials.
Created and Delivered POC environment for FSCM 9.2 Upgrade.
Strategize for PeopleSoft Environment refreshes
Highly Complex and customized PeopleSoft CRM application was tuned at infrastructure level
Repurposed the existing infrastructure
Database Cold backups & Hot backups
BAU support
Process scheduler & Integration Broker support
Migration of code changes using STAT tool
SOX Audit Support
L3 Support and Escalation SPOC
PeopleSoft Finance Helpdesk Support.
Weekly and Monthly Migrations
Integration /Architecture support
Setup Oracle SES for secure enterprise search.
Setup and integrate PeopleSoft with Taxware Software
Streamline IT Infrastructure Support Processes
Infrastructure support of Unix servers to AIX 6.1
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Storage allocation and Sizing of servers
Performance tuning of the Oracle databases
Improved Production availability from 75% to 99%.
Analysis, Design and Development of the customizations for SuperMedia
Fit Gap Analysis
Validation of the PS Finance Servers.
Technical Design Documents for Data Mapping
Conversion techniques and impact analysis
Setup Search Servers, Performance Monitors for Production environments.
Database refreshes using different method export/import, expdp/impdp, RMAN duplicate
Scoping, Prioritizing and Assigning Tasks to team
Holding Status and Staff meeting
Weekly Status reports to all stakeholders
Upgrade Oracle databases from 9i to 11g
Creation of new Application & Web Servers
Migration from Sun Solaris OS to AIX 6.1
Creation of Stat Databases and implementing version control for PeopleSoft.
Offshore/Onsite coordination
PeopleSoft Security, creating and maintaining PS Roles
Client liaison for status update, issues and escalations.
Achievements:
Successfully managed and supporting a very large scale PeopleSoft upgrade with complex technological and
functional requirements.
Successfully created and implemented the upgrade and integration strategy of PeopleSoft financials with HR,
CRM and home grown java Applications of the company.
Provided the holistic picture and created and maintained the architecture diagrams for over 7 different
environments with the complete PIA implementation.
Provided POC documents and technical designs
Successfully created and Delivered POC environment for FSCM 9.2 Upgrade. The upgrade is planned for June
2016.
Strategized the movement from Sun Solaris to AIX 6.1 which has paid back itself in terms of dollar value and a
huge cut on oracle licensing costs.
Planned and Implemented the Autosys Scheduler for Company wide batch processing.
JCPenney Plano, Texas PeopleSoft HRMS, Payroll and Financials Infrastructure
Lead and Application Architect {Team Size 17} (August 2010 Jan 2013)
JCPenney one of the nations largest apparel and home furnishing retailers, is dedicated to
fitting the diversity of America with unparalleled style, quality and value.
Worked as a PeopleSoft Application Administrator and was involved with PS Admin functions like applying
patches, tax updates, environment installation and maintenance for PeopleSoft HRMS, Finance and Payroll
instances.
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Maintaining and Deploying Infrastructure services
Storage allocation and Sizing of servers
Performance tuning of the Oracle databases
Redesigning of interface architecture using Web Methods
Managed Large Batch operations Teams
Managed Data Center moves for PeopleSoft applications
Complex LDAP integrations and Setup
Implementing Secure protocols https/SFTP/SHA-2 with 256 bit encryptions.
Escalation Management for critical projects
TSM and Backup of Databases on Tape Drive for Disaster Recovery.
Create and maintain Architectural diagrams.
Strategize hardware platform moves.
Architecture Assessment for HR upgrade
Estimate Efforts
Perform major and Minor Demo upgrades
Worked closely with GSC on Incidents and issues reported during new PeopleSoft version Releases.
Client interaction and troubleshooting the issues.
Application server and Weblogic Web Server maintenance
Maintenance Schedule execution using CA7 Scheduler.
Report status to business users
Release and Change management using Remedy.
Review PeopleCode Coding Standard using Assent tool
Support and Maintenance of over 300 servers and 12 domains.
Migration of LUNS using EMC technology.
Managing the Application of Payroll patches and Regular Tax updates.
File transfers using FTP, SFTP, Bizlink and JScape.
Support and Maintenance of PS Security for PeopleSoft HR and Payroll.
Achievements:
Successfully managed and supporting a very large scale PeopleSoft upgrade with complex technological and
functional requirements.
Created POC for PeopleSoft version control by using Phire for Oracle PeopleSoft
Strategized the movement from STAT to PHIRE for PeopleSoft version control
Planned and Implemented the CA7 Batch Scheduler for Company wide batch processing.
Strategized and technically lead the initiative to move from FTP to SFTP
Strategized and implemented the movement from Microsoft Source Safe to Tortoise SVN for organization level
documentation version control
Technically pioneered the Bizlink and JScape based file transfers
Oracle PeopleSoft CoE, New Delhi Infrastructure Services Project Leader {Team Size 8}
(Jul 2009- Jul 2010)
Professional services firm focusing in the areas of risk advisory, tax, finance and accounting
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
The Oracle PeopleSoft Centre of excellence (COE) is the central group for PeopleSoft Practice in TCS. It
involves setting up and creating environments, solutions for PeopleSoft HRMS, Finance and CRM instances.
PeopleSoft experts in TCS work as a team and support the existing clientele of TCS.
Training PeopleSoft Resources.
Primary Architect for various PeopleSoft customers such as Hays, Nortel, UNDP and ConAgra Foods.
Architecting Solutions for different versions of PeopleTools ranging from 7.5 to 8.4.
Mange the infrastructure and Technical support for Multi-Tenant Server.
Plan and Prepare for critical Production moves and coordinate for execution as per Change control process
defined.
Recruiting/Hiring new PeopleSoft Resources.
Lead the team in installation & integration of Oracle Fusion with PeopleSoft using PeopleSoft Integration Broker.
Creating a Multilingual tool for PeopleSoft primarily for Portuguese language.
Integration Services using ESB, TIBCO and FUSION
Support, maintenance and periodic refreshes for the PS Treasury Management
Assign task to team members & holding status meetings with team members
Onsite Offshore Co- ordination
TSM and Backup of Databases on Tape Drive for Disaster Recovery.
Release and Change management using Remedy
Addressing areas of improvement in post implementation note
Segment wide User support during UAT and Post Production
Provide effort estimations using Traceability Matrix
Monitoring progress & tracking percentage of work done of team members
Achievements:
Successfully implemented Fusion and PeopleSoft instances on a single server based implementation
Canon, Chesapeake, Virginia PeopleSoft Infrastructure and Integration Architect (Sep
2008- Jul 2009)
Leading provider of consumer, business-to-business and industrial digital imaging solutions to
the United States and to Latin America and the Caribbean markets.
Feasibility Study PeopleSoft CRM ver. 9.1
Upgrade and Reimplementation of interfaces for PeopleSoft CRM ver. 9.1
Review PeopleCode Coding Standard using Assent tool
Effort estimation using Traceability Matrix for identifying the components that need any changes for bugs/ CR.
Managing Knowledge Process and holding knowledge sharing sessions on PeopleSoft Integration Broker.
Review PeopleCode Coding Standard using Assent tool
Testing components using TCA tool
Developed Application Engines, SQL and shell scripts for cron jobs and Integration Broker synchronous
messaging systems.
Coordination with 3rd party vendors.
Designed strategies for Volume Stress Testing using WinRunner, LoadRunner
Achievements:
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Successfully implemented Credit Card processing gateway integration with PeopleSoft CRM.
Ameriprise Financials, New Delhi, India PeopleSoft infrastructure and Performance
management Architect (Nov 2005 Sep 2008)
Formerly American express financial services Ameriprise financials is a global financial leader.
The company has more than $800 billion in assets under management and administration.
Extensive Analysis of the System
Design and Development of the System in order to suite the requirement using PeopleSoft Application Designer.
Support the PeopleSoft architecture post upgrade
PeopleSoft Global Support Center (GSC) working with Install / Upgrade Teams and assist in Installation and
upgrade for PeopleSoft Labs
Using Traceability Matrix for identifying the components that need any changes for bugs/ CR and provide effort
estimations.
Integration using PeopleSoft Integration Broker.
Review PeopleCode Coding Standard using Assent tool
Maintain High Quality of the deliverables using IQMS
Reporting status to onsite project manager
Batch processing using CA7 Scheduler tool.
Architecture Assessment for HR Application upgrade
Release and Change Management using Remedy.
Re-Platform from Unix to Linux
Oracle Database upgrade from 10g to 11g
Achievements:
Successfully implemented database upgrades and cross platform migrations
American Express, New Delhi, India PeopleSoft Technical Analyst (June 2004 Nov 2005)
Also known as Amex is an American multinational financial services corporation founded in
1850. The company is best known for its credit card, charge card, and travelers check
businesses. Amex cards account for approximately 24% of the total dollar volume of credit card
transactions in the US. BusinessWeek ranked American Express as the 22nd most valuable brand
in the world.
Design and Development of the System in order to suite the requirement
Develop codes based on the design and functional requirements
Database design based on the specifications obtained from the user
Responsible for developing new features while maintaining the existing functionality
Release and Change Management using Remedy.
PeopleSoft Global Support Center (GSC) worked closely with the installation/upgrade teams
Provide customization and enhancement of modules based on new requirements
Provide Technical assistance to the Customers
Involved in the performance tuning and Optimization of the queries and procedures
Contact: Gaurav K Ohri acr6ao@r.postjobfree.com
Review Java Coding Standard using Assent tool
Testing components using TCA tool
Achievements:
Successfully implemented Time and Labor exceptions in an innovative manner which has now been implemented
in PeopleSoft HR version 9.2.
EDUCATION:
MBA, Punjab Technical University April 2007
Bachelor of Engineering, Amity School of engineering and technology April 2004
Oracle certified associate in PeopleSoft Support -2008
Oracle certified PeopleTools Specialist -2008
ITIL certified specialist -2008