SUMMARY

More than 15 years of experience in IT industry. Highly experienced ORACLE Technologist/ORACLE APPS DBA/ CORE DBA/ ORACLE 10g AS/ ORACLE Fusion Middleware/IDENTITY Management CONSULTANT/Oracle Security Consultant with exceptional systems development and implementation experience. Good working knowledge with UNIX/LINUX/WINTEL OS as system administrator. Well experienced with all phases of design, development, and implementation of software applications of all sizes.

SKILLS:

• Installation, Configuration, Administration, Upgrade, Performance Tuning of the following Oracle Suite of Technologies:
• Oracle E - Business Suite R12, 11.5.10 CU2 RUP6
• Oracle 10g AS, Oracle Fusion Middleware
• Oracle BI Architect/ Administrator using DISCOVERER, OBIEE, OBIA, DAC, Informatica
• Oracle Apex 3.x
• Oracle Identity Management OID and Single Signon SSO
• Oracle Identity Management Suite OIM, OAM, OID, OVD, OPAM, and OIF
• Oracle 10g/11g Database Server RAC and STANDALONE
• Oracle 10g/11g SOA Suite
• Operating Systems: Linux, Wintel, Unix Sun Solaris

EXPERIENCE:

Sr. Oracle Consultant/Architect CONFIDENTAIL

Major Accomplishments:

• Created an Enterprise Architecture for Defense Security Cooperation Agency
• Implemented the Architecture by Installing Oracle Application Servers and R12 EBS
• Installed and Configured Oracle GRC
• Installed and Configured Oracle SOA/BPEL 11g
• Installed and Configured Oracle IDM Suite 11g
• Integrated OAM 11g and OIM 11g with EBS R12
• Setup ACTIVE/ACTIVE IDM 11g across Data Centers.
• Implemented Integration with Active Directory and KERBEROS authentication
• Implemented Secured transactions using XML Encryption, XML Signature, and Secure Access Markup Language SAML
• Installed and Configured OBIEE 11g, DAC, Informatica
• Installed and Configured R12 EBS
• Installed and Configured Oracle Tools like UPK, OPA, etc for Operations.
• Patched, Maintained, and Performance Tuned all of the Applications and Databases.
• Installed Security Patches for the Environment.
• Worked with the Security Team for ATO for DSCA.

Sr. Oracle Consultant/BI Architect CONFIDENTAIL

Major Accomplishments:

• Implemented a Comprehensive BI Architecture by combining disaparate systems into one.
• Upgraded OBIEE 10g to OBIEE 11g including customizations and skins
• Created BI DataWarehouse Schemas within the Database and populated Data
• Created custom ETL scripts to populate data from the source systems
• Created New Reports in BI Publisher for the end-users
• Maintained Databases on a daily basis - including backups, performance tuning, and Administration
• Provided Support to Developers on a day-to-day basis
• Administered Oracle Fusion Middleware and OBIEE platform
• Deployed applications, configured OBIEE, and managed Catalogs.

Sr. Oracle Consultant/Software Engineer

CONFIDENTAIL

Major Accomplishments:

• Implemented Enterprise Architecture of Hardware and Software for MHS.
• Implemented Identity Solution for NICoE using Oracle Identity Manager
• Created workflows in Access Manager to handle two level approval process for accounts.
• Implemented Single Sign-on by configuring SIEBEL, OBIEE, SOA, WEBCENTER, UCM and 10.x and 11.x Oracle Application Tiers.
• Architected and Developed Oracle SOA B2B solution for handling HL7 Messages
• Successfully managed the DOD DIACAP process and mitigated risks for ATO.
• Configured OBIEE/OBIA/DAC/Informatica and ran ETLs for Reporting
• Protected Resources using Oracle Access Manager
• Collected Requirements and converted these to Functional Requirements
• Configured Reverse proxy solution for the System.
• Installed R11 E-Business Suite HTB and Upgraded this version to R12 Version of E-Business
• Configured and Administered R12 E-Business Suite HTB Health Transaction Base module.
• Applied Patches, Maintenance of R12 E-Business Suite.
• Performance Tuned R12 E-Business Suite utilizing R12 JConsole, OAM
• Sr. Oracle 11i Apps/Database Consultant

CONFIDENTAIL

Major Accomplishments:

