SUMMARY

• 20 Years of progressive experience in Implementation, Management, Support and Upgrade of Oracle ebusiness suite and other Oracle based industry applications as an Oracle Apps DBA.
• Expertise includes Oracle Applications and Databases on UNIX platforms in ensuring Quality, Integrity and Availability of the Company’s data within Oracle Server
• Experience with many Installations, Configurations, Upgradations, Migrations, Administration and Patching of Oracle Applications and Oracle databases.
• Upgraded many large scale Oracle Applications from 10.7 to 11.0.3 to 11i and 11i to R12.1.x, R12.2.x with full set of application modules.
• Upgraded HRMS and Payroll modules to latest RUP’s.
• Routine Oracle Application Maintenance and configuration: autoconfig, clone, patching, technology stack upgrade, configuration management, and statistics.
• Upgraded databases to 9i, 10g, 11g and 12c. Implemented HA solutions including RAC, Dataguard
• Experience in Installations, configurations, Administration and patching of 10gAS, 9iAS and Oracle Web Application Servers.
• Oracle Applications all modules Techno Functional knowledge.
• Proficiency includes Engineering and Architecture of Oracle, Resource and Security management, Tuning, Clustering, Backup and Recovery, RMAN scripts. Good Exposure to Oracle Database Architecture, Optimal Flexible Architecture (OFA).
• Developing standard DBA procedures and practices.
• Troubleshooting critical production issues in a complex application environment.
• Work in conjunction with other IT, application development, and business groups to understand functionality, scalability, performance, security, and integration requirements from the database perspective.
• Knowledge in administration, management of Operating Systems like Sun Solaris, HP - Unix, IBM AIX, Linux and Oracle EXADATA
• Experience in managing technical teams for both large and small scale implementations.
• Lead architect at the current upgrade process
• Expertise in Oracle Enterprise Manager (OEM) to maintain databases and Applications
• Areas of Expertise in Oracle Financials, Distribution, Manufacturing and HR modules
• Implemented Single Sign (SSO) on integration with Active Directory (AD)
• Oracle APEX installation and administer workspaces
• Expertise in SQL Server installations and maintain the applications
• Worked on the entire life cycle implementation of various modules in various application versions like 10.7, 11i, R12.
• Experience using workflow components like Workflow Builder, Workflow Engine and administrator.
• Experienced in Performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
• Excellent working knowledge in UNIX shell scripting.

TECHNICAL SKILLS:

• Oracle RDBMS 12c/11g/10g/9i/8.x/7.x, SQL Server 2005
• Oracle Applications 12.2.x/12.1.3/11i/ 11.0.3/10.7 sc/10.7nca/10.7char
• Oracle Applications Financial Modules, HRMS and Payroll and Manufacturing Modules.
• Oracle Retail Applications (POS) 13.4.8, back office and central office applications for POS
• RMAN, Tivoli, Veritas, OEM, Dataguard, RAC, Commvault backups and SQL server Backup utility
• EXADATA, IBM AIX, Sun Sparc 10/8/6, HP Unix 11i/10, Redhat Linux, OEL Linux and EMC Navisphere
• Toad, DB Artisan, Workflow Builder, OEM, Apex, Informatica, Clarity
• Oracle Internet Directory (OID), Single Sign on (SSO), Oracle Identity Management.
• Oracle Discoverer, OBIEE, SOA, Oracle Portal, Oracle jDeveloper, SOA, XML Publisher, Shell

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Oracle EBS 12.1.3 /OBIEE/SOA

Responsibilities:

• Oracle EBS r12.1.3 production support
• OBIEE/SOA/ODI configuration
• EMC Navisphere storage configuration and maintenance
• Oracle retail POS upgrade from 13.1 to 13.4.8
• Install and confifure Central office with Oracle EBS
• Configure SOA for return orders
• Migrations to multiple environments from Redhat to Oracle Linux
• Patching analysis of latest CPU and apply them for each version
• Implemented cloning process to refresh lower instances from Production
• Maintain and support OEM 12c for all environments
• Configured CommVault for tape backups
• Document all existing processes
• Regular software updates on Redhat Linux and maintain

