We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Houston, TX

SUMMARY:

  • Over Fifteen (15) years of IT experience in analysis, design, development, upgrade and implementation phases using Oracle Application Tools in multi - user, client-server, open systems, operational and development environment.
  • Technical Expertise in Interfaces, Conversions, Oracle v7.x/8i/9i, SQL*Loader, PL/SQL, Developer 6i (Forms 6i and Reports 6i), Developer 2000 (Oracle Forms v4.x and Reports v2.x), Discoverer 3i.Involved in customization, implementation and writing interfaces using PL/SQL Packages and procedures
  • Experience in R12 and 10.5.9.
  • Eleven (15) yrs. of experience in PL/SQL, Forms and Reports.
  • Experienced in Oracle customizations software including Nucleus, CorisPlus, Oracle Energy, VMDB and OEIS.
  • Strong technical and communication skills.

SKILLS:

Hardware: IBM PC/XT/AT and Sun.

O/S: UNIX, MS-Windows, MS-Windows NT, MS-DOS, VMS.

Databases: Oracle v9i, Oracle v8i, Oracle 7.x, Oracle 10G

Tools: Oracle Developer 6i, Developer 2000 (Oracle Forms v 6i/4.5 and Oracle Reports v 6i/2.5/2.0),Oracle Forms and Reports9i, Oracle Forms v4.0, Oracle Reports v2.0, Oracle Discoverer 2000, Integrated GEMMS v3.21.09, Oracle Reports v2.0/2.5, SQL*Forms 3.0, SQL*Plus 3.1, PL/SQL v2.0, SQL Report Writer v1.1, Oracle Graphics., Oracle R12 and Oracle Applications 10. 5.9, BI publisher reports, XML Gateway

Languages: C, C++,JAVA, ASP .NET, VB.NET

Software: Microsoft Office, Windows 2000.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle PL/SQL Developer

Responsibilities:

  • Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.
  • Involved in analyses of existing system written in PL SQL using complex Index structure.• Extensively worked on Performance improvement in SQL, PL SQL code using Explain Plan analysis,Indexes, Hints, DBMS profiler, SQL TRACE, and TKPROF.
  • Involved in meeting with business people to find out existing business process and its logic tointerpret the code.
  • Successfully delivered Design of Schema requirement in database, size, table structures, Processflow through packages, procedures and triggers.
  • Extensively involved in preparing Detailed Technical & Functional Documents from the existing codein company standard document guidelines.
  • Analyzed the data and mapped it with the old system.
  • Created new table structure and new flow of system to achieve resultsCreated complex procedures and packages.
  • Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions
  • Object oriented programming with PL/SQL - oracle object types. used Materialized Views extensively
  • Unit tested the code and worked with users in their testing and user signoff
  • Heavy PL/SQL debugging
  • Expertise in all the phases of System development life Cycle (SDLC)
  • Writing code for enhancing existing programs or developing new programs
  • Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
  • Experienced in working with many complex SQL queries with joins, date functions, inline views,cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
  • Performance Improvement of PL SQL code and improving memory utilization.
  • Experience in Back end Testing of the applications by executing complex SQL commands.
  • Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.
  • Comfortable in working with a fast-paced, team environment.
  • Excellent verbal and written communication skills and the ability to interact professionally with adiverse group, including executives, managers, and subject matter experts.

Environment: HP UNIX, PL/SQL, Oracle 10g, Toad

Confidential, Houston, TX

Oracle PL/SQL Developer

