SUMMARY

• Sector Experience: Telecommunications and Retail
• 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.

TECHNICAL SKILLS

• PL/SQL
• Python
• Django
• Oracle DB
• MySQL
• Oracle EBS
• Oracle Financial
• Oracle APPS
• Business Objects
• Unix
• Shell Scripting
• Oracle Forms
• Oracle Reports
• Schema Builder git
• SQLPlus
• Excel

PROFESSIONAL EXPERIENCE

SR. Oracle PL/SQL Developer

Confidential, New york, NY

Responsibilities:

• 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.

ERP DEVELOPER

Confidential

Responsibilities:

• 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

Responsibilities:

• 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

Database Developer

Confidential, Santo domingo, DR

Responsibilities:

• 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.