SUMMARY

• 8+ years of experience in IT industry involving requirement analysis, design, development and implementation of Business Intelligence, RDBMS applications under different environments.
• Participated in migrating OBIEE 11G to 12C environment.
• Extensive experience in OBIEE 10g/11g/12c including configuring repository, creating/managing OBIEE Intelligent Dashboards including gauges, graphs and charts, Analysis, Answers (AdHoc) and BI Publisher.
• Experience with all components within Oracle's BI Applications (OBIEE) including Presentation Services, Dashboards, Agents, BI Server, BI Publisher and Report Server.
• 8+ Years of Architect/Lead experience in handling all phases of SDLC of BI projects.
• Have an excellent experience in working on UNIX/LINUX platforms.
• Extensive experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBIEE Administration Tool.
• Expert in creation of dimension and fact tables, logical columns, hierarchies, drilldowns, level based measures in Business model& mapping layer.
• Created many session and repository variables. Created users, roles in console and assigned them to groups in Enterprise Manager and implemented security.
• Extensive experience on assigning Data security & Object Level Security to the users using OBIEE repository objects, external database and LDAP.
• Experience in creating users and assigning them to their respective groups and roles.
• Extensive experience in creating Metadata Objects (subject area, table, column) and Web Catalog Objects (Dashboards, Pages, and Reports).
• Developed reports and dashboards with various analytical views with Global and Local Filters, Customized Prompts at page level and Dashboard level.
• Created exclusive views as Trellis view, Pareto charts, Sliding graphs for providing an excellent and interactive interface for end users.
• Executed OBIEE Administrative Tasks and BI Publisher reports (formerly known as xml publisher) in assigning various templates to publish the report as per requirements.
• Involved in upgrading the application from OBIEE 11g to 12c and configured the internal and external Components to retain the application functionality, security, look and feel.
• Worked on Middleware(EM & CONSOLE) admin tasks .
• Used XML, and XSL for advanced report features and formatting.
• Designed Star schemas, Snowflake schemas for Data Marts and Data Warehouses.
• Participated actively in many major and minor releases and deployed RPD and migrated catalog from development environment to testing and from testing Environment to PROD.
• Worked with Smart View and developed reports using BI data in Excel, Word and PowerPoint for presenting to users.
• Worked extensively on BI Publisher and published reports to users.
• Have good Knowledge working with OBIEE 12C and Visual Analyzer.
• In - depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Data Validation to check if data is consistent in the reports and dashboards and performance tuning the reports.
• Comprehensive knowledge in debugging, optimizing and troubleshooting the Oracle BI / Siebel Analytics Dashboards /Reports.
• Extensively experienced in designing, building, implementing, and deploying data universes/data models against Oracle and other databases.
• Played a prominent role in testing data accuracy in reports with backend data.
• Implemented ETL(extract Transform Load) using ODI. Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Implemented the Projects, Interfaces, Scenarios and Packages in ODI. Scheduled and Monitored the load process using ODI.
• Design ODI/ETL mappings and flows by interacting with the in-house BI technical Lead, business analyst and other team members
• Worked on setting up the ODI connection with Oracle, MS SQL Server and flat files.
• Installed and configured OUA(Oracle Utility applications) for CCB & ODM.
• Customized Out of the box Knowledge modules, ODI mappings and packages, Load plans according to the business requirements in OUA
• Customized Out of the box RPD, Reports, Dashboards according to user requirements in OUA
• Experience in Translating the Business Requirements to Functional and Technical specifications (Design documents (LLD AND DLD) and unit test cases.), ensuring the delivery and tracking requests.
• Expertise in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Improve the performance by creating Indexes (B Tree, Bitmap), Hints, Partitions, Bulk Processing, Collections (nested tables, arrays, and associative arrays) and defining exceptions to handle the run time errors.
• Expert in working with MUD (Multi User Development) environment in OBIEE.
• Worked on various OBIA modules as sales, financial and hr.
• Experience in Oracle database, SQL Server, Essbase and other databases.
• Have excellent knowledge in connecting to various databases and data modelling to create various views as charts, graphs using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1.
• Building, publishing customized interactive reports and dashboards, report scheduling using TIBCO SPOTFIRE
• Have knowledge on TIBCO ADS(Action Data Services).
• Recently started implementing Devops (onestash, Jenkins and GIT HUB) for viewing various files in server and automated process of deploying RPD instead of using em.
• Create deployment artifacts for migration of the solution on various environments following the stages of the project and provide documentation on all deliverables.
• Have immense ability to multi-task and have excellent communication skills.
• Had meetings and dealt with clients and developers on a regular basis.

