SUMMARY

• Over 17 years of experience in the IT industry.
• My experience includes implementation & supporting full life cycle PeopleSoft Projects for HR, Financials, CRM, Portal, EPM, ELM applications and oracle database administration.
• Expertise in strategy making and implementation of PeopleSoft admin Activities.
• Expertise in Installation of PeopleSoft Applications, Troubleshooting, Release Preparations, apply patch, maintenance pack, tax updates and other PeopleSoft admin activities.
• Master of Business Administration Specialized in Computer Management, Confidential University.
• Having around 14 Years of experience in Peoplesoft administration.
• 15 years Oracle 8i/9i/10g/11g DBA experience (upgrades, patches, data backup/recovery, change management, troubleshooting, and monitoring of databases)
• Having around 5 years of project management experience as Team lead.
• Sr. Oracle Database Administrator and PeopleSoft admin
• OCP ( Oracle Certified Professional ) certified Oracle DBA
• Worked with giants like PeopleSoft Inc., Confidential, Confidential, Confidential Bank & Countrywide.
• Worked extensively on Oracle on both UNIX and Windows (Redhat Linux, AIX, HP, Solaris, Windows NT and Windows 2003).
• Worked in Unix environments with good Shell Scripting Knowledge
• Experience in Oracle Database Administration in windows and Unix operating systems.Worked in Oracle Grid, RAC and RMAN technologies.
• Worked on Peoplesoft MAA ( Maximum Availability Architecture )
• Experience in object migration and change management using Quest tool STAT.
• Experience in implementing the Integration Broker technologies, Single Sign - on and LDAP
• Experience in configuring and administering the weblogic web server.

TECHNICAL SKILLS

• Operating Systems: Windows, SUN-Solaris-8, Linux, AIX- UNIX, Redhat Linux
• Databases: Oracle 7.x, 8 and Oracle 8i, 9i, 10g, 11g
• ERP Packages: Oracle Financials, PeopleSoft 7.5,8 and 9.1
• Development Tools: Developer 2000, Visual Basic 5.0
• Reporting Tools: Reports 2.5
• Application Server: Tuxedo, Websphere 6
• Web server: Apache and Weblogic
• Languages: Sql, PL/Sql, Shell Scripts
• Administration Tools: Oracle Enterprise Manager, Spotlight, Toad, DBA Artisan
• Other Tools : Peopletools, STAT Version 5.2.0, Spotlight, Foglight.

PROFESSIONAL EXPERIENCE

Confidential, Loveland, CO

Responsibilities:

• Played a key lead role in preparing, planning and executing PeopleSoft admin.
• Installed BEA Tuxedo, people tools 8.52 and Micro Focus Cobol on UNIX, Configured application server, process scheduler.weblogic 10.3.1 Configured PIA on AIX unix ver.7.1
• PeopleTools configuration includes Application Server, Process Scheduler, Integration Broker, Web Server, Report Repository.
• Installed PeopleSoft environments.
• Cloned PeopleSoft environments
• Designed and implemented security and SOX compliant procedures
• Tuned PeopleSoft application server and process schedulers
• Installed, configured and performed Server Admin tasks with Oracle datagaurd and RAC environment.Performed Server Admin tasks with Batch, Web and Application server.
• Exported people soft security to preserve and imported after refreshes.
• Analyze issues and Troubleshooting PeopleSoft admin related issues.
• Served as the technical expert for resolving escalated technical issues and system faults
• Oracle database, PeopleSoft administration and control management process.
• Responsible for database changes using oracle sql, project migration, applying patches and fixes and tax updates, and database activities like Database refresh, tuning and security tasks.

Environment: PeopleSoft FIN 9.1,PeopleTools 8.52. Oracle 11g, AIX 7.1, STAT Version

Confidential, Pasadena, CA,

Responsibilities:

• Played a key lead role in preparing, planning and executing PeopleSoft tasks and websphere administration.
• Installed BEA Tuxedo, people tools and Micro Focus Cobol on UNIX, Configured application server and process scheduler.
• Installed PeopleSoft environments.
• Installed people tools, weblogic on windows, Configured PIA on windows.
• Maintained PeopleSoft environments, set up IIS, install and update SSL
• Cloned PeopleSoft environments
• Designed and implemented security and SOX compliant procedures
• Applied maintenance packs and Tax bundles
• Tuned PeopleSoft application server and process schedulers
• Tuned weblogic web servers
• Worked on Peoplesoft MAA ( Maximum Availability Architecture )
• Performed Server Admin tasks with Oracle datagaurd and RAC environment.
• Performed Server Admin tasks with Batch, Web and Application server.
• Exported people soft security to preserve and imported after refreshes
• Oracle database, PeopleSoft administration and control management process. Responsible for project migration, applying patches and fixes and tax updates, and database activities like Database refresh, tuning and security tasks.
• Upgraded different peopletools versions 8.51/8.46 /8.42/8.21.
• Implemented the Integration Broker technologies, Single Sign-on and LDAP . Supported the administration and maintenance of PeopleSoft modules such as HCM, CRM, EPM, ELM and Portal.
• Utilized STAT 5.2.0 as a change control tool for managing PeopleSoft changes.
• Communicated with internal department workflow throughout Enterprise Change Management (ECM) activities and ensure that changes implemented at the enterprise level meet specific guidelines as set forth by the management from the systems point of view while using expertise in change control management process, PeopleSoft, CRM, Oracle;
• I have lead offshore team, conducted team meeting, assigned tickets and managed Offshore projects.
• Provided direction to IT Central and development groups in order to minimize the risk of unpredictable development schedules; provide guidance and enforcement of ECM.
• Facilitate centralized communication and tracking of IT production changes across the enterprise Ensure protection of company's software assets and monitor changes;
• Reviewed IT Central and development group change procedures and make recommendations for improvements.

Environment: PeopleSoft HCM, CRM. EPM, ELM 8, 9, Oracle 9i/10g/11/g, AIX Unix, STAT Version 5.2.0

Confidential, Pasadena, CA

Responsibilities:

• Played a key lead role in preparing, planning and executing the PeopleSoft tasks. Below is the list of title related detail tasks.
• Installation of PeopleSoft environments.
• Installation of BEA Tuxedo, people tools and Micro Focus Cobol on UNIX, Configuration of application server and process scheduler.
• Installation of people tools, weblogic on windows, Configured PIA on windows.
• Maintained PeopleSoft environments.
• Cloned PeopleSoft environments.
• Designed and implemented security and SOX compliant procedures.
• Applied maintenance packs and Tax bundles.
• Tuned PeopleSoft application server and process schedulers
• Tuned Weblogic web servers
• Performed Server Admin tasks with Batch, Web and Application server.
• Exported people soft security to preserve and imported after refreshes.
• Oracle database, PeopleSoft administration and control management process.
• Responsible for project migration, applying patches and fixes and tax updates, and database activities like Database refresh, tuning and security tasks.
• Supporting the administration and maintenance of PeopleSoft modules such as HCM, CRM, ELM and Portal.
• Utilized STAT 5.2.0 as a change control tool for managing PeopleSoft changes.
• Communicated with internal department workflow throughout Enterprise Change Management (ECM) activities and ensure that changes implemented at the enterprise level meet specific guidelines as set forth by the management from the systems point of view while using expertise in change control management process, PeopleSoft, CRM, Oracle.
• Provided direction to IT Central and development groups in order to minimize the risk of unpredictable development schedules; provide guidance and enforcement of ECM
• Facilitate centralized communication and tracking of IT production changes across the enterprise Ensure protection of company's software assets and monitor changes;
• Reviewed IT Central and development group change procedures and make recommendations for improvements

Environment: PeopleSoft HRMS 8.01, 8.2/Oracle 9i

Confidential, Lexington, MA

Responsibilities:

• Confidential, A navisite company, the leading application outsourcer of On Demand Solutions for middle market companies, delivers brand name application choice and affordable strategy, implementation, outsourcing and optimization services.
• Confidential 's complete solution portfolio comprises Customer Relationship Management, eBusiness, Financial Management, Human Resource Management, Productivity and Supply Chain Management solutions.
• Confidential offers vertical expertise in the manufacturing/distribution, financial services, healthcare/pharmaceutical, services, publishing/media & communications, and public sector industries.
• As a PeopleSoft Application DBA my responsibility on this project, handling database problems and worked as on call DBA.
• My responsibility also includes Database Refresh, Database Tuning Application, Applying Patches and Fixes, Configuration of Application server Tuxedo.
• Interacting with clients to resolve the database issues. My role also includes coordinating with offshore as this project is an Onsite offshore Model.

Environment: PeopleSoft HRMS, EPM, CRM and Financials 8.4/Oracle 8i,9i (2003)

PeopleSoft Administrator,

Confidential,

Responsibilities:

• Confidential Bank has been implementing PeopleSoft financials General Ledger for countries like Singapore, USA, UK, Hong Kong and Middle East countries.
• We have provided the infrastructure support for development and production support for production systems.
• As a Application DBA my responsibility on this project includes Production support for Singapore and US databases, handling database problems and worked as On call DBA. Created operator panel and support panel using shell scripts to administer database appserver domain process schedulers etc.
• Written batch jobs to backup database, startup, shutdown databases, appserver domain, process schedulers and webserver etc.
• My responsibility also included New Environment Building and Database Refresh, PeopleSoft project Migration thro STAT and, Applying Patches and Fixes, Configuration of Application server Tuxedo. Interacting with clients to resolve the database issues.
• Monitoring Batch jobs using Control M.

