Summary

• 13 Years of experience in IT and over 10 years of experience in PeopleSoft System Administration with Oracle , Microsoft SQL Server and UD DB2 and having strong experience in Installation ,Upgrade ,Administration and Maintenance. Oracle 9i Certified Database Professional.
• Installed and supported many PeopleSoft applications.
• Successfully performed Upgrade of PeopleSoft FSCM 8.8SP1, PeopleTools 8.47/8.50, HRMS 8.3/9.0,PeopleTools 8.19/8.48 and Financials 8.4/8.8, PeopleTools 8.44.
• Expertise in administering PeopleSoft Server components, Report Repository Servers, PIA PeopleSoft Internet Architecture , Integration Broker, SQL Server, Oracle, troubleshooting application and technical issues.
• Installed and configured BEA Web Logic Server, installed Web Server components and created Web Server domains. Installed and configured both Single Server and Multi Server domain.
• Installed Tuxedo and configured Application Server domains.
• Configured Process Schedulers on both NT Batch Servers as well as UNIX batch servers.
• Involved in implementing Quest STAT for Change Management enabling to migrate PS Project and File Objects with ability to rollback to the previous archive sets if needed.
• Expertise in Performance tuning, troubleshooting connection issues of PeopleSoft Application Server, Process scheduler, Web Server and Database Servers instances.
• Expertise in Installation, Configuration and troubleshooting of Change Assistant.
• Performed Application Updates and Fixes, PeopleTools Patches and PeopleTools Upgrades.
• Expertise in Version control, Change management, Data Mover.
• Extensive experience with Integration Broker handling both PeopleSoft to PeopleSoft and PeopleSoft to 3rd party Application messaging.
• Implementation of Single Sign On SSO setup for PeopleSoft application.
• Installation of Peoplebooks, Verity search, Crystal Reports, COBOL compiler/licenses.
• Migrated PeopleSoft objects both internal objects PeopleCode, records, panels/pages etc and external objects COBOL, SQR using Quest STAT as well as Application Designer.
• Archived system transaction data using Peoplesoft Data Archive Manager Tool.
• Implementation of PeopleSoft Security Matrix.
• Ability to troubleshoot complex technical and logical issues and adapt quickly to changes.
• Extensive experience in performing database refreshes / cloning.
• Worked with PeopleSoft GSC on critical issues and documented the resolutions.
• Supported PeopleSoft Development team, QA team and Production End-users.
• Expert in relational database concepts and design. Involved for maintenance and support for OLTP environment.
• Performed tasks associated with tuning of database systems for performance and efficiency enhancements, reviewing the logs, available space, configuring the initialization parameters based on application requirements, optimizing complex SQL queries.
• Very comfortable with all the flavors of UNIX Solaris, AIX, HP UNIX , Linux and Shell Scripting. Have good knowledge of basic Unix Administration and file systems concepts.
• Strong written and verbal communication skills. Effective team player and Ability to learn new skills/tools on demand and deliver excellent productivity in short time. Self-motivated and enjoy working in a technically challenging environment.

TECHNICAL SKILLS:

PROJECT EXPERIENCE:

Confidential

Senior PeopleSoft Architect / Administrator / DBA

PeopleSoft Support and Upgrade project FSCM 8.8 SP1 / PT 8.47 To FSCM 8.8 / PT 8.50

• Planned for the Upgrade including tasks like reviewing PeopleSoft Customer Connection for Applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and review documentation e.g. release notes, white papers .
• Played an active role in deciding the Upgrade path and made recommendations on hardware and Software to meet PeopleSoft certification and maximize performance.
• Successfully Upgraded People Tools from 8.47 to 8.50.
• Prepared compare reports to identify PeopleTools Customizations. Performed migration in accordance with the business rules.
• Fine tuned and created templates of psappsrv.cfg files for creating future domains.
• Configured Integration Broker in the PT 8.50 environment. Setup and configured the Cyber source for Credit card authorization.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT and SYSAUDIT and Alter Audit, Database Integrity checks, update statistics.
• Applied Maintenance Packs 8/9 and Bundles 19-28 using Change Assistant in DMO, DEV, TST, PROD.
• Documented and performed knowledge transfer to other groups of the architectural design.
• Worked on development tools like SQR, Application Designer, and Crystal Reports.
• Installed and configured all the tiers in PIA setup The File server, Application server, Batch server, Web servers and Database server to support the PIA.
• Uploaded data between the databases using Export and Import utilities in Data mover sql export/import tool.
• Figured out all the procedures and tasks that can be performed in parallel in order to speed up the process. Documented all the steps of Change Assistant, with the timings that each step takes to complete. Tried to minimize the time to fit everything in the Go-live time window.
• Keeping the Peoplesoft Environment PCI Compliant by applying quarterly released patches on scheduled time.
• Working on the Data Archival using the Data Archive Manager Tool.
• Re-established SQL Replication between the OLTP and Reporting environments.
• Worked on other Microsoft projects like BI and Prophix for setting up the environments and migration of objects and other troubleshooting.
• Carried out day to day support running data fix scripts, Migration of updates, monitoring performance, security related requests, problem resolution, performing database refreshes, cloning environment, providing 24X7 support.
• Along with Peoplesoft , supported other in house systems such as Red Prairie for distribution Shipping , Business Intelligence Reporting Tool , Syteline ERP system implemented for China/Shanghai ,Prophix Budgeting tool in the scope of the system administrator.