Confidential, Schaumburg IL

Oracle EBS R12.2 upgrade

Responsibilities:

• Oracle database upgrade from 10g to 11.2.0, 4 on Sun sparc
• Application upgrade from 11.5.10.2 to R12.2.5
• Cloning EBS from Prod to non-Prod instances
• ADOP online patching on 12.2.5
• Weblogic configuration as part of 12.2
• Reconfigured Backup and restore procedures
• Installed and configured OEM grid control 12c
• Knowledge transfer to onsite DBA
• Patching and maintenance of EBS instances
• Performance tuning
• Prepared documents with new features for client review
• Supported existing 11i version

Confidential, IN

Production Support

Responsibilities:

• Exadata migrations and upgrades
• Multiple Upgrades 11.5.10.2 to R12.2.4 on Exadata
• Production support for R12.2.4 and 12.1.3 and 11i (300 instances)
• F5 load balancing configuration for external suppliers thru DMZ
• Coordinates with offshore team
• Migrations to multiple environments
• Patching analysis of latest CPU and apply them for each version
• Ptach as part CPU patching
• Implemented cloning process to refresh lower instances from Production
• Maintain and support OEM 12c for all environments
• Oracle Release management for AOL migrations (chainlink)
• Document all existing processes

Confidential, Chicago IL

EBS R12 Database Upgrade and Migration to 12c and new hardware

Responsibilities:

• Install and Configure 12c Grid Infrastructure for Cluster
• Configure Oracle Database 12.1.0.2 RAC on Redhat Linux 64 bit
• Upgrade database from 11.1.0.7 to 12.1.0..2
• Apply Interop Patches on Oracle EBS R12 as part of database upgrade
• Configure Oracle EBS application with new database servers
• Configure Oracle Enterprise Manager (OEM) cloud 12c
• Upgrade Hyperion Database and migrate to new hardware
• Upgrade SSO database configure on new hardware
• Cloning from Production to non-productions instances on regular base
• Performance tuning
• Code migration using PPM
• AppWorkx Scheduling
• Maintain Applimation Application database
• Documentation of the process

Confidential, IL

EBS R12 Upgrade on Sun Sparc

Database upgrade from 9.2.0.7 to 11g

Responsibilities:

• Upgrade from Oracle EBS 11.5.10.2 to R12.1.3
• Upgrade database from 9.2.0.7 to 11.2.0.4 as part of upgrade
• Oracle HRMS upgrade to latest RUP6
• Upgrade Clear Orbit Bar Code system to integrate with R12
• Oracle Enterprise Manager Configuration
• RMAN Backups and Recoveries
• Support Multi Language
• Patching on both 11i and R12 versions
• Cloning from Production to non-productions instances on regular base
• Performance tuning
• Code migration
• EDI inbound/outbound Maintenance (Liason and OB10)
• Production Support
• Documentation of the process

Confidential, Beloit, WI

Oracle EBS R12 Upgrade on IBM AIX Power Systems

Responsibilities:

• Upgrade from Oracle EBS 11.5.10.2 to R12.1.3
• Upgrade database from 10.2.0.4 to 11.2.0.3 as part of upgrade (1TB db size)
• Upgrade Oracle Value Chain Planning Instance (VCP) from 11i to R12
• Oracle Enterprise Manager Grid Control
• Patching on both 11i and R12 versions
• Cloning from Production to non-productions instances on regular base
• Performance tuning
• Code migration using PPM (Project Portfolio Management)
• XML gateway configuration
• Production Support
• Documentation of the process

Confidential, CA

Apps DBA Track Lead

Oracle EBS R12 Production Support

Responsibilities:

• Oracle EBS R12 Production Support
• Cloning EBS from Prod to non-Prod instances
• Monitoring the Server Loads and tune them if necessary
• SME9 ticket resolutions for issues
• Mentor the DBA team
• Worked with offshore team
• Patching and maintenance of EBS instances
• Finding the root cause for issues and documenting for audit purposes
• Performance tuning

