Synopsis:

• Over 10 years of IT experience in Oracle technologies, experienced in Design, analysis, implementation, installation, configuration and administration support for Oracle technologies like OBIEE, EBS, Databases, Exadata, Exalytics, Essbase.
• Expertise in Installation and Configuration of Oracle EBS Applications 11i, R12.1.3, R12.2, configured and implemented PCP, multiple nodes, external tier DMZ node.
• Involved in Design, Architect and Implementation of OBIEE EBS on Exadata and Exalytics infrastructure, installed and configured EBS R12.1.3 and OBIEE 11g, Oracle Database 11g.
• Experience of 2 end to end Financial ERP project using EBS OBIEE, installation, configuration and maintenance of EBS Data Warehouse, Business Intelligence Applications, and production support.
• Expert in Oracle Database Installation, upgrades, patching, cloning of Oracle Databases 10g and 11g , RMAN recovery from backup, ASM disk management.
• Oracle EBS Installation of R12.1.3 12.2, Cloning, Patching, Performance tuning, Maintenance and administration.
• Integrated and implemented OBIEE external LDAP, integrated with SSO - Single Sign On with various external Oracle tools like - OID/OAM, OHS, and ODSEE.
• Integrated EBS SSO -Single Sign On using OID Oracle Internet Directory, OAM.
• Experience in working with ASM for RAC and non-RAC setups, installing and configuration single node, RAC and DR database.
• Experience with design and implementation of database backup and recovery procedures using RMAN and Grid control. Worked with storage administrators for Storage level snapshot backups etc.
• Troubleshooting Oracle Data warehouse performance issues arising due to full incremental ETL loads and ensuring the ETL jobs completes with in timeline.
• Configuration of EBS and OBIEE production environment on Exadata machine, building infiband connections with application servers on Exalytics machines.
• Worked extensively on Oracle EBS Application performance tuning of Concurrent managers, concurrent requests, scheduling of concurrent jobs, JVM tuning, request level memory allocation.
• Administering Oracle EBS 11i and R12 Instances using AD utilities: AD Admin, AD-Patch, AD Controller, AD Relink, AD Merge Patch, AD Splicer, AD Configuration, AD File Identification, AD Timing Report, AD LICMGR, AD Clone.
• Experience in Installation, Configuration, and administration of Oracle OBIEE, Web Logic Server, Performance Tuning of Web Logic, managed servers and OBIEE services, issue resolution.
• Expertise in Cache Management, Performance tuning at OBIEE report level and database level.
• Strong experience debug, deploy, developing OBIEE Repository RPD at three layers Physical Layer, Business Model Presentation Layer .
• Expert in Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access/query/report privileges , configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Installation, configuration and admin support for OBIEE 11g/10g, expertise in providing end-to-end business intelligence solutions using OBIEE.
• Experience in Administration of Oracle Web logic Application Server, maintenance and deployments.
• Integration with EBS, ODI/ETL and OBIEE for financial reporting also implemented and supported FAH, GL, AP, AR, Projects and HR functional areas.
• Expert in Infrastructure and Implementation specialist for support on Oracle technologies on Exadata systems for databases and Exalytics in memory systems for OBIEE applications.
• Oracle 11g, 10g database Installation, Cloning, Patching, Performance tuning and Maintenance on RHEL Linux, Oracle Enterprise Linux 5.5 environments.
• Installation, Maintenance and Upgrades of EBS 11.5.10.2 to R12.1.1 and R12.2 and database upgrades of 10.2.0.3 to 11.2.0.3.
• Installed and configured Oracle EBS Application stack on Single node, Multi node with RAC and Concurrent Manager configuring PCP.
• Administering Oracle 11i and R12 Instances using AD utilities: AD Admin, AD-Patch, Auto-Upgrade, AD Controller, AD Relink, AD Merge Patch, AD Splicer, AD Configuration, AD File Identification, AD Timing Report, AD LICMGR, AD Clone.
• Expert in patching OBIEE, EBS and Oracle databases, WebLogic patches, OPatch for BI APPs patching, OPatch for database patching, AD-Patch for EBS patching.
• Good in shell scripting, HP-Unix and RHEL Linux environments.
• Write and update Technical Notes and Documentation for future analysis and standardization.
• Experience Supporting 24 7 Production computing environments. Experience providing on-call and weekend support.
• Highly motivated team player with immense ability to grasp new concepts and apply them.

Technical Skills:

• BI Applications ERP: OBIEE 11g, Oracle EBS R12.2, EBS 12.1.3, Oracle EBS 11i, Oracle DB 11g
• Engineering systems: Exadata machine, Exalytics machine, Exalogic VM's, Infiband connections.
• Oracle Tools: ODI ETL, OHS, Essbase 11.1.1, Exalytics, Exadata, ODSEE, OID, OAM
• Database: Oracle 11g, Oracle 10g.
• Operating System: HP-UX, RHEL Linux, Oracle Enterprise Linux, Windows Server 2003, 2008.
• Performance Tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG
• Programming: SQL, PL/SQL, UNIX Shell Scripting, Java.
• Tools: Toad, SQL Loader, Oracle Developer 2000, OEM, OAM, SQL Tuning Advisor.

Professional Experience:

Confidential

Sr. EBS Admin, OBIEE Admin

Environment: Exadata, Exalytics, OBIEE 11.1.1.7.1, EBS R12.1.3, DB 11.2.0.2,

Responsibilities:

• Responsible for the full cycle implementation of the Financial ERP project, Implementation of OBIEE and EBS and integration with ODI on Exadata and Exalytics machine.
• Responsible for implementing financial modules of Oracle EBS R12, implementing life cycle of Development, Test and Production ERP systems.
• Coordinated among functional, technical, systems and internal DBA team for installation, implementation, upgrade and issue resolution on EBS R12.1.3 and OBIEE.
• EBS R12.1.1 upgrade to R12.1.3, Patching, cloning multiple environments, troubleshooting issues, post go live support, resolving issues concurrent programs, building internal and external DMZ nodes.
• Responsible for administration, monitoring databases, ASM space issues, database object extents growth and review existing database initialization parameters.
• Ensured performance issues by monitoring and review of application logs, trace files, alert logs, and concurrent logs, reports involving CPU, I/O Activity, and memory utilization.
• Installation of OBIEE 11g application on Exalytics server and Exalogic VM's servers in single and cluster mode.
• Experience in working with SSL certificate and software level load balancer on EBS application servers.
• Excellent knowledge with integrating Oracle Single Sign-on SSO and Oracle Internet Directory OID and Oracle Access Management - OAM on Oracle EBS R12.1.3 release.
• Integration of Essbase cube and RDBMS objects for various level of Reports and drill down.
• Oracle application installation of R12.1.3 and Oracle application database upgrade to 10.2.0.3 to 11.2.0.3.
• Starting and stopping apps services, Concurrent Manager Configuration.
• Oracle application maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Integration with EBS, ODI/ETL and OBIEE for financial reporting also implemented and supported FAH, GL, AP, AR, Projects and HR functional areas.
• Configuration of EBS and OBIEE production environment on Exadata machine, building infiband connections with application servers on Exalytics machines, resolving TNs issues, monitoring and tuning ETL jobs using Infiband connection.
• Expert in Infrastructure and Implementation specialist for support on Oracle technologies on Exadata systems for databases and Exalytics in memory systems for OBIEE applications.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Integration of OID and EBS Application, implemented Single Sign on SSO for EBS and OBIEE.
• Implementing Security certificates for EBS OBIEE and integrated with Load balancers and multiple Web servers and HTTP servers, Proxies.
• Implemented Best Practices on OBIEE, OWB and Proactive measures taken on performance bottlenecks.
• Worked on LDAP Authentication, Role Based Authorization Model, Display Tabs, Default Landing Dashboard, Object Level/Data Level Security, and Prompt Values using OBIEE.
• Supported migration of Essbase cube between different environment and integrating drill down for same.
• Designed and developed the metadata layer RPD to meet the business requirements.
• Designed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model Layer, and Presentation Layer.
• Did the Necessary RPD and Catalog upgrades and applied OBIEE and WebLogic patches.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Created several dimensional hierarchies in the BMM layer for reporting drill-down functionality.
• Configuring Repository, Session variables for user security and to generate dynamic reports.
• Supported Performance monitoring and tuning for various reports and worked with server architect to tune CPU, Memory and DISK for the environments.
• Migrated Repository Web Catalog from Development to Test Production server using Oracle Enterprise Manager/Catalog Manager.
• Created dashboard and reports using pivot views, column selector, view selector, presentation variable, master-detail reports, pie charts, bar charts, etc.
• Implemented MUDE Multi User Development Environment in OBIEE.
• Extensively used Action Links to navigate from Parent to Child Report passing filters/prompt values.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Created Application Roles using Oracle Enterprise Manager assigned different permissions on dashboards and reports.

