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.

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

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, professional development 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

Continental, 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

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.

Hire Now