Professional Summary

• 13 Years of experience in IT Industry in the areas of Analysis, Design, Development, Implementation, Administration and Production Support.
• 10 Years in ERP implementations Support as a PeopleSoft Administrator supporting mainly PeopleSoft Financials and HRMS applications on Oracle and MS SQL Server.
• Installed and supported PeopleSoft applications on UNIX and NT Environments.
• PeopleSoft Server Administration, expertise in installation, configuration, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
• Worked extensively on Production Support On call support as well as in implementation and support of Development, Test, UAT and various other PeopleSoft environments.
• Worked extensively in implementation and Support of PeopleSoft HRMS 8.x, 9.x and PeopleSoft Finance 8.x, 9.x and was responsible for applying patches, applying maintenance packs and tax updates.
• Ensured system availability by implementing failover by spreading multiple domains across multiple hosts
• Have Good knowledge in PeopleSoft Tools/Application Upgrade and successfully upgraded from HRMS 8.3 to HRMS 9.0.
• Extensive experience in refreshing development QA from Production database and also migrating changes to QA and Production
• As part of PeopleSoft Admin role handled Security tasks like creating new users for the environment and Managing Roles and Permission Lists for the PeopleSoft users.
• Have good knowledge and understanding of Autosys and scheduling jobs as per requirements.

As Manager

• Work as Onsite and Offshore coordinator
• Responsible for Offshore deliverable of PS Admin, Oracle DBA and Autosys teams.
• Ensure SLA's are maintained and manage escalations as and when required.
• Ensure all the tickets raised are worked on and generate monthly reports for workload monitoring.
• Attend Weekly meetings with Client and ensure proper RCA is done and the reports with solutions are provided to the client.
• As part of Change Management, ensure changes being made do not impact other environments or functionalities and ensure proper backup plans are in place.
• Shift and On Call planning.

Appreciations:

• Received many awards like Best Team, Project Start, Superior Performance, Best Performer for different projects based on the VOC.

Technical Skills

People Tools: Application Server, Process Scheduler and PeopleSoft Utilities, Application Designer, People Code and Application Engine, Security Administrator, Object Security, Query Security and Tree Manager, PS Query Tool, Integration Broker, Configuration Manager

SKILL

ERP Applications: PeopleSoft Financials, HRMS, Portal, EPM and CRM

WEB Servers: Web Logic 11gR1, Apache

Middleware: Tuxedo 11gR1

Reporting Tools: SQR, Crystal Reports

Operating Systems: Windows, UNIX

Databases: Oracle 8i/9i/10g/11g

Tools: Visual Basic 6.0, HTML, DHTML, XML, ASP, PVCS, Autosys, Tivoli,

Control-M, Assima

Languages: C, C , SQL

Professional Experience

Confidential

Role: PS Admin and Autosys Developer

As PS Admin, was responsible for

• Providing On-Call Production Support.
• Deliver technical expertise by troubleshooting and resolving PeopleSoft related Issues.
• Monitoring, Administration and Tuning of App Server, Process Scheduler and Web Servers.
• Troubleshooting Web Server and App Server Issues
• Applying Tax Updates.
• Migration of objects Internal and External from one region to other.
• Work closely with Development, Oracle DBA and Solaris to help in troubleshooting and resolving issue.
• Work with the upgrade team to help upgrade and resolve upgrade issues.

As Autosys Developer, was responsible for

• Providing On-Call Production Support.
• Monitoring of Batch jobs scheduled on Autosys
• Schedule new jobs using Autosys in PeopleSoft and on Unix to manage file transfers in between servers and also to 3rd party servers.
• Work closely with Development, Functional and Oracle DBA to help in troubleshooting batch jobs issues.

Environment: PeopleSoft HRMS 8.9 9.2 PeopleSoft FIN 8.9 9.2, PeopleTools 8.52 8.53, Oracle, OEL 5.6, Windows, Autosys11.

Confidential

Role: PS Admin Lead

As PS Admin, was responsible for