TECHNICAL SKILLS

Business Intelligence tool: OBIEE 11.1.x,10.1.3.x,12C, TIBCO SPOTFIRE 7.11, TABLEAU 8.1

Programming Languages: C#, C, C++

Database Technologies: SQL Server 2000/2005, Oracle 11g,10g,SQL, PL/SQL

Operating Systems: Windows 2000/2003/NT, Unix, Linux

Tools: SQL *PLUS, SQL Developer, Toad, DAC, MS OFFICE, SmartView 9.3.1,Visual Analyzer, Tableau, TIBCO SPOTFIRE

ETL Tools: ODI 11.1x/10.1.3.x, Informatica Power Center 8.x/7.1/6.1

PROFESSIONAL EXPERIENCE

Confidential, Evansville, IN

Principal BI Developer & Admin

Responsibilities:

• Installed and configured Oracle utility Analytics (OUA) for CCB and MDM
• Configured Oracle Golden Gate(OGG) to replicate near real time data as part of the Oracle Utility Analytics .
• Configured ODI to Extract, load and Transform data in to data warehouse.
• Configured OBIEE with Out of the box RPD, Out of the box dashboards, Out of the box BI Publisher reports.
• Customized Out of the box Replication database to replicate new source database tables using Golden Gate(OGG) mechanism.
• Involved in the applications configurations and data model creations for OUA(CCB-Customer Care and Billing).
• Upgraded the entire application and components from OBIEE 11g to OBIEE 12c, re-designed the security, customizations and modified styling sheets for look and feel.
• Raised various SRs and worked with oracle on several issues we faced and was successful in resolving them.
• Resolved many user access issues as clearing cache, removing ATR files and GUID refresh.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the data with integrity constraints into Physical Layer using Connection Pool.
• Performed admin tasks as deploying and migrating RPD in various environments.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created Views and deployed them in all 3 environments for adhoc reporting.
• Created and debugged BIP reports and per the business requirements.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to already existing Reports.
• Implemented writeback for various reports for the user to directly update the data in DB.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP.
• Created catalog groups and set permissions for items in the presentation catalog and rights to users and groups.
• Developed various documents for end users as in how to create agents, deploy RPD, create reports and dashboards and other such documents.
• Conducted a learning session on how to handle OBIEE with users.
• Validated the data in reports with backend data by writing various SQL queries and fixed the inconsistencies in data.
• Participated in all the phases of project - development, testing, deployment and support.
• Configured agents to deliver content based Analytics on schedule, automated agents to obtain daily and weekly reports.
• Have extensive knowledge in debugging sawlog, query log and Scheduler log files.
• Changed instanceconfig files for implementing various look and feel and other config setting in our 12c environment.
• Created unit test cases validating the standards and data in dashboard.
• Debugged legacy PL/SQL packages, procedures, functions and views for systems & fixed the code if there is an issue.
• Have worked with ODI(ETL)
• Set up the Topology including physical architecture, logical architecture and context and reverse engineered them to designer for creating models.
• Created new models for the data sources in ODI.
• Monitored the data load process and work flow in ODI using the operator.
• Creating procedures, variables, interfaces and packages in ODI. Created packages with interfaces, procedures and variables as package steps and loaded the target tables with appropriate mappings and work flow.
• Improved the Performance of data retrieval from tables in database by creating indexes.
• Expertise on working with tools like TOAD for Oracle and SQL Developer
• Have an excellent experience in working on UNIX/LINUX platforms.
• Have an excellent hands-on working experience using TIBCO SPOTFIRE.
• Worked on creating graphs, data marking, joining data from various sources, including and changing text areas, creating calculated fields in SPOTFIRE.
• Building, publishing customized interactive reports and dashboards, report scheduling using TIBCO SPOTFIRE
• Have knowledge on TIBCO ADS(Action Data Services).
• Created reports in SPOTFIRE and made them available to users in Webplayer.

