PROFESSIONAL SUMMARY

• Over 7 years 8 Months of experience in PeopleSoft Administration for PeopleSoft Applications and Databases.
• Thorough knowledge and experience in Administrating PeopleSoft Server components like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker, Sql server, Application Issues and technical issues, etc.
• Experience in performance tuning, installing servers, and migrating to new servers. Installing and Administering PeopleSoft software configuring Workstations, Application Server, Process Scheduler, Tuxedo, Web Servers, PIA, Report Repository, Report Nodes for PeopleSoft applications. Applying Application Updates and Fixes and Tools Patches. Upgrading Tools to higher levels.
• Proficiency in migration activities in PeopleSoft, Tax updates, Patches, Maintenance packs, Service packs, tools upgrade for different applications versions of PeopleSoft.
• Expertise in Backup strategy for complex and robust Erp databases like PeopleSoft.
• Good Oracle database administration, Rac, Rman, Dataguard and good in UNIX common process handling commands.
• Excellent knowledge and experience in database administration, implementation and production support, performance monitoring, data and user security, Software Testing Tools and development tools.
• Possess thorough knowledge in PeopleSoft Architecture, PeopleSoft System Administration, Design and Implementing to suite Corporation Specific needs
• Worked on third party tools like Connect Direct-Ndm, CA Autosys, Hp Omni Backup, Net Backup, and Toad.
• Excellent communication, analysis, problem solving skills, Adaptable to change, Strong Attitude, Creativity, Analytical approach to problem solving and highly
  Task oriented.
• Roles – Peoplesoft Administrator, Peoplesoft Admin, PSadmin, DBA, Upgrade specialist.

Skills:
OS : Linux, Hp Unix, Solaris,Aix, Win Nt/2000/2003,Xp.
Databases : Oracle 8i, Oracle 9i, Oracle 10g, 11g, Sql server.
ERP : PeopleSoft HRMS, Financials, EPM, CIS, HCM, Portal 8.0/8.3/8.4/8.8/8.9/9.0/9.1
People Tools : 8.x/8.4x,8.5 Weblogic Server 51/6.1/8.1/9/10, Tuxedo 6.5/8.1/9.1/10
Tools : SQL plus, SQL Loader, SQR reports, MS Access, Application
Designer, Application Engine, Server manager Tools, PS Query,
Data Mover, Application Upgrade, Upgrade Assistant Tool, Change
Assistant, PeopleSoft Performance Monitor, Process Scheduler,
Process Monitor, Report Manager, COBOL Compilers, Net Express,
Server Express and AppWorx7, Rman, Oracle enterprise manager console,
Database configuration assistant, Oracle universal installer, Lstnctrl,
Dbverify, Sql trace, Sql auto trace, Explain plan, Export, Import, Sql loader.
Languages : SQL, Unix shell Scripting, C, C++, PL/SQL.
Tools : PVCS, Toad, Sftp, Ndm, Autosys, Ftp, Crontab, Telnet, Win Runner 6.x,
SQA Suite, Load Runner

• Master of Business Administration (MBA) – Specialized in Systems

Relational and object oriented database
Management System.

• Bachelor of Science specialized in Mathematics
• Diploma in computer applications from Radiant, Software solution integrated.

• Oracle Certified Professional (OCP) in Oracle 9i Database administration Track (Overall percentage above 95).
• Brain bench Certified in Rdbms Concepts.

• Oracle database administration training from Sql Star international Chennai.
• Oracle RAC and Data guard training from Sql Star international Chennai.
• Red Hat Linux training from STG Chennai.
• Six sigma training from Birlasoft Limited.

Project Details:

1. Confidential, Apr-10 to Till date

Currently working in Application upgrade project as a PeopleSoft upgrade administrator,
Responsible for PeopleSoft instance build, configuration and all types of admin activities.
Maintaining the Change assistant templates adding new tasks and performing the test pass using change assistant.
Being part of team in formulating strategy for successful execution of the application upgrade and
active member in overall team performance.

Responsibilities:

• Creation of new PeopleSoft 9.0 Finance AR Instances in new servers.
• Refresh of upgrade instances from 8.4 Production and upgrade them into 9.0 MP10 for batch and UAT testing.
• Creation of Maintenance process hand book documents to be followed by offshore team members
• Setting up monitoring for PeopleSoft application server and web server and process schedulers in UNIX server thro crontab scripts.
• Maintenance of production, development PeopleSoft instances and the upgrade instances.
• Performing application upgrade test moves thro change assistant in Windows NT server
• Stat administrator – responsible for stat accounts and any issues faced by configuration analysts in stat tool

Worked with Citi Corp PeopleSoft production support project team, Citi’s PeopleSoft
Environment has a variety of applications ranging from Hrms, Financial, Epm, and Portal.
Total number of databases supported by our team exceeds more than 50, hence a busy team with varieties of issues faced daily.
Apart from regular activities I represent my team in a major application upgrade project for APAC and EMEA PeopleSoft application, end application version is HCM 9.1 with tools 8.50.

Responsibilities:

• Represent my team as part of application upgrade for Citi’s Apac & Emea application tools 8.50 and application HCM 9.1.
• Worked as PeopleSoft Production Support Admin and took care of day-to-day activities like migrations and support to the DEV, TEST and PROD environments.
• Applied Tax update, patches and bundles on an ongoing basis.
• Perform tools upgrade for different PeopleSoft application, and work on patches and update for different technologies.
• Installation of PeopleSoft environment and configure as per requirement from development team.
• Work on issues reported by the application team, troubleshoot and provide resolution for different types of issues.
• Created integration broker message nodes for the Source and Target PeopleSoft Applications, configured report nodes.
• Configured Application Servers and Process Scheduler Servers with different templates and tuned the configuration parameters based on the type of usage.
• Migrated security related objects of the applications from development database to unit testing and system testing and then finally to the production during roll out. This included keeping all the databases consistent and in sync.
• Facilitated and participated in the planning, testing, and implementation of new/Upgraded infrastructure.
• Add and configure Ndm nodes for different clients, create and sent Sftp keys to vendors.
• Attend daily and weekly statuses calls and provide inputs on day to day activities and share thoughts on important decisions.

Technologies: Oracle 10g, Aix, Solaris, PeopleSoft 8.9, 9.1, Tools 8.49.22, 8.50 Connect-Direct Ndm, Unix, Toad.

Worked as PeopleSoft Admin/Dba in one of the world’s biggest PeopleSoft implementation.
Experience in Hrms and Crm environment, worked in various GE customized processes
and procedures.
Activities in the project include closely co-coordinating with the client for requirement gathering
and delegating work across teams and assigning work to our offshore team, have been a part of onsite team in managing 40 member offshore team working 24/7.
Created repositories in PVCS – Version control utility, Data load in newly created environment,
working across the board in major activities like Code sync (Code sync is the process of merging
code, base-setup table data between two development environments).
Tools upgrade for various environments, Application of tax updates and fixes. Comparison of
Base tables between databases, database reduction.

Responsibilities:

• Worked in a huge team for migration of Payroll for US employees from Legacy Mainframe systems to PeopleSoft Hrms.
• Have been part of the PeopleSoft G-crm Implementation team, worked on admin and support activities.
• Worked with development team in Implementation of Oracle Bam – Business activity Monitoring dashboard.
• Developed expertise in code sync activities between different development environments.
• Applying Tools patches in development instances and migrating it to Production after testing.
• Create, configure and monitor Application Server and Process Scheduler.
• Installation of Web server domains using Weblogic.
• Managing Oracle Database Server and apply Oracle Security Patches as and when required.
• Decide proper strategy for database backup and recovery to achieve the minimum down time at time of database recovery.
• Refresh Production database with development to perform periodic testing of database issues and to validate the backup.
• Perform database level and Sql level performance tuning to increase the response time of various processes and jobs.
• Space Capacity planning to accommodate the future space requirement.

Technologies: Oracle 10g, Solaris, People soft Hrms 8.9, Tools 8.47, Oracle Bam, Unix Shell
Scripting, Toad.

