Summary

• Over 7 years of Complete Life Cycle or End-to-End gathering Business Users Requirements, System Analysis, Design Data Modeling, Development, Testing implementation experience of Business intelligence and Data warehouse applications using OBIEE, Oracle Applications and Informatica.
• Very strong experience in developing OBIEE at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, OBIEE Security Setup users/groups, access / query privileges , configured OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog Objects Dashboard, Pages, Folders, Reports , scheduling iBots.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports.
• Expertise in implementing Security models for Dashboards, Row level, object Level, Role Level, Dashboard Level.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers iBots .
• Experience in Upgrading OBIEE environments.
• Configured DAC Data Warehouse Administration Console for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• 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.
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Extensively involved in end to end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics.
• Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Very strong in Extraction, Transformation and Loading ETL of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets and various Tasks.
• Experience in development customization of Oracle BI Publisher XML Publisher , BI Discoverer Reports.
• Experience in writing, testing and implementing SQL/T-SQL/PL/SQL, Stored Procedures, Triggers and Functions.
• Experience in writing, maintaining and executing Test cases, Test plans, and Test scripts and generating software defect reports.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Project management experience, project proposals, presentation and documentation
• Expertise in business planning, analysis software designing skills with ability to transform business users' input into software requirements and specifications.
• Excellent Written and Verbal Skills Results oriented and Self-Starter looking for challenges Ability to rapidly learn and apply new technologies and improve processes Self-motivated and results-oriented with solid work ethic.

Technical skills:

Professional Experience:

Confidential

Role : OBIEE and BI Apps Consultant

• Implemented Financials, Supply Chain, Procurement and Spend Analytics.
• Interacted with SME's, Business Analysts and Users for gathering and analyzing the Business Reports Requirements and did the necessary GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for seamless integration with the data warehouse.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Implemented Financial Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• 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.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked using Catalog Manager to migrate Web Catalog among Instances.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• 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.
• Using Universal adapters created new folders and mappings in Informatica to bring the data from other source systems.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed and debugged many intelligence Dashboards using different Analytics Views Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View , Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Customized Out of the Box Dashboard pages like Budget vs Actual, GL Balance, Cash Flow, AP Balance, Payments Due, Invoice Details, Supplier Report, AR balance, Customer Report, AR Transactions in Financial Analytics.
• 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.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Trouble shooting the issues related to repository models and report development.
• Developed many complex Full/Incremental Informatica Objects Workflows / Sessions, Mappings/Mapplets with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customization and enhancement of standard Oracle applications reports in Account Payables module like Invoice Aging Report, Invoice Validation report, Cash requirement report using Oracle BI Publisher.
• Developed process and business rules around setup of new users Logins, Responsibilities .
• Defined Dashboards, Filters, and Prompts as per user's requirements.
• Created new requests and opened Answers for ad hoc reporting to the End users.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle EBS R12.1.3 General Ledger GL , Account Payables AP , Accounts Receivable AR , Inventory INV , Purchase Order PO , OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.1, DAC 11g, Toad

Confidential

Role : OBIEE and BI Apps Consultant

• Implemented Financials, Supply Chain Order management.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Preparing Design Specification documents based on functional requirements and also prepared the Technical Design Documents.
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse OLAP system.
• Migrated Analytics RPD and Web catalog from one environment to another.
• Implemented the single sign on SSO .
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• 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.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Exclusively Involved in Unit Testing Regression Testing.
• Adding new Tables, Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
• Configuring the Analytics repository RPD and implementing the security to authenticate and authorize Oracle EBS users.

Environment: Oracle Applications R12, Accounts Receivable, Inventory, Order Management, Oracle Purchasing Oracle 11g, OBIEE 11.1.1.6, BI Apps 7.9.6.3, Informatica 9.1.0, DAC 11.1.6.4, XML/BI Publisher , Repots 10g, SQL PLUS, SQL Loader, TOAD

Confidential

Role : OBIEE Consultant

