SUMMARY:

• Over 13 years of experience in IT and 9+yrs Experience in providing end - to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE 12C Cloud,Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Strong experience in developing OBIEE/Siebel Analytics Repository- three layers (Physical Layer, Business Model & Presentation Layer).
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
• Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator.
• 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.
• Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections
• 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.
• 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.
• Experience in Installing, Upgrading and Configuring OBIEE, OBIA from 10.1.3.4.1 to 11.1.1.3.0 and from 11.1.1.3.0 to 11.1.1.5.0 and 11.1.1.7.x.
• Experience in working with OBIEE 11g Web Logic Server, Enterprise manager Fusion Middleware, RPD and Webcatalog.Worked in the integration of Essbase with OBIEE to enable reporting on top of OLAP cubes and accomplish slicing and dicing of data.
• Extensive experience in at all three layers (Physical, Business Model and Presentation) of RPD using the Oracle BI Administration.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, building Analytics Repository and Metadata Modeling consisting of three layers (Physical Layer, Business Model (Semantic Layer) & Presentation Layer, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• 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.
• 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.
• Knowledge in Data warehousing development using ETL tools such as Informatica Power Center 7.x/ 6.x and developed Informatica Mappings and Workflows with Worklets& Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experience working with various Heterogeneous Source Systems like Oracle, Teradata, and Flat files.
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Implemented complex business rules in Informatica by creating re-usable transformations, robust mappings/mapplets.
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Provide HIPAA compliance requirements for Oracle Stack and Database
• Experienced in creating interactive UI Design (Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design using HTML, XML.
• Hands on experience on SAP BO, BICS, Tableau

TECHNICAL SKILLS:

BI : OBIEE Cloud12c/ 11g/10.1.3.4/Siebel Analytics8.0/7.8/7.7 EPM11.1.2/9.3

ETL: Informatica Power Center/Power Mart 8.6/8.1.1/7.1.4/6.2

RDBS: Oracle 10g/9i/8, ODI, BO, Teradata, Oracle Financials R12/11i (11.5.10/11.5.9/11.5.8 )

Modeling: Dimensional Data Modeling-R Modeling

Scheduling: DAC 7.8.5v, CVS, VMS

Languages: .Net, SQL, PL/SQL, ESSBASE, Hyperion, People soft

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS

Integration Services: Oracle SOA suite, Siebel CRM

Operating Systems: Ms-Dos, Win NT 2K Win XP, Red Hat Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Performed in-depth analysis and documentation of business logic and requirements. Developed high level design documents for reporting and analysis projects. Extensive experience in working with Multi User Development Environments
• OBIEE 12C Cloud Upgrade and development,data visulaisation usage experience for sales and market performance application.
• Deployed the RPD from MUDE to DEV, QA and production environments
• Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.
• Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.
• Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
• Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
• Created schedules to seed and purge cache for cache management. Implemented security by creating roles and web groups, and defined Object Level and Data Level .Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
• Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G.Worked on RTF Template, OAF(Oracle Application Framework), and interactive template for migrating reports from 11G to 12C.Worked on scheduling BIPublisher reports basing on user requirement.
• Performed monitoring and analysis on OBIEE report usage. Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.
• Participated in the Modeling of several multi dimensional 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.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Used Oracle Data Integrator ODI to extract relevant data from Teradata and map it to Siebel interface tables.
• Used Oracle Data Visualization Desktop to connect to OTBI environments to get data
• Involved in modification of local object mask to simplify the creation of more number of interfaces
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle Business Intelligence(OBIEE)12c,Cloud,,O racle BI Server, BI Publisher Enterprise,Teradata, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Confidential, CA

Sr. OBIEE Consultant

Responsibilities:

• Performed in-depth analysis and documentation of business logic and requirements. Developed high level design documents for reporting and analysis projects. Extensive experience in working with Multi User Development Environments
• Deployed the RPD from MUDE to DEV, QA and production environments
• Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.
• Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.
• Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
• Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
• Created schedules to seed and purge cache for cache management. Implemented security by creating roles and web groups, and defined Object Level and Data Level .Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
• Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G.Worked on RTF Templet and interactive template for migrating reports from 11G to 12C.Worked on scheduling BIPublisher reports basing on user requirement.
• Performed monitoring and analysis on OBIEE report usage. Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.
• Participated in the Modeling of several multi dimensional 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.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Design and develop Essbase data cubes to reporting and forecasting.
• Designed Essbase data cubes to support dashboard models.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Used Oracle Data Integrator ODI to extract relevant data from Oracle EBS and map it to Siebel interface tables.
• Used Oracle Data Visualization Desktop to connect to Oracle Cloud Application OTBI environments to get data
• Involved in modification of local object mask to simplify the creation of more number of interfaces
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle Business Intelligence(OBIEE) 11.1.1.7/12.2.1.0.0, BI Publisher 11.1.1.7.1/12.2.1.0.0, Template Builder, OBIEE 10G/11G/12C, Oracle BI Server, BI Publisher Enterprise, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Confidential, Portland, OR

Sr OBIEE Consultant

Responsibilities:

• Install, upgrade and configure all components of OBIEE on Development, Test and Production server
• Implemented security based on LDAP Authentication
• Created mock-ups, prototypes, technical design documents, business (user) requirements documents, test documents, etc. to deliver DW/BI solutions.
• Created design documents and ETL mapping specification documents for DW/BI solutions and provided estimates for the same.
• Performed Data analysis and Data Profiling on data to understand requirements of data and business, to ensure data follows the defined standards and to identify data anomalies.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers
• Migrated RPD, catalog and configured Active Directory Security on servers. Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly Perform validation of data on the reports and monitor the performance status of the same
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and tuning of mappings for better performance.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers
• Created user level security for intelligence dashboards based on Business Requirement
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Developed various Interfaces, Packages and Procedures using ODI to load data from Flat file & Relational Sources to Data Warehouse.
• Experience in ODI components like designer, topology manager, operator and on other ODI concepts Master Repository, work Repository, Project Models, sources, targets, Interfaces, Packages, Scenarios, Knowledge Modules, metadata.
• Created users, groups, access privileges and query privileges using Security settings in OBIEE AdminTool Integrated BI Publisher with OBIEE.
• Installed Clustered Oracle WebLogic, SOA, And Web Center. Installation of oracle application server infrastructure, middle tier, and business intelligence
• Installed Oracle Identity Management Components. Developed ODI interfaces utilizing technologies such as Oracle, File, and JMS to move data from a source system to a target system
• Developed and supported integrations using Oracle Data Integrator (ODI) to implement data and master data flows across multiple systems and technologies such as Oracle EBS, Teradata, etc.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.
• Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition. 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).
• Defined users, groups, access privileges and query privileges

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, BICS, OBIA (7.9.6.x), Manufacturing Analytics, Oracle BI Server, BI Publisher Enterprise, BI Publisher, TOAD, Oracle11, Oracle BI Presentation Server, OBIEE Administration Console, OBIEE Enterprise Manager, DAC, ODI, Power Center 8.6.1

Confidential, Boston

Sr. OBIEE (BI Publisher) Analyst

Responsibilities:

• Experience with installation, configuration of OBIEE 11g, setting up the web logic server, with Hyperion EPM11.1.2 Smart view, Interactive reporting, dashboards,
• Upgradation of OBIEE 10.1.3.4. to 11.1.1.5 and hands on experience with reports and dashboards development of OBIEE 11g environment
• Analyzed, Designed, and Developed Metadata repository (RPD) level data modeling for Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Experience with OBIEE Publisher 11g REPORTS development, ODI working on Knowledge modules, Meta data navigator, Aggregate functions, BI scheduler settings and migration
• BI Publisher "integrated” Reports integration with JMS(JDE) Server on Development, SIT, UAT and Production environment.
• Gathering the requirements for Client Billing(FIABS) system for OBIA Financial analytics, interaction with the business manager for technical Specifications.
• Designed Publisher reports in the HR Functional Client Billing and Site Billing modules.
• BI Publisher reports are triggered by Oracle 10g database usage along with the real-time Production issues based on BI publisher schedule, setting up active directory and configuration for printing reports.
• Developing SQL queries against data source, implementing security within reports that is integrated with OBIEE security Incorporating BIP reports on OBIEE Dashboards
• Hands on experience with XML Publisher templates, template calling, hyperlinks and XLF files, e Text templates, XML conversion
• Trouble shooting of BI publisher reports For Oracle BRM, bill revenue reports, check forms, purchase orders and Invoices through Database Transaction and SSRS, SQL Statements
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Generate XML data by creating data template, create report Layout Template in Word, Upload Template, Associate with View

Environment: OBIEE 11.1.1.x, BI Publisher, SQL, OEM, Oracle Hyperion EPM 9.1, Oracle EBS, ODI, SQL Development.

Confidential, St. Paul, MN

OBIEE Analyst

Responsibilities:

• Analyzed, Designed, and Developed Metadata repository (RPD)level data modeling for Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Experience with installation, configuration of OBIEE 11g, setting up the web logic server, with Hyperion EPM11.1.2 Smart view, Interactive reporting, dashboards,
• Familiar with migration of Micro strategy to OBIEE 10.1.3.4. and hands on experience with reports and dashboards development of OBIEE 11g environment
• Ability to mentor small team with OBIEE11g development and deployment through development to Production environment.
• Develops and delivers HR Analytics Ad hoc Discoverer Reports for business users to help facilitate system stabilization.
• Defines Role to Responsibility mapping and develops Individual Training Plan (ITP) for users and Corporate HR Analytics groups; Performs change management duties for business entities.
• Experience with OBIEE Publisher 11g REPORTS development, BI scheduler settings and migration
• Customized Dashboard pages like Invoice Details and All Transactions in Receivables Dashboard.
• Working on Invoices, Transactional reports , payroll exception, timesheets based HR, Financial analytics related environment.
• Assists in Self Service HR Analytics and Self Service benefits configuration and troubleshoot customization issues.
• Created logical data models, recognize source tables and columns, to build Micro Strategy Schema objects into Hyperion BRIO including Attributes, Facts, Hierarchies.
• Acts as a liaison between business and technical team to define OBIEE Analytics requirements including Repository definition and Dashboards for managers and executives (role based).
• Provides HR Analytics, Benefits and Salary base table and column information to technical team and assists them in defining OBIEE Repository requirements, and defines design and content requirements for Dashboards.
• BI Publisher reports are triggered by Siebel Workflows and documentum tool usage along with the real time Production issues based on BI publisher scheduler and configuration for printing invoices and reports.
• Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
• Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) using Meta data navigator, OBIEE Google maps integration, Knowledge modules, implementation a to enable building the OBIEE Logical Layer
• Experience with Oracle Data Integrator10g modules (Designer, Topology, Operator, and Security Manager)..
• Used various Transformations like Lookup, pivot reports, Expression, Filter, Interactive graphs and Joiner for cleansing and consistent data.
• Developed Siebel PP address verification process using integration object, Siebel EAI Adapter, EAI XML Converter, Java scripting and eScript
• Trouble shooting of BI publisher reports and Invoices through Siebel Transaction Database and SQL Statements
• Usage of OLAP SQL querying for daily transactions and invoices related production issue probing.
• Identified key facts and dimensions for the design of the star/snow flake schema.
• Designed conceptual data model , logical and physical data models using Erwin data modeling tool and documented analysis results in a logical format to be presented to the client .
• Used reverse engineering to connect to existing database and created graphical representation and involved in script generation.
• Analyzed Source System and determined the necessary data for the requirement definition.
• Validated the model and checked for compatibility of data with response to questionnaire from analyst using SQL.
• Created Meta data Repository and documented for Data Analysis in Informatica.
• Extensively worked with the report designing and dashboards.
• Worked with BI publisher and built the reports.

