Oracle Pl/sql Developer Resume
5.00/5 (Submit Your Rating)
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 DeveloperResponsibilities:
- Responsible for enhancement of the pl sql code.
- Enhancement of packages, procedures, functions.
- Implementation of new indexes.
- Optimization of code.
Confidential
Oracle PL/SQL DeveloperResponsibilities:
- Implementation of logic for Confidential .
- Developed function for the logic.
Confidential
Oracle PL/SQL DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- Enhancement of the code for the project.
- Enhancement of the queries, function, packages.
- Unit Testing and Peer Testing
Confidential
Oracle PL/SQL DeveloperResponsibilities:
- 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