SUMMARY

• Over 6+ years of professional experience in OBIEE/Siebel Analytics and BI Publisher/XML Publisher (E - Business Suite).
• Expertise in developing Custom Reports.
• Expertise in Fit Gap analysis to gather, define and document business requirements. Both for Data warehouse models and Business intelligence models.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, Access privileges, LDAP authentication setup, External table and configuration of Multiuser Development Environment.
• Experienced in usage of Disconnected Analytics and Siebel/Oracle Delivers for sending alerts via intelligence agents (iBots) to the dashboards for the end users.
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Strong experience in developing and customizing Reports and Forms using Oracle Reports 10g/4i Discoverer 10g/4i and XML Publisher 5.6.3/5.6.2 , OBIEE 10.1.3.x,OBIEE 11.1.1.
• Experience in supporting the production system and handling day-to-day issues.
• Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.
• Hands on experience in customizing reports, filters and charts in Oracle Answers.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views .
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Strong experience in developing and customizing Reports and Forms using Oracle Reports 10g/4i Discoverer 10g/4i and XML Publisher 5.6.3/5.6.2 , OBIEE 10.1.3.x, OBIEE 11.1.1.
• Experience in supporting the production system and handling day-to-day issues.
• Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Purchase Order, Service Contracts, Purchasing, System Administrator.

Application Tools: Reports 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2 , OBIEE 10.1.3.x,OBIEE 11.1.1. BIApps 7.9.6.x/7.9.5.x

Databases & Tools: Oracle 11g/10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUSSQL* Loader,SQL Developer

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, XML.

Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

ETL Tools: Informatica 8.x/7.x/6.x

PROFESSIONAL EXPERIENCE

Confidential, NE

OBIEE Consultant

Responsibilities:

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model (Physical, Business and Presentation layer).
• Migration to OBIEE 11.1.1.3
• Experience on OBIEE 11.1.1.3
• Involved in setting Up MUDE in the organization.
• Configured Agents to send the Reports through Emails to the user group.
• Developed Parent Child Hierarchies in the repository.
• Identified granularity level of the Financial data required to be available for analysis.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Created measures and level Based measures in Business Model
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Developed PL/SQL procedures and functions and used the same in mappings, pre and post sessions.
• Used Debugger to troubleshoot the mappings.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Used Table and pivot table to display hierarchical columns.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Customized Meta Data Repository (RPD) to work with PeopleSoft Financials (AP, AR, GL and CAM). Pulled new physical tables to physical layer of RPD, joined them with dimension tables, developed hierarchy and presented them to presentation layer.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Used conditions to determine whether agents delivered their content and executed their actions, whether actions links are displayed in dashboard pages, and whether sections and their contents are displayed in dashboard pages.
• Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Worked with Cache persistence Wizard to efficiently handle cache
• DevelopedMaster Detail Report in OBIEE.
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Used the Oracle BI Presentation Catalog in order to a. Perform basic tasks such as creating, deleting, and copying objects and folders. b. Performed object-specific tasks like modifying settings using the associatededitorCreating/ assigning an agent.
• Archived the entire catalog, folders, or objects to unzip them in another directorylocation.
• Specified permissions that determine the folders and objects that users can view.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.
• Used Java script to disable the dashboard prompts in the dashboard page using OBIEE Answers.
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Environment: OBIEE 11g/10g, BI Publisher 10.1.3.4.1 /11.1.1.3.0 , Oracle 11g/10g, TOAD, SQL, Windows XP.

Confidential, OH

OBIEE Consultant

Responsibilities:

• Translated Business requirements into technical requirements.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics using OBIEE.
• Created Dashboard prompts and advanced filter criteria.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Created data only excel templates using BI Publisher.
• Worked on Cache management mechanisms to clear out the Cache on the OBIEE server side.
• Migrated Webcatalog and RPD from one environment to other environment.
• Registered the XML Publisher report as concurrent program.
• Implemented custom drilldown functionality in BI Publisher to replace the crystal reports functionality.
• Replicated the Reports, Dashboard, and Functionality in Crystal reports to OBIEE (nearly 55 reports).
• Used the expression builder in the BMM layer and created various calculation measures.
• Experience to Design AR Invoice printing on Demand and Invoice Past Due Net Term Reports for Intel customers by giving Invoice Date range and optional Invoice range using XML/BI Publisher.
• Created a XML / BI publisher report for Transaction register in Inventory.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Provided source logic to build some custom columns in data warehouse.
• Designed and developed the OBIEE metadata repository (.RPD) using OBIEE Server Admin tool by importing required objects (Dimensions, Facts,Aggregations) with integrity constraints into physical layer using connection pool, developing multiple dimensions and logical and facts/ Measures objects in business model layer, and creating the presentation catalogs in presentation layer
• Worked on Security management for users, groups and web-groups using the various authentication systems such as LDAP, OS, Database and Database table authentication using Session Variable features, as well as Dashboard / Report-level security.
• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)
• Created Dimensional Hierarchy, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer to improve performance in rpd.
• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions
• Created new requests and opened Answers for adhoc reporting to the End users.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector using Oracle BI Presentation Services.
• Solved few production issues in Purchase Orders Dashboard.
• Customized Dashboard Pages like Purchase Order Detail and Requisition Summary in Purchase Orders Dashboard.
• Created Data Model documents for Purchase Orders, Iexpense and Accounts Payables Modules.
• Involved in Unit Testing and Performance Testing for reports.

