SUMMARY:

• Over 8 Years of strong experience in design, analysis, development and implementation of various applications using Oracle Business Intelligence, ETL Tool under Windows/Unix environment.
• Expertise in OBIEE10g/11g, OBIA and Security and Integration between BI application with Siebel and Oracle EBS Applications.
• Having strong experience in installation, administration of OBIEE components on various platforms (AIX/Windows).
• Having onsite experience in Abu Dhabi, UAE.
• Having experience in implementation of various OBIA and is subject matter of expert (SME) in Financial Analytics, HR Analytics, Projects Analytics and Order management & Supply Chain Analytics.
• Expertise in planning, designing and leading teams for implementing OBIEE solutions for leading clients using various implementation methodologies (Waterfall & Agile), deriving Functional Design based on Requirements, Development and maintenance of Data warehouse/Business Intelligence, performing solid GAP analysis for OBIA implementations to best use Out of the Box content.
• Worked extensively on modeling Hierarchies/Level Based Measures, Design & Development of ETL Mappings in Informatica/ODI, OBIEE & OBIA architecting OBI solution for High Availability, configuring Clusters/SSO/integration with Siebel 8.1.1 & OBIEE 10g/11g, designing and building all the layers of OBIEE Metadata Repository and design and development of reports and dashboards.
• Experience in multiple ETL tools such as Informatica/ODI which gives him enhanced skills in optimizing the data loads & a problem solver with a passion for simplifying and streamlining business processes using technology transparent to the business, has the ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.
• Strictly adheres to follow OBI best practices throughout the implementation life cycle in all the areas and he has exceptional training skills in Oracle Business Intelligence tools to technical audience as well as business users (Oracle University & Oracle Partner Network instructor in ODI/Informatica/DAC, OBIEE & OBI Mobile Application).

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center9.6, Power Mart 6.2/5.1,Informatica Power Exchange Navigator 7.1.

Databases: MS SQL Server, Oracle 10g/9i/8i, DB2, Sybase, MS - Access, Essbase, Tera Data.

Operating Systems: UNIX (AIX 5.1), Windows NT, Windows 7, Linux, Solaris.

Languages: SQL, PL/SQL, HTML, UML, UNIX Shell Scripting, C, C++, JAVA, .Net.

Scheduling Tools: DAC (Data Warehouse Administration Console).

Reporting Tools: OBIEE 11g/10g, Siebel Analytics

Business Intelligence: Siebel 8.1,OBIEE (Oracle Business intelligence Enterprise Edition), Administration, Answers, Interactive Dashboards, Oracle BI Publisher, OBIA Disconnected Analytics, Briefing Books, BI Delivers, Web Catalog Administration, Analytics Server Administration

Reporting Tools: OBIEE 11g/10g, Siebel Analytics

Scheduling tools: DAC (Data Warehouse Access Control)

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, TablesPhysical and Logical

WORK EXPERIENCE:

OBIEE Developer

Confidential, Los Angeles, CA

Responsibilities:

• Understanding Business Processes and gathering analytics requirements with Business
• Building POC and validating the reporting requirements with Business
• Design of OBIEE Metadata Repository based on the POC results and requirements
• Building OBIEE Metadata Repository based on the design
• Building Hierarchies and Level based measures
• Construction of Reports using Oracle Analysis (Previously Answers) with different views (Pivot, Chart) and extensively implemented Slider based navigation of data.
• Building Dashboards with multiple pages and using Dashboard Prompts
• Performance Tuning of OBIEE Reports
• Created Session & Repository Variables to achieve desired functionality.
• Created web - groups for security purpose with access privileges
• Created OBIEE Intelligent Dashboards, &Answers.
• Assigned Data level &Object level security to different Users and web groups based on their responsibilities.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created and used Siebel Delivers and iBots extensively.
• Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power
• Center.
• Involved in fine-tuning of Informatica Mappings.
• Involved in creating mappings using different Transformations like Source Qualifier, filter, Router, Aggregator

Environment: OBIEE 10g (10.1.3.4.1 ), Windows 2008 Servers, Oracle 10g

OBIEE Developer

Confidential, Weston, FL

Responsibilities:

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Worked with Retail and sales analytics to make sense of business performance by adding context to real - time business measure.
• Experience in Dimensional Data Modeling and Technical documentation and presentations.
• Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
• Responsible for setting up the environment including installation of OBIEE and Informatica in all the environments.
• Configuring the Analytics repository (RPD) and implementing the security to authenticate and authorize Oracle users.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Built 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 & Dimensions and defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
• Cross-functional ability (OBIA perspective of ETL, EBS Table structures, etc. )
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users.
• Create/Manage Repository/Web Users and Groups and assigning permissions using OBIEEAdministration Tool.
• Designed and implemented Informatica Power Center 8.6 for ETL to load target Oracle 11g database.
• Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
• Created Mappings to demoralize data from a Normalized format.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Worked on Oracle Procurement & Spend Analytics, Oracle Supply Chain & Order Management Analytics, Oracle Service Analytics, and Oracle Financial Analytics.
• Up graded OBIEE and database from 10G to 11G environment.

Environment: Oracle 11G, OBIEE 11.1.1.3/10.1.3.4 , OBIA 7.9.6.3, BI Publisher 10.1.3.4, DAC 7.5, ETL/Informatica 8.6, SQL DEV, Erwin, SQL* Loader.

OBIEE Consultant

Confidential, Alpharetta, GA

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business
• Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Worked on oracle module subject area such as Order Management.
• Designed and developed Customized the existing Reports/Dash Boards in Order Management such as
• Inventory, Order fulfillment, Order Management
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developing Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• 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.
• Worked extensively on Answers, Delivers, and Intelligent Dashboards for Procurement and Spend Analytics.
• Developed Various Dashboards and Reports and Created the Business Model for Ad - hoc queries using
• Oracle BI Answers and assigning them to application specific dashboards.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.

Environment: Windows XP, OBIEE 10.1.3.3, Oracle Financial Analytics 7.9.5, Informatica 8.1, DAC, oracle 10g/9i, SQL, TOAD, PL/SQL.

Data Modeler/ ETLDeveloper

Confidential

Responsibilities:

• Interacted with the business users to gather reporting requirements focusing on Salesgroups, Service Requests and Sales Analytics.
• Actively involved in designing of low level process diagram for the project, Consumer Data Mart.
• Designed the logical data model from the technical design documents and translating to a physical data model using Erwin tool.
• Developed the documentation on the complete data mart ETL process.
• Created Repository, Folders, and User accounts using Repository Manager.
• Involved in Designing and creating mappings using Power Center Designer.
• Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load consistent data into Warehouse Database.
• Various Performance and Tuning techniques used to improve the load.
• Supported the data mart in Production.