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

Responsibilities:

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

Confidential

Responsibilities:

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

Confidential

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

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

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

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

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

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

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

Responsibilities:

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

Confidential

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