SUMMARY:

• Over 7 years of professional IT experience in the Installation in clustered environments, Design, Development, Administration and Maintenance of OBIEE Oracle Business Intelligence Enterprise Edition /Siebel Analytics and ETL .
• Experience in web technologies including WebLogic, Oracle Fusion Middleware, managing application servers and load balancing
• Subject matter expert for OBIEE expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse ,OBIEE RPD development, OBIEE reports and Dashboards
• Strong Experience in Data Warehouse Administration Console DAC 7.9.6/7.9.5 .
• Expert level skills in Implementation and Testing of Enterprise Data Warehouses using Informatica Power Center 9.0.1/8.x/7.x ETL tool
• Experience in testing Informatica Mappings, Sessions, Workflows, Worklets and Tasks.
• Experience in providing end-to-end business intelligence solution by dimensional modelling 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
• Good Experience with OBIEE 11.1.1.6,11.1.1.7.2 /OBIEE 10G
• Perfect in understanding Data Models Star Schema and Snow Flake Schema
• Lead the Onsite and offshore team for the development of Repository and the dashboard reports.
• Apply fixes, patches and Service Packs
• Expertise in design and implementation of security framework including Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on SSO
• Expertise in Configuring Financials, Human Resources, Marketing, Supply chain and Procurement Spend Analytics
• Expertise in Design and Development of RICE Reports, Interfaces, Conversions and Enhancements components
• Good working knowledge in Technical Documentation using AIM Methodologies MD50, MD70, CV40 AND CV70
• Extensive experience in writing, testing and implementation of the Triggers, Functions, Packages using PL/SQL.
• 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 Expertise:

Technical Skills

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Title: Sr. BIAPPS Consultant.

• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Configured LDAP authentication on OBIEE 11G using the WebLogic servers and EM.
• Provided the Dashboard access to the Users through the LDAP and setting up the security levels.
• Worked extensively on BMM Business Model and Mapping layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots/Agents queries to obtain daily and weekly reports.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• Upgradation of OBIEE 11.1.1.6 to 11.1.1.7.0 and applying patch to upgrade it to 11.1.1.7.2
• Developed Complex mappings using lookup, filter, Joiner, aggregate, Sequence generator and expression transformations.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Designed and Developed General Ledger, Payables, Receivables, profitability, Procurement and spend and supplier performance Dashboards in OBIEE.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Configured event polling cache purging method to clear the stale data
• Worked on integrating and configuring BI Publisher with OBIEE
• Monitored incremental and full load of data through Data Warehouse Administration Console DAC and Informatica.
• Monitor, maintain, and promote data quality. Proactively identify, troubleshoot, resolve and document data quality and integrity issues.
• Identified Data warehouse and staging tables, Informatica workflows/mappings and DAC tasks related to Finance data and customized Informatica mappings to load historical data.
• Worked in developing transformations and mappings using Informatica designer and processing tasks using workflow manager to move data from multiple sources into targets.
• Customized Out of the Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
• EBS Integration with the OBIEE 11.1.1.7.0 A single sign on is established for the Users from the OBIEE applications to OBIEE Analysis based on the EBS Responsibilities .
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer, Time Series function and implemented time comparison using To Date and Ago functions.
• Worked on the Materialized view to show the reports with the updated data for few of the reports Sales Quality Dispatch reports .
• Participated in designing, coordination and execution of User Acceptance Testing UAT with QA, BA and selected business users.

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

Responsibilities:

Title: Sr. BIAPPS Consultant.

• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Communicating when support for current versions will expire and plan for upgrades with management and customers. Analyze and plan the BI software upgrades and patches.
• Developed reports involving HR Analytics subject areas such as Payroll, Retention using OBIEE Answers.
• Advising on best practices for application architecture design applications and solutions, and guide development team with subject matter expertise
• Experience in testing Informatica Mappings, Sessions, Workflows, Worklets and Tasks.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Upgradation of RPD and web catalogs from 10G to 11G
• Merging the Repository merging the Command Line and migration of the RPD's from one environment to another.
• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard in OBIEE.
• Lead the Off-shore team in the development of the Dashboard reports and complex financial reports.
• Customized OBIEE Styles, Skins and Messages according to the client requirements
• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Effectively migrating webcat, Skins and Style sheets from one server to another server by using catalog manager in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Developed Customer Hierarchy to generate reports on the Region/Country/Time zone.
• Copied existing RPDs from Server into the Local machine for testing and tuning of dashboards.
• 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.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

Title: Sr. BIAPPS Consultant.

Responsibilities:

• Developing migration project plan and estimates, eliciting and managing requirements, and providing progress reports for all OBIEE migration projects
• Server space management for various log files, cache files, back up files etc.,
• Providing on-call production monitoring and support for critical Business Intelligence processes on a rotation basis.
• Creating, maintaining, and scheduling automation scripts, and maintaining responsibility for creating and updating system documentation
• Installed and Configured DAC.
• Implemented Financial Analytics, Supply chain and order management and Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System EBS to staging system SDE mappings and to the target Analytics Warehouse SIL mappings .
• Involved in installation and configuring of Financial, Order Management Supply Chain and procurement and Spend Analytics.
• Technical experience in installation and developed reports through User Interface of OBIEE 11.1.1.3.0 Suite.
• Created new and opened Answers for adhoc reporting to the End users.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables and Profitability.
• Monitored the Memory and the File System Utilization on the servers.
• Developed the Audit balance sheets reports from OBIEE dashboards.
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Did gap fit analysis to migrate reports from Discoverer to OBIEE.
• Developed the GL Daily Balanced report from OBIEE dashboards.
• Extensively worked on Shell Scripting.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked closely with Oracle Product Development team to resolves issues.

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

Confidential

Title: Sr. OBIEE/Admin Consultant

Responsibilities:

• Created MUD Multiple user Development environment by utilizing projects in OBIEE.
• Provide timely work breakdown tasks with time estimates to develop, test and implement the business intelligence functional requirements.
• Utilize monitoring software or develop Business Intelligence administration scripts. Automate and continuously improve monitoring of Business Intelligences environments for the efficiency of the team.
• Setting development standards for implementation of features. Develop, document and communicate best practices, coding standards and design templates to support business intelligence standards. Facilitate design reviews.
• Document, troubleshoot, and resolve day-to-day data issues.
• Identify, implement and test patches and upgrades and maintain up-to-date documentation of OBIEE-related configuration.
• Performed migration and merging of RPD's in OBIEE.
• Configured the Informatica Source, Lookup and Domain files.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Responsible for ETL and OBIEE Repository development for Financials and HR Analytics
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Alias and Logical tables.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Created Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Worked using Catalog manager to migrate web catalog between different instances.
• Created Pivot Tables and manipulated Initialization Blocks for report analysis.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Was part of the installation team to install OBIEE BI Apps.
• Developed Dashboard pages like Budget Vs Actual, Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
• Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
• Worked on the testing and validating the Repository in OBIEE.
• Created Dashboard prompts and advance filter criteria.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Designed and developed custom Dashboards.
• Customized existing Dunning report in Account Receivables using XML/BI Publisher.
• Created multi-layout report to hide/show columns based on the profile options of the user who is running the program.
• Customized Standard 6i reports to XML/BI publisher reports.
• Resolved open issues with the production system.
• Prepared technical document MD50, MD70 for the customizations done.

Environment: Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivables, Inventory, Purchasing, Fixed Assets, BI Apps 7.9.6, OBIEE 10.1.3.4.1/10.1.3.4/10.1..3.3/10.1..3.2, Informatica 8.6.0, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, ,SQL PLUS, SQL Loader, TOAD, Unix.

Confidential

Title: OBIEE Consultant

Responsibilities:

• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Developed Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
• Setup Multi User Development Environment MUDE in OBIEE.
• Created Dashboard prompts and advance filter criteria.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Worked on BI Publisher to create report Templates based on multiple Data sources.
• Designed, Developed and Tested Object level security at Repository level and web level Dashboard, Answer and Report level security in OBIEE.
• As part of the installation team installed OBIEE BI Apps.
• Designed and developed custom Dashboards.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Created and ran Sessions Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Worked on Service Contract interface program by using the standard API's.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG's.

Environment: OBIEE 10.1.3.3,Informatica ,Oracle Applications 11i 11.5.10 ,General Ledger, Accounts Payables, Account Receivables, Order Management, Supply Chain SCM , , BOM,WIP, Inventory, Oracle 9i, Discoverer 10g, ,Windows 2000/NT, SQL Plus, TOAD, Reports 6i ,Unix.

Confidential

Title: OBIEE Consultant

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Mainly Worked on Oracle HR and Financial analytics.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Created highly formatted reports using BI Publisher based Data Templates form different data sources.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Identified and created aggregate tables to improve query performance.
• Created Reports using different Analytics Views.
• Created Session Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges
• Extensively worked in fine-tuning of Informatica Mappings and OBIEE Repository and Dashboards.
• Created OBIEE Intelligent Dashboards Answers.
• Created dimensions in the Business model Mapping layer.
• Assigned Data level UI level security to the Users.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• 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
• 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

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

Confidential

Oracle Apps Consultant

Responsibilities:

• Implemented and tested Purchasing solution Procure to Pay P2P Integrated purchasing with payables to allow matching invoices to PO receipts 2 ways, 3 way and 4 way matching .
• Customized to modify PO Approval Hierarchy and Notification
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Developed Interface for the Standard Items of Sales Orders Import in OM.
• Defining setup option, Accounting Flex fields, set of books, security rules, recovery Journals, Budget, Budgets organizations mass budget formulae, roll up groups in General Ledger Modules.
• Developed Interfaces using PLSQL. Creating Packages, procedures and functions using PL/SQL developer.
• Used PLSQL extensively to write SQL outbound, procedures, packages, database for validations etc.
• Identified and worked with external groups/teams to resolve issues found in testing. Responsible in Production Deployment, Production Planning and Production support.
• Interacted with end user for problems faced and providing necessary technical support by fixing the tickets.

Environment: Oracle Applications 11i, AP, PO, OM, INV, Oracle8i, Forms, Reports, SQL Loader, TOAD, UNIX, Windows 2000.