SUMMARY

• Over 9+ years of result oriented professional experience in Administering PeopleSoft Applications and Oracle Databases.
• Over 7 years of experience as PeopleSoft Administrator Supporting mainly HRMS, FSCM, EP,TM, CRM application on Oracle Databases and their supporting Operating Systems.
• Expertise in PeopleSoft Admin and Oracle DBA Activities
• Expertise in installation, configuration, setup and management of PeopleSoft Internet Architecture (PIA) environment (People Tools 8.4x/8.5x, Applications 8.8/9.0/9.1/9.2 ).
• Successfully installed and configured WebLogic Server, Application Server, Process Scheduler and Database on UNIX / NT operating systems
• Configure Report Repository using http and ftp, IB setup, Crystal installation, COBOL installation, People Books (tools and application) Installation and configuring F1 help.
• Tools patch, Application patch, Bundles, Tuxedo patch, Weblogic patch
• Proficient in Data and Project Migrations using Data Mover and Application Designer.
• Experience in refreshing DEV/QA/TEST environments from Production database, migrating changes from Development to QA and Production
• People tools upgrade from 8.4x to 8.5x
• Participated for Application Upgrade project.
• Proficient in Data and Project Migrations using Data Mover and Application Designer.
• Experience in using Oracle tool TOAD for Database Administration.
• Configure Report Repository using http and ftp, IB setup, crystal installation, People Books (tools and application) Installation and configuring F1 help, People Tools Patching
• Troubleshooting PeopleSoft related issues.
• Implementation of “Forgot Password” functionality in PeopleSoft ERP.
• Implementation of SSL to make secure PIA.
• Implementation of Single Sign On.
• Expertise of Oracle software installation, Database creation, Users and Security maintenance, Tablespace and data file management, Export/Import utility, Statistics update, RMAN and User - Managed Backup-Recovery, Replication via Materialized view, Data guard configuration, Understanding of Standby database, Set up DR. Database upgrade, Performance Tuning, Applying Oracle quarterly CPU patches, Database cloning.
• Oracle databae upgrade from 9i to 10g, 10g to 11g.
• Moving/Copying an instance from one server to another server
• Configuration in Oracle grid control.
• Experience in using Oracle tool TOAD for Database Administration.
• Setup cron jobs for specific task (like backup/ server monitoring etc)
• Set up SSH for password less login between Linux and Windows machines.
• Set up Stand by database, Participate in DR test.
• Excellent analytical, problem solving and time management skills.
• Good noledge of UNIX commands, able to read Shell scripts, troubleshooting of jobs running through Shell script.

TECHNICAL SKILLS

Operating Systems: Windows / UNIX /Linux/AIX/ Solaris

Database: Oracle 9i/10g/11g

Tools: & Utilities: TOAD, Sql Developer, RMAN, Export/Import, Control-M

ERP: PeopleSoft HRMS/FSCM/PA/EP (8.x/9.x), People Tools 8.4x/8.5x

Webserver: Bea Weblogic 8.1/9.2, Oracle Weblogic 11g

PeopleTools: Data Mover, Change Assistant, Process Scheduler, Configuration Manager, Application Designer, Tuxedo Application server

FSCM: Financials General Ledger, Accounts Payable, Purchasing, Commitment Control, Accounts Receivable/Billing, Asset Management, Travel and Expense, Grants, Management, Project Costing, Treasury.

Supply Chain: Inventory, eProcurement, eSettlements, Supplier Contract Management, Strategic Sourcing.

HCM: Human Resources, Base Benefits, Benefits Administration, Time and Labor, Payroll, Enterprise Learning Management (ELM), Absence Management, Talent, Acquisition Management/eRecruiting, eApps (eBenefits, eDevelopment, eCompensation, ePay, ePerformance eProfile)

PROFESSIONAL EXPERIENCE

Confidential, New York

PeopleSoft DBA

Responsibilities:

• PeopleSoft installation for HRMS/Fin/EP/PA from scratch for 9.x.
• People Tools upgrade from 8.4x to 8.5x
• Preparing servers for Database and People Soft components.
• Creation of App server, Process Scheduler, Web server on new People Tools release.
• Applying necessary bundles to application.
• Technical issue fixing after setting PIA on new hardware.
• Day to Day People Soft Admin activities.
• Creation and Administration of Application Server, Process Scheduler and Web server.
• Project Migrations from Development to UAT/Preproduction/Production environments.
• Database refresh & PeopleSoft Refresh activities of Non-Prod environments from Prod.
• Monitoring and database administration from OEM 11g/12c
• Script creation for RMAN backup, pre refresh & post refresh activity
• Installation of People Tools and application of patches.
• Oracle Database upgrade from 9i to 10g, 10g to 11g
• Creation of Data Migration scripts.
• Compare reports.
• Troubleshooting issues
• Shell Scripts
• Migrating customized SQR's/Crystals/nVisions.
• Standby database setup
• Participate in DR test
• Oracle Database administration like Space management, Security maintenance, RMAN backup monitoring and troubleshooting, Export - Import.
• Participated in Application upgrade of FSCM/HCM 9.1 to 9.2
• Installed new Release DEMO databases for HCM 9.2, FSCM 9.2
• Created staging database to copy production data (wif data scrub in place ) which is used to clone target database to be upgrade
• Prepared estimated database size increase report and requested additional space required in advance.
• Backing up databases whenever required as part of Upgrade process wif RMAN, Datapump export/import Cold backups.
• Running initial audit reports (DDDAUDIT, SYSAUDIT) whenever required and worked closely wif DEV/L3/BSA/Functional teams to clean discrepancies.
• Compared customizations (UPGCUST) and involved in KEEP/DROP Analysis decisions wif Functional/BSA teams in Initial pass.
• Updated statistics whenever required to increase performance of upgrade.
• Removed deprecated parameters and incorporated new parameters suggested by oracle to increase performance.
• Applied people tools changes ( PPTLS84CUR project copy/build, created application tablespaces,converting data types (Long to LOB, time data types)
• Running and reviewing compare reports and sharing wif BSA/DEV teams.
• Applied Application changes (Copy UPGCUST project, running data conversion concurrently).
• Worked closely wif BSA/Functional teams during conversion and supported team to go data-conversion smoothly.
• Designed and developed scripts to make upgrade fast and fall in wif-in window of 72 hours of Go-live.
• Performed post-upgrade tasks as required.
• Performed database upgrade 9i to 11gR2, 10gR1 to 11gR2
• Prepared database upgrade check list (PRE & POST upgrade tasks) wif time lines
• Verified kernel parameters and downloaded/applied patches required for upgrade
• Installed oracle 11gR2 64 bit on database server
• Checked space availability for SYSAUX/SYTEM table spaces and increased them.
• Updated database statistics before /after upgrade
• Ran scripts to find invalid objects in SYS /Non SYS schemas and worked wif teams to fix before upgrade
• Checked time zone versions and applied patches accordingly
• Taking backups (RMAN, Cold backup) whenever required.
• Commented out all deprecated parameters in init.ora file.
• Performed all post-upgrade tasks.

Environment: s: Oracle 11g, FSCM/ TM / EPM/ PA/ HR wif People Tools 8.5x on Oracle Linux

Confidential - Atlanta

Oracle DBA

Responsibilities:

• 24/7 support to production instances.
• Respond to all teh tickets wifin 15 minutes of time.
• Respond to teh request coming through DBA mailbox/Call/Manage Now(Ticketing Software).
• Review teh SQL codes developed by developers as per Confidential standards.
• Creation and administration of database.
• Space management - Tablespace and data file maintenance by adding or resize data file..
• Security maintenance - User/Roles/Profile maintenance.
• Monitoring and troubleshooting RMAN jobs for production and non-production backup running through Crontab.
• Monitoring and troubleshooting Replication jobs running through Control M(Scheduler).
• Full Peoplesoft Database refresh from Production to Dev/QA/TST.
• Performance & tuning
• Monitoring of all databases through OEM
• Applying Oracle Quarterly CPU patches on all teh database servers.
• Statistics update to improve performance.

Environment: s: FSCM, HCM, EP, PA, and People Tools 8.4x Database: Oracle 10g, Linux, Windows

Confidential, New York

PeopleSoft DBA

Responsibilities:

• Conducted environment meeting every week and discussed ongoing issues and upcoming tasks wif various team leads.
• Prepared SMTD( System maintenance technical document ) for management
• Maintained database level security and application level security by running ad-hoc compliance scans and revoking unwanted roles, permissions privileges assigned to users
• Refreshed databases on regular basis from production backups
• Taking backup of oracle level security, application level security before refresh and restoring them after refresh.
• Coordinated wif various teams in addressing all BAU (Business as usual) tasks.
• Configured applications servers web servers and process schedulers for new environments as requested by Dev and testing teams.
• Supported and maintained around 20 PeopleSoft environments in various streams of development, QA and production support.
• Oracle Database upgrade from 9i to 10g using DBUA.
• Creation of Data Migration scripts.
• Compare reports.
• Migrating customized SQR's/Crystals/nVisions.
• Oracle Database administration like Space management, Security maintenance, RMAN backup monitoring and troubleshooting, Export - Import.

Environment: HRMS 8.9 and FSCM 8.9 People Tools 8.46, Database: Oracle 10g

Confidential

Oracle DBA

Responsibilities:

• Involved in requirement analysis.
• Responsible for allocating system storage and planning for future storage.
• Responsible for planning for backup and recovery of teh databases.
• Creation and modification of Forms and Reports as per requirement.
• Creation of new objects at database level for enhancement of teh application.
• Backup /Recovery
• Logical backup/recovery using Export/Import utility.
• Space utilization monitoring.
• User / Role creation.
• Creating Profile and assign to users based on requirement.
• Managing user’s security and privileges.
• Looking for teh routine jobs as per teh requirements of Management/Users.
• Attending users complaints.
• Co - ordination wif outside agencies for maintenance of teh computer system.
• Involved in DBA activities and Shell Scripting.

Database: Oracle 8i, In House Developed ERP