We provide IT Staff Augmentation Services!

Obiee Architect/lead Resume

0/5 (Submit Your Rating)

Westlake Village, CA

SUMMARY

  • Confidential is a certified implementation specialist in Oracle Business Intelligence Foundation Suite 11g.Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating high performance technical solutions to meet challenging business needs.
  • Confidential TEMPhas over Nine years of professional experience in the IT industry and a passionate Oracle Business Intelligence technical blogger, Oracle Technical Network contributor.
  • Oracle certified Implementation Specialist - OBIEE 11g
  • Worked extensively on OBIA (Oracle Business Intelligence Applications) Supply Chain& Order management Analytics, HR Analytics, Finance, Retail and Case Management Analytics.
  • Hands on experience on working with Oracle E Business Suit R12 (EBS R12), Siebel CRM, JD Edwards, PeopleSoft as source systems and implementing various OBIA offerings.
  • Hands on experience in installation of OBIEE (10/11G) and BI publisher (10g/11g).
  • Experience working with new features Key performance indicators (KPI) like KPI watch lists, KPI Scorecards in OBIEE 11g.
  • Working with Exalytics Oracle In-memory environment.
  • Design & Customize OBIEE Answers Views & charts Create & save Filters Create Charts & Tables Bins in OBIEE Answers.
  • Expertise in installation and configuration of OBIA out of the box applications and customizing it to customer needs.
  • OBIEE Mobile Apps design and development (iPhone and iPad)
  • OBIEE Integration with Google Maps and expertise in working with Spatial Data and Map Viewer, Map Builder
  • Skilled with Caching & Mapping, data- level and object-level security, MUD, Integration Variables/Initialization Blocks configuration in the RPD.
  • Skilled expertise in creating reporting using BI Publisher from OLTP and OLAP.
  • Highly skilled in building Interactive Dashboards and Adhoc reports with drill-down & drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization
  • Expertise and hands on experience in development using OBIEE, Informatica, DAC.
  • Hands on experience in working in ODI (Oracle Data Integrator) installing, configuring out of the box OBIA mappings.
  • Worked on scheduling Informatica ETL mappings using DAC.
  • Performed Informatica and DAC migration for DEV-TEST-PROD environments.
  • 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, Aggregate persistence wizard.
  • OBIEE integration with Hyperion Essbase OLAP Cubes as source and designing and Federating the RPD using relational and Essbase sources.
  • Extensive experience indesigning and developing OLAP cubes using Essbase studio client.
  • Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
  • Skilled in the Active and passive ETL transformations using the Informatica Power Center.
  • Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
  • Worked on Microsoft office tool which is present in OBIEE.
  • Experience in optimizing ETL mappings and designs to reduce the total data load time and optimize the performance.
  • Managed day-to-day RPD, Scheduler &iBots, and Performed Pre and post implementation testing of Dashboard (Unit, System, User Acceptance Testing, post deployment smoke testing), Answers and validating Repository. test scripts for Unit, System, and User Acceptance Testing
  • Installation and configuration of OBI Apps (HR Analytics, Case management Analytics) out of the box mappings for Informatica (Various application packages)
  • Worked extensively on OBIEE Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer.
  • Extensive experience in OBIEE security models implementation and OBIEE Environment administration (MUD creation, configuration and Support).
  • Expertise in modeling the Essbase Cubes in the repository and designing the reports.
  • Knowledge of implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
  • Expertise in integrating BI publisher reports with Siebel application
  • Good analytical & problem solving skills.

TECHNICAL SKILLS

Business Intelligence: OBIEE 10G, OBIEE 11g, OBIEE 12C OBIEE Administration, WebLogic Administration, Oracle Fusion, BI Publisher, ODI, Map Viewer, Map Builder, EBS R11, EBS R12, OBIA 11.1.1.9.2 , OBIA 7.9.6.4, Oracle Exalytics.

DAC: DAC 7.9.4 / 7.9.6 / 7.9.6.1 / 7.9.6.2 / 10.1.3.4.1

Database: Oracle 11g, 10g, 9i, Hyperion, SQL Server 2008, SQL Server 2008 R2

EPM: EPM System 11.1.2.3, Essbase Studio11.1.2.3, Smart View, Essbase Administration Services 11.1.2.3, Oracle Essbase Integration Services

CRM Verticals: Siebel eSales, Siebel e-Pharma, Manufacturing, Judiciary, Healthcare, Banking, Retail.

Operating System: Windows, UNIX, Red Hat Linux, AIX, Sun Solaris OS, MS-DOS

