PROFESSIONAL SUMMARY:

• 17 years of experience that includes consulting and Managing PeopleSoft, Database, Lawson projects.
• Conducted various workshops with the businesses prioritizing requirements, evaluating analytical/ERP product and arriving at right fitment for the purpose.
• Sound knowledge on PeopleSoft Implementation, Integration, Interface and support
• PeopleSoft Lead consultant at onsite for Confidential, California and Ohio.
• PeopleSoft Lead Consultant for Confidential, California.
• Involved in full life cycle implementations, upgrades, and Maintenance of Development, QA, UAT and Production environments of PeopleSoft HCM, FSCM, CRM, Enterprise Portal & EPM applications.
• Proficient in PeopleSoft Environment on both UNIX and Windows Platforms, PeopleSoft Security, Project Migrations, Refreshes, Applying Tax updates, Bundles and Patches.
• Sound knowledge of the customized cloud (Hyper V environments).
• Familiar with Single Signon, Ldap Integration, Integration broker configuration and Application Messaging.
• Worked on the new features like Oracle SES integration/configuration and PeopleSoft Upgrade manager (PUM) for applying the Tax updates/Patches/Bundles.
• Good knowledge of BEA Tuxedo, Web Server, Application Server.
• Well versed with Security Best Practices in the industry.
• Experience in performing requirement analysis, project planning, proposals and design skills including developing technical specifications for migration of People tools across OS.
• Exposed and supported to various stages of life cycle development and have gained extensive knowledge in quality management, project management, communication and presentation skills.
• Handled data migration projects from legacy to ERP system/product.
• Experience in Capacity Planning, Data Center Management and Disaster Recovery System.
• Strong Team Management, Communication, Interpersonal and Presentation skills.
• Experience in migration of the customizations across various environments.
• Excellent analytical and troubleshooting skills.

TECHNICAL SKILLS:

ERP: PeopleSoft v8x, 9x (HCM/FSCM/CRM/EPM/PORTAL)

Operating Systems: Sun Solaris 8, 9 & 10 AIX 5.1, 5.3 & 6 HP - UX, Linux, Windows 2000, 2003, 2008, 2012 NT

Languages: SQL.

RDBMS: Oracle 8i, Oracle9i, Oracle 10g & 11G, Sql Server 2012.

Middleware Server: BEA Weblogic, Tuxedo/Jolt, Oracle Application server, IBM WebSphere

Tools: & Utilities: PeopleTools 8.4x,8.5x Data Mover, Application Designer, Change Assistant, Integration Broker, Oracle sql developer, Toad, sql server 2012, WinSCP3, PuttyFTP, Telnet, Toad, OEM and Xmanager and VSS, SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, California

Environment: PeopleTools 8.53/8.54 PeopleSoft HCM 9.2, FSCM 9.2, Portal 9.1, Webogic 10.3.6.17 Tuxedo 11gR1,Oracle 10G Release 2, Sql Server 2012.

Consultant

Responsibilities:

• Extensively involved in the project planning for Application deployment and maintenance.
• Managing 63 PeopleSoft FSCM/HCM/PORTAL environments on the customized cloud (Hyper V environments).
• Architected overall system configuration, load balancing, integration and security for high availability and scalability.
• Performed Lawson ERP migration from Solaris to Linux.
• Responsible for Lawson security and Application and database Administration.
• Upgraded the HCM Image 13 to Image 20.
• Responsible for installation of the environments required for Initial and Move to Production Passes.
• Responsible for installation and setup of SES (Secure Enterprise Search), Oracle Virtual Box, PUM (PeopleSoft Update Manager).
• Setup of Disaster Recovery for Lawson in Data Center.
• Setup of Disaster Recovery for PeopleSoft FSCM/HCM in Data Center.
• Created the Portal Interaction HUB 9.1
• Created the Candidate Gateway for HCM environment.
• Setup REN Server, LDAP with Active Directory.
• Setup for SSL Offloading on Load balancer.
• Responsible for installation and setup of SES (Secure Enterprise Search), Oracle Virtual Box, PUM (PeopleSoft Update Manager).
• Applying tax updates, Bundles/patches/Fixes with PUM and Change Assistance.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and Training purposes.
• Migration of code in all environments (Development, STG, TST, Q/A, UAT and PROD) on Adhoc basis.
• Extensively involved in system testing, integration testing and performance testing.
• Provided hyper care support, assisted customer to troubleshoot and resolve issues identified after Post Go-Live
• Performs all task related to oracle database administration and Sql server 2012 administration
• Supports in System Administration: Building Virtual box, Solaris Server & Troubleshooting.

Confidential, Los Angeles, California

Environment: PeopleTools 8.51.10, 8.48.07 PeopleSoft HCM 9.1, FSCM 8.9, Weblogic 11gR1 Tuxedo 10gR3, Oracle 10G Release 2, DB2 8.1 z/OS.

Architect

Responsibilities:

• Supported California, Canada and Ohio site of Honda for both PeopleSoft HCM 9.1 and FSCM 8.9 systems.
• Designed Metadata Audit report to analyze user activity, frequency of access and memory usage needed for reporting governance.
• Responsible for preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and Training purposes.
• Created Run Guide and SOP for access control, library management and server cleanup activities.
• PeopleTools upgrade patch from PT8.50.14 to PT8.50.24 Finance system to resolve long pending issues.
• Supported the Third party system DataStage(ETL), MQ client, Xign, Right Fax, Optim and MERKER (which is responsible for sending Purchase Orders).
• Support issues related to HR External candidate gateway applicant sites for both Ohio & Indiana.
• Created new weblogic domains and Installed SSL certificates on PeopleSoft HCM Prod & Non Prod envs.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Maintaining a date wise log of migrations to each of the instance. Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Applying Tax updates, bundles and patches across various environments.
• (Viz: Demo-Dev-INT-UAT-Prod).
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating the explain plan for the query tuning.
• Tuning the webserver and application server as per the business requirement.
• Monitoring the long running quires and generating the AWR report to find the Root Cause.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Environment: HCM/ELM/CRM/Portal 8.9 9.0, PT8.48, PT8.49, Weblogic 11gR1 Tuxedo 10gR3, Oracle 8i,9i,10G,11g, sql server 2008.

Consultant

Responsibilities:

• Managed team of 20 PeopleSoft Administrator, Oracle DBA and Sql Server DBA to maintain and support 1200 various application including PeopleSoft HCM/CRM/ELM/Portal 8.9 9.0 and coordinating with client on daily basis.
• Tracking and reporting project deliverables to Confidential management.
• Responsible for documentation of technical requirements and Production outages.
• Design of Metadata Audit report to analyze user activity, frequency of access and memory usage needed for reporting governance.
• Capacity Planning.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and Training purposes.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Checking the compatibility of the hardware and Software.
• Maintaining a date wise log of migrations to each of the instance. Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Applying Tax updates, bundles and patches across various environments
• (Viz: Demo-Dev-INT-UAT-Prod).
• Uploading the data in PeopleSoft with the help of CI (Component interface).
• Carrying out Pre-refresh and Post-Refresh Activity.
• Monitoring the Sessions in Production database and killing the unwanted sessions as per the request.
• Monitoring long running Processes from backend by grabbing the SQLs and analyzing the tables and indexes as per requirement.
• Creating the explain plan for the query tuning.
• Tuning the webserver and application server as per the business requirement.
• Monitoring the long running quires and generating the AWR report to find the Root Cause.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Analyzing customer defined tables on a fortnightly basis.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Environment: PeopleSoft HRMS 8.9/8.47, PeopleSoft Portal 8.9/8.49,Oracle 10G.

PeopleSoft Lead

Responsibilities:

• Preparing activity schedule and coordinating with team members.
• Capacity Planning.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for UAT/ TEST/ DEV and Training purposes.
• Configuration of PeopleSoft with the exchange server using Multi Channel Frame work.
• Maintaining a date wise log of migrations to each of the instance.
• Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Preparing activity schedule and coordinating with team members and Oracle Consultants.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Updating database statistics regularly.
• Checking the compatibility of the hardware and Software.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• Uploading the data in PeopleSoft with the help of CI (Component interface).
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating the explain plan for the given query as per the requirement.
• Monitoring the long running quires and generating the AWR report for get the Root Cause.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Environment: PeopleSoft HRMS 8.9/8.47, PeopleSoft Portal 8.9/8.49,Oracle 10G

PeopleSoft Lead

Responsibilities:

