We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

New York, NY

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.

Hire Now