SUMMARY:

• Database Manager and Oracle EBS R12 Applications DBA with over 15 years’ experience on large ERP and Data Warehouse implementations and Cloud migrations.
• Extensive experience and business knowledge in the Pharma and Life Sciences industry as well as in the Federal, Public and Commercial sectors. Project Team Lead and Cloud Architect for the design, development, and deployment of Business Applications using Oracle and SQL Server databases.
• Working knowledge of audit and SOX compliance as well as experience in Risk Control and Tolerance Analysis in complying with regulatory requirements. As a Database Manager at Confidential interfaced with the BI development team to provide the in depth knowledge of the Oracle ERP data model that is needed to write the complex sql queries for extracting data and building KPIs.

TECHNICAL SKILLS:

• Cloud ERP architecture and deployment for Oracle E - business suite 12.1.3/12.2.0.5/11 i/10
• Integration specialists
• Extensive experience with Oracle EBS 11i till R12.2 including installation, cloning, setup, system administration and custom integrations with other applications
• OAC and Hyperion administrator
• Oracle ERP migration from IBM hosting to OMCS, Data center to OMCS cloud & PeopleSoft from data center to OMCS and further OMCS to OCI cloud
• Oracle Fusion Middleware 11g & Oracle Application Server 10g (SSO, OID, OUD, LDAP, Access Management, Portal)
• Functional and business process knowledge for Oracle EBS Financials and Manufacturing, Purchasing, and Supply Chain ERP applications, experienced in helping business users resolve issues working with Oracle Support

PROFESSIONAL EXPERIENCE:

Database Manager

Confidential, Morristown, NJ

Responsibilities:

• Oracle ERP R12.1.3 upgrade to ERP R12.2.3 EBS with Oracle ERP on premise instance migration to Oracle cloud OCI in multi node instance
• Oracle Analytics cloud technical implementation on OCI and OAC administrator
• Change management process for deploying customization and enhancement by following SDLC including unit testing and owning identified issues and implementing its fixes across all instances using STAT tool
• Owner of developing of standardization as SOP for customizations for financials, HR, Inventory and procurement modules
• Support development team (access request in non-prod instances for application, database, unix putty ssh etc).
• Managing concurrent managers and concurrent requests (crontab scripts to identify long running requests and troubleshooting)
• Work closely with MSP using developed baseline for patch propagations, upgrades, performance tuning using alerts on database and severs
• Owner of instance management for Oracle ERP and DMS system instances
• Oracle Access manager (OUD) integration with 12.2.5 for single sign on
• MySQL database install for enterprise wide Implementation of Inductive automation systems
• Implemented & Integrated Power tax with Oracle ERP
• Implemented Pascale and Deal Management systems across 47 global plant sites (USA, Europe and Canada)
• Experienced with deploying, tuning and supporting Oracle, SQL Server and MySQL databases utilizing AWS, Azure, Rackspace and OCI Cloud environments
• Troubleshoot complex SQL server SSIS package configuration issues for ETL
• Integration lead for PS, ClickView, PowerBI, Powertax, ETL & Discoverer, DMS, CovMart
• Migrated Data center Databases and Applications to AWS cloud
• Confidential Integration lead and specialist & DM specialist. SME for DM & Integration architecture

Senior Oracle Applications DBA & SME

Confidential, Parsippany, NJ

Responsibilities:

• SME DBA lead for upgrading Oracle EBS 11.5.10.2 to R12.1.3 and Migrating EBS suite from IBM hosting to Oracle managed cloud service
• Implemented backup and recovery for Oracle and Peoplesoft databases using Tivoli and RMAN
• Primary lead responsibility to ensure the Avis Oracle database environments in compliance under SOX audit
• Implemented Oracle standards and best practices for security, data encryption, and established the access process for the AVIS Oracle databases containing customers PCI data
• Provided HRMS system administration, created global security profiles and responsibilities as required
• Oracle EBS R12 support and maintenance, cloning, patching, and monitoring as well as backup and recovery
• Implemented Oracle 11g Grid Control for database monitoring
• Hyperion Essbase and OBIEE Implementation
• SME for migration of Oracle R12 from IBM hosting to OMCS
• Oracle Fusion Middleware 11g SSO, OID, LDAP, Access Management and OID integration with OUD
• OID 11.1.1.5.0 migration to OUI for SSO tech stack upgrade
• Implemented audit process to capture monthly, semiannual and annual reports for sox & compliance

