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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship