SUMMARY

• Experience in PeopleSoft Application, Databases and STAT Administration.
• Expertise in PeopleSoft Implementations and Support.
• Expertise in STAT Change Management 5.5.5/6.0.
• Expertise in PeopleSoft Application Security Administration.
• Expertise in Autosys Job Scheduler for all PeopleSoft jobs/processes.
• Expertise in Oracle Traffic Director, F5 BIG - IP Load Balancing and Integration Broker.
• Experience in Tools patches/Bundles, Application maintenance packs.
• Have hands on experience of RDBMS Concepts including design, restore and maintenance of database backup, recovery procedures.
• Experience of LDAP and Desktop Integrated Single Signon.
• Experience in Oracle Database 10gR2/11gR2/12c and SQL Server 2008 Database server Administration and PeopleSoft Application FSCM/HRMS/T&E 9.0/9.1/9.2 and People Tools 8.49/8.50/8.51/8.52/8.53/8.54 with Linux 5.0/6.0 and Window servers.

TECHNICAL SKILLS

• Operating Systems: ExaLogic Linux server 2.6, Oracle Linux Server release 5.8/6.0, Windows 2003/2008 64 bit
• ERP: FSCM/HRMS/T&E 9.0/9.1/9.2 People Tools 8.49/ 8.50/8.51/8.52/8.53/8.54, Oracle Business Intelligence System 11g Release 1.
• APPLICATION /Web SERVER Web logic, Tuxedo/Jolt, Oracle Application Server Database: Oracle 12.2.0.2/10.2.0.2/11.2.0.2, SQL Server 2008
• Tools & Utilities: People tools 8.4x,8.5x application v8.x,v9.x (HRMS,CRM,EPM,FSCM and Portal) Applications PeopleSoft, OBIEE, Data Mover, Application Designer, RMAN, Crystal Reports BO, PUM QL plus, SQL Loader, SQR reports, MS Access, 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 OEm, Database configuration assistant, Oracle universal installer, Lstnctrl, Dbverify, Sql trace, Sql auto trace, Explain plan, Export, Import, Sql loader Change Management & Version Tool STAT 5.0/6.0

PROFESSIONAL EXPERIENCE

PeopleSoft Administrator

Confidential

Responsibilities:

• Administrating PeopleSoft Server components like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker etc.
• 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.
• Working as STAT Administrator and supporting STAT Infrastructure & Application. Working on Change Management Life Cycle Process, Design and Implementation on other PeopleSoft modules.
• Administrating Oracle Traffic Director OTD and load balancer F5 on PeopleSoft applications.
• Supporting all PeopleSoft Productions and non-productions applications.
• Supporting Oracle Secure Enterprise Search SES.
• Work on Oracle ExaLogic issues at server side.
• Taking care of Oracle Database tasks, Create and execute backup/restore and disaster recovery strategy and scripts for databases in specified environment.

PeopleSoft & STAT Administrator

Confidential

Responsibilities:

• Worked as PeopleSoft & STAT Administrator and responsible for Configuration and Administration for Production/Developments environments.
• Maintained 45 PeopleSoft environments: Demo, SYS, DEV, UAT, SIT, Pre-Prod and PROD Instances.
• Complete setup of PeopleSoft 9.1 FSCM 9.1 with Tools 8.51.16 multilingual on Linux 5.0 and Windows 2008 R2.
• Done the Installation of PeopleSoft FSCM 9.2 and Tools 8.53 multilingual.
• People Tools Patches, Application Bundles and Maintenance Packs with the help of Change Assistant.
• Configure and administer Application / Process Scheduler and Web server instances.
• Complete setup of STAT (change management tool) implementation for Finance and HR module.
• Responsible for STAT tool for both modules (Finance and HR).
• Design, Implement and Test PeopleSoft DR (Disaster Recovery) environments.
• Coordinate and Planned Production go-live cutover activities.
• Taken care of Post Refresh activities for the PeopleSoft environments.
• Troubleshoot Autosys Jobs and PeopleSoft Adapter issues.
• Involved in Web Server load balancing using Big IP F5 Product.
• Coordinate with application team and perform project migrations through STAT Change Management Tool.
• Have successfully built the STAT DR (Disaster recovery) server.
• Installation of OBIEE (Oracle Business Intelligence Enterprise Edition) application.
• Planned and Performed Namespace migration.
• Worked with Oracle support on various issues during implementation. Created and maintained documentation.

PeopleSoft Administrator

Confidential

Responsibilities:

• Metadata sync between two PeopleSoft databases (development environments).
• Applied Code migration steps on PeopleSoft database.
• Done Post Sync Setup as per the setup document.
• Ran the Alter Audit reports to sync the People Tools tables with DBMS tables.
• Ran the SYSAUDIT, DDDAUDIT and SETSPACE.sqr reports to verify the inconsistencies.
• Compare and Migrate projects from source to target database.
• Done Oracle Schema refresh using Oracle utility: Oracle exp/imp.
• Resolved issues during Metadata Sync along with other PS Admin Activities.
• Planned and Performed Namespace migration.
• Worked with Oracle support on various issues during implementation.
• Created and maintained documentation.

Oracle Administrator

Confidential

Responsibilities:

• GeoDatabase design and performance tuning of their existing production server.
• ArcGIS server production environment setup with Web Adaptor working with multiple ArcGIS Server sites.
• Workflow requirements (functional and non-functional) for development of Web GIS application.
• Installed ArcSDE/ArcGIS software and configured ArcSDE with Oracle 9i/10g databases.
• Upgraded the ArcSDE version with Oracle databases as per User's requirement.
• Managed the ArcSDE tables/objects at Oracle level.
• Using SQL queries for project related search criteria's.
• Troubleshoot and solved Oracle database queries with respect to ArcSDE for ESRI's customers.
• Create/Maintain database users, roles, assign privileges and set Password policies for database users.
• Setup the multiple geodatabases of ArcSDE in a single Oracle database and also setup the different geodatabases of ArcSDE into different Oracle databases.
• Applied Oracle different Patches of 9i/10g as per User's requirement.
• Configured Listener and Tnsnames.ora file for Oracle network configuration.
• Memory management (shared pool, db buffer cache and log buffer)
• Backup and Recovery:
• Performed Full Backups.
• Took Hot/Cold Backup
• Control File Backups in ARCHIVE LOG mode.
• Maintain Backup & Recovery policies (Taking Export Dump at every Night)
• Closed Database Recovery.
• Restored Data Files
• Restored Archived Redo Log Files