We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

0/5 (Submit Your Rating)

Raleigh, NC

SUMMARY

  • 7 years of total experience in Analysis, design, development, and testing of various business applications using Oracle SQL and PL/SQL.
  • Worked extensively on various RDBMS like Oracle 11g/10g/9i, SQL Server 2008/2005.
  • Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
  • Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
  • Experience in Data Warehouse design, Data Modelling and Schema Design.
  • Strong understanding of data warehouse design methodologies, data structures, data modelling and RDBMS concepts.
  • Extensive experience in performance monitoring and tuning in Oracle/MS SQL Server.
  • Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
  • Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
  • Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
  • Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.
  • Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
  • Having Good knowledge of UNIX, and Shell Scripting.
  • Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
  • Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
  • Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.
  • Good communication, Analytical and presentation skills. Ability to provide timely solutions and work within specific time frames.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, SQL Server 2000/2005, MySQL, Microsoft Access.

Operating System: Windows NT/2000/2003/XP/VISTA, Linux, UNIX.

Programming Languages: C, C++, VB, SQL and PL/SQL.

Version Control Tools: CVS, Clear Quest, Clear Case, Subversion (SVN)

Tools: TOAD, SQL Developer, SQL * Loader, SQL navigator.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.
  • Interacted with Business stakeholders, subject matter experts and Business Analyst to gather the Requirements and Business logics and mappings on scheduled basis.
  • Involved in source data analysis and creating ETL design document along with the enterprise architects.
  • Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
  • Created stored procedures, Functions to facilitate the functionality for various complex modules. And used the oracle Pipeline functions to improve the performance.
  • Created Oracle Virtual Private Databases (VPD) to enforce security and control data access by creating security policies on PII data elements.
  • Designed and Developed and maintained the complex oracle scheduler chains for the load process.
  • Involved in creating data marts, views to load the data into application databases.
  • Involved in documentation of User requirements and Testing of developed modules.
  • Created the production release and migration scripts/documents, worked closely with Data Base Administrators on production deployments.
  • Supporting the production environments 24/7, fixing the defects and high priority bugs.
  • Analyzed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
  • Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
  • Performed unit testing, integration and regression testing for various applications developed in data warehouse.
  • Responsible for performing code reviews and code fixing after identifying the Defects.
  • Optimized and fine - tuned the SQL queries by using Explain plan and Quest SQL optimizer.
  • Involved in helping the application teams to rewrite and fine-tuned the existing applications.
  • Worked closely with team members to share the work and helping them to resolve the issues.
  • Played an important key role in decision-making and provided valuable ideas and inputs for the success of the project.

Environment: Oracle 11g R2, TOAD 11.x, SQL PLUS, SQL Developer, UNIX, Windows 7.

Confidential, Peoria, IL

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
  • Implemented Security by creating different Users, and assigning Roles to Users.
  • Created Data Structures including Tables and Views, and applied referential integrity.
  • Participated in designing of data conversion/interface with the use of SQL*Loader.
  • Created Form level objects i.e. Libraries, property classes.
  • Created Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developed SQL*loader scripts to load data in the custom tables.
  • Developed PL /SQL code for updating payment terms.
  • Involved in documentation of User requirements and Testing of developed modules.
  • Worked in the Production Support team and fixed high priority bugs.
  • Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
  • Performed unit testing and integration testing for various development applications in ORACLE 10g.
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Used external tables to manipulate data obtained daily before loading them into the tables.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.
  • Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 10g.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD 9.X, Forms 10g, Reports 10g, Windows XP, UNIX shell scripting, Oracle Applications.

Confidential, Fairlawn, OH

Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
  • Designed and created all the required tables, indexes, sequences and views using SQL*Plus and Toad.
  • Written Procedures to Load Data into data warehouse system.
  • Involved in developing Object data types and collections.
  • Developed various Complex Queries, Views for Generating Reports.
  • Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
  • Written SQL scripts for implementation and mentored the end users
  • Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.
  • Written Shell Scripts, control files to load data into staging tables and DW tables.
  • Developed and Tested applications for loading inventory data into database tables.
  • Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
  • Involved in Unit testing PL/ SQLStored Procedures andFunctions.
  • Perform analysis of key requirements and transfer knowledge accordingly to the end users
  • Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
  • Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, andpresentation of results.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • Loading data from flat files into database tables using SQL* Loader
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Optimizing database objects and streamlining applications.

ENVIRONMENT: Oracle 10g, Windows XP, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD.

Confidential, Winston Salem, NC

Oracle PL/SQL Developer

Responsibilities:

  • Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
  • Created and maintained development environment, resolved Production and validated Environment problems.
  • Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 11g.
  • Developed and deployed the Reports using Oracle Reports 11g.
  • Detected and Corrected bugs during system integration and user acceptance testing.
  • Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
  • Involved in Planning, Implementation, Testing, and Documentation.
  • Mapped the source and target databases by studying the specifications and analyzed the required transforms.
  • Responsible for the development and maintenance of end-user documentation.
  • Detected and Corrected bugs during system integration and user acceptance testing.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, ERWIN, MS Access, MS Excel, C++, SQL*Loader, CVS, TOAD, Dynamic SQL, Eclipse, EXPLAIN PLAN, TKPROF, MS Visio, UNIX.

Confidential

SQL Developer

Responsibilities:

  • Worked on converting the date from existing legacy system into oracle.
  • Developed PL/SQL Packages, stored procedures, and functions to extract, transform and load data from Legacy systems into Oracle database.
  • Involved in uploading of the data from flat and external files into relational Database tables using SQL*Loader and validated the data.
  • Worked on performance issues while conversion of data.
  • Created PL/SQL objects such as tables, views, synonyms, sequences, triggers and database links as well as custom packages tailored to business requirements.
  • Worked on scheduling programs on a nightly basis using DBMS JOB SCHEDULING.
  • Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
  • Involved in unit and integration testing and documentation.

Environment: Oracle 9i, Windows XP, SQL Server 2005, Oracle SQL developer, SQL * Loader, PL/SQL, SQL*PLUS.

We'd love your feedback!