Oracle Applications & Database Administrator

SATYA GANDI

TECHNICAL

SUMMARY:

Over ** years of total IT industry experience in Systems Analysis, Design, Development and Implementation of Custom and ERP projects with Fortune 500 companies

Over 10 years of Oracle Applications DBA experience in R12, 11.0 and 11i ERP, HRMS, Payroll, Financials, OPM, ASCP, Demantra and Manufacturing applications install and upgrade

Over 10 years of Oracle DBA experience in Oracle 6.x-19c Installation, maintenance, performance tuning and backup of custom databases of sizes over 1TB

Over 7 years of Project Leadership in Analysis, capacity planning, resource management, and user training

TECHNICAL

SKILLS:

Database Installations: Oracle 19c, Oracle 18c, Oracle 12c. Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, Oracle 8, Oracle 7 and Oracle 6

Database Upgrades: Oracle 6 to 7, Oracle 7 to 8, Oracle 8 to 8i and Oracle 8i to 9i, Oracle 9i to Oracle 10g, Oracle 10g to 11g, 11g to 12c, 12c to 18c, 18c to 19c.

Oracle Applications Installation: Oracle Financials 10.7, Oracle Applications 11.0.3, Oracle Applications 11i (11.5.10), Oracle EBS 12.1, 12.2 on Sun E10K, HP 9000, DEC Alpha, Dell 5600 Linux x86,IBM AIX 5.2

Oracle Applications Upgrade: 10.7 to 11i, 10.7 to 11.0,11.0 to 11i, 11i to Release 12. R 12.1.3 to 12.2.x

Operating Systems: Linux x86, AIX 5.x, UNIX System V R4, Sun OS 4.1, Solaris5.8, MS-Windows 95, NT 4.0, Linux x86

GUI Builders: Visual Basic 3.0, Power Builder 3.0, and Developer 2000

Languages: C, Shell Scripts, COBOL, Pascal, FORTRAN, Perl 5.0, and Java

Databases: SYBASE 11.5, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Forms 4.5, Forms 6.0,Reports6.0, SQL*Menu, Pro*C, SQL*Loader, SQL*Net, PL/SQL, Oracle DBA (incl. Financials DBA), Focus, FoxBASE, REXX, Unify, MS Access, Crystal Reports 5.0, MS SQL Sever

Hardware: Exadata 2.2, Exalogic 2.0, HP Superdome, HP Itanium, IBM P7, IBM P6, IBM 3070, ND 530, Intel Pc’s, Sun E25K, Sun-sparc 20, Sun ultra - 160, Sun Enterprise 4000, Sun Enterprise 4500, DEC-ALPHA, RS 6000, HP 3000

EXPERIENCE:

01/19-Till date : Department of Energy, Maryland

Project: Upgrade of Oracle Applications from 12.1.3 to 12.2.8 & setup Dashboards using Oracle ECC framework V2.

Role : Oracle Apps DBA consultant

Completed the Comptia Security + certification.

Upgraded the Oracle Applications from 12.1.3 to 12.2.8.

Integrated Oracle EBS with The Stripes, FDS & Hyperion systems.

Resolved performance issues of Database & Oracle Applications.

02/17 – 12/18 : Department of Education:

Project : Upgrade of Oracle EBS from 11.5.10.2 to 12.2.6, Database Migration from 11.2.0.4 to 12.1.0.2

Platform migration from AIX to Linux.

Role: Lead DBA handling the R12.2.6 upgrade project.

Lead the project and prepared the detail steps of upgrading from Oracle EBS from 11.5.10.2 to 12.2.6 and database

From 11.5.10.2 to 12.2.6

Integrated EBS with Cognos, Sunflower, Grants system (G5), Hyperion.

Resolved the performance issues, online enablement issues.

Setup the PCP and HSTS compliance for load balancing.

01/15- 01/17 Teva Pharma, Horsham, PA

Project : Global Implementation of EBS 12.2 and database 12.1.0.2 on Exalogic/Exadata servers. Exadata/Exalogic migration from 2.0 to 5.x

Role : Team Lead/Consultant.

Handled the performance issues in the global rollout of EBS 12.2 to European countries.