Worked as a lone Dba in up gradation of PeopleSoft from application version 8, tools 8.2 to
Application 8.8, tools 8.47. Have installed Oracle 9i; people soft, Cobol compiler, Tuxedo/Jolt, Web logic and created databases and new app server, process scheduler from scratch and actively involved in migration and go live process.
Have attended meetings on deciding the backup policy for the upcoming upgraded application, and also implemented the same through Unix shell scripting.
Implemented Data guard architecture between production and DR database, through scripting and ftp process.

Responsibilities:

• Manage GE Com-fin production databases hosted on HP-UX 11.23 Itanium Servers, and 9.2.0.6.0 and 10g.
• Creation of Oracle database and PeopleSoft Applications on Unix.
• Applying Tools patches in development instances and migrating it to Production after testing.
• Create, configure and monitor Application Server and Process Scheduler.
• Installation of Web server domains using Weblogic.
• Provide support to development team in order to ensure smooth flow of implementation and customization of application.
• Troubleshoot PeopleSoft Application related, Database related problems faced by users and Developers.
• Managing Oracle Database Server and apply Oracle Security Patches as and when required.
• Support production and different development instances like demo, dev, test, dr.
• Decide proper strategy for database backup and recovery to achieve the minimum down time at time of database recovery.
• Take backup of Oracle database files and Operation system files using HP OmniBack II.
• Refresh Production database with development to perform periodic testing of database issues and to validate the backup.
• Develop and test a procedure to fight against disaster. It was tested successfully.
• Perform database level and Sql level performance tuning to increase the response time of various processes and jobs.
• Space Capacity planning to accommodate the future space requirement.

Technologies: Oracle 9i/10 g, People soft, Hp Unix 11, Hp Omni back 5.5, Unix Shell Scripting, Sql Loader, and Toad.

5. Confidential, Client: Confidential, Boston. Feb 2005 – Dec 2005

Worked in ASP support project for Navisite thro Hexaware technologies, activities include:
PeopleSoft Tools upgrade, Installation of PeopleSoft in windows platform and Oracle Backend,
Installation of Oracle 9i in New Database server and application of Patch for the desired version.
Have performed People books installation as a separate web server domain referencing a single
Instance or Multi instance.

Responsibilities:

• Applied Maintenance packs, service packs and tax updates.
• PeopleSoft instance refreshes and environment refreshes.
• Used Rman, Oracle enterprise manager console, Database configuration assistant, Oracle universal installer, Lstnctrl, Dbverify, Sql trace, Sql, autotrace, Explain plan, Sql plus, ISql plus,Export, Import, Sql loader, Direct path, Export/Import.
• Database Role maintenance in coordination with security teams.
• Database creation, cloning, import, export for production, development and testing environments.
• Database backup, hot backup, cold backup, recovery for production, development and testing environments.
• Provided Support using Remedy centralized Ticket Monitoring system, Mails, IM and phones. Bringing application down and up for maintenance purposes.
• Database operational issues directly handled from User’s out of 24/5 support for Non Production and 24/7 support for Production. Handled Mission critical systems at business peak hours.
• Database creation, User/Role maintenance, Cold Backup, Hot Backup,Sql loader in Oracle, Sql server administration and Sql tuning.

Technologies: Oracle 8i / 9i / 10g Dba, People soft Erp, Unix (Solaris 8), Linux, Unix Shell Scripting, Sql Loader, Toad.

6. Confidential, India Feb 2004 –Feb 2005
Position: PeopleSoft Admin

• Design Development and implementation of new PeopleSoft instance in Windows and Unix platforms.
• Administration of Database in Oracle 9i Server. Maintenance activities such as Manual space extension for tables, adding Datafiles for Tablespaces, etc.
• PeopleSoft migration and admin activities including project and external migration.
• Maintenance of User profiles, Password Management, Assigning User Quotas. Performed Backup & recovery (User managed).

7. Confidential, India May 2001-Aug 2002
Position: System Admin

• Worked as System Admin in NCR PeopleSoft HCM database with backend Oracle. Creation and maintenance of Application and web servers.
• Oracle schema level backup activities, writing basic Sql Queries for extracting data and useful information from the database.