Environment: PeopleTools 8.47/8.50, PeopleSoft FSCM 8.8, Weblogic 10.3.1/9.1, Tuxedo 10g R3/9.1, MS Sql Server 2008/2005/2000,Windows 2003/2008, Track-it.

Confidential

Senior PeopleSoft Administrator

PeopleSoft Support Project

• Maintained a vast system comprising of 12 environments for Campus Solution and 8 environments for ELM.
• Involved in the day to day support activities such as resolving jeera tickets, performing weekly migrations using Kintana, providing 24X7 system support, monitoring the system performance.
• Implemented PeopleSoft Verity, Installed peoplebooks.
• Applied PeopleTools patches and Application bundles in the DMO, Test, UAT and other non prod environments and the Production environment using Change Assistant.
• Involved in Oracle DB patch upgrade from 10.2.0.3 to 10.2.0.4.
• Maintained a number of third party systems like Kaba Clock and so on.
• Maintained complete and precise documentation of changes in a system known as Docushare.
• Involved in the configuration of BIGIP and firewall setup between different components of PS.
• Performed database refreshes and created scripts to schedule them daily.
• Created PeopleSoft Jobs using Custom Scheduler.
• Developed interface for inbound and outbound files.
• Grant Portal Access to Developers and Users on request basis. Run data fix scripts. Turn Trace on debug process, perform performance tuning on slow and long running processes. Provided 24X7 support.

Environment: PeopleTools 8.49, PeopleSoft CS 9.0 ,ELM 9.0 Weblogic 9.2 MP1 p5, Tuxedo 9.1 rp36, Oracle 10.2.0.3.0/10.2.0.4, Linux, Solaris, AsJira, Kintana, docushare, confluence..

Confidential

Senior PeopleSoft Upgrader / Administrator Infosys Technologies

PeopleSoft Upgrade project HRMS 8.8 / PT 8.4 To HRMS 9.0 / PT 8.49

• Planned for the Upgrade including tasks like reviewing PeopleSoft Customer Connection for Applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and review documentation e.g., release notes, white papers .
• Made recommendations on hardware and Software to meet PeopleSoft certification and maximize performance. Also worked with PeopleSoft to validate HW/SW requirements for installation.
• Successfully performed PeopleSoft HRMS upgrade from 8.8 to 9.0.
• Successfully Upgraded People Tools 8.4 to 8.49.
• Participated in the conversion of Non-Unicode Oracle database 9i to Unicode database 10g.
• Prepared scripts to convert Long data type to Clob data type.
• Ran compare reports to identify differences between source and target database before doing any migrations. Performed migration in accordance with the business rules.
• Fine tuned and created templates of psappsrv.cfg files for creating future domains.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT and SYSAUDIT and Alter Audit, Apply Upgrade Options UPGOPT project, update statistics.
• Participated in applying tax updates, bundles and fixes using Change Assistant.
• Documented and performed knowledge transfer to other groups of the architectural design.
• Worked on development tools like SQR, Application Designer, and Crystal Reports.
• Installed and configured all the tiers in PIA setup The File server, Application server, Batch server, Web servers and Database server to support the PIA.
• Installed /configured multiple Web Servers. Generated certificates, configured SSL for the Web Servers.
• Uploaded data between the databases using Export and Import utilities in Data mover.
• Working with other DBA's to get tracing turned on to trace batch processes in order to investigate performance issues. Ensure all performance modifications are identified and documented.
• Figured out all the procedures and tasks that can be performed in parallel in order to speed up the process. Broke down some data mover scripts into smaller scripts which could be run in parallel. Documented all the steps of Change Assistant, with the timings that each step takes to complete. Tried to minimize the time to fit everything in the Go-live time window.

Environment: PeopleTools 8.4/8.49, PeopleSoft HRMS 8.8/9.0, Weblogic 9.1/8.1SP5, Tuxedo 9.1, Oracle 10g RAC, Linux 2.6.9-42.0.10.ELsmp, Webstar.

Confidential

Senior PeopleSoft Administrator Infosys Technologies

PeopleSoft Mirroring and Maintenance project:

• Installed PeopleTools 8.49, FSCM 9.0/8.9.
• Installed BEA Tuxedo on the Application/Batch server. Installed BEA Web Logic on the Web server.
• Build many PeopleSoft environments for Demo, Prototype, Conversions, Development, UAT Testing, Performance Testing, Training and Production database instances.
• Configured the Web Server, Configured single server as well as multi server domains and created multiple Web Logic Web Server instances for load balancing and fail over.
• Installed People Books and generated search collection for the entire site. Configured Help URL in the PIA Web Profile so that online users can use Help.
• Configured Application Server domains and Process Scheduler Servers and tuned the configuration parameters based on the type of usage.
• Installed Micro Focus Net/Server Express COBOL compiler on the NT and UNIX Batch Servers.
• Ensured Data integrity by running SYSAUDIT and DDDAUDIT reports on a regular basis and before and after applying any patches or bundles.
• Worked on PeopleSoft Security, Created Permission Lists, Roles, User Profiles, and maintained them.
• Extensively used Data mover utility for running many DMS scripts for exporting, importing PeopleSoft security and encrypting passwords.
• Installed Change Assistant to apply patches and bundles.
• Created Database Performance related scripts. Re-indexing/Updating Statistics.
• Extensively used UNIX servers Sun Solaris and Red Hat Linux for Application Server, Web Server, Database Server and Process Scheduler. Implemented many scripts in UNIX server to Monitor Application Server / Process scheduler status, Reboot scripts.
• Performed Db refreshes / Cloning of databases.
• Performed 24x7 Production support on an ongoing basis.

Environment: PeopleTools 8.49, PeopleSoft FSCM 9.0/8.9, Weblogic 8.1SP5, Tuxedo 8.1, MS SQLSERVER 2000 SP4, Sun Solaris, Red Hat Linux, Windows 2003, Webstar.

Confidential

Senior PeopleSoft DBA

Responsibilities:

• Maintained and supported 55 PS system databases supporting more than 50K global users.
• Performed the role of a Senior PeopleSoft DBA and executed duties like Appraisals, shift schedule design, mentoring.
• Responsible for all phases of the HCM 8.3 to 9 PT 8.19/8.48 Upgrade Project from the infrastructure side including the initial infrastructure design, Installation/ configuration of Development , Testing , Pre-Prod and Production box, performance tuning testing, deployment and Production support.
• Lead the HCM 8.9 MP Implementation project.
• Responsible for Production support of HRMS, Portal, Finance and CRM Applications.
• Designed the physical and logical layout of the servers based on user requirements, scalability.
• Implemented Lightweight Directory Access Protocol LDAP Authentication.
• Implemented security for PeopleSoft environments SSL .
• Applied Patches Fixes, Tax Updates, Bundles, Maintenance Packs to non-prod prod env.
• Involved in performing the Initial Upgrade, Test Move to Production before a Final Move to Production. Tuned and optimized system to reduce time needed for running upgrade scripts.
• Experience with Integration Broker. Troubleshooting causes for Integration broker messages in Queued status, Report Not Posting, Subsequent process failures, Site not accessible, Deadlock issues, Database agent unable to connect to DB.
• Developed and maintained UNIX shell scripts for automating administration.
• Worked extensively in Security by designing developing Roles, Permission List User Profile.
• Installation and Configuration of PIA on Windows NT/2000 and UNIX Boxes.
• Installed People Books for online availability for all the users.
• Migrated projects between PeopleSoft Instances using Application Designer and Quest STAT. Worked as a STAT Admin for creation of Users profiles and accesses.
• Worked on development tools like SQR, Application Designer, and Crystal Reports.
• Involved in performing database refreshes /database cloning at the request of the developers.
• Database administration tasks like creating permission to users and services accounts for third party applications and PeopleSoft applications.
• Involved in database performance tuning and SQL scripting.
• Involved in tuning the table spaces, updating the statistics re-org of tables and indexes and SQL query tuning based on the execution plan and the I/O.
• Proven ability to effectively troubleshoot systems administration issues and communicate.
• Trained the Staff on PeopleSoft Internet Architecture concepts.
• Provided 24X7 Production Support.

Environment: PeopleTools 8.19/8.2x/8.42/8.43/8.46/8.48,PeopleSoft FSCM 8.0/8.4/8.9, HCM 8.0/8.3/8.9/9, Portal 8.9 ,CRM 8.4, Websphere 5.1, Weblogic 8.1/6.1/5.1, Tuxedo 8.1/9.1, IBM UDB DB2 8.1 FP10, MS Sql Server 2000 ,Oracle 9i/10g RAC ,STAT 5.13, Unix AIX-5.3, NT2000,Remedy.

Confidential

PeopleSoft Administrator /Security Administrator Cognizant Technology Solutions

Responsibilities:

• Performed PS Upgrade for FSCM 8.4 PeopleTools 8.44 to FSCM 8.8 PeopleTools 8.44 .
• Performed installation of PeopleTools, Applications, evaluated the existing hardware and software configuration and tuned according to the recommendations.
• Installed and setup Change Assistant to apply application updates to the PeopleSoft applications on People Tools 8.44 and above.
• Applied the People Tools 8.47 Product Patch and applied the Maintenance Pack 1 thru Maintenance Pack 4 for Financials 8.9 using Change Assistant.
• Applied Maintenance Packs and Tax Updates to HRMS 8.9 applications.
• Applied PT patches and Application specific patches, Bundles and Service Pack upgrades.
• Involved in system testing and bug fixing during the initial and move to the Production phases.
• Designed the Security Matrix in accordance to SOX Compliance. Created the Permission List, Roles, User Profiles and granted Query access, Process execution access as per the Security Matrix.

Environment: PeopleTools 8.44/8.47 , PeopleSoft FSCM 8.4/8.8/8.9, HRMS8.9, Oracle9i, WebSphere 5.1, Tuxedo 8.1, UNIX Sun Solaris 10, STAT 5.13, ClearQuest.

Confidential

PeopleSoft Administrator / Oracle DBA

Responsibilities:

• Implemented the Data Archival project using OuterBay product for PeopleSoft 7.5.
• Set up demo environment for PeopleSoft 7.5 installed Oracle 8.1.7 software and created fresh databases to be used as DEMO databases for PeopleSoft 7.5.
• Used Data Mover for migrating AE and mass change customizations. Run database refreshes.
• Monitored CPU, shared memory and I/O statistics for UNIX and Windows NT PeopleSoft boxes.
• Performed Debugging and customizing SQR programs.
• Created Shell scripts to automate server startup, shutdown process and cache clearance.
• Performed Oracle DBA activities on Development databases create schemas, tablespaces, referential integrity, data quality assurance, table creation, views, backups and so on.
• Worked on Database Security, Performance Tuning, Database Optimization.
• Modified Control File for database cloning, reset logging and default archiving.
• Implemented hot and cold backups, online backups, export backups and restorations.
• Worked on resolution of various Database Recovery scenarios using RMAN.
• Performance tuning for long running queries.
• 24X7 Production Support.

Environment: PeopleTools 7.52, PeopleSoft Finance 7.5, Tuxedo 6, Oracle 8.1.7, AIXv4.3, Clearcase, Remedy.

Confidential

Software Consultant / Oracle DBA Responsibilities:

• Provided Support to the Legacy systems.
• Designed the Web Pages. Developed the module which transfers data using flat files.
• Scheduled and monitored the routine and monthly Jobs.
• Developed SQR programs to generate KPI Reports monthly.
• Involved in the rollout of the module which facilitates transfer of Legacy data to ERP System.
• Installed Oracle 9i, 10.1.0.2 on Windows 2000 server, Solaris 8, Fedora Core -4.
• Reorganized the data using Import and export utilities. Created remote database links.
• Involved in System administration activities like maintaining security, adding the system users.
• All backups for ORACLE are automatically taken at different time during the day through Unix Cronjob utility. Responsible for configuring the crontab files.
• Performed Backup and recovery of the database which included taking backup on tape drives through UNIX, recovered /restored the files through operating system UNIX . Maintained the schedules for daily, weekly and monthly backup for both logical as well as physical backup. Created RMAN script for backup and performed RMAN backup.
• Performed SQL tuning using Tkprof, SQL Trace and Explain plan. Used OEM for tuning the SQLs.
• 16X7 Production Support.

Environment: HTML, JavaScript, PL/SQL, ORACLE 7.x/8/9i/10.1,MS Access, SQLloader, SQL Plus, UNIX, Solaris 8, Shell Scripts, Oracle Web Application Server, Forms 3.0, PL/SQL 2.24, SQR 2.28,Win 98/NT/2000.