Oracle Management

Gopinath Tammana

Page *

PROFESSIONAL SUMMARY

Proven organization leader with a extensive technical and functional background in Information Technology and with talent for motivating and developing teams creating a high performance culture focused on the successful achievement of project goals.

20 plus years of extensive experience in Information Technology. Expertise on multiple platforms as a Developer, Project Lead, Technical Lead, Database Administrator, Team Lead on Oracle Technologies including Oracle Databases, E-Business Suite Applications Technology, Obi, and Service Oriented Architecture (SOA Suite) Fusion Middleware systems

A Masters Degree in MBA along with a Certification in "Six Sigma Black Belt Professional" ( SSBBP ). Thorough understanding of DMAIC principles to help organize and complete projects successfully. Well aware of team dynamics and assign team member roles and responsibilities.

Certified "Project Management Qualified" (PMQ).

Skilled in team building, leading kaizen events, and developing and implementing quality systems. Consistently focus on improving quality by minimizing downtimes of systems and improving MTTR. (Mean Time To Recover).

Proficient in an assortment of technologies, including Oracle Database 9i/10g/11g, RAC Database, Oracle Applications 10.7, 11i, Release 12, Oracle Application Server, Bpel, Oracle Dataguard, Oracle Forms and Report Server and Apache Web Server on multi- node architecture, Third party shipping tools configuration, Oracle Golden Gate Replication, Oracle Transportation Management (OTM), Identity Applications Management(IAM), Single-Sign on (SSO), Service Oriented Architecture (SOA) suite, Cloning tools such as Delphix.

Expertise in multiple operating systems like HP, LINUX, AIX, SOLARIS, WINDOWS.

Excellent in analyzing the systems and cost reduction activities of consolidating systems to help reduce licensing costs on servers.

Expertise on Identifying and analyzing the poor performing systems and focus on performance tuning activities by coordinating with multiple teams.

Expertise in Implementing and Configuring Database cloning tools. Recently implemented huge number of databases cloning and scripted all pre and post refresh steps which helped reduce a huge number of man hours spent on the cloning.

Expertise in all software life cycle phases. Start to end involvement in Analysis, Planning, Implementing, and Architecting upgrades of Oracle Applications, Oracle Databases or Integration of third party tools/software.

Configured several shell scripts to help ease in the ERP Cloning Steps (One Touch Cloning, No Touch Cloning) which reduced the database and apps cloning time considerably.

Well aware of the architecture and the dataflow and modules of the Oracle applications. Provided analysis, evaluations, recommendations, production implementation strategies, preparation of specification documents, data conversion design, reports analysis and end user training.

303-***-**** ********@*****.***

Gopinath Tammana

Page 2

Team Lead for the Group of Offshore production support DBA's which consists of Core, Apps, Teradata and Sql Server DBA’s. I mentor, monitor, help transition the knowledge of tasks, issues, projects which in turn helps them effectively support during after hours.

Excellent presentation and interpersonal skills. Highly organized with proven leadership, analytical and troubleshooting abilities. Ability to communicate with all levels of management, support teams, Vendors, Internal and External customers.

Dealt with large multi-terabyte high volume transactional database environments and Developed and tested storage strategies and disaster-recovery plan for company’s large operational databases, delivering solution that guaranteed recovery performance and high availability.

Proficiency in Analyzing the Application Patches, Merging the Patches, applying the patches and observing/working the performance issues with patch apply process.

Reduced the Patch Apply process exceptionally by implementing the Shared Appl Top which helps in applying the patch only one time across multiple app servers. Worked with F5 Team on Load balancing between the App Servers.

Outstanding Troubleshooting Skills. Effectively debug and resolves the production issues related to the concurrent managers, cloning issues, Apache Issues, Patching Issues, Auto config and workflow mailer issues with app and Issues like data block corruption.

Experience in Configuration and Supporting the I-recruitment Applications with DMZ Architecture, Configuring SSL, Configuring Parallel Concurrent Processing and maintaining databases under VCS cluster system with CPU load (GWLM) management.