OBIA: Supply Chain and Order Management Analytics, Case Management analytics, Human Resource Analytics, Procurement and Spend Analytics, Finance Analytics, Retail Analytics.

Internet Technologies: XML, HTML, Perl, CGI, UML, Junit, Python.

Version Control Tools: Clear case, SharePoint, Visual Source Safe, Quality Control (QC), JIRA.

Middleware: WebLogic

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Architect/Lead

Responsibilities:

  • Infrastructure setup (DEV, UAT, PROD) - Installation and configuration.
  • Perform the design and architecture of the OBIEE visual factory environment.
  • Dimensional modeling design and development.
  • RPD development and testing. Developed reports using BI Dashboard and Answers, views & charts
  • Performed Unit testing and load testing for both the RPD and web catalog.
  • Experience in setting up web catalog and administration.
  • OBIEE KPI Scorecard Automation.
  • Font end customization using JavaScript and j query.
  • Designed and customized OBIEE reports to meet the Confidential requirements and standards.
  • Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Setup DATA and OBJECT level security using custom application roles and groups.
  • Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
  • Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
  • Implemented OBIEE write back functionality extensively to allow user interactive operations to modify and update data.
  • Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
  • Implemented Scorecards and KPI for the sales and commission data.
  • Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.

Environment: OBIEE 11.1.1.7.1 , MS SQL SERVER 2010, MS SSIS, JD Edwards.

Confidential

Senior OBIEE/OBIA Architect

Responsibilities:

  • Perform system analysis of the existing environment and define the upgrade strategy and project plan.
  • Setup new environment for the OBIA 11.1.1.9.2 .
  • Install the new ODI instance and perform the functional configuration of the OBIA offerings.
  • Perform the source domain analysis and work with the matrix owners to finalize domain mappings.
  • Gather the ODI Data load parameters for Finance, Procurement and HR Analytics offerings.
  • Manage the reporting parameter and configure the same in the BIACM.
  • Define the business intelligence application instance.
  • Create implementation project and assign it to the users.
  • Manage the business intelligence application instance configuration from BIACM.
  • Setup preferred currencies and Warehouse languages.
  • Manage domain mappings and hierarchies including the configuration of source and target domains.
  • Configure slowly changing dimensions.
  • Customize out of the box ODI mappings and debug the issues related to daily and full loads.
  • Configure sub ledger modules to be Extracted for GL linkage Information.
  • Setup Group Account numbers. Implement GL Segment, GL Account, Asset Category and Asset Location Dimensions.
  • Manage domain and member mapping for various dimensions
  • Configure the various band (Age, performance, job)
  • Create the domain load plan (Domain only Extract and Load - SDE, SIL) and perform the domain mapping for each offering from the BIACM.
  • Create the load plan (Source Extract and Load- SDE, SIL and PLP)
  • Perform the load for various offerings.
  • Configure the OBIEE RPD for various OBIEE Offerings and validate the repository. Enable the subject area and preform consistency checks.
  • Validate the OBIEE security.
  • Perform OBIEE Dashboard customization according to the customer requirements.
  • Monitor the OBIEE query performance of various dashboards and manage the OBIEE caching strategy.

Confidential

OBIEE/DW Lead

Responsibilities:

  • Architecture, Design and Develop Active Data Warehouse Business Intelligence repository and dashboard reports.
  • Setup data and object level security using custom application roles and groups.
  • Business Intelligence Server Administration and maintenance DEV, TEST and PROD environment.
  • Create deployment plans and manages migrations to higher environments.
  • Developed Ad hoc reports, BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
  • Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Integration with Google Maps using Spatial Data.
  • Experience in setting up web catalog and administration
  • Design and develop repository business model using Hyperion Essbase Cubes and Relational Data sources.
  • Designed star schema using Vertical Federation to combine both Essbase and DW data sources together.
  • Developed Rules file and perform Monthly loading of metadata and Essbase OLAP data.
  • OBIEE Administration - Physical, Business Model & Mapping, and Presentation Layers, Answers, Dashboards, Catalog Management.
  • WebLogic administration and maintenance.
  • Setup DATA and OBJECT level security using custom application roles and groups.
  • Design and develop OBIEE Hierarchies using active data warehouse attributes.
  • Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
  • Worked with ODI (Oracle Data Integrator) ELT tool to create Active Data warehouse OLAP for LCEC.
  • Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
  • Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
  • Debugging the master jobs and packages by using operator navigator.
  • Perform Pre and post implementation testing of Dashboard, Answers and validating Repository.
  • Performance tuning of Business Intelligence reports and Query optimization.
  • Performed Unit testing and load testing for both the RPD and web catalog.
  • End user training, support and documentation.