Responsibilities:

  • Provided full support while batch processing and resolved errors within stipulated time period withoutaffecting business process.
  • Used TOAD, PL/SQL developer & SQL Developer tools for faster application design anddevelopments.
  • Designing and Developing Oracle Stored Procedures, Triggers
  • Understanding of and ability to apply Oracle database environment performance tuning principles
  • Expertise in SQL tuning of large database environments (1+ terabytes

Environment: HP UNIX, PL/SQL, Oracle 10g, Toad

Confidential, Houston, Texas

Sr. Oracle Application Developer

Responsibilities:

  • Work on reports, Form customizations, ETL Tools including XML Publisher.
  • Written PL/SQL Stored procedures and packages in R12.
  • Written complex packages and procedures using pl/sql and toad.
  • Extensively worked in data warehouse environment architecture and methodology using StarSchema
  • .Proficient in debugging PL/SQL packages to troubleshoot issues.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications R12 (AR, Invoicing, AP, GL ), Oracle v10G, SQL*Plus, PL/SQL Developer, Oracle 9i Forms and Reports, Toad, and XML Publisher.

Confidential, Woodlands, TX

Responsibilities:

  • Work on Complex Packages, Procedures and UNIX Scripts.
  • Designed, Developed and tested Complex Oracle Forms & Reports in Oracle Applications modules
  • Worked on custom conversions and gl interface.
  • Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions
  • Unit tested the code and worked with users in their testing and user signoff
  • Heavy PL/SQL debugging
  • Experience in Back ends Testing of the applications by executing complex SQL commands.
  • Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications v 10.2.0.2.0 (AR, Invoicing, AP, GL ), Oracle v10G, SQL*Plus, PL/SQL, R12 and experience in BOM, WIP, INV/GL/AP/AR/PO modules.

Confidential, Texas

Sr. Oracle Application Developer

Responsibilities:

  • Worked on complex Unix Shell scripting to automate the process.
  • Write complex PL/SQL Packages and Procedures and tune them in 10g.
  • Worked on Complex VB.NET Programs..
  • Worked on customer and AR Interfaces and custom conversions.
  • Unit tested the code and worked with users in their testing and user signoff
  • Heavy PL/SQL debugging
  • Experience in Back ends Testing of the applications by executing complex SQL commands.
  • Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v10G, SQL*Plus, PL/SQL,MS SQL Server, .VB.NET., XML Gateway,

Confidential, Clearlake, Texas

Sr. Oracle Developer

Responsibilities:

  • Implement and Write PL/SQL Packages and Procedures in 10g Environment.
  • Worked on Complex VB.NET Programs..
  • Worked on complex Unix Shell scripting to automate the process.
  • Worked on GL Interface and custom conversions
  • Work on Complex Packages, Procedures and UNIX Scripts.
  • Designed, Developed and tested Complex Oracle Forms & Reports in Oracle Applications modules
  • Worked on custom conversions and gl interface.
  • Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions
  • Unit tested the code and worked with users in their testing and user signoff
  • Heavy PL/SQL debugging
  • Experience in Back ends Testing of the applications by executing complex SQL commands.
  • Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus, PL/SQL, VB.NET, Experience in R12 and experience in BOM/WIP/INV/AR/AP/PO/GL and GL modules.

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

  • Lead Role in Oracle Customizations.
  • Have written complex procedures and packages using PL/SQL and tested Complex Oracle Packages.
  • Work on Complex Packages, Procedures and UNIX Scripts.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus.

Confidential, City of Houston, Texas

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Designed, Developed and tested Complex Queries and written complex Packages and Procedures.
  • Have Written Reports using MS SQL Server Queries.
  • Maintained SQLServer Database.
  • Worked on complex Unix Shell scripting to automate the process.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus, MS SQL Server.

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

  • Customized the standard Mass Adjustments API to allow the option of creating a mass adjustment to a single GL Account code or to the Business Units (BU) and Line of Business (LOB) that exists on the invoice being adjusted.
  • Customized Oracle Mass Adjustments Form to capture additional invoice selection criteria and reverse adjustments functionality.
  • Updated mass adjustments form to accommodate Globalization.
  • Mass Adjust Custom Report - Developed the report using Mass Adjust Batch Name field as a selection parameter to allow reporting on all adjustments created within that batch.
  • Worked on AP Interface ABOB Report, EGL AP Overhead Payables Report, Budget-to-Actual FA Report, and EGL.
  • Worked on form customizations and few conversions.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications v11.5.9 (AR, Invoicing, AP), Oracle v9i (Forms 6i and Reports 6i), SQL*Plus.

Confidential, Houston, Texas

Sr. Oracle Applications Developer

Responsibilities:

  • Customize, Support Oracle Custom Development.
  • Worked on COM objects.
  • Worked on sql and pl/sql tuning .

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus.

Confidential, Houston, Texas

Oracle Developer/Analyst

Responsibilities:

  • Developed interfaces for Vertex tax module to AR.
  • Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.
  • Involved in analyses of existing system written in PL SQL using complex Index structure.
  • Extensively worked on Performance improvement in SQL, PL SQL code using Explain Plan analysis,Indexes, Hints, DBMS profiler, SQL TRACE, and TKPROF.
  • Involved in meeting with business people to find out existing business process and its logic tointerpret the code.
  • Successfully delivered Design of Schema requirement in database, size, table structures, Processflow through packages, procedures and triggers.
  • • Extensively involved in preparing Detailed Technical & Functional Documents from the existing codein company standard document guidelines.• Analyzed the data and mapped it with the old system.
  • Created new table structure and new flow of system to achieve resultsCreated complex procedures and packages.
  • Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions
  • Object oriented programming with PL/SQL - oracle object types. used Materialized Views extensively
  • Unit tested the code and worked with users in their testing and user signoff
  • Heavy PL/SQL debugging
  • Expertise in all the phases of System development life Cycle (SDLC)
  • Writing code for enhancing existing programs or developing new programs.
  • Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
  • Experienced in working with many complex SQL queries with joins, date functions, inline views,cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
  • Performance Improvement of PL SQL code and improving memory utilization.
  • Experience in Back end Testing of the applications by executing complex SQL commands.
  • Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.
  • Comfortable in working with a fast-paced, team environment.
  • Excellent verbal and written communication skills and the ability to interact professionally with adiverse group, including executives, managers, and subject matter experts.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle Financials v11i (AR, AP, Workflow), Oracle v8i, Oracle Developer 6i (Forms 6i and Reports 6i), Oracle Discoverer, Nucleus.

Hire Now