SUMMARY:

• Over 13+ years of experience in IT. Last 12+ years of experience as a Lead ERP/Peoplesoft Application's Administrator/DBA.
• Possess strong communication, leadership, analytical, organisational and relationship management skills. Experience of working with cross - cultural and multi-lingual teams.
• Technical strengths -Extensive experience in PeopleSoft HR/Finance/CRM/LMS/Portal/EPM Applications, Oracle Application which includes Application DBA/Oracle DBA Support for US and Global implementation, Upgrade, Patches, Fixes, Security Administration, Design, Development, Installation, Patch update, Cloning, backup & recovery(RMAN), Configurations formulation, performance tuning & implementation of disaster recovery strategies. Experience in HR, Finance, Insurance, Manufacturing,, Oil and Gas, Pharmaceutical, Retail, Finance, United Nation (Mulity countries)and retail sectors.

TECHNICAL SKILLS:

Operation Systems: Unix(SCO,HP,AIX 5.3/6.1.,VMS,Linux RHEL 5, Sun Solaris), Windows XP/95/NT/ 98/2003/2008, Novell NetWare, Linux, OS/400, Sun Solaris Server 7.00 & 8.00, Vmware, CentOS, Virtual Box.

Languages/Tools: PL/SQL,SQL*PLUS, svrmgrl, Forms 4.5/5- Developer 2000, OEM, Pro*C, Oracle DBA tools, Toad, Oracle Performance Tuning Tools, Erwin, Sql*Loader,Cognos, Informatica 4.1,C,C++, Java,COBOL/400, RPG,ASP,IIS,PWS, People Tools, PIA, Tuxedo (8.1-10.3), Web Logic 8.1-10.3).,PeopleSoft Upgrade Assistant and Changes Assistant, MS Project, MS Office,Star Team, STAT people soft migration tool, Quick Test Professional 6.5 and CITRIX

ERP: Oracle Applications(eBusiness suite) 10.7 SC/NCA/ 11i (11.5.3, 11.5.5 & 11.5.8), 12i, Oracle 9ias, PS DBA, PeopleSoft FINANCE/ELM/Portal/CRM/EPM/HRMS 9.1 SP1 (ver. 7.x - 9.2) (US, Canada UK and Multi-language) with People Tools 8.53 (ver. 7.5-8.53), Oracle 9iAs/10gAs,Web Logic 6.1-10.3.3.

DBA: Oracle 11g (ver 7.3.4 - 11g) DBA, MS-SQL Server 7/2000, DBA, Backup/Recovery, Oracle Performance Tunings, Oracle Apps DBA, DB2/400, Ms-Access. Orbit Application Version 5.00, Netcharts 4.00, Vista Administrator, SQL Developer, STAT Peoplesoft migration Tools, Oracle RAC, RMAN, Data Guard, Oracle ASM, PHIRE and OBIEE.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and upgradation of PeopleSoft/Oracle Applications, Bundles and Oracle server software (RDBMS).
• DBA experience and knowledge within 11G/10G(Oracle 11.2.0.2/3, 11.1.0.7, 10.2.0.5).
• Experience in Oracle 11 RAC ( Installation, Adding/removing nodes, load balancing, migration from non-RAC to RAC env, Oracle ASM).
• Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 8i, 9i, 10g) in production, testing and development environments hosted on Unix servers (HP, Linux, AIX, Sunsolaris) and Windows servers.
• Responsible for RMAN backups of production databases.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.
• Responsible for consolidation of several production, test, and development multi-terabyte databases by migrating from DB2 environments to AIX.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Installation, upgrade and patching of databases from Oracle 8i, 9i, Oracle 10g to 11g.
• Support of databases using High Availability & PeopleSoft weblogic clustering
• Monitor database performance via TOAD, STATSPACK, and Quest STAT Tools.
• Participation in design reviews for upcoming application enhancements.
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• 24/7 Production Support for Peoplesoft Applications/Database/Apps DBA environment.
• Experience in PeopleSoft Application of Tax Updates, Patches and Fixes.
• Bug Fixing, Troubleshooting and Helpdesk support in Peoplesoft Environment.
• Maintain security, portal security in all environments. Grant roles to user profiles, update reqd. security tables etc.
• Experience in handling Application Server and Process Scheduler related issues.
• Provide technical support to application development teams.
• Strong problem solving and analysis skills in high-pressure environments.
• Installed, administered, and tuned PeopleSoft including application, process schedulers,
• Analyze compare reports b/w different environments, running/analyzing audit reports - DDD, SYS and ALTER audits and creating/configuring domains, sites.
• Defining Report Nodes for various environments and fixing issues.
• Experience using Upgrade assistant/Change assistant tool to perform all the required steps in peoplesoft applications/people tools upgrade/Patch/bundle/Tax upgrade.
• Generated scripts to build all the required objects in the database.
• Planning and preparations for each Test Move, including identification and application of patches and fixes. Running Data mover scripts, analyzing audit/compare reports.
• Experience in managing large server environments with high availability. Provide expertise on hardware/software requirements for implementing PS architecture, interfacing, configuration management in multiplatform environment including Windows/UNIX Servers as well as Oracle database, MS-SQL Server and DB2.
• Project planning and coordination with functional teams/clients for the enhancement of existing PeopleSoft systems, the creation of new environments, database backup strategy, coordination, development, report generation, data manipulation, maintenance of software application and hardware to meet business needs.
• Maintaining project plans, issue logs and performing resource management to ensure on time project delivery.
• Peoplesoft Oracle performance tuning for worst long running process/jobs/SQLs
• Job scheduling tools like Maestro, Crontab and Autosys.
• Perform periodic SOX audits and provide reports to auditors based on the questions.
• Installation, configuration and upgradation of Oracle server software, Oracle Applications/PeopleSoft Applications.
• Physical database design & creation. Devise strategy for Backups, recovery & fine-tuning.
• Creation of tablespaces, rollback segments, user maintenance, database security imposition by creation and granting of roles and privileges, performance tuning, backups (Hot/Cold/Logical) using RMAN. Managing Oracle security and Oracle network tools
• Tuning of SQL statements and support for Oracle toolsets and utilities like SQL*Plus.SQL Query optimization using Oracle Explain Plan.
• Provide technical support to application development teams.
• Evaluate Oracle features & related products. Setup and maintain documentation and standards
• Interfacing with Oracle technical teams for upgrades, latest version, iTAR and utilities.
• OBIEE Administrator and migrator
• Design, development, testing, troubleshooting and debugging of the application.
• Oversee smooth implementation and testing and implementation at client location.

