We provide IT Staff Augmentation Services!

Obiee/obia Lead Consultant Resume

Hartford, CT

SUMMARY

  • Around 9+ years of IT experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse/ Data Marts and Business Intelligence. Involved in all the stages of SDLC and provided solutions to various clients.
  • Extensively worked on OBIEE 11g/10g and BI Publisher 11g/10g.
  • Strong Knowledge on OBIEE 12C.
  • Experienced in customizing Business Intelligence Dashboards/Score cards with drill - down capabilities using global and local Filters Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders and Reports).
  • Experienced on integrating BI Analytics with EBS.
  • Extensively worked on section conditions in Dashboards.
  • Extensively worked on OBIEE report performance tuning.
  • Extensive Experience in developing BI Publisher Reports in 10G/11G
  • Expertise in Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server and Oracle BI Publisher.
  • Implemented Best Practices in BI Publisher/XML Publisher.
  • Provided Production support extensively.
  • Expertise in writing complex queries and packages.
  • Expertise in Implementing Object level as well as Data level Security.
  • Expertise in creating, modifying and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.
  • Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters. Expertise in Implementing Object level as well as Data level Security.
  • Expertise in Performance tuning of OBIEE/Siebel Analytics by implementing Cache management and Aggregate Navigation techniques. Implementing Database tuning as well.
  • Experience Integrating OBIEE with OBI Publisher and Hyperion Smart view through Provider Services.
  • Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
  • Experience in troubleshooting Complex SQL queries and improved data delivery performance
  • Upgrades, performance tuning and optimization on Linux and Windows environment.
  • Extensively worked on installations and configurations of OBIA 11.1.1.7/ 11.1.1.9.2 on Exalytics and Linux VM Machines.
  • Experienced in installing OBIEE 12c on Exalytics Server.
  • Extensive Experience in Moving Middleware folders from one server to another and created a new environment without doing new installations (Changing the Hostnames).
  • Experienced in Installing times ten in Exalytics.
  • Experienced in upgrades and patching on OBIA 11.1.1.X in Linux and Windows machines.
  • Experienced Migrating objects (Catalog/Repository) from one environment to other.
  • Experienced in merging the repositories.
  • Expertise in integrating OBIEE with Webcenter Portal.
  • Expertise in Integrating OBIEE with EBS/PeopleSoft Portal.
  • Experienced in creating and Configuring Google Maps with Dashboards.
  • Experience in configuring LDAP/OAM/Database authentication.
  • Expertise in the complete Administration of OBIEE in LINUX/WINDOWS.
  • Expertise in migrating security from DEV to TST to PRD.
  • Expertise in installing and configuring J2EE agent.
  • Expertise in installing ODI 11g and ODI 12c.
  • Expertise in migrating ODI objects from one environment to other using smart export and smart import.

TECHNICAL SKILLS

OLAP/BI Tools: OBIEE 12C/11g, BI Publisher 11.1.1.9, Essbase 9.x/7.x/6.x

ETL Tools: ODI 11g/12C, Informatica Power Center 9.1.

Tools: Toad 4.0.3, Erwin, SQL Developer.

Methodologies: Ralph Kimball’s Star Schema and Snowflake Schema.

RDBMS: Oracle 12c, 11g/10g, MS-SQL Server 2005/2000/7.0/6.5.

Languages: PL/SQL, SQL, Java 1.2, HTML, XML.

O/S: Linux, Windows server 2003/2000, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

OBIEE/OBIA Lead Consultant

Responsibilities:

  • Designed Metadata repository(rpd) - Physical layer, Business Model & Mapping layer and Presentation Layer.
  • Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
  • Created Aliases and defined Role-Playing Dimensions.
  • Configured People Soft Security with BI using Database Authentication.
  • Created Custom Groups and Application Roles as per business requirements.
  • Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
  • Created multiple UNION reports.
  • Extensively used Session/Repository/Request/Presentation variables as per requirement.
  • Used Oracle Data Integrator for performing ETL, Data Integration, Data Cleansing efforts.
  • As per the business requirement created source to target mappings using filters, joins and different SQL expressions.
  • Created custom roles as per business requirement.
  • Integrated Google Maps with Dashboards.
  • Implemented Out of box OBIA 11.1.1.9.2 on People Soft Financial and HR Analytics .
  • Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Analytics.
  • Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer in OBIEE 11g.
  • Worked on setting up content levels and created level based measures.
  • Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
  • Assigned Object level and Data level Security.
  • Developed Repository from scratch based on Business requirement.
  • Installed and configured whole BI apps (OBIEE, ODI and Weblogic) in Linux environment.
  • Defining Business intelligence applications instances using BIACM in OBIA 11.1.1.9.2.
  • Configuring Source/Target systems.
  • Enabling the BI Applications offerings in BIACM.
  • Creating load plans using Manage Load plans.
  • Configuring Data load parameters/Reporting parameters in BIACM.
  • Functional Configurations using FSM.
  • Implementing the Projects.
  • Configuring the offerings.
  • Configure source codes with target codes using Managing Implementation Projects in FSM.
  • Resetting warehouse to run full load.
  • Configuring GL Accounts and Segments using CSV files.
  • Migrating Configurations from DEV to TPR to PRD using Export/Import Setup data or from repository tables.
  • ODI Installation, Configuration, creating master and Work repository. Setup of Topology, data Stores, projects and Security as ODI administrator
  • Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets.
  • Upgraded the PSFT 9.1 Adaptor to 9.2 Adaptor without redoing all customizations in ODI 11g through backend changes.
  • Modified the load plan to improve incremental load timings.
  • Worked on Topology Manager Module to manage the data describing the information systems physical and logical architecture.
  • Used custom incremental logic with MViews to run all mappings in Incremental load.
  • Responsible for Metadata Administration, managed Data models and reverse engineering
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
  • Extensively worked on Load Plan and Scenarios.
  • Customized Knowledge Modules (KM) to meet specific interface requirements.
  • Created Custom Packages and Procedures as per business requirement.
  • Extensively worked with variables to customize the flow of the package.
  • Created custom packages to run Scenarios in Asynchronous to improve the performance for long running Scenarios/Interfaces.
  • Customized the load plan as per business requirement.
  • Created many custom Interfaces to populate custom Facts and Dimension using out of box Knowledge Modules.
  • Worked on running scenarios/Packages outside in a Full/Incremental loads.
  • Customized the KM’s as per DBA’s suggestions to improve the performance.
  • Worked on running specific fact group in Incremental/Full Load.
  • Experience on running the load plans using DB Link.
  • Having knowledge on ODI REPO tables to enable or disable the variable values in database.
  • Experienced in migrating objects from one environment to other using Smart Export/Import. (DEV to TPR to PRD)
  • Purging the sessions log with custom procedure in Load plan.
  • Running multiple scenarios in parallel to improve the performance using ORA HASH.
  • Running load plan through command prompt/SH script.
  • Configured J2EE agent.
  • Passing HINT values or Alter Sessions or Variable values to Load plan/Individual Scenarios.
  • Customized the EXEC TBL MAIN as per business need.

Environment: OBIEE 11.1.1.9/12 C, ODI 11g, People Soft 9.1/9.2, BI Apps 11.1.1.9.2/7.1 , BI Publisher 11.1.1.7.0 , Oracle 11g/10g, TOAD, SQL, LINUX, Windows 2008 Server.

Confidential, Baltimore, MD

Sr OBIEE Developer

Responsibilities:

  • Worked extensively on the K12 Educational Data warehouse to retrieve all the facts and conformed dimensions to the OBIEE Repository.
  • Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements
  • Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Analytics.
  • Extensively worked on RTTT (Race To The Top) projects.
  • Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer in OBIEE 11g.
  • Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
  • Having experience on configuring Google maps with Dashboards.
  • Assigned Object level and Data level Security.
  • Having experience on Configuring Webcenter portal with OBIEE.
  • Configured OBIEE dashboards as Webcenter Spaces in OBIEE 11g.
  • Developed Repository from scratch based on Business requirement.
  • Upgraded from 11.1.1.5 to 11.1.1.7
  • Created Repository Groups and Web Groups and assigned users to configure security in OBIEE 11g.
  • Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
  • Worked on moving objects from DEV to TEST to PROD.
  • Scheduled reports to be e-mailed using BI Publisher Scheduler. Worked on Dashboard and Page level prompts and Report filters
  • Used Table and pivot table to display hierarchical columns
  • Created Aggregate Level facts to improve the performance in the reporting needs.
  • Developed Master Detail Report in OBIEE
  • Generated Report Name at Runtime in BI Publisher Bursting.
  • Created Hyperlinks to other reports.
  • Created excel templates using BI Publisher.
  • Worked Extensively on developing Excel Templates

Environment: OBIEE 11.1.1.7.0 , BI Publisher 11.1.1.7.0 , Oracle 11g/10g, Informatica Power Center 8.6.1, TOAD, SQL, Windows 2008 Server and Linux.

Confidential, Boston, MA

OBIEE/BI Publisher Developer

Responsibilities:

  • Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
  • Scheduled reports to be e-mailed using BI Publisher Scheduler.
  • Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
  • Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
  • Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
  • Created Aggregate Level facts to improve the performance in the reporting needs.
  • Developed Master Detail Report in OBIEE.
  • Implemented custom functionality in BI Publisher to prevent blank pages getting printed in reports.
  • Worked Extensively on developing E-text Templates
  • Created Multi Sheet Excel templates using XLSPE engine
  • Migrated Web catalog and RPD from one environment to other environment.
  • Developed Sql queries and PL/ sql packages from scratch to use as BI Publisher Event Trigger.
  • Upgraded Standard 6i reports to BI publisher reports.
  • Created Complex Matrix reports in BI Publisher.
  • Created Reports from scratch in 11.1.1.5
  • Created Packages and Procedures/Functions using Cursors, Global Temporary Tables, Record Types, and Table Types as per the requirement of the data model.
  • Involved in Setting up of users/roles in Oracle OBIEE/BI Publisher.
  • Converted all the existing Actuate reports into BI publisher Reports.
  • Converted Main Frames Reports to BI Publisher Reports.
  • Customized various BI Publisher 11G Reports using RTF templates and defined their respective Templates and Data Definitions.
  • Used Table and pivot table to display hierarchical columns.
  • Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
  • Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).

Environment: OBIEE 11.1.1.5.0 , BI Publisher 11g, ODI (Oracle Data Integrator), Toad, Linux/Windows.

Confidential, Richardson, TX

OBIA Developer

Responsibilities:

  • Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements.
  • Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
  • Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
  • Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
  • Creation of presentation layer tables by dragging appropriate BMM layer logical columns.
  • Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
  • Creating Users and Groups and managing the object level and data level security.
  • Managing the intelligent dashboards by using dashboard, page and report level security.
  • Creation of views like Pivot table, Column Selector, Compound layout.
  • Identified the granularity level of the data required to be available for analysis.
  • Involved in fine-tuning the reports by working extensively on the Caching Strategy.
  • Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Configured measures in the Business Model Layer and mapped to multiple logical source tables.
  • Extensively used Oracle Delivers and iBots so as to provide alerts.
  • Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.
  • Created RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

Environment: Oracle Applications, OBIEE 11g, OBIA 7.9.6.4, Informatica 8.1.1, Oracle BI Publisher, Oracle 10g, SQL, Windows XP.

Hire Now