Summary:

• 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Extensive Data warehouse development experience using OBIEE/ Siebel Analytics, BI APPS, Informatica , Oracle Data Integrator ODI , BI Publisher, Oracle 10g/11g, SQL/PLSQL
• Hands on experience in the Data Modeling, Meta Data Development, BIAPPS Implementations and Testing of OBIEE/BIAPPS Functionalities
• Experience in Creating Dimensional modeling of STAR, SNOWFLAKE schemas in OLAP and customizing Fact and Dimension tables as per the user requirements.
• Good understanding of all phases of Software Development Life Cycle SDLC including Business Requirement Analysis, Development and Testing
• Expert in working with OBIEE administration tool in developing RPD with Working on Advanced concepts like aggregated tables, fragmentation, time series functions security privileges.
• Experience in writing and modifying Design documentation, technical requirements analysis, test results documentation and standard operating procedures SOP documentation.
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Pivot table, Chart, Column Sector, Tabular with local and global filters using Analytics.
• Experienced in deploying Informatica workflows to the DAC configure, monitor and schedule ETL routines and created dependent Hierarchical tasks.
• Created and scheduled OBIEE IBOT's to be delivered to key business users in various function areas.
• Expertise in Cache Management, Performance tuning at report level and database level.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
• Responsible for conducting interviews with stakeholders to gather requirements, perform data analysis to to design ODI interfaces from multiple source systems.
• Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting.
• Good Programming Skills using Shell Scripts and Pl/SQL Coding Procedures, Functions, Database Packages and Triggers for Automation of ETL Process.
• Optimized solutions using various performance tuning methods SQL tuning, ETL tuning i.e. optimal configuration of transformations and memory parameters , Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.
• Actively involved in business-related project milestones such as in Requirements Gathering, Data modeling logical and physical design of databases , Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.

Technical Skills:

Professional Experience:

Confidential

OBIEE/OBIA Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Responsible for setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created Reports, prompts and Filters using OBIEE 11g.
• Created dashboard pages and sections.
• Created Reports with graphical representation such as Bar charts, pie charts.
• Created bookmark Link, Prompted Links and Saved Customizations.
• Formatted the Reports as per the Client requirement.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Created saved several BI Publisher reports by selecting an Analysis request as Data Source.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Created proactive agents IBOT'S and interactive Dashboards to alert the business teams about business changes.
• Customized the repository with new custom functionally and developed new Reports / Dashboards with different Analytics Views.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc.
• 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

Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.3,Oracle EBS R12.1.1,Oracle 11g,Oracle data integrator 11.1.1.6, DAC,TOAD, Oracle BI Publisher.

Confidential

OBIEE/OBIA Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Responsible for setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration.
• Developed the Oracle BIEE Metadata repository model with for SSOP subject areas that involved creating the Physical layer, BMM layers, and Presentation layer with aggregates, dimensions, hierarchies time series functions using Oracle BI Administration tool.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created Reports, prompts and Filters using OBIEE 11g.
• Created dashboard pages and sections.
• Created Reports with graphical representation such as Bar charts, pie charts.
• Created bookmark Link, Prompted Links and Saved Customizations.
• Formatted the Reports as per the Client requirement.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Created saved several BI Publisher reports by selecting an Analysis request as Data Source.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Created proactive agents IBOT'S and interactive Dashboards to alert the business teams about business changes.
• Customized the repository with new custom functionally and developed new Reports / Dashboards with different Analytics Views.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc.
• 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

Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.3,Oracle EBS R12.1.1,Oracle 11g, Informatica 8.6.1, DAC,TOAD, Oracle BI Publisher

Confidential

OBIEE/OBIA Developer

Responsibilities:

• Responsible for conducting interviews with stakeholders to gather requirements, perform data analysis to to design ODI interfaces from multiple source systems.
• Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
• Involved in overall SDLC lifecycle of the project in all stages right from the Analysis, requirement gathering, IVSC SDM design, development reporting requirements.
• Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting
• Worked very closely with Architects to drive the Logical physical models for the project looking into different subject areas and inter relations between each entity which derived in creating different set of tables for SRC , XREF , STG TGT tables for the respective Dimension Fact tables in the SDM.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Implemented aggregated tables, Fragmentation Partitions , Time Series functions Security privileges for better performance and security measures.
• Designed dimensional hierarchies, materialized views and aggregate tables to support the reporting system.
• Configured the LDAP to OBIEE for Authentication and Audit for Fusion Middleware.
• Implemented data and object level security based on the business requirements through External table.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Developed reports, dashboards, standard filters and prompts.
• Created Reports, prompts and Filters using OBIEE 10g, OBIEE 11g.
• Created dashboard pages and sections.
• Created Reports with graphical representation such as Bar charts, pie charts.
• Created bookmark Link, Prompted Links and Saved Customizations.
• Formatted the Reports as per the Client requirement.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges.
• Created and scheduled IBOT's for delivering personalized reports to users.
• Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
• Tested UI testing, Functional testing, Data Validation testing and Performance testing.
• Implemented and developed the migration plan for moving the repository and web catalog from DEV to UAT and PROD.

Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.3,Oracle EBS R12.1.1,Oracle 11g,