Strong programming skills in development of inbound, outbound interfaces, validations and data conversions & mapping, database triggers, stored procedures and oracle alerts. Extensively worked with SQL*plus, Plsql and in full suite of Oracle AOL architecture. Gopinath Tammana

Page 3

ProBuild Holdings, Inc, Denver, Co: Mar 2013 - Till Date Sr. Apps DBA

ProBuild is the nation's largest supplier of building materials for home building, professional & contract builders. Working in Probuild as a Sr. Apps DBA with main focus on managing RAC Databases, EBS R12 applications, Performance Tuning and Integrating Delphix.

Implemented Cross Platform Migration Using transportable tablespaces (TTS) for multiple databases including ERP Databases. Faced several challenges during the migration from AIX TO LINUX Operating systems and able to resolve them in timely manner to deliver the databases on time. This migration reduced a huge licensing money which used to spent on AIX servers.

Scripted the ebs pre and post refresh scripts and automated the entire cloning process with NO TOUCH cloning process. This helped in reducing huge number of man hours which used to take prior to automation.

Prowalk is one of the huge Enterprise projects that helps the Field Representatives by reducing Takeoff capture errors, increasing efficiency for sales representatives and manufacturing Previously ProWalk team used to spend a lot of time on manual loading the data into temp tables during the web delivery ProWalk schema refreshes. Worked with them on automating the loads with use of external tables. Created the multiple external load scripts and showed the ProWalk development team on steps for creating the external tables. This overall effort reduced a huge manual load timing during every refresh. This also helped to refresh environments as many times as they need because of simplification of tasks.

Addressed several Production Priorities immediately and deployed fixes to the problem in a quick fashion.

Identified redundancies in databases and applications and consolidated the databases and application there by reducing a huge licensing costs

Identified several performance issues hogging the system and worked on troubleshooting efforts with functional/Development teams and followed up to move the changes to production. Below are some of the changes that helped smooth functioning of production:

Streamlined the Gather Schema Statistics of Several EBS modules.

Identified several long running jobs under RUNBOOK process and coordinated with functional, development teams and suggested the fixes. This overall effort helped reducing RUNBOOK time from 5.30 hrs. to 3.30 hrs.

Observed several blocking sessions because of custom code in the system and created scripts to automate the cleanup of locks to help avoid manual termination.

Identified the root cause for the FND queues locking. Implemented the solution and configured the PCP (parallel concurrent processing) setup correctly to avoid locks.

Observed frequent alerts of file system usage. This is because the logs are not cleaned from long time. Created and automated scripts to do the cleanup regularly.

Automated the runbook hold process during the monthly maintenance. Gopinath Tammana

Page 4

Identified the issue with incremental backup taking longer time and implemented Rman Block Change Tracking which reduced incremental backup time considerably.

Identified the drawback of the previous cloning methods and trying to improve cloning timings which help deliver cloned instances to internal customers in a quicker way.

Identified the drawback in the monthly maintenance procedures and came up with new scripts which helped to reduce human intervention and big downtimes on production systems.

Implementing AIX Large Pages and Jumbo Frames to take advantage of memory and network speed.

