Abdul Latif
abj70a@r.postjobfree.com 281-***-****
http://www.linkedin.com/in/psadminabdul
Summary of Professional Skills:
. Over 8 years of result oriented professional experience in Analysis,
Design, Implementation, System Administration, Application Security,
upgrade and Production Support.
. Migrated the entire IBM hosted PeopleSoft Infrastructure to Dana
Corporation Maumee Data Center
. Experience as PeopleSoft Technical Architect in designing the new
Hardware for existing PeopleSoft Applications running in HRMS 8.8
PeopleTools 8.46.03, EPM 8.8 PeopleTools 8.46.03 and CRM 8.9
PeopleTools 8.45
. Effectively carried out three PeopleSoft Application upgrades version
8.3 to 8.8, 8.8 to 8.9 and 8.9 to 9.0
. Involved in PeopleSoft PeopleTools upgrade from 8.16 to 8.19, 8.21 to
8.43, 8.43 to 8.45, 8.47 to 8.49 and 8.48 to 8.49
. Experience in Upgrade Assistant & Change Assistant Tool and used in
deploying Patches, Bundles, Maintenance Packs and performing Upgrades
. Experience in Content Management for Enterprise Portal Application 9.0.
Designed a new migration strategy for migrating contents from one database
to other as PeopleSoft don't recommend any migration process.
. Extensive experience in supporting the Majority of PeopleSoft
applications, including HRMS, EPM, ELMS, CRM, FSCM and Portal.
. Supported the above mentioned applications residing on Oracle, MS SQL
Server, Sybase and UDB DB2 databases in a UNIX (AIX, HP-UX, IBM and
Solaris), Red Hat Linux and Windows Environments.
. PeopleSoft Server Administration PeopleTools v8.4x/8.1x/7.5x -
Expertise in installation, configuration, setup, security and
management of the PeopleSoft Internet Architecture PIA environment and
related processing objects.
. Successfully installed and configured BEA Web Logic Server
9.2/8.1/6.1/5.1, and Tuxedo 9.1/8.1/6.5 and Jolt 1.2 on HP/AIX/IBM
Unix, Red Hat Linux and Windows server.
. Worked as a Security Administrator on PeopleTools 8.1x/8.4x. Extensive
experience in setting up User profiles, Roles,Permission lists,
Tree Manager and running FASTVIEW, SJT processes
. Experience in SQR reporting, Component Interface, Application Engine
. Perform Installation / Creation of Database, Backups, Recovery, User
Creation and monitoring the performance of Database in SQL Server 7.0,
2000 & 2005 and Oracle 9i & 10g.
. Hands on experience in creating shell scripts for monitoring
Application Server, User counts etc.
. Configuring REN Server as per the client need.
. Worked with Sox Auditors to provide them with Sox data. Worked with
Auditors in defining the Control Points for the Audit making sure that
Segregation of Duties and Responsibilities are implemented
. Ensured system availability by implementing failover where environment
continues operating after a Web Server, Application Server or Process
Scheduler host goes down.
. Used BIG IP tool for Load Balancing and Failover.
. Perform Change Management of PeopleSoft Objects using STAT software.
. Setting up Security and Administering Workflow related to PeopleSoft
objects in STAT.
. Created multiple Application Server domains on separate host systems
to access one database for performance failover and business
continuity planning.
. Tuned Application Server and Web Server as per client need.
. Extensive experience in refreshing development & testing environment
from Production database.
. Evaluating the required patches and applying them to the PeopleSoft
system on a timely basis.
. Experienced PeopleSoft Applications Administrator including
performance problems with SQR reports, App Engine, and working with
DBA to tune the Database configuration parameters.
. Object Migration between PeopleSoft Environments, Development to Test
and Production.
. Experienced in change control and version control management.
. Worked as Secondary DBA in Oracle and SQL Server platforms.
. Extensive experience in installing Oracle software on HP/AIX/IBM Unix, Red Hat Linux and Windows server and applying required Oracle
patches
. Experience in performing Hot backups, Cold Backups, Export and
creation of Database from these backups.
. Experience in Oracle Enterprise Manager and used for administering day
to day activities of Oracle and Performance Tuning.
. Knowledge in RAC, Data Guard and RMAN.
Technical Skills:
ERP: PeopleSoft Financials 9.0/8.9/8.8/8.4/8.0/7.5, HRMS
9.0,8.9/8.8/8.3/8.0/7.5, ELMS .8, CRM 8.9, Portal
9.0, EPM 8.9
PeopleTools: 8.49, 8.48, 8.47, 8.46.xx, 8.45.14, 8.43.xx
8.42.xx, 8.21, 8.18, 8.17, 7.63
Administration Tools: Process Scheduler, PeopleSoft Utilities,
Configuration Manager, Application Designer, Data
Mover, Application Engine, Component Interface,
Business Interlinks, PeopleSoft Security, Object
Security, Query Security and Tree Manager, PS Query
Tool, SQR, Crystal Reports, nVision Reports, Upgrade
Assistant, Change Assistant, Quest STAT
5.2,Business Process, Workflow, COBOL, ExceltoCI
Application/Web Server: BEA Web Logic 9.2/8.1/6.1/5.1, Web Sphere
4.1/5.1,6.1,Tuxedo 9.1/8.1/6.5
Databases: Oracle 9i, Oracle 10g, DB2 Mainframe/UDB, SQL
Server, MS Access
Operating Systems: Sun Solaris, z/OS, AIX, HP-UX, Windows
NT/2000/2003, 2008 Linux 4.0
SQL Tools TOAD, SQL PLUS, SQLPLUSW, SQL Client, DB2 Client
Programming Languages: C, JAVA
Other Skills: MS Word, Excel, Visio, PowerPoint, Outlook and
MS Project.
Call Logging Software: Remedy, Gold Mine HEAT, Siebel ERM & CRM,
Perigirin
Schedulers CA7, Control M, Autosys
Web Application myHR Internal Hewitt Associates Web Portal, AOL Internal
Applications like ESS, MAT, and AOLU
Professional Experience:
Dana Corporation, Maumee, OH
PeopleSoft Infrastructure Lead
Jan 2010 - Till Date
. Working as Infrastructure lead in redefining the existing
Infrastructure and Services from IBM AOD
. Administering the Existing PeopleSoft Application HCM 9.0 MP3 and
PeopleTools 8.49.07 running in Oracle 10g on AIX 6.1 Server
. Did Infrastructure Migration of PeopleSoft Application from IBM Data
Center to DANA Maumee Data Center
. Worked with Different Groups like Firewall, Unix, Windows, Oracle
Database in defining the strategies and Steps to be performed during
each phase of Infrastructure Migration
. Worked with Unix Admin in defining the File System, Required Patches
and creating psdan user
. Installed Tuxedo 9.1 RP 095, Web Logic 9.2 MP3 in Non Production and
Production Environments
. Worked with Oracle DBA in defining the File System and restoring the
Database from Cold Backup provided by IBM AOD Team in Non Production
and Production Environments
. Installed PeopleSoft HCM 9.0 MP3, PeopleTools 8.49.07 in Windows 2008
Server and synched up the External Directories from IBM AOD.
. Configured PeopleTools utilities like Configuration Manager,
Application Designer, Change Assistant, Data Mover,Excel to CI
utility in Windows File Server
. Configured Environment Management HUB and tested the Agent running by
deploying files using sample Patch Template.
. Configured Process Scheduler PSNT in Windows Server and created
Application Server for Test Run in Non Production Environments.
Verified the Installation by performing Instance Verification Test.
. Untar the Unix PS_HOME in AIX Server and defined PS_HOME in all Non
Production and Production UNIX Servers. Configured Application Server, Process Scheduler PSUNX in above servers
. Configured Report Node Definitions and Failover Configurations in
Configuration. properties in Web Server
. Defined the Integration Broker Gateway and configure Node Definitions
. Installed People Books and configured Search and enabled Help link
from PeopleSoft URL.
. End to End Testing was completed by involving different groups like
HR, Benefits, Payroll and getting their Sign Off for moving to
Production
. Successful implementation of Mock Migration to Production Environments
. GO-LIVE activities are published and performed a Successful Migration
to new Production Environments
. Detailed Weekly Maintenance / Monthly Maintenance by PeopleSoft
Support Team are defined and executed with few challenges. Process
Improvements are still under progress.
. Alert Notifications Setup for monitoring File System of Database
Server/Application/Web Server
. Worked with Oracle DBA in reusing the existing Backup/Recovery
Procedures followed in DANA
. Defined the Environment Migration Cycle and Refresh Schedule for Non
Production Environment
. Perform all the Non Production Change Control Activities like SQR,
Project Migrations, Cobol Compilations
. Apply Tax Updates delivered by Rimini Street a 3rd party vendor in Non
Production Environments and act as a Single Point of Contact from DANA
helping in end to end Coordination
. Coordinate with IBM AOD team for performing Migrations in Production
Environment
. Performed the cleanup of DDDAUDIT/ SYSAUDIT which provided greater
visibility and appreciation from Client. Defined the Maintenance Plan
in cleaning up the Audits on regular basis.
. Created Business Requirement Document,Software Requirement
Specification,Technical Design Document and Work Breakdown Structure
for cleaning up DDDAUDIT/SYSAUDIT
. Perform Pre Refresh and Post Refresh activities for the Database
Refresh in Non Production Environment
. Created Standard Operating Procedure (SOP) which is used by IBM AOD
for refreshing PeopleSoft Databases of Non Production Environments
. Installed PeopleTools 8.48.07 in DANA hosted Citrix Server and
configured according to User Requirement
. Worked with Firewall Team in identifying the Ports to be connected
through Citrix application Server to IBM Servers. Identified the Time
Out Settings and helped in Improving the Performance in Citrix
. Automated Alert Notification for PeopleSoft Processes running in
PeopleTools Process Scheduler
. Acting as Security Administrator in cleaning and redefining the
existing PeopleSoft Security by working with Business Users and
cleaning the Roles/ Permission List/User Profiles.
. Defined Deployment Life Cycle for Tax Updates / Migrations across the
Environments
. Cleaned up Database Users, Database Links, PeopleSoft OPRIDs in Non
Production and Production Environments
. Coordinate PeopleSoft Administration Activities from Onshore/Offshore
Ongoing Support Team and complete those meeting DANA SLA Requirements
. Created PeopleSoft Security Matrix, Access Tracker, Run Book,
Configuration Management Plan for DANA
. Defined the Process Flow for applying Tax Updates which are delivered
from Rimini Street across the PeopleSoft Environments
. Worked with DANA SOX Auditors in defining the Segregation and
Responsibilities of PeopleSoft Application Users. Provided Security
Data to Deloitte Security Auditors and worked with them in identifying
the Roles which are exceeding its functionality.
. Assisting Production Support Team with their Ongoing Issues
. Worked with IBM AOD for Infrastructure Operation Support Activities
. User Assistance for PeopleSoft Security Administration Team in helping
them in their Security Tasks adding required Roles to existing Users
based on Security Access Matrix
. Cleaned up Roles from PSROLEUSER table for OPRIDs not existing in
PSOPRDEFN table
. Supporting PeopleSoft 8.3 Application on adhoc basis and restarting
the PeopleSoft Servers as per the maintenance plan.
. Administer QuickR Application, a knowledge repository for storing Team
Documents and used as a Change Control Tool for versioning the Work
Request Documents. Grant Access to new Users, Modify existing User
Access and control User level Permissions according to their Role.
. Also worked as a Business Analyst for implementing Interfaces for
Enterprise Single Sign On Applications connecting to Partner Sites
like Vanguard, AON and ACS from DANA Web Portal
Intel Corporation, Hillsboro, OR
PeopleSoft Architect/Administrator, ERP Services June
2009 - Dec 2009
. Production Support for existing PeopleSoft applications HRMS 8.8, EPM
8.8 running on PeopleTools 8.46.03 and
CRM 8.9 running in PeopleTools 8.45 on Windows Server
. Monitor the ERP Support Mailbox and trouble shoot the PeopleSoft
issues occurred during the business hours
. Work with the offshore team in assigning the off hours task to them
like Post Completion Steps after Refresh, COBOL Compilation and verify
the tasks
. Apply Bundles, Tax updates to existing PeopleSoft Pre-Production and
Production Environments
. Worked with Migration Team in moving the PeopleSoft Components one
from Environment to Other
. Worked on adding Russian Language to existing CRM Application
. Worked on the mail server issue occurred in CRM Application and helped
in fixing the issue
. Assigned to work as PeopleSoft Technical Architect in implementing new
Hardware for existing PeopleSoft Servers
. Designed the PeopleSoft Architecture for the new Hardware Windows
Servers and created the architecture diagram
. Worked with Different Team in identifying the tasks to be performed
by each team for Hardware Upgrade
. Created Project Plan for implementing the new Hardware for the
existing PeopleSoft Production and Pre-Production environments
. Weekly Review meetings are conducted to make sure that the tasks are
performed by each team without issues.
. Captured the issue logs and worked with the respective teams
accordingly
. Installed, Configured PeopleSoft Applications in the new Hardware
boxes running on clustered environments
. Created Web Servers, Application Servers and Batch Servers in the new
Windows Server
. Conducted Offshore training and Onsite Training for SAP Team about the
PeopleSoft activities carried out in Intel Corporation
. Documented all the tasks which are performed during my tenure and did
knowledge transition to team
. Created Build Documents which walks through the entire Installation
Process of PeopleSoft Installs
. Was Involved in implementing Disaster Recovery for the PeopleSoft
Servers and worked with Oracle team in verifying the Data Guard
Installation
. Created Scheduled Tasks to execute Scripts for shutting down and
starting the PeopleSoft Application Server, Batch Server during weekly
maintenance
. Updated the Server Information in KCDB (Intel's Knowledge Repository)
for existing ERP Servers
. Verified the ILO connectivity for all the ERP Servers and worked with
the Data Center team in configuring for servers with no ILO
connectivity
AOL, Virginia Oct 2007 -
Apr 2009
PeopleSoft Architect, Corporate Systems Operations Team
. Successfully Upgraded PeopleSoft HCM 8.9 to 9.0 and PeopleTools
8.47.04 to 8.49.17
. Installed Oracle 10g software and upgraded to 10.2.0.4 version in
Linux RH 4.0 server
. Installed Tuxedo 9.1 and Web Logic 9.2
. Installed PeopleTools 8.49.17, HCM 9.0 and created a Demo Database
. Performed an Oracle cold backup of Demo Database and created another
Database as Standby database.
. Configured Application Server, Process Scheduler and PIA for the new
Demo Database
. Applied Bundles and Required for upgrade in new Demo Database
. Performed the upgrade from Application 8.9 to 9.0 and Tools 8.47.04 to
8.49.17 by following the steps mentioned in Change Assistant.
. Installed the higher version software over existing file system and
rebuild the application server, process scheduler and PIA for Copy of
Production Database.
. Working on Move to Production phase with the new Copy of Production
Database.
. Administering Application Servers, Batch Servers & Web Servers running
for HCM 8.9 PT 8.47.04, CRM 8.9 PT 8.47.06 and Portal 9.0 PT 8.48.09
. Did migration of PeopleSoft Development, Training environments from
egenera boxes to new boxes
. Created new Web Server Domains, Application Server Domains, and
Process Schedulers for the above environments.
. Reconfigured the Integration Broker with the new gateway URL.
. PeopleSoft Portal Content Management from one environment to other.
Has created our own practice as PeopleSoft don't support content
migration.
. Exporting the Pagelets and Content Reference tables from Source and
Importing in the Target Database.
. Change Request Management, Version Control using STAT for PeopleSoft
tool
. Automated patching, Migration Management and Auditing & Reporting on
required basis using STAT tool.
. Managing CSR console, Job monitoring on daily basis using STAT tool.
. Upgraded Quest STAT from 5.2.0 to 5.3.2. This involved three test
upgrades to make sure STAT works as designed for the existing HCM, CRM
and Portal Environments.
. Performed multiple migrations using STAT Quest 5.2.0 and 5.3.2 which
included migrating PS and Non PS objects.
. Took care of multiple manual migrations using App designer for HR
application which was not compatible with the existing version of
Quest STAT.
. Performing Impact Analysis and applying PeopleSoft Patches using ACM
STAT process.
. Did migration of Plateau AOLU system from egenera boxes to new hosts
co-coordinating with Web Server and DBA team.
. Performing daily activities like checking the Web Servers, Application
Servers and Batch Servers status, Integration Broker Messages and
Space monitoring in Linux servers
. Monitoring the daily jobs running in auto sys and fixing the data
issue if any
. Running the Brio Reports daily.
. Migration Activities in PeopleSoft and non PeopleSoft applications
. Scheduling the Jobs in Autosys
. Working on Remedy requests created by the users.
. Created mirror environments for performing Tools Upgrade. Configured
Application Server, Web Server for the new upgraded environments.
. Ran the PeopleSoft post refresh activities and AOL steps.
. Performed Tools Upgrade from PT 8.47.06 to PT 8.48.09
. Performed Tools Upgrade from PT 8.47.04 to PT 8.48.09
. Applied Maintenance Packs MP6 Cumulative to HCM 8.9 application
. Applied Maintenance Pack 9,10 and 11 to CRM 8.9 application
. Configured Integration Broker and Single Sign on between these
Databases.
. Working with DBA team for Database refresh and performing post People
Soft DB Refresh
. Managing the Architecture Diagram
. Working on the Product Support Document (PSD)
. Attending the SCRUB meeting prior to migration
. Working on the monitoring scripts for PeopleSoft Application Server
and Process Scheduler
. Status meeting with offshore team and managing offshore resources in
Mumbai, India
. Managing AOL Internal Web Applications like AOLU, Time Trak, Brio
Reporting and Other applications like MAT,ESS,Goalign
. Preparing checklists for daily activities and prepared Operations
Manual for Corporate Systems Operations Team.
Prudential Insurance
Hewitt Associates, Charlotte, NC
PeopleSoft Infrastructure Administrator July 2007
- Sep 2007
. Played a Key role as Technical Architect in setting up People Soft
environments for Prudential International Common People Reporting
Platform (ICPRP).
. Installed PeopleTools 8.49, applied product patch 04 and installed EPM
8.9 Application Software to run on an Oracle Database 10g platform on
Solaris Server.
. Installed PeopleTools 8.49, product patch 04 and EPM 8.9 Application
software in Windows file server.
. Installed Tuxedo 9.1 and Jolt components to support 8.49 PeopleTools
Installation.
. Installed Web Sphere Network Deployment Application Server 6.0 on
Solaris Server
. Created Databases for People Soft EPM Application and Cognos
Application
. Created People Soft Demo Database and refreshed for other environments
. Installed Ascential Data Stage 7.5.1 in Windows File server and
Solaris Server
. Installed multiple environments namely Demo, Development, and UAT
Testing
. Installed People Books and configured Search and enabled Help link
from PeopleSoft URL.
. Worked on PeopleSoft Security for EPM modules - Created Permission
Lists, Roles, User Profiles, and maintained them.
. Worked closely with PeopleSoft development team, functional team, DBA
team, Wintel team, UNIX server team and storage team.
. Applied Maintenance Pack Cumulative version 4 and Delta 5 in EPM Demo
Database
. Migrated the above to all other Environments.
. Used Change Assistant to apply patches
. Configured Application Servers and Process Scheduler Servers with
different templates and tuned the configuration parameters based on
the type of usage.
. Performed Database refresh on a weekly basis
. Exported and imported Peoplesoft security using Datamover scripts
. Created and Maintained environmental documentation by updating
documentation, in a timely fashion, to reflect infrastructure changes,
tuning procedures, other techniques.
. Supported and participated in maintaining a current application
infrastructure.
. Makes recommendations regarding hardware and software acquisition
. Automated routine tasks and streamline processes to increase
efficiency
. Responsible for maintenance of security and disaster recovery plans
PeopleSoft Upgrade Specialist July
2006- June 2007
. Installed People Soft HCM 8.9 & PeopleTools 8.47 on Oracle 10g
database on AIX server.
. Installed Tuxedo 8.1 and Jolt components to support 8.47 PeopleTools
Installation.
. Installed Web Logic 8.1 and configured for all the environments
. Installed all the patches required for upgrade.
. Installed multiple environments namely Demo, Development, UAT Testing,
Performance Testing, Training and Production environments.
. Installed People Soft HCM 8.9 & PeopleTools 8.47 in Windows File
Server
. Installed Change Assistant and created Jobs for upgrading the
databases.
. Upgraded the existing version of HCM 8.8 to HCM 8.9 and PeopleTools
8.43 to PeopleTools 8.47
. Worked with DBA's in tuning conversion programs while running the
upgrade
. Worked closely with DBA to fine tune SQR's. AE's, nVision etc and
updating statistics on tables and database.
. Involved and performed TMTP1, TMTP2, TMTP3 and MTP.
. Worked with functional users on pre upgrade and post upgrade tasks.
. Generated compare reports between projects and databases for analysis
and migrations.
. Worked on errors while running the upgrade scripts on target database
and opened cases with PS as and when needed
. Involved in 3 upgrade cycles till Production GO - LIVE
. Configured Ren Server and created documentation.
. Implemented LDAP authentication for new environment.
. Created separate Integration Broker/App Messaging App Server domain
and Nodes for the Source and Target PeopleSoft Applications including
configuration of integrationgateway.properties file to include the
Node Names of the Default and Remote Nodes.
. Implemented Application messaging for system integration and publish
and subscribe processing between PeopleSoft and outside systems.
. Setup PeopleSoft Performance Monitor for environment testing.
. Worked with re-platforming team in analyzing the changes made to
People Soft in converting from Mainframe to UNIX platform.
. Worked with the conversion team in checking the Data validity
/integrity from Mainframe to Oracle database
. Worked with loadrunner team to crate load on various servers under
test before deployment as part of performance testing.
. Refreshed all the environments with the Copy of Production from Source
and performed the upgrade for 3 life cycles.
. Created Application Server Domains and Process Schedulers for the
upgraded environments.
. Configured Weblogic server for the above domains.
. Created multiple servers for Load Balancing and Fail over clustering.
. Worked with the Development Team in retro fitting the SQRs
. Worked with the Control M team in scheduling the jobs from COBOL to
SQR
. Worked on PeopleSoft Security for HR and Financials modules - Created
Permission Lists, Roles, User Profiles, and maintained them.
. Performed all Change Control Activities like Project Migration,
External Migrations, and Cobol Compilation upon developer's request.
Followed the Change Control procedures.
. Used Change Assistant to apply patches.
. Performed Database refresh on a weekly basis
. Exported and imported Peoplesoft security using Datamover scripts
. Monitored, Detected, Analyzed, fixed and communicated problems that
degrade the predictable delivery of business application services.
. Processed migrations to Testing and Production databases quickly and
efficiently adhering to Change Management standards.
. Automated routine tasks and streamline processes to increase
efficiency
. Responsible for maintenance of security and disaster recovery plans
. Performed Production Support after GO-LIVE which includes supporting
the environment 24*7
. Applying the latest bundles, tools patches and Maintenance pack for
existing environment for Demo, Development and UAT instances
. Worked on the week end's for applying patches in Production Databases
PepsiCo Oct 2005 - June 2006
Hewitt Associates, The Woodlands, TX
PeopleSoft Administrator
. Worked as PeopleSoft Administrator for Quaker and Frito-Lay divisions
in PepsiCo
. Monitoring the Application Server Domains, Process Schedulers and Web
Server Domains running on People Soft HRMS 8.0 SP1 PT 8.21 and People
Soft HRMS 7.5 PT 7.63
. Involved in Server Migration from NT to Windows 2000 and installed all
People Soft Applications and reconfigured Application Server Domains
. Applying Tax updates to all the environments and working with
Migration Team in moving to Production Environment
. Applied DST patches to all existing environments
. Involved in migration of Citrix Servers and Installed PeopleTools
executables in Citrix Servers for developers accessing People soft
. Installed BEA Tuxedo on multiple servers on windows and UNIX operating
system.
. Performed Production Support Activities like Project migrations,
External Migrations
. Worked with different Hewitt internal teams for migrating the above
components and adhere to Hewitt - PepsiCo process compliance
Web Portal - myHR Production Support
. Installing, Creating and Configuring PeopleSoft Domain in SIT, UAT and
Production Environments for myHR web application.
. Supporting all the technologies like People Soft, Messaging Servers,
Workflow Engine and Message Adapters
. Running queries in Oracle Database and fixing the user transactions or
data issues.
. Triggers created for all the People Soft Databases. Services setup for
all the Messaging Adapters.
. Citrix Server setup for Hewitt Developers to access the above
environments.
. Administering People Soft Application servers, Workflow Engine.
. Performance Tuning of the workflow engine and People Soft Application
Server.
. Migrating the People Soft changes from one environment to other.
. Monitoring the Siebel ERM, CRM and Workflow Tools and fixing the
transactional issue of the
. Instances.
Navisite (formerly named as Surebridge)
May 2004 - Sep 2005
Hexaware Technologies, Chennai, India
PeopleSoft Application Administrator/ Upgrade Admin
. Application Server/Process Scheduler / Web Server Configuration for
Navisite Customers maintaining different People Soft Application
versions like HRMS 8.x, Financials 8.x & Portal 8.x
. Worked with different versions of PeopleTools and upgraded tools
starting from PT 8.21, 8.43,8.45
. Performed a PeopleTools Upgrade from 8.43 to 8.45 using Change
Assistant for a client supporting ELMS 8.8 application
. Performed an upgrade from Financials 8.3 to Financials 8.8, PT 8.21 -
8.43 for one of the clients of Navisite using Upgrade Assistant.
. Perform Environment Refreshes and Database Refreshes for clients of
Navisite on daily/weekly basis
. Tools Upgrade and Service pack Upgrades
. Applying Tax Updates
. Requirement Analysis study before the deployment of Patches.
. Analyze the patch document and identifying the pre-requisites and post-
requisites
. Apply the patches and fixes.
. Perform any manual steps as mentioned in the patch document based on
the order.
. Migrating Custom Projects/Reports across various environments
. Troubleshooting issues related to PeopleTools and Application
configuration
. Analysis of Database Compare
. DDD Audit, SYS Audit, Alter Audit fix
. Working on 24*7 and involved in performing both Change Control and DBA
activities.
Cognizant Technology Solutions (CTS), Chennai, India
Sep 2002 - Apr 2004
PeopleSoft Production Support DBA
. Daily Routine work that involves releasing the memory locks in
Application, Database & Web servers.
. Monitoring the entire system and tuning the applications for a better
performance by end users.
. Database Refreshes using SQL Server 7 and 2000 version.
. Creating new SQL Server DTS packages based on request from Internal
Support team
. Implementation of PeopleSoft servers and SQL instance for the new
PeopleSoft Module. This implementation includes establishing Web
server, Application Server and Database server on three different high
- end machines with appropriate installation.
. Handled the PeopleSoft Production Environment Migration to the
powerful machines, which involved Installation of Web Logic 5.1.0 SP6
on Web Server.
. Installation of PIA, PeopleSoft Applications HRMS 8.0 SP1, Financials
8.0 SP1, PeopleTools 8.19 on Application Server.
. PeopleSoft Database Upgrade from SQL 7 to SQL 2000, which involved
challenging tasks like creating the new instance of the PeopleSoft
application as per our requirement.
. Populating the production data in the new instance and checking for
data integrity
. Identifying the SQL scripts and stored procedures that are no longer
supported.
. Guiding the team in recreating it, tested and moved to production.
. Recreating Indexes for the whole production database.
. Successfully upgraded the PeopleTools 8.16 to 8.19.12 in the
Production Environment.
. PeopleSoft Application being an online transaction processing (OLTP),
tuned the database to support a large volume of transactions which
involves,
. Fine tuned Indexes and clusters to have high throughput.
. Reactive tuning to improve Production System Performance by updating
STATISTICS on regular basis.
. Worked as People Soft Security Administrator, which involved in
Analysis, Planning & Designing of Complete Secured PeopleSoft System.
. Preparation of Requirement Analysis Document and Functional
Specification Documents.
. Creation of various Access groups according to different levels of
Users.
. Creation of Roles, Permission Lists and attaching the same to the User
Profiles based on the functionality they perform in Cognizant.
. Designing Workflows for different Business process applications based
on the requirements.
. Creation and Maintenance of Tree structures for different corporate
using Tree Manager Application tool.
. Developed a complete secure PeopleSoft system allowing the Users to
perform/ view their own operations only adhering to
Cognizant Security standards
. Production Support involves in Bug - fixing, Error Handling, and
Development. & Testing according to the requirement from the users.
. Assisting Front end users to perform their Application functions
effectively.
. Generating Reports, SQL Queries, PS Query, and Crystal Reports etc.
. Customizing PeopleSoft applications according to the requirements from
the Functional Team
Education and Training:
B.E Madurai Kamarajar University, India
Certifications:
PeopleSoft PeopleTools