Summary:

• Over seven years of IT experience in complete Software development life Cycle SDLC implementation experience of Data warehouse and Business Intelligence applications using Oracle Applications, OBIEE and Informatica.
• Expertise in providing end-to-end business intelligence solutions using OBIEE.
• Extensive experience in OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, OBIEE Administration Tool, Delivers and iBots with OBIEE Applications.
• Experience in installation and configuration of OBIEE, DAC and administering permissions, privileges to users based on their groups and responsibilities.
• Strong understanding of Business Logic, Business Process flows, identification of Business opportunities.
• Extensive experience as Technical ERP Developer, Consultant in Oracle E-Business Suite Applications with expertise in General ledger GL, Account Payables AP, Account Receivables AR, Fixed Assets FA, Order Management OM, Purchasing PO, Inventory INV, Service Contracts and Payroll.
• Building of RPD application design for Physical, Logical BMM , and Presentation layers, configuration of those layers, development of Reports, Dashboards, BI Publisher, and integration to Microsoft suite of tools, testing, and deployment.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Expertise in converting and using Oracle pre-build Rpd's Finance Analytics according to business requirements.
• Strong Experience in Data Warehouse Administration Console DAC 7.9.6, 7.9.5 .
• Very good understanding on the Architecture of BI Applications and knowledge about KPIs.
• Extensively involved in end to end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Experienced in DAC to configure, monitor and schedule ETL routines.

• Expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center.
• Experience in developing various Informatica Transformations and Mappings.
• Experienced in tuning Informatica Mappings, Sessions and SQL queries for better performance.
• Worked on Informatica that provides critical integration between ERP, CRM, Metadata and Remote Data and deliver it to Data Warehouses, Operational Data Stores and Business Intelligence tools. Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports as well.
• Extensive experience working with Oracle Business Analytics Warehouse Data Model/Data Structure and creating Star Schema, Snowflake data structure for OBIEE/Siebel Analytics and Oracle BI Analytics.
• Expertise in debugging and optimizing the Oracle BI / Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Good Knowledge of database experience using Oracle 10g/9i/8i, MS SQL Server 2005/2000, TOAD, PL/SQL, SQL and SQL Loader.
• Experience in leading the team and also worked as Lead in Onsite-Offshore model.
• Excellent team player with strong analytical, communication and presentation skills.

Technical Skills:

Confidential

Oracle BI Consultant

Responsibilities:

• Interacted with the business users for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica.
• Worked in a multi user development environment
• Developed many Analytical and Operational reports using different Analytics Views Pivot Table, Chart, Column Selector, and Narrative View , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used iBots.
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Developed reports using BI Dashboard and Answers, views charts, created filters to obtain weekly sales reports and send alerts to top management.
• Managed presentation catalog groups and users settings to web group folders.
• Designed and developed the OBIEE Metadata Repository .rpd using Oracle Business Intelligence Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units Update Strategy, Filter, Router, Expression, Lookup, Aggregator for loading data into Data Warehouse.
• Performed Data Validation of data in the reports , Fixed all the errors and warnings in the repository and web catalog.
• Worked on upgrading OBIEE 10 g to 11g.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.

• Effectively managed migration of RPD and presentation catalog changes across environments through catalog manager
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics

• Upgraded the Informatica repository to Informatica 8 to 9.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: Oracle Business Intelligence EE 10g/11g, Oracle10g/11g, OBIA/BI APPS 7.9.6/7.9.5, Seibel Analytics Financials, Supply chain , Data Warehouse Administration Console DAC Informatica Power Mart 6.2.1,Windows XP.

Confidential

Oracle BI Consultant

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Performed the setting up, Installation and configuration of the complete Analytics platform.
• Analysis of existing OLTP system and Identification of required dimensions and facts from the Database
• Creation and Customization of the OBIEE Repository Physical Business and Presentation layer .
• Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• Creating KPI's Key Performance Indicators , Interactive Dashboards, Administering Oracle OBIEE Applications.
• Created new repository, customized existing metadata Repository .rpd .
• Involved in creating dashboard prompts and advance filter criteria.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Development of triggers, procedures, functions and package using PL/SQL.
• Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
• Developed strategic operational planning by integrating functional operational and financial planning using EPM.
• Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries.
• Developed iBots by calling from Dashboards/Answers by clicking single URL to send emails to Administrator.
• Created the initialization block to capture the data level and object level security information and applying the same as filters via Group session variable in Presentation Catalog.a user can access and New Id creation, Account modification of existing users, Password reset and deletion of accounts.
• Implemented various Repository variables and System variables depending up on user requirements.
• OBIEE Admin work: Security Manager - used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects tables, columns and to control over when and what data users based on LDAP Authentication type in Production and also other Authentication types External table authentication and Database in other environments.
• Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer BMM , Physical Layer and migration of the Code, Repository RPD , Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts
• BI Apps/OBIEE/Informatica/DAC/OBAW implementation of Oracle HR Analytics like Oracle HR Analytics Subject Ares, Dashboards and Oracle Financial Analytics like Financial Analytics Subject Areas, Dashboards.
• Development and conversion of Oracle BI Reports.
• Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Performed extraction, transformation, and loading ETL for data warehouses by consolidating data from heterogeneous data sources.
• Experience in performance tuning of targets, sources, mappings and sessions.

Environment: OBIEE 10.1.3x, BI Apps 7.9x, Oracle E-Business Suite 11.5.10, Release 12, XML BI Publisher, Oracle Discoverer 4i/10g, ODI, Informatica 8x, Windows XP, DAC, OBAW, OWB, Oracle10g, Toad, PL/SQL.

Confidential

Oracle BI Consultant

Responsibilities:

• Involved in Project meetings and application status calls with clients, handling technical issues.
• Extensively worked on Answers, Dashboards and Security for users and creating complex reports.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• 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.
• Involved in Merging the RPD and Web Catalog folder with OBIEE Admin tool and Catalog Manager.
• 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.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created Session Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports pivots, charts, tabular using global and local filters.
• Configured iBots to deliver Analytics content based on schedule
• Involved in creating mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Trained End Users and Pilot Users about OBIEE Tools.
• 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.
• Created sets of programs to handle mass load of work orders created by users through a flat file. This uses the Oracle SQL Loader tool combined with PL/SQL to handle the data loading and validation to the standard interface tables for BOM.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

Environment: OBIEE 10.1.3.x, Informatica 7.1.x/8.x, oracle 10g, SQL, PL/SQL, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• A number of optimization techniques are used to determine the most efficient access plan for SQL queries.
• Study and analyze the business requirements.
• Developed custom Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems.
• Adding the triggers in form level, block level and Item level.
• Development of Stored Procedures to encapsulate Business processes.
• Developed procedures, functions, packages, Conversion Programs to convert Payable Invoices and Conversion Program to load Vendor data.
• Rewriting complex SQL queries with many queries and joins using SQL compiler for better system performance.
• Produced Scripts to cleanse source data, ETL process Extract, Transform Load data with business rules, and built re-usable Mappings.
• Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans
• Developed views, functions, procedures, triggers, packages using PL/SQL SQL to transform data between source staging area to target staging area.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote SQL, PLSQL, SQL Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Optimized critical queries to eliminate Full Table scans.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and kept logs.
• Analyzing Business requirements with product management for new release cycles
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: Oracle 9i, MS Access, SQL, PL/SQL, Windows NT, SQL Plus, SQL Loader.