We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

GA

PROFESSIONAL SUMMARY:

  • Over 8+ Years of IT experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL Developer.
  • Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance.
  • Experience in Performance Tuning & Optimization of SQL statements.
  • Worked in Agile Environment as an Oracle Developer.
  • Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting.
  • Good knowledge on Nested Tables, V arrays, Records, Types, Bulk Collects and Bulk Variables.
  • Strong knowledge in Oracle Cursor Management, Exceptional Handling, REF - Cursor.
  • Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter Forms, and Report Triggers.
  • Expertise in performance tuning and query optimization using various types of hints, partitioning, bulking techniques and indexes.
  • Wrote complex SQL queries using complex joins, grouping, aggregation, nested sub queries, cursors, etc.
  • Strong Background in implementation of RDBMS concepts.
  • Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
  • Comfortable working with unit testing, debugging and deployment of applications. Implemented and supported test and production environment.
  • Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
  • Experience in writing Technical design documents and developing unit test documents.
  • Supported integration and end user testing with efficient defect management process.
  • Experienced in Unit testing and Integration Testing with excellent debugging skills.
  • Strong Knowledge on oracle architecture and database design.
  • Worked on production support, troubleshooting the application and involved in bug fixes.
  • Quick learner and a team player with strong communication and interpersonal skills.
  • Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

TECHNICAL SKILLS:

Database: Oracle 9i/10g/11g/12c, SQL Server, MS Access

Data Modeling: Erwin 3.5.2, 4.0

Languages: PL/SQL, SQL, HTML, C, C++

Reporting Tools: Oracle Reports

Tools: SQL Developer, PL/SQL Developer.

Operating Systems: Windows XP, UNIX.

MS Suite: MS Office, MS Access, MS Power Point, MS Excel, MS Word.

PROFESSIONAL SUMMARY:

Confidential, GA

Sr. PL/SQL Developer

Responsibilities:

  • Gathering development requirements from client's functional team and from functional design specification documents.
  • Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
  • Executed PL/SQL blocks using cursors, ref cursors, exception handling, Collections.
  • Performed weekly oracle database migrations from development databases to staging database.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Analyzed the reporting requirements from the business users and convert them into technical specifications.
  • Worked as a part of the technical team in understanding the business requirements and translating them to technical documents.
  • Created test cases for System Testing, Integration Testing (UAT) and Production (Post Implementation Review) in Agile/Scrum environment.
  • Extensively used PL/SQL features like collections, nested table, Varray for high performance of stored procedures.
  • Worked with the business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
  • Support and modify existing code.
  • Extensively used error and exception handling techniques.
  • Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day activities
  • Extensively used SQL Loader for loading data into oracle database from flat files.
  • Created Indexes on Tables to improve the performance by eliminating the full table scans and views for hiding the actual tables to eliminate the complexity of the large queries
  • Create various user defined Exception to control the process based on the business requirement.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 12c,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting, SQL*loader, Informatica, XML, Windows XP.

Confidential, OH

PL/SQL Developer

Responsibilities:

  • Creating SQL, Object Views, and PL/SQL database objects. Written the interface stored procedures for data transformation.
  • Used principles of Normalization to improve the performance.
  • Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
  • Expertise in SQL and PL/SQL programming and strong knowledge on Oracle architecture and database design.
  • Wrote database scripts & PL/SQL stored procedures, functions and triggers.
  • Store procedures, User defined functions, Views for complex business logic.
  • Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
  • Expertise in DDL and DML, as well as using Aggregate Functions.
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages.
  • Assured and checked the quality and the integrity of the data received from the store collectors.
  • Worked closely with the end users in writing the functional specifications based on the business needs.
  • Wrote shell scripts for data loading and DDL scripts.
  • Worked in production support environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements and data changes, etc.
  • Wrote conversion scripts using SQL, PL/SQL, Stored Procedures, Functions and Packages to migrate the data from the SQL server database to Oracle database.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Involved in the Analysis, Design, Coding and Testing of the application.
  • Involved in developing packages for implementing business logic through procedures and functions.
  • Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading.
  • Made use of cursors in procedures to generate high performance queries and PL/SQL code.
  • Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.

Environment: Oracle 9i/10g/11g, Oracle Forms 10G, SQL*Loader, SQL Navigator, XML Reports, TOAD,

Confidential, OH

PL/SQL Developer

Responsibilities:

  • Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client. Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Involved in developing packages for implementing business logic through procedures and functions.
  • Developed and modified procedures, functions, triggers, forms, and reports and deployed the changes in the system.
  • Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
  • Used Materialized views in order to improve the performance.
  • Trouble shooting performance issues within packages using dbms output.
  • Involved in 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.
  • Involved in writing conversion scripts using SQL, PL/SQL, stored procedures and functions to migrate data from SQL server database to Oracle database.
  • Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

PL/SQL Developer

Responsibilities:

  • Analyzed requirements, designed, developed, deployed and documented software components.
  • Designed ER diagram using Erwin, to set the logical and physical relationships of database.
  • Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and Views to handle the Online and Batch process
  • Created database Triggers for the security purposes.
  • Perform code review and made enhancements as required.
  • Developed Oracle database triggers, cursors, Packages, stored procedure, Functions, Cursors, Collections.
  • Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Implemented data security by designing the process to only retrieves data for exchange IDs that the user is authorized to view using users BBG license.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, stored procedures, packages using oracle tools like TOAD
  • Designed and developed Oracle PL/SQL scripts for data import/export.
  • Designed and built an integration solution that merged Oracle tables from two separate Oracle databases using PL/SQL.
  • Worked on Performance tuning and monitoring of database.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
  • Designed tables, indexes and constraints using SQL * Plus and loaded data into the database using SQL* Loader.

Environment: Oracle database 9i, Forms 6i, Erwin, PL/SQL, SQL Plus, SQL*Loader TOAD, and UNIX.

Hire Now