Environment: OBIEE 11.1.1.7.0 , Oracle 11g R2, Oracle Data Integrator ODI, OBIA 11.1.1.9.2 , Hyperion Essbase, Smart View.

Confidential

OBIEE/OBIA Lead

Responsibilities:

  • Dimensional modeling design and development.
  • RPD development and testing.
  • Oracle IDM SSO integration with Siebel CRM.
  • Custom autantication based on GROUPS stored in external tables (Siebel), using custom SQL adapters.
  • Setup DATA and OBJECT level security using custom application roles and groups.
  • Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
  • Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Performed Unit testing and load testing for both the RPD and web catalog.
  • Experience in installation and configuration of OBI Application Case management analytics 7.9.6.4.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Created Hyperion Essbase cubes with various dimensions for performance improvement using Essbase studio.
  • Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
  • Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
  • Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
  • Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
  • Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.
  • Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
  • Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.

Environment: OBIEE 11.1.1.7.2/ OBIA, Oracle 11g R2, Informatica 9.2, BI Publisher

Confidential, Westlake Village, CA

OBIEE Technical Lead/DW Administrator

Responsibilities:

  • Upgrade OBIEE environment to 11g and setup DEV, UAT, PROD
  • Gatheird requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
  • Managed day-to-day RPD, Scheduler &iBots and resolved Ad hoc report requests and performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
  • Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables in RPD for the new dimension and Fact tables.
  • Developed Oracle BI Publisher Report (Template Building, Creating Data sets, XML generation from IO Created, Sub Templates, Parameterization, Scheduling, Translations, and Graphical Reports etc.) for the customer statement reports.
  • Implemented Scorecards and KPI for the sales and commission data.
  • Expertise in integrating BI publisher reports with Siebel application
  • Manage and monitor DAC tasks and ETL.
  • Customizing out of the box Supply Chain and HR Analytics applications.
  • Administration and maintenance of the DAC client.
  • Design and develop monthly customer statement (PDF) reports using BI Publisher.
  • Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
  • Worked on Configuring MUDE (Multi User Development Environment) OBIEE scheduler, Usage Tracking, Security integration between RPD and BI Publisher, Repository Sever and Presentation Server configuration changes and cache.
  • Experienced in Data Modeling, identification of Facts and Dimensions, Creation of schemas (Star), Hierarchies, Documentation of Report and Dashboard Layouts, End User Demo/Documentation for Business/Report Users.
  • Created Users, Groups by establishing a Connection to the existing LDAP Server by creating Initialization Blocks and variables for establishing Client Data Level Security and object level security.
  • Worked with ESSBASE OLAP Cube data to include in the RPD. Federating OLAP Cube data with DW and combine the data sources in the repository.
  • Implemented different Caching techniques to improve the performance of BI server.
  • Create and manage custom application roles and privileges.
  • Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI
  • Implemented OBIEE Maps using spatial data to represent the sales trend nationally.
  • Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
  • Used Informatica Power center for Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
  • Designing and implementing SCD - slowly changing dimensions’ types (1, 2 and 3) and CDC - Change Data Capture.
  • Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
  • Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
  • Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so dat the required information is visualized by end users.

Environment: OBIEE 11.1.1.7.2/ OBIA, Retail, HR, Oracle 11g R2, Informatica, BI Publisher

Confidential, Memphis, TN

Senior OBIEE/OBIA Developer

Responsibilities:

  • Infrastructure setup (DEV, UAT, PROD) - Installation and configuration.
  • Dimensional modeling design and development.
  • RPD development and testing. Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
  • Implemented Supply Chain & Order management Analytics using OBIA for Oracle EBS as source.
  • Customized Informatica mappings to meet the client requirements and base table extensions
  • Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures
  • Performed Unit testing and load testing for both the RPD and web catalog.
  • Experience in setting up web catalog and administration.
  • Designed and customized OBIEE reports to meet the Confidential requirements and standards.
  • Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
  • Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
  • Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
  • Implemented OBIEE write back functionality extensively to allow user interactive operations to modify and update data.
  • Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
  • Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
  • Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.

Environment: OBIEE 11.1.1.6.7 , Oracle 11g R2, EBS R12, Informatica 9.2.1, TOAD, OBIA 7.9.6.3 Supply chain Analytics, Order management Analytics, HR analytics and Retail.

Confidential, Los Angeles, CA

Senior OBIEE/OBIA consultant

