• 7 years of experience in Oracle Business Intelligence Applications OBIA / BIApps with expertise in gathering user requirements, designing, developing and supporting.
• Exceptional Background in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, HR and Project analytics.
• Expertise in utilizing ETL tools including Informatica and RDBM systems like Oracle and Teradata.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformation Developer, Mapplet and Mapping Designer.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC Software Development Life Cycle .
• Strong experience in developing and customizing OBIEE and BI Publisher Reports.
• Experience in Project methodology, SDLC, DW, BI infrastructure and architecture using OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, dimensional modelling using Star schema in Data warehouse life cycle.
• Installed and Configured DAC Data Warehouse Administration Console to manage ETL process for OBIA Analytics.
• Hands on experience in installation, administration and maintenance of OBIEE, OBI Applications, DAC and Informatica.
• Experience in dimensional modeling, designing data marts, star and snowflake schemas.
• Hands-on experience in Performance tuning of Informatica ETL and OBIEE Queries.
• Experience in gathering requirements, Proof of concept, gap analysis, design, development, Testing and Implementation of the OBIEE/ETL/Data Warehouse projects.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes and Shell scripting.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• 24/7 Support and effectively to production development issues and taking responsibility for seeing those issues through resolution.
• Have strong interpersonal skills along with proficient written and verbal skills. Overall strength lies in precise translation of business requirements into technical documents. Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Professional Experience:

Responsibilities:

• Installed, configured and extended financial, procurement and spend, HR analytics.
• Worked on complete Software Development Life Cycle SDLC , from gathering requirements to deployment.
• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Implemented Financial Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in analyses calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Created security groups in repository, web groups in presentation services and configured privileges for security groups in Administration.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Documented the Requirements and implemented a Design Solution for the BI Architecture.
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers.
• Part of STEP ERP project by implementing Oracle BI Apps using ODI and OBIEE application tools.
• Granting access to users and maintain security by using database authentication and authorization.
• Implemented Type-II Slowly Changing Dimension SCD logic in OBIEE environment.
• Performed OBIEE Admin works like new ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Provided reports in Financials by gathering business requirements from Business users.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables AP using XML/BI Publisher.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.
• Automated process of migrating Data Definitions and Templates from instance to instance.
• Resolved open issues with production system.
• Prepared technical documents MD 70, TE 20 for customized work.
• Implemented object and Data security in OBIEE.

Environment: OBIEE11g, OBIA/BI APPS 7.9.6.4, DAC 11g, Informatica Power Center 9.0.1, XML/BI Publisher 11g, TOAD, SQL, PLSQL.

Responsibilities:

• Installed, Configured and extended Supply Chain, Order management and project analytics.
• Analyze Design, and Develop OBIEE Metadata repository RPD that consists of
• 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.
• Performed the Setup, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Worked on the testing and validating the Repository in OBIEE.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Developed process and business rules around setup of new users Logins, Responsibilities .
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built reports using Analyses including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Created new requests and opened Analyses for ad hoc reporting to the End users.
• Developed and debugged many intelligence Dashboards using different Analytics Views Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View and Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Developed Dashboard like Recycling Report, Shipments Bookings, Invoices detail, Orders detail, Global Price and Enterprise Order Number in Order Management and Supply Chain.
• Customized Out Of Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics.
• Trouble shooting the issues related to repository models and report development.
• Verified and tested ETL mappings using Informatica Power Center Designer.
• 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.
• Used the Totals/Subtotals/Group/Sort features of Oracle BI Publisher to make data intense operations happen at the template level.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Receivables, Account Payables, Supply Chain SCM , BI Apps 7.9.6.2, OBIEE 10.1.3.4.1, Oracle 11g/10g, Informatica 8.6, DAC 10.1.3.4.1, Oracle BI Publisher, PL/SQL, SQL, TOAD.

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Install, configure, and administer the OBIEE platform.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Created Session Repository Variables to achieve desired functionality.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps to configure and created repository .rpd and prepared a detail design document.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Used SQL Loader for Data Conversions and to load the data from flat files into Oracle tables.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Analyses.
• Customized Dashboard pages like AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Developed Mappings and Workflows using various Transformations Update Strategy, Router, Expression, and Aggregator for extracting sales data.
• Developed balance sheet, profit and loss statement using BI Publisher.
• Scheduled Workflows and Session tasks comprising of different mappings in order to load data into target database and fine-tuning ETL Mappings and Sessions. .
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1, Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad, Linux.

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions in the BMM Layer of RPD.
• Verified and tested ETL mappings using Informatica Power Center Designer.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE.
• Created Aliases and defined Role-Playing Dimensions.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Designed Metadata repository Physical layer, Business Model Mapping layer and Presentation Layer.
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• 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.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Customized Dashboard pages like Marketing, Field Sales, Marketing Service etc, which have their own drilldown, and Navigation 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.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Customized Employee listing Report, Invoices on Hold report and Suppliers report as per the business requirements using Oracle BI Publisher.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1, Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad, Linux.

Responsibilities:

• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version 11.5.8 to 11.5.10.
• Developed Custom Packages, Procedures for validating the Summary balances and Detail Transactions from the legacy system, imported them into interface table and submitted the Journal Import program to populate base tables.
• Created PL/SQL Functions, Procedures, Packages to support reports.
• Implemented Oracle GL, INV modules to meet Business requirements of the client.
• Worked on GL Conversion to extract data from legacy system to GL base tables.
• Transferred GL Account Balances from legacy system.
• Customized the GL Account Analysis Report based on the Clients requirement.
• Involved in designing various reports like Inactive items report, Bill of materials BOM item listing reports, GL detail report using Oracle Reports 10g.
• Imported ITEMS from legacy system to Oracle Inventory by using the standard item import program through a custom package that validates individual records.
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Designed and Developed the custom package to validate the legacy item Categories and assigned the categories to converted items using standard Item Category Assignment import program.
• Developed a stored procedure to cancel the PO LINE by calling a public API called PO DOCUMENT CONTROL PUB.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Oracle Reports 10g.
• Developed PL/SQL procedures, functions and packages.
• Created the materialized views and also created the partitioning tables.
• Worked on database triggers for automatically updating the tables.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Created various lookups, Value sets, user defined tables.
• Performed the unit test cases for all the identified impacted items and documenting the same for user acceptance test.

Environment: Oracle Applications 11i, GL, AR, AP, PO, INV, OM, Shipping, Oracle 10g, Forms 10g, Reports 10g, Workflow, XML/BI Publisher, TOAD and Forms Data Loader