Obiee 12c Developer Resume

SUMMARY:

Peter is a Canadian citizen, certified Oracle Specialist, and talented OBIEE developer with deep expertise in Analytics and BI solutions.
He has 6 years of experience deriving key insights and delivering answers dat lead to better business decisions using Oracle BI Publisher and Oracle Business Intelligence Enterprise Edition (OBIEE) versions 11g and 12c.
Combination of 6 years experience in OBIEE 11g and OBIEE 12C architecture, security, repository and dashboard development
Proficient with SQL/PL - SQL (me.e. create/modify stored procedures/debugging queries/performance tuning of reports)
Understanding of data warehousing, ETL concepts, OLTP, OLAP, Star and Snow Flake data models
Skilled in Caching & Mapping, data- level and object-level security, MUD, Variables/Initialization Blocks
Seasoned in building Reports and Interactive Dashboards with drill-down & drill-across capabilities
Working knowledge of ODI (Oracle Data Integrator)
Solid knowledge in Data Analysis, Data Modeling, Dimensional Modeling
Analytical, critical thinker and creative problem-solver
Excellent writing, analytical, communication and interpersonal skills
Strongly motivated team player who is detail oriented and capable of mentoring others

PROFESSIONAL EXPERIENCE:

Obiee 12c Developer

Confidential

Responsibilities:

Responsible for creating reports and dashboards with global prompts, column selectors, action links, conditional formats, and drill - down capabilities using OBIEE 12C Analytics
Configured proactive Agents /iBots to generate and deliver reports based on business requirements
Used OBIEE Web Catalog to secure catalog objects and set up access privileges based on LDAP Authentication and Application roles
Carried out Performance Tuning of Dashboards and Reports to improve query response time
Initiated user sessions and supported requests for enhancements and modifications of reports

Obiee 11g Developer

Confidential

Responsibilities:

Interacted with Subject Matter Experts and Business Analysts to gather requirements for analysis and to define business and functional specifications.
Worked in all three layers of teh RPD in a Multi User Development Environment (MUDE)
Utilized OBIEE 11g Administration tool to create connection pools, import metadata, join tables, make Alias tables, and design star/snowflake data models in teh Physical Layer
Designed logical columns, dimensional hierarchies, calculated measures, and level - based measures in teh BMM layer
Wrote debugging queries in Oracle SQL Developer and created schedules to seed and purge cache.

Obiee 11g Developer

Confidential

Responsibilities:

Worked with business analysts and team leads remotely to design and develop reports based on business requirements
Used BI Analytics to create various reports and Interactive dashboards
Configured iBots/Agents to schedule delivery of alerts and reports
Performed reports performance tuning and troubleshooting of all failed OBIEE components
Added conditional formats to simplify teh viewing of reports
Involved in user s on teh generated reports for dis project

Obiee 11g Rpd Developer

Confidential

Responsibilities:

Gatheird Business requirements and identified sources for analytical data by interacting with teh business users
Involvement with ETL (Extract - Transform-Load) development team to communicate teh specification for teh required dimensional, aggregate and indexed data tables
Worked extensively on performance tuning by utilizing cache management techniques, usage tracking, event polling tables, and aggregate tables
Streamlined administrative tasks and allowed dynamic modification of metadata content using initialization blocks for session and repository variables
Configured security and managed permissions for Subject Areas and Objects in teh OBIEE Administration Tool
Coordinated teh OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to teh Production environment.

Obiee 11g/Bi Publisher Developer

Confidential

Responsibilities:

Used XML data and report layout templates to create BI Publisher reports Implemented Bursting techniques for BI Publisher
Managed OBIEE 11g security by creating users and assigning them to groups.
Made use of aggregate tables and cache management techniques to enhance performance
Added prompts, filters, and different views such as charts, gauges, and tree maps to reports