Oracle Pl/sql Developer Resume
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.
