We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

0/5 (Submit Your Rating)

North Wales, PA

SUMMARY

  • 7 years of programming experience as anOracle PL/SQLDeveloper in implementation of Oracle EBS with emphasis to Financials and Supply Chain modules.
  • Involved in all phases of theSDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Expertise in Oracle Development tools - SQL, PLSQL, Workflows, Forms, BI Publisher.
  • Expertise inDynamic SQL, CollectionsandException handling.
  • Experience withPLSQL Performance Tuning.
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Technically proficient inRICE components (Reports, Interfaces, Conversions, Extensions)
  • Strong analytical, communication and troubleshooting skills with ability to work in a dynamic, team oriented environment.

TECHNICAL SKILLS

ERP: Oracle Applications 11i

Languages/Utilities: SQL, PL/SQL, Unix shell scripts,Java, XML, HTML

Database: Oracle 9i/10g/11g

Tools: Forms 6i, Work Flow Builder 2.6, BI Publisher, SQL Loader AIM 3.0 Methodology

PROFESSIONAL EXPERIENCE

Confidential, North Wales, PA

Oracle PL/SQL Developer

Responsibilities:

  • Developed conversion programs in PLSQL to create new users and responsibilities in Oracle.
  • Developed PLSQL procedures and functions to end date users and responsibilities.
  • Created concurrent programs to load suppliers and supplier sites.
  • Interacted with functional users to understand the business requirements.
  • UsedBulk Collectionsin conversion programs forbetter performance.
  • CreatedPL/SQL packagesto extract the data from the operational database into simple flat text files usingUTL FILE package.
  • Created several database objects liketables, views, triggers, procedures and functions as per the business needs.
  • Loaded data from excel files into custom tables using data importer utility in TOAD.
  • Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
  • Worked onSQL*Loaderto load data from flat files obtained from various vendors.
  • Created UNIX shell scriptsfor promoting the database objects to test and production environments.
  • Involved in performance tuning of PLSQL packages.
  • Developed custom BI publisher reports.
  • Worked on production support for fixing defects in production, unit testing and promoting database objects to production.

Environment: Oracle 11.5.10, Oracle database 11g, UNIX, SQL, PLSQL, TOAD, Forms 6i BI Publisher, Workflows.

Confidential, Wayne, PA

Oracle PL/SQL Developer

Responsibilities:

  • Interacted with functional users to understand the business requirements.
  • Developed plsql programs to extract employee data from HR and export data into flat files and ftp the files to vendors.
  • Developed several plsql stored procedures, functions and custom database tables, views are per the business requirements.
  • CreatedSQL*Loaderscripts to load data into the temporary staging tables.
  • Involved in performance tuning of complex Stored Procedures for faster execution.
  • Customized invoice approval workflow to send email notifications once the invoice is approved or rejected.
  • Developed new reports in Payables using BI Publisher.
  • Developed several Concurrent Programs for various business requirements.
  • Extensively worked on registering reports and concurrent programs using standard APIs.
  • Created custom value sets and profile options for concurrent programs.

Environment: Oracle 115.10, Oracle 10g, UNIX, SQL, PLSQL, TOAD, Forms 6i, BI Publisher Workflows

Confidential, Danbury, CT

Oracle PL/SQL Developer

Responsibilities:

  • Created control files for SQL*Loader as part of conversion process to extract legacy data from existing applications and loaded them into Oracle Application tables.
  • PerformedSQL tuningusingExplain Plan, Tkprof, Hintsandindexes.
  • Analyzed SQL statements, create indexes to improve response time of SQL queries.
  • Developed conversion programs to import customers into Oracle.
  • UsedCUSTOM.PLLextensively to modify the functionality provided by standardformsaccording to client requirements and created custom forms using zoom functionality.
  • Developed custom reports in XML publisher for various business requirements.
  • Design and development of several PL/SQL packages, procedures and functions that were used inCustom ReportsandFormsdevelopment.

Environment: Oracle 11.5.10, Oracle 9i, UNIX, SQL, PLSQL, TOAD, Forms 6i, BI Publisher Workflows

Confidential, Memphis, TN

Oracle PL/SQL Developer

Responsibilities:

  • Developed Code forCustom APInvoice Import Program. This interface reads invoices from ASCII data file and loads the standard Oracle Payables invoice Interface tables.
  • Worked with performance tuning tools likeExplain PlanandTKPROFto improve the performance of various custom PL/SQL Packages, Procedures and Reports developed.
  • DevelopedSQL Loaderscripts to populate staging tables.
  • Developed various reports as of the user specifications usingXML Publisher.
  • Designed and developedStored procedures,FunctionsandTriggersinPL/SQLto implement complex business rules.

Environment: Oracle 11i, Oracle 9i, UNIX, SQL, PLSQL, TOAD, Forms 6i, XML Publisher.

We'd love your feedback!