SUMMARY:

• Currently working as Oracle Database Platform Admin. Manager for Confidential serving the clients in North America in various verticals and industries.
• Worked as Lead Oracle Apps DBA Principal Consultant for the implementation of the multi - million dollar Project INSPIRE for the local utilities company, MLGW (Memphis Light, Gas and Water) in Memphis, TN.
• Worked as Database Advisor in Global Data Architecture supporting production, testing and development systems with R12.1.3 EBS in multi-org architecture for FedEx services.
• Over 22 years of experience managing Oracle ERP Suite (Financials, supply chain and Manufacturing) system administration and Applications DBA role.
• Over 22 years of experience in data modeling, database administration, data warehousing, systems analysis, design, SDLC and client server computing in Oracle environment.
• Expert in upgrades of Oracle E-Business applications from 11i to the latest release R12.x
• Strong inclination towards Oracle tools and technology.
• Expert in advanced methodologies in Auto Patching and administration of Oracle EBS.
• Several functions of EBS Administration are automated thru shell scripts and self-executing alerts.
• Architected Oracle E-Business suite implementation including planning, design and implementation phases.
• Managed development team for Oracle financial module customizations.
• Led the Upgrade of several versions of Oracle E-Business suite applications over the years.
• Mentored in documenting Oracle EBS testing procedures for all the financial modules.
• Expert in troubleshooting and resolving the production issues after the major upgrades.
• Strong experience in managing day to day functional and technical issues of the corporate financials systems.
• Strong experience in leading to deploy corporate applications using Oracle RDBMS and Oracle application server technologies.
• Involved in several upgrades and migration of the legacy systems to the open systems using advanced methodologies.
• Architected and supported the processes for audit functions of the business financial systems according to SOX compliance.
• Strong knowledge in RDBMS technologies for various versions of Oracle RDBMS, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Data Pump, Export/Import, Partitioning, Oracle 9.x/10GR2/11G
• Performed several database upgrades in the past and well versed with the Oracle upgrade methodologies.
• Migrated the EBS/RDBMS to Enterprise Linux systems from Solaris/HPUX environments.
• Implemented SQL Outlines/SQL Profiles/STS over the various RDBMS versions. Utilized SPA to compare the SQL execution plans during the changes.
• Strong knowledge in Oracle Application utilities, patching technologies and configurations of oracle applications using cloning methodologies.
• Involved in developing and deploying backup methodologies for Oracle systems using RMAN.
• Implemented DR policies for Oracle applications for critical business continuity.
• Implemented Oracle CPU updates keeping Oracle applications baselined with the security alerts.
• Extensive experience in trouble-shooting the performance issues and strong knowledge in Oracle tuning methodologies such as SQL tuning, TKProf, Oracle Diagnostics.
• Strong knowledge in analyzing AWR/ADDM reports and dba hist views for performance/measure of workload in the database.
• Automated custom alerts monitoring Oracle RDBMS processes and resources.
• Strong knowledge in Shell programming (Korn) in Solaris/HPUX/Linux environment
• Possess working knowledge in SUN Solaris/Veritas administration.
• Possess working knowledge in EMC-BCV technology for storage operations.
• Functioned as backup BASIS admin for SAP HR applications.
• Implemented POC installs/configurations for OBIEE, RAC, OEM Grid, Oracle Fusion Middleware/SOA and Integrated SOA Gateway (ISG) for E-Business suite.

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Windows NT, Veritas

Hardware: SUN Solaris, HPUX, AIX, Oracle Linux

Software: OEM, Oracle Weblogic, Oracle Developer suite, Oracle Designer 2000, Oracle Application WebServer, Oracle Access Manager

ERP/Applications: Oracle E-Business Suite 12.x/11.5.x, Hyperion, Primavera P6 EPPM, SAP, RedPrairie, Demantra

RDBMS: Oracle 7.x/8.x/9i/10G/11G/12C, ASM/RAC, MS SQL Server

Languages: SQL, PL/SQL, C, Basic, XML, Korn Shell, Python

WORK EXPERIENCE:

Confidential

Database Admin Manager

• Responsible for key activities related to the Lift & Shift, preparing the databases for next generation cloud technologies.
• Supported action items and knowledge transfer between technical team and client counterparts
• Updates / created documentation for technical transition
• Technical knowledge of servers and applications / database: Linux, Oracle OBIEE, BIA, SSO, RMAN, SOA, OEM, PRISM, EBS, Sys admin for comm / infrastructure
• Responsible for current Oracle architecture and provide recommendations on migration and syncing options

Confidential

Lead Oracle EBS DBA-Oracle EBS R12.2 Technical Upgrade

