Project Oracle

Jayaprakash Dhanapal

PROFESSIONAL SUMMARY:

Over 15 years of experience in the IT industry. My experience includes implementation & supporting full life cycle PeopleSoft Projects for HR, Financials, CRM, Portal, 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, Newport University.

• 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., Bank of America, Hewlett Packard, Standard Chartered 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

• Having work experience in websphere application server administration.

• Experience in object migration and change management using Quest tool STAT.

EDUCATION:

MBA Specialized in Computer, Newport University 2000 (Graduated)

CERTIFICATIONS:

OCP (Oracle Certified Professional) certified Oracle DBA ; Candidate ID: I00128909

TECHNICAL DETAILS:

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 8

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

PROJECT DETAILS:

Employer: Countrywide Home Loans (Bank of America) 01/2006 to Aug 2012

Locations: Pasadena CA, Plano TX, Richardson TX and Addison TX

Position Title: Consultant II System Eng. End of Project

Played a key lead role in preparing, planning and executing PeopleSoft tasks and websphere administration.

Responsibilities

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 certificates

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.

Upgraded different peopletools versions 8.51/8.46 /8.42/8.21

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;

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 8, 9, Oracle 9i/10g/11/g, AIX Unix, STAT Version 5.2.0

Client: Countrywide Home Loans Pasadena, CA

Employer: EC Manage 05/2005 to 01/2006

Position Title: Software Engineer End of Project

Played a key lead role in preparing, planning and executing the PeopleSoft tasks. Below is the list of title related detail tasks.

Responsibilities

Installed PeopleSoft environments.

Installed BEA Tuxedo, people tools and Micro Focus Cobol on UNIX, Configured application server and process scheduler.

Installed 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

Client: Surebridge, Inc. / A Navisite Company Lexington, MA

Employer: Hexaware Technologies, Ltd. 09/2003 to 05/2005

Position Title: Sr. System Analyst End of Project

Surebridge, 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. Surebridge's complete solution portfolio comprises Customer Relationship Management, eBusiness, Financial Management, Human Resource Management, Productivity and Supply Chain Management solutions. Surebridge offers vertical expertise in the manufacturing/distribution, financial services, healthcare/pharmaceutical, services, publishing/media & communications, and public sector industries.

Responsibilities

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, CRM and Financials 8.4/Oracle 8i,9i (2003)

Client: Standard Chartered Bank Singapore

Employer: Hexaware Technologies, Ltd. 09/2002 to 09/2003

Position Title: Sr. System Analyst

Standard Chartered 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.

Responsibilities

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)

Client: HP Chennai, India

Employer: Hexaware Technologies, Ltd. 05/2002 to 09/2002

Position Title: Sr. System Analyst

Migration project for Hewlett Packard (ASP) headquartered in Pleasanton, California. It provides application hosting services for US clients. As a cost cutting measure PeopleSoft Ecenter decided to handover the ASP to Hewlett Packard and HP has decided to move their Clients applications from Sun Solaris Unix to HP UNIX.

Responsibilities

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

Client: Bank of America Chennai,India/ Charlotte, NC

Employer: Hexaware Technologies, Ltd 11/2001 to 05/2002

Position Title: Sr. Technical support Engineer

Exult 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.

Responsibilities

As an Application DBA my responsibility on this project is knowledge transfer to the offshore team The knowledge through the training 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

Client: PeopleSoft, Inc. Chennai, India

Employer: Hexaware Technologies, Ltd. 09/2001 to 11/2001

Position Title: Sr. Technical support Engineer

Oracle Downgrade project for PeopleSoft Ecenter (ASP) headquartered in Pleasanton, California. It provides application hosting services for US clients. As a cost cutting measure PeopleSoft Ecenter 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

Client: PeopleSoft, Inc. Chennai, India

Employer: Hexaware Technologies, Ltd. 02/2001 to 11/2001

Position Title: Sr. Technical support Engineer

PeopleSoft ECenter 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

Responsibilities

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

Employer: ClickCricket, Ltd. 05/1999 to 02/2001

Chennai, India

Position Title: Database Administrator

Project 1 : Data Warehousing

Clickcricket 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.

Responsibilities

Creation of SQL*Loader scripts, Creating complex SQL queries & Data validation scripts.

Project 2 : Replication of Database

Clickcricket server is located in VSNL and it was replicated to our local office server for backup server. Replication is done in such a way that the remote server is in sync with

Local server.

Responsibilities

Installation of Oracle 8i. Replicated (Basic Replication) the database from vsnl server to local server for clickcricket.com Configured init.ora file and enabled parameter to support replicated environment .Created materialized views and refresh groups that refreshes periodically.

Other Activities

Developed hot backup Scripts and automated

Implemented the security

Worked on the periodic check of the backup with recovery in the test database.

Workde on backup using hot backup and cold back up of datafiles, redo logs and control files

Tablespace management

Worked on backup with recovery

Environment: Oracle 8i, Sun Solaris Unix

Employer: Excp Computers, Ltd. Chennai, India

08/1996 to 05/1999

Position Title: Database Administrator

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

Contact Details :

Phone :214-***-****

Email : **.********@*****.***

Contact this candidate