OBIEE developer Resume

Professional Summary:

Over 7+ years of experience as software developer that includes OBIEE 10.1.3.x, Oracle BI Applications 7.9.x, Siebel Analytics 7.7.
Experience in building and configuring repository, creating and managing Oracle/SiebelIntelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots.
Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
Extensive experience of creating star schema for OBIEE/Siebel Analytics Projects.
.Experience with complete Lifecycle (gathering Business Users Requirements, Analysis, Design & Modeling, Development, and Testing) of Business Intelligence using OBIEE (Siebel Analytics) and have knowledge on Oracle EBS.
Experience in specifically focused IT, reporting strategy and design, with a strong focus on Business Intelligence and analytics and also worked on BI Publisher.
Translating high-level business requirements into logical business dimensional model; Defining various logical subject areas and organization of Presentation Layer metadata; Understanding and defining key metrics, dimensions, hierarchies and attributes.
Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor, and building OBIEE (Siebel Analytics)Repository using OBIEE (Siebel Analytics).
Experience in creating dimension hierarchies and level-based measures and adding disparate sources to business model objects and also experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
Experience in setting up a Multi-User Development Environment (MUDE) and using OBI answers to run queries to test and validate the repository.
Experience in Data Warehousing development and ETL methodology using Informatica 8.1.1/7.1 and worked in Oracle Financials (GL, AP, and AR).
Expertise in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various tasks and scheduling them using both Workflow Manager and Drive collaboration with the user & BI team.
Experienced in Informatica Data Integration Tools - Repository Manager, Designer, Workflow/Server Manager, and Workflow Monitor.
Expertise in Developing Mappings, Mapplets and different Transformations between Source and Target using Informatica Designer.
Experience in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts.
Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 8.x, 7.x and implementing OBIEE platform (Formerly Siebel Analytics).
Experience in extracting data from Siebel, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
Excellent balance between technical and business process skills. Able to interact with users and business owners, while still maintaining a deep technical competency to interact with technical teams.
Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize execution plans, and monitor ETL process for General Ledger.
Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, business models, generating reports, and creating dynamic Dashboards using Oracle BI Analytics.

Technical Skills:

Operating Systems

MS-DOS,Windows XP/2000/NT, UNIX, Linux

Packages

MS-Office, Adobe

Programming Languages

C,C++, SQL, SQL*Plus, PL/SQL, UNIX shell scripts, Java

Databases

Oracle 8i/9i/10g, MS Access, SQL Server

Reporting Tools

Oracle's Siebel Analytics 7.5.x/7.7.x/7.8.x, OBIEE 10.1.3.x, Oracle BI Apps 7.9.x

ETL Tools

Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 7.8.5v

DB Tools

TOAD 7.x, SQL Plus 10.x/ 9.x/ 8.x, ODBC

Dimensional Data Modeling

Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Logical and Physical Data Modeling

Education:

B.tech

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship