Summary:

• 11 years of hands-on experience in PeopleSoft Administrator/DBA using PeopleSoft PeopleTools 8.51.07/8.49.21 upgrade, Portal 9.1, SCM 9.1, CRM 9.0, HCM 9.1, Campus Solutions 9.0, and EPM 8.9 using WebLogic 10gR3/9.2, Tuxedo 10gR3 and Oracle 11g/10g, SQL Server 2k, DB2 database environments. Expertise in administration, installation, maintenance, tax updates, performance tuning, upgrading, DST patches and production support for large PeopleSoft environments.
• Administration expertise in PeopleTools 8.51.06/8.49.21/8.46.10 SCM 9.1 GL, AP, AR, PO Billing, CRM 9.0 helpdesk and support HCM 9.1 Payroll HR, Time and Labor, Benefits, change management, Campus Solution 9.0 and EPM 8.8 Enterprise Warehouse, Funds Transfer Pricing FTP Workforce Analytics and Forecasting using Red Hat Linux, HP-UX, AIX, Sun Solaris and IBM Regatta RS6000 environments.
• Expertise in Oracle Database Administration, RMAN, import/export and general RAC database administration. Configuration of ETL tool Data stage 7.5, Ascential Data stage Administrator, Data stage Designer and Informatica PowerMart 6.1/5.1, OLAP Tool Cognos 7.1, COGNOS 8 BI, ReportNet, Framework Manager, NDS, Access Manager, Power Play Enterprise Server PPES Upfront Server, Integration and IWR using NT and UNIX servers, Business Objects 6.1, Supervisor, Designer, Web Intelligence, Carbon Copy, Citrix, Sun Solaris, Linux and AIX Environments.

EXPERIENCE

Confidential

PeopleSoft Administrator

• Providing support for FSCM/Financials 9.1/EPM 9.1, Portal 9.1 with PeopleTools 8.51.07, 2 WebLogic 10gR3 multi-server using Oracle 10g/11g RAC databases on AIX 6.0 on ASM file system.
• Configured load balanced app servers using Tuxedo 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using Oracle 10 RAC databases.
• Configured load balanced web server and multi servers PIA using Weblogic 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft FSCM 9.1 environments using a hardware switch.
• Providing support for HRMS 8.9 with PeopleTools 8.49.17, 2 WebLogic 9.2 multi-server and Tuxedo 9.1 using Oracle 10g RAC databases on AIX 6.0 on ASM file system.
• Expertise in Tuning app server configuration files for Max clients per handlers , no of handlers and max PSAPPSRV and other processes and configuring app server load balancing.
• Expertise in Tuning web server/load balancing for optimal performance of HCM and SCM applications using appropriate PIA heap size configurations in multiserver web server environment and configuring VIP.
• Configured SSL, active directory, configured certificates, Single signon, apply Tax updates, bundles, and configuring application messaging using Integration broker for all PeopleSoft environments.
• Migrated legacy data from mainframe databases into Oracle PeopleSoft databases using PeopleTools DataMover.
• Installed ETL tool DataStage server and client tools.
• Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating, refreshing PeopleSoft databases using RMAN/ import export in RAC and non RAC databases.
• Exposure to Oracle wallet, quest foglight, and oracle datagaurd.

Confidential

PeopleSoft Administrator