• 11i Apps DBA for more than fifty six 11i EBS instances on Oracle RAC
• Applied Patches using ADPATCH, ADMERGE, and OPATCH
• Cloned PROD To several NON-PROD Instances
• Created Documentation for Several Projects
• Researched and applied Several Patches for the 11i OTL Functionality
• Performance Tuned the System
• Installed, Configured, and Administered Oracle Identity Management
• Configured SSL for OHS, and SSL for SSO
• Configured SSO and OHS for CAC Authentication at DOD
• Loaded Users, and managed users using Bulkload, ldapmodify, ldapsearch utilities
• Created Certificate Requests and Installed Certificates using openssl and orapki utilities
• Integrated EBS 11i with SSO/OID on several NON-PROD Instances
• Configured DIP to access Windows active directory for synchronization of User Accounts
• Installed SOA/BPEL and involved in Upgrade, and Patching.
• Installed CRS, ASM, and the 11g database RAC and applied patches and upgrades
• Administered ASM using asmcmd and at the instance level
• Administered DiskGroups in ASM and added and dropped disks
• As a Core DBA, wrote rman backup scripts to duplicate several databases.
• Worked on Several day-to-day tickets involing Core and 11i Expertise.
• Implemented Database Auditing on all Databases
• STIG the databases and Application as part of Information Assurance
• Architectected REVERSE PROXY and DMZ for 11i APPS.

Sr. Oracle 11i Apps/Database Consultant

CONFIDENTAIL

Major Accomplishments:

• Implemented RUP4 and RUP6 in the 11i Apps Environment.
• Applied patches using ADPATCH, ADMERGE, and OPATCH
• Changed the MDS repositories in 11i for custom Personalizations
• Administered 11i using context files, FND PROFILES, and JSERV properties.
• Implemented DMZ for 11i APPS
• Implemented ROW LEVEL SECURITY using VPD policies
• Upgraded the Database from 9i to 10g in 11i apps environment
• Installed, Configured, and Administered Oracle Identity Management
• Configured SSL for OHS, and SSL for SSO
• Configured SSO and OHS for CAC Authentication at TSA
• Loaded Users, and managed users using Bulkload, ldapmodify, ldapsearch utilities
• Created Certificate Requests and Installed Certificates using openssl and orapki utilities
• Integrated EBS 11i with SSO/OID on several NON-PROD Instances
• Configured custom notifications using 11i Workflow
• Installed, configured, administered DTE environment DEV env for TSA .
• Implemented Security by using the UMX module of 11i apps
• Created IZU module for Oracle Diagnostics Pack.
• Implemented and monitored DIP process for synchronization of LDAP with 11i
• Installed, Configured, Administered, and trouble shooting of Discoverer 10g with 11i Apps
• Implemented DST Daylight Savings Time patching in the 11i Environment
• Configured and Maintained Load Balancers F5 for 11i environment
• Configured and Maintained 10g Web Cache for the 11i Environment.
• Installed, Configured, Administered REVERSE PROXY for the OC4J Environment
• Installed and configured 10g RAC Databases for US CENSUS Project
• Installed and configured 10g AS Application Tier and Infrastructure Tier
• Created RMAN Scripts for backup and Restore
• Maintained 24x7 support for Production Databases as a Production On-Call 11i Apps DBA
• Deployed EAR files in the 10g AS apps tier using dcmctl and opmnctl utilities
• Configured the OC4J Containers by configuring opmn.xml and app.properties files
• Monitored Apache, opmn, site, and 11i Jserv logs for 10g and 11i Application issues
• Implemented PHYSICAL AND LOGICAL STANDBY Database for 11i
• Created Custom Concurrent Processes for 11i Processing
• Installed, configured, and Implemented TIBCO applications
• UPGRADED from Applications 11. 5.7 to 11.5.8 to 11.5.9 to 11.5.10
• CLONED Multi-Node to Single Node and vice versa
• Implemented CUSTOM TOP for Several Organizations using ADSPLICE utility.
• Database migration from SQL Server/ Sybase to Oracle
• Setup FAILOVER, SWITCHOVER, and Disaster Recovery using Oracle Data Guard
• Managed a team of DBAs, Data Analysts, Database Developers
• Installed and configured Apex 3.0 previously HTMLDB
• Worked on OA Framework and DQM Framework
• Configured and Used ORACLE FLASHBACK Technology
• Proficient in AWR, ASH, ADDM, EXPLAIN PLAN, PARTITIONING, PARALLEL PROCESSING
• Employed Business Continuity Plan and Disaster Recovery Plan in to the System.
• Installed, Configured, Administered Oracle Application Express -APEX formerly HTMLDB, OID SSO, Oracle SOA Suite, Oracle 10g AS, Oracle E-Business Suite, BOXI Crystal Environment, Oracle GRID, ORACLE OBIEE for 11i