• Successfully upgraded Oracle EBS applications from Oracle EBS 11.5.10.2 to R12.2.5.
• The customer's EBS eco system had Demantra application/APS, Markview, Kofax, GRC, SOA, Revpro, Sabrix, OBIEE applications.
• Successfully upgraded Oracle APS instance from Oracle EBS 11.5.10.2 to R12.2.5
• Succesfully upgraded Demantra applications from release 7.3.1.4 to 12.2.5.1
• Successfully upgraded Markview application to integrate with Oracle EBS 12.2.5
• Successfully upgraded GRC application to integrate with Oracle EBS 12.2.5
• Installed and upgraded Sabrix application to integrate with Oracle EBS 12.2.5
• Implemented and Installed Dell STAT tool for the code migrations in Oracle EBS 12.2.5 instances.
• Responsible for planning, executing and delivering the pre-cutover, cutover and post-cutover activities for the entire upgrade.
• Mentored and managed offshore DBA team for the upgrade process of Oracle EBS 12.2.x
• Coached the customer's dba team and offshore dba team with the new patching procedures of Oracle EBS 12.2.x
• Designed application development architecture to accommodate the new versioning of the Oracle EBS 12.2.5

Confidential

Technical Architect I-Lead Oracle

• Successfully upgraded to EBS R12.2.4 from R12.1.3
• Demonstrated extensive knowledge of Oracle Databases & EBS systems
• Executed clone, patch & install of Oracle Apps R12.2 environments
• Good understanding of the Oracle database, related utilities and tools
• A good understanding of the underlying operating system
• Performed both Oracle and operating system performance tuning and monitoring
• Executed RMAN backup and recovery scenarios
• Executed in code migration, change management and data management through the various stages of the development life cycle
• Good communication skills with management, development teams, vendors and systems administrators

Confidential

Lead-Data warehouse modeling

• Successfully mitigated performance issues for data analytics queries from Tableau to Oracle systems.
• The response times for data analytics operations were reduced more than the business users’ expectations.
• Successfully implemented Data modeling techniques such as de-normalization and normalization to enhance the systems performance.

Confidential

Oracle Infrastructure Architect

• Executed excellent hands on Oracle database skills and provided the performance benchmarking
• Successfully understood the existing solution/ data access layer in place and performance tune/optimize the database and drive/identify any networking latency issues as well.
• Customer had a huge MDM (master data management) system which was highly critical providing the information about the customers and medical technicians for the world. Customer's Confidential system had long running jobs causing them to halt the operations of the system. The data had been collected from various upstream systems in the different regions of the world. The performance of the system's jobs was major concern for the continued success of the system's operations.
• Successfully collected all the data points of the process flow and identified the bottlenecks in the system's eco-system. The different layers of the system, i.e. storage, hardware, server os, database and application's bottlenecks were identified and provided the best methods and recommendations for the system. The performance of the system was assessed and provided the analysis with the recommendations and the best methods for the continued successful operations of the system.

Confidential

Architect RedPrairie Systems, Oracle RDBMS, MS SQL Server

• Successfully migrated Oracle RDBMS systems to MS SQL Server databases using database conversion utility.
• Implemented scripts for backup and recovery procedures for Oracle RDBMS systems for high availability solutions.

Confidential, Memphis, TN

Sr.Oracle EBS DBA-Principal Consultant

• Developed a platform migration plan to migrate the existing Oracle HRMS ERP (EBS R12.1.3) from the HPUX environment to Oracle Linux environment.
• Responsible for all the Apps DBA tasks including Cloning, Patching, Performance tuning, trouble-shooting the issues and configurations for all the INSPIRE instances.
• Developed and responsible for the roadmap for preparing the existing Oracle HR & Payroll system to implement the additional modules scoped for the Project INSPIRE.
• Installed Oracle Primavera P6 EPPM R8.3.2 and configured the LDAP authentication with the Enterprise AD.
• Responsible for delivering the CRP instances meeting the project’s requirements and providing the Functional SysAdmin support for all the setups and profile changes.
• Responsible for supporting multiple DEV & CRP instances for the implementation of all the functional modules.
• Responsible for the patch management policies for all the EBS instances for the Project INSPIRE.
• Responsible for managing and supporting all the technical requirements including the profile options management to meet the business requirements for the Project INSPIRE.
• Developed the standard policies for the deployment of enterprise JRE supporting all the applications in the Enterprise eco-system.
• Responsible for up-taking all the instances with all the patches/patchsets and managing migration of the patches thru all the instances.
• Upgraded the EBS instance’s RDBMS to 11GR2 from 10GR2.

Confidential, Collierville, TN

DBA Advisor

