PROFESSIONAL SUMMARY:

• Around 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 Siebel Analytics 7.x/ Oracle Business Intelligence (OBI) EE 10.x .
• Worked Extensively on 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, Guided 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.
• Working Knowledge of Oracle BI Publisher.
• 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.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Ability to work in a team environment and desire to learn new tools and technologies. Always willing to work in challenging and cross platform environments.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 10.x, Siebel Analytics 7.x (Admin, Dashboards, Publisher, Delivers, IBots).

ETL Tools: Informatica 5.1/6.x/7.x (PowerCenter & PowerMart) and SQL Server Integration Services ( SSIS)

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle 8.x/8i/9i/10g/11g, T-SQL, SQL*PLUS 8.x/9.x and PL/SQL 8.x/9.x.

Data Modeling Tools: Microsoft Visio and Erwin

Languages: C, C++, Java, HTML, XML, Perl and UML

Operating Systems: Windows 95/98/NT/2000/XP, Linux and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Sr. OBIEE Developer

Responsibilities:

• Interact with Business users for gathering the Reporting Requirements.
• Validation of all Business Intelligence Requirements.
• Involve in Data modeling Discussions.
• Converted the Business Requirements to Functional Specs and Software Design Document (SDD) and wrote the test cases.
• Responsible for the configuration of the business Intelligence environment.
• Design and Develop the OBIEE metadata Repository using OBIEE Admin tool.
• Developed reports using BI Dashboard and Answers, views & charts, Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Developed Reports/Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters).
• Implemented Security by authenticating against the LDAP. Implemented Authorization using External Table.
• Performance monitoring and tuning for reports and Dashboards.
• Design appearance and functionality of portal interface (custom style sheets and html) to improve reports, prompts, drill paths, & security.
• Assist in the development and delivery of end-user, business-oriented metadata, and the metadata tool repository.
• Responsible for writing necessary documentation to move the code to QA/Production.
• Provide support for QA, internal users and hardware.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, SQL, PL/SQL, SQL Server 2008, SQL Developer and Windows Server 2003.

Confidential, SFO, CA

Sr. OBIEE Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in gathering new and existing report Business Requirements, performed GAP Analysis.
• Identified the Data Sources (Relational, Excel etc), Facts, and Dimension tables in designing the Star Schema for the Data Mart
• Converted the Functional Specs to technical design and wrote the test cases.
• Performed the detailed design of Reports / Dashboards and Analytical Data Model (Metadata / .rpd) by performing Gap Analysis between the reports and the new requirements.
• Designed and Built 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
• Involved in RPD Modeling which includes 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 reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
• Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefits.
• Developed Reports/Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters).
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache etc.
• Implemented Security by authenticating against the LDAP. Implemented Authorization using External Table and Session variables.
• Created iBots to deliver reports to business users via email and to speed up some expensive queries by enabling the cache ceding functionality while creating the iBots.

Environment: Windows 2003, OBIEE 10.1.3.4 (Oracle BI Admin Tool, Answer, Presentation Services), Oracle 10g, SQL and PL/SQL.

Confidential, Alexandria, VA

OBIEE Consultant

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements.
• Business Analysis(Conducted Interviews to gather Business Requirements and Prepared the detail Functional Specification Document).
• IdentifiedBusiness Model, Determined Facts & Dimensions, Granularity, and Data Consistency across Dimensions.
• Converted the Functional Specs to technical design and designed the overall rpd metadata development methodology.
• Involved in RPD Modeling which includes 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
• 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.
• 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.
• Created iBots to deliver reports to business users via email and to speed up some expensive queries by enabling the cache ceding functionality while creating the iBots.
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Developed Dimensions and Time Series objects in the Business Model and Mapping Layer with Security settings in Analytics Admin Tool to setup groups, access privileges and query privileges.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
• Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.

Environment: Windows 2003, OBIEE 10.1.3.4 (Oracle BI Admin Tool, Answer, Presentation Services), Oracle 10g, SQL and PL/SQL.

Confidential

OBIEE Consultant

Responsibilities:

• Identified Facts and Dimensions (with levels & hierarchy) and developed Siebel Analytics Repository 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.
• 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.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• 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.
• 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 Siebel Analytics Repository.
• 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: OBIEE 10.1.X, Oracle 10g, Informatica 8.X, Win 2003

Siebel Analytics /InformaticaDeveloper

Responsibilities

• Business Analysis(Conducted Interviews to gather Business Requirements and Prepared the detail Functional Specification Document). IdentifiedBusiness Model, Determined Facts & Dimensions, Granularity, and Data Consistency across Dimensions. Identified Data Sources and Browsed Data Content.Prepared Design Document, Facts and Dimensions, Stars with Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts. Created Analytics Repository by importing required objects into Physical Layer using connection pool, developing multiple dimensions (drill down hierarchies), logical objects. Created Level based Measures and Aggregate navigation in BMM layerand created presentation catalogs in Presentation Layer. Built Reporting Dashboards and Pages. Created 40 Critical Reports in Answers developed and debugged manyDashboards / Reportswith differentAnalytics Views(Pivot Table, Chart, Tabular and View Selector),Alerts, Guided Navigation andDynamic Dashboardswith drill-down capabilities using dashboard and page prompts. Deployed Appropriate Security Model for different Users throughexternal table authentication with session variables and object level security for different web groups. Configured and Scheduled i-BOTs to deliver report contents to all users through different devices on various locations.
• 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.
• 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 Siebel Analytics Repository
• Viewed SQL query in Query Log and used Toad to run & debug the SQL query issued during report execution.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, re-building of indexes.

Confidential

Siebel Analytics/Informatica Consultant

Responsibilities:

• Gathered business user’s reporting requirements and prepared the requirement specifications document.
• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.
• Created detail design document and wrote the test cases. Performed gap analysis.
• Analyze, Design and Developed CP/CR Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model/layers with dimensions & time series objects, presentation layers with presentation catalogs, External table security using session variables etc.,..
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Developed many Mappings using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the CP/CR data.
• Created many Oracle Materialized Views to fasten slower queries with complex joins.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.

Environment: Siebel Analytics 7.x, Informatica 6.x, Oracle9i