We provide IT Staff Augmentation Services!

Senior Obiee Consultant Resume

VA

SUMMARY:

  • Over Eight years of experience in full life cycle includes Design Analysis, Application Development, Implementation, Maintenance and Documentation of Data Warehouse, Data mart and Business Intelligence using OBIEE, Informatica and BI Applications.
  • Experience in implementation of Data Warehouse, BI solutions and a 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.
  • Implemented Scheduler- iBots, Alerts and report bursting-proactive reporting. Worked on Disconnected Analytics, Usage tracking, event polled cache purge and cube views.
  • Created, modified and formatted requests, along with charts and filters, in OBIEE Answers.
  • Developed various Dynamic and Interactive Dashboards/ Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers.
  • Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
  • Extensively involved in configuring BI security using External table Authorization and LDAP Authentication.
  • Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBIEE Repository.
  • Expertise in configuring various analytics for Finance, Pharmaceutical, Insurance, Distributing Sectors.
  • Experience with the Oracle EBS/PeopleSoft (Oracle Apps): Financial, Supply Chain & Order Management and Project Analytics in particular and DAC (Execution Plans, Subject Areas, Containers, Design, Setup, and Execute etc.).
  • Worked with BI publisher 10g/11g, created and managed highly formatted reports for a different data sources.
  • Worked with newly introduced features in BI Publisher 11g: building new data models and creating and editing new report layouts within the BI Publisher interface.
  • Expertise in creating Union Reports, Repository Variables, Presentation Variables Dashboard Prompts and Briefing Books.
  • Extensive experience in BI Publisher, which includes working on Data Models, Data sets, Report Job scheduling, report development objects like data templates and RTFs.
  • Extensive experience in configuring Interactive dashboards with drill-down capabilities, Security Setup, Metadata Objects and Web Catalog objects.
  • Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.
  • Experience in configuring Security Settings (groups, roles, report privileges), Upgrading and scheduling iBots/Agents for OBIEE 10g and OBIEE 11g
  • Responsibilities handled include requirement study, functional study, system analysis, programming, testing and implementation support.
  • Self-starter, motivated to learn, takes initiative and has experience working on complex projects and strict deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6,ODI 11.1.1

Business Intelligence Platform: OBIEE 11.1.1.7/11.1.1.6/11.1.1.5/11.1.1.3/10.1.3.4 , Oracle BI Application 7.9.4/ 7.9.5/7.9.6. x/ 11.1.1.7.1 , BI Publisher 11.x

Analytics Packages: HR Analytics, Financial Analytics, Supply Chain and Order Management and Procurement and Spend Analytics.

Databases: Oracle 11g/10g/9i, SQL Server 2005, Essbase Versions 11.1.1.3/ 9.3.1 , PeopleSoft 9.1,Oracle EBS 11.1.5.10/R12,Taleo Business Edition 12.5

PROFESSIONAL EXPERIENCE

Confidential, VA

Senior OBIEE Consultant

Responsibilities:

  • The IT sector is implementing “Project Accelerate” for conversion of their source system from JD Edwards to Oracle EBS R12, OBIEE is implemented as a part of their reporting system to replace the old crystal reports.
  • Designed and Developed OBI Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
  • Developed Time Series object for comparing between the months, quarter’s sales.
  • Developed complex reports involving complex SQL filters.
  • Successfully Organized Bi-weekly Scrum meeting as part agile methodologies and creating weekly status review meeting notes.
  • Extensively used presentation variables to develop the logic for the reports.
  • Implemented Security by creating roles & web groups, checks with External tables and LDAP.
  • Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters and Column Selector etc.
  • Created Materialized views and indexes for improving the performance.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To-Date functions.
  • Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.
  • Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive Training to business users and to enable the use of Ad-hoc Reporting.
  • Also involved in all production support activities, incident ticket resolving, issues fixing and troubleshooting the problems.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services.
  • Perform end to end unit testing upon completing custom monthly FTE and Payroll reports comparing against legacy system reports.
  • Created and implemented operational dashboards provided instant insight for Organization’s business by providing them with relevant and timely information, allowing executives to instantly identify and apply appropriate check points to improve their efficiency.
  • Extensively interacted with client to provide all the necessary information and documented all the installation and configuration activities that are performed at onsite.

Environment: OBIEE 11.1.1.7, Oracle E-Business Suite R12, Oracle11g, SQL Developer, ODI 11.1.1 PL/SQL.

Confidential, TX

Senior OBIEE Consultant

