PROFESSIONAL SUMMARY:

• Result Oriented IT professional with over 12+ years of experience in analyzing the Business Users Requirements, Application Design & Modeling, Development, Testing, Implementation, Documentation and Support of Business Intelligence using Oracle Business Intelligence (OBIEE/BI Publisher), Database Development using Oracle, ETL methodology for supporting data transformations & processing using Informatica PowerCenter/Oracle Data Integrator.
• 11+ years of extensive experience in providing end - to-end business intelligence solutions using OLAP/DSS tools like OBIEE 12.2.1.4.0/ 12.2.1.2.0 / 11.1.1. .1.1.7.1 5 / 11.1.1.7.0 / 11.1.1.6.2 / 10.1.3.2/3.3/3.4 , Oracle BI Publisher 11.1.1.7.0 / 11.1.1.6.0 / 10.1.3.4 and OBI Analytics 11.1.1.7.1 .
• Extensive experience in Installation, Configuration, Upgradation, Support and Maintenance of OLAP/DSS tools like OBIEE 12.2.1.4.0/11.1.1. .1.1.7.1 / 11.1.1.7.0 / 11.1.1.6.2 /11.1.1.5.0
• Expertise in User Requirement Gathering and converting the same into Technical Specifications.
• Worked extensively on OBIEE Administration Tool, Presentation Services/Answers/Analytics, OBIEE Interactive Dashboards, OBIEE Delivers/IBOTS, Cache Management, OBIEE Scheduler Configuration and Oracle BI Publisher.
• Proficient in building three layers (Physical Layer, Business Model & Mapping Layer and Presentation Layer) of OBIEE Repository using OBIEE Administration tool.
• Expertise in translating high-level business requirements into logical business dimensional model.
• Extensive experience, defining various logical subject areas and organization of Presentation Layer metadata; Understanding and defining key metrics, dimensions, hierarchies and attributes.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience in upgrading OBIEE Repository, Presentation Catalog, BI Publisher, BI Security from OBIEE 10g to OBIEE 11g using Upgrade Assistant wizard.
• Worked extensively on all the four ODI Navigators (Designer Navigator, Operator Navigator Topology Navigator and Security Navigator) and developed Mappings, Interfaces, Packages, Models and Data stores using different Technologies.
• Proficient working on various RDBMS (Oracle 11g/10g/9i/8i, MS-SQL Server 2014/2010/2008/2005 , IBM Netezza 7.2.1, Teradata v2r5, MS-Access etc).
• Extensive experience in Oracle Database Development and hands on experience in writing Oracle SQL queries and creating, testing and implementation of Oracle Database Objects like Tables, Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Views.
• Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses.
• Experience in integration of various data sources like Oracle 9i, SQL server 7.0, Teradata v2r5, Flat files and Excel files into staging area.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Ability to interact effectively with clients, understanding their requirements and providing optimum solution and production support.
• Strong understanding of Systems Development Life Cycle (SDLC).
• Highly motivated, enthusiastic professional with a high degree of commitment to succeed.
• Excellent writing, analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

OLAP/DSS Reporting Tools: OBIEE 12.2.1.4.0 / 12.2.1.2.0 / 11.1.1. .1.1.7.1 5 / 11.1.1.7.0 /6.2/10.1.3. x.x, Oracle BI Publisher 11.1.1.7.0 /6.0/10.1.3. x.x and OBI Analytics 11.1.1.7.1

Database Tools: TOAD 10.6/7.4/7.2 , SQL*Plus, SQL Developer, SQL Loader, Forms 6i/6.0/10g, Reports 6i/6.0/10g, SQL Server Management Studio 2008/2010/2014 , Aqua Data Studio 16.0.4.

OLAP/DSS ETL Tools: Informatica Power Center 7.1, Oracle Data Integrator 11.1.1.7.0

Databases: Oracle 12C/11g/10g/9i/8i, SQL Server 2005/ 2008/2010/2014 , IBM Netezza 7.2.1, Teradata v2r5

Programming Languages:

SQL, PL: SQL, and C.

Scripting Languages: Perl and Shell Scripting.

Operating Systems: Windows XP/2003/2008/7, Sun Solaris, Redhat Linux 6.0 and MS-DOS

Markup Language: HTML, CSS, XML

Tracking Tools: Mercury Quality Center 9.0/HP ALM 11, JIRA and Bugzilla 3.2.10

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. OBIEE Consultant

Responsibilities:

• Worked extensively on installation, configuration, upgradation and validation of OBIEE 12C on Sandbox, Development and Test environments as part of OBIEE 11g to 12C upgradation project.
• Reviewed Oracle matrix document for OBIEE 12.2.1.4.0 to ensure that the system meets the basic requirements, downloaded and unzipped the required installable files into a folder.
• Installed, configured and validated JDK, WebLogic, RCU, OBIEE and BI Domain.
• Worked on applying the bundle/one-off patches, validating the conflicts and rolling back them.
• Created import/export jar files to migrate the Catalog, Rpd and security from 11g to 12c system using migration-tool.cmd utility.
• Customized some of the OBIEE configuration files to accommodate the client requirements.
• Configured the Novell Authenticator (users) and BI SQL Group (Groups) providers in Fusion Middleware Administration console.
• Re-defined the application policies for custom application roles and deleted the unwanted application policies & application roles migrated from 11g system to 12C system using Enterprise Manger or Fusion Middleware.
• Created custom styles and skins using bicustom.ear/analytics.ear and deployed it through Administration console.
• Configured and validated BI Scheduler and Usage Tracking on OBIEE 12c.
• Customized the testconfig.xml file with PreUpgrade and PostUpgrade scripts and ran BI Validation Tool against both 11g and 12C systems.
• Also manually validated the OBIEE report/dashboards post upgradation and worked on fixing the issues identified and documented the defect status in JIRA.
• Drafted BI Installation, Configuration & Upgradation document by consolidating all the steps with the screenshots captured.
• Also responsible for the complete setup of 22 developer sandboxes.
• Installed the required ODBC drivers and migrated ODBC sources across different environments using export/import of REGEDIT.
• Migrated Rpd across the environments using datamodel.cmd download/upload utilities and web-catalog objects using archiving and unarchiving feature of catalog manager.
• Expanded the domain to include BI Publisher and utilized exportarchive.cmd/importarchive.cmd to migrate the contents across the environments.
• Reached out to Oracle Support on the outstanding issues/bugs identified as part of upgradation validation via SR’s and followed the recommendations from Oracle.
• Worked on the POC of configuring SSL for secure data exchange between client & server and drafted the steps.
• Worked on the POC of configuring SAML2 as authenticator/identity asserter for single sign-on and drafted the steps.
• Worked on creating usage tracking KPI’s using performance tile layouts and integrated them onto the dashboards in OBIEE 11g.
• Unit tested the developed reports by verifying the SQL generated by BI and debugged the SQL queries using SQL Services Management Studio utility against SQL Server database.
• Worked collaboratively with system architect/solution architect/project managers/data analysts/system administrators on deliverables.

Environment: Oracle Business Intelligence (OBI) EE 12.2.1.4.0/11.1.1.9.16 , Windows 10/Windows 2012R2/2010, SQL Server 2010/2014, SQL Server Management Studio 2014, JIRA 6.3, MobaXterm 6.5.

Confidential, Boston, MA

Sr. OBIEE/ODI Consultant

Responsibilities:

• Analyze the existing reports and identify the gaps based on the new subject area.
• Worked extensively on both Analytical and Operational models.
• Worked extensively on the three layers namely Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables and defined Fact & Dimensions using the physical (foreign key) joins in the physical layer of the repository.
• Created logical facts/dimensions having single or multiple logical table sources and defined complex joins in BMM Layer.
• Created dimensional hierarchies, logical levels, logical/chronological keys and defined content levels to the fact LTS’s in the BMM layer.
• Created new logical columns/measures/ level based measures using expression builder in BMM layer.
• Created subject area’s/presentation layer catalogs to show different views of the business model to different users, nested table folders and assigned group permissions to the catalog folders.
• Implemented custom landing pages to business users using PORTALPATH system session variable.
• Implemented Write Back capability to help business users to update the data using OBIEE.
• Repointed the existing BI reports to a new subject area and unit tested.
• Drafted pre- implementation and post-implementation documents.
• Created custom Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager of QC environment.
• Drafted OBIEE code migration documents and submitted the requests for migrations from QC to UAT and UAT to Prod.
• Created data servers, physical/logical schemas for different technologies in Topology Navigator and projects, models and data stores for various schemas in Designer Navigator of ODI.
• Developed various mappings, interfaces for loading data from a variety of source systems to target.
• Worked closely with Application Admins Rpd/Web-catalog deployments & security configurations related to OBIEE and scenarios for Interfaces & packages related to ODI.
• Used Oracle SQL Developer for validating and debugging SQL queries.
• Worked closely with QA team on fixing the defects and updated the defect status in HP ALM.
• Trained Users on creating their own ad-hoc reports.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.1 5/11.1.1.9.16, Windows 7, Oracle Data Integrator 12.1.3, Oracle database 11g, Oracle SQL Developer 11g, Tortoise SVN, HP ALM 11, MobaXterm 6.5,winscp 5.1.4.

