SUMMARY:

• Confidential has overall 10.5+ years of IT experience out of which 9.5+ years of experience in PeopleSoft Database Administration (PSDBA).
• 24x7 Production Support, Maintenance and Implementation. Worked on PeopleSoft HRMS/HCM/FSCM/CRM/EPM/PORTAL 9.1, 9.0, 8.9 and 8.8 and People Tools PT 8.44, PT8.46, PT 8.47, PT8.48, PT8.49, PT8.50.24, PT8.50, PT8.51.
• Extensively worked on installing the PeopleSoft Environment on both UNIX and windows Platforms, PeopleSoft Security, Project Migrations, Refreshes, Applying Tax updates, Bundles and Patches.
• Experience in migration of the customizations across various environments.
• Experience in Creating Roles, Permission list, user profiles, adding components to Permission list.
• Experience in applying Tax - updates/Bundles/Patches etc.
• Experience in Refreshes of Databases.
• Experience in performing requirement analysis, project planning 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.
• Excellent analytical and troubleshooting skills.

TECHNICAL SKILLS:

ERP: PeopleSoft HRMS/FSCM 8.x /9.x

PEOPLETOOLS: PT8.44, PT8.46, PT8.47, PT8.48. PT8.49, PT8.50, PT8.51

OPERATING SYSTEMS: AIX 5.2, HP UNIX, Red Hat Linux 9.0, Solaris 10, Windows .

LANGUAGES: Shell Scripting, Perl.

MIDDLEWARE: BEA Tuxedo/Jolt.

DATABASES: Oracle 8i, Oracle9i, 10g (RAC), 11g

Performance Monitoring Tools: Quest TOAD 9.1, OEM for oracle.

TOOLS: Application Designer, Data mover WinSCP3, Putty, Remotely anywhere, FTP, Telnet, Toad, OEM and Xmanager and VSS

PROFESSIONAL EXPERIENCE:

Confidential (Los Angeles, California)

Senior Consultant/Tech Lead

Responsibilities:

• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and purposes.
• Recently applied PeopleTools upgrade patch from PT8.50.14 to PT8.50.24 Finance system.
• Handles the Third party system DataStage(ETL), Xign, Optim and MERKER (which is responsible for sending Purchase Orders)
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Updating database statistics regularly.
• Preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• User support for forgotten / expired passwords, account lockouts etc.
• 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
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Senior Consultant

Responsibilities:

• Capacity Planning.
• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and purposes.
• Monitoring Database, web server, application server Performance and activity.
• Performing backup and restore for database.
• Checking the compatibility of the hardware and Software.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• User support for forgotten / expired passwords, account lockouts etc.
• 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
• 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).
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Technical consultant

Responsibilities:

• Providing Infrastructure support in terms of PeopleSoft Installation, Administration & configuration by creating new PS environments for PROD/ UAT/ TEST/ DEV and purposes.
• Configuration of PeopleSoft with the exchange server using Multi Channel Frame work.
• 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.
• Preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• User support for forgotten / expired passwords, account lockouts etc.
• 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).
• 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).
• Creating users in PIA, resetting, dropping the users and granting the required roles and privileges.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Creating Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Technical consultant

Responsibilities:

• Upgrading 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.
• 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.
• Preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• Running the Role Query.
• User support for forgotten / expired passwords, account lockouts etc.
• Setup Department trees for each of the Business Units after discussing with Functional Team.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• 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 Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Technical consultant

Responsibilities:

• 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.
• Preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• Running the Role Query.
• User support for forgotten / expired passwords, account lockouts etc.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• 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 Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Responsibilities:

• Capacity Planning.
• Checking the compatibility of the hardware and Software.
• Preparing activity schedule and coordinating with team members and ORACLE CONSULTANTS.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• Running the Role Query.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• 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 Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• 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.
• 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.
• Creating and configuring Application, Process Scheduler and Webservers for Non-Prod environments.

Confidential

Responsibilities:

• Preparing activity schedule and coordinating with team members.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• Running the Role Query.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• 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 Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• Monitoring long running Processes from backend by grabbing the SQLs and analyzing the tables and indexes as per requirement.
• 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

Responsibilities:

• Preparing activity schedule and coordinating with team members.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• Creating Roles, Permission list, adding components to Permission list.
• Add / Delete/ Update User Profiles, Roles and Permission List.
• Running the Role Query.
• 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.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• 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 Database users, resetting, dropping the users and granting the required roles and privileges.
• 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.
• Monitoring long running Processes from backend by grabbing the SQLs and analyzing the tables and indexes as per requirement.
• 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

Responsibilities:

• Preparing activity schedule and coordinating with team members.
• Providing 24x7 Production support for PeopleSoft Applications and Databases.
• 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.
• Configuration of messages using Integration Broker for real-time data exchange between PeopleSoft HRMS & Finance application.
• 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).
• Building, verifying and then executing script for Tables/Views/Indexes on database of Production and Non-Production instances.
• Carrying out Pre-refresh and Post-Refresh Activity.
• Performing hot and cold backup and restore for database
• Performing Run stats and reorg on database.
• Performed the Weekly Server Maintenance which involves the Reboots of DB, Web and Application server.
• Creating, resetting, dropping the users and granting the required roles and privileges.
• 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.
• Monitoring long running Processes from backend by grabbing the SQLs and analyzing the tables and indexes as per requirement.
• 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.
• Applying Tax-update across various environments (Viz: Demo-Dev-INT-UAT-Prod).
• Creating and configuring Application, Process Scheduler and Web servers for Non-Prod environments.
• Involved in People Tools upgrade PT8.44.15 to PT8.48.18.
• Creating Business reports for client on monthly basis.
• Preparing and maintaining audit reports in the VSS.
• Conducting sessions for Entry level trainees on PeopleSoft System Administration and Oracle SQL.

Confidential

Responsibilities:

• Writing Perl, Shell programs for generating reports.
• To generate reports (using Latex tool).
• Uploading data in Excel sheet (Pipe de-limited format) to database.
• Creating data entry screens for Data entry operators.