Summary:
Oracle E-Business Suite Applications & Database Certified Professional Highly accompolished, deeply driven with over 8+ years of extensive experience as leading, implementing & maintaining production e-Business suite applications & databases. Installations, Performance tuning/debug (database & applications), Cloning, Patching, Code migration, Upgrades, Cross platform migrationusing Oracle tools and technologies. Oracle Applications (Techno-Functional) ERP, Financials Payables, Receivables, Fixed Assets, General Ledger, HRMS, SCM, Projects, P2P, Manufacturing, Inventory, Purchasing, Advance Pricing, CRM, SOA architecture, Oracle Fusion Middleware (J-Developer, J2EE, BPEL), Oracle Application Server 9iAS, 10gAS, XML/BI publisher, OBIEE. Database 11g, 10g RAC, 9i, 8i. RAC multi terabyte, Dataguard, High availability. Administering Unix/Linux Servers, IBN/AIX/HP, Sun Solaris, and SAN Storage. contributing relevant experience and education background where my technical and functional expertise, industry exposure, conceptual and analytical skills would be utilized productively. Familiarity of ITIL life cycle process and standards.

Key Strengths:
Implementation: Expert level skills in the following areas:

• Data Modeling, Architecture, Installation, Upgrades, Migration, Application Customizations.
• Installation & Configuration of Oracle e-business suite R11i, R12 in multi-node database, multi apps nodes, RAC & rollout to Production for modules like Financials (AR, AP, GL, FA, Cash Management), HRMS, Payroll, SCM, Manufacturing, iprocurement & isupplier.
• Regular maintenance and updates of Oracle Application Server 10gAS.
• R12i implementation using Oracle Business Accelerator.
• Installation Oracle Applications on Unix/Linux/Solaris/Windows. System Administration.
• Linux Installation, Configuration, Networking & Administration.
• Plan and implement Oracle Real Application Clusters (RAC) on Unix. Application Failover and high transaction volume. High Availability – Real Application Clusters (RAC) and Advanced Replication.
• Oracle Clusterware, ASM, Shared ApplTop and Shared tech stack.
• Implementing Data Guard setup and Flash Back.
• Implementation of Backup Strategies using RMAN, Oracle Import/Export,Veritas NetBackup, and

HP Data storage.

• Installation, configuration & clone of 9iAS & 10gAS with SSO, OID, and LDAP. Discoverer, Interconnect & Oracle Workflow builder.
• Sysadmin activities like Profile Settings, Printer Configuration, Creating users, Responsibilities, Menus, Concurrent managers & managing Concurrent queues, Printer configuration.
• Configuring Load balancer of Web, Forms and Concurrent server.
• Configuration of PCP – Parallel Concurrent Managers.
• Implement RAC 10g on Linux, RAC Setup & Installation, Administration.
• Cloning application & database to create Dev, UAT, Preprod instances.
• Designing & Developing for perf. Tuning, configuring DB for Perf, SQL tuning, Instance Tuning, statspack TKPROF, AWR, ASH, ADDM, Security, Using Indexes and clusters, EXPLAIN PLAN, Appl tracing tools.
• Patching and Upgrades Management and Version Control Applications and Databases.
• Install NLS software for new language support.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Extensively worked on Financials Modules, Inventory, AOL, Alerts, Workflow and System Administration.
• Proficient in writing Stored procedures, Packages and functions, triggers, using SQL, PL/SQL, Shell Scripting & CornJobs.
• Capacity planning, tuning & performance enhancements.
• HandsOn experience in data interfacing from Legacy system.
• Good exposure in Project Management activities including Project Scheduling and Phasing, Coordinating Presentations and Workshop Sessions.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology.
• Sound experience working directly with Oracle Support and Metalink.

Upgrade/Migration: Expert level skills in the areas of :

• Version upgrade experience of E-business 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).
• Database Upgrade (Versions 9i to 10g) and 10gR2.
• O/S Migration of Applications & Database (O/S Windows, Linux, HP Unix, AIX, IBM).
• Migration of concurrent managers in RAC environment.

