SUMMARY:

• 8 years of experience as Oracle Business Intelligence and Applications Consultant with successful track record in gathering user requirements, designing, developing and supporting different Business Applications.
• Experienced in customizing Intelligence Dashboards/Scorecards with drill - down capabilities using global and local Filters Analytics Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Good Knowledge in Developing OBIEE Reports using 11G/10g.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Developed different types of reports including RTF, EXCEL, and ETEXT TEMPLATES.
• Expertise in Oracle BI Publisher, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server.
• Followed the Agile methodology to develop full life cycle project development.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Strong experience in developing and customizing Reports and Forms using Oracle Reports 10g/4i Discoverer 10g/4i and XML Publisher 5.6.3/5.6.2, OBIEE 10.1.3.x.
• Experience in supporting the production system and handling day-to-day issues.
• Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.
• Migrated Repository and Web Catalog from one environment to another environment.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Very proficient in SQL tuning and optimization of queries
• Excellent analytical, problem solving and communication skills with ability to be an effective team member and have the capability to work under severe time constraints.

TECHNICAL SKILLS:

BI Tools: Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.0.0/11.1.1. x/ 10.1.3.x, BI Apps 7.9.6.x/7.9.5.x and BI Publisher

ERP: Oracle EBS

ETL Tools: Informatica 9.1/9.5/8.x/7.x

RDBMS: Oracle 11g/ 10g/9i/8i/7.x,Netezza

Utilities: SQL Developer, TOAD, SQL*PLUS

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, XML, XLST.

Operating System: Windows 07/NT/XP/2000/98, Sun Solaris, Unix, Linux

WORK EXPERIENCE:

Confidential, San Francisco, CA

OBIEE Developer/ BI Analyst

Responsibilities:

• Designed, Developed and Analyzed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model/layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders.
• Interacted with the end users for requirement gathering and defined requirement specifications document.
• Involved in Data Modeling, Design documents and data warehouse.
• Installed and Configured OBIEE 11g and 12C.
• Understand project requirements and work towards design and developments of the plan layout.
• Created connection pools and imported the metadata into Physical layer.
• Built Business model and established relationships, created joins, level based measures in BMM Layer. Created Time-series function.
• Created different types of Customized Reports Drilldown, Dimensional hierarchies, Aggregation to meet client requirements.
• Organize presentation layer in a format that is easy for end users to use as basis for reporting using Oracle BI Administration tool (.RPD).
• Worked with session and repository variables and initialization blocks to streamline administrative tasks for generating filters and defining security.
• Generated various Analytics Reports.
• Implemented OBIEE security at the object, data levels and Restricting data for particular users using Row level security and User filters.
• Developed OBIEE Dashboards, Analysis, Prompts, KPI’s and scorecards using global and local filters.
• Created different analytics views including Pivot Table, Charts, Gauges, Column Selector, View Selector and prompts using Oracle BI Presentation Services.
• Validated the data in SQL Developer to make sure the reports were consistent.
• Migrated OBIEE Dashboard, Pages, Reports and other web catalog folders from DEV to UAT and UAT to Prod
• Added users, Application and Catalog roles and configured security in WebLogic console of OBIEE 11g.
• Involved in Performance tuning and enhancing the reports/dashboards using cache management and working with the DBA to figure out if we needed to create indexes, aggregate or partition columns to increase the processing time of reports.
• Created detailed design documentation and unit test plans in SDLC documents.
• Providing guidance and support to end users during the implementation and in production

Environment: OBIEE 11g, OBIEE 12c, BI Publisher 11g, ODI, Oracle 11g, SQL Developer, TOAD, Windows7, Supply chain management, PeopleSoft

Confidential, Lake Forest, IL

OBIEE/ BI Publisher Developer

Responsibilities:

• Worked as an OBIEE /BI Publisher Developer in multiple projects
• Primary responsibilities include gathering business requirements, designing the functional and technical specifications
• Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository as per the Standards
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Worked on Dashboard and Page level prompts and Report filters
• Created Logical Columns based on other Logical and Physical columns in the BMM layer
• Worked on Agile methodology to keep the whole team involved in the project in terms of communication.
• Gave a scope for enhancements and Change management in place with agile methodology.
• Designed Schemas using Fact, Dimensions, Hierarchical, Physical, Logical, Alias and Extension tables with star and snowflake architecture
• Managed security privileges for each subject area and dashboards according to user requirements
• Developed ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters)
• Developed and tested Store procedures, Functions and packages in PL/SQL for BI Publisher reports
• Developed BI Publisher reports using Dynamic SQL
• Migrated Oracle 6i reports into Oracle BI Publisher
• Trained IT resources to Develop reports using BI Publisher tool, OBIEE Admin tool and trained Business users for ad hoc Reporting
• Developed different TEMPLATES for BI Publisher reports.

Environment: OBIEE 11.1.1.6, BI Publisher 11g,Oracle reports6i/9i,Maximo,ODI, Oracle 11g,TOAD, Unix

Confidential, Rockville, Maryland

OBIEE Developer/ BI Analyst

Responsibilities:

• Worked as an OBIEE Developer/Technical Analyst in multiple projects. Implemented OBIEE/BIP across multiple environments and developed metadata for each aspect of the business to report on.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Worked with Security team to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, Filters and also implemented Object level and data level Security
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE 11g Administrator tool.
• Reporting on two Fact tables using conformed dimension
• Migrated Analytics RPD and Web catalog from one environment to another
• Developed ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, and business rules with user identity and roles within the OBIEE/BIP
• Developed BI Publisher reports using Bursting Definition to deliver to a server/File.
• Developed different types of BI Publisher reports including RTF, EXCEL, ETEXT TEMPLATES
• Worked with JAVA Developers to run BI Publisher reports using BI Publisher web services
• Trained IT resources to Develop reports using BI Publisher tool and trained Business users for ad hoc Reporting
• Designed Reporting Standard and Guidelines Document(SPP Standards)
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Migrated Web catalog and RPD from one environment to other environment.
• Used the expression builder in the BMM layer and created various calculation measures.
• Created Dimensional Hierarchy, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer to improve performance in rpd.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Involved in Unit Testing and Performance Testing for reports.

Environment: OBIEE 11.1.1.7/11.1.1.6, BI Publisher 11g, Oracle 11g, Informatica 9.5/9.1, TOAD, Unix, Netezza

Confidential, TAMPA, FL

OBIA/ OBIEE Developer

Responsibilities:

• Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and to date functions.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level. .
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications
• Developed many Full/Incremental Informatica Objects (Workflows/Sessions, Mappings/mapplets) with various transformations.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.

Environment: Oracle Applications 11.5.10, Service Requests, Service Contracts, Install Base, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 11g, OBIEE 10.1.3.4.1, Informatica 8.6.1, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g, Reports 10g, SQL*PLUS, SQL*Loader, TOAD, Unix

Confidential

OBIEE Developer

Responsibilities:

• Integrated OBIEE with EBS for Single Sign On (SSO).
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Implemented Financial Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Worked on Oracle/PeopleSoft reports on OBIEE for GL, AP and Projects.
• Created Budget vs Actual report with details drill down for each Cost Center.
• Created/Modified/ Customized Metadata repository (.rpd) and Configured Metadata Objects using OBIEE Admin tool.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Interacted with SME’s, Business Analysts and Users for gathering and analyzing the Business Reports Requirements.
• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse.

Environment: Oracle Applications R12 (GL, AR, AP, OM, INV, PO), OBIEE 10.1.3.4.1, Oracle BI Applications 7.9.6.1, Oracle 10g, Informatica 8.6.1, DAC 10.1.3.4.1, SQL*Loader, TOAD