Environment: OBIEE 12C/OBIEE 11g, Oracle 12c/Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher, ODI 11g/12C, TIBCO SPOTFIRE and OUA(2.7.0.0)

Confidential, Irving, TX

Senior OBIEE Admin/Developer

Responsibilities:

• Gathered business requirements for various projects from end users and efficiently converted the requirements to technical specifications for developing the OBIEE Reports/Dashboards
• Participated in upgrading the entire application and components from OBIEE 11g to OBIEE 12c, re-designed the security, customizations and modified styling sheets for look and feel.
• Raised various SRs and worked with oracle on several issues we faced and was successful in resolving them.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the data with integrity constraints into Physical Layer using Connection Pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Performed admin tasks as deploying and migrating RPD in various environments as DEV,SIT and PROD.
• Migrated RPD and catalog from SIT environment to PROD environment for monthly releases.
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented writeback for various reports for the user to directly update the data in DB.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP.
• Created catalog groups and set permissions for items in the presentation catalog and rights to users and groups.
• Provided access to various users using Confidential ’s internal Security tool CAM.
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers.
• Created Repository and Session Variables and initialized them using Initialization Blocks.
• Developed end-user and migration Documentation briefing the features and capabilities of various reports with screenshots and supporting description on how to schedule and execute the reporting process.
• Developed reports and dashboards with various analytical views with Global and Local Filters and prompts.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards.
• Built some exclusive view like Trellis View, Pareto graphs, Slider graphs for providing an excellent and interactive dashboards to end users.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Validated the data in reports with backend data by writing various SQL queries and fixed the inconsistencies in data.
• Participated in all the phases of project - development, testing, deployment and support.
• Integrated reports and with MS Office tools using SmartView and MS Office Integrator.
• Integrated BI Publisher with OBIEE. Created Templates, Reports and Prompts in BI Publisher
• Configured agents to deliver content based Analytics on schedule, automated agents to obtain daily and weekly reports.
• Maintained RPD and created reports using NAR standards.
• Deployed the test cases and test scripts to test the reports during the Testing phase.
• Expert in creating design documents (LLD and DLD). Created unit test cases validating the standards and data in dashboard.
• Recommended & debugged legacy PL/SQL packages, procedures, functions and views for systems & converted them in to ETL.
• Played a prominent role in testing data accuracy in reports with backend data.
• Set up the Topology including physical architecture, logical architecture and context and reverse engineered them to designer for creating models.
• Created new models for the data sources in ODI. Monitored the data load process and work flow in ODI using the operator.
• Creating procedures, variables, interfaces and packages in ODI. Created packages with interfaces, procedures and variables as package steps and loaded the target tables with appropriate mappings and work flow.
• Postproduction support, enhancements and performance tuning the ETL Process.
• Debugged and developed stored procedures to load data from source tables into facts and dimension tables for some projects which did not use ODI ETL.
• Improved the Performance of data retrival from tables in database by creating indexes.
• Expertise on working with tools like TOAD for Oracle and SQL Developer
• Expert in working with MUD (Multi User Development) environment.
• Experience in data analysis, data profiling and validation
• Worked with Smart View and developed reports using BI data in Excel, Word and PowerPoint for presenting to users.
• Developed and created various graphs, views and charts using Tableau for some of the projects.
• Connected to various data sources (file, oracle and others) and created star schema in Tableau and provided reports, dashboards and various charts.
• Have an excellent experience in working on UNIX/LINUX platforms.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau desktop and server
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images.

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher, SmartView 9.3.1, ODI 10.1.X/11g, Tableau 8.1.