Confidential

OBIEE Admin EBS DBA consultant

Environment: OBIEE, RHEL Linux 5, Oracle EBS R12.1.1, Oracle RDBMS 11.2.0.2, PL-SQL, Toad.

Responsibilities:

• Responsible for implementing financial modules of Oracle EBS R12.1.1, implementing life cycle of Development, Test and Production ERP systems.
• Coordinated among functional, technical, systems and internal DBA team for implementation and issue resolution.
• Patching, cloning, troubleshooting and post go live support.
• Responsible for monitoring database space issues, database object extents growth and review existing database initialization parameters.
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Created several dimensional hierarchies in the BMM layer for reporting drill-down functionality.
• Configuring OBIEE Repository, Session variables for user security and to generate dynamic reports.
• Supported OBIEE Performance monitoring and tuning for various reports and worked with server architect to tune CPU, Memory and DISK for the environments.
• Ensured performance issues by monitoring and review of StatsPack reports involving CPU, I/O Activity, and memory utilization.
• Oracle application installation of R12.1.1 and Oracle application database upgrade to 10.2.0.3 to 11.2.0.3.
• Starting and stopping apps services, Concurrent Manager Configuration.
• Oracle application maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Integrated EBS SSO -Single Sign On using OID Oracle Internet Directory, OHS Oracle HTTP Server.
• Implemented Best Practices on OBIEE, OWB and Proactive measures taken on performance bottlenecks.
• Worked on LDAP Authentication, Role Based Authorization Model using OBIEE.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Application and database Tuning using AWR, ADDM, ASH, SQL Tuning Advisor, STATSPACK, EXPLAIN PLAN, and SQL TRACE for performance tuning.
• Cloned Oracle home to all non-prod instances and made sure everything is in sync with production.
• Upgraded Java from 1.6.0.17 to 1.6.0.35 and supported application team in resolving the post-upgrade issues.
• Implementation and maintenance support for EBS and database.
• Verified all instances are up and running and all Application Services are on-line.
• Scheduled automated back-end jobs and monitoring scripts.
• Registered Forms, created Form Functions and Menus.
• Registered Executable, created Concurrent Programs and Request Groups
• Identified programs causing performance issues and worked with development team to resolve them.
• Set standards for access and use of databases with objectives of data integrity, data security, and efficient operation and audit requirements.
• Continuous exposure to the issues related to various modules like HRMS, OM, Finance, etc.
• Installation and configuration of WebLogic server.
• Supported OID11g on standalone database with failover data guard.

Confidential

Oracle EBS DBA consultant

Environment: RHEL Linux 5, Oracle EBS R12.1.1, R12.1.3, PL-SQL, Oracle RDBMS 11.2.0.2, Toad.

