TECHNICAL SUMMARY

• Has over 8 years experience in gathering Business Requirements, performing GAP Analysis / Data modeling Development, implementation, supporting the application, tuning and database administration.
• Nearly 5+ years of extensive experience as a OBIEE/Siebel Analytics developer
• Expertise in Implementation of OBIEE architecture, Data warehouses and DataMarts with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology
• Thorough understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL.
• Very strong in OBIEE/Siebel Analytics Admin Tool, Analytic Web and Scheduler.
• Expertise in developing OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• 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 (Presentation Services, Dashboard, Pages, Folders, Reports).
• Expertise in debugging and optimizing the OBIEE Dashboards / Reports and Informatica Mappings / Workflows.
• Proficient in SQL/PL/SQL, Procedures/Functions, Packages, Triggers and Materialized Views.
• Extensive experience in design and development of Data warehouses and Data Marts using Informatica Power Center / Power Mart 8.x/7.x 6.x and associated tool to map, transform and extract data feeds from various source platforms and databases.
• Very strong in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (using pmcmd)
• Expertise in database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing,
• Expertise in Performance Tuning of Mappings & Workflows/Sessions.
• Proficient in working on production and developmentenvironment in different RDBMS (in Oracle 8i/9i, SQL Server) and strong troubleshooting skills.
• Worked closely with BI Data / System / Application Architects, Business User Groups, Analysts, Development teams and DBA\'s.
• Expertise in working on various platforms like HP, Solaris, IBM AIX and WindowsNT/2000.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.
• Experience in data modeling using Erwin data modeler
• Experience in Data Warehouse Administration Console(DAC),created execution plan , task , subject area , task group scheduling ETL
• Experience working on SQL Server
• Worked with business and created Functional Documents . And gather business requirements for reporting and performed Gap analysis
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Prepare detailed design documentation by adhering to CMMI standards.

EDUCATION

• BS Computer Science

TECHNICAL SKILLS

OBIEE: OBIEE 11.1.1.5/11.1.1.6/10.1X

Languages/Utilities: C, C++, HTML, XML/TOAD 7.0/SQL Developer, SQL Server Management

Databases, Database Tools: Oracle 9i/10g/11g, DB2 SQL Server 2005/2008, SQL Server 2008 R2 ,PL/SQL

ETL\\Data migration: Informatica 6X/7X/8X,
Data Warehouse Admin Console (DAC): DAC 10.1.3.4.1

Scripting: VB script

Testing Tools: Manual Testing , QC 9.5,10

Operating systems: Windows NT/XP/2000,Window7, Linux, UNIX

PROFESSIONAL EXPERIENCES

Confidential, Austin , Texas May 2012 - TILL DATE Obiee Consultant
Description
Confidential, is the world\'s premier provider of orthotic and prosthetic (O & P) services and products, offering the most advanced technology, clinically differentiated programs and unsurpassed customer service. Owning and operating hundreds of patient care centers nationwide, Hanger's business also includes distribution centers and the largest O & P network management company in the country. Worked on upgrade from 10 g to 11g solved critical issues during upgrade .Creating Obiee report from crystal report .Worked with business and created Functional Documents. And gather business requirements for reporting and performed Gap analysis. Extensively worked with business and data analyst's requirements gathering and to translate business requirements into technical specifications and repare detailed design documentation

Responsibility

• Responsible for upgrading Obi fresh Install of version 11.1.1.1.6.Upgrading the Rpd of 10.1.3.4 to 11g version solving the critical issue in Rpd and report after the upgrade . Raising SR with Oracle on bugs faced during upgrade.
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Prepared detailed design documentation by adhering to standards.
• Worked on Creating Obi Reports from crystal reports applying same business rule in obi which were applied on crystal reports.
• Worked and handle Security in 11g Obi web logic
• Worked on there Back Office Financial System and did Gap analysis on stored procedures to identify data elements ,calculation in measures and how the Report will be in Obiee
• Wrote TSQL, PL/SQL for implementing business rules and validate the data in backend to Obi Reports
• Created complex finance report in Obi using the same calculation and business logic defined in SQL Server Database.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Analytics Web.
• Worked with business and created Functional Documents . And gather business requirements for reporting and performed Gap analysis
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.

Environment: OBIEE 10.1.3.4, 11.1.1.5,11.1.1.6 , SQL Server Management 2012, SQL Server 2008 R2

Confidential, Grand Rapids, Michigan Jan 2012 - May 2012
Obiee developer
Description
Confidential, is big consumer products manufacture company . It have factory all over the world The aim of the project was to build data warehouse and build reporting for CMX that support documentum tool to create reporting for checking history of document workflow. Worked on obiee 11g upgrade from 10g solved critical issues in rpd and dashboard

Responsibility

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the Repository manager, users, user groups and their access profiles.
• Extracted data from different sources like DB2, Sql server, flat files and loaded into DWH.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Worked on obiee 11g upgrade from 10g solved critical issues in rpd and dashboard
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Created MUD (Multiple user Development) environment by utilizing projects.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP (ADSI) authentication and associating catalog objects and Web modules with the created users and groups.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Analytics Web

Environment: OBIEE 10.1.3.4, 11.1.1.5,11.1.1.6, Informatica Power Center 8.x/7.x, Oracle 11g

Confidential, Pittsburgh, PA June 2011 - Dec 2011
OBIEE Consultant
Description:
Confidential, is one of the leading bank in the United States . Worked in HR Technology department. The aim of the project is to provide the customer/manager accurate employees data headcount and turnover hires and re hires . Worked on BI apps using Informatica and DAC data warehouse admin console . Creating reports from data warehouse

Responsibilities:

• Gathered high level business requirements, analyzing database architecture, and mapping the same in the logical dimension repository.
• Identified the GAP's by analyzing the Datamart instance and provided alternative solutions as well recommended changes to database.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns
• Developed HR intelligence Dashboards, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions
• Created Execution plan ,Task, Task group , Subject Area , Rebuild the execution plan Create connection , schedule the ETL using DAC , ran ETL using DAC
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Created FAQ in dashboard and manage it
• Implemented security by creating roles & web groups, checks with External tables and LDAP.
• Involved in resolving bugs raised by users and QA
• Involved in resolving why the data is not accurate in certain reports
• Developed and executed PL/SQL queries on Oracle database using TOAD

Environment: OBIEE 10.1.3.4.0 Informatica Power Center 8.x/7.x, Oracle 10g, Data warehouse admin console(DAC) 10.1.3.4.1 , HP UNIX

Confidential, Bloomington,IL Sept 10 - May 2011 OBIEE Consultant
Description:
Confidential, is one of the leading insurance companies in the United States. The aim of the project is to help the customers to get a free online quote instantaneously. This application also enabled the field agents/customer representative of the company to view prospective customer\'s data and once the customer decides upon joining State farm, the application also deals with the customer registration, enrollment process, policies and their benefits. Worked on claim management system. Creating report from data warehouse

Responsibilities

• Gathered and analyzed requirements from the business users to provide focus on the Inside sales mainly focusing on service requests and Sales Analytics.
• Performed the setting up, installation and configuration of the OBIEE and the required connectivity for seamless integration with the data warehouse.
• Analyze, Design, and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer (Semantic Layer), and Presentation Layer.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns.
• Customized the Sales Branding, Customer Service dashboard by adding in new products and Finish Sales Trend Dashboards.
• Implemented HR, Sales, Finance Analytics (Proactive intelligence, Compensation Analytics, Operational Analytics). Integrated data from HR, Finance (EBS) and other enterprise systems and transformed data using Informatica (Pre Built Repository).
• Developed HR intelligence Dashboards, used KPI's which provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Created MUD (Multiple user Development) environment by utilizing projects.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP (ADSI) authentication and associating catalog objects and Web modules with the created users and groups.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Implemented Security/Access privileges by creating roles & web groups, checks with External tables.
• Built the applications in order to track predefined KPI'S (Key Performance Indicators).
• Installed and configured BI Office components in windows 2003 environment.
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.
• Developed and executed PL/SQL queries on Oracle database using TOAD

Environment: OBIEE 10.1.3 Siebel Analytics 7.8.4, Informatica Power Center 8.x/7.x, Oracle 10g, DB2, HP UNIX

Confidential, San Mateo CA May 09 - Sept 10

OBIEE Consultant

Description:
Confidential, is one of the nation\'s leading health benefit company serving more than million medical members nationwide. It has implemented Trizetto FACETS application to meet their Business and health care needs. A FACET is an application used for Health Care solutions. Created. Was working on sales analyst to find out top company to give best comminsion

Responsibilities:

