SUMMARY:

• Over 9 years of experience in overall SDLC, 6 years of experience in OBIEE Oracle Business Intelligence Enterprise Edition /Siebel Analytics.
• Expertise in complete SDLC and Agile methodologies which involve Requirement Gathering, Proof of concept, Gap analysis, Converting functional to technical Spec, Design, Development, Testing and Implementation of the OBIEE/Siebel Analytics.
• Expertise in configuring and installing OBIEE 11.1.1.7.0.
• Upgraded the OBIEE 10.1.3.4 environment to 11.1.1.7.0.
• Expertise in developing all 3 layers of the Analytics Repository Physical Layer, Business Model Presentation Layer .
• Extensive experience in OBIEE RPD Development, Answers, Intelligent Dashboards, Delivers, iBots
• Implementing security using LDAP, Single sign on SSO .
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Configured failover for Clustering and implemented SSL configuration.
• Configured the NQSCONFIG.INI file for usage tracking using direct insertion.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series Functions, Cache Management.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Expertise in Debugging and Performance Tuning of OBIEE Dashboards.
• Expertise working with dimensions and fact tables and experience with understanding universal adaptors in order to load into BI.
• Involved in performance tuning at the DB level, OBIEE-RPD ,Dashboard Server Level.
• Extensively worked on reports based on EssBase cubes as data source.
• Knowledge in Data warehousing development using ETL tools such as Informatica Power Center and developed Informatica Mappings and Workflows with Worklets Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Worked with Oracle Utilities like Toad, Putty and expertise in SQL Loader, SQL, PL/SQL and Shell scripting, MS Word, Visio for documentations and diagrams, and Excel spread sheets.

Technical Skills:

Business Intelligence OBIEE 11.1.1.7.0/6.x/5.x/4.0,10.1.3,SiebelAnalytics 7.8/7.7/7.5,Qlikview 11,MS BI Suite

ETL Tools SSIS, Infomatica.

RDBMS Oracle 10g/9i/8i/7, Essbase, SQL Server, MS Access

Methodologies Star Schema, Snowflake Schema.

Languages SQL, PL/SQL, C, HTML, XML, SQL Scripts

Tools Microsoft Visio, TOAD

Operating System UNIX, SUN Solaris, Windows

Data Modeling ERWIN

Work Summary

Confidential

Sr.OBIEE Developer

Roles Responsibilities:

• Worked closely with Business Analyst team in understanding the Analytics requirements and generating reports as per the user requirements.
• Presented the overall rpd metadata development methodology.
• Provided Weekly status reports to the Senior manager.
• Involved in the data modeling sessions to create tables and views as per the requirements.
• Upgraded OBIEE 10.1.3.4 to OBIEE 11.1.1.7.0.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Developed Role-Based Dashboards for Region Managers, CFO and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management CRM to analyze the financial service center statistics for different campaigns.
• Configured advanced Navigation reports, guided navigation link, Union reports etc.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Performing Testing of the IT Defects and CR raised by the Testing team.
• Developed reports on the Essbase Cubes with drillable hierarchy.
• Used Hyperion data for building KPI reports used this data as the target data for the KPIs.
• Implemented security by creating roles web groups, checks with LDAP Authentication.
• Implemented a new security model to utilize Active directory groups in OBIEE directly.
• Migrate the rpd metadata web catalog contents to Test Production environment.
• 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 other developers to guide them with any technical difficulties.
• 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 11.1.1.7.0, OBIEE 10.1.3.4, Qlikview, Hyperion 11.1.2.1, SQL Server 2008, SQL Server 2012, Windows.

Confidential

Sr.OBIEE Developer

Roles Responsibilities:

• Worked with Client for gathering requirements, Identified KPI, Identified Analytics Report requirements
• Responsible for gathering Business Requirements, preparation of Business Requirement Specification document and performed Gap and Data Analysis.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, Interactive Dashboards and Security Implementation.
• Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Set up Obiee Tool Level security for specific users who can access a part of the tool, like just answers, No Dashboard prompts,Etc.
• Obiee reports performance improved by tuning long running sql. Created indexes, created materialized views, created Aggregate Tables, Configuring Nqsconfig.ini parameters etc.
• Worked on Obiee Administration like , installation, configuration of Obiee Security External Database, LDAP, Aggregate Table Configuration of nqsconfig file and also Instanceconfig.xml files, Setup and Configure Obiee Delivers, Creating Materialized Views, Setup Mud Environment, Repository Merge, Catalog Merge, Deployment from dev to prod.
• Setup MUDE Environment for Development of Obiee for Developers.
• Setup and Configure Bi Publisher.
• Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, and Column Selector, View Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Created Dimensional Hierarchy for Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters, ticker in user interface.
• Developed aggregated fact tables using the content tab.
• Configured Repository and session variables to get dynamic reports and dashboards.
• Added new Dimensions and Columns to the Subject Areas to full fill the additional requirements of the Business Analysts.
• Implemented security by creating roles web groups, External tables.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Creation of pivot table to analyze the business from different perspectives provided optimized Analytics request.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Environment: OBIEE 10.1.3.3, Informatica, PL SQL scripts, Oracle 10g, SQL Server 2008, TOAD, Windows XP

Confidential

OBIEE Developer

Roles Responsibilities:

• Worked with Business People for gathering requirements, Identified Analytics Report requirements.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, Interactive Dashboards and Security Implementation.
• Configured and Extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions type-1, type-2 and type-3 , Facts aggregate tables, Measures and Hierarchies.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing.
• Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Developed aggregated fact tables using the content tab and fragmentation.
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, Execution Plan.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Implemented security by creating roles web groups, External tables and LDAP.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: OBIEE 10, UNIX Shell scripts, Oracle 10g, SQL Server 2005, Informatica, UNIX, PL SQL, TOAD

Confidential

Seibel Analytics Developer

Roles Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Responsible for Data Modeling, Functional and Technical Design for the Client.
• Responsible for the Developing Siebel Analytics Repository.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Responsible for the Production and Maintenance Support Siebel Analytics.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from Siebel Analytics.
• Trained end users to build ad hoc reports using Siebel Analytics.
• Developed star schemas and created custom star schema as per the business requirements.
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers Physical, Business and Presentation .
• Enhanced existing Business Models created customized Dashboards for revenue ratio reports.
• Implemented measures dimensions and organized the data into related subject areas.
• Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain weekly reports sent notifications Alerts to Managers.
• Created hierarchy based Sales Card Dashboards for different Business units and end users.
• Customized Business Mapping Layer, created marketing segmentation criteria for Prospective customers.

Environment: Siebel Analytics 7.7.1.x, Oracle 9i, SQL PLUS, PL/SQL, TOAD, Erwin, Windows XP.

Confidential

Oracle Developer

Roles Responsibilities:

• This module is an online system covers finished goods as production receipt, transfer of goods to various Carry and Forward C F agent locations, Order Processing, Invoice Preparation, Inter depot transfer of stocks, Receipts/Payments, Stock Returns, Credit/Debit Memos, Credit Recommended Memo, out standings Adjustment, Various Supporting modules, All types of reports necessary for Field Staff, and reports required for business.

• Study and analyze the business requirements.
• Build models of the system, Confirm and refine the model with the analysts and experts.
• Design the database based on the model developed in the strategy and analysis phase.
• Build the prototype system, Write and execute the commands to create the tables and supporting
• Objects for the database.
• Development of Stored Procedures to encapsulate Business processes, triggers, procedures,
• functions and package Using PL/SQL.
• Refine the prototype. Move the application into production, user acceptance testing, conversion of
• existing data, parallel operations.
• Perform Integration and Unit testing of all the modules.
• Monitor its performance, and enhance and refine the system.
• Training internal people.

Environment: Oracle 8i, PL/SQL, SQL Plus, Windows 98.