Support the Enterprise EBS and Non EBS(Databases (11g, 10g ) and applications.

Planning on upgrading the current OEM to 12C, Upgrade EBS to 11g and Convert to ASM.

Dish Network LLC, Englewood-CO: Jan 2005 – Mar 2013 Staff DBA

My Experience in ERP Applications with Programming and Development both functional/technical knowledge helped me to progress my career into Applications DBA at Dish Network. Worked as a Staff ERP Applications DBA with main focus on ERP Applications and related databases. Responsibilities include Support and Maintenance of production and non production instances that includes Patching, cloning, Upgrades, implementing new projects, recommendations of new products etc. Environment:

Sun Solaris, HP Itanium VCS for Cluster, HP Pa Risc

Oracle Applications 11.5.10, Release 12.1.3

Database Versions 10.2.04, 11g

Lead ERP Applications DBA. Implement, architect, plan Projects and effectively delegate/Share the tasks/Knowledge with the team accordingly.

Manage & Lead group of offshore production support DBA team. I mentor, monitor Helps and shares with them knowledge on the tasks/projects we do onsite for their effective support during after hours.

On call Production Support all Databases on rotation basis among the team. Major Accomplishments at Dish:

E-Business Suite production Database was on a HP PA Risk Superdome with no failover server. This caused some outages during server crash etc. Architected the plan and Implemented ERP Split Configuration in 11.5.10 Version and moved the Database to Itanium by retaining Admin/concurrent/app Nodes on HP PA Risc servers. This helped for the 24/7 availability of Database.

Gopinath Tammana

Page 5

Implemented the SSL (Secure Socket Layer) on ERP Applications to move from http to https. As part of these changes also implementing the Forms Servlet Model.

Currently planning on implementing the PCP (Parallel Concurrent Processing).

Recommended the Enterprise Team with the Extended Support Patches for ERP which includes several Database Patches + Upgrade from 10.2.0.3 to 10.2.04, Application Patches like HR RUP5, ATG 6, Forms6i Patchset 19 and Jinitiator to Java Upgrade and implemented them Successfully which helped save a huge amount of licensing for extended support.

Good at research on patches for any bugs and will proactively research the “Known Issues” in metalink and will try to get the Patches for fixing the known issues which results in lowering the production issues.

Faced Several Challenges with Jinitiator to Java 1.6.17 Upgrades with third party applications and worked with several custom applications teams to get the Changes successfully Implemented.

Worked on the ERP Security Vulnerability Issues and Implemented Several Cumulative Security Patches to be at current.

Implemented the “Inbound SSL” Configuration with Workflow for the issues of Passwords Transmitted in Clear Text by installing Cert in Database server as well as Application Server.

Fixed the Issues with the Performance with RMAN Incremental Backup which is taking similar time as Full backup. Implemented the BCT (Block Change Tracking) which reduced the incremental backup times considerably.

Moved the 8 Terabyte of a custom application Database read only Schema into a Different Database by using TTS (Transportable Tablespace Method).

During the Split of Echostar into 2 Companies Dish/Echostar in 2007, implemented a separate 11.5.10 Instance and a 10.2.0.4 Database with up to date Patch Levels and helped the Dev Team in migrating the setup data.

Contributed to the Enterprise Project of Moving the Databases from HP Pa Risc to Itanium Super Dome (UNIX Consolidation). Worked on migrating several of ERP/non ERP Databases to Itanium and applied the latest PSU Patch Bundles.

Upgraded the Database to 9i to 10g and Applications from 11.5.9 to 11.5.10 CU 2.

Cloned the current 6 TB ERP Instance and upgraded to Release12 in Dev Instance.

Upgraded the Discoverer Reporting to 10.1.2 Version.

Implemented the Oracle Golden Gate replication which uses the database archive logs for further use by Nateeza application for reports.

Implemented / supporting the Logical Apps Application (Configuration controls Governor-CCG) with ERP, which tracks the Changes in the ERP Apps for sox/audit purposes.

Support the Frequent clone of dev/test Instances after every patch bundles to production. Worked on the scripts to help reduce a numerous steps in ERP Cloning and automated several steps. Worked with Dev Team and built procedures to scramble the sensitive information in dev/test instances.

Implemented autoconfig templates for the ERP Customizations which saves considerable time in re implementing the customizations after every autoconfig. Gopinath Tammana

Page 6

Coordinated the Resume Mirror Changes with I- recruitment Application. This helps in parsing the resume and uploads the results to the tables for easy validation/search by HR Team.

Maintain the Enterprise oracle I-learning applications on Solaris operating system. Planning to move to OLM (Oracle Learning Management) with EBS Release 12.

Configured several shell scripts to alert the Team and Apps Support Team on the Blockers, blind query forms sessions, inactive forms sessions etc.

Contributed for Sox/Audit compliance by developing scripts to automatically lock and expire the individual username in multiple databases as soon as HR Record shows as employee being terminated.

Projects in Progress:

Implemented Database upgrade from 10.2.0.4 to 11.2.2 & Implementing OATM (Oracle Applications Table space Model) along with db upgrade to facilitate for Release12 Architecture..

Currently undergoing phases of ERP Applications Release12 Upgrade and moving away from Split Config Architecture to Entirely HpUx Itanium for both database and applications.

Currently we are on a Standalone Oracle I-Learning Applications on Solaris platform and having Several Performance issues with Out Dated Version of 5.1 and OS. Recommended the Management to move the Stand Alone ILEARNING Apps in to Oracle ERP Applications by using the OLM ( Oracle Learning Management) with R12.

Planning to move the Current I-RECRUITMENT application to the new instance by separating it from the current ERP transactional Database. Dish Network LLC. Englewood-CO Feb’2000 – Mar’ 2005 Staff Application Analyst/Developer

Worked at Dish as an Oracle Applications Developer from Feb 2000. Attained multiple promotions during the service. Excellent troubleshooting and development skills.

Worked on all phases of design, development, and implementation during several Oracle Applications Upgrades 10.7 to 11.0.3 to 11i. Customized several programs/processes, reports to withstand as per the new upgrades oracle apps versions.

Re-engineered the Custom shipping system from multiple databases in 11.03 to a single database in 11i which helped in increasing the performance of the shipping system which reduced maintenance in UNIX, applications and pc level changes.

Re-Engineered the Custom Argo Shipping System from a standalone NT Forms to move to the ERP Based module. Re implemented the changes on several forms on the ERP Forms Templates and Re coded the open interfaces for printing labels etc.

Installed/configured the Scanner Based Shipping System for the huge dealer orders by using the third party vendor BPA. Developed the validation of pallet/serial numbers for shipping.

Gopinath Tammana

Page 7

Fixed and Developed Several Automated concurrent programs to help ease in the Serial control Inventory move from a Non Serial Enabled Warehouses to Serial Control Warehouses.

Developed an automated process of receiving/shipping/closing sales orders for after the fact receivers that are installed in customer homes via CSG.

Performed several development, enhancements related to the Oracle Manufacturing/Distribution modules with emphasis on the Order Management, Inventory and Shipping (Argo, Gemini).

Performed Lead Roles in Several Projects. Interfaced closely with internal customers on identifying and providing systems solutions for the business. Partnered with business leaders to evaluate user needs, technical alternatives, design options and achieve stated objectives. Responsibilities included scope requirements, system design and development and user support.

Tuned several application custom programs for better performance for faster results. Identified several programs which are causing huge system resources across several modules and intimated to several team managers for assigning resources for the fix of programs.

OurHouse Inc, IL Sep’99 - Feb’ 2000

Sr. Consultant

The main objective of the Project is Strong E-Business. Which led to implementation of Oracle Financial Applications and integrating Web front? Worked on Interfaces of Oracle Order Management. The purpose of the order management interface is to process the online OurHouse orders via oracle order entry system. The fulfilled order information is used to bill the customers and can be viewed as and when required. Worked on Interfaces: Order Entry

Net Order Change Detail Interface:

This interface creates the flat file and transfers the details of the Net orders to Ace system through a flat file. The purpose of this process is to Transfer summary of Sales orders and RMA's data from oracle to the Ace system According to the entity mapping specifications.

Pick Release/Pick Slip

This interface creates the flat file and transfers the details of the items which are pick release released to Ace system through flat file. The purpose of this process is to transfer summary of Sales Orders data from oracle to the Ace system. According to entity mapping specifications.

Reports: Order Entry/Payables/Receivables

Product Profitability of Item SKU Report: This report shows the item cost, net revenue and margin by item stock. The cost portion of this data resides in payables and the revenue portion resides in order entry module.

Gopinath Tammana

Page 8

Backorder Statistical Report: This report will print the list of backlog orders. This report will be used by CSR to determine if any action is required on the backlogged orders if they are in this state for a long time.

Gopinath Tammana

Page 9

Dupont Photomask Inc., CA Feb’99 - Aug’ 1999

Technical Consultant.

As a member of the implementation team, was responsible for the customization, designing and development of new Custom Reports in Oracle Applications. Responsibilities Involved:

Interacting with users for understanding the business needs.

Designing and Development of new Custom Reports in modules like Account Receivables, Order Entry, Work in Process, Inventory.

Designing and Development of Reports in Custom Modules like Corrective Action system (CAS), Lithography (LITHO), Quality, Inspection.

Some of the Reports Developed like CAS volume report, Material Reject Analysis Report, Transactional Layers by Tier Report, Late Plate Parito, Customer Hold Report, Corrective action Quetime report, Corrective action Quality Report, Inspection volume by Number of Plates report etc.

Involved in Testing and conversions. Testing includes creation and execution of test scripts and test cases.

Registered the developed and modified reports as new concurrent programs in corresponding custom applications for standard report submission. Biological E. Ltd., India. Jan'98 – Dec '1998

Functional/Technical Consultant

A project on the implementation of Oracle financials for Biological E.Ltd., an established Pharmaceutical company. The project included the design and development of Chart of Accounts including Accounting Flex fields, action of Security and Cross validation rules and set of books. The structure of accounting flex fields depends upon the present and future requirements of an organization. Hence a detailed study of organization structure and requirement of company needs are being undertaken before designing the chart of accounts.

Environment: Oracle Applications 10.7, Modules: General Ledger Account Payables, Accounts Receivables, Order Entry, AOL, System Administration; Oracle*Forms 4.5/2.3, SQL* Loader, Oracle*Reports2.5/2.0. Gopinath Tammana

Page 10

Eastwin Labs, India March'95 - Oct'97

Sr. Programmer/Analyst

This project was used to automate many of the in-house activities like management of inventory, transaction processing, orders, billing and various management confirmation reports in addition to maintaining the database of suppliers/Vendors of item and customers. The master maintenance module deals with the maintenance of item master, supplier master, customer master and supplier-item master. Transaction module deals with the placing of purchase orders, sales orders, billing and on line transaction processing. The reports generated are MRP reports, supplier details, customer details and all purchase order reports, sales order reports between a given period of time.

Designed and developed Material Requirement and Planning. Environment: Oracle 7.x, Forms 4.5, Reports 2.5, PL/SQL, SQL*Loader TECHNOLOGY STACK

Operating Systems :Aix, Linux, Sun Solaris, HP UNIX, Windows Databases : Oracle 11G / 10G / 9i / 8.0.6 / 7x

Languages : C, Unix Shell, SQL plus, PL/SQL and Pro*C, Html, Xml. Oracle E-Business Suite :

Oracle Apps Release 12

Oracle Apps 11i (11.5.10)

Oracle Apps 11.0.2, 11.0.3

Oracle Apps 10.6, Oracle 10.7 (CHAR, NCA)

Oracle I-Recruitment

Oracle I-Learning

Oracle SOA Suite ( 10g,11g)

Tools :

OAM (Oracle Applications Manager),

OEM (Oracle Enterprise Manager), Web ADI,

Discoverer 10g, 4i, Oracle ADI utility,

OWM ( Oracle Wallet Manager )

EDI, Golden Gate Replication, Noetix Reporting

Oracle Development Tools :

Oracle Developer, plsql, Oracle Forms 6i, 4.5, 2.3.

Oracle Reports 6i,2.5, 2.0, SQL* Loader,

WorkFlow Builder, Toad, SQL Developer

Education :

(MBA)Master's degree in Business Administration.

PGDCA -Post Graduate Diploma in Computers

Oracle Applications Certification

Bachelor's degree in Commerce.

Gopinath Tammana

Page 11

(SSBBP) Six Sigma Black Belt Professional Certification

(PMQ) Project Management Qualified Certification Status : USA Citizen

Gopinath Tammana

12215, S Grass River Trail

Parker, CO 80134

Cell: 303-***-****

Contact this candidate