Worked on the Exadata/Exalogic migration from 2.0 to 5.x

Setup of the SDP protocol instead of TCP/IP for faster client performance.

Installed ERP & VCP(ASCP) 12.2. Instances .

Resolved the scoring harness Engine performance Issue in advanced collections.

Resolved strategy management concurrent process running long.

Advanced Collections - View Account Form Performance Issue.

Advanced Collections Performance In Searching Customer By Transaction.

Tested the Oracle Apps and resolved numerous issues related to the

1.Relink of Application executables

2.Changing of sql execution plans due to migration.

3.Forms & Reports migration issues .

4.Testing the DR/failover for seamless smooth transition.

07/14- 12/14 Dell Computers Round Rock, Austin, TX.( Remote)

Project : Omega Upgrade from 12.1.3 to 12.2.4 Oracle EBS Applications. Performance tuning after go-live.

Role : Team Lead/Consultant.

Reduced the 12.2.4 upgrade time from 120 hours to 56 Hours on 30TB data.

Resolved numerous performance issues related to custom code/ Vanilla Code which will be a show stopper/hindrance to the business.

02/13 – 06/14 Alticor Inc., Grand Rapids, MI

Project: Global Implementation of EBS 12.1.3 and database 11.2.0.3 on Exalogic/Exadata servers. Upgrade from Oracle EBS 12.1.3 to 12.2

Role : Consultant Team Lead. Team size : 10 .

The database size is 3 TB and is running on Exadata 2.2 . The EBS is running on Exalogic 2.0.

Implemented Smart Scans, Flash cache & HCC.

Maintained the exadata storage cells.

Configured the exalogic compute nodes for EBS 12.1.3 Installation.

Resolved the configuration issues on ILOM.

Worked on the upgrade from 12.1.3 to 12.2.5

09/12 – 01/13 Harvard University, Cambridge, MA

Project: Upgrade of EBS from 11.5.10.2 to 12.1.3 and database from 10g to 11.2.0.3 and beta upgrade from 12.1.3 to 12.2

Role : Consultant Team Lead. Team size : 10 .

The database size is 2 TB and is running on Solaris E25K servers. Resolved numerous issues that plagued the IT & Business. These issues have been growing over time and required both functional and technical knowledge to resolve. My contributions were often recognized by the business and the IT department.

Reduced the upgrade timing from 72 hours to 48 hours.

Resolved the performance issues by tuning the JVM’s

Captured the bottle necks and improved the performance

Of the Auto-create invoice process.

Captured all the plans before the DB upgrade and implemented

SPM to overcome the performance issues after the upgrade.

Completed the beta upgrade from 12.1.3 to 12.2

Discoverer upgrade from 10G to 11G.

01/12 – 08/12 Stuller Inc., LA

Project: Upgrade of EBS from 11.5.10.2 to 12.1.3 and reduce the down time of upgrade from 104 hours to 48 hours

Role : Consultant Team Lead. Team size : 6 .

The database size is 3.2 TB and is running on HP superdome. Resolved numerous issues that the upgrade team is facing. These issues are

Set SGA, PGA and audit_trail, recyclebin, parallel_max_servers and job_queue_proceses,aq_tm_proceses

Set the JREOPT & JRIOPT parameters in the middle tier.

Set the batch commit size to 200000 and parallel workers to number of CPU’s +2

Intsalled the performance patches in pre-install mode.

Used the default GL periods for the migration.

Pre-created some of the long running indexes.

Worked on the discoverer upgrade from 10g to 11g.

03/11 – 12/11 TJX Corporation, MA

Project: Upgrade of EBS from 12.0.4 to 12.1.3 and database from 10.2.0.4 to 11.2.0.2

Role : Consultant Team Lead. Team size : 6 .

1.Prepared & executed the detailed steps involved in the Upgrade from12.0.4 to 12.1.3.

The architecture includes 2 Node RAC, 6 MT Linux servers and 2 PCP servers.

2.Resolved all the issues and documented the best practices for future upgrades.

3.Setup the plan management to provide stability of the sqls after the upgrade.

4.Set up the DR using Data Guard Redo Apply.

