Sr. Oracle Pl/sql Developer Resume
2.00/5 (Submit Your Rating)
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.