Confidential, Leawood, KS

Sr. OBIEE Consultant

Responsibilities:

• Interacted with Business Users (Film Buyers/Operations team/Accounting Managers) and gathered report/dashboard specifications.
• Analyzed the requirements and created detailed level design documents.
• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data/repository using OBIEE Administration tool in a MUD environment.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Opaque Views and defined Facts & Dimensions using the foreign key joins in the physical layer of the repository.
• Created logical dimensions, logical facts, logical table sources, dimensional hierarchies, logical levels, logical/chronological keys and defined content levels in the BMM layer.
• Used expression builder utility to create new logical columns/measures/level based measures in the BMM layer.
• Created nested table folders, defined object level security and implicit fact in the Presentation layer.
• Worked extensively on OBIEE web catalog to create Reports/Prompts/Dashboards from a variety of subject areas with different Analytic views (Tabular, Pivot, Chart, Static Text, Narrative, Legend, Column Selector and View selector with global and local Filters) as per the requirements.
• Implemented a solution for dynamic column selection on the report/dashboard.
• Utilized the web-catalog column property features like data format, action links, Master- Detailed functionality and conditional formatting.
• Created OBI variables like Repository Variables, Session variables, Presentation variables and Request variables as part of the implementation.
• Worked on creating/configuring BI Agents to deliver Analytics/Dashboard content and scheduled them to deliver on timely basis via email.
• Created Usage Tracking Reports/Dashboards to monitor the BI Agents activity.
• Migrated OBIEE web-catalog objects from Sandbox to Dev environment by archiving and unarchiving features of OBIEE catalog manager/presentation services.
• Drafted OBIEE deployment document and prepared Rpd & web-catalog objects for migration from Dev to QA, QA to Stage and Stage to Prod.
• Worked closely with the BI Admin team for all code migrations, code validations, creation & granting required permissions for all users and security groups.
• Used Aqua Data Studio/SQL Server Management Studio to create & validate SQL queries for Opaque Views/Variable Initialization Blocks/BI Requests and to debug the SQL issued during report execution.
• Coordinated with the QA’s/BA’s on defect fixes and on deployments for retesting the dashboards.
• Reviewed the dashboards with the business users as part of UAT and also helped them with OBIEE Ad-Hoc queries/SQL BI requests.
• Involved in up-gradation and testing of OBIEE rpd and web catalog from OBIEE 11g( 11.1.1.7.1 5) to 12C (12.1.1.2.0 )

Environment: Oracle Business Intelligence (OBI) EE 12.2.1.2.0/ 11.1.1.7.1 5, Windows 7, SQL Server 2010/2014, SQL Server Management Studio 2010/2014, Microsoft Visual Studio Team Foundation Server 12.0

Confidential, Houston, TX

OBIA Consultant

Responsibilities:

• Designed and Implemented of OBIA HR Analytics using Oracle E-Business Suite as the source system.
• Configured, created and developed domain mappings using Applications Configuration Manager (BIACM).
• Scheduled, monitored and managed of ELT process using Oracle Data Integrator studio/console.
• Modified the OOTB ELT interfaces, variables, sequences, user functions, procedures and packages and regenerated the scenarios in Oracle Data Integrator (ODI) studio.
• Modified the OOTB ELT HR load plan to improve the performance of the full load by increasing the no. of accrual parallel threads and created a separate standalone load plan without accruals.
• Deployed ETL metadata using smart export from one environment to another and validated the deployed code.
• Configured, created, developed and customized repository/metadata using OBIEE Administration tool.
• Worked on OBIEE web services to create Reports / Dashboards as per the client requirements.
• Coordinated with Oracle on demand support on the implementation of BI application, open SRs, fix the errors and communicated status to the team.
• Deployed OBIEE metadata, OBIEE web-catalog related codes from one environment to another and validate the deployed code.
• Drafted and maintained the reporting documentation.
• Worked on HR analytics real time reports using Oracle BI Publisher
• Interacted with the functional team and gathered BI Report Specifications for real time reports.
• Created and configured datasets using query builder, LOVs (list of values) and parameters for building the data-model component of BI Publisher real time reports.
• Worked extensively on customization of report layouts (Tabular, Pivot Table and Chart View) using RTF template as per the client requirements.
• Used SQL Developer to debug the SQL queries to identify duplicate rows in the OLTP/OLAP databases, and to debug SQL queries issued during report execution.
• Took the ownership of managing the admin and managed servers in all the environments.

Environment: Oracle BI Cloud Service (OBIA 11.1.1.7.1 , Oracle BI Publisher 11.1.1.7.1 , Oracle Data Integrator 11.1.1.7.0 , Oracle Business Intelligence Applications Configuration Manager 11.1.1.7.1 , Oracle Functional Setup Manager 11.1.1.7.1 , Oracle WebLogic 11g, Oracle Database 11g, Oracle Enterprise Linux 5.9), Oracle SQL Developer 11g, MobaXterm 6.5, winscp 5.1.4, Windows 7.

Confidential, Houston, TX

Sr. Oracle BI Consultant

Responsibilities:

• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
• Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
• Used expression builder utility to create new logical columns/measures in the BMM layer.
• Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
• Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports via email using BI Delivers.
• Implemented OBIEE security using embedded LDAP and Microsoft active directory.
• Created new Users and assigned the users to the BI Administrators group in OBIEE 11g Administration Console.
• Created custom Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager.
• Implemented and Managed object level and data level security using custom User groups/Application roles.
• Ran the utilities nqudmlgen.exe and nqudmlexec.exe to downgrade the server repository version from .
• Merged on the repositories from Dev and Pre-QA environments using 3-way merging feature and deployed the new repository obtained from the result set in Pre-QA.
• Migrated OBIEE web-catalog objects from Dev to Pre-QA by archiving and unarchiving features of OBIEE catalog manager.
• Drafted OBIEE deployment document and prepared Rpd & webcatalog objects for migration from Pre-QA to QA.
• Coordinated with the administration team on deployments and validated the migrated code.
• Used SQL Server Management Studio to debug the SQL query issued during report execution.
• Coordinated with the QA team on defect fixes and on deployments for retesting the dashboards.
• Involved in the implementation of Usage Tracking reporting to monitor the user activity.
• Deployed Sample Application V309 on a physical server and recorded the implementation steps.
• Involved in setting up Multiuser Development Environment, documented the steps and trained other Developers on check-out and check-in process of a OBIEE project.
• Ran RCU (repository creation utility) 11.1.1.6.0 to drop and recreate BIPLATFORM and MDS schema’s on Production Server.
• Involved in the Installation of OBIEE 11.1.1.7.0 on new Production server and applied the patches to upgrade OBIEE to 11.1.1.7.1 31 that includes Mobile Application designer feature.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.0 / 11.1.1.7.1 3/ 11.1.1.7.1 4, Windows 7 / Windows Server 2008, SQL Server 2008, SQL Server Management Studio 2008, Microsoft Visual Studio Team Foundation Server 12.0

Confidential, Columbia, MD

Sr. Oracle BI Consultant

Responsibilities:

