Professional Summary

• Around 8 years of experience in IT with primary focus on design, configuration, development and deployment of Business Intelligence applications using OBIEE.
• Experience in OBIEE 11.1.1.5/ 10.1.3.4/ 10.1.3.3, Siebel Analytics 7.7/7.8.2/ 7.8.4.
• Worked extensively in Oracle BI Web/ Presentation Services, BI Publisher, Answers and repository building.
• Experience in designing Star and Snowflake Schema, Slowly Changing Dimensions, Facts and Dimension Tables.
• Experience in developing OBIEE repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Experience in implementing security and personalization using Repository Variables, Initialization Blocks and Session Variables.
• Expertise in Dashboard/ Reports with different Analytics Views Drill-down/ Dynamics, Cascading style sheets, Pivot Table, Charts, Column Sector, Tabular with local and global filters using presentation services.
• Experience in Business Model development with various functionalities like Hierarchies, Measures, Aggregation Rules and Time Series.
• Experience in creating mock reports and dashboards for review by the business users.
• Experience in performance improvement using SQL tuning.
• Thorough Understanding of Software Development Life Cycle SDLC , involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Have an excellent understanding of OLAP, BI Architecture, Business Intelligence and Data Warehousing Concepts.
• Worked in specific areas on OBI Apps Analytics Financial Analytics, Procurement and Spend Analytics .
• Experience in installing and maintaining OBIEE.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences
• Quick learner with an ability to rapidly assimilate job requirements, come up with and employ new ideas, methods and technologies.
• Energetic and self-motivated team player with good problem solving skills and interpersonal skills.

Technical Skills

Professional Experience

Confidential

Role: OBIEE Developer

Description: The project deals about the lead contract data systems and heads can accurately forecast future business risks involved and accordingly generate customized proposals to their Leads. Analytics application helps all center heads and top Management and business leads to analyze and compare forecasts vs. revenue and helps them to plan and implement improved strategies for a profitable business.

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional models.
• Configured Metadata Repository .rpd using OBIEE Administration Tool.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Worked on developing OBIEE repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed Business Facts and Dimensions and defined logical relationship between them at the Business Model and Mapping Layer.
• Designed and developed BI Apps Metadata for Financial Analytics, Procurement and Spend Analytics.
• Configured new metrics on GL Balance Fact W GL BALANCE F and GL Other Posted Transaction Fact using Group Account Numbers in Group Account Number Dimension W GL GROUP ACCOUNT D .
• Created Dimension Hierarchies, Aggregates and Keys in the Business Model and Mapping Layer.
• Created Repository and Session Variables to achieve desired functionality.
• Created Reports and Dashboards by using Report features like Pivot tables, charts and view selector using Local and Global Filters.
• Worked with Global Prompts, Column Selectors, Automatic Drill-Down and navigation.
• Created Web groups for security purpose with access privileges and also assigned data Level and object Level security to users.
• Worked on customizing Reports' look and feel using Column Formatting and Conditional Formatting.
• Developed interactive Dashboards using OBIEE Answers.
• Experience in configuring complex reports and dashboards from multiple subject areas.
• Performed Cache management.

Environment: OBIEE 11.1.1.5.0, Informatica Power Center 9.0.1, Erwin, Oracle 11g/10g, DAC, Oracle EBS, Windows XP.

Confidential

Role: OBIEE Consultant

Description: This was a full life-cycle Data warehouse upgrade project. All the changes in the source Oracle ERP system were implemented in the Data Warehouse system and Informatica Power Center ETL jobs. Some new ETL processes were created for data extraction and transformation of source ERP data to Staging database and data migration of the Data Warehouse system. The database and table changes were also implemented in the OBIEE Dashboard and reports.

Responsibilities:

• Interacted regularly with Business Users to gather Report specifications.
• Involved in the analysis and design Data warehouse database and data model changes.
• Worked with Informatica Designer tool in customizing and developing mappings to extract and load data and involved in implementation of source Oracle EBS ERP system changes to the Data warehouse database and impacted ETL tasks.
• Worked on developing ETL processes for data extraction and data migration to Warehouse for customized new tables.
• Worked on creating reports and publishing them in Dashboards using Answers.
• Worked on customizing Repository and configuring metadata objects Subject Area Table Column and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.
• Involved in installing, configuring and administration User Creation and Cache Management of the OBIEE platform.
• Configured OBIEE security with active directory in security manager.
• Created Session Variables for users to provide Data Level security and used the variable in OBIEE answers to build the query.
• Worked on presentation variables in Answers to save prompt values and use them for Conditional Formatting.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Built Time-Series calculation using AGO and TODATE functions on Business Model and Mapping Layer.
• Worked on analysis of existing system reports, modifying the reports and creating new reports as per the Business Users' need.
• Worked on data level and object level security.
• Experience in combining reports using set operators.
• Worked with Local and Global Filters, Constrained filters, Column filter prompts and different views such as Table View, Pivot Tables, View Selector, Column Selector, Chart and Narrative views.
• Scheduled reports and delivered them to end users using Delivers.
• Install, configure, and administer the OBIEE platform for maximum utilization and throughout.
• Performed configurations for OBIEE Multi User Development MUD, Usage tracking, iBot scheduling , Security Model using LDAP authentication .
• Worked on PL/SQL procedures and packages.