• Provided production support for FSCM 9.1, EPM 9.1, HCM 9.1,Camous Solution 9.0 and Portal 9.1.
• Successfully completed SCM 9.1 /PT 8.51.06 upgrade from SCM 8.9, in development Test, QA and production environments.
• Successfully completed Campus Solutions 9.0/PT 8.49.21 implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases.
• Successfully completed PeopleTools upgrade to PT851.06 from PT849.21 for Campus Solutions 9.0 environments.
• Providing production support for Campus Solutions 9.0/Portal 9.1 with PeopleTools 8.51.06, 2 WebLogic 10gR3 multi-server 10 PIA /server using Oracle 11g/10 RAC databases on Red Hat Linux 5.0 on ASM file system.
• Expertise in setting up application Messaging using Integration Broker, gateway and setting up integration. properties configuration file.
• Expertise in legacy data conversion into Oracle database using PeopleSoft data mover scripts.
• Applied SCM Maintenance Packs 6 through 11using Change Assistant.
• Configured environment needed to start upgrade process i.e. setting up change assistant, downloading template from customer connection, creating change assistant job and follow through all the steps in change assistant job to finish the upgrade.
• Creating, refreshing PeopleSoft databases using RMAN/ import export in RAC and non RAC databases.
• Cloned/refreshed PeopleSoft environments from production as per business needs using RMAN and import/export, installing PeopleSoft databases, application servers, process schedulers, report repository, PIA, single sign-on, SSL certificates and load balancing.
• Installed ETL Tool DataStage for PeopleSoft EPM 9.1 environments.
• Troubleshot production /development environment issues, performance tuning of long running jobs in a timely manner to keep production /development environments up and running for smooth development/ production system.
• Installed and configured HCM 9.1 environments configure app/prcs/web server with PT8.51.06 DEMO for future upgrade using WebLogic 10gR3/Tuxedo 10 using Red Hat Linux 5.0 environment.
• Successfully completed CS 9.0 implementation for NYU using PT8.50.07 on Oracle 11g RAC database environment.
• Provided production support for Campus Solution 9.0, maintaining a huge 24 application server and 28 WebLogic multi-server PIA with a 3 node ASM RAC Oracle 11g databases environment.
• Installation, deign, testing, capacity planning, user, security, space management, migration and administration of PeopleSoft Oracle RAC 11g/10g databases environment on ASM file system.
• Troubleshot web servers PIA or any application related issues. Configured app/web, report repository, batch servers for Campus Solution 9.0 environments.

Confidential

PeopleSoft Administrator

• Successfully completed the PeopleSoft PeopleTools upgrade to PT849.21 from PT846.10 using Change Assistant with Oracle 10g CRM 8.8 databases on Sun Solaris 9 environment.
• Successfully completed the PeopleTools upgrade from PT844.17 to PT846.10, installed demo environment for HRM and SCM 8.4 sp2.
• Production support for SCM 8.9, CRM 8.8 and HRMS 8.8 with PeopleTools 8.49.17 using WebLogic 9.2, Tuxedo 9.1 and Oracle 10 databases on Solaris 9.0 / Red Hat Linux 4.0.
• Applied CRM bundles on a predefined schedule in CRM 9.0 environments starting from DEMO, DEV, TEST, Stage and production.
• Applying tax updates, dst patches, bundles, fixes and patches and performing PeopleSoft migrations.
• Installed and configured CRM 9.1 Demo environment, configure app/prcs /web server with PT8.50 for future upgrade using WebLogic 10gR3 / Tuxedo 10gR3 using Red Hat Linux environment.
• Successfully completed SCM 8.9 upgrade from SCM 8.4sp2 with PT849.10 from PT847.15. Configured Change Assistant job ran all the automated and manual steps.
• Configured app/web, report repository, batch servers for upgraded environments.
• Monitored PeopleSoft production databases for long running queries, datafile size and database availability on 24/7 basis.
• Configured and load balanced PeopleSoft SCM 8.9using apache RPS for WebLogic 9.2/WebSphere 6.1.
• Providing production support to PeopleSoft HCM 8.8, SCM 8.4 and CRM 8.8 using PeopleTools 8.47 on Oracle 9i databases using Solaris 9 environments.
• Set up new PeopleSoft environments requirement gathering analyzing space requirement, setting up web Server, single sign-on, PIA, application server/process schedulers on NT and Solaris
• Setting up app messaging, Integration Broker, Gateway, nodes, channels and Integration properties file.
• Tuning app server and web server/load balancing for optimal performance of HCM and SCM applications.
• Worked with PeopleSoft HCM developer to configure OIM, created and configured app messaging nodes and tested it with OIM.
• Production support for PeopleSoft Oracle 10g databases on a rotation basis.
• Refreshed / cloned PeopleSoft Oracle databases / environments dev, test, QA and Stage databases from production as per business requirement.
• Created new Oracle environments, creating tablespaces, roles, indexes and triggers, supported PeopleSoft databases using enterprise manager and command level SQL Plus level expertise in Oracle database administration.
• Expertise in implementing backup/restore strategies using RMAN for cold backups and HOT backups.
• Tuned application jobs for optimal performance identify and troubleshoot the performance bottleneck for scheduled jobs, identifying if correct indexes are used for optimal performance of SCM and HCM applications.
• Configured and developed shell scripts for handling day to day PeopleSoft administration and configured in job scheduling tool AutoSys for alert notification.
• Created and modified shell scripts to monitor PeopleSoft administration related alerts and configured in cron/AutoSys jobs.
• Configured and upgraded ImageNow 6.4 / 5.42 for PeopleSoft created Oracle 10g databases and needed roles, users and other ImageNow objects.
• Set up new PeopleSoft PT 8.47.15 environments, analyzing space requirement, creating application server, process schedulers on NT and Solaris environments.
• Provided production support, helping developers group for PeopleSoft objects migration, troubleshooting and resolving production helpdesk ticket issues.
• Monitored app/web servers to function properly and make sure production environments are UP for users during business hours.
• Provided production and development support for day-to-day administration activities for monitoring App and Web Servers, PeopleSoft migrations Project, SQR, nvision between different environments.
• Set up PeopleSoft security permission list, row level security with LDAP directory server.