5.Integrated the Data Guard with RAC and managed using OEM 11g.

6.Installed the AMP 3.1 on the Grid and set up the auto application of DB & Application patches.

03/10 – 02/11 Stryker Pharma, Mahwah, NJ

Project: Migration of Oracle ERP & ASCP to IBM P6 Servers . Upgrade of Oracle ERP, ASCP from 11.5.10.2 to R12.1.1 and Integration With Demantra 7.3

Role : Consultant Team Lead. Team size : 6 . The off-shore DBA support is from Oracle corporation, India.

7.Prepared & executed the detailed steps involved in the Migration to P6 with 10G RAC.

The architecture includes 2 Node RAC, 16 MT Linux servers and 4 PCP servers.

8.Performed the Upgrade from 11.5.10.2 to R12. Resolved the issues and documented the best practices for future upgrades.

9.Helped in executing the tasks required for CSV.

10.Resolved the numerous performance and other issues that plagued the business in the migration to P6.

11.Setup the Grid Control 10.2.0.5 and installed the Applications Management Pack 3.0 for monitoring EBS applications

4/09 – 02/10 Welchs Incorporation, Concord, MA

OM Performance tuning & Demantra Integration With ASCP & EBS 11.5.10.2 & EBS 12.1.1

As a lead Apps DBA consultant I resolved numerous performance issues that plagued the business since go live in 2007. These issues have been growing over time and required both functional and technical knowledge to resolve. My contributions were often recognized by the business and the IT department.

Reduced viewing time from 8 Minutes to 15 Milliseconds (Viewing the Additional Order Information like Invoices/Credit Memos).

Setup the Real Application Testing & SPA in 11g database. The capture is running on the 10g databases and the replay of the transactions are setup to run on 11g . Grid control is upgraded to 10.2.0.5 to connect to both 10g and 11g databases.

Resolved the performance issues in RAC nodes by running the racdiag script and by using the gv$ views

Reduced Order entry time booking time from 25 minutes to 1 minute.

Setup Custom Responsibilities, Request Sets and other sysadmin setups

Lead on the pilot upgrade from 11i EBS to Release 12.1.1. Upgraded the database from 10.2.0.3 to 11g Release 1. Developed procedures and best practies to follow for all future upgrades

Tuned the wait events in the Order Management and Project Accounting modules.

Changing the CRD or the ship method in the Order Organizer reduced from 10 minutes to 30 seconds.

Reduced from 2 minutes to 10 milliseconds the navigation from the Summary tab to the lines tab in the Order Organizer form.

Tuned the sqls by using hints and re-writing the custom code.

Saved 10 hrs. of processing time and $250K for the company.

Leading the off-shore team of 6 DBA’s and provided them direction. QA’ed all work into Production.

Wrote procedures and deployed best practices for cloning systems. Cloned the both ERP and ASCP instances in the RAC Environment.

Completed 20 clones using Autoconfig and also using OAM

Successfully Cloned RAC instances using OAM Simple Clone/ Advanced Clone.

Installed the Oracle Application Server 10G and integrated with the Oracle E-Business Suite for the ASCP implementation .

Designed and lead the team for the De-coupling project: the separation of the ASCP Instance from the ERP, Integrate with Demantra .

Setup the DB links, Instance and plan partitions for the Planning Run and Collections Run on the ASCP Instance.

Resolved workflow issue of carriers not receiving emails for the tender requests.

Resolved the performance issues with the Cost Rollup update & AR lockbox Concurrent programs.

Reduced Cost rollup Update time from 70 minutes to 24 Minutes .

Reduced AR lockbox Concurrent Program run time from 12 minutes to 1 minute.

Resolved numerous performance issues with the Noetix reports.

Wrote procedures and performed the re-org of the tablespaces using OEM.

Tools used: Quest, AWRRPT & OEM

9/07 – 3/09 Vertex Pharmaceuticals, Cambridge, MA

Project: Oracle ERP & ASCP Applications 11i (11.5.10.2) and R12

Oracle Applications DBA

Accomplishments:

Worked on the Upgrade of Oracle Financials & ASCP from 11.5.10.2 to release 12