Environment: OBIEE 11.1.1.3/10.1.3.4, PL\SQL, Oracle BI Apps 7.9.6, BI Apps 7.9.6.1(Financial Analytics, HR Analytics) Oracle Applications R12, General Ledger, Micro strategy, Account Payables, Account Receivables, Order Managements, Siebel tools, Oracle EBS 11.0.3, SQL Developer, TOAD.

Confidential, WI

Sr OBIEE/BI Publisher

Responsibilities:

• BI Publisher "integrated" with Siebel 8.0 environment with integration on Development, SIT UAT and Production environment
• Designed Publisher reports Financial Analytics, Responsible for designing plant-by-plant deployment plan for Financial Analytics,, testing strategy, and functional specification documentation.
• BI Publisher reports are triggered by Siebel Workflows usage along with the real time Production issues based on BI publisher scheduler and configuration for printing invoices and reports.
• Developing SQL queries against both OLAP and OLTP data sources Implementing security within reports that is integrated with OBIEE security Incorporating BIP reports on OBIEE Dashboards
• Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
• Hands on experience with XML Publisher templates, template calling, hyperlinks and XLF files, e Text templates, XML conversion
• Trouble shooting of BI publisher reports and Invoices through Siebel Transaction Database and SQL Statements
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Generate XML data, create report Layout Template in Word, Upload Template, Associate with View
• BI Publisher Report Maintenance Separate query, layout, and translation Report output
• Data Logic Layout Translation BI Publisher
• Worked on both OLTP and OLAP systems and even excel spreadsheets and pulled the data from them.
• Identified key facts and dimensions for the design of the star/snow flake schema.
• Designed conceptual data model, logical and physical data models using Erwin data modeling tool and documented analysis results in a logical format to be presented to the client.
• Oracle BI Apps SQL Server Siebel CRM, E-Business Suite, PeopleSoft BI Publisher Data Source
• BI Publisher Integration, create report layouts, report layout deployment and administration
• BI Publisher Engine using XSL, BI Publisher Client, BI Publisher Engine, XSL Siebel Application Web Services, BI Publisher Server Siebel & OBIEE BI Publisher Client BI Publisher Engine XSL OBIEE Server Any Siebel Version Data
• Scheduling and Bursted reports, wider range of Template types and output formats.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle EBS R12, Oracle BI Apps 7.9.6, Oracle 10g,Siebel tools.

Confidential, AZ

Sr. OBI EE Developer

Responsibilities:

• Created Technical Specs (SOA) based on functional requirement. Identified the Facts and Dimensions based on the design specification.
• Created Dashboard pages like AR Balance, Time & Expense, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys .
• Extensively worked on admin tool , Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports , and cutomized widgets .
• Designed, developed and modified OOTB reports and dashboards.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non-Real-Time reports.
• Client was using intensive custom built processes. My tasks involved everything from OWB and Workflow installation to the actual data conversion, migration to production, Installed and evaluated OBIEE and Oracle Data Integrator(ODI) 10.1.3.5.0.
• Implemented and automated batch integration processes that import Oracle ERP Customer, Agreement, and Licensing data, Symantec Partner data, and Marketing Opportunity data into Siebel CRM using Siebel EIM, PL/SQL, Java scripting and Unix shell scripts. Designed and implemented data migration solutions for merge and acquisition activities prototyped Siebel and Sharepoint integration using Siebel Web Service, EAI, Workflow, Business Service, iFrame, and soupUI.
• Configured users, roles and privileges in administration console.
• Worked on security for users based on LDAP Authentication and SSO in Production and also other Authentication types ( External table authentication and Database ) in other environments.
• Worked extensively on Custom Build Real-time (OLTP source) and Non-Real-Time Reports to enable Market/ Corporate Users to Order Management, Installation Management and Cash Management .
• Expertise in Financial Analytics, sales analytics, marketing analytics.
• Created the Custom Business model rpd from the scratch.
• Configured C ustom Business model to report on Oracle HRMS Sales Rep and Installer Pay Stubs, pay to procure(P2P) and Daily Commission Report . This involved creating dimensional hierarchies, Level based measures, Fragmentation content, Pivot reports, Aggregations, Interactive reports and complex joins. Configured Bridge and Helper tables .
• Configured Implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.
• Created various Static and Dynamic variables for different report and Security requirements.
• Involved in upgrading the Siebel analytics web catalog to Oracle BI presentation catalog. performed upgrading the existing repository for use with Oracle BI infrastructure.
• Responsible for Production support and involved in Migration of metadata and Web catalogue from Dev to UAT to production and also installation of OBIEE
• Involved in Clustering of Production Environment, Cache management, Creating Aggregate tables, Ibots etc
• Involved in installation and configuration of disconnected analytics.
• Involved in performance tuning at the report level, rpd level, dashboard level
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Monitored the daily Incremental Load in Production environment and fix any issues during the Load.

