SUMMARY:

• Certified Oracle Exadata Professional, Oracle Systems Master and Oracle Excellence winner of 2014 with extensive technology experience within professional services including: life cycle of implementation, management, business process analysis / reengineering, software and hardware evaluation / implementation, security and providing end - to-end solutions. Exceptional skills in building relationships with upper-level decision makers, seizing control of problem areas and delivering on customer commitments and company targets. Proven ability to consistently improve profitability, exceed customer expectations and build motivated teams. Competence in a variety of roles including Exadata DMA, Oracle DBA, Program & Project Manager, Solutions Architect, and Consultant.

TECHNICAL SKILLS:

Oracle ERP Applications: Oracle ERP Version 10.7SC to 12.1.3 Tuning of Middle Ware configuration Implementation of Financials, Grants Accounting, Procurement, I*Store, eAM, Oracle Assets, HR, Order to Cash, CRM, Oracle Manufacturing, Bar Code scanner, pick slips, inventory, and transportation Troubleshooting the functional issues of Oracle: Financial Modules, Grants Accounting, I*Store, eAM, Oracle Assets, I*Procurement and Workflow related issues System Administration and Workflow OAM, SSO and Discoverer integration 11g OEM Grid Integration with ERPSoftware: 11g /12 C OEM Grid, Quest Software, Compuware, SP SAP ERP (all modules) SharePoint and all change mgmt control software Microsoft Office, Microsoft Projects, Microsoft VisionStorage / OS: EMC, HP - EVA 8000, Implementation of HP-Proliant C-Series Blade and Management Server, HP-Data Storage Linux Enterprise update 5, HP-Unix, Sun Solaris, IBM-AIX and MS windows

PROFESSIONAL EXPERIENCE:

Confidential - Chicago

Oracle Architecture Specialist

Responsibilities:

• Re-hosting project, migrated the database from IBM-AIX to Exadata
• Upgrade strategy databases from 11.2.0.4 to 12c
• Upgrade the databases
• Migrated the critical databases from P5 frame to P8
• Implemented the strategy for testing and performance tuning of database with RAT
• Build up the dataguard server
• Support critical database 24x7
• Upgrade the grid and Oracle databases on Exadata with Rolling
• Applied the Oracle e-buisness RUP 8 on 12.1.3 application and also upgraded the database too
• Upgrade the Oracle e-business from 12.1.3 to 12.2.0.4 in Testing environments and support
• Reviewed the existing infrastructure of Oracle e-business database, Oracle OBIA database and gave recommendation for best practice implementation.
• Tuned the OBIEE and OBIA 7.9.6.4
• Installed and implemented the OBIEE 11.1.1.7.1 and OBIA 11.1.1.8.1 on AIX server.
• Tuned the Oracle e-business suites.

Confidential - Arlington Heights, IL

Exadata DMA & Infrastructure Architect

Responsibilities:

• Infrastructure and architect specialist to Oracle databases
• Upgraded the database from 10g to 11g with 12-C ASM Grid
• Implemented the 12-C OEM for monitoring the Gird, Oracle and SQL*Server databases
• Proposed the solution for Oracle database consolidations and Hardware on Exadata server
• Implemented the cage architecture for OLTP and OLAP databases on Exadata
• Implemented the hybrid column compression for data warehouse databases
• Implemented active Data Guard from Exadata to non-Exadata machines for the DR solutions
• Tuned the queries and databases
• Implemented the full lifecycle for firmware, patching on OS Linux, Oracle databases, storages with rolling forward
• Implemented Hyperion, Business Analytics, OBIEE and OBIA
• Configured and tuned the application layers
• Implemented and upgraded the lifecycle for Oracle e-business from 12.0.0 to 12.2.4.x
• Worked closely with CIO and Business team to implement the new modules of Oracle E-Business, Oracle Assets Tracking and Enhancement
• Responsible for troubleshooting complications with existing applications
• Involved in implementation of Full Life cycle of Oracle Financial Modules GL, AP,AR,Order to Cash, Procure to Pay, eAM, Inventory, Grants Accounting, i*Store, HR-Core, Oracle Time and Labor, i*Recruitment, CWB and Fixed Assets.

Confidential - Chicago, IL

Oracle Technical Team Lead

Responsibilities:

• Implemented RAC on SUN SPARC with RAW devices and ASM
• Converted non-RAC database to RAC Dataguard, HA Solution, implemented re-org, patching strategy, backup and recovery plan and implementation
• Implemented the Oracle CRM, I*store, HR, Order to Cash, ERP Financial and Core databases, including HA solution
• Managed team of 10 DBA’s
• Managed offshore team ensuring documentation is up to date and work is done smoothly
• Implemented backup and migrated database from Window non-RAC to Linux RAC
• Fixed the major performance tunings issue on RAC and mentored the 5 DBA

Confidential - Chicago, IL

Infrastructure Architect

Responsibilities:

• Implemented SAN and configured Febric Channel
• Implemented Storage Area HP-EVA 8000
• Implemented Oracle Unbreakable Linux 4.0 with 64 bits
• Designed the SAN configuration for RAC and ERP
• Configured the Infiniband card and bonding of Ethernet cards
• Implemented the RAC on Inifiniband (20gb/s) and bonding of Ethernet cards
• Implemented database 10g REL 3
• Implemented Oracle Release 12 ERP and rollup patch 4 and CPU
• Implemented HP-Proliant C-series blade and Management server
• Implemented HP-EVA and configure Storage using Command View
• Implemented Fabric Zone and Fabric Channel for Blade and connected to SAN
• Installed Unbreakable Linux 4.0, Discoverer and 10g Grid OEM
• Mentored for DBA/APPS-DBA/RAC to Pace Trainer
• Prepared calendar for Pace staff after analyzing skill level of Pace Staff
• Worked with architecture team to procure hardware
• Implemented the RMAN backup recovery and 10g SSO with ERP and Sync with MS-AD
• Developed standards for interfaces for the best performance of database
• Developed strategies for change request and release management
• Provided scheduling and project management for technical team
• Coordinated with internal customers (Users) and external vendors (HP/Oracle).

Confidential - Chicago, IL

Senior Oracle Apps DBA Lead

Responsibilities:

• Part of Architecture team to select the product of Archival and Purging process
• Designed the monitoring and pro-active monitoring system
• Worked on HR Security and supporting development and implementation team
• Worked on Production Support on Oracle financial, Demantra, Supply Chain, Discrete Manufacturing, MES, OM, Order to Cash, Quote to Order,
• Supported 9i Oracle RAC with 11.5.10 APPS
• Worked on 10g Application Server upgrade with High Availability solution
• Tuning of Discoverer customize reports
• Implementation of Portals
• Implemented Rollup Patches for ATG’H’ Financial Family pack ‘G’
• Upgraded the Apps database from 9.2.0.6 to 9.2.0.8. and the 10gAS from version 9.0.4 to 10.2.2.0
• Upgraded the Discoverer
• Worked on Noetix Software / Supported Remedy, TReqs, ECC and E*ROOM Docs
• Prepared the standards for documentation for Out-Sourcing team.

Confidential, IL

Sr. Oracle SAP DBA

Responsibilities:

• Worked as SAP Oracle DBA responsible for Backup Database with EMC BCV, Tuning the database, Cloning the database. Involved in Major Go-live for SAP Modules R3, SCM, B&W and having an exposure for SAP Basis.

Confidential - Chicago, IL

Sr. Oracle APPS Database Manager

Responsibilities:

• Prepared project plan and schedule of DBA’s
• Interaction with internal and external vendors
• Involved in Architecture group to select the product (RFP for HR, Archival Process)
• Implemented I*Procurement, Public Sector Budget, Oracle Financial
• Implemented SSL with I*Procurement and OATM
• Implemented Portal and Reverse Proxy Server in Q&A server
• Upgraded the family pack of 11.5.10 and database upgrade and Discoverer
• Tuning, Backup and Recovery
• Rapid Clone from RAC to Non-RAC
• Upgraded databases from 9i to 10g for Non-ERP
• Provided support to KRONOS Database and upgrade database 8i to 9.2.0.6
• Supported 20 non-ERP 10g databases

Environment: ; HP system with VERITAS Cluster and used BCV technology to clone database and application

Confidential - Downers Grove, IL

Sr. Oracle DBA

Responsibilities:

• Worked with very large database with minimum size of 200G to 800G database
• Team lead of High Availability system (team of 5 Sr. DBA’s) which include implementing 9iRAC on IBM-AIX with HCAMP Cluster, Data Guard physical and Logical Standby Database and implementation of 10G in testing environment
• Tuned database, installation of Database, Logical and Physical Design of Database for Data warehouse and customize application, RMAN Backup with VERITAS Netbackup, Creating standby database using RMAN duplicate Backup in Cloud Architecture Upgrading an existing database to Oracle 9.2.0.4 in Compaq HP TRU-64, IBM-AIX 4.3, and 5L

Sr. Principal Consultant

Confidential - Chicago, IL

Responsibilities:

• Troubleshoot Application and Data processing
• Backup and Recovery with RMAN, and implementation
• Standby Server and Data-guard Logical (9i Rel2 with all patches) for disaster recovery, using Logminer and Flashback to recover user’s errors
• Database tuning using Statspack, Oracle Enterprise Manager TOOLS and SQL*Tuning, writing Shell Scripting, Corn Jobs and AT, Data Transfer from (Oracle to Mainframe and MSACCESS and DBASE, SQL*Server to Oracle using Deployment of Application on Internet with Forms Server and Reports Server using 9iAS and configured Java Deployment
• Implemented Business Intelligent System
• Involved in development to enhance applications in FORMS and Reports 6i and Forms 9i and Reports 9i
• Involved in system study of financial applications, Testing Multi-Master Replication in 9i on platform SUN OS and Windows-NT and 2000
• Prepared all technical documentation and transfer knowledge to concerned officer
• Database support, enhancement and troubleshooting dedicated to OLTP applications Grants Management System, Police Citation System, 24x7 Ticket Sales Accounting Point (Touch Button Application) Implemented at Union Station (Metra), Risk Management System and Ticket Revenue Accounting System and Ticket Inventory System