We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Jamesburg New, JerseY

SUMMARY:

  • Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
  • Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables .
  • Loaded Data into Oracle Tables using SQL * Loader .
  • Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE .
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor and Collections .
  • Expertise in Dynamic SQL, Collections and Exception handling .
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS .
  • Created Shell Scripts for invoking SQL scripts.
  • Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

Languages: PL/SQL, SQL, Unix Shell, XML.

Oracle tools: Oracle Forms & Reports 6i/9i/10g.

Tools & Utilities: SQL Loader, WS FTP, Putty, TOAD, PL/SQL developer, Oracle s SQL*Plus, HP Kintana (4.7).

Operating Systems: Windows XP/2000/ 2003.

Testing Tools: HP Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential, Jamesburg, New Jersey

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Performed modifications on existing form as per change request and maintained it.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Developed UNIX Shell scripts to automate repetitive database processes.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, Mountain view, CA

Oracle PL/ SQL Developer

Responsibilities:

  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
  • Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Designed Data Modeling, Design Specifications and to analyze Dependencies.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Created some Custom reports for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Windows 2000, Toad.

Confidential

Oracle PL/ SQL Developer

Responsibilities:

  • Created and maintained PL/SQL scripts and stored procedures.
  • Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
  • Investigated data quality issues and implemented appropriate solutions.
  • Helped to improve the performance, scalability and stability of database systems.
  • Identified and implemented programming enhancements.
  • Developed technical system documentation.
  • Documented code in accordance with company policies, company standards and industry best practices
  • Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with company policies, company standards and industry best practices.
  • Assisted in the conversion of existing PowerBuilder code to PL/SQL and Java to support a new Flex application.
  • Tested coding modifications and assisted with application and system testing to minimize errors and downtime.
  • Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
  • Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
  • Maintained versioned code in Subversion in accordance with company policies, company standards and industry best practices.
  • Designed, coded, tested, and debugged enterprise wide applications.

Environment: Oracle 9i/10g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, TOAD.

Confidential

Oracle PL/ SQL Developer

Responsibilities:

  • Worked with SQL*Loader to import and export data from flat files in and out of the legacy database.
  • Participated in the development of new PL/SQL procedures, function, triggers and updating old ones based on the change requests.
  • Created various DML and DDL statements using oracle PL/SQL and SQL.
  • Tuned some existing quires using Hints to improve execution time of the queries.
  • Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
  • Participated in creation of database objects like tables, views, materialized views, cursors(Implicit, Explicit, REF),procedures, packages, cursors using Oracle tools like TOAD,PL/SQL,SQL * Plus, SQL * Loader.
  • Prepared the test scenarios and performed unit and regression tests on PL/SQL programs .Assist Java development team for writing SQL queries for the application.

Environment: Oracle 9i, SQL*Plus, PL/SQL, Windows 2000, Toad.

Confidential

Oracle PL/ SQL Developer

Responsibilities:

  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Wrote Shell Scripts for Data loading and DDL Scripts.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
  • Involved in Logical & Physical Database Layout Design.
  • Set-up and Design of Backup and Recovery Strategy for various databases.
  • Performance tuning of Oracle Databases and User applications.
  • Provided user training and production support.
  • Improved the performance of the application by rewriting the SQL queries.
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Oracle 8i, SQL*Plus, PL/SQL, Windows 2000, Toad.

Hire Now