Environment: OBIEE 10.1.3.4, Hyperion Essbase, Oracle BI Apps 7.9.6, (Financial Analytics, Order Management and Supply Chain Analytics) Oracle Applications R12, General Ledger, Account Payables, Oracle 10g, Siebel tools, Oracle Essbase, Informatica Power Center 8.6, BI Apps 7.9.5(Financial Analytics) Oracle Applications R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Windows NT and XP,AIX. SQL server 2005/2000, Oracle EBS 11, Siebel CRM, SQL Developer, Teradata, peoplesoft

Confidential, GA

Oracle Business Intelligence Analyst

Responsibilities:

• Captured Business Intelligent requirements from demonstrate out of box subject areas , Facilitate Out of box Metrics , SOA applications , workshops and prepared high level and detailed design documentation .
• Installed and configured OBIEE, Informatica, Oracle Applications(eBS R12) and DAC.
• Took part in DBA work as well.
• Designed and Developed call report/ Revenue Star/Company Star/Motivator Star/Person Star/Usage Accelerator Company/Contact/CRM Usage schema diagrams based on Siebel CRM Customizations and Existing Motivator System Functionality .
• Developed Company Star Schema diagram that has the relationships to Entity/Risk Ratings/Marketing Source (Campaigns)/Primary Contact/Sales Rep (Primary/Secondary via W ORG PARTY Visibility)/Day Dimensions.
• Configured/Developed Physical Layer/Business Layer/Presentation Layer Objects including Custom Tables/ Alias/Keys (composite)/Foreign Keys, Business Layer Logical Display Folder/Sources/Complex Joins/Keys/Foreign Keys/Dimensions/Drilldown Keys for Division, LOB, Region, Team, Center hierarchies/Aggregations.
• Customized the reports to inmprove the look and feel .
• Developed BI dashboards for motivator dashboards including Tiering Report, Sales Performance etc., extensively used Dashboard , Pages , Sections , Add Column , Dashboard Prompts including Constrained Prompts with Default Session Variable Values Initialization, View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Dynamic Access mechanism via My/My Team/My Company Team/My Opportunity Team View modes, Add Explicit Permissions on Shared Folders via Catalog Manager etc.
• Customized Financial analytics

Environmen t: OBIEE, Oracle BI Platform 10.1.3.3.1, Oracle BI Applications 7.9.3, Data Administration Console (DAC), Siebel Answers, Siebel Administration Tool, Oracle BI Server, Oracle BI Scheduler, Oracle BI Presentation Server, Siebel CRM, Financial analytics, .