• Implemented Financials, Supply Chain, Procurement Spend Analytics, Material Management, logistics, Production Orders, Pricing, Viziya analytics, Inventory Control, General Ledger, Material Transactions, and Viziya Maintenance Score Cards.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Involved in installation and configuration of OBIEE, Informatica, DAC and upgrade from 10g to 11g, BI Publisher and Informatica from 8x to 9x
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse OLAP system.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
• Implemented the single sign on SSO .
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• 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.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Exclusively Involved in Unit Testing, Peer Testing Regression Testing.
• Adding new Tables, Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
• Configuring the Analytics repository RPD and implementing the security to authenticate and authorize Oracle EBS users.

Environment: Oracle Applications R11.5.10, Service Requests, Service Contracts, Install Base, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Logistics, Material Management, Production Order, Pricing, Oracle 10g, OBIEE 10.1.3.4.1 , Informatica 8.6.1, DAC , XML/BI Publisher, Discoverer 10g, Repots10g, SQL PLUS, SQL Loader, TOAD

Confidential

Role : OBIEE Developer

• Created numerous executive level reports 'Dashboards' were generated to provide insight into the sales/marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Involved in modifications of physical, business and presentation layers of metadata repository using BI Analytics Administration Tool
• Developed custom reports/Ad-hoc queries using BI Answers and assigned them to application specific dashboards
• Developed different kinds of Reports pivots, charts, tabular using Global and Local Filters
• Created proactive agents iBots and Interactive Dashboards to alert the Marketing team about business changes
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator ,Oracle Enterprise
• Improved Database performance by optimizing back end queries, PL/SQL tuning and implementing performance improvements by analyzing indexes and partitioning tables

Environment: OBIEE 10g, Oracle 9i, SQL Server 2003, SQL, PL/SQL, TOAD, Unix, XML, HTML, Informatica 8.1

Confidential

Role : OBIEE Developer

• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd .
• Worked with business analyst and users Financial Advisors or FAs to gather analytics requirements and created the business model using star schemas.
• Worked with System Engineering team to design Facts, Dimensions and Hierarchies of the business model.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Import/create tables and add/change physical joins/keys.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Creating global filters, complex queries, prompts, reports charts, tables, graphs in Answers.
• Setup and administered Usage Tracking using the direct insert process.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Configured repository and session variables to get dynamic reports and dashboards.
• Good working knowledge of Trader, Broker, and Mutual fund tables.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data into data warehouse.
• Analyzed data processing modules and identified areas of enhancement and improvements. Maintained the ERP system in order to ensure it provides the company with proper business solutions and accurate results.
• Handled improvements of ERP systems as well as system upgrades and software updates.
• Conceptualized reporting systems interfaces to be more suitable for easy administrative controls.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8, Informatica 8.1, DAC 7.8.5, OBI Publisher 10.1.3.4, SQL Server 2005, Oracle 10GR2, Windows XP.

Confidential

Role : Oracle Apps Developer

• Designed and developed custom packages, triggers and procedures.
• Provided user support and involved in development, design meetings.
• Involved in database design, development and testing phases.
• Designed and developed forms and reports using Forms 6i and reports 6i.
• Provided various validations such as purging previous data, checking for duplicate files, validating input data, updating invalid data, formatting input data and transferring data from custom staging table s to interface table s such as GL INTERFACE.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing into Account Receivables.
• Experience in importing PO Headers, PO Lines from legacy system to Oracle Purchasing through Purchase Order Open Interface PO .
• Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs.
• Experience in customization of XML Publisher reports for Oracle Purchasing.
• Used SQL Loader and UTL FILE packages for Inbound and Outbound interfaces
• Developed two main reports in Oracle Purchasing i.e., Purchase Order report and Requisition Report
• Wrote PL/SQL validation scripts.
• Customized PL/SQL packages and wrote database procedures.
• Created database objects like tables, views and triggers.
• Prepared program documentation.
• Carried out unit and integration testing.

Environment: ORACLE 9i, Forms 6i, Report 6i and Windows XP, UNIX.