• Responsibilities:
• Responsible for 24x7 maintenance and upgrade to Oracle EBS R12, implementing life cycle of Development, test and Production systems.
• Coordinated among functional, technical, systems and internal DBA teams for implementation and issue resolution.
• Production support, maintenance, performance tuning, troubleshooting by ensuring all instances are backed up and available for users.
• Oracle applications maintenance of R12.1.1 and upgrade to R12.1.3 by ensuring support is provided for escalated issues/SR with ORACLE support team.
• Supported Functional end users to fix any issues related to Applications and resolved database performance-related issues.
• Performed complete refresh of the development environment from the production using Rapid Clone.
• Configured shared application tier on the development environments.
• Based on the requirement created the custom top and configured them on EBS.
• Worked on patching activities like patch analysis, merging and applying patches using the utilities like admrgpch and adpatch and troubleshooting the issues faced during the process.
• Responsible for managing production, development test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
• Involved in Upgrading of Oracle database Oracle Applications 11.5.5, 11.5.2 and supporting the production team.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Involved in database migrations cloning Oracle Applications 11.5.5, 11.5.2 production system, for testing and development purpose using rapid clone.
• In depth experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice and adctrl.
• Expertise in performance tuning using Stats Pack, TKProf, OEM, SQL Analyzer and Quest TOAD as well as performance tuning of Oracle APPS.
• Responsible for all Remedy tickets, communicated and resolved in a timely fashion
• Oracle database installation, maintenance for production, development and test environment.
• Support for customization and upgrade for Oracle database.

Confidential

E-Business Suite DBA consultant

Environment: HP-UX, Oracle EBS 11i, Oracle 11g, PL-SQL, Toad.

Responsibilities:

• Provided 24x7 Production Oracle database administration and Oracle Application administration support.
• Creation of users, assigning responsibility, creation of custom menus for Oracle Apps 11i and R12.
• In depth experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice and adctrl.
• Pre-patch analysis and document preparation with pre and post patch installation steps.
• Worked with business team and Functional team on issue resolution and performance enhancement.
• Generating automatic scripts for backups.
• Upgraded of Oracle Applications from 11.5.10.2 to 12.0.4 and upgrade of databases from 10.2.0.3 to 11.2.0.2
• Enabled Auditing feature for tables such as FND USER etc.
• Created new concurrent managers, Purged concurrent requests table.
• Performed daily and weekly backups using Netbackup snapshot technology.
• Coordinated and reviewed among DBA team for any new installations, upgrades and configuration changes to the existing environments.
• Worked on patch analysis, merging and applying patches using the utilities like admrgpch and adpatch.
• Used AD utilities like adctrl and adadmin to resolve the issues while applying the patches.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.

Confidential

DBA and Data Analyst

Environment: SQL, Oracle 10g, 11g, Toad for Oracle, Toad for Data Analysis.

Responsibilities:

• Provided 24x7 Production Oracle Database Administration support.
• Was responsible for supporting production databases, administration and maintenance of the databases.
• Performed Oracle 11g installation, backup, cloning, schema refreshes, user maintenance, user table refresh.
• Created and maintained users by providing proper authorizations and maintaining appropriate profiles.
• Involved in developing a disaster recovery DR plan.
• Performed SQL tuning and assisted developers with coding PL/SQL.
• Written scripts to collect database statistics and to perform regular backups and recovery with various backup strategies for different databases.
• Monitoring trace files, alert files, log files, collecting performance statistics, manage parallelism for optimum performance using Explain Plan, SQL Trace, TKPROF, Stats pack.
• Reorganization of Database, Table spaces, tables, indexes etc.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Oracle 10g upgrade and patching and maintenance of Development and production databases.
• Planning and Administration of backup and recovery strategies configuring backups using hot and cold backups.
• Worked closely with Technical and functional teams to provide Database tuning support during server change and upgrades.

Confidential

DBA.

Environment: PL/SQL, Oracle 10g, Linux, Java.

Responsibilities:

• Worked on development of customized Enterprise Resource Planning ERP system to improve and expand tracking inventory and recording of purchase/sales orders.
• Worked with Sr. DBA in designing and developing oracle database, created tables and views as per the specifications.
• Wrote PL/SQL queries and functions to migrate and reconcile data from third parties into database.
• Tuned and configured Oracle 10g Database for optimum performance.
• Provided production support and System Administration of 10g database.
• Developed backup scripts, Verified all instances are up and running.
• Migrated legacy system data into Oracle Database that customer service and sales representatives could access for wide range of services.
• Designed batch cycle procedures to upload the interface data and implement payment cycles.
• Developed custom tables, SQL queries and Oracle reports based on technical requirements from the application developers.