SUMMARY

• Around 8 years of IT Experience, including responsibilities like gathering Business Requirements, System Analysis, Design & Data Modeling, Development, Client Interaction, Oracle Business Intelligence and Data warehousing.
• Deep understanding of Information TechnologySoftware Development Life Cycle (SDLC)methodology and project management principles.
• Expertise in OBI Applications (Marketing, Financial).
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE/Siebel Analytics Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series etc.
• Skilled with Caching & Mapping, data - level and object-level security, MUD Integration Variables/Initialization Blocks configuration.
• Highly skilled in building Interactive Dashboards with drill-down drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization.
• Very good with 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).
• Well versed in Debugging, Optimizing and Performance Tuning of OBI (Siebel Analytical) Dashboards / Reports to improve performance at Database.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Build interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables in the OBIEE Environment.
• 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.
• Good Experience in Repository Administration, Backups/recovery, Troubleshooting, setting MUDE and creation of User Groups.
• Results-oriented individual who views challenge as an opportunity. A good team player capable of working independently with excellent communication, analytical, and inter-personal skills.

TECHNICAL SKILLS:

• OBIEE 10g/11g
• OBIEE
• Siebel Analytics 7.x (Repository
• Presentation Services
• Webcat
• Scheduler iBOT’s)
• BI Publisher
• Informatica 5.1/6.x/7.x (PowerCenter and PowerMart)
• OLAP
• OLTP
• Oracle 8i/9i/10g
• SQL*Plus 8.x/9.x
• PL/SQL 8.x/9.x
• C
• C++
• Java
• Windows /NT/2000/XP
• Linux
• Unix

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr OBIEE 11g / 10g Consultant

Responsibilities:

• Involved in Analysis, Requirement gathering, Functional/Technical Specifications, Development, Deploying and Testing.
• Involved in the Installation of OBIEE 11g (BI Administration Tool, Oracle BI Enterprise Manager, and Oracle BI Administration Console) in the WINDOWS.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Involved in rpd Development, Oracle BI Administration, Oracle BI Analytics, and Scheduling IBOTS.
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Created and populated data from OLTP data into OLAP tables.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Analytics) using Repository Variables, Session Variables and Initialization Blocks.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions and involved in Configuration of Web Catalog Security and Cache Management.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Generated Level Based and Parent-Child hierarchies, where Parent child hierarchy is introduced in new OBIEE 11g version.
• Developed multiple Dimensions (Drill-Down Hierarchies) and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Periodically scheduled reports to send out to users using the BI Scheduler/iBots.
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics with different Analytic Views(Guided Navigation, pivot-table, chart, view selector, column selector, filters, and Dashboard Prompts) using Presentation Services.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Generated session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Developed iBots such as “Purge” to clear server cache using NQCmd utility and had developed Scheduled reports to be e-mailed using iBots.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.
• Performed testing in different environments during various test cycles.

Environment: OBIEE 11g/10g, Oracle11g/10g, SQL Developer, SQL Server 2008, WINDOWS XP/Server 2003.

Confidential, NY

OBIEE Consultant

Responsibilities:

• Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Worked as a member of architect team in reviewing the code developed by different teams.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Performing administrative tasks related to the development and configuration of Interactive Dashboards.
• Designed and Built OBIEE RPD 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.), test and validate the model.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges
• Customized the Oracle Business Intelligence Presentation Services interface.
• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Set up Usage tracking and Scheduler in OBIEE.
• Created Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Developed different levels of Security set-up are for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies for optimizing the performance.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Planned and supported end-user sessions on the new product, prepared and managed operations run book for continued support.

Environment: OBIEE10g/11g, Oracle 9i, Informatica 7.1, SQL server 2008

Confidential, Reston, VA

Business Intelligence Consultant

Responsibilities:

• Involved in Analysis, Requirement gathering, Functional/Technical Specifications, Development, Deploying and Testing.
• Installed and configured OBIEE/Oracle Financial Analytics 7.9.5.
• Designed Physical Layer, Business Model, Mapping Layer and Presentation Layer in the repository after connecting to the database engine.
• Installed and configured BI Publisher and integrated with OBIEE Servers.
• Identified Facts, Dimensions & Hierarchies of the Business Model.
• Implemented various kinds of reports as per the client requirements using OBIEE Answers & Dashboards.
• Developed various kinds of Reports (Pivots, Charts & Tabular) using global and local filters.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.
• Configured IBots to deliver Analytics content based on Schedule to obtain weekly reports and sent notifications Alerts.
• Implemented Cache Management techniques to improve the performance on both real time and non-real time reports.
• Implemented prompts to provide dynamic filter conditions to end users.
• Customized report look and feel using column formatting and conditional formatting.
• Tuned OBIEE Reports to improve the performance.
• Created Session & Repository variables to achieve desired functionality.
• Imported physical tables from SQL Server 2008 and defined relations between physical tables at the physical layer.
• Created complex stored procedures in SQL Server 2008 to retrieve the data required to generate reports.
• Involved in developing the testing documents like estimates, test strategy, test plan, use cases, test cases, test scenarios and test data according to requirement specifications, experience in preparing test execution reports.
• Implemented triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level.

Environment: OBIEE 10.1.3.4, BI Publisher, SQL Server 2008, TOAD, Windows XP/Server 2003

Confidential

Siebel Developer

Responsibilities:

• Evaluated business requirements against the Siebel CRM out-of-the-box capabilities and looked for opportunities to adapt the business needs to existing functionality.
• Created Detailed Designs related to Siebel Applications using Siebel Tools.
• Configured and modified the Siebel Applications as per the Detailed Design.
• Responsible member of the SiebelOperations SupportTeam with rotational and on-call duties for Tier II and III support of the Siebel application.
• Performed Unit Tests and Documents modifications made to the Siebel Applications.
• Analyzed development or support requests in to technical design and developed appropriate solution on Siebel platform.
• Responsible for knowledge transfer/cross- with other members of Siebel Application Development Staff.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL, Windows 2000, UNIX