• Upgraded the EBS to Release 12.1.3 from the version R12.1.2.
• Supported the conversion rollouts of global regions from legacy system OCEAN into Oracle EBS.
• Implemented advanced methods troubleshooting the performance issues in parallel dml operations.
• Developed a utility in shell programming to identify & display the top Oracle sessions from the OS in HPUX.
• Developed custom programs to automate iterative post-cloning steps.
• Developed programs to automate and expedite the data fix scripts provided by Oracle Support.
• Extensively used OEM to troubleshoot SQL by implementing SQL Profiles/SQL Performance Analyzer.
• Involved in migrating the EBS-HPUX to Linux-RHEL platform.
• Involved in drafting the new architecture for Linux environment with high availability/maximum availability considerations.
• Tuned the JVMs for OC4J components in R12 architecture.
• Lead the DBA team for supporting the production and lower level instances.
• Developed custom scripts for pro-active and re-active monitoring of the system.
• Developed some Python programs to migrate the RMAN backup sets to speed up the clones.
• Implemented cloning methodology and procedures for refreshes.
• Automated migration of the code drivers using subversion.
• Implemented several monitoring scripts/alerts for better user experience in the EBS.
• Implemented RMAN for the backup/recovery operations.
• Involved in successful implementation of Migration project from HPUX-nonRAC to Linux-RAC based systems including the database upgrade/character set upgrade for the data. This is a huge project involving multiple components and multiple stakeholders. The migration project includes building/migrating of L0/L1/L2/L3/L4/L5/L6/Gold and Production. The foot print for EBS installation is about 80 servers with high availability and redundancy.

Confidential, Memphis, TN

Sr. Oracle Applications DBA

• Upgraded the EBS to Release 12.1.3 from the version 11.5.10.2.
• Performed several Oracle applications upgrades for Oracle ERP systems (starting from 10.7 SC, 11.0.1, 11.0.x, 11.5.8, 11.5.10.2, R12.0.6, R12.1.3) over the period successfully.
• Performed several RDBMS upgrades for Oracle database servers over the period successfully.
• Implemented OEM for database operations.
• Implemented Oracle Alerts, WebADI, Oracle Workflow, Oracle XML Publisher/BI Publisher for the Application processing.
• Involved in all the financials and manufacturing modules implementation in Oracle EBS Application.
• Implemented Oracle Applications Manager and Oracle Diagnostics for troubleshooting any data issues in Oracle E-Business Suite applications.
• Currently involved in implementation of Hyperion, GetPaid applications.
• Implemented Oracle Application Server, Oracle Web Server and Apache web server for intranet applications.
• Implemented SUN JRE for deploying Oracle Applications in corporate intranet across all the locations.
• Responsible for SOX compliance and auditing of all the enterprise databases and Oracle E-Business suite.
• Responsible for administering enterprise users for Oracle Metalink support.
• Implemented and installed Oracle RDBMS in LINUX environment in IFL(Mainframe-zVM)
• Implemented several fast cloning of databases and Oracle E-Business suite applications using RapidClone methodologies and BCV disk operations.
• Involved in implementing Hyperion 9.3 with various components and supported the Essbase database connecting to Oracle RDBMS server (10GR2) for the metadata storage.

Confidential, Memphis, TN

Software Engineer

• Involved in an application to centralize the pricing and quotation system for all the products and distributors in our corporation. Responsibilities include database design, database development, on going updates from mainframe through MQ interface to Oracle, coordinating development of user interfaces for both web and client-server environments. Visigenic ORB was used for distributed object computing.
• Maintained and trained users for a data warehousing application, Sales Reporting System which was developed using Oracle tools only. The application was designed and developed using Oracle Designer 2000 and Oracle Developer 2000. This application supported both OLTP and OLAP. Data was extracted from legacy systems and reports are generated for decision supporting. Maintenance included customizing screens, fixing reports, writing stored packages to support the system. This also included implementing the system and training the users as well. Views and roles were created encapsulating security.
• Designed and developed a relational database engine, DMI known as Distributor Manufacturer Integration. The application provided an intermediate communication layer between distributors and different manufacturers. The system kept track of all the purchase orders, suggested orders, shipments, daily sales, invoices and claims. The application provided the vendor to manage the customer’s inventory also known as Vendor Managed Inventory. The whole system was implemented in Oracle environment. The engine also supported EDI transactions. Security was implemented using roles, views and public synonyms. The design and modeling was implemented using Oracle Designer 2000 tools. Screens were generated using Forms generator and further customized using Developer 2000. Also responsible for the repository administration.
• Developed an application called Remote Report Requester which requests the report server remotely and stacks them in the queue. A daemon was created in Visual Basic to process the queue and sends the report outputs back to the user. This was developed using VB 3.0, MS Access, Oracle Reports, and Crystal Reports. MAPI controls were extensively used for communications.