Confidential, Englewood, CO

OBIEE Developer

Responsibilities:

• Worked with end users to gather business requirements from clients and efficiently converted the requirements to technical specifications for developing the OBIEE Reports/Dashboards and ODI Interfaces/Scenarios
• Upgraded the entire application and components from OBIEE 10.1.3.4.2 to OBIEE 11.1.1.5.0/11.1.1.6.0/11.1.1.7.1, re-designed the security, customizations and re-configured the external applications.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Performed some admin tasks as deploying RPD in various environments as DEV,QA and PROD.
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP and External Table
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers.
• Created Repository and Session Variables and initialized those using Initialization Blocks.
• Created Security settings in OBIEE Administration Tool to set the groups and access privileges. Also implemented security for the groups at the BI Answers
• Developed end-user and migration Documentation briefing the features and capabilities of various reports with screenshots and supporting description on how to schedule and execute the reporting process.
• Developed reports and dashboards with various analytical views with Global and Local Filters and prompts.
• Customized Prompts at page level and Dashboard level, in accordance with the requirements.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Performed data validation of reports in dashboards to check if data is consistent in them and created unit test cases validating the standards and data in dashboard.
• Participated in all the phases of project - development, testing, deployment and support.
• Integrated reports and with MS Office tools using SmartView and MS Office Integrator.
• Deployed the test cases and test scripts to test the reports during the Testing phase.
• Setup connection with Oracle and flat files. Creating and debugging procedures, variables, interfaces and packages in ODI.
• Set up the Topology including physical architecture, logical architecture and context.
• Developed stored procedures to load data from source tables into facts and dimension tables for some projects which did not use ODI ETL.
• Expertise on working with tools like TOAD for Oracle and SQL Developer.
• Designed and Integrated BI Publisher reports to oracle BI Dashboards for Analysis to PDF/RTF templates

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher, SmartView 9.3.1, ODI 10.1.X/11g.

Confidential, Mc Lean, VA

OBIEE/ODI Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Created catalog groups and set permissions for items in the presentation catalog and rights to users and groups.
• Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Ad-hocreport according to the client needs.
• ConfiguredInteractive Dashboardwithdrill-downcapabilities usingglobalandlocal Filters,Metadata ObjectsandWeb Catalog Objects.
• AppliedCascading PromptsandMulti Level PromptsonDashboards.
• Created Session variables for security.
• Created presentation and Repository variables which are used in reports and dashboards.
• Identifiedissues,performancebottlenecks, and optimized the Business IntelligenceDashboardsand Reports.
• Improved the performance by caching, Aggregate Navigation and Usage Tracking.
• Deployed RPD in various environments as DEV,QA and PROD
• Developed different kinds ofreports (pivots, charts, tabular)usingglobalandlocal Filters.
• WroteCustom SQL Codesfor the reports.
• AppliedOptimization Techniquesfor the better performance of the reports.
• Involved inMonitoringandSchedulingdifferent process flows usingOracle Work Flow Manager.
• Used external tables toTransformandLoaddata fromFlat filesintotarget tables.
• Used Debugger tovalidate Mappingsby creating break points toanalyzeandmonitor Data flow.
• Involved introubleshootingtheload failure cases, includingdatabase problems.
• ImplementedSecurityby authenticating against theLDAPandexternal table.
• Trained End Users and Pilot Users aboutOBIEE Tools.
• Have Excellent hands on experience working on tools like PL-SQL Developer, Toad and SQL Developer.
• Designed and Integrated BI Publisher reports to oracle BI Dashboards for Analysis to PDF/RTF templates
• Created various unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Conducted code reviews and planned the knowledge transfer to client.
• Created Design and test documents used in reporting.
• Implemented OracleBI Appsusing ODI and OBIEE application tools.
• Customized Dashboard pages likeOverview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet inGeneral LedgerGL .

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, SQL Developer, Toad, BI Publisher, SmartView 9.3.1, ODI 10.1.X/11g.