Sr. Tech Lead Oracle Applications

Confidential, Branchburg, NJ

Responsibilities:

• Technical implementation and support of Oracle database based applications Oracle business suite, Oracle Portal, Oracle SSO, Trackwise (Tracking deviation CAPA), Pyros EQS (quality software), Vertex (Tax calculation), Clearorbit and Loftware (Label printing solution)
• Implementation and support of Sql server based database EQMS and HQMS for LOP documentation
• DM for all R&D and clinical trial software
• Served as the point person for Oracle E-business suites issues. Debugging, documenting and implementing solution resolution using HPMS software
• Tuning sql code and troubleshooting business critical slowness issues
• Applying database (oracle, SQL server) and application (ERP, Trackwise, Pyros EQS, Vertex, EQMS, HQMS and Trackwise) patches
• TechLead for migrating 11.5.10 CU2 from Sun(NJ) to AIX(Texas) data center
• Implemented an Hyperion data feed to collect trial balance information from multiple Oracle instances to send it across to the parent company Hyperion Essbase server
• Administrator for Hyperion (patching upgrade etc)

Tech Lead Oracle Applications

Confidential, Mahwah, NJ

Responsibilities:

• Supporting Oracle ERP Production DEV, QA Environment with RAC DB.
• Patching ERP instances using adpatch.
• 11.5.9 Upgrade to R12.
• Creating new customized applications, registering applications, custom reports, forms, creating menus, request groups.
• Installed R12 VISION Demo.
• Managing users in the EBS ERP and synchronization with Oracle Portal using OID Sync for SSO.
• Upgrading existing 11.5.10 instances to EBS R12 with migration to HP-UNIX superdome servers.
• Oracle Portal installation and implementation.
• Discoverer upgrade to Release 2.

Senior Oracle Applications DBA

Confidential, Fairfield, NJ

Responsibilities:

• Installation of 11.5.9 Oracle Applications, Later upgraded to Release 2 and Release 3 For “ One Company System”, which is Comprised of Oracle Applications E-Business Suite in Integration with Vista Plus, APPS work, TIBCO.
• Installation, maintenance, troubleshooting Oracle Applications and its database.
• Cloning, Migration and Maintenance of Multiple Applications Instances.
• Installed Ring Master software for patching and Implemented RingMaster workflow for patching in Ricoh Apps environment, which includes huge customization.
• Supported Reporting architecture on multiple nodes using BCV Architecture.
• Provided Development and Migration support.

Oracle Applications DBA

Confidential, Kansas City, KS

Responsibilities:

• Designed Architecture For IAS Environment, which is Comprised of Oracle Applications E-Business Suite with iProcurement and Purchasing in integration with Prism Compusearch Product for contracting through Oracle Compusearch Interface.
• Designed the Architecture For Integration of IAS with USDA legacy system Federal Financial Information System (FFIS) using IBM MQ Series.
• Installation, maintenance and troubleshooting Oracle Applications and its database.
• Installation and Maintenance of Oracle Compusearch Interface (OCI).

Oracle Applications DBA

Confidential, Baltimore, MD

Responsibilities:

• Applied patches for Order Management patchset E, AR minipack E, AP minipack F, Procurement minipack E, HR minipack E and Order management consolidated patch 1, Supply chain management. Upgraded 11.5.2 to 11.5.4 and provided patch support and overall support for the patch management system.
• Installation, maintenance, troubleshooting Oracle Applications and its database with multiple Set Of Books.
• Loading of online help for HR.
• Migrated DB2 Payroll information to Oracle Apps (Using Interface Tables).
• Installation, Patching and setup for Oracle Configurator, Oracle Supply chain management.
• Generating form files, jar files, class files and custom.pll.
• FNDLOAD utility for transferring value sets, profile options, rollup groups, security rules, application, values, look ups, descriptive flexfields, custom concurrent programs including executables across different instances.
• Trained BGE DBA team for Application and database maintenance work including sysadmin/AOL module .