SUMMARY

• Over 8 years of experience in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions.
• Expertise in providing end - to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using 11g, OBIEE, Siebel Analytics.
• Worked Extensively on 11g/Oracle BI/Siebel Analytics Administration Tool, Siebel Analytics Web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Strong in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching & Mapping.
• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards/Reports.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x.
• Very good experience in developing Informatica Mappings / Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router,
• Expression, Stored Procedure, Lookup, and Aggregator) for ETL of data from Multiple Sources to Data Warehouse.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel
• Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Results oriented, self starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

• OBIEE 11g 10g
• Siebel Analytics 7.x (Admin
• Webcat/Presentation Services
• Dashboards
• Publisher
• Delivers iBots)
• Informatica 5.1/6.x/7.x (PowerCenter & PowerMart)
• SSIS package
• Oracle 11g/10g/9i/8
• Oracle Applications10.7
• MS SQL Server 2000
• SQL Server 2005
• T-SQL
• Lotus Notes
• C
• C++
• HTML
• XML
• Perl
• UML
• Windows 95/98/NT/2000
• RHEL
• Oracle Solaris

PROFESSIONAL EXPERIENCE

Confidential, NY

OBIEE Consultant

Responsibilities:

• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the Insurance data.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Created Union reports as per the requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements
• Generated various Analytics Reports using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• 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 Obiee Repository.
• Worked extensively on performance tuning of reports in the application layer.

Environment: OBIEE 11g, Oracle11g, SQL Developer, WINDOWS 7/Server 2003.

Confidential, Columbia, MD

Sr. OBIEE Consultant

Responsibilities:

• 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.
• Fixed defects in Quality Center raised by user during projects QA and UAT and V&V within timelines
• Maintained the various subject areas by providing technical support as a part of the global implementation
• Involved in merging different rpd files and fixed bugs after merging.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for the better Performance.
• Created the technical design documents and functional documents.
• Used union reports, drilldown, presentation variables and prompts in the creation of answers and dashboard reports
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Worked on Dimensional Data Modeling, Relational Data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling
• Used union reports, drilldown, presentation variables and prompts in the creation of answers and dashboard reports
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• 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
• Reviewed the logical model with ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Worked with ETL Team to create source to target mappings.
• Worked with DBA to create the physical model and tables.
• Created several views in database for better performance
• 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 Logical Tables, Logical Columns with Measures Calculated as per the Business need
• Created Materialized views to improve the performance.
• Worked with Oracle in debugging the issues and opened several service requests
• Worked extensively on performance tuning of reports in the application layer
• Involved in Analysis, Functional/Technical Specifications, Development and also in testing
• Worked extensively for usage tracking and created performance matrix values.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders
• Performed Unit Testing and Functional Testing for the various reports and dashboards
• Worked on 508 standards.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interaction.

Environment: OBIEE 11g, Oracle11g, SQL Developer, SQL Server 2008, Linux, WINDOWS XP/Server 2003, DAC, Informatica 9.1, BI Publisher.

Confidential, NC

OBIEE 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 XP and also in Linux environment.
• 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.
• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• 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, Informatica 9.1/8.1, SQL Developer, SQL Server 2008, Linux, WINDOWS XP/Server 2003, DAC.

Confidential, Mt.Laurel, NJ

11g/OBIEE Consultant

Responsibilities:

• Gathering, Analyzing and identifying the Gap of Business Reports Requirements.
• Identified Facts and Dimensions (with levels & hierarchy) and developed Siebel Analytics Repository (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), create presentation folders, test and validate the model.
• Installed 11g version on 64 bit windows, upgraded 10g RPD and Webcat.
• Worked with Oracle in debugging the issues.
• Installed some patches in the 11g version based on Oracle recommendation
• 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.
• Implemented Security by creating roles, web groups, and external tables.
• 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. Executed the workflows through shell scripts using pmcmd.
• 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 Obiee Repository.
• Worked extensively on performance tuning of reports in the application layer.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Extensively worked in fine-tuning of Informatica Mappings.
• 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.

Environment: 11g, OBIEE 10.x, Informatica PowerCenter 8.1, Oracle 10g

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 training sessions on the new product, prepared and managed operations run book for continued support.

Environment: OBIEE, 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, T-SQL, TOAD, Windows XP/Server 2003, Informatica 8.6.

Confidential, Dallas, TX

Sr. Business Intelligence Consultant

Responsibilities:

• Participated in complete life cycle of the project from project initiation to development and maintenance.
• Customized the Siebel Anaytics/OBIEE repository (Physical Layer, BMM and Presentation Layer).
• Modified Presentation layer to add presentation tables and defined joins in the physical layer of the repository.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.

Environment: Siebel Analytics 7.7/OBIEE, Oracle BI Application 7.9.4, Informatica 7.1.3, DAC, Oracle 9i, Toad, PL/SQL, Windows Server 2003/XP

Confidential

Siebel Analytics Developer

Responsibilities:

• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Created Business Facts and Dimensions and defined Logical relation between them in BMM layer
• Created Drill Down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables (LTS), logical columns, and also validating repository level calculations done in the business model layer.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Created Reports using different Analytics Views (Pivot Table, Chart, Table)
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Configured out-of-the box as well as custom Analytics/Dashboard reports using Siebel Answers
• Implementing report Level Business Logic using Function editor.
• Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
• Created mappings with PL/SQL procedures and functions to implement business rules while loading data
• Performed performance tuning by optimizing Target, Source, Mapping and Session
• Improved SQL query performance using TKPROF and EXPLAIN PLAN
• Involved in migration of mappings / workflows from Development to Testing and to production

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