Responsibilities:

  • Requirements gathering, interacting with business users and documentations.
  • Infrastructure setup (DEV, UAT, PROD) - Installation and configuration.
  • Dimensional modeling design and development.
  • RPD development and testing.
  • Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
  • Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Performed Unit testing and load testing for both the RPD and web catalog.
  • Experience in setting up web catalog and administration.
  • Design and development of monthly and Quarterly reports for Federal government.
  • Designed and customized OBIEE reports to meet the FED requirements and standards.
  • Customized OBIEE report outputs to Federal specifications and formats.
  • Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
  • Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
  • Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
  • Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
  • Implemented OBIEE write back functionality extensively to allow user interactive operations to modify and update data.
  • Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
  • Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
  • Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.

Environment: OBIEE 11.1.1.6.7 , Oracle 11g R2, Informatica 9.2.1, TOAD

Confidential, Rochester, NY

OBIEE/Informatica Developer

Responsibilities:

  • Leverage Sales and Service Analytics of BI Applications 7.9.6.1.
  • Performed installation of Oracle Business Intelligence Enterprise Edition (OBIEE 11.1.1.6.1 ) in Windows (32 and 64 bit) and Linux Operating systems in Prod, Dev, Performance and QA environments.
  • Developed Dashboards and reports for Organizational and executive users, using graphs charts and table views.
  • Collaborated with the business representatives and existing model’s development team in understanding the complexities of de-normalizing the current OLTP models into OLAP model.
  • Worked with out-of-the-box Oracle BI Applications 7.9.6.1 for evaluating the amount of customization dat will be required with respect to the sales and service analytics.
  • Analyzed the out of the box ETL mappings (SIL’s and SDE’s) and their dependencies.
  • Identified the key fields dat need to be additionally added for the current staging environments.
  • Managed the MUD (multiuser development environment) for the project
  • Customized the out of the box DAC containers - Siebel 8.0 verticals and scheduled the full and incremental loads as per the staging and target requirements.
  • Integrated OBIEE in Siebel Application and configured SSO.
  • Implemented the Change Data Capture mechanism in DAC to capture the changes using auxiliary tables.
  • Customize Informatica mappings to include new dimensions and fact tables.
  • Configure DAC Tasks as per Informatica mappings.
  • Implemented Data Level Security leveraging the BI Apps Security Model.
  • Customize OBIEE RPD to model the new changes and create reports accordingly.
  • Create new Star Schemas and new Subject Areas to build data models based on Confidential Data Model.
  • Perform GAP Analysis to implement the customization.
  • Managed the onshore and offshore deliverables and maintained a highly organized and streamlined environment.

Environment: OBIEE 11.1.1.6.1 , AIX 5.3, Oracle 11g, Informatica 8.6.1, BI Apps 7.9.6.1, SQL, PL/SQL, TOAD.

Confidential

OBIEE/BI Apps Developer

Responsibilities:

  • Design and customization of DW Schema
  • Created and modified Execution Plans and tasks using DAC to manage ETL jobs for data population
  • Development and customization of ETL Mappings
  • Implementation of object level and position based data level security
  • Development and customization of OBIEE RPD
  • Customized Star Schema in BI Repository to improve performance.
  • Gatheird user feedback to support enhancements during iterative development phase
  • Implementing OBIEE metadata (RPD) design and development
  • Designed the 3 Layers - Physical Layer, Business Mapping Modeling and Presentation Layer adhering to the Oracle Design/Build review standards and best practices
  • Development of Dashboards and Reports
  • Modification of reports based on end user feedback
  • Generated test data for unit and system testing of ETL and OBI code

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6.1, DAC 10.1.3.4.1 , SQL, PL/SQL, TOAD.

Confidential, Easton, Pennsylvania

OBIEE Developer

Responsibilities:

  • Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
  • Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Developed Business models to represent business logic for Service and created logical tables and defined the complex joins for a business model.
  • Involved in Understanding the user requirement and developing the Technical documentation.
  • Extensively involved in review of the Design documents with the peers (at different levels)
  • Involved in resolving the UI layer formatting issues at OBIEE Answers level.
  • Created dashboards, pages, reports with various views me.e. table, pivot, charts, narrator, column selector etc. and various report prompts
  • Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
  • Responsible for the administration and migration of user reports or repositories between various environments
  • Extensively worked with Administration team to resolve the issues happened while migration to different environments.
  • Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
  • Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
  • Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
  • Involved in modifying the calculations at Answers level based on the requirement changes.
  • Involved in unit testing the reports.
  • Extensively worked on the defect fixing, Technical document changes and migration process.
  • Updating the status sheets on regular basis to know the status of the objects.
  • Involved in MOM preparation
  • Worked as an onsite & offshore coordinator
  • Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, Informatica, Toad, Siebel CRM, DAC ( 10.1.3.4.1 .)

We'd love your feedback!