• Gathered high level business requirements, analyzing database architecture, and mapping the same in the logical dimension repository.
• Identified the GAP's by analyzing the Datamart instance and provided alternative solutions as well recommended changes to database.
• Designed Siebel Analytics architecture and metadata design
• Developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Used Star Schema modeling with many extended tables and LTS.
• Developed many Case Solutions Time Series objects for comparing the various case types' service requests between the quarters.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, View Selector, Tabular with global and local Filters).
• Implemented security by creating roles & web groups, checks with External tables and LDAP.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• 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 of various Dashboards / Reports and Repository.
• Life-cycle support for migration efforts from Development to Integration Test to Production Analytics.
• 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 Siebel Analytics Repository.
• Developed and executed PL/SQL queries on Oracle database using TOAD

Environment: Siebel Analytics 7.8.4, Informatica Power Center 6.x/7.x, Oracle 9i/10g, DB2, HP UNIX

Confidential, Pittsburg, Pennsylvania Dec 07 - May 09
OBIEE/Business Intelligent Analyst Consultant
Description:
Confidential, is a very large food products producing company which manufacture different kind of food products .It have a very large data warehouse having data of sales of all product in different part of states generated sales report of top products selling which part of states

Responsibilities

• Gather user requirements, analyze and create the Business Requirements Document
• Review requirements with the IT team and translated the same into functional requirements
• Identification of Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases
• Defined Business Rules as per business requirements and IT standards
• Create a prototype of the project and demonstrate to the users for sign off
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Installation and configuration of OBIEE
• Analyze, Design, and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, Security using LDAP Authentication, Session Variables, and Initialization Blocks
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used Siebel Delivers and iBots
• Implemented the Drilldown and Drill through across for various Views of data for analysis purpose
• Involved in resolving bugs raised by users and QA
• Responsible for Integration and Regression testing of various Dashboards / Reports
• Developed many Informatica Mappings / Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator
• Created many PL/SQL packages for ETL Sanity Check and called same in pre & post sessions.
• Worked closely with the users during UAT and get a sign off from them
• Work with users and developers to resolve production issues during and after go-live
• Coordinating between off shore and onsite consultants and make sure that the deliverables are completed in time
• Life-cycle support for migration efforts from development to QA to production analytics.
• Documentation, Knowledge Transfer, and User Training

Environment: OBIEE 10.3.3.1, Informatica 7.1.4, TOAD, Oracle 9i

Confidential, Charlotte NC Feb 06 - Nov 07 OBIEE/Sr. Siebel Analytics / Informatica Consultant
Description:
Confidential, is a diversified financial services company that provides a broad range of banking. The web application was developed allowing account holders to perform on-line transactions like accessing Personal Accounts, Transfer of Funds (between accounts), Pay Bills, Checking Balances, detailed transaction reports and business solutions like International Trade, Foreign Exchange and International Corporate Banking. The application updates the account details of the account holder daily and automatically prints monthly statement

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Procurement and Maintenance Time Series objects for comparing the usage variations between the quarters.
• 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).
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups, checks with External tables and LDAP.
• 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.
• Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions.
• 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 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.

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

Confidential, India Aug 04 - Jan06 Data Warehouse Developer
Description:
The important mission of the data warehouse project is to Increase the frequency and quality of information by providing increased levels of beneficial data to stakeholders in a more responsive way at a predictable cost. Support and align with the corporate business strategy and differentiate the data offering from its competitors.

Responsibilities

• Involved in the analysis and designing of the data warehouse system requirements.
• Data Modeling (Star schema - dimension and fact tables) using Erwin.
• Extracted data form Flat files and Oracle database, and applied business logic to load them in the central oracle database.
• Responsible for dataextraction and data cleansing from databases external to the company.
• ETL was developed using Informatica to transform and load the data.
• Implemented various transformations like Expression, Lookup, Sequence Generator, Source Qualifier, Rank, and Aggregator etc. to load the data from Staging area to DW.
• Worked on sequential and parallel jobs to run multiple sessions concurrently and parallel to improve performance.
• Involved in performance tuning of various queries using Explain plan utilities.
• Identified various bottlenecks and critical paths of data transformation in sessions.
• Migrated folders from development repository to QA repository.
• Created email tasks for reporting the status to entire group.

Environment : Informatica 6.1, Erwin 4.1, Oracle 8i, SQLServer2000, Business Objects 5.1, UNIX (Solaris)