Objective

• To work as results - driven Oracle Applications EBS Project Manager/Architect with versatile, cross-platform experience and proven success in managing multimillion/critical Financials EBS system rollout to highly demanding clients & business.
• Decisive, Action oriented, result focused Sr. Project Manager offering 12+ years of experience with comprehensive strategic planning and implementation skills in IT industry focused on project management and Leading the team for various Oracle Applications Implementation, Upgrade and Migration Projects with a very strong history of turning "Break Even" projects into profitable projects through delivery of cost saving solutions & designing process enhancements.

SUMMARY

• Over 12+ Years of rich experience working as Oracle Applications EBS Project Manager/Architect & DBA (Oracle Server 7.x, 8.0.5, 8i, 9i, 10g, 10g RAC) with a multiple/cross platform experience on UNIX (Solaris 5.8/10, IBM AIX 5.2/5.3, HP-UX, Linux Red Hat, SUSE and windows).
• Over 6+ years of productive experience in Financial Industry serving as Senior Oracle Apps DBA/Tech Lead/Architect working on Financial, HRMS, CRM, self service Banking, EAM, iProcurement on multiple versions of Oracle Applications e-Business Suite (11.0.3, 11.5.4, 11.5.5, 11.5.8, 11.5.9, 11.5.10(11i) & Release 12 (12i 12.0.4, 12.1.2), working as Tech Lead for Stress Testing/benchmarking Oracle Applications Production Systems and Oracle Enterprise Data Warehouse, BI integration with 11i Oracle Applications and EPM 8.9, effectively leading and planning a 24*7 support across Dev, Business, Functional and Reporting teams.
• Strong Project, Technical & Resource Management skills. Highly efficient in Project initiation, Project planning, risk & issue management, coordinating QA testing followed by meeting in-Time Project deliverables & Deadlines. Outstanding communication skills with an ability to build strong working relationship with business, development, functional and other corporate clients. Expert in creating & implementing technical and operational plans, prioritize projects, requirement analysis and a very strong problem solving skills.

TECHNICAL SKILLS

Hardware: IBM AIX p595, Sun v440, v480, v490, 280R, v660, v880, v890, Sun 25K, HP9000,Veritas Clusters, EMC SRDF, Cisco/Big IP/3DNS Load Balancer

Operating Systems: IBM AIX 5.3/6.1, Sun Solaris 8, Linux RHEL3, Linux RHEL4, Suse SLES9, HP-UX 11.0,X-Windows, MS-DOS, Windows NT/2000, Digital Unix 4.0b, CentOS 4.0

Database/ DB Tools: Oracle Database (7.x, 8.0.6, 8.1.7.1, 8.1.7.4, 9.0.2, 9.2.0.5, 10g),Oracle Data Guard(Standby Database), 10g RAC Real Application Clusters, RMAN, ASM,SQL Backtrack, Oracle Enterprise Manager (OEM Grid Control), SQL Analyzer, Space Manager, PL/SQL, Toad, Quick IO, Quest SharePlex, Schema Manager, EDW 4.0, OWB 9.2.0.4, ETL

Middleware/Application Server: Oracle Application Server Portal (3.0.9.8.3, 3.0.9.8.4, 9i, 10.2.0.2, 10.1.4 10G Portal), Oracle Single Sign On (SSO), Oracle Internet Directory OID, LDAP, Oracle Identity Management OIM, Oracle Application Server 10G AS Repository/Infrastructure,Oracle Discoverer (3.x, 4.1.44, 4.1.48 4i, 9.0.4.44 9i & 10.2.x 10g), Discoverer Administration (9.0.4, 10.1.2, 10.2.0.2), Discoverer desktop (9.0.4, 10.1.2), Jinitiator, JRE,SQL*Forms(4.5, 3.0, 2.3, 6i), Reports (1.1, 2.0, 2.5, 4i, 6i), Oracle WebDB, iAS 1.0.2.2.2, Apache, Oracle Workflow, WEB ADI, XML Publisher, OAM, Oracle Alerts, Oracle Mail, Unix Shell Scripting, Cron processes, SQL Scripting, C, csh, ksh, HTML,Java, XML

PROFESSIONAL EXPERIENCE

Confidential, New York

Oracle Applications EBS Manager/Architect

Responsibilities:

• Managed and lead a team of Oracle E-Business Suite/Application DBAs for a critical 24*7 Financials EBS R12 System
• Work as liaison between Functional/Development/System Administration teams
• Define Technology Road Map to meet Short Term, Interim and 5 Year Goals
• Collaborate with Senior Management, Project development, functional & business and define EBS R12 upgrade & maintenance Road Map
• Managed Project Review and implemented technology standards, reducing redundancy and saving more than $200,000 annually on maintenance cost.
• Create a predictable Yearly Plan for the Oracle Application Technology Needs
• Managed & Implemented 5 major upgrade projects (Upgrade R12 Oracle Applications to R12 12.1.2, Discoverer to 10.1.2.2, Single-Sign-On 10.1.2.2, R12 Database to 11.2.0.1 & 10.2.0.4, Upgraded Oracle Grid Control to latest Management Pack and database to 10.2.0.4)
• Managed, Architected and migrated an Oracle Application Server 10.1.2 OLTP application from windows to Linux Platform as a fix to frequent hangs to the application as a 100% High Available and Disaster Recovery Solution.
• Clearly define Project Plans and Lead Team by incorporating Resource Plan, various stages of project lifecycle, defining Milestones, Estimate/allocate realistic Budgets & track the project to completion by providing weekly, Bi-Weekly Project Status reports
• Risk analysis & Crisis management during the project implementation
• Excellent Process improvement, root cause analysis & problem solving skills
• Successfully managed a very reactive, Issue prone DBA Team supporting R12 Oracle Applications and turned it into a productive, result driven & proactive team.
• Managed various projects using Scrum and Six Sigma techniques by keeping the Budget well under control and delivering Projects on time.
• Managed a very timely and effective conflict resolution plan to keep team motivated between busy schedules and by breaking internal and external silos.
• Managed, Architected & Implemented a 100% Disaster Recovery solution for R12 12.0.3 Oracle Applications and Database.
• Effective performance reviews and defining career path for the direct reports keeping them motivated for the next challenges

Confidential, Cleveland, Ohio

Oracle Applications Architect/ Tech Lead

Responsibilities:

• Managed & implemented 7 Node Single Sign On solution by integrating 3 Node E-Business Suite 11i 11.5.10 & R12 12.0.4 system with 4 Node Oracle 10g Application Server SSO/OID Load Balanced environment using Cisco Load Balancers and Multi Master Replication for Database, Oracle Internet Directory OID High Availability and failover.
• Managed the implementation of latest E-Business Suite Release 12 (12.0.4) Applications with Oracle Database 11g 11.1.0.7 RAC & ASM solution for China Project
• Led the upgrade of Production system to the latest HR/FA/ATG Patch set levels
• Lead an effort of Analyzing, identify Security threats/vulnerabilities for Oracle Database & Applications
• Extensively involved in performance tuning and problem solving activities
• Upgrade Oracle Applications 11.5.10.2 to use JRE & Jinitiator 1.3.1.29
• Address & Fix major Performance Issues for Oracle Apps 11.5.10.2 on 10g RAC
• Address various issues related to 10G RAC, VCS Veritas Clusters, Voting Disks & OCR
• Extensive involvement with installing, configuring, cloning & administering 10g RAC Database with VERITAS Cluster & ASM
• Analyze & Design the Oracle Applications AS Portal & BI Architecture
• Extensive Performance Tuning on 7 Node RAC based Oracle Applications 11.5.10.2 system
• Address, define & Implement Cloning Procedures for Oracle Applications 11.5.10.2 on RAC
• Address, define & Implement Patching/Maintenance Procedures for Apps 11.5.10.2 on RAC
• Lead the EAM/HRMS/FA upgrade implementations effort to Production
• Analyze, Research & Implemented a fix to a major RAC cluster & Server crashes on Oracle Applications e-Business Suite 11.5.10.2 Production & Development Systems
• Analyze & Architect a long term Oracle Applications Infrastructure strategy - In Progress
• Upgraded Oracle e-Business Suite from 11i (11.5.10 HRMS & Financials) to R12(12.0.4)
• Configure Applications Management Pack 2.0.x with OEM for e-Business Suite monitoring

Confidential, Tampa, Florida

Technical Lead / Senior Oracle APPS DBA

Responsibilities:

• Managed & led Stress Testing and Performance benchmarking efforts for Oracle Applications 11.5.10 RUP2 OLTP Production system.
• Worked with various teams to define a clear Road Map for Regression Testing cycles
• Worked internally & externally between teams to better manager resources
• Team Lead for the overall management of Enterprise Database Warehouse Project
• Team Lead for Oracle Business Intelligence Discoverer Integration project
• Tech Lead for Oracle 10G Application Server BI Integration with EPM 8.9
• Upgrade Oracle Applications e-Business Suite 11i (11.5.10.2 & 11.5.9) to Release 12 (12.0.4)
• Integrate Oracle Applications e-Business Suite R12 with Oracle Portal/Discoverer using Oracle Internet Directory OID/LDAP & Oracle Identity Management
• Implemented Shared Appl Top with e-Business Suite R12
• Upgraded Oracle Applications to 11.5.10 and migrated to Shared Apps Tier Architecture
• Architected the complete infrastructure for the optimal performance of Shared Apps Tier integration with Oracle Applications 11.5.10
• Architected the complete life cycle of 10G AS Portal/OID/LDAP/SSO with Oracle Apps 11i (11.5.9 & 10) for the scalability of OLTP Production system with 20,000+ users of workload
• Defined OID Cloning process with Oracle Applications 11i
• Defined a complete 10G Portal Cloning Process with Oracle Applications 11i
• Expertise in OID, LDAP and SSO (Single Sign On) implementation and maintenance
• Defined 10G Portal 10.1.2 Implementation procedures with Oracle Applications 11i and trained the team
• Oracle Database 8.0.6, 8.1.7.4, 9.0.2.x, 9.2.0.2, 9.2.0.3, 9.2.0.5
• Configured Data Guard for providing high availability solution for Database
• Cloning, Backup and Recovery of Oracle Database
• Fine Tuning Oracle Wait events, Tuning sorts/temp segments
• Maintaining Hit ratios of Oracle Database for optimal performance
• Identifying top sqls/sessions and tuning
• Fine tuning datafile waits and I/O
• Monitoring and troubleshooting top cpu/memory consuming processes
• 24*7 Production Support including US and other countries across the Globe
• Oracle Applications 11.5.4, 11.5.5, 11.5.8. 11.5.9 & 11.5.10
• Extensive experience in cloning and configuring Oracle Applications using Adclone, Adconfig and Rapid Clone .
• Fixed Assets, Accounts Payables, General Ledger, Procurement, Self Service
• Implemented and Configured Multi Languages in 11i Oracle Applications Production system e.g. Polish, Dutch, French, German etc.
• Installed and Configured Dutch, Portuguese, French, German, Latin America Spanish, Polish etc Languages for Portal
• Experienced in working with Single Byte and Multi Byte Character Sets including UTF8
• 10G Application Server 9.0.4.0.0, 10G 9.0.4.0.0 and 10G 10.1.2.0.2
• Installation and Configuration of 10G Portal with Oracle Applications 11.5.9
• Implemented 10G Web Cache with Oracle Portal and Discoverer for Performance
• 10G Infrastructure and Repository
• 10G Discoverer Standalone and with 11i e-Business Suite
• Configured 10G Oracle Applications Middle Tiers for Portal and Reports with 11i
• Configured 10G AS Portal, SSO, OID with third Party Single Sign On product (Netegrity Siteminder)
• Load Balancing 10G Middle Tiers for high availability and COB
• 10G WebCache Clustering and Middle Tiers Clustering
• SSL configuration with Oracle Applications (all 11i releases) 10G AS and WebCache
• Enterprise Manager Console, Oracle Process Manager,

Confidential, Buena Park, CA

Oracle APPS DBA

Responsibilities:

• Complete cycle of implementing 11i
• Completed Upgrade from 10.7 to 11i
• Completed upgrade from 11.0.3 to 11i
• Installing, Upgrading, Patching and Managing Oracle Applications 10.7, 11.0.3, 11.5.6(11i) Tuning Concurrent Managers, Defining Work Shifts, etc.
• Registering new forms, reports etc.
• Using utilities like adpatch, adadmin, adctrl, adaimgr, etc.
• Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i, 9i).
• Installing and configuring Recovery Manager.
• Installation and configuration of IAS 2000, 9iAS, Apache and Oracle Portal.
• Used Designer 2000 for database design.
• Built the ETL stage using Informatica Power Center
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
• Used Quest Shareplex for replicating databases.
• Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.
• Managing Veritas Clusters, I2 Implementation.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Working with Blobs and Clobs, Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Applying Patches both Server side and Client side.
• Cloning 11i databases.
• Setting up new environments (Development, Production etc)
• Upgrading to Oracle Server 7.3.4 and then to 8i.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Setting up Oracle Parallel server.
• Installed and configured Oracle Web Server 3.0
• Taking Hot and Cold Backups, Exports etc.
• Setting up and Installing Oracle Web Application Server
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Data Warehousing
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Setting up GLDI and Metaframe Citrix.
• Defragmentation of database using export import.
• Removing row chaining for better performance.
• Data Modelling, Database Design and Creation
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.
• Complete cycle, including development, testing, training and production,
• Implementation of 11.0.3/10.7 implementation.
• Installation, Upgrade, patching and managing Oracle Apps 10.7NC, Smart client and 11.0.3
• Tuning Concurrent Managers, Defining Work Shifts, etc.
• Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i).
• Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc
• Applying Patches both Server side and Client side.
• Used Designer 2000 for database design
• Cloning databases.
• Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
• Upgrading to Oracle Server 7.3.4 and then to 8i.
• Setting up advanced replication.
• Setting up Oracle Parallel server.
• Installed and configured Oracle Web Server 3.0
• Taking Hot and Cold Backups, Exports etc.
• Setting up and Installing Oracle Web Application Server
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Data Warehousing
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Defragmentation of database using export import.
• Removing row chaining for better performance.
• Data Modelling, Database Design and Creation
• Unix shell scripts (csh, ksh) for backup and recovery, Import and export procedure.

