• 7 years of experience in Oracle Business Intelligence Applications OBIA /BIApps with expertise in gathering user requirements, designing, developing and supporting.
• 2 years of experience in Oracle Data Integrator with expertise in building data extraction routines for Data Warehousing and Code tuning.
• Exceptional Background in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, HR and Project analytics.
• Experience in creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Expertise in utilizing ETL tools including Oracle Data Integrator, Informatica and RDBM systems like Oracle and Teradata.
• Extensively experienced in development of ELT and ETL Interfaces/Mappings in Oracle Data Integrator .
• 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/ODI 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.
• Interacted with business analysts for better understanding of individual subject areas and modified specifications to reflect accurate user requirements.
• Configured and setup ODI, master repository, work repository, Models, sources and Knowledge Modules.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW .
• Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Essbase, Relational Database Management servers including Oracle RDBMS, SQL Server, and IBM DB2 and flat files including CSV, Excel, XML file formats .
• Worked on Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Responsible for Metadata Administration, managed Data models and reverse engineering.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
• Part of STEP ERP project by implementing Oracle BI Apps using ODI and OBIEE application tools .
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Maintained security by assigning permissions to reports and dashboards based on users and groups.
• Performance tuning in OBIEE repository level and reporting level.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Created different types of Customized Reports Drilldown, Aggregation for Sales and Product to meet client requirements.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger GL .
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Implemented LDAP authentication and configured application roles for authorization.

Environment: ODI 11g, OBIEE 11.1.1.7, OBIA/BI APPS 11g Financials and P2P , Oracle 11g, TOAD, SQL, PLSQL.

Responsibilities:

• Installed, Configured and extended Supply Chain, Order management and project 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.
• 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:.

• Created new requests and opened Analyses for ad hoc reporting to the End users.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Worked on the testing and validating the Repository in OBIEE.
• Performed the Setup, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• 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.
• Analyze Design, and Develop OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• 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 .
• Built reports using Analyses including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• 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.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• 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:

• 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