Provided Oracle Applications DBA consulting services/Oracle PL/SQL Developer services to customers• Designed and implemented a mission critical Data Warehouse architecture in collaboration with the Infrastructure Team.• Developed efficient ETL code using ERP Application APIs and PL/SQL for seamless data movement to the Data Warehouse.• Successfully evaluated and integrated Oracle APEX for rapid data migration from MS Access and MS Excel to Oracle.• Implemented complex business logic in Oracle databases using Stored Procedures, PL/SQL Packages, and Package Bodies.• Optimized Oracle database server performance through strategic configuration changes.• Created and maintained RMAN scripts for backup and recovery operations.• Designed and deployed silent installation scripts for Oracle EBS 12.2 Databases and Application Tiers.• Managed local Oracle Relational Databases within a RAC and Data Guard environment.• Conducted comprehensive performance tuning for applications and databases, resolving performance and defect issues.• Applied patches to enhance performance and address defects.• Developed and maintained SQL scripts for data warehouse reporting.• Led candidate assessment for permanent DBA positions.• Assessed professional development needs and knowledge levels of onsite DBAs.

• Provided round-the-clock support for a 24x7 global production environment.• Managed Oracle High Availability solutions involving Oracle 11g/10g RAC and Physical and Logical Standby Databases.• Served as System Administrator and Application DBA for local and global Oracle EBS systems.• Developed outbound HCM interfaces to Benefits Carriers and ADP Payroll using PL/SQL Packages.• Created inbound HCM interfaces from ADP Payroll to Oracle GL via PL/SQL Packages.• Produced HCM Reports using Oracle BI Publisher.• Maintained comprehensive technical documentation following company standards.• Resolved internal SRs and RFCs through technical support activities.• Oversaw code changes and ensured smooth deployment to the database.• Managed TAR creations and escalation processes.• Utilized Jira Incident Tracking Tool for precise issue tracking.

Provided Oracle Applications DBA consulting services/Oracle Developer services to client Mitsubishi UFJ Securities, NY.• Managed local Oracle Relational Database 11g in a RAC and Data Guard environment.• Designed and executed a custom Financial and Human Resources Reporting Platform using Microsoft SharePoint and PowerPivot.• Utilized Informatica for ETL data transfers to the BI Database.• Collaborated with developers to enforce standards and optimize application performance.• Developed custom Interfaces and Reports for Human Resource, Payroll, and Benefits Systems using Oracle BI Publisher architecture in collaboration with the Infrastructure Team.

• Led Oracle Financials implementations across various industries, demonstrating strong problem-solving skills and in-depth knowledge of Oracle tools.• Spearheaded Enterprise-Wide Data Warehousing initiatives using Oracle High Availability solutions and Oracle Data Warehouse Application (OBIEE).• Implemented robust Disaster Recovery Procedures, performed regular application cloning, and ensured data obfuscation.• Developed custom reports, interfaces, and conversion programs, enhancing Oracle Financial Applications.• Proficient in Oracle APEX, Reports Builder, SQLPlus, PL/SQL, and XML Publisher for report creation and deployment.• Played a pivotal role in the successful implementation and support of highly customized systems for Grants Management, Payables, Purchasing, and GL.• Contributed to off-site disaster recovery implementation and assisted with Apps 11.5.2 installation.• Innovatively designed and executed a custom Web Customer process, improving order management efficiency in the automotive industry.• Assumed multiple roles in a global Oracle Financials implementation, upgrade, and data warehousing project for the pharmaceutical sector.• Held certifications in various areas, including architecture, SQLPlus development, PLSQL development, Oracle Forms development, Oracle APEX, and more.• Extensive training in Oracle Application Architecture, AIM Methodology, AIX Systems Administration, and other relevant subjects.• Demonstrated strong leadership, problem-solving, and documentation skills, contributing to successful project management and knowledge transfer.