Confidential

PeopleSoft Administrator

• Successfully completed PT 846.08 and SCM 8.9 upgrade using DB2 on ZOS environment on AIX 5.3
• PeopleSoft/Oracle databases and environment setup, installation, design, testing, capacity planning, space management, migration and administration of Oracle Database versions 9i.
• Set up Change Assistant, creating CA job from PeopleSoft provided template executing CA steps manually and automated. Faced many upgrade related problems but resolved all issues in a timely manner.
• Set up Peoplesoft Single Sign-on/Site Minder setup, Tuxedo 8.1 application server and WebLogic 8.1 clustering environment.
• Created new instances for PeopleSoft environment and configuring app/web and batch servers on AIX and NT
• Used QUEST STAT tool for PeopleSoft objects migration between different environments i.e. Development to Test and QA and Production.
• Created and managed users, roles and profiles in the Oracle 9i environment for database access.
• PeopleSoft day-to-day administration responsibilities for monitoring App and Web Servers, PeopleSoft migrations Project, SQR, nvision between different environments.
• Provided PeopleSoft maintenance and Production support for PeopleSoft Financials 8.8, AR, AP, GL and HRMS 8.3, HR, Payroll and Benefits, EPM 8.9 on Oracle 9i / DB2 databases using Solaris and AIX environment.
• Applied bundles, patches, fixes, application updates and tax updates using Change Assistant.

Confidential

PeopleSoft Administrator

• Provided production support for PeopleSoft Financials 8.4, EPM 8.8, CRM 8.4 and HRMS 8.3 using Oracle databases on AIX 5.3.
• Set up new PeopleSoft environments, requirement gathering analyzing space requirement, creating application server, process schedulers on NT and HP UNIX environments.
• Set up SQL clients and other software on users' machines and providing support to developers remotely.
• Successfully completed PeopleTools upgrade from 842 to 844 and application upgrade SCM 84 to 84 SP2 using upgrade assistant.
• Ran and analyzed compare reports before and after upgrade, downloaded upgrade template and required for upgrade files from customer connection.
• Created Upgrade assistant job and executed errored jobs manually.
• Performed day-to-day activities of a PS admin, monitoring PeopleSoft environments, PeopleSoft objects migration, taking care of production issues, working with developers to resolve their environment related issues.
• Tuned Tuxedo 6.1/8.1 and WebLogic 8.1, tuning max handler/min handlers, increasing Tuxedo queue size, tuning OS level kernel parameters, turning on load balancing in Tuxedo which is turned off by PeopleSoft, tuning heap size in WebLogic for optimal performance of PeopleSoft applications.
• Created new PeopleSoft PIA environment, UNIX / NT process scheduler for PeopleTools 8.46, created report nodes and setup report repository, compiled COBOL and tested sample processes on UNIX / NT Scheduler and SQR and Crystal reports.
• Applied PeopleSoft Financials patches fixes and Bundles as per requirement.
• Created load balancing application servers and WebLogic 8.1 Web Server to point proxy PIA
• Configured Application-Messaging servers configures Application Messaging Gateway, creating channels, and messaging nodes using Integration Broker utility and monitoring messages with Application Message Monitor.
• Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory, LDAP integration, and Single Sign on implementation.
• Successfully installed PeopleBooks on WebLogic PSOL server with context sensitive help enabled.
• Create and troubleshot Mercury LoadRunner scripts to Load Test PeopleSoft SCM and HRMS applications.

Confidential

PeopleSoft Administrator

• Provided PeopleSoft maintenance and Production support for Time Warner Cable, TWC have PeopleSoft live from last 2 years with HRMS 8.3 and Financial 8.4, EPM 8.8 and Portal using PeopleTools 8.43 and 8.18 using Oracle 9i databases on Linux and Solaris environment.
• Set up Informatica Server 6.1 administration and support Informatica Server Start/Shutdown, Cleaning Cache, Disk Space Management, Repository Backup for different PeopleSoft EPM environments.
• Supported PeopleSoft environments using SQL Server 2000 databases, used T-SQL and little bit database administration.
• Integrated the application servers, process schedulers, Tuxedo 6.5, and WebLogic 6.1 servers using Oracle 9i Solaris environment.
• Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory, LDAP integration, and Single Sign on implementation.
• Tuned Tuxedo 6.1/8.1 and WebLogic 8.1, tuning max handler / min handlers, increasing tuxedo queue size, tuning OS level kernel parameters, turning ON load balancing in tuxedo which is turned off by PeopleSoft, tuning heap size in WebLogic for optimal performance of PeopleSoft applications.
• Set up Single Sign-On for Portal using Netscape Directory Server 6.01 LDAP Lightweight Directory Access Protocol for Peoplesoft applications.
• Set up and creating Links between different Portal applications includes PeopleSoft and HRMS, Financials.
• Applied Tax Updates 04A to HR environment and applied application Updates and Bundles fixes and patches as per the functional needs.
• PeopleSoft general day-to-day administration responsibilities for PeopleSoft Project, SQR, nvision Migration between different environments.
• Configured Application-Messaging servers configures Application Messaging Gateway, creating channels, and Messaging Nodes using Integration Broker utility and monitoring messages with Application Message Monitor.
• Configured Netscape Directory Server NDS , Object Store 6.1, Cognos Powerplay Enterprise Server PPES 7.1, Upfront Server, Access Manager, Impromptu Administrator, IWR and Transformation Server on Solaris.
• Successfully created and published IMR, ppr, ppx reports, Catalogs, Cubes, on Powerplay Enterprise Server and Upfront Server.
• Supported developer team for PeopleSoft HRMS and Financials Implementation.
• Developed the UNIX/ Batch scripts to help manage the PeopleSoft and Informatica server environment.
• Worked with PeopleSoft development tools and methodology, including PeopleTools, PeopleCode, Application Designer, Application Engine, and Application Messaging.
• Creating new Oracle databases for PeopleSoft environment and monitoring for day to day activities.
• Installation, Design, Testing, Capacity Planning, Space Management, Migration and Administration of Oracle Database versions 9i.
• Creation and Management of users, roles and profiles in the Oracle 9i environment for database access.
• Created Database storage structures User Tablespaces, Index Tablespaces and Undo Tablespaces. Allocate system storage and plan for future storage requirements for the databases.

Confidential

PeopleSoft Administrator

• Supported developer's team for PeopleSoft CRM 8.8, HRMS, EPM and Financials Implementation.
• Responsible for setting up development, testing and production database environments.
• Granted and managed necessary system, user, and object privileges to the respective users and roles.
• Expertise in migration of PeopleSoft Projects, running Compare Reports and sync, SQR's, Crystal Reports and nVision reports between environments.
• Responsible for PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, PeopleSoft Directory, NDS, LDAP integration, and Single Sign-on for Portal implementation.
• Provided Production support for PeopleSoft CRM 8.8, HRMS 8.8, Portal 8.8 and Financials 8.4 and resolved day to day production issues.
• Created database storage structures User Tablespaces, Index Tablespaces and Undo Tablespaces. Allocate system storage and plan for future storage requirements for the databases.
• Administration support for PeopleSoft Financials A/P, G/L, A/R and HRMS Benefits admin, Payroll etc and PeopleSoft EPM FTP, ABM and workforce Analytics.
• Expertise in performing migrations PeopleSoft projects, SQRs, and crystal/ Nvision reports between environments.
• Configured Application-Messaging servers, configure Application Messaging Gateway, creating channels, and Messaging Nodes using Integration Broker utility and monitoring messages with Application Message Monitor.
• Configured WebLogic, Tuxedo and Jolt on UNIX/NT, PeopleSoft Web Servers WebLogic 6.1 on Sun Solaris and PeopleSoft application servers Tuxedo and Process Schedulers using NT and UNIX environments.
• Configuration experience in creating Report Server, Report Repository, Integration Broker, Batch Server and PeopleBooks using NT and UNIX environment.
• Used Terminal Server, VPN, PC Duo and worked from home to resolve immediate issues like bounce the App servers, web Servers fixing report server problems.
• Expertise in SQR HRMS and FIN App Messaging and App Engine.

Confidential

PeopleSoft Admin PeopleSoft/DB2 Mainframe OS390

• Experienced as PeopleSoft administrator at BCBS, responsibilities includes setting up and maintenance of PeopleSoft HRMS Payroll, T L and Financials AP, AR GL applications environment, using DB2 databases for HR/Financials Tech, Functional and Testing environments for developer's.
• Installed, configured and maintained the PeopleSoft HRMS 8.0/8.3 and Fin 8.0/8.4 Process scheduler and application servers.
• Installed and maintained PIA using IBM AIX 5.1/Citrix/CarbonCopy environment.
• Successfully installed and configured Web Servers using WebLogic 5.1/6.1 and PeopleSoft Internet Architecture on AIX 5.1 using IBM Regatta RS 6000 p670.
• Successfully upgraded PeopleTools 8.18 to 8.43 using PeopleSoft delivered template and Upgrade Assistance for Financials and HRMS environments.
• Supported PeopleSoft environments using SQL Server 2000 databases, used T-SQL and little bit database administration.
• Expertise with PeopleSoft Security components: permission lists, roles, user and data permissions, reporting Security, PIA, LDAP integration, PeopleSoft Directory Server and Single Sign-on.
• Load balancing App Servers and Web Logic servers creating failover App Servers.
• Experience in tuning Financials and HRMS applications using DB2 UDB environments.
• Responsibilities includes support to PeopleSoft HRMS and Financials developers monitoring App/Web Servers, clearing cache files, generating trace files, bouncing App/Web servers, migrating projects between environments.
• Successfully performed PeopleTools upgrade from 8.18 to 8.42.
• Administration of Process schedulers on NT, AIX and OS390.
• Configured Application Messaging Servers, Business Interlinks, Channels, and Gateway Configuration, adding handlers, loading handlers and adding Messaging Nodes.
• Set up EPM and Enterprise Data Warehouse environment for ETL tool Informatica and OLAP tools Cognos and Business Objects for PeopleSoft EPM for ODS and Warehouse layer.
• Installed and configured Informatica Server/client, setting up Netscape Directory Server NDS , Object Store, Access Manager, Cognos Power Play Enterprise Server PPES , Power Play Upfront Server, IWR, Impromptu Administrator, Transformer and Power Play on NT and Unix
• Created mappings and sessions using ETL tool Informatica, and catalogs and reports using Power Cubes from Transformer of Cognos.
• Implementation of Business Objects 6.1 applications, created and modified universe, joins, resolved loops, and Business Objects reports.
• Successfully installed PeopleBooks and PeopleTools 8.17/8.18 8.41/42 for HRMS and Financials environments.
• Successfully installed and developed Batch Process scheduler servers for HRMS 8.3 and FIN 8.4 .