Oracle data integrator 11.1.1.6, DAC,TOAD, Oracle BI Publisher.

Confidential

OBIEE/OBIA Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Responsible for setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration.
• Developed the Oracle BIEE Metadata repository .rpd model with for Sales Marketing, Procurement Spend subject areas that involved creating the Physical layer, BMM layers, and Presentation layer with aggregates, dimensions, hierarchies time series functions using Oracle BI Administration tool between the quarters
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created Reports, prompts and Filters using OBIEE 10g, OBIEE 11g.
• Created dashboard pages and sections.
• Created Reports with graphical representation such as Bar charts, pie charts.
• Created bookmark Link, Prompted Links and Saved Customizations.
• Formatted the Reports as per the Client requirement.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Created saved several BI Publisher reports by selecting an Analysis request as Data Source.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Created proactive agents iBots and interactive Dashboards to alert the business teams about business changes.
• Customized the repository with new custom functionally and developed new Reports / Dashboards with different Analytics Views.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc.
• 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

Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.3,Oracle EBS R12.1.1,Oracle 11g, Informatica 8.6.1, DAC,TOAD, Oracle BI Publisher

Confidential

OBIEE Developer

Responsibilities:

• Worked with Business Users, Involved in Discussing and Gathering the Analytics requirements from different user groups.
• Requirement analysis, Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform.
• Installed and configured the OBIEE 10.1.3.2 on servers and dealt with the installation issues.
• Designed and Developed OBI Repository at three layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins , Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales using inbuilt functions and expressions.
• Identified Facts, Dimensions Hierarchies of the Business Model.
• Developed Time Series object for comparing between the annual and quarter sales.
• Implemented the variables in the repository to import them in the presentation layer.
• Actively resolved all the issues in the development process to satisfy the client's best requirements.
• Implemented Security by creating roles web groups, checks with External tables.
• Set-up Security using SSO Authentication.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Used DAC Data Warehouse Administration Console Client to manage, configure, customize, and monitor ETL process.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.

Environment: OBIEE 10.1.3.2, Informatica Power Center 8.1.1, Flat files, Oracle 10g/9i, MS SQL Server 2008, DB2, PL/SQL, UNIX Shell Scripting, Toad, Windows NT.

Confidential

OBIEE Consultant

Responsibilities

• Involved with management professionals, analysts as well as other business teams on requirement gathering.
• Customized and developed the OBIEE Physical Layer, Business Model and Mapping layer.
• Implemented complex requirements like dimension hierarchies, time comparisons, share measures along with rank measures and change data capture, slowly changing dimension design.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer. Implemented caching and aggregate table techniques to improve the performance.
• Created, modified and formatted requests, along with charts and filters in OBIEE Answers.
• Created, modified, and administered analytics intelligence dashboards with links to web sites HTML text links to documents and embedded content such as images, text, charts, and tables.
• Worked with Informatica Designer tool in customizing and developing mappings in SRMW to extract and load data.
• Worked with Transformation developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Environment: OBIEE 10.1.3.x, Siebel Business analytics 7.8.9, Oracle 10g, Informatica Power Center 7.1.

Confidential

INFORMATICA/OBIEE Developer

Responsibilities:

• Involved in the design phase of logical and physical data model using Erwin.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of PL/SQL scripts for Database table DDL's, User Privileges, Index and views
• Utilizing the existing UNIX shell scripts to run the Informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participated in on-call support for ODS and the data warehouse.
• Worked along with the QA team in order to determine the data validation and preformed the data validating at the source and the target database level.

Environment: Informatica Power Center 7.1, Oracle 9i, Windows 2000, flat files, Erwin,

OBIEE 10.1.3.3.3