We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

PROFESSIONAL SUMMARY:

  • Over 6+ years of IT experience as an Oracle PL/SQL Developer (6+ years) and OBIEE developer (6 months).
  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.
  • Created Packages, Procedures, Functions, Triggers, and Cursors using PL/SQL.
  • Applied Database Tuning and Optimization, Normalization in the new database design.
  • Created Schema, Tables, Constraints, Indexes, Sequences and Synonyms.
  • Query optimization and Performance Tuning of Oracle Applications.
  • Design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
  • Developed Dimensional Hierarchies, Level Based Measures, and added multiple sources to business model objects.

TECHNOLOGY:

Language: SQL, PL/SQL, Java

Database: MS SQL, ORACLE ( 10g, 11g)

Business Intelligence: OBIEE 11.1.1.7.0

Industries: Financial services, Banking

Tools: SQL Developer, SQL*Plus, TOAD

Operating System: Windows

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for enhancement of the pl sql code.
  • Enhancement of packages, procedures, functions.
  • Implementation of new indexes.
  • Optimization of code.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Implementation of logic for Confidential .
  • Developed function for the logic.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for new functionality and design flow.
  • Responsible for Database design - ER diagram, Table creation, Normalization.
  • Writing of Stored Procedures, Functions
  • Implementation of Triggers, Sequences, Schedulers

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
  • Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
  • Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
  • Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
  • Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for conversion of files from EBCDIC to ASCII.
  • Conversion of SQL SERVER procedures, functions to Oracle compatibility.
  • Enhancement of SQL SERVER views to Oracle.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for table design and new functionality.
  • Implementation of indexes triggers.
  • Developed packages, procedures, functions.
  • Involved in design and interaction with the client.
  • Involved in functional specification, test plan and documentation.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Code Development and Integration.
  • Responsible for creating and modifying PL/SQL procedure, function.
  • Responsible for writing packages, Use of collection.
  • Documented the requirement and solution.
  • Query optimization and performance tuning.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for table design and new functionality.
  • Responsible for writing packages, stored procedures, queries and triggers.
  • Responsible for Performance tuning
  • Conducted knowledge management sessions.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developed new functionality and table design.
  • Implemented SQL and PL/SQL queries, triggers and Stored Procedures as per the requirement of the project.
  • Interaction with the client.
  • Conducted knowledge management sessions about the new functionality.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Enhancement of the code for the project.
  • Enhancement of the queries, function, packages.
  • Unit Testing and Peer Testing

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Code Development and Integration
  • Developed the code on the basis of the requests for the change.
  • Use of sub-queries and joins in the programs.
  • PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
  • Develop and maintain the documentation to support the team and business.
  • Involved in functional specification, test plan and documentation.
  • Interacted with client to gather the requirement and implement the same in the project.
  • Implemented PL and SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
  • Proper documentation of the application, for better future understanding.
  • Optimization of the query and performance tuning.
  • Conducted knowledge management sessions

Hire Now