Technical Skills:
ERP Applications: Oracle E-Business suite 11i.x (11.5.7, 11.5.9, 11.5.10.2), R12.1.2
JD Edwards EnterpriseOne 8.12
Databases: Oracle 11g, 10g RAC, 9i, 8i. DB2, SQL Server 2000 & 2005, MS Access
Operating Systems: IBM AIX, HP UNIX, RHEL, Win-NT, IBM AS-400, Novell Netware
Oracle Tools: Oracle Forms 6i, OEM, ADUtilities, ADI, XML/BI publisher, OBIEE
Middleware: Oracle Application Server 10gAS, 9iAS R2, Web Logic, SSO, OID, LDAP
Languages: SQL, PL/SQL, C Shell, Linux Shell Scripting, Visual Basic, HTML, DHMTL,
XML spy and Java Scripts
Integration Technologies: Service Oriented Architecture (SOA)
Web Technologies: Web Sphere, Oracle App Server, Apache, Web Logic, OC4J, JDBC, Oracle Forms and Reports Server
Hardware: HP Data Storage, VERITAS Net Backup
Reporting Tools: Oracle Reports 6i, Discoverer, and Business Objects 6.0 & XI, Data Warehouse
Tools: Oracle J-Developer, Oracle BI Publisher, TOAD, Web-ADI, SQL *Loader, SQL Navigator, PL-SQL Developer, Data Loader, Browser/Query Builder, VMware, CITRIX
Administration CNC management (JD Edwards EnterpriseOne 8.12)
Methodology: Oracle AIM

Education:

• Bachelor Degree in Commerce (B.Com), Major in Finance
• Masters Diploma in Software Engineering (HDSE)

Certification:

• Oracle 10g Database Administrator Certified Associate (OCA).
• Oracle 10g Database Administrator Certified Professional (OCP).

Employment:
Confidential,Mettawa, IL Feb 2010 to May 2010
Sr. Oracle Apps Consultant

Tools: Oracle Applications 11.5.10.2/R12, TOAD/SQL Navigator, Oracle 9i, 10g, UNIX, PL/SQL, RAC, OBIEE. RMAN. Implement and Upgrades includes Oracle Financials, Oracle Inventory, Projects and Order Management.

• Support and maintain Oracle Applications 11.5.10.2 and R12 Instances including production.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i Instances, (Rapid Clone).
• Install Oracle Database 10g RAC.
• Install and configure 10gAS and 9iAS.
• As an Oracle Applications Consultant/DBA in the Unified Financials Management Systems to help Conversions and Interfaces from Legacy system to Oracle Apps in Oracle GL.
• Upgrade Applications from 11.5.10.2 to R12.
• Upgrade Database from 9i to 10g.
• Install NLS software when new language support is required.
• Troubleshoot problems with Concurrent managers, Apache, Jserv processes, database and application performance.
• Applying database and applications patches. Cumulative patch updates CPU.
• Perform SQL tuning.
• Assist developers with coding PL/SQL and OBIEE data warehouse.
• Customizing Forms and Reports using Designer/Developer.
• Create and maintain custom responsibilities and menus.
• Move all custom programs and reports to production. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Create tablespace, tables, and users for custom applications.
• Backup and Recovery Administration (RMAN, Import/Export, VERITAS NetBackup).
• Administering through Oracle Management Server (OEM).
• Application System Administration and AOL.
• Maintain User security, Oracle Schemas.
• Centralized financial control of projects and projects inventory tracking.

Confidential, Sep 2008 to Dec 2009
Oracle Apps DBA (Application & Database Administrator)

Project: Oracle Application Implementation, Upgrade and Support. Version: 11.5.9/11.5.10.2, Multi Org, RAC
Oracle Database 9i, 10g Installations and Support. XML publisher and EDI tool. Implementation by AIM methodology.
Environment Oracle Apps 11.5.9/11.5.10.2, R12 Oracle 9i, 10g AS, RAC, ASM, SSO, Clusterware, PCP, RMAN, Oracle Enterprise Manager, Oracle Discoverer, HP UNIX, Linux, AIX and SAN Storage, HP Data Storage, Veritas NetBackup

Apps Responsibilities:

• Upgrade Applications from 11.5.10.2 to R12
• Designing the System Architecture of the environments and provided suggestion for change management and procedures.
• Cloning & building OLTP e-business suite environment from 4 nodes RAC to single node database in UNIX cluster for High Availability with 3 application nodes.
• Cloning & building the specific Oracle Advanced Planning & Scheduling module of e-business suite instance and configuring the DB link and materialized views for refreshing snapshots and APS data collection.
• Designing the System Architecture of the environments and provided suggestion for change management and procedures.
• Implementing the HTTP hardware layer & Jserve layer load balancer to achieve session persistence.
• Performing a fresh Oracle ebusiness suite 11.5.10.2 installation and clone this to create a development environment for the application team to do new full cycle development activities.
• Application System Administration activities like creation of Responsibilities, Menus & Users.
• Independently resolved many critical issues related to technical side of Application.
• Performing Application and database clone using Rapid Clone.
• Application Patch management - Applying Family pack, Minipacks, Consolidated updates and standalone or one-off patches.
• Multi-org (MO) implementations.
• Perform Application, Database and OS Performance Tuning.
• Installing, Configuring & Clone10gAS Interconnect, Adapters. Configure OID & Single Sign On.
• Oracle Discoverer Installation, configurations & Cloning Discoverer.
• Maintaining AOL and Concurrent Manager.
• Creating Disaster Recovery site and testing for fail over and fail back procedures.
• Setting up RMAN database backups.
• OEM and Oracle Grid Control experience.
• Performed Application admin tasks using ADADMIN utility.
• Forms upgrades & other technology stack related upgrades.
• Administered and Troubleshooting of Oracle applications Server issues.
• Application Desktop Integrator (ADI) and Web ADI installation.
• Configuring Workflow notification mailers.
• Financial Statement Generator (FSG’s)
• Analyzing and developing of data conversion script in AP, AR, GL Suppliers, GL Balances, specifically.
• Creating custom database objects like Views, Function Procedure according to user requirements.
• Converting the Parallel Concurrent Processing Servers (PCP) to Single Concurrent Processing Server and devising the failover process to other o/s cluster node.
• Interfaces using SQL * LOADER.
• Cloning & configuring to create Development, CRP Testing, Production environments.
• Oracle Enterprise Manager Grid Control Administration.
• Some of the other Systems Administration duties including the following:

- Printer Configuration.
- Security (users, menus, responsibilities creation, security groups).
- Setting users profiles options that alter the way Oracle HRMS looks and behaves.
- Managing Concurrent programs and requests.
- Decisions taken for which modules users have access to specific forms, functions and reports.

• Managing concurrent processing and ensuring that long-running, data-intensive tasks run simultaneously with online, parallel operations.
• Expert level experience in Oracle BI Publisher/XML Publisher and Template Builder.
• Monitor and tune the Oracle Application for optimal performance.
• Well expert at using Metalink to find solutions to the issues.

Oracle DBA Responsibilities:

• DB installation, upgrading and maintenance, administration 10g, 9i.
• Oracle RAC 10g ASM installations and administration ASM instances.
• Creation and maintenance of Schema objects.
• Used DB links & materialized views to refresh the data between various databases.
• Database Backups and Recovery using DB Export/Import.
• Hot and Cold Backups and Recovery/Disaster Recovery – RMAN and supplement it with daily export utility.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Modeling, Architecture, Installation, Upgrades, Migration and Patches.
• Supporting Oracle Apps and Databases in a RAC cluster environment with load balancers experience.
• Troubleshooting the application and database issues raised by end user through remedy tickets.
• Extensive work on tuning SQL queries, disk I/O, SGA.
• Create databases, tablespaces for different application schemas; enroll users, and setup auditing Manage user security through privileges and roles.
• Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests.
• Partitioning large tables using partitioning keys.
• Creating Object data and User-defined data types.
• Provide remote technical support using SSH and terminal services
• Configured Load Balancing for RAC environment.
• Refresh from production to Test and Dev Environments.
• Installed, maintained, tuned Metadata Repositories.
• Creating the database specifying the Data files, Table spaces and Log files.
• Control database size by adding/dropping Table spaces.
• Work closely with technical team to ensure to adhere and to co-operate the policies and procedures pertaining to the database.
• Monitor the growth of database to ensure the smooth functioning of daily activities.
• Experienced in mapping legacy application data to Oracle applications fields.
• Control and monitor user access and security to the database.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Performing upgrades of the database and software to new release levels.
• Customer Service oriented with high values of customer satisfaction.
• Data migration using Oracle Applications Interface through APIs and Open Interface.
• Strong Communication Skills with Management, Application Team, DBA Team, Application Team, Business Users, UNIX & Storage Administration Team.
• 24/7 maintaining & Supporting the production e-business suite application and database.

Modules Implemented and Supported:
- Core Application Technology Stack
- Applications DBA
- Financials (GL, AP, AR, FA, Cash Flow Management)
- HRMS (Payroll Manufacturing, Human Resource, Self Service)
- Inventory
- Purchasing
- Manufacturing
- Quality Management
- Supply Chain Management

Confidential,Middle East Mar 2003 to Aug 2008
Oracle Applications DBA

Project: Oracle Application Implementation, Upgrades, and Support. Version:11.5.7/ 11.5.9/11.5.10.2, Multi Org
Oracle Database 9i, 10g AS. Implementation by AIM methodology

As an Oracle Apps DBA and Technical Consultants: Maintained full responsibility for Oracle e-business suite Finance, HRMS, Inventory and Purchasing modules. As part of their project team and performed technical activities in supporting Oracle e-business suite application & Database which was with 3 Apps nodes and 2 Database nodes in Real Application Cluster with Raw devices. As part of maintenance activity upgraded Oracle database and e-business suite. Also on a special project requirement, as first phase the PCP Concurrent managers were migrated from database node to the application node and as second phase database instances were migrated from HP Unix to AIX Unix.