Confidential, Piscataway, NJ

Oracle APPS DBA

Responsibilities:

• Installation, Upgrade, Patching etc of Oracle APPS 10.5 Character based.
• Installation and Configuration of Oracle (7.1.6, 7.3.2.3, 8.0.5)
• Applying Patches both Server side and Client side.
• Copying databases.
• Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
• Upgrading to Oracle Server 7.3.2.3 from 7.1.6.
• Taking Hot and Cold Backups, Exports etc.
• Setting up and Installing Oracle Web Application Server
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords(security).
• Data Warehousing, Installing Oracle Applications Data warehouse
• Deciding the backup and Disaster Recovery Criteria
• Setting up Replication using Database Triggers and Stored Procedures.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Performance Tuning, Memory (SGA) Tuning, etc
• Data Modelling, Database Design and Creation
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Tables like parent child and master information are grouped to form clusters, Indexed or Hashed.
• Data base triggers are used to enforce the integrity constraint
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh

Confidential

Oracle DBA

Responsibilities:

• Developed E-R and data flow diagrams
• Performed Data Modeling and architected the data warehouse.
• Developed several stored procedures.
• Creation of database, tables, users, roles in Oracle7.0.
• Development of reports in Pro*C and ReportWriter 2.0 Security administration i.e. managing privileges and roles
• Backups and Recovery i.e. exports/imports, hot archieve log backups, cold offline backups, etc
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
• Space Management which includes table space creation, adding new datafiles,
• Creating rollback segments, etc. Shell Scripting in csh and ksh