Sr. Oracle DBA/Oracle 11i Apps/Database Manager

CONFIDENTAIL

• Full Cycle implementation of Oracle Applications 11i
• Configured Oracle Financial application settings and options GL, FA, AR, AP
• Setup Development, Testing, Staging, and Production ORACLE APPS Environments
• UPGRADED from Applications 11. 5.7 to 11.5.8 to 11.5.9 to 11.5.10
• Setup Multi-Node and Single Node 11i midtiers using cloning methodologies
• Applied PATCHES using ADPATCH and OPATCH
• Implemented CUSTOM TOP for Several Organizations using ADSPLICE utility
• Migrated databases from SQL Server/ Sybase to Oracle
• Implemented FAILOVER, SWITCHOVER, and Disaster Recovery using Oracle Data Guard
• Capacity planning for the Oracle Applications 11i, Oracle 10G/9i/8x Database Server
• Implemented Oracle GRID.
• Migrated Databases to 10g RAC.
• Installed, Configured, and administered DISCOVERER for Business Intelligence
• Worked as System Administrator on Unix and Linux.
• Performed Backup Recovery of Databases using RMAN and NETBACKUP
• Created and Executed change management Scripts using Oracle Change Management Pack.
• Managed a team of DBAs, Data Analysts, Database Developers
• Worked with FEMA on Disaster Recovery efforts for KATRINA and RITA
• Restored the FAA environment when NEW ORLEANS went under water.
• Migrated FAA to the new FPPS Payroll System
• Created Datawarehousing for the National Offload Program
• Setup Oracle Internet Directory and LDAP for Air Traffic Quality Assurance
• Installed 10g A, configured Application Server, and deployed Application EAR files
• Configured OID and configured SSO for applications
• Installed and configured Apex 2.x previously HTMLDB

Sr. Oracle 11i Apps Database Consultant

CONFIDENTAIL

• Maintained HR and Payroll E-Business 11i APPS Environment
• Worked on OA Framework and DQM Framework
• Monitored and implemented health checks in the environment
• Provided Production On Call DBA 24x7 support
• Cloned Application Tier and the Database Tier to the Testing Environment.
• Helped in the ETL of Legacy data into Oracle
• Created Data marts and Dashboards for the Captain
• Installed, configured, Administered Sun Solaris 9.x and Oracle Instances
• Implemented Backup and Recovery of the databases using RMAN.
• Installed EBS 11.5.9 using RAPID WIZ
• Applied Patches to the 11.5.9 E-Business Suite using ADPATCH utility
• Cloned Applications using RAPID CLONE
• Performance Tuned the Application Tier for better response Times
• Created Logical and Physical Datamodel for Datawarehouse Project
• Supported Crystal Enterprise Development Environment

Sr. Oracle 11i Apps/Database Consultant

CONFIDENTAIL

• Installed 11.5.9 using RAPID WIZ
• Applied Patches to the 11.5.8 E-Business Suite using ADPATCH utility
• Implemented, Integrated, Upgraded and Supported projects for Financial and Distribution modules of Oracle E-Business Suite. Proficient in procure to pay cycle.
• Proficient in AIM Methodology, involved in requirement gathering, preparing functional and technical design documents and preparing test case scenarios.
• Good functional knowledge on procure to pay cycle and business processes.
• Extensive experience in documentation and training end-users.
• Experience in Oracle Forms, Oracle Reports and PL/SQL.
• Strong perseverance and diligence towards attaining challenging goals and effective time management.
• Migrated 11.5.8 to 11.5.9 Applications
• Cloned the production in the test environment
• Supported Highly visible Disclosure and Registration System
• Lead for a Team of Very Experienced DBA Group
• Maintained Four different systems TEST, QA, STRESS, and Production Systems
• Desinged Logical and Physical Data Model using ERWIN
• Helped in the design of DATAWAREHOUSE and DATAMARTS for Business Intelligence
• Initiated and Implemented DB Standards in coding and Object Naming Conventions
• Fine Tuned PL/SQL, Stored Procedures, and implemented Innovations in Coding
• Applied Oracle Patches as soon as they are released
• Worked with the Application Developers in resolving issues

Sr. Oracle Database Consultant CONFIDENTAIL