Define the processes for the operational improvement, document them and provide the help and guidance in the implementation.

Setup Custom Responsibilities, Request Sets and other sysadmin setups.

Migrated the Oracle APPS Instance 11.5.10.2/10G from Solaris 5.9 to Red Hat Linux 4.0.

Migrated the application from single node to multiple MTs with shared APPL_TOP.

Worked on the OPM implementation project and setup the audit trails for OPM modules.

Setup the Physical and Logical standby databases using Data Guard.

Set up the 2 node RAC on Linux clusters and NAS storage using OCFS2.

Setup the ASM instance for the storage management of the Instances

Used the Grid control for monitoring the Instances and configure the alerts and administration.

Worked on the upgrade from Discoverer version 4 to version 10G.

Resolved the issues with the Single Sign On, OID after applying the RUP6 patch.

Helped in the configuration of accounts in OID to synch with the Application accounts.

Setup the AWR snaps at higher level to compare the sql costs with the historical data.

Used the sql hints to tune the sqls and used the toughest hints like swap_input_joins.

Used the stored outlines for plan stability for the sqls.

Trouble-shooted the issues with RMAN backup and recovery.

Used the ASH to find out the hot blocks and eliminated the hot blocks.

Used the EMC VIsualSAN for the storage management of SAN.

Coordinating with the infrastructure team and the development team for PROD/project support issues.

Applied the ATG RUP6 and resolved the post issues of RUP6.

Coordinating for the monthly release of the PROD migrations/patches with the development team.

Troubleshooted the performance issues.

Environment: Database sizes 700GB on Sun Solaris 5.9 servers

4/06 – 8/07 Teva Pharmaceuticals, Horsham, PA

Project: Oracle ERP & ASCP Applications 11i (11.5.10.2)

Oracle Applications DBA

Accomplishments:

Lead the on-site and offshore DBA team

Coordinated with the Unix Admins, functional teams and developments for the OPM implementation

Worked on the upgrade from 11.5.9 to 11.5.10.2

Performed the cloning, patching & performance tuning for the upgrade project.

Installed, configured and managed Oracle Application Server 10G

Upgraded the discoverer from version 4 to version 10G

Resolved the issues of jvm crashes and garbage collection.

Implemented the native compilation for performance improvement

Tuned the custom pick release & order import program

Supported the conversion team bulk load item master by tuning the sqls

Implemented the audit trail setup

Fixed the issues of xml publisher reports

Tuned the init.ora parameters in 10g database.

Applied the ATG RUP 4 and fixed workflow issues.

Resolved the JVM and shared pool fragmentation issues

Reduced the number of httpd processes associated with each jvm

Installed the 11.5.10.2 vision instance for project support

Fixed the issue of excessive redo generation by qmon and also a performance hog.

Tools Used: quest qco

Environment: Database sizes 600GB on IBM AIX servers

4/03 – 3/06 EMC Corporation, Westborough, MA

Project: Oracle CRM & ERP Applications 11i (11.5.10)

Team Lead/Oracle Applications DBA

Accomplishments:

Lead the Performance team for the 11.5.10 upgrade project

Coordinated with the cross functional teams, Vendors, infrastructure team and developers for the implementation.

Working on the performance team to tune the EOQ sql queries

Using quest Central and FST console and Hotsos

Implemented the native compilation for performance improvement

Reviewed the FD & TD documents for performance review

Tuned the init.ora parameters in 10g database

Tuned the queries by using the sql profiling technique in 10g

Tuned the wait events and I/O distribution.

Installed, Configured and Managed Oracle Application Server 10G

Tuned the JVM sizes for performance improvement

Reduced the no of JVMs to improve performance.

Setting up the 1 TB database on 2 nodes RAC

Installed the 11.5.10 instance for project support with one DB tier

32 MT on linux x86 with Shared APPL_TOP and 4 Concurrent tiers with PCP

Migrated the Middle Tiers of 11.5.10 from Solaris to Linux.

Configured adding nodes in Linux.

Set up the configurator, batch validation, Archiving / Purging of Quotes.

Upgraded the databases from 9i to 10G release 2

24X7 worldwide support of EMC Applications and more than 200 databases of size 1 TB