• Prepared activity schedule and coordinating with team members.
• Capacity Planning.
• Provided Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and Training purposes.
• Involved in the Oracle database form non-Unicode to Unicode.
• Upgrading the PeopleSoft application from non-Unicode to Multi-lingual by applying translation.
• Importing the translated string into database using External Tables.
• Maintaining a date wise log of migrations to each of the instance. Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Updating database statistics regularly.
• Checking the compatibility of the hardware and Software.
• Setup Department trees for each of the Business Units after discussing with Functional Team.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Applying bundles and patches across various environments (Viz: Demo-Dev-INT-UAT-Prod).
• Creating the explain plan for the given query as per the requirement.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Analyzing customer defined tables on a fortnightly basis.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Environment: PeopleSoft HRMS 8.9/8.47, PeopleSoft Portal 8.9/8.49,Oracle 10G.

PeopleSoft Lead

Responsibilities:

• Preparing activity schedule and coordinating with team members.
• Capacity Planning.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for UAT/ TEST/ DEV and Training purposes.
• Configuration of PeopleSoft with the exchange server using Multi Channel Frame work.
• Maintaining a date wise log of migrations to each of the instance.
• Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Preparing activity schedule and coordinating with team members and Oracle Consultants.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Updating database statistics regularly.
• Checking the compatibility of the hardware and Software.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• Uploading the data in PeopleSoft with the help of CI (Component interface).
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating the explain plan for the given query as per the requirement.
• Monitoring the long running quires and generating the AWR report for get the Root Cause.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Environment: PeopleSoft HRMS/ELM 8.9, PeopleSoft Tools 8.46,Oracle 10G.

Assistant PeopleSoft Manager

Responsibilities:

• Capacity Planning.
• Checking the compatibility of the hardware and Software.
• Responsible for creating Application, web and process scheduler servers, installing tuxedo and Web logic on Linux and Windows environments.
• Preparing activity schedule and coordinating with team members.
• Checking on the license required and co coordinating with procurement team.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Providing Production support for PeopleSoft Applications and Databases.
• Taking care of PeopleSoft Security Admin activities.

Confidential

Environment: PeopleSoft HRMS/ELM 8.9, PeopleSoft Tools 8.46,Oracle 10G

Assistant PeopleSoft Manager

Responsibilities:

• Responsible for preparing activity schedule and coordinating with team members.
• Responsible for creating Application, web and process scheduler servers, installing tuxedo and Web logic on Linux and Windows environments
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for UAT/ TEST/ DEV and Training purposes.
• Maintaining a date wise log of migrations to each of the instance.
• Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Responsible for PeopleSoft Security Admin activity
• User support for forgotten / expired passwords, account lockouts etc.
• Setup Department trees for each of the Business Units after discussing with Functional Team.
• Setup of Data / Row Level Security and executing/scheduling security process as per requirement.
• Setup Row level permission list.
• Maintaining a date wise log of migrations to each of the instance. Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Applying bundles and patches across various environments (Viz: Demo-Dev-INT-UAT-Prod).
• Uploading that the data in PeopleSoft with the help of CI (Component interface).
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Cleaning up the Stale data in Prcs scheduler tables in Production and Non-Production environment from backend to ensure that the Prcs server is working fine.
• Analyzing customer defined tables on a fortnightly basis.

Confidential

Environment: PeopleSoft HRMS/ELM 8.9, PeopleSoft Tools 8.46,Oracle 10G.

Assistant PeopleSoft Manager

Responsibilities:

• Prepared the cutover plan for Time and Labor along with technical team executed the migration tasks following the process.
• Involved in rolling out the Time & Labor model for WNS across the Geographical region.
• Providing Production support for PeopleSoft Applications and Databases.
• Setup Department trees for each of the Business Units after discussing with Functional Team.
• Preparing activity schedule and coordinating with team members.
• Maintaining a date wise log of migrations to each of the instance. Communicating with PeopleSoft through Customer Connection to report issues and seek advice.
• Troubleshooting problems with Application Server, Web Server and Process Scheduler Server of each instance.
• Migration of the customizations across various environments (Viz: Dev-INT-UAT-Prod).
• Applying bundles and patches across various environments (Viz: Demo-Dev-INT-UAT-Prod).
• Responsible for PeopleSoft Security Admin activity.
• Uploading that the data in PeopleSoft with the help of CI (Component interface).
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating the explain plan for the given query as per the requirement.
• Monitoring the Sessions in Production database and killing the unwanted sessions as per the request.
• Involved in performance tuning activities like monitoring long running sqls and running the explain plan on long running sqls, running stats and building of indexes when required.
• Scheduling the jobs in Oracle database and also at PeopleSoft level.
• Cleaning up the Stale data in Prcs scheduler tables in Production and Non-Production environment from backend to ensure that the Prcs server is working fine.
• Analyzing customer defined tables on a fortnightly basis.