Environment: PeopleSoft HRMS and Financials 8.3/Oracle 8i (2003)

Confidential,

Responsibilities:

• Migration project for Confidential (ASP) headquartered in Pleasanton, California. It provides application hosting services for US clients.
• As a cost cutting measure Confidential decided to handover the ASP to Confidential and HP has decided to move their Clients applications from Sun Solaris Unix to HP UNIX.
• This Migration project includes the following
• Migration of Oracle databases, Exporting and importing of the existing Databases.
• Migrating the PeopleSoft projects, sqr. sqc, Cobol files etc.
• Reconfiguration of the application server domains
• Reconfiguration of the Process Schedulers in both Unix and NT servers
• Reconfiguring Web server domains complete IVT ( Installation Verification Test )

Environment: PeopleSoft HRMS 8.3, Oracle 8, 8i, TOAD

PeopleSoft Administrator

Confidential

Responsibilities:

• Confidential is an Application Service Provider (ASP) headquartered in Charlotte, North Carolina, USA.
• It provides application hosting services for US clients.
• It has two data centers in the US (Richmond, Viginia and Richardson, Texas) from where the PeopleSoft applications and other HR applications like Global advantage, Ceridian, Restrac are hosted.
• All the applications are running in oracle database and hp-ux 11 Operating System.
• As an Application DBA my responsibility on this project is knowledge transfer to the offshore team The knowledge through the also includes Process of Database Refresh, Database Tuning Application Security administration and Oracle Security administration, Applying Patches and Fixes, Configuration of Application server Tuxedo.
• Interacting with clients to resolve the database issues. Database Security administrations like adding, modifying or deleting the users, administering the quotas to the users, auditing and checking for security Problems.
• Monitoring Database using DBA artisan.

Environment: PeopleSoft 7.50/8.0, Oracle 8, 8i, TOAD

Confidential,

Responsibilities:

• Confidential project for Confidential (ASP) headquartered in Pleasanton, California.
• It provides application hosting services for US clients.
• As a cost cutting measure Confidential decided to downgrade all the 40 Oracle Databases from Enterprise version to Standard Edition.
• This project includes the downgrade of Oracle database 8.1.7 Enterprise Edition to Standard Edition, Exporting and importing of the existing Databases and Complete IVT (Installation Verification Test)

Environment: PeopleSoft 7.50/8.0, Oracle 8, 8i

Confidential,

Responsibilities:

• Confidential is an Application Service Provider (ASP) headquartered in Pleasanton, California.
• It provides application hosting services for US clients. It has two data centers in the US (Pleasanton and Austin) from where the PeopleSoft applications are hosted.
• At that time around 40 clients have been hosted.
• Applications supported are PeopleSoft HRMS & Financials (7.x & 8) and CRM. ECenter was expecting the number of clients to increase to 100 by the end of 2001.
• Due to increasing number of clients, PeopleSoft decided to outsource part of the hosting support services.
• As a result, a pilot project was given to Hexaware to demonstrate the offshore/onsite capability to support ASP clients. Application DBA is the area identified by PeopleSoft for the pilot project.
• The scope of the main project includes activities relating to Application DBA, System Administration, Support and Extended Services
• As an Application DBA my responsibility on this project includes Migration, Upgrades, applying Patches and Fixes, Database Refresh, Win NT(Citrix admin), Database downgrade .
• Database Monitoring, Application Security administration and Oracle Security administration.
• Installation of PeopleSoft HRMS 8 Demo & Production on AIX & NT. Installation & Configuration of Application server on AIX & NT Configuring Net8 Installation & Configuration of Process Scheduler on AIX & NT Installation & Configuration of PIA (PeopleSoft Internet Architecture) with both Apache and Weblogic Installation of Oracle 8I, Database creation, Crystal Reports, SQR, Tuxedo on AIX & NT Support Help desk call on Application Server, Process Scheduler, Crystal Reports & SQR, Worked on PeopleSoft HRMS (HR, Benefits, Ben Admin) Upgrade 7.0 - 8.3

Environment: PeopleSoft 7.50/8.0, Oracle 8, 8i, AIX unix and NT

Confidential,

Responsibilities:

• Confidential was a site fully about cricket sports, cricketers, cricket statistics.
• All the one day international Scorecards which were in flat files are loaded in the Internet database.
• After successfully loading into the database all the one day match and test match International Cricket Statistics were generated.

Environment: Oracle 8i, Sun Solaris Unix

Confidential,

Responsibilities:

• Administering financial accounting in oracle database.
• Implementing the security level for the software developed as per the requirements of the client.
• Planning the effective backup and recovery strategies for the database Backup includes logical, hot as well as cold backups for data file, archive files, control file and tablespaces.
• Performing the periodic check of the backup with recovery in the test database.
• Worked on development of financial accounting project.

Environment: Oracle 7 Windows