Oracle Certified with 15+ years of IT/IS Experience.
Proficient in Oracle8i/9i/10g,PL/SQL, analysis, design and development.
Development in Data warehouse environments using the Oracle Relational Database Management System (RDBMS), Good knowledge in STAR Schema, FACT Tables and Dimension Tables and ETL.
Well experienced in Oracle PL/SQL, Java programming, writing Stored Procedures, Functions, and Database Triggers.
Comprehensive knowledge of tuning and performance enhancing tools in Oracle like SQLTrace, Explain Plan, different types of optimizer hints, indexes, tables and best practices in SQL and PL/SQL.
With 8+ years experienced in Oracle Developer tools: Forms, Reports, Schema builder
8+ years experienced in several modules of Oracle E - Business Suite (11i, R12) either Functional as well as Technical.
With 8 years of experience in analysis, developing Business Objects Reports.
Schema Builder git
SR. Oracle PL/SQL Developer
Confidential, New york, NY
Created Complex Master Detail Reports, with calculations, format triggers, Programming Units and Report triggers.
Tuned procedures for the maximum efficiency in various schemas across databases using OracleHints and Explain plans.
Involved in performance tuning and optimization on Business Objects Reports
Developed interface between POS and ERP: Synchronization and Deployment of prices
Worked on Dynamic SQL and also created new tables as per requirement.
Worked on Packages to know the root cause of Production issues.
Worked on creating scripts for AP, AR, GL interfaces to Oracle R12
Delivered standard documents (MD50, BR100, MD060) using Oracle AIM methodology.
Business Requirements gathering and Analysing
Support interacting with end users for enhancements, bug fixes and customizations.
Developed PL/SQL Packages and Procedures accordance with Business Requirements and also to extract the data from different sources and load it into production system.
Performed SQL tuning using Explain Plan, Hints and indexes.
Sr Oracle technical developer
Confidential, Santo domingo, DR
Implemented Oracle EBusiness Suite: Developed programs for loading invoices to AP module, Customized several forms and libraries in INV module to speed the load of serial items through a flat file, designed and developed the interface between Sales Web Application and the Oracle modules(INV,AR)
Developed an interface to upload the journal data into the Oracle Application’s General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validation.
Upgrade Oracle Ebusiness Suite from 11.5.10 to R12: Setup post Upgrade modules AP,INV,GL,AR,EB Tax
Involved in migration of AR and AP custom interfaces and reports, during oracle financials upgrade project.
Implement new functionalities in the version R12: Payments,Banks, AP/AR Nettin g, Xml Publisher Formats
Upgrade and develop new interfaces between external applications and Oracle EBS R12
Confidential, Santo domingo, DR
Development using Oracle RAD (Forms, Reports).
Creation of database objects: Tables,synonyms,views,sequences.
Responsible for supporting Payables and Payment application.
Improved Oracle Reports and processes using techniques of index and SQL optimization.