Set up audit events in oracle 10g, 9i release2 databases.

Set up DR monitor for 10g, 9i and 8i databases.

Cloning the application instances using Rapid clone.

Setup of the workflow notification Mailer

Resolving the issues of istore, itime, CXP, MRP, Financials in 11i and SSP in 11.0.3

Supporting the windchill applications and interfaces to the 11.0.3

Supporting the shareplex for replication and reporting.

Tools Used: quest qco, live re-org, OEM tools, foglight

Environment: Database sizes over 1TB on sun E-25k servers, Dell 5600 Linux Servers

1/03 – 3/03 Advanced Marketing Services, San Diego, CA

Project: Oracle ERP Applications 11i (11.5.7 (Financials)

Oracle Applications DBA

Accomplishments:

Performance improvement of the Order Management and Update shipping.

Identified the bottlenecks as latch contention, I/O distribution, post maintenance steps in the patch application, Library cache management

And shared pool management, index table contention, Fragmentation of tables

And indexes and sql tuning.

Implemented the recommendations and monitored the performance improvement after this exercise is between 15-20%

Tools Used: quest space manager

Environment: Database sizes over 400Gb on HP unix 5.1

3/01 – 12/02 Fidelity Investments, Merrimack, NH

Project: Oracle ERP Applications 11i (11.5.6), (HRMS/Payroll, Financials)

Team Lead/Oracle Applications DBA

Accomplishments:

Upgraded Databases 8i (8.1.7.x) to 9i Release 2 (9.2.0.1.0)

Upgraded the databases from 7.3.2 to 8i (8.1.7.4.)

Upgraded the ERP/Financial Applications from 10.7 to 11i and 11 to 11i

Setup the cloning of Dev, QA instances from Time Finder BCVs

Lead member for the evaluation of the quest, precise and OEM tools.

Lead member defining the Security policies and implementation for the Database security and access.

Installed and configured Oracle HRMS, Payroll applications Multiple Instances on the same box.

Installed the Quarterly and Year end FLS upgrade for Oracle Financials

Set up of the CBO to update the staled stats.

Installed the stats pack for performance monitoring and tuning.

Setup of the 11.0 and 11i patches to run automatically thru Kintana including the vertex and hr global driver

Setup of the brio tool for reporting.

24X7 Production support for 160 HRMS databases when on Call

Setup of the Control M jobs for the monthly release DBA tasks

Installed Precise savant, interpoint

Tuning the data loads for custom applications

Setup of the concurrent manager alerts

Installed and configured Workflow, Apache Server, and OAS

Troubleshot day-to-day database and application problems

Tools Used: Brio reporting tool, quest and precise tools

Environment: Database sizes over 400Gb on Sun 10K machines

8/00 – 3/01 Saleslink Inc., Charlestown, MA

Project: Oracle ERP Applications 11 (11.0.3), (MRP, BOM, INV, OE, AP, INV, WIP, CRP, WORKFLOW,)

Oracle Applications DBA

DBA responsible for the installation of Oracle APPS 11.0.3, Applying patches, setting up of the Custom Applications and trouble shooting the errors in MRP, BOM, Financials, INV, WIP, Work Flow, CRP.

Accomplishments:

Configuring the Oracle Web admin Server, Oracle Application server, Jinitiator, Configuring the DAD, PL/SQL Agent.

Cloning the applications APPL_TOP’s and Database successfully

24X7 Production support for users in Boston and California

Setup of the export and attachment functionality

Setup of the Workflow

Installed and configured RMAN for backup of Prod and Non Prod servers

Setting up Cronjobs for auto monitoring of the Application processes.

Installed multiple Application Instances on the same box.

Installed the CRP module

Tuning the data loads for custom applications

Setup of the concurrent manager alerts

Environment : Oracle Applications 11.0.3, Database 8.0.5, HP unix 4.0f Web Server

10/99 – 8/00 Sun Micro Systems Inc, Chelmsford, MA

Project: Oracle Financials 10.7

Oracle Applications DBA

Part of a team member responsible for the database administration and development of Pricer Module in the E-commerce application Sunstore. Worked on the IVAR and Leasing Projects. Responsible for the trilogy Backbone Schema Changes and Report Object Changes and coordinating with trilogy.

Accomplishments:

Monitoring the pricing feeds from various sources and adding new price lists

Performed database maintenance tasks for pricing database

Developing Methods in Java for pricing changes in Quote.

Developing new stored procedures in PL/SQL

Setting up Cronjobs for auto loading of price lists.

Environment: Oracle Applications 11.0.3, Oracle 8.0.5, HTML, Solaris 5.6, Java, Trilogy 3.1, ATG Dynamo Webserver, Java Web Server

12/97 – 10/99 Fidelity Investments, Merrimack, NH

Project: Fixed Income Funds

Oracle/Sybase DBA

Worked in the FITech division for the COCOON setup and database administration of the various applications. Part of a team member responsible for the database administration and development of Bondview and Muniview Reptool ver 2.1. It is an analytical and reporting tool developed to assist Fixed Income fund managers. The tool can be used for fund portfolio based on quality, duration and sector of underlying securities.

Accomplishments:

Performed database maintenance tasks like purging databases, space management, rebuilding of indexes, database replication, server upgradation

Used csh, ksh and perl for developing scripts for database load and unload.

Used object oriented perl for CGI scripts

Used clearcase for Release Management

Environment : C++, Csh, Perl 5, CGI, Oracle 8.0.4, Sybase 11.5, Autosys, HTML, Solaris 5.5.1, Sun OS 4.1, Windows NT

8/96 – 11/97 P&O Nedlloyd Ltd., UK

Project: Control Layer System

Oracle DBA

Part of a team involved in the Database Administration of Control Layer System. The Control Layer System was designed to handle more than 1500 messages per day from Far East and other Asian locations.

Accomplishments:

Monitor the performance of the database in the test, user-trail and production environments.

SQL tuning, creating indexes, clusters, hash indexes when necessary.

Tuning memory usage by using hit ratios and also using cost-based optimizer (analyze command).

Defragmentation of segments, free extents, Measuring fragmentation, combining the free extents

Tuning physical and logical storage, replication of data using copy command, snapshots.

Maintenance of database security

Recovery of database from failures

Environment: Oracle DBA, Forms 4.5

1/96 – 7/96 DOW Chemicals, SWITZERLAND

Project: Fixed Income Funds

Oracle DBA

Accomplishments:

Lead a team responsible for the Enhancements and application support for the SUCCESS system.

Environment: DEC-ALPHA, RS6000, IBM 3090, IBM 3070, Oracle 7.0, VB 3.0 with ODBC, Formula One, First Impression, C, Quick pack tool Library, Q Pro, MS Access

10/88 – 12/95 National Informatics Centre, INDIA

Project: Immigration Control System

Project Lead

Accomplishments:

Handled the whole Immigration Control System’s Oracle database administration.

Lead member of a team for the Development of the Prison Management System.

As a Team leader involved in Study, Design, Normalization, Development and Installation of Financial Review Monitoring Information System (FIRMIS).

As a Database Administrator, assisted the UT division of the Ministry of Home Affairs in the personnel planning and management of the IAS and IPS officers of the UT cadre.

Environment: Oracle 6.0, SQL Forms 3.0, SQL Net 1.0, PRO*C 1.1, SQL Reporter 1.0, Power Builder 3.0, ORACLE 7.0 DBA, Intel P-5 machines

EDUCATION:

Andhra University, Visakhapatnam, INDIA

BS Computer Science, Graduated in 1985.

TRAINING:

TFA International, Boston, MA

Certified in More VRP performance tuning tool

Hotsos, Westborough, MA

Advanced Optimizer concepts and Performance Tuning

Oracle Corporation, San Francisco, CA

Oracle 10g training

Oracle Corporation, Waltham, MA

Oracle 9i Performance tuning

National Informatics Center, INDIA

Oracle DBA and Performance tuning

GUI Concepts, Visual Basic, and PowerBuilder

Project Management tools (MS-PROJECT)

Birla Horizons International, UK

ISO 9000 procedures with stress on testing

US Citizen

603-***-**** *****@********.**

Contact this candidate