• Supported Highly visible Top Secret Project for FAA Federal Aviation Administration
• Implemented an ARCHITECTURE for a redundant, robust, failover system.
• Created and maintained a redundant Hot Standby Database Server using oracle Datagaurd.
• Formulated a Backup and Recovery plan for the Production database using RMAN
• Employed Business Continuity Plan and Disaster Recovery Plan in to the System.
• Developed PL/SQL scripts, Procedure, Triggers, Packages.
• Created and collected Stats using STATSPACK on a daily basis.
• Provided Admin Support to the system Administration on UNIX.
• Migrated Oracle 8.1.6 to 9i Version 2 to 10g RAC.

Sr. Database Architect/Administrator

CONFIDENTAIL

• Supported Highly visible Top Secret Oracle Database in Production Environment.
• Provided Architectural improvements to the Production System
• Implemented a Robust Architecture to support from 4 million to 8 million Transactions.
• Planned and Implemented redundancy and extensibility to the entire Production Architecture.
• Implemented Backup and Recovery for the production database using RMAN.
• Employed Business Continuity Plan and Disaster Recovery Plan in to the System.
• Re-defined database storage using Partitioning of Tablespaces.
• Developed Applications using PL/SQL Procedure, Triggers, Packages
• Installed, Configured, Administered Oracle Workflow using Advanced Queues.

Sr. Database Architect/Administrator

CONFIDENTAIL

• Installed Linux Advanced Server 3.1
• Installed and Administered Informix Database on Linux
• Worked on ATF American Tobacco and Firearms Project for Department of Justice
• Worked on United States Courts System for Department of Justice

Sr. Database Architect/Manager

CONFIDENTAIL

• VREPS A Project for six major networks ABC, NBC, FOX, CBS, CNN, AP
• Architected and implemented OBJECT ORIENTED ORACLE DATABASE.
• Designed Business Intelligence Data Warehouse.
• Provided Unix System Administration support for Sun Solaris 8.x Servers
• Worked as Team Lead for the database group and System Administration group.
• Administered PVCS and managed the builds for every iteration.
• Installed, Configured, and Administered Oracle Database Instances as DBA
• Tuned the database using Stats Package
• Installed, Configured, and Tuned SHAREPLEX software.
• Load Tested SQL using BENCHMARK FACTORY.
• Initilized DATA JUNCTION and custom ETL scripts in complex data migration
• Implemented VERITAS HA and SHAREPLEX HA solutions
• Administered EMC Navisphere and Veritas HA for Oracle

Sr. Database Administrator/Architect

CONFIDENTAIL

• Provided Database Architecture, Administration, Disaster Recovery plan for the Databases for:
• SQL Server DBA support to Travel Planners E-Commerce Portal Project.
• Unix System Administration support in setting up the Development Environment for Projects.
• Provided Sys Admin support to WEBLOGIC, BROADVISION, and ORACLE.
• Information Resources Consultant/Application DBA CONFIDENTAIL
• Administered PVCS for Code builds and Version Control
• Implemented Business Intelligence Warehouse for Marsha Online Reservation System.
• Installed ORACLE GATEWAYS to IBM MQSeries Applications.
• Provided ORACLE DBA support for SAP R/2.
• Administered Development HP-Unix Systems as System Admin.
• Performed Database Design, Development, and Performance Tuning as ORACLE DBA
• Designed database using ERWIN.

Project Manager/DBA

CONFIDENTAIL

• Performed Project Management for a Development Team of Six Personnel
• Created and Maintained ORACLE 7.2.3 DATAWAREHOUSE.
• Designed Logical and Physical Databases using PowerDesigner and ERWIN
• Used extensively ORACLE SQL Loader and EXPORT/IMPORT.
• Performed DBA work on ORACLE and SYBASE.
• Performance Tuned on ORACLE 7.2.3 and SYBASE 11.x
• Performed Daily Back up and Recoveries for both Engines.
• Provided Business Intelligence Warehouse/DBA Support for Reseller Management System:
• Worked as SYBASE DBA for support on Telephone Billing and 24x7 Customer Service.
• Implemented SYBASE to ORACLE ETL and DBA support for Account Aging System:
• Sun Solaris System Administration Support for various projects.

Systems Analyst

CONFIDENTAIL

• Designed and Implemented Full Life Cycle Development with constant interaction with Clients.
• Designed and Reengineered databases using ERWIN.
• Maintained Oracle and Sybase Databases as DBA
• Installed Software, and Provided Technical Support.
• Managed Files using Consistent Standards and Procedures.