Environment: OBIEE 10.1.3.4.1/10.1.3.4, Informatica 8.6.1/8.5.1, Oracle BI Financial Analytics 7.9.6, Oracle 10g, PL/SQL, TOAD, Windows XP.

Confidential

Role: OBIEE Consultant

Confidential -based, multinational, telecommunications company based in Schaumburg, Illinois. It is a manufacturer of wireless telephone handsets, and also designs and sells wireless network infrastructure equipment such as cellular transmission base stations and signal amplifiers. The project was aimed at developing dashboards and reports for Sales Analysis and Customer Follow up thus enhancing decision-making process with respect to future business, revenue and service management.

Responsibilities:

• Worked on RPD as per changes in requirement and with BI Answers for reporting and Dashboards.
• Created, copied and moved Dashboards along with Pages, Reports, and Filters using Catalog Manager.
• Experience in creating reports with different views such as Table Views, Pivot Tables, View Selectors, Column Selectors, Guided Navigations, In-Place Drills and embedding Active Links in the Report Column for Dashboards.
• Created Connection Pools, Physical Tables, defined joins and implemented authorizations in the Physical Layer of the repository.
• Worked on developing OBIEE repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Worked on Session and Repository variables.
• Worked with Security Settings in the Admin Tool to setup Users, Groups and Access privileges.
• Created Global and Local Filters and Customized Prompts as per the Business Requirements.
• Designed and Configured Interactive Dashboards for different groups of users, including, Managers, Functional Heads, Department Heads.
• Created iBots to send preprocessed reports using OBIEE Delivers.
• Worked on Performance Tuning of various OBIEE Reports/ Dashboards.
• Worked with and trained end users to create their own ad-hoc reports using OBIEE Answers.

Environment: OBIEE 10.1.3.4.0 / 10.1.3.4.1, BI Publisher, Informatica 8.6, Oracle 10g, SQL, TOAD, PL/SQL, Windows XP.

Confidential

Role: OBIEE/ Reports Developer

Confidential is a leading consumer electronics specialty retailer and growing provider of business-to-business retail support services. It has nearly 500 company-owned and dealer stores. This project dealt with building various types of reports for their sales and marketing department using OBIEE.

Responsibilities:

• Used OBIEE tool to Configure and develop the Metadata Repository RPD .
• Worked extensively with Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the Physical Layer of the repository.
• Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Initialization Blocks and variables session and repository to implement data level and object level securities in the repository level
• Troubleshoot errors in the BI Server and made backups for RPDs.
• Created Reports and Dashboards using Oracle BI Answers as per the Business Requirements.
• Created reports in different views such as Pivots, Charts and Tabular Reports with Prompts and Filters in BI Answers.
• Implemented security for dashboards and reports and shared among a lot of users.
• Created Reports and Dashboards with Drill thru, Drill up, Slice and Dice Properties.

Environment: OBIEE 10.1.3.2, BI Publisher 10.1.3.2, Oracle10g, SQL, TOAD, SQL Server 2005, Siebel CRM, Windows Xp.

Confidential

Role: Siebel Analytics Developer

Confidential is a joint venture between India's largest bank, State Bank of India and Cardiff S.A., a leading life insurance company in France. SBI Life offers a range of Insurance Products to a range of different customers specifically designed for their requirements. These products can be classified as Group Insurance Products, Individual Insurance Products and Unit Linked Products.Confidential is having 3 different source systems namely portal 4, portal 8 and indigo. The purpose of this project is to provide the detailed analysis: channel wise, product wise, time wise, underwriting, payment premium, rider wise, SBI branch wise, SBI Life wise etc.

Responsibilities:

• Performed analysis of functional and technical requirements.
• Identify Data Sources and ETL requirements.
• Worked on building ETL Data Mapping, establishing ETL process Design and building Data Mart.
• Built Business Model and established relationships and Foreign Keys Physical Logical between tables.
• Built Interactive Dashboards and Reports using Tabular and Pie Chart Reports with Drill down and drill up capabilities to enhance granularity in the Data.
• Assisted in creation of Pivot Table request allowing managers to analyze the business from different perspectives providing optimized Analytics request using Column Selector.
• Created templates for presenting results and Analytics and modified the Dashboard using cascading style sheets.
• Managed day-to-day rpd, Scheduler and iBots.
• Performed Pre and Post-implementation testing of Dashboard, Answers and validating Repository.
• Troubleshoot Caching problems in the Oracle BI Server.

Environment: Siebel Analytics 7.5, Oracle 8i, SQL server, SQL Plus and Windows operating system.

Confidential

Role: SQL Server Developer

Responsibilities:

• Involved in creating tables with different types of constraints.
• Involved in writing T-SQL queries to do the operations on the database objects.
• Using different types of SQL Server Constraints including Primary, Foreign, Unique, and Check.
• Involved in database programming in writing stored procedures, triggers and indexes very frequently.
• Installation and configuration of SQL Server 2000 components.
• Created groups, roles, users and assigning access privileges to users.
• Managing security using different server roles and database roles.