Confidential, Atlanta, GA

OBIEE Developer

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Worked on UNIX/LINUX operating systems.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Mapping in data sources using Oracle BIEE Admin tool to create repository.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local filters.
• Created Session & Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges
• Created OBIEE Intelligent Dashboards, & Answers.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Integrated BI Publisher with OBIEE. Created Templates, Reports and Prompts in BI Publisher
• Created Interfaces, Procedures, variables and mappings to load data from source to target tables.
• Imported knowledge modules for work flow and customized them according to the requirements.
• Created packages with interfaces, procedures and variables as package steps and loaded the target tables with appropriate mappings and work flow.
• Developed Informatica Mappings, Mapplets, Tasks and Workflows using various transformations.
• Redesign Informatica ETL & DAC mappings based on new requirements.
• Configured DAC to run nightly data loads by Schedule.
• Migrated mappings and workflows from development server to Test Server to perform integration and system testing.
• Involved in developing testing documents, including Estimates, Test Strategy, Test Plan, Use Cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.

Environment: OBIEE 10.1.3.4.0/10.1.3.4.1, BI Publisher, Oracle 10g, Informatica Power Center 8.6, Toad, Windows XP, ODI, PL/SQL.

Confidential

OBIEE Developer

Responsibilities:

• Created/Modified Metadata repository suiting to data requirements using OBIEE Admin tool (.RPD).
• Created the Physical Layer, Business Model and Mapping Layer and presentation Layer using OBIEE Administration Tool (.RPD).
• Developed Answers, Filters, Customized Reports and Dashboards using OBIEE Analytics Web. Build Interactive dashboards with drill-down capabilities.
• Configured Sales & marketing Campaign management.
• Configured the Web reports for the Marketing application.
• Developed and enhance meta-data to Build Business model (SCD’s, Hierarchies, Measures, and Partitions) and establish relationships.
• Simplifies and reorganizes the Meta data into a single business model.
• Organize presentation layer in a format that is easy for end user to use as basis for reporting using OBIEE Analytics Administration tool.
• Cache management and enhancing query performance. Applied best practices to enhance the performance of the application.
• Created users, groups, access privileges and query privileges using Security settings across OBIEE.
• Developing custom dashboards and reports using OBIEE Answers.
• Created customized reports and charts in OBIEE Answers.
• Created Prompts, Filters and charts, pivot tables and views as per client requirement.
• Scheduled Reports using Delivers (Intelligent ibots).
• Developed PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Used standard packages like UTL FILE, DBMS SQL, and UTL SMTP.
• Fine-tuned poorly running SQL queries by examining execution plans
• Involved in database development by creating oracle PL/SQL functions, stored procedures, triggers, packages, cursors, records and collections.
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL.

Environment: OBIEE 10.1.3.2, Oracle 10g/9i/8i, TOAD, SQL Navigator, Erwin 3.5.2, Windows NT, SQL Developer

Confidential

OBIEE Developer

Responsibilities:

• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Created Snowflakes, Star Schemas for proposed architecture.
• Configured physical, business model and presentation layers of the Analytics Repository. Customized/Modified Metadata repository (.rpd) suiting to the organization’s data.
• Built Reports and Dashboards that leverage configured data model to meet client’s analysis business requirements.
• Configured Intelligence Dashboards by adding, included and embedded content such as links/images, HTML objects and folders.
• Created Subject Areas, Folders/Sub-folders, and Presentation/Business columns; Prepared Charts & Tables in pane; Query, Filter, Drill-downs, User / User group level Security requirements.
• Cache management and enhancing query performance. Applied best practices to enhance the performance of the application.
• Created users, groups, access privileges and query privileges using Security settings across OBIEE.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Involved in developing testing documents, including Test Plan, Test cases, Test Scenarios and Test Data according to Requirements Specifications.

Environment: OBIEE 10.1.3.2, Oracle 10g/9i, Windows NT, SQL.