SUMMARY:

• 8+ years of experience in gathering Business Requirements, performing GAP Analysis, Design, Data Modeling, Development, Testing, Implementations, and Documentation of various functionalities of Data Warehouse / Data Marts.
• Hands on experience in configuring and developing OBIEE repository in OBIEE 11g, OBIEE 10, and Siebel Analytics versions.
• Developed Time Series Function, Dimensional Hierarchies, Variables, Initialization Blocks, Aggregation Navigation, and Event Polling tables in the RPD.
• Experience in installing 10g/11g applications on single and clustered servers.
• Hands on experience in upgrading 10 RPD and webcat to 11g
• Experience in setting up security and architecture in 11g by using weblogic admin console and enterprise manager.
• In depth knowledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases which includes Requirements Analysis, Design, Development and Testing.
• Experience in configuring interactive dashboards with drill - down and drill-through capabilities, Guided Navigation, Narrative Views, Master-Detail reports, Columns Selector, View Selector etc.,
• Expertise in Cache Management, Performance tuning at report level and database level
• Experience in enabling read/write privileges on web catalog objects (Dashboards, Tabs, Reports)
• Created and scheduled OBIEE iBOT’s to be delivered to key business users in various function areas.
• Worked on data analysis, dimension modeling that included both star and snow flake schemas.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x.
• Very strong in developing Informatica Mappings / Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookup, Router, Update Strategy) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, etc).
• Experience in working with various operating systems like IBM AIX, HP UNIX, Solaris, and WindowsNT/2000.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.

TECHNICAL SKILLS:

• OBIEE 11.1.X/10.1.3.X, Siebel Analytics 7.x (Repository, Presentation Services, Webcat, Scheduler, i-BOT’s), BI Publisher
• Informatica 5.1/6.x/7.x (PowerCenter and PowerMart),OLAP,OLTP
• Oracle 11g/10g/9i/8i, MySQL
• SQL, PL/SQL, TOAD, Import, Export, RMAN, Explain Plan
• Oracle Enterprise Manager
• Windows /NT/2000/XP, Unix, REDHAT Enterprise Linux 4.0, 5.0
• Oracle Fusion Middleware 11g, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

OBIEE Consultant

Responsibilities:

• Created the Technical Specification Document and Functional Specification Document based on business specifications.
• Installed OBIEE 11g on single and clustered servers and upgraded current 10g RPD and webcat to 11g version.
• Developed Physical, Business Mapping and Model, and Presentation layers in OBIEE 10/11g RPD.
• Performed patch upgrade related activities from OBIEE 11.1.1.4 to OBIEE 11.1.1.6.
• Created both star and snow flake schemas dimension data models in the RPD.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Created logical tables and assigned levels and custom aggregation rules.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Parent child hierarchies based on the Requirements
• Created Time series functions like To-Date (YTD, MTD and QTD), period rolling and AGO functions for comparison of data.
• Created Repository, system and non-system Session variables and initialization blocks for various repository needs.
• Authenticate users and maintained Object and Data level security.
• Implemented security by creating users and web groups, set up External Table, created session variables and initialization blocks and associated catalog objects and Web modules with the created groups.
• Implemented MUD environment for multiple developers to modify a repository simultaneously.
• Designed and developed complex interactive OBIEE reports, including prompts, filters, different report views (Pivot table, Column Selectors, View Selectors, Line/Bar Graphs, Narrative Views etc.), drill-down capabilities, and navigation links; detailed designing and developing of custom dashboards, including customized appearance.
• Responsible for migration and deployment of 11g RPD and webcat using EM console.
• Implemented cache management and enhancing query performance.
• Configured IBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Configured and enabled usage tracking for all dashboards and pages.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.

Environment: OBIEE 11g, Oracle11g, Informatica 9.0.1, BI publisher, Toad, WINDOWS XP/Server 2003, DAC.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Worked closely with Business users in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Configured OBIEE 10g/11g RPD that involves Physical, BMM, and Presentation layer.
• Responsible for installing OBIEE 11g and also upgrading the 10g RPD and webcat to 11g version.
• Involved in testing the RPD and validating reports and dashboards in 11g application.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Created opaque views and aliases in the physical layer of OBIEE per reporting requirements.
• Enable data level security on various dimensions like Sales Geography, Product, and Customer Geography etc.
• Created Proactive Agents /iBots using Delivers & delivered using Scheduler services.
• Migrated Repository & Web Catalog from Development to Test & Production server using Oracle Enterprise Manager/Catalog Manager.
• Created, modified and formatted reports/dashboards, using different views i.e. pivot table, charts, and filters in analysis. Built new reports as per business needs.
• Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Created Application Roles using Oracle Enterprise Manager & assigned different permissions on dashboards and reports.
• Worked on Cache Management to improve performance.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards.
• Documented Technical Design document and User /help documents.
• Guiding / customer’s IT Team during course of the project so that it feels confident about supporting this product post deployment