• Providing On-Call Production Support.
• Deliver technical expertise by troubleshooting and resolving PeopleSoft related Issues.
• Monitoring, Administration and Tuning of App Server, Process Scheduler and Web Servers.
• Troubleshooting Web Server and App Server Issues
• Applying Maintenance packs and Patches as and when required.
• Implementation of SSL
• Involved in planning, setup and testing of DR
• Migration of objects Internal and External from one region to other.
• Perform database refreshes as and when required using export import utilities.
• Designed Maintenance Scripts to do weekly Restarts, Cache clear and Log Cleanup of PeopleSoft Domains.
• Developed script to monitor Integration Broker Messages and send alerts if messages go to error.
• Developed script to monitor all the PeopleSoft admin user profiles and send alerts if the passwords are about to expire
• Developed script to monitor the SMTP server and send an alert if SMTP server is not responding.
• Developed script to monitor the memory utilization of the Application server processes and send alerts if required.
• Generate and check the AWR report daily to see if there are any problematic sqls which are taking more time and work with the Development team to tune them if required.
• Work closely with Development, Oracle DBA, Solaris to help in troubleshooting and resolving issue.
• Work closely with the Control M team to schedule and monitor PeopleSoft Interface and Batch jobs.

As Lead

• Attend Weekly Incident meetings with Client.
• Generate Monthly Interface/Batch jobs status, Concurrent users, SLA, Major Incident and Environment availability reports.
• Generate weekly and monthly management reports like Incident, KPI, Workload, Effort tracking etc.
• Shift and On Call planning.

Environment: PeopleSoft HRMS 8.9ML, PeopleTools 8.49, Oracle, Solaris, Windows, Assima language conversion tool , Control-M

Confidential

Role: PS Admin

As PS Admin, was responsible for

• Install the required Demo Instances.
• Download the required template and scripts required for Upgrade.
• Configure and run jobs for Upgrade through Change Assistant.
• Monitor the upgrade jobs and troubleshoot the issues.
• Perform all the manual steps involved in an upgrade.
• Co-ordinate with the technical team in preparing the Copy of Production for upgrade.
• Co-ordinate with the technical team in analyzing the compare reports.
• Taking backups and restoring them when ever required.
• Adding of new data files to the database, analyzing the database for better performance of the upgrade jobs.
• Prepare documents which contains all the details like the down times required, errors occurred and resolutions, backups, space requirements e.t.c.
• Assist the technical team in identifying the object changes to prepare documents like record differences structural, new, deleted records , Component changes New, deleted , Component Page Changes New pages added, Pages deleted , Page differences in components new pages, deleted pages and also Records referred in each page.

Environment: PeopleSoft HRMS 8.0/8.9/9.0, PeopleTools 8.21/8.49, Oracle, AIX, Windows.

Confidential

Role: PS Admin

As PS Admin, was responsible for

• Day-to-day Support.
• Monitoring and Administration of App Server, Process Scheduler and Web Servers.
• Trouble shooting PeopleSoft related Issues.
• Refresh of development database with production
• Applying patches and maintenance packs.
• Migration of objects from one Instance to another

Environment: PeopleSoft CRM 8.9, People Tools 8.44, Oracle, Solaris, Windows.

Confidential

Role: PS Admin

As PS Admin, was responsible for

• Migrating Data from DB2 to Oracle.
• Compare the Table Structure between DB2 and Oracle.
• Calculate Approx time to migrate data from DB2 to Oracle.

Environment: PeopleSoft Finance 8.0, People Tools 8.19, Mainframe DB2, Oracle, Mainframe, AIX, Windows.

Confidential

Role: PS Admins

As PS Admin, was responsible for

• Day-to-day Support.
• Monitoring and Administration of App Server, Process Scheduler and Web Servers.
• Trouble shooting PeopleSoft related Issues.
• Configure and Monitor the interfaces.
• Monitor the incoming and outgoing files.
• Prepare scripts to move inbound/outbound files from the ftp servers to the PeopleSoft Servers and vice versa.
• Monitor the Paycycle Jobs.
• Schedule the PeopleSoft Jobs and scripts using Autosys.
• Prepare Autosys jobs for the newly created PeopleSoft Jobs and Unix/FTP Scripts.
• Reschedule the existing Autosys Jobs.
• Clearing all the old log files on all the servers.
• Recreating Indexes.
• Monitoring the tablespaces.
• Migrate objects Internal and External from one region to other.
• Grant PS/Oracle access on requirement to Developers in Development and Testing regions.

Environment: PeopleSoft Finance 8.4, People Tools 8.43, Oracle, SQR, Crystal Reports, UNIX, Windows.

Confidential

Role: PS Admin

As PS Admin, was responsible for

• General DBA activities like monitoring, space management, schema management etc.
• Responsible for day-to-day Support.
• Monitoring and Administration of App Server, Process Scheduler and Web Servers.
• Trouble shooting PeopleSoft related Issues.
• Install and configure PeopleSoft instances with Oracle on Windows/Solaris.
• Applying patches and maintenance packs.

Environment: PeopleSoft HRMS 8.8/8.9, EPM 8.8/8.9, Finance 8.8/8.9, People Tools 8.4x, Oracle, SQR, Crystal Reports, UNIX, Windows.

Confidential

Role: PS Admin

• Responsible for day-to-day Support.
• Monitoring App Server, Process Scheduler and Web Servers.
• Administration of App Servers, Process Schedulers and Web Servers.
• Trouble shooting PeopleSoft related Issues.
• Setting up Forgot Password option.
• Setting up Crystal Reports

Environment: PeopleSoft 8.9 HRMS, People Tools 8.48, SQL Server, SQR, Crystal Reports, Windows 2000 Server

Confidential

Role: PS Admin

• Responsible for day-to-day Support.
• Monitoring App Server, Process Scheduler and Web servers.
• Administration of App Servers, Process Schedulers and Web Servers.
• Fine Tuning and Troubleshooting of PeopleSoft Application Servers, Process Schedulers and Web servers.
• Trouble shooting PeopleSoft related Issues.
• Run DDD audit, SYS audit rectify the issues.
• Create DMS Scripts to Import and Export Data for particular tables from one instance to another.
• Monitoring of tablespaces, adding data files/resizing the data files.
• Creation of new databases.
• Setting up Application Servers Process Schedulers.
• Performance tuning of the Database and Application.

Environment: PeopleSoft 8 FIN, People Tools 8.16, Oracle8i, SQR, Crystal Reports, UNIX, Windows 2000 Server

Confidential

Role: PS Admin

• Security: Creation of new Roles, Permission lists, Users, Update users with new roles, delete users,
• import, export backup of security tables and user security tables, adding tables to query trees.
• DB Compares: Running compares between Database for Internal objects External objects.
• Autosys: Creating new jobs, testing them and running jobs as part of production Support.
• Migrations: Migrate objects Internal and External from one region/instance to other. This also includes registering components and providing security, running DMS scripts, running sqls, compiling Cobol programs, moving the compiled .gnt files to Application servers' e t c.
• Code Sync up: Sync up Instances by doing internal and external object compares and move the objects, which were missed in the migration process.
• Base table compares: Running sqls to compare data in Base tables in between different Instances.
• Reduction: Run SQRs to load only certain Employee's data from conversion Instances to testing Instances and validate by comparing if give set of data got loaded properly.
• Run Audits: Run DDD audit, SYS audit and Alter Audit in instances and rectify the issues.
• Instance Verification Test: When ever an instance is refreshed/a new instance is created/instance is back from reduction we perform certain tests to see that the instance is free from infrastructure Issues.
• Code Audits: Perform audits on the code developed by the users to check if the users are maintaining the standards.
• Create DMS Scripts to Import and Export Data for particular tables from one instance/region to another.

Environment: PeopleSoft HRMS 8.8, People Tools 8.43.17, SQR, Windows-2000, UNIX, Oracle9i.