Confidential

Peoplesoft Technical DBA/Consultant

Responsibilities:

• Plan, Install, configure, test and release PeopleSoft instances as per requirements
• Provide technical support for Managed PeopleSoft Hosting services provided by UNICC, including system administration of PeopleSoft technology components such as WebLogic, PeopleSoft PIA, Tuxedo, Process Scheduler, DataStage, OBIEE, PeopleSoft Performance Monitor, and Oracle databases
• Perform routine production support activities and provide incident and problem management support. Troubleshoot PeopleSoft-related issues
• Co-ordinate with the application and database vendors for resolution of problems (functional bugs, performance issues, etc)
• Conduct database and environment refreshes
• Perform support activities during maintenance windows
• In case of emergencies, perform support (either on-site or remotely using VPN connectivity) outside normal working hours
• Provide standby and on-call support as and when required
• Monitor capacity. Implement new PeopleSoft environments as required
• Performed tools 8.53.04, application and database upgrades(11.2.03)
• Provide technical support for the ERP development team of the Partner Organization(s)
• Plan and conduct DR tests
• Provide assistance in landscape design
• Produce documentation as required
• Implement project-type activities and other requests for services
• Liaise with Partner Organizations on a service management basis
• Perform other duties as required
• Planning the upgrade project
• Running the initial pass
• Data conversion. Rman backups and schedule
• People Tools version 8.46, 8.50+ to People Tools 8.52.
• Peopletools upgrade, 8.50.09/8.5 .04 using Change Assistant.
• OBIEE administration& monthly migrations
• Tuned long running conversion sqls/ Undertake performance tuning.
• Preparation of OS Re-platforming and application/tools upgrade projects
• Worked on new hardware refresh project from one server to other servers.
• Install COBOL compiler Server express 5.1 WP6 and compile PeopleSoft delivered COBOL programs.
• Run PeopleSoft installation tests and matrix before the upgrade.
• Currently working on Application upgrade of CRM/ELM/HRMS and Finance l from 9.0/9.1 to 9.2 and applying latest bundles to portal 9.1 env

Confidential

Sr. Peoplesoft DBA/Admin

Responsibilities:

• Cognizant Lead PSAdmin/Upgrade Specialist for these projects.
• Migrate DB between software versions(DB2 to Oracle 11g), platforms, DB products
• Handled multiple projects( HRMS/FINANCE) on parallel track
• We have performed Infra Hardware/software the application support analysis.
• Ensure all deliverable are completed, approved and appropriately versioned Provide status
• Formulate PS Instance plan
• PeopleSoft DB/Environment refreshes
• Ensure installation, creation and maintenance of demo, development, testing,, QA, conversion and Production related PS instances (FSCM 9.1/HCM 9.1/ PT 8.51.11)
• Run various audits to ensure tight integrity. Participate in Architecture review meetings.
• Co-ordinate with OS/Network teams. Co-ordinate/review/monitor with offshore team for Peoplesoft admin related work assignment and support during the project
• Project Migration across instances. Monitor instances during performance testing
• Design Security setup for new PS objects
• Creation, modification, migration and retrofitting of security objects. Unix shell scripting.
• Peoplesoft Web logic cluster/Load balancer setup. Resolving critical issues during SIT/UAT/PROD build phase. Monitor instances during performance testing
• Peoplesoft Oracle performance tuning for worst long running process/jobs/SQLs (Example. HRMS Paycalc process tuned from 27 hours to 3 hours, Finance Voucher Build process tuned from 3 days to 2 hours and Pay cycle process)
• People Tools upgrade from .07 in DB2 Mainframe
• Trained Client team for Peoplesoft apps DBA tasks (Example. HRMS Tax update, COBOL installation, Peoplesoft Weblogic cluster installation)
• Performed Oracle DBA tasks to support to client DBA and projects (Running Oracle Grants, Gathering Oracle stats(DB/Schema/Table level), Running status, Truncating tables, Identifying bad SQLs, Monitoring the Database, Creating table spaces, Database space analysis and performance tunings (init.ora level and DB level), Oracle Database monitoring and other daily tasks as required.
• Experience with data mover, Application designer and client set up. Helping to run big conversion script in the UNIX and Windows server
• Experience using Change assistant tool to perform all the required steps in Peoplesoft applications/people tools upgrade/Patch/bundle/HRMS Tax upgrade.
• Peoplesoft application upgrade from HCM 8.9 to HCM 9.1 MP2, FSC 8.0 to FSCM 9.1 MP4.
• Supporting nVision, Crystal report issues for development team
• Work with developers and end- users to analyze, diagnose, and troubleshoot problems and deliver recommendations in an efficient manner
• Install, configure, patch and maintain PeopleSoft web servers/Application servers/process scheduler servers
• Analyze and apply periodic PeopleSoft application patches, tax bundles etc
• Configure and maintain PeopleSoft Integration broker
• Configure and maintain PeopleSoft REN server with SSL layer.
• Application of Web s for all Production Web servers and Load balancer servers.
• Support PeopleSoft change assistant to apply tools and application bundles
• Install/Support the People Books and PeopleSoft demo systems
• Peoplesoft security Administrator
• Performed Real DR ( Applications, web server, process scheduler and database server in DataGurd)
• Resolved critical production issue related to nVision and check printing(sev1).
• Support to configure the Oracle Data guard.
• Configures, sizes and assists in the planning for all server hardware for hosting and proposals with infra team manager
• Participate in the hardware and software procurement to support the growth.
• Share best practices with the development teams and work in optimizing database queries.
• Work with vendors to apply necessary patches to the database (Oracle database, Shareplex, Oracle Grid/OEM, Oracle Data Guard) products

Confidential

Lead Peoplesoft DBA

Responsibilities:

• Peoplesoft Admin for production support, various projects support for ERP apps.
• Project Lead/ PSAdmin for this project.
• Lead PS DBA support in PeopleSoft environment
• Peoplesoft Admin support / apps upgrade specialist for various projects
• Worked as System Analyst/Sr.Peoplesoft DBA for various projects for Hexaware Technologies Inc. ( ) using PeopleSoft Finance/PeopleSoft HRMS 7.5/8.9 SP1/MP1, PeopleTools 7.5/7.63, Tuxedo 8.x and Web Logic 8.x, Oracle 8i,9i,10g Windows NT, Sun Solaris 8.00. Peoplesoft Application database Server, Process Scheduler, VNC Software, Putty, Weblogic 6.1-8.1, MS-SQL Server 2000. Contributions: Oracle Apps DBA/Peoplesoft Application DBA/DBA for various clients support. Applications hosting support, Production support & Upgrade support. Maintenance of various applications/database related support for Development/ Productions envs. TeamSize: 91
• Worked as Oracle Financials DBA/Consultant for Vsource In corporate projects for: BITECH (310893 H) ( Bitech), Malaysia. ( ) using Databases. Oracle8i/9i, SQL-SERVER 7.00/2000, Windows NT 4.00, Sun Solaris 8.00. Oracle Application database Server (CRM) 11i, Red Hat Linux 8.00, VNC Software, Putty (SSH Tool) Oracle 9i Application Server, Oracle 9iAS Portal. Contributions: Oracle Financials DBA/Consultant or various projects support. Maintenance of various database related support for Development/ Productions Databases. TeamSize: 25
• Worked as Senior Oracle DBA for Japanese projects for: Confidential Pvt Ltd, Chennai, (A CMM Level 4 Company), Tokyo, Japan. ( ) using JSP, VC++, JAVA.Oracle8i/9i, Pro*C, Oracle 8i,Sun Solaris Japanese Environment,NT, Thin Driver,ODBC, JDBC, Sun Solaris Advanced Server. Contributions: Senior Oracle DBA/ DBA for various Onsite/Offshore projects support. Maintenance of various database related support for Development/ Productions Databases. TeamSize: 35
• Worked as Programmer/Consultant for Malaysian projects for Klong Container Terminer, BHD (Malaysia), BITECH, Chennai ( ) using Windows 95, Unix, Oracle 7.x, 8, Developer 2000,(PL/SQL, VMS, Designer/2000. TeamSize: 39
• Worked as Junior Oracle DBA/Programmer for Suhail & Saud Bahwan (The Bahwan Group) ITP Computer Division Muscat, Oman - Client:Ministry of Oil and Gas ( 9) using NT,Oracle 8,8i, Dev’2000, PL/SQL, EM, Svrmgrl.,Unix. TeamSize: 12
• Worked as Oracle DBA/Programmer for Naveen Computers (p) Ltd., Trichy ( 8) using Windows 95, Oracle 7.3, Developer 2000 (Forms 4.5), Windows NT.TeamSize: 6