Environment: OBIEE 11g/ 10.1.3.4, Informatica 8.6, BI Publisher, Oracle 10g, SQL server 2008, SQL Developer, WINDOWS XP/Server 2003, Linux,.

Confidential

OBIEE Developer

Responsibilities:

• Gathering, Analyzing and identifying the Gap in Business Reports Requirements.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Implemented security by creating roles, web groups, and LDAP Authentication.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed the Initial and Incremental / Delta ETL process i.e., Mappings & Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Used different application development tools like TOAD (Oracle)
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.

Environment: Windows XP,OBIEE 10.1.3.4, Informatica 7.1, oracle 10g, SQL, PL/SQL, TOAD.

Confidential

Responsibilities:

• Configured the Metadata for the VPI score card at all three layers Physical, Business Model and Presentation layer.
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Development of Supply Chain Management Reports like Supplier Tracking Performance, Cycle Count, Kanban Cards, Account Receivables and Payables for different vendors and customers of the Client using views like Pivot Table, Chart, Bar Graph, Navigation and Drill-down Reports.
• Migration of Business Objects Reports to OBIEE.
• Configure the RPD to point the Oracle Apps Data Base and model the Physical, BMM and Presentation Layer
• Configuration of the Out Of Box Security Model to adapt to the LDAP authentication and also object level Authorization at the RPD and also the Presentation Server too.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports
• Migration and Deployment of the RPD and Webcat (using Catalog Manager) to all the environments.
• Train the Business Users to generate the Answers at various views.
• Involved with Oracle Apex team to capture the information going into the VPI Scorecard to model the DB.
• Communicated with the data team for data model reviews and worked with them to suffice the reporting requirements as per OBIEE Architecture
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations (Expression, Look-Up, Router, Update Strategy, Stored Procedure etc.,) and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Developed Informatica mappings with re-usable transformations and mapplets using various transformations
• Involved in User Acceptance Testing (UAT) for all the reports and validation of the reports.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing materialized views, partitions, re-building of indexes, overwriting the SQL execution path by using hints etc.,

Environment: OBIEE 10.1.3.4.0, Oracle 10g, TOAD, Informatica 8.1.1,Sun Solaris 64.

Confidential

Sr.OBIEE Consultant

Responsibilities:

• Talk to the business users and understanding the Environment
• Analyzing the Out of Box reports and made few customizations for the reports and dashboards.
• Segregated all the Customization reports into three groups Complex, Medium and simple, by analyzing the SQL scripts generated by the Discoverer reports.
• Developed the RPD for supporting the customized reports in the OBIEE.
• Configured the Physical layer for making sure that we have Multiple aliases created as per the requirement as the Environment is Transactional and the way are related in the Physical Database.
• Dimensional modeling for the Normalized tables in the BMM layer in order to generate the Star Schema.
• Created Opaque Views for few tables as per the requirements.
• Configuration of Presentation Layer as per the User requirement.
• Responsible for creation of pivot table requests and bar/column charts allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector/view selector, multi-select page prompts
• Implemented Security for various users and groups using External Table Authentication
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment
• Extensively involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL
• Developed / modified mappings per gaps identified
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment
• Developed reports in various views. Used complex grouping of filters in order to achieve results based on Discoverer reports.
• Installed and configured Disconnected Analytics.
• Created Dashboards, Sub dashboard for the Users.

Environment: OBIEE 10.1.3.3.3, Oracle 10g, Oracle Discoverer, Oracle Financial Analytics, Sun Solaris 64.

Confidential

Sr. OBIEE/Siebel Analytics Consultant

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Analyzed the data flow from Source systems (OLTP) to Staging to Data Warehouse (OLAP)
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with LDAP Authentication
• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository

Environment: OBIEE, Siebel Analytics 7.x, Informatica PowerCenter 6.x/7.x, Oracle 9i/10g, DB2, HP UNIX

Confidential

Siebel Analytics Consultant

Responsibilities:

• Gathered user requirements from business representatives and convert them into functional and technical specifications
• Designed and developed Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints using connection pool into Physical Layer, developed multiple Dimensions (Drill-Down Hierarchies) & Logical Facts / Measures in Business Model Layer, and created the Presentation catalogs in Presentation Layer
• Implemented Security by creating roles & web groups, checks with External table
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Involved in complex ETL Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)
• Designed and documented the business/validation rules, error handling and test strategy of the mapping
• Tuned the sessions for better performance by implementing the partitions

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x, Oracle 9i