Summary of Experience:

• Over 8 years of professional experience as Technical ERP Developer/Consultant in Oracle E-Business Suite Applications with expertise in General ledger GL, Account Payables AP, Account Receivables AR, Order Management, Purchasing PO, and Inventory INV.
• Over 5 plus years of experience as OBIEE Technical Consultant using 11g / 10g and BI publisher.
• Extensively worked on Installation and configuration of Financials and Supply Chain Analytics. Experience in using Data Warehouse Administration Console DAC to schedule the Informatica jobs and metadata management.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers iBots/Agents .
• Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup groups, access/query privileges , metadata objects and web catalog objects Dashboard, Pages, Folders, Reports .
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management RPD , Extraction Transformation and Load ETL .
• Proficient with Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL Developer, Oracle Reports 11g/10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL Loader, SQL Plus, Data Loader, TOAD and UTL FILE.
• Experienced in Complete Software Development Life Cycle SDLC which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Involved in development of RICE components Reports, Interfaces, Conversions, Extensions for the Oracle Applications E-Business Suite implementation across major modules.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer EUL .
• Strong Conceptual, Business, Analytical skills highly motivated team player and ability to work independently as well.
• Focused, result oriented and committed to execute the tasks within the set project timeframe.

Skills:

Work Experience:

Confidential

OBIEE Consultant

Responsibilities:

• Development and customization of OBIEE repository
• Created different reports based up on user requirement using multiple compound layouts views Table, Pivot, Chart, Static View, Narrative View, Column Selector, and View Selector.
• Implemented dynamic dashboard and used guided navigation to drill into particular segments of the business in a performance.
• Configured agents for delivering alerts and for Cache Seeding.
• Administration- Implemented Security by creating roles web groups using External tables and SSO, repository merge and web catalog migration
• Implemented Event Polling Table for Cache management.
• Extensively used Variables for different purpose.
• Crated different application roles and user using Enterprise manager.
• Merged the RPDs using BI Administrator tool and deployed the RPD across the environments using Web logic Enterprise manager.
• Extensively used web catalog manager to migrate the reports across the environments.
• Worked on deployment of web app in 11g for customization.
• Raised SR with oracle and worked closely with oracle on the bug fixes.
• Communicated the Status of milestones and project status report with Strategic and Internal stakeholders.
• Implemented and Created custom Reports in Usage tracking reports User Acceleration.

Environment: OBIEE 11.1.1.7.0 / 10.1.3.4, OBIA/BI APPS 7.9.6.3/7.9.5, Seibel Analytics, Oracle Applications R12/11i GL, AP, AR, PA , Financials, Order Management, HR Analytics, Procurement Spend, Project Analytics , Discoverer 10g, Database 10g, TOAD, SQL Plus, Informatica 9.0.1

Confidential

OBIEE LEAD

Responsibilities:

• Tech Lead for BI Development, leading 3 developers.
• Closely worked with business in gathering the requirements and created a business model.
• Worked with BA in creating Business Requirements Document
• Worked with International business analyst and business users in creating the mockups dashboards/reports
• Worked with Data Architect on designing the dimensional model
• Involved in Building the RPD based on the requirements
• Involved in building reports and customization of dashboards based on the requirements.
• Integrated OBIEE with EBS for Single Sign On SSO
• Have developed custom mappings for a third data source and integrated it with the existing analytic warehouse.
• Setup of Multi User Development Environment MUDE in OBIEE.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.

Environment: OBIEE 11.1.1.6.2 /10.1.3.4, OBIA/BI APPS 7.9.6.3/7.9.5, Seibel Analytics, Oracle Applications R12/11i GL, AP, AR, PA , Financials, Order Management, HR Analytics, Procurement Spend, Project Analytics , Discoverer 10g, Database 10g, TOAD, SQL Plus, Informatica 9.0.1

Confidential

OBIA LEAD

Responsibilities:

• Complete end to end production support.
• Implemented Financials analytics.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
• Onsite Lead for the ongoing support of the OBI Applications solutions.
• Analyzing and fixing issues in OBIEE analytics, dashboards, and repository layers, alerts etc.
• Analyzing and fixing issues in the ETL ETL mappings, workflows, and DAC execution plans
• Implemented best practices for architecture, ETL, and business intelligence tools.
• Implemented migration techniques for OBI Apps components into various test and production environments.
• Optimization of the OBIEE analytics, dashboards, and repository layers, etc.
• Optimization of the ETL mappings, workflows, and DAC execution plans.
• Optimization maintenance of the Data Warehouse, implemented strategies for the fact tables and indexing.
• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
• Interacting with business users and other stakeholders, assessing business requirements and designing appropriate Data Warehouse solutions also enhancement to existing BI solution.
• Assist users with problems and resolves issues independently.

Environment: OBIEE 11.1.1.5, Oracle 11g/10g, TOAD, PL/SQL, Informatica 9/8.6.1, Oracle EBS R12

Confidential

OBIEE / BI Consultant

Responsibilities:

• Implemented OBIA for Procurement and Spend, Financials and HR
• Worked with metadata modeling using BIEE, various modules of OBI Applications against source systems including E-Business Suite, Siebel CRM, PeopleSoft HCM, and Essbase.
• Experienced full cycle implementing specialist of Oracle Datawarehouse, BI Applications and OBIEE reporting solutions at several clients.
• Provided technical direction and leadership in positioning, designing, engineering and delivering Oracle DW / BI solutions.
• Proposed road map for Oracle BI Application Analytics, Custom BI Analytics and OBIEE.
• Designed Oracle BIEE/Siebel Analytics CRM/EBS/Peoplesoft solutions on projects, three end to end Oracle BI project.
• Participated in Designing enterprise-wide Business Reporting and Data warehousing solutions.
• Integrated OBIEE with Essbase as a data source for Oracle BI Repository
• Drove requirements to work effort estimation, project planning and implementation
• Reviewed and validated business requirements and provided design specifications for the OBIEE solution.
• Drove requirements to work effort estimation, project planning and implementation
• Experienced in Out of the Box implementation Oracle BI Applications, implemented and deployed out-of-box OBIEE Analytics against Oracle EBS R11 ,R12 and PeopleSoftHCM 9.1
• Experienced in Extract, Transform, and Load ETL for prebuilt EBS Adaptors, full and incremental load to Oracle Business Analytics Warehouse OBAW
• Experienced in configuring ETL metadata, including Informatica Source Analyser, Designer, Mapplets, mappings, and workflows and DAC metadata.
• Experienced Informatica developing Source Objects and Target Objects including Source Dependent Extract SDE and Source Independent Load SIL mappings
• Performed preload configuration steps for BI Applications
• Use Data Warehouse Administration Console DAC to configure execution plans, manage, and run ETL routines to populate the OBAW and monitoring the results.

Environment: OBIEE 11.1.1.6.7, EbsR1213, Toad, Informatica 9.1.0, DAC 10.1.3.4.1

Confidential

BI Lead/Analyst

Responsibilities:

• Implemented end to end customized application for business.
• Gathered required information and was involved in data analysis.
• Maintained and designed complete documentations such as BRD Business requirement document issue trackers, training manuals for end users.
• Integrated multiple source system for single source of truth as Teradata.
• Implemented Financial, Procurement and Spend Analytics.
• Application designed involved in integration of Java ON Boarding screens with OBIEE along with right back functionality on application specific tables.
• Worked on incremental and full load of data through Data Warehouse Administration Console DAC and Informatica.
• Developed the Incremental ETL processes i.e., Mappings Mapplets using various Transformations and Workflows with Sessions/tasks for data extraction from E-Business suite.
• Design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management RPD .
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Developed different kinds of reports pivots, charts, tabular using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters , contextual navigation, business rules with user identity and roles within the OBIEE suite. Implemented the single sign on SSO .
• Involved in setting up AGENTS to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Implemented Security by authenticating against the LDAP and external table. Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

Environment: OBIEE 11.1.1.5, Oracle 11g/10g, TOAD, PL/SQL, Teradata, Informatica 9/8.6.1,

Oracle EBS R12 General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO.

Confidential

OBIEE Consultant

Responsibilities:

• Responsible for OBIEE 11g upgrade.
• Identified Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.

• Developed different kinds of reports pivots, charts, tabular using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.

• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.4.1/11.1.1.5, Oracle BI APPS 7.9.6.2/7.9.6.3, DAC, Informatica 9/8.6.1, XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL Loader, Oracle EBS 11i/R12 General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM ,

HR Analytics , Oracle 11g/10g, TOAD, PL/SQL

Confidential

OBIEE Consultant/Analyst

Responsibilities:

• Worked on complete Software Development Life Cycle SDLC , from gathering requirements to deployment.
• Implemented Financial Analytics, Supply chain, Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Monitored incremental and full load of data through Data Warehouse Administration Console DAC and Informatica.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Granting access to users and maintain security by using database authentication and authorization.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
• Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console DAC and Informatica.
• Involved in developing the Incremental ETL processes i.e., Mappings Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
• Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
• Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics, Procurement and Spend Analytics.

• Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Involved in complete Procure-to-pay P2P and Order-to-Cash O2C life cycle.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables AP using OBIEE.

• Worked on tools like TKPROF and Explain Plan for tuning of PL/SQL queries for better database performance.
• Resolved open issues with production system.
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents.

Environment: Oracle EBS R12 General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM , Oracle 10g, TOAD, PL/SQL, OBIEE 10.1.3.4.1/11g, Oracle BI APPS 7.9.6, DAC, Informatica 8.6.1,XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL Loader.

Confidential

OBIEE Consultant

Responsibilities:

• Identified Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.

• Developed different kinds of reports pivots, charts, tabular using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.

• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.1.3, Informatica8.1.1, DAC, Oracle 10g, SQL Developer, SQL Plus, BI Publisher 10.1.3.x, XML Publisher, Windows-XP