Creates and maintains application system documentation for all environments. PRIMARY RESPONSIBILITIES/ACCOUNTABILITIES: Handles day-to day provisioning of end user accounts, responsibilities, and menus per established SOX policies and procedures Assures that the Oracle e-business application operates effectively during the course of the business day, especially during critical windows such as month-end close Handles all activities related to troubleshooting, recovery. Application supports for In-house and International Divisions of ALJ Group.

Environment Oracle Apps 11.5.9/11.5.10.2, Oracle 9i, 10g AS, RAC, ASM, Clusterware, RMAN, OEM, Oracle Discoverer, HP UNIX, Linux, AIX and SAN Storage, Veritas NetBackup

Responsibilities:

• 24/7 maintaining & Supporting the production e-business suite application and database.
• Oracle Application upgrade from 11.5.9 to 11.5.10.2. RAC multi node setup.
• Install and Maintain Oracle 10g RAC for the Oracle Financial, HR Applications and other modules.
• Administering storage (ASM Instances, ASM Disk groups), Adding and Removing nodes and Instances.
• Support approximately 100 users on Oracle Financials.
• Apply application patches and Code Migration.
• Clone refresh to rebuild the test environment.
• Create and maintain custom responsibilities and menus.
• Installation of Web applications server, Oracle Applications server and Oracle Forms and Reports server.
• Set up to share APPL_TOPs over different instances.
• Oracle Applications in Financial - modules installed include AP, GL, AR, FA, CM, cash Management, iExpenses, project costing, Procurement, Project, etc.
• Move all custom programs and reports to production. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Make changes to standard Oracle Applications forms and reports using Designer/Developer for testing purposes as advised by Oracle Support (Metalink).
• Installed and patched for 11.5.9/10 instances, including foreign languages and Discoverer 4
• Upgraded and supported multi-country, multi-language 11.5.9 to 11.5.10 installation.
• Creation of Request Group, Data group, value sets and Flex Field setups.
• Installation of support pack for Oracle Diagnostics
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Create test web server, web listeners, form servers, concurrent managers, and databases from the production environment.
• Create tablespaces, tables, and users for custom applications.
• Maintain user’s management and security.
• Database Administration & sizing, performing Db tuning & optimization.
• Generating Trace files & Tkprof & analyze them for Errors or Performance Reasons.
• Troubleshooting includes tablespace extension, login issues, session issues, long running requests.
• Bringing Up the Notification Mailer & Background Engine & Agent Listeners Using OAM.
• Assist Programmers and Developers with Oracle and Applications problems.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Write SQL scripts to monitor tablespace and extent growth.
• Perform analysis, coding, maintenance, and testing of applications.
• Answer users\' questions on an ongoing basis.
• Resolve various application failures due to data entry errors or system errors. Involves identifying problems and implementing corrective actions.
• Assist Developers to convert legacy data to an Oracle Applications database.
• Write SQL*Loader control files for uploading legacy data (AS400) to interface tables.

Modules Implemented or Supported:

• Core Application Technology Stack
• Applications DBA
• Financials (GL, AP, AR, FA, Cash Management)
• HRMS (Payroll Manufacturing, Human Resource, Self Service)
• Inventory
• Purchasing
• Cash Flow Management.

Confidential,Middle East May 2001 to Feb 2003
Oracle Apps Developer

Client : Confidential,
Project : Hospital Management System (An Electronic Management)
Forms : Oracle Forms 5.0
Reports : Oracle Reports 2.5
Database : Oracle 8i

Responsibilities:

• Involved in Analysis, Design, Coding, Tesing and implementation of the project.

Modules:

• Patient Registration (In & Out), Appointment Scheduling, Adminssions / Discharge / Transfer
• Bed Management, Wards Management Module, Patient Relations, Doctors Workbench
• Nursing Workbench, Electronic Medical Record, Clinic Specialities, Laboratory Information System, Radiology Information System, Pharmacy, Cental Supply Department, Dietary, Housekeeping / Laundry, Patient Billing, Insurance and Contracts Management, Hospital Administration, Roster Management.

PROFESSIONAL COURSES:

• Diploma in Oracle 10g DBA, Wilshire Information Technologies, Hyderabad India.
• Diploma in Oracle Apps DBA R12, HASZone Technologies, Hyderabad India.

HANDS-ON TRAININGS:

• Oracle e-Business Suite 11i Apps Security.
• Oracle Human Capital Management.
• Oracle Payroll and Oracle Learning Management.
• CNC Administration (JD Edwards EnterpriseOne 8.12).