• Worked extensively on Oracle BI Publisher Audit (OOTB) and Operational reports (Custom).
• Analyzed business requirements documents.
• Created high-level and detailed design documentation.
• Installed jrockit (jdk1.6) and weblogic 10.3.6 in Dev and Test environments.
• Ran RCU (repository creation utility) 11.1.1.6.0 and created BIPLATFORM and MDS schema’s in Dev and Test environments.
• Installed Oracle BI Publisher 11.1.1.6.0 in Dev & Test environments.
• Configured the weblogic domain for BI Publisher for both the environments.
• Involved in the up-gradation of out of the box Oracle Fusion Middleware Audit (Access Manager, Identity Manager, Virtual Directory, Internet Directory etc.) Reports from BI Publisher 10g to 11.1.1.6.0. using upgrade assistant wizard.
• Created the JDBC’s and configured the reports pointing to this JDBC’s.
• Used Oracle SQL Developer to debug the SQL query issued during report execution and also to identify the data discrepancies.
• Optimized the SQL Query to improve the performance.
• Customized the SQL/PL-SQL queries as per the data attributes available within the database.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on customization of audit Report layouts (Tabular, Pivot Table and Chart View) using RTF template as per the client requirements.
• Created and configured datasets using query builder, LOVs (list of values) and parameters for building the data-model component of Operational reports.
• Worked on layout editor feature for defining the templates/layouts of operational reports.
• Implemented and managed BI security using Oracle Virtual Directory as an LDAP.
• Created new Users & custom user Groups and associated the users to the groups in Oracle Identity Manager.
• Created custom Application Roles and mapped them to the User Groups in Fusion Middleware Control / BI Enterprise Manager.
• Implemented and Managed object level security using custom User groups/Application roles in Dev environment.
• Worked closely and supported testing team in preparing test scripts, establishing test data, executing test scripts, recording and fixing defects in Bugzilla 3.2.10.
• Migrated BI Publisher reports from Sandbox to Dev and Dev to Test environments.
• Migrated security.xml file from Dev to Test environment to replicate object level security.
• Prepared Oracle BI Publisher Installation and configuration document to support the Infrastructure team for further installations in Implementation and Production environments.
• Prepared deployment documents for migrations from Test to Implementation and Implementation to Production environments.
• Worked closely with DBA’s for all the Database related issues.
• Took the ownership of managing the admin and managed servers in Dev and Test environments.
• Coordinated with development team and updated the project status to the development manager.

Environment: Oracle Business Intelligence Publisher 11.1.1.7.0 /11.1.1.6.0, Windows 7, Oracle 11g, Oracle SQL Developer 11g, Bugzilla 3.2.10, Redhat Linux 6.0, MobaXterm 6.5,winscp 5.1.4 .

Confidential, San Francisco, CA

Sr. OBIEE Consultant/Offshore Co-Ordinator

Responsibilities:

• Analyzed business requirements documents.
• Created high-level and detailed design documentation.
• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined complex joins.
• Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
• Used expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
• Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports via email using BI Delivers.
• Involved in the up-gradation of OBIEE repository and web catalog from OBIEE 10.1.3.4.2 to 11.1.1.6.9. using upgrade assistant wizard.
• Implemented and managed OBIEE security using LDAP and External Authentication.
• Created new Users & user Groups and assigned the users to the groups in OBIEE 11g Administration Console.
• Created Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager.
• Implemented and Managed object level and data level security using custom User groups/Application roles.
• Worked closely and supported with the business users in preparing test scripts, establishing test data, executing test scripts, and recording defects in JIRA.
• Migrated OBIEE Repository from Dev to Test and Test to Support environments using UDML.
• Migrated OBIEE web-catalog from Dev to Test and Test to Support using catalog manager.
• Prepared OBIEE code migration documents and submitted requests for migrations from Support to Prod.
• Coordinated with offshore development team and helped them with the roadblocks/concerns on the project.
• Used Oracle SQL Developer to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.0 /10.1.3.4.2, Windows 7, Oracle 11g, Oracle SQL Developer, JIRA.

Confidential, Pittsburgh, PA

Sr.OBIEE Consultant/Offshore Co-ordinator

Responsibilities:

• Analysis, functional/technical Requirements Gathering, Design, Development, Testing, Deployment, Maintenance, Documentation and Support.
• Interacted regularly with Business Users and gathered Report Specifications.
• Created high-level and detailed design documentation.
• Analyzed the logical Data model of the target systems and implemented it on local machine with sample MS Access data source to build mock up reports using Oracle SQL Developer tool.
• Created mock-up reports and dashboards for review by the business users.
• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined complex joins.
• Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
• Configured Intelligence dashboards by adding included and embedded content such as sections, Folders, Text, Links/Images, Guided navigation links, HTML objects for navigation.
• Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports via email using BI Delivers.
• Involved in up-gradation of OBIEE rpd and web catalog from OBIEE 10.1.3.4 to 11.1.1.6.2
• Prepared OBIEE code migration documents and submitted requests for migrations from Dev to QA and QA to Prod.
• Worked closely with the BI Admin team for all code migrations, code validations, creation & granting required permissions for all users and security groups.
• Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with Dashboards.
• Customized BI Publisher reports to meet the requirement by creating RTF (Rich Text Format) Templates using BIP Template Builder for Word.
• Worked closely and supported testing team in preparing test scripts, establishing test data, executing test scripts, and recording defects in Mercury Quality center/HP ALM.
• Worked closely with DBA and Data Modelers for all the Database related issues.
• Coordinated with offshore development team for couple of the projects and helped them with the roadblocks/concerns on the project.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
• Prepared functional & non-functional, Requirement Report Matrix and RPD documents by reverse engineering as a part of Production support documentation.
• Trained Users on the generated reports for the projects.
• Also worked as a Production Support Developer and resolved real time issues.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.6.2 /10.1.3.4, Windows XP, Toad 10.6, Oracle 10g Enterprise Edition, SQL*Plus, Oracle 11g, SQL Server 2005, Oracle Essbase 11g, Oracle SQL Developer, Oracle BI Publisher 10.1.3.4, Mercury Quality Center 9.0/HP ALM 11.

Confidential, Atlanta, GA

Sr.OBIEE Developer

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created mock-up reports and dashboards for review by the business users.
• Involved in the development of Metadata repository (.rpd) as per user requirements and available information in Data Warehouse.
• Created connection pools, defined joins and implemented authorizations in the Physical Layer of the repository.
• Imported required physical tables (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool and defined Physical Joins using new foreign key join.
• Worked extensively on BMM (Business Model and Mapping) layer using Star Schema.
• Created Logical Tables, Logical Facts, Complex joins between various Dimension and Fact Tables, additional Metadata in the Business Model & Mapping Layer Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on the Time Series function and implemented time comparison sales.
• Created materialized views and aggregates to improve performance.
• Customized the Presentation layer model objects and Re-named the data as necessary for the set of users.
• Analyzed and validated the repository file by performing check global consistency.
• Developed many Reports with different Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Web Answers and assigned them to application specific dashboards.
• Debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment.
• Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with Dashboards.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
• Configured iBots to deliver Analytics content based on schedule.
• Created proactive agents iBots (BI Scheduler) and interactive Dashboards and sent Alerts to High Level Client Users.
• Implemented security by creating roles & web groups, checks with External tables and LDAP.
• Involved in migration of Analytics .rpd and Web Catalog objects from developing environment to QA environment and to the Production environment.
• Trained Users on the generated reports for this project and documented the work.
• Participated in Post implementation reviews with the Project teams.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.4, Oracle BI Publisher 10.1.3.4, Oracle 10g, SQL*Plus, Sun-Solaris.

Confidential, San Francisco, CA

OBIEE Developer

Responsibilities:

• Extensively worked on Answers, Dashboards and Security for users.
• Worked on creating complex reports.
• Modeled the Logical Layer based on the Business requirements in the Business Model and Mapping Layer and Developed the necessary Star Schemas.
• Created Users, Groups by establishing a Connection to the existing LDAP Server.
• Worked on security for user based on external table authentication.
• Created Initialization Blocks and variables to call VPD Functions for establishing Client Level Data Security.
• Created various Static and Dynamic variables for different report and Security requirements.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Managed security privileges for each subject area according to user requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Generated custom reports by using OBIEE report features like Pivot tables, Charts, Ticker, Narrative and View selector.
• Assigned the customized reports to application specific dashboards.
• Maintained effectiveness in creating the Dashboards by appropriately including global prompts, column selectors, guided navigational links, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Modeled time series and slowly changing dimension (SCD) data in OBIEE Analytics.
• Trouble shooted errors in the BI Server and made backups for RPD’s.
• Interacted regularly with Business Users and gathered Report Specifications.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.3, Oracle 10g, Windows XP, Oracle SQL Developer.