We provide IT Staff Augmentation Services!

Obiee Developer Resume

Columbia, MD

SUMMARY:

  • Have 4+ years of experience in OLAP tools like Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x and hand on experience on 11.1.1.5.
  • Worked extensively on OBIEE Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer
  • Extensive experience in OBIEE Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher
  • Excellent aptitude in translating high - level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor
  • Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series functions etc
  • Skilled with Caching & Mapping, data- level and object-level security , MUD, Integration Variables/Initialization Blocks configuration
  • Highly skilled in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization
  • Very good with implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
  • Proficient in working on production and development environment in different RDBMS (in Oracle 10g/11i)
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
  • Strongly motivated, enjoy team work and capability of mentoring others and learning new skills
  • Excellent writing, analytical, communication and interpersonal skills

TECHNICAL SKILLS:

OLAP/Reporting Tools: OBIEE 11g/ 10.1.3.4.1

Operating System: Windows 9x/2K /NT, XP

Databases: Oracle 10g/11g

DW Utilities: Oracle SQL Developer, Microsoft SQL Server 2008

Languages: SQL, HTML, XML

PROFESSIONAL EXPERIENCE:

OBIEE Developer

Confidential, Columbia, MD

  • Created OBIEE 11g Simple Navigation training modules for Consumers and an Advanced Tutorial for Power Users and Authors.
  • Worked on various Reports /Dashboards in BI Analytics with different analytics views:
  • Drill-down
  • Dynamic
  • Narrative
  • Charts
  • Pivot tables
  • Column selector and View selector
  • Local filters
  • Created and modified Interactive Dashboards
  • Performed administrative tasks related to the development and configuration of Interactive Dashboards.
  • Customized and developed OBIEE Analytics Reports and integrated them in dashboards.
  • Used BI analytics to run queries, test, and reports and validated the repository.
  • Met with business representatives, business analysts and end users to understand the business models and functionality.
  • Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements.
  • Imported physical tables and defined joins in the physical layer of the repository.
  • Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository.
  • Created dimension hierarchies and level based measures, built time and calculated measures of a fact table.
  • Used the rename wizard to rename fields and tables.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Created groups and added users to the groups and granted privileges.
  • Customized the Oracle BI Presentation Services user interface.
  • Assigned Users to groups and granted permissions.

Environment: OBIEE 11g, Reports, Dashboards, BI Analytics, SQL, Oracle 11g, Html, XML, SQL

OBIEE Developer

Confidential, Gaithersburg, MD

  • Worked on various Reports /Dashboards in BI Analytics with different analytics views:
  • Drill-down
  • Dynamic
  • Narrative
  • Charts
  • Pivot tables
  • Column selector and View selector
  • Local filters
  • Created and modified Interactive Dashboards
  • Performed administrative tasks related to the development and configuration of Interactive Dashboards.
  • Created agents for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist process owners with timely decision making.
  • Customized and developed OBIEE Analytics Reports and integrated them in dashboards.
  • Used BI analytics to run queries, test, and reports and validated the repository.
  • Met with business representatives, business analysts and end users to understand the business models and functionality.
  • Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements
  • Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository
  • Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository.
  • Created dimension hierarchies and level based measures, built time and calculated measures of a fact table.
  • Used the rename wizard to rename fields and tables
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs
  • Created repository and session variables
  • Created groups and added users to the groups and granted privileges
  • Customized the Oracle BI Presentation Services user interface
  • Performance tuning experience included modeling aggregate tables to speed query processing and partitions and fragments to improve application performance, usability and caching
  • Enhanced performance tuning using the SQL developer
  • Worked in a Multi User Development ( MUDE) Environment check out repository, made changes, and completed the merge process
  • Tested and modified OBIEE security for the internal controls environment

Environment: OBIEE 11g, Reports, Dashboards, BI Analytics, SQL, MUDE, Oracle 11g, Html, XML, SQL

OBIEE Developer

Confidential, Gaithersburg, MD

  • Developed Interactive dashboards with drill - down capabilities and dynamic dashboard prompts to zoom into particular segments of the business
  • Used Filters and provided customized prompts to appropriately to avoid excessive data showing up on reports
  • Created reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards
  • Creatively used OBIEE to set up conditional formatting to develop pricing models
  • Created agents to send pre-processed reports
  • Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements
  • Assisted in developing Metadata Repository
  • Customized the OBIEE repository ( Physical, BMM, and Presentation layers).
  • Built star and snowflake schemas in the repository
  • In the BMM- Created logical tables, whole diagrams using complex joins, dimensional modeling design and building business models
  • Defined drill- down time series and other dimension hierarchies
  • Used Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements
  • Used Rename Wizard to rename fields and tables
  • Created repository and session variables
  • Performed Installation and Configuration of OBIEE Software to set up enterprise
  • Oracle BI Publisher

Environment: OBIEE 11g, Reports, Dashboards, BI Analytics, SQL, MUDE, Oracle 11g, HTML, XML, SQL

OBIEE Report Developer

Confidential, Rockville, MD

  • Requirements Gathering
  • Created standard and adhoc reports in different views
  • Organized the Dashboards
  • Created filters, protected the filters and also created dashboard prompts
  • Hard coded the prompts according to the users business needs
  • Created Action links and Web links on various reports per user specifications
  • Discussed and gathered the analytics requirements from different user groups

Environment: OBIEE, Dashboard, Reports, Oracle 11g, HTML, XML, SQL

OBIEE Developer

Confidential, Rockville MD

  • Interacted with management to identify key dimensions and measures for business performance and this allowed management to quickly focus on relevant aspects of the business and make effective and profitable decisions.
  • Created reports and dashboards and assigned the users to the groups
  • Actively trained users so that they could efficiently navigate the dashboards
  • Created reports and set up alerts to deliver specific information to the users at a specific time in order to enable then to make decisions in a timely manner.
  • Involved in building star and snowflake schemas in the repository
  • Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
  • Modeled aggregate tables to speed up query processing and managed cache
  • Worked in a Multi User Development (MUDE) Environment check out repository, made changes, and completed the merge process

Environment: OBIEE, Dashboard, Reports, Oracle 10/11g, HTML, XML, SQL

Data Analyst/Developer

Confidential

  • Assisted in business requirements gathering, analysis, design and data modeling
  • Interacted with management to identify and determine the functional specifications for business processes
  • Created Reports and collection strategies to improve revenue collection and business performance
  • Extracted/Created Reports from Excel Spreadsheets data sources
  • Data modeling
  • Assisted in building the Physical, Business Model and Mapping and Presentation layer of the repository
  • Involved in building star and snowflake schemas
  • Assisted in creating interactive dashboards
  • Created Pivot tables allowing managers to analyze the business from different perspectives and in an orderly summarized manner

Environment: OBIEE, Dashboard, Reports, Oracle 10g, HTML, XML, SQL

Hire Now