Environment: OBIEE 10G, BI Publisher 10.1.3.4.1 , Oracle 10g, SQL*PLUS, SQL*Loader, TOAD

Confidential, NY

OBIEE Consultant

Responsibilities:

• Responsible for the installation of BIApps 7.9.5.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Developed the Common Processes (Mapplets, reusable Expression Transformations and Lookups) for the data validation and Exception Handling
• Used error routines and exceptions handling techniques as per business rules
• Precise Documentation was done for all mappings and workflows.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Analyzed, Designed and Developed OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Worked using Catalog manager to migrate web catalog between different instances.
• Created Dimensional Hierarchies and implemented Business Logics for Facts.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Used BI publisher for special reporting requirements.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Configured and validated OOTB Profitability and Payables Analytics.
• Customized Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Created Dashboard prompts and advance filter criteria.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Worked on the testing and validating the Repository in OBIEE.
• Customized Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard in OBIEE.
• Developed many complex Informatica Objects with various transformations.
• Responsible for the design and development of execution plan in DAC which will call the Informatica workflows and updates the Image tables.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica WorkFlow Monitor.
• Designed and Developed Sessions and Workflows.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Developed RMA Detail Report in Order Management by using OBIEE.

Environment: BI Apps 7.9.5, OBIEE 10.1.3.4.0 , Informatica 8.1.1, DataWarehouse Administration Console 7.9.5, Human Resource Analytics, Financials Analytics, Order Management Analytics, Procurement & Spend Analytics, Oracle 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, New Jersey, NJ

Oracle Apps /OBIEE Consultant

Responsibilities:

• Designed and Developed New Financial Dashboard pages in General Ledger, Payables and Receivables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Used various Transformations like Lookup, Expression, Filter, and Joiner for cleansing and consistent data.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Optimized performance by tuning the Informatica ETL.
• Designed and developed various Dashboards that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
• Designed Employee Information Report.
• Developed an Interface for the Standard Items of Sales Orders Import in Order Management.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Developed an interface program using API for loading item On Hand quantity balances.
• Designed and developed custom Dashboards.
• Demonstrated the willingness to tackle several types of issues like Translation, Metadata Changes, ETL Changes and Performance.
• Updated and tested DAC ETL execution plans. Documented installation, upgrade and customization procedures for release.
• Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.
• Developed Open interface to import orders from legacy system to apps.
• Developed Give Service Report using XML/BI Publisher in Service Contracts.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Accounts Payables, Account Receivables, Order Management, Service Contracts, Install Base, Inventory, OBIEE 10.1.3.2.1 , Informatica 7.x, XML/BI Publisher, Oracle 9i, Discoverer 10g, Financials Analytics, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, UNIX

Confidential

Siebel Analytics Consultant

Responsibilities:

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Upgraded and migrated Siebel repository (.rpd) database from Siebel Analytics 7.7 to 7.8
• Designed and build Star schemas.
• Configured repository (RPD) to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented Siebel security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Used BI Publisher for manage and deliver all types of highly formatted documents.
• Assist in performance of Gap Analysis related to Data Models and data extracted in ETL’s, and map client requirements into Siebel Analytics functionality.
• Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Extensively worked on Data Extraction from Databases and flat files by using Informatica
• Created reports of using BI Publisher through OBIEE
• Created and scheduled iBots as per the business requirements
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement
• Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process
• Applied Optimization techniques and tuned performance of the reports.
• Provided technical and user documentation and training.

Environment: Oracle Business Intelligence Enterprise Edition, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, BI Publisher, Oracle 10g,, PL/SQL Windows XP Prof.