We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

NY

SUMMARY:

  • 7+ years of experience as an Oracle PL/SQL Developer, System Analysis, Design, Development & Support of Oracle Database 11g/10g in Production, Staging, Development, and Testing Environments
  • Experience with all phases of the S oftware D evelopment L ife C ycle(SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance
  • Extensive knowledge of Relational Database Management Systems (RDBMS)
  • Proficient in creating PL/SQL Packages, Procedures, Functions, Exceptions,Views, Triggers, Grants and Synonyms
  • Experience in query level performance tuning using Explain Plan
  • Experience in loading high volume data and Performance Tuning using Partitioning and Indexes for fine tuning and optimizing SQL and PL/SQL queries
  • Extensive experience of Oracle tools like TOAD,SQL*PLUS, and PL/SQL Developer
  • Experience in data loading from other databases and text files into Oracle database using SQL*Loader, Import/Export, Bulk Collect.
  • Involved in developing various data models using MS VISIO
  • Extensive experience in Exception Handling
  • Experience in working with DB Links and Data Migration between different environments
  • Experience in UNIX Shell Scripting and Knowledge ofCrontab in UNIX environment for scheduling routine tasks
  • Hands on experience with REF Cursors and Dynamic SQL
  • Experience in releasing the enhancements and code fixes into various environments through the process of Release Deployment
  • Knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, and Data Marts used in relational and dimensional modeling
  • Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre - Stage, Stage, Pre-Target and Target tables
  • Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas
  • Knowledge of DBMS SCHEDULER, DBMS JOB, DBMS DATAPUMP, and UTL FILE packages
  • Good understanding of the concept of Normalization
  • Worked with the technical teams and DBAs for issues related to code changes, data fixes, and testing
  • Possess excellent communication, interpersonal and presentation skills
  • Excellent team player with the ability to work independently and interact with people at all level

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, MS-Access XP, SQL Server

Environment: UNIX (Sun Solaris 5.8/5.9, HP-UX 11/11i, IBM AIX 5.2/5.3), Red Hat Enterprise Linux 3, Windows 2003/2000/XP/98

Languages: SQL, PL/SQL, Shell Programming, C, C++

Tools: TOAD 9.0/9.6, SQL*Plus, PL/SQL Developer 7.1.5, Oracle Enterprise Manager, Vi Editor, Putty, MS VISIO 2000/2007, SQL*Loader, TKPROF, SQL*Navigator v.4.5, ClearCase, MS Virtual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

  • Involved in different phases of SDLC for all the new modules including Physical and Logical Design, Code Development, Testing, Implementing and Maintenance
  • Involved in creating Logical and Physical Models using MS VISIO 2007
  • Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables
  • Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
  • Proficiently developed new Packages, Functions, and StoredProcedures using PL/SQL as well as modified the existing ones as per the user requirement
  • Extensively created Tables, Indexes, Views, and Sequences for the new modules
  • Experience in Exception handling
  • Created synonyms and grantedprivileges on schema objects for other users to be able to share and access content
  • Worked extensively with advanced features of PL/SQL like record and table types
  • Experience in using ExplainPlan for query level performance tuning
  • Involved in periodic Performance Tuning and Unit Testing of the PL/SQL code by using appropriate joins, indexes, and partitions
  • Analyzed the tables periodically to improve query response time
  • Coordinated with the offshore support team in resolving critical issues during the Production Run
  • Worked with DBAs to analyze performance as well as during table space and schema lock issues
  • Performed Data Migration between different environments using DB Links
  • Used other features like PL/SQL Wrapper, Hints, MaterializedViews, and ERR$ Tables
  • Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database
  • Extensive experience of promoting the new initiatives, enhancements and code fixes to various DEV and QA environments through the Deployment Process using UNIXplatform
  • Extensively used TOAD for development and administration of various relational databases objects
  • Proficiently used, created, and maintained various codes and scripts on different branches of ClearCase (Version Control)
  • Created and maintained documents and log reports for various modules including Release History on SharePoint
  • Actively participated in periodic status meetings and conference calls

Environment: Oracle10g, UNIX (Sun Solaris 5.8/5.9), TOAD 9.6, MS Visio 2007, HTML, Clear case

Confidential, Providence, RI

Oracle PL/SQL Developer

Responsibilities:

  • Actively Participated in different phases of SDLC
  • Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
  • Extensively involved in writing SQL queries and sub-queries using TOAD 9.6
  • Involved in creating Logical and Physical Models using ERWIN 4.0
  • Developed Packages, Functions, and Stored Procedures using PL/SQL and maintained the scripts for various data feeds
  • Created Indexes and Sequences for faster retrieval of the product information and enhance the database performance
  • Used Database Triggers for saving previous data when insertion, updating and deletion on the tables
  • Wrote DDL Scripts to create new database objects like tables, views, and synonyms
  • Wrote extensive Exception handling procedures to handle exceptions
  • Data loading from other databases and text files into Oracle database using SQL*Loader
  • Applicable knowledge of granting privileges on schema objects for other users to be able to share content
  • Worked with advanced features of PL/SQL like record types and Dynamic SQL
  • Used overloading feature of procedures, functions inside package
  • Used Explain plan for Tuning the SQL statements
  • Didquery performance using joins, indexes, partitions and hints appropriately
  • Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data
  • Wrote UNIX shell scripts to transfer and manage data within the database
  • Involved in debugging, Tuning and Unit Testing of the PL/SQL code
  • Attended daily walkthroughs, and status meetings

Environment: Oracle11g, HP-UX 11/11i, ERWIN 4.0, TOAD 9.6, ClearCase

Confidential, RI

Oracle PL/SQL Developer

Responsibilities:

  • Was involved in design, development, test and maintenance of Credit Scoring Application
  • Involved with all phases of SDLC for creating Credit Report Application
  • Created Logical and Physical Models using ER/STUDIO 7.5
  • Involved in Data Analysis and requirements gathering to develop and design documents
  • Created DDL scripts to create, alter tables, views, synonyms and sequences
  • Developednew and modified existing Packages, Procedures and Functionsas per the user requirements
  • Created Triggers to implement business requirements
  • Worked on trouble shooting of PL/SQL code using Exception handling
  • Developed standalone procedures for specific tasks using DynamicSQL and Cursors
  • Experience with handling huge volumes of data
  • Involved in improving query response time by creating partitioning on tables
  • Shared content with fellow developers by granting them privileges on schema objects as well as creating synonyms for objects on different schemas
  • Experience with using Explain Plan for tuning complex queries
  • Wrote SQL queries to perform Data Validation and Data Integrity testing
  • Used TOAD 9.0.1 for the development of stored program units for Oracle databases
  • Created and maintained documents and log sheets related to the database requirement, accessible to the whole team
  • Participated in weekly status meetings and presentations
  • Actively participated through the whole life cycle of the project

Environment: Oracle 10g, Windows XP, IBM-AIX 5.2/5.3, TOAD 9.0, ER/STUDIO 7.5, MS Visual SourceSafe 2005\

Confidential, Memphis, TN

Oracle PL/SQL Developer

Responsibilities:

  • Active participation in the System Study, Physical Designing and Development of database
  • Involved in creating technical documentation and Data Models using MS VISIO 2000
  • Wrote DDL Scripts to create new database objects like tables, indexes, views, and synonyms
  • Created and modified stored programs in the form of Packages, Procedures, and Functions for implementing the database intensive business rules
  • Used database trigger for making history of insertion, updating, deletion and all kind of audit routines
  • Worked on complex SQL queries and sub queries on the testing servers for performance tuning
  • Worked on User-defined and System defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS
  • Used SQL* LOADER to load data from CSV files into the database
  • Wrote small Linux Shell Scripts for automated jobs
  • Generated various reports using MS Excel XP
  • Monitored Alert Log Report and System Error Logs
  • Assisted in code reviewing and testing
  • Participated in the ongoing process enhancements and modification requests
  • Responsible for maintaining the documents for business analysts

Environment: Oracle 10g, Red Hat Enterprise Linux 3, Windows NT/XP, SQL*PLUS, MS VISIO 2000, MS Visual SourceSafe 6.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in design and development of the database design.
  • Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
  • Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
  • Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Involved in the design, development, testing and maintenance.
  • Troubleshot production problems and worked effectively with other team members to identify and address problems.
  • Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
  • Responsible writing UNIX Shell scripts.

Environment: Oracle 9i, Sql*Loader, Pl/Sql, Toad, UNIX Shell Scripting.

Hire Now