Oracle PL/SQL Developer Resume

SUMMARY

Over 8+ years of IT experience with strong background in Application Development, Maintenance, Analysis, Design, Enhancement, Implementation of Data warehouse Technologies and Data warehouse development, reporting using Siebel Analytics/Oracle BI (OBIEE), Dimensional modeling across Banking, Retail, Financial, Pharmaceutical and HealthCare Industries.
Extensive knowledge on UNIX commands, FTP and shell scripts.
Involved in all the phases of SDLC - Analysis and Design, Data Modeling - ER Diagrams and different methodologies, System Testing, Development, documentation and implementation on both Client/Server as well as Web-based applications.
Good knowledge in OL
AP tools like Business objects.
Highly proficient in developing Oracle PL/SQL Packages, Stored procedures, Functions, Triggers and Cursors as per business logic. Also developed various applications using Oracle in-built packages.
Optimizing the SQL queries in PL/SQL code.
Experience on Incident management and Change management.
Agile methodology experience.
Extensive work experience on Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows enterprise platforms.
Experience in design and development of reporting environments.
Extensive experience using Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrative views, advance Reports.
Modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling
Extensive experience in OBIEE Answers, Dashboards, Delivers, iBots with OBIEE stand- alone/integrated implementation, Catalog Manager.
Strong expertise in BI reporting, sourcing data from multiple data sources like EBS, Oracle R12/11g, SQL Server 2005 and several flat files.
Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.
Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
Experienced in Data Modeling, identification of Facts and Dimensions, Creation of schemas (Star), Hierarchies, Documentation of Report and Dashboard Layouts, End User Demo/Documentation for Business/Report Users.
Experienced in configuring the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication.
Strong experience on working hierarchies, complex and foreign key joins, initialization block, presentation/repository/session variables, aggregate tables, partitions and fragmentations.
Implemented different Caching techniques to improve the performance of BI server.
Extensive experience in developing Interactive Dashboards with drill-down capabilities, Security Implementation (Creating groups, grant access privileges, data level and report level), Metadata and Web Catalog Objects (pages, folders and reports) and scheduling reports using BI Delivers.
Experience in reviewing the existing OBIEE reports documentation, analogous reports design, reports building; reports unit testing,delivery of reports package for production and verification of post deployment.
Experience of working with technical architects and application designers in defining and maintaining metadata of the enterprise.
Experience in prototype building and demonstrating to clients. Optimizing reporting and query performance and develop custom tables.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005, IBM DB2, MS-Access.

ETL Tools: ODI 11.1.1.6, Oracle PL/SQL.

Languages: SQL, PL/SQL, Unix Shell Script, HTML, XML, C, Pro*C, Java, Hibernate

Tools: Toad, SQL* Plus, SQL Navigator, Surveyor, Putty, SQL Developer.

Operating Systems: Windows 7, Unix, Linux, Solaris9/8, HP-UX 11g, Windows XP/2000.

BI Reporting Tools: OBIEE 11G & OBIEE 10G

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship