We provide IT Staff Augmentation Services!

Oracle Pl Sql Developer Resume

SUMMARY

  • Over 5+ years of programming experience as an OraclePL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Expertise in Oracle SQL,PL/SQL
  • Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
  • Expert level experience onPL/SQLthat includes Cursors, Ref - cursors, Procedures, Functions and Packages, Object, Partitioned Tables, and Table Indexing.
  • Expertise in using user defined and system defined Exceptions for Error handling.
  • Experience in creating composite data types and collections.
  • Experience in using tools likeSQL* Plus,SQLAssistant,PL/SQLdeveloperand TOAD.
  • Experienced in writing UNIX shell scripts for automating the process of data loading& Batch Processing.
  • Experienced in writingSQLstatements,PL/SQLcode for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.
  • Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users
  • Good experience in data modeling using Erwin Data Modeler: Creating entities, relationships, sub-types, schemas and ERD to database schemas.
  • Good experience in Software Engineering Processes (Agile and Waterfall Methodologies). Development of software project based on users' requirements and meeting deadlines to satisfy users' need.
  • Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
  • Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
  • Worked in analyzing and Implementing the ETL architecture using ETL Informatica,SQL* Loader,PL/SQL.
  • Experience in DML, DDL, and TCL operations.
  • Extensive experience in Database query tuning, Performance tuning of Reports.
  • 24/7 Production Database Support & Maintenance.
  • Experience in Migration and Upgrade of databases.
  • Expert knowledge with Microsoft Excel, Power Point, Word.
  • Excellent analytical and problem-solving skills and can work independently.
  • Excellent Communication and responsible team player.

TECHNICAL SKILLS

Databases: Oracle11g, 10g, 9i, MSSQLServer

Languages: SQL,PL/SQL, T-SQL, Java, HTML, C#, .NET

Operating Systems: Windows, Linux, Unix, Shell

DB Dev. Tools: TOAD,SQLDeveloper,SQL*Plus, Informatica Power Center,SQLLoader, Warehouse Builder, Erwin

PROFESSIONAL EXPERIENCE

Oracle PL SQL Developer

Confidential

Responsibilities:

  • Created complex functions, stored procedures, and packages by usingPL/SQL.
  • Responsible for working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
  • Developed back end interfaces usingPL/SQLpackages, stored procedures, functions, Object Types, Pipelined functions,Oraclequeues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between thePL/SQLandSQLengines.
  • Hands on experience in developingpl/sql - stored procedures, functions, packages, proc-c programming on Unix platform, shell scripting based applications.
  • Wrote complexSQLqueries using Joins, sub queries and inline views to retrieve data from the database for reporting and analytics in <>
  • Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on various tables to create Indexes to improve query performance. Also, worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
  • Worked on various reports like formulary analysis, UM criteria, UM audit, formulary draft status.
  • Developed technical system documentation.
  • Performed unit testing and supported integration testing and end user testing.
  • Extensively worked on production issues with effective defect management.
  • Proactively tunedSQLqueries and performed refinement of the database design leading to significant improvement of system response time and efficiency.

Environment: SQL,PL/SQL,Oracle10g/11g, Toad,SQL*Plus,SQL*Loader, MS Office, Windows XP,OracleReports 10g,OracleForms 10g.

Oracle PL SQL Developer

Confidential

Responsibilities:

  • Worked with various functional experts to implement their functional knowledge into working procedures.
  • Developed application and database triggers, functions, procedures, and packages inPL/SQL,Oracle11g as back - end.
  • Creation of database objects like tables, views, procedures, packages usingOracletools like SQLLoader,SQL* Plus andPL/SQL.
  • Created variousSQLandPL/SQLscripts for verification of the required functionalities.
  • Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
  • Worked on optimizing existing procedures and functions usingPL/SQL.
  • Worked on User Exit, DynamicSQLandPL/SQLblock inPL/SQL.
  • Created various Database triggers usingPL/SQL.
  • Have converted old data from Flat files toOracledatabase UsingSQL* Loader.
  • Wrote various kinds ofSQLqueries involving Correlated Sub queries, UNION, Inner and Outer Joins
  • Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL,PL/SQL, UNIX Shell Scripting,Oracle10g/11g, Toad,SQL*Plus,SQL*Loader, PUTTY, MS Office, Windows XP,OracleReports 10g,OracleForms 10g.

Senior Oracle PL/SQL Developer

Confidential

Responsibilities:

  • Strong experience with Very Large Databases, over 8 terabytes.
  • Database developing usingOracle11g and UNIX shell script.
  • Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
  • Understanding the requirements and carrying out impact analysis
  • Coded complexSQLqueries to retrieve data from the database depending on the need.
  • Designed and developed data loading processes usingPL/SQLand UNIX Shell scripts.
  • Created database objects like tables, views, indexes and sequences.
  • Responsible for the design, construction, unit test, code review and bug fix.
  • Participated in Functional Testing and Unit Testing.
  • Creating data mapping documents, technical documents as well as QA/production release notes.
  • Use and maintain all version of codes in PVCS.
  • Wrote complex functions and stored procedures to populate time dimension values with complex logic.

Environment: Oracle11g, TOAD forOracle, Netezza, Aginity Workbench for Netezza, Putty, UNIX, PVCS Version Manager, SBM, MS Communicator

Oracle PL/SQL Developer

Confidential

Responsibilities:

  • Developed variousPL/SQLobjects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.
  • Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
  • Define and represent entities, functions and flows between the entities.
  • Participated in analyzing the requirements for the logical and physical design of the database.
  • Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
  • Loading data into test warehouse for the business analyst to perform QA testing usingSQLLoader utility and Data pump utility.
  • Performed exception handling for data that did not conform to the required format.
  • Implemented purging techniques on the data which is not required by the clients.ImplementedPL/SQLscripts in accordance with the necessary Business rules and procedures.
  • OptimizedSQLstatements andPL/SQLblocks by usingOracleHints, Explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.

Environment:, Oracle10g,PL/SQL,OracleFMW, xml, .Net, Visio, UNIX Shell scripts, SVN, Toad,SQLDeveloper, HP Quality Center,SQL*Loader, Import Export.

Hire Now