Responsibilities:
  • Installed the Oracle BI Enterprise Edition on distributed environment and responsible for administration and migration of repositories between various environments.
  • Involved in translating functional requirements into technical requirements assisted in building detailed project schedule, gathering the requirements, completed the proof of concept.
  • Actively involved in creating custom Interactive Dashboards, Answers and Administering Oracle BI Apps Applications
  • Involved in Daily status meetings and preparation of operational plan and Involved in technical Conference Room Pilot sessions.
  • Worked with Oracle BI Apps (OBIEE) Installation, Oracle BI Server, Presentation Server, Repository and Oracle BI Administration.
  • Developed User Interface (UI) components Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts using Oracle BI Presentation Services.
  • Development using Oracle BI Repository like, Physical Layer, Logical Layer, Presentation Layer
    Analysis, Design, development and customization of Reports and Dashboards in OBIEE.
  • Daily client interaction. Preparation and execution of the test plans.
  • ETL process using Informatica for deploying BIEE reporting solution and optical metadata modeling. Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
  • Created Guided Navigation Links within OBI Dashboards
  • Customized the OBIEE web user interface to meet Client reporting standard and developed key business Reports and Dashboards.
  • Developed yearly and quarterly sales trending reports using time series functions like ago and To-date.
  • Involved in applying department level data security for all BI reports and dashboards. Implemented the Cache Purging Strategy and usage tracking of Reports.
  • Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
  • Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.

Environment: Oracle BI Apps 7.9.6.3, OBIEE 11.1.1.6, Informatica 8.6, Oracle E-Business Suite R12, DAC, OBAW, Oracle11g, SQL Developer, PL/SQL.

Confidential, VA

OBIEE Consultant

Responsibilities:
  • Worked with multiple business groups and individuals in the process of Requirements Gathering.
  • Extensively involved implementing LDAP Security with External Table Authorization.
  • Organized meeting with Business users as part out of the box reports GAP analysis and gathering requirements for custom reports.
  • Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
  • Worked on scheduling Daily incremental loads after creating new client specific execution plan.
  • Created workflows with the event wait task to specify when the workflow should load the tables.
  • Customized the repository and created new requests using Answers.
  • Developed the financial reports from different subject areas like FMS-AP-Account Entries, FMS-AP-Aging Process and reports like Listing of intra fund elimination exceptions, Payroll Disbursements.
  • Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
  • Configured OBIEE Event Caching and Cache management features for improved end-user query experience.
  • Worked closely in migrating the Security Groups, Id’s, Users at the time of migration along with catalog.
  • Organized the presentation layer in a format that is easy for end user for Ad-hoc reporting.
  • Involved in Merge and Migrating RPD that include Repository and Catalog files from Development to Integration, QA and Production Environments.
  • Debugged and optimized the OBIEE Dashboards / Reports
  • Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive Training to business users and to enable the use of Ad-hoc Reporting.
  • Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.

Environment: OBIEE 10.3.4.1/OBIEE 11.1.1.5, Informatica 8.6, SQL Explorer 3.0, DB2 9.1.4, Oracle 10g, Windows XP, AIX.

Confidential, PA

OBIEE Developer

Responsibilities:
  • Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
  • Involved in Creating and Administering the Physical Layer, Business Model & Mapping
  • Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
  • Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
  • Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
  • Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
  • Involved in Design and Data Modeling using Star schema.
  • Developed several mappings to load data from multiple sources to data warehouse.
  • Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.
  • In Reports created the charts, tables, Pivot tables, View/Column selector, prompts etc.
  • Design and configuration of BIP reports using BI Publisher for sharing the reports with Regulatory Authorities.
  • Utilized BI (XML) Publisher to create Data Templates, RTF, and XSL Templates.
  • Creating data models, parameters, templates and writing SQL Query for getting the data from source tables to design the BIP reports.

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6, DAC, Oracle 10g

Confidential

DataWarehouse Consultant

Responsibilities:
  • Worked with Business Analysts and Business Users in the design of technical specification documents for data warehouse during multiple phases of the project
  • Participated and provided input in business review meetings for approving logical and physical data models
  • Involved in gathering user requirements and analysis.
  • Involved in working with heterogeneous data sources like flat files, DB2 and Oracle.
  • Implemented Type2 Dimension Model In Customer/Supplier/Product - record book. I.e. new attributes/columns were introduced in the dimension tables by slowly changing dimensions.
  • Used complex mappings involving Target Load Order and Event based loading.
  • Created various transformations like Joiner, Lookup, Router, Filter, Update Strategy Sequence Generator, Sorter and Stored Procedure.
  • Created Mapplets for reusable business rules.
  • Created Shortcuts to reuse objects across folders without creating multiple objects in the repository.
  • Loaded bad data using reject loader utility and actively coordinated with testing team during Integration and Regression testing
  • Dealt successfully with resource problems and reduced the turnaround time of DBA with data warehouse issues
  • Implemented performance tuning techniques at system, session, mapping, transformation, source and target levels

Environment: Oracle 10g, Informatica 8.1x, Windows 2003 R2, 10.1.3.x, HP Quality Center, Toad

Confidential

Oracle Developer

Responsibilities:
  • Involved in identifying and analyzing user requirements, preparing testing specs, database designing.
  • Involved in development of online intranet Leave application & Time sheet management /HR payroll is for board wide use.
  • Involved in designing database schema and implementing the software.
  • Developed User Interface screens (GUI's) with Visual Basic.
  • Responsible for forming SQL queries as per the criteria selected by user
  • Created Stored Procedures and triggers.
  • Involved in analyzing user requirements.
  • Created the Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
  • Involved in design, development and modification of PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.
  • Performance tuning of SQL queries, checking the most expensive queries using Explain Plan.

Environment: Oracle 10g, SQL Developer, SQL*Plus, TOAD, Windows XP

Hire Now