Post Job Free

Resume

Sign in

Manager Assistant

Location:
Perrysburg, OH, 43551
Posted:
October 05, 2010

Contact this candidate

Resume:

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



Contact this candidate