Confidential, IN

Lead Oracle Apps DBA

Oracle EBS R12 Upgrade on HP-UX/Redhat Linux

Oracle EXADATA Migration

Responsibilities:

• Upgrade from Oracle EBS 11.5.10.2 to R12.1.3
• Upgrade from R12 base HRMS to RUP6
• Platform Migration from HP-UX to Linux
• Migrate EBS R12 to Oracle EXADATA high performance systems
• Oracle Enterprise Manager Cloud 12C
• Patching on both 11i and R12 version
• Production Support 11i and R12
• Performance tuning on R12 upgrade
• Configured and supported 11g RAC environment
• Cloning R12 using Rapid Clone

Confidential, Upper Marlboro, VA

Lead Oracle Apps DBA

Oracle EBS R12 Upgrade and Migration on Linux

Responsibilities:

• Database upgrade and migration from Hp Unix to Redhat Linux
• Upgrade from Oracle EBS 11.5.10.2 to R12.1.3base upgrade to 11gR2
• Oracle R12 HRMS and Payroll upgrades to latest RUPs
• Custom Migrations
• Oracle Enterprise Manager
• Performance tuning on R12 upgrade
• Configured and supported 11g RAC environment
• Cloning R12 using Rapid Clone

Confidential, Chicago

Sr. Oracle Apps DBA (Lead)

Oracle EBS R12 on Sun Sparc/Redhat Linux

Responsibilities:

• Migrated Oracle Applications from Sun Sparc 8 to Sun Sparc 10 blade servers
• Implemented Single Sign on (SSO) with Active Directory (AD)
• Configured and Maintained OID as part of SSO implementation
• Upgrade Oracle Applications from 11.5.10.2 to 12.0.4 version
• Upgrade Oracle Database from 9i to 10g using upgrade assistant as part of Applications upgrade
• Upgraded Oracle Application servers from 9iAS to 10iAS
• Upgraded Oracle Enterprise Manager OEM to the latest
• Automated all Oracle Databases Hot backups and Cold backups and scheduled them.
• Patching and Cloning of Oracle Applications
• Monitor and trouble shoot database performance issues
• Implemented Evergreen check printing software to print checks from Oracle Payables
• Installed and configured Oracle APEX for budgeting system
• Maintained SQL server to support Clarity system
• Automated backups using SQL server backup utility
• Upgraded databases from 9i to 10g for various applications
• Migrated Oracle Applications 11i from Sun Solaris to Redhat Linux 5 as part of proof of concept.
• Implemented ETL extract procedures to load data from oracle to Data warehouse
• Converted two node to single node architecture
• Upgrade Oracle applications from 11.5.3 to 11.5.10.2
• Installed and administer the Discoverer server
• Applied Oracle HR patch legislations
• Configured OAM workflow manager for email notifications
• Utilized AD utilities to maintain Applications
• Implemented Disaster Recovery (DR) procedures
• Automated system failures and monitored them in timely manner
• Implemented and developed RMAN scripts for database backup and recovery including hot and cold backups
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Production Support and maintain applications
• Worked with Oracle support to fix the bugs/issues using SR’s
• Configured CRON jobs to schedule backups and other jobs
• Cloning e-business suite 11i/12i using Rapid Clone technique.
• Installed and configured Enterprise Manager Grid Control.

Confidential, Chicago

Sr. Oracle Apps DBA

Oracle EBS 11.5.3 on HP UNIX

Responsibilities:

• Maintained Internal Oracle Applications
• Installed and Configured Demand Planning and ASCP using Express Server
• Configured Express server to work with Advanced Supply Chain Planning
• Installed multiple version of Oracle Applications for their training wing and sized accordingly
• Cloning using Rapid Clone methodology
• Worked on their client systems to tune for performance
• Worked with all Backup and restore procedures to maintain the databases.
• Production support for their clients

Confidential, NY

Lead Architect

Upgrade from 11.0.3 to 11.5.3

Responsibilities:

• Lead Architect and Lead technical in this Upgrade project
• Migrated Oracle Applications into new hosted environment
• Validated migration and testes the application
• Upgraded Oracle applications from 11.0.3 to 11.5.3 on two node configuration
• Upgraded the database from 8.1.7.4 to 9.2.0.5
• Captured all steps and timings for the first iteration which can be used as baseline for subsequent iterations
• Migrated all DTS extracts into new environment
• Led both functional and technical teams in this upgrade
• Coordinated with functional team to implement pre and post upgrade steps
• Coordinated with business users for full testing.
• Evaluated upgrade steps and addressed issues during each category of the upgrade
• Applied latest patch sets using ad utilities
• Implemented new Backup and Recovery procures using RMAN
• Production support
• Documentation and internal training to the client DBA’s
• Implemented cloning procedures to refresh non production instances with production databases
• Performed tuning using tkprof and perfstat utilities

Confidential, McHenry IL

Sr. Oracle Apps DBA

Oracle EBS 11.5.3 on HP UNIX

Responsibilities:

• New implementation of Oracle Applications 11.5.3 with all financials, Manufacturing, HRMS and CRM modules
• Installation of Oracle Applications and database sizing
• Cloning Oracle Applications using Rapid Clone method
• Patching, maintenance and Administration of Applications using AD utilities
• Load balancing using hardware load balancing
• Implementation of Hot and cold backup strategies
• Standby database implementation for disaster recovery site
• Oracle database performance tuning
• Concurrent Managers administration
• Production Support and maintain applications
• Performance tuning of applications
• Discoverer installation and configuration

Confidential, Detroit

Tech Lead

Oracle EBS 11.5.3 on HP Unix, Redhat Linux

Responsibilities:

• Technical Lead and lead architect
• Installed Redhat Linux and HP Unix and administration of both environments
• Installed Oracle Applications 11i on Redhat Linux
• Created and implemented Backup and Recovery procedures using NetBackup
• Cloning, Patching and maintain Applications
• AD utilities to administer and maintain Oracle Applications
• Support to Training environments
• Provided documentation on installation and maintenance activities of oracle instances
• Security Management
• Responsible for monitoring Application services on day to day basis
• Worked with Oracle support to resolve bugs/issues by TARs
• Patching, maintenance and Administration of Applications using AD utilities
• Load balancing using hardware load balancing
• Standby database implementation for disaster recovery site
• Oracle database performance tuning
• Concurrent Managers administration
• Production Support and maintain applications
• Performance tuning of applications
• Discoverer installation and configuration
• Installed and configured Oracle ADI tools for GL uploads
• Configured Oracle Project Connect to work with Oracle Projects module

Confidential, Libertyville IL

Oracle Apps DBA

Oracle EBS 11.5.1 on HP UNIX

Responsibilities:

• Technical Lead and lead architect
• Implemented Oracle financials, Manufacturing and Distribution modules
• Installed HP Unix 10 and administered
• Installation and configuration of Oracle Applications 11.5.1 on single node architecture
• Worked with Ceridian for Payroll integration with Oracle
• Implemented self Service HR
• Ceridian Payroll integrations
• Installed Express server to configure the Demand Planning
• Implemented backup and Recover procedures and automated them to run every day.
• Integrated printers with Oracle Applications
• Implemented rightfax to fax the PO’s

Confidential, IL

Oracle Apps DBA

Oracle EBS 11.5.1/11.5.3 on IBM AIX

Responsibilities:

• Implemented Oracle financials, Manufacturing and Distribution modules
• Installation of Oracle Applications 11.5.1 and configured on multi node installations
• Implemented load balancing to balance the load on middle tiers
• Patching, Cloning, and monitoring Application instances
• Implemented RMAN backup strategy to backup and recover the databases
• Implemented Hot and cold backup procedures
• Upgraded Oracle Applications 11.5.1 to 11.5.3 and then later to 11.5.5 versions
• Maintain administer Concurent Managers
• Configured ADI and ADE tools to work with Applications
• Database performance tuning
• Production support
• Applied HRMS legislation Patches

Confidential, Orchards, WA

Oracle Apps DBA

Oracle Apps 11.0.3 on Digital UNIX

Responsibilities:

• Implemented New modules and Discover server
• Implemented new backup policies
• Implemented right fax for Purchasing solutions
• Developed new Shell scripts to run schedule jobs
• Production support

Confidential, IL

Tech Lead

Oracle Apps 11.0.3 and upgrade to 11.5.3 on HP UNIX

Responsibilities:

• Installed and configured HP Unix
• Installed Oracle Applications 11.0.3 using one hour installation procedure
• Implemented Oracle financials, Manufacturing and Distribution modules
• Technical Lead and lead architect
• Implemented Backups and Restore procedures
• Configured Printers, right fax with Oracle Applications
• Upgrade 11.0.3 to 11i at later stages
• Configured Workflow for notification mailer
• Worked on all upgrade issues with team and resolved in timely manner
• Automated all hot and cold backup scripts and emailing any failed procedures to the DBA team
• Production support
• Provided training to internal team

Confidential, West Mont IL

Oracle Apps DBA

Oracle Apps 11.0.3 and istore on Sun Solaris

Responsibilities:

• New Implementation of Oracle Applications 11.0.3
• Implemented Oracle financials HR, Distribution, istore and ipayments
• Install and configure Oracle Applications on multi node architecture
• Patching and cloning the instances as part of maintenance
• Team member of the DBA group
• Configured Vignette content management system and integrated with Oracle Applications
• Worked with Cybercash payment system for credit card integration with iPayments
• Development support to the team members

Confidential, Dayton OH

Sr. Consultant

Oracle Apps 11.0.3 on Sun Sparc and Windows NT

Responsibilities:

• Design and Develop conversions, Interfaces, Reports
• Importing Items, Categories, Customers, Suppliers into Oracle
• Implemented new module called membership using Oracle Forms
• Worked on various reports and forms
• Designed and developed Shop Floor reports
• Worked on various reports in Oracle Demanding and forecasting
• Designed and developed new module Membership using Oracle Forms

Confidential, Champaign IL

Sr. Consultant

Oracle Apps 10.7SC on HP UNIX

Responsibilities:

• New Implementation of Oracle Applications 10.7SC
• Implemented Oracle Manufacturing and Financials
• Design and develop various conversions, interfaces, reports and extensions
• Worked on Oracle Configurator (ATO and PTO)
• RMA’s and Label printing solutions with Oracle
• Custom SQL code for ATO orders

Confidential, Boca Raton FL

Sr. Consultant

Oracle Apps 10.7 on HP UNIX

Responsibilities:

• New Implementation of Oracle Applications 10.7
• Implemented full suite of Application which includes all manufacturing modules
• PO Conversion, Approved Suppliers conversion, item Conversion, Auto Invoice Import, Suppliers conversion and Orders import to Oracle
• Worked on reports. Forms and extensions using Oracle forms 2.3 and reports 2
• Worked on WIL, INV and BOM modules extensively

Confidential, SFO

Consultant

Oracle Apps 10.7 on HP UNIX

Responsibilities:

• New Implementation of Oracle Applications 10 5 character
• Installed and Maintained Internal Servers
• Trained internal consultants on Applications
• Sizing of the database and hardware configurations for Oracle Applications

Confidential, Cleveland OH

Consultant

Oracle Apps 10.7 on HP UNIX

Responsibilities:

• System Administrator
• Configured Printers, and maintain Concurrent managers shifts
• Production support
• Troubleshooting the daily issues and resolved
• Created new reports and customized forms per requirements

Confidential

Consultant

Oracle Apps 10.7 on HP UNIX

Confidential

Sr. Architect

Oracle 7, Power Builder, Delphi and SCO Unix

Confidential

Consultant

FoxPro on Windows