OBIEE/OBIA DevelopeR

• Implemented Financial Analytics, Procurement and Spend Analytics integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Customization and validation of all Dashboards: General Ledger, Payables, Procurement and Spend, Supply Chain and Project Analytics dashboards against Oracle EBS Source System.
• 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.
• 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.
• Modified Out of the Box metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.
• Built repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
• Created reports using Logical Dimensions with Level-Based Hierarchies, ragged and skipped-level hierarchies.
• Created scripts to schedule the jobs database level in order to analyze the run time of long running SQL queries.
• Participated in designing, coordination and execution of User Acceptance Testing UAT with QA, BA and selected business users.

Environment:

Oracle Business Intelligence 11.1.1.7, Oracle 11g, OBIA 7.9.6.4, DAC 11g, Informatica Power Center 9.5 Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor

OBIEE/ETL DevelopeR

• Involved in business requirements gathering and translated the requirements into technical requirements.
• Configured Oracle BI Applications Informatica/ETL, DAC and OBIEE/RPD/Reports/Dashboards on distributed environment and implemented oracle out of the box prebuilt analytics.
• Conversion of custom oracle discoverer reports in BI environment and working with BI-XML Publisher reports for Purchase Orders and configured Data Bursting to email print.
• Responsible for all activities related to the development, implementation, administration and support of ETL Informatica DAC processes including customization of Prebuilt OOB Applications.
• Customized and developed OBIEE Analytics Consumer goods RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Developed Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters using Oracle BI Presentation Services.
• Setup Multi User Development Environment MUDE in OBIEE/OBIA.
• Created new requests and opened analytics for ad-hoc reporting to the End users
• Worked closely with the Informatica Admin Console to point the repository to the different environments in course of testing.
• Used Informatica Mapping Designer to customize pre-built mappings using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new/customized Informatica mappings.
• Worked with the schedules to accommodate the data re-alignment of customers and accounts.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: OBIEE 11g, Oracle BI Apps 7.9.6.3, WebLogic Server, Oracle 11g/10g, Windows 2008 Server, Informatica Power Center 9.1, Toad, XML/BI Publisher

OBIEE/OBIA DevelopeR

• Validate the OOTB Dashboard Reports Financial Analytics 7.9.6 and provide solutions for the related issues.
• Implement the Drill through solution to OBIA Warehouse database tables from Essbase cubes using Essbase Integration Services EIS and Excel add-in.
• Create new mappings and transformations to load Essbase cubes with aggregated data from EBS and warehouse tables.
• Validate the tables data being used to populate the various warehouse tables and solve the related issues.
• Import data from Hyperion Essbase cubes into the Oracle database using DIM- Informatica as the ETL tool after creating the required mappings using Informatica Designer Workflow Manager.
• Create new mappings in Informatica as per the requirements integrate the tasks in the DAC update the Execution Plan accordingly.
• Load data into Essbase applications/cubes from the DW/EBS as per the requirements.
• Create new Source Container/Execution Plan for the ETL customizations.
• Import the new tables / tasks into DAC, allocate them to the Subject Areas and ensure the new tasks are working properly.

Environment: OBIEE 10.1.3.4.1, OBIA Financial Analytics 7.9.6, Oracle eBusiness Suite, Oracle DB, SQL Developer, Hyperion Essbase, DIM Informatica, DAC

OBIEE/ETL DevelopeR

• Configured DAC Data warehouse Administration Console for running of ETL process.
• Extracted data from various ERP systems like Oracle EBS and People Soft.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Implemented HR Analytics Proactive intelligence, Compensation Analytics, Operational Analytics .
• Integrated data from HR, Finance and other enterprise systems and transformed data using Informatica ETL .
• Developed HR intelligence Dashboards, used KPI's that provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Implemented comprehensive security functionality by creating users web groups, setting up LDAP ADSI authentication and associating catalog objects and Web modules with the created users and groups.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Developed many incremental ETL using Informatica mappings Oracle PL/SQL procedures for loading into OLAP DB'S from multiple data sources that includes AP, AR.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

Environment: OBIEE 10g, Informatica Power Center 8.1, DAC 10g, Oracle 10g, DB2, Erwin, PL/SQL, OBI Apps 7.9.6, UNIX Shell Scripting, Toad, LINUX

Oracle apps developer

• Worked on Cycles such as Order to Cash O2C and Procure to Pay P2P .
• Worked on Suppliers, Supplier Sites Conversion and Invoices for the players using AP Invoice Interface.
• Involved in AR Lockbox Interface to import receipts into Oracle Applications Account Receivables.
• Modified Service Contract Forms using Forms builder.
• Enhancements include the existing functionality of Forms, Reports, Interfaces, Workflow and XML/BI Publisher Reports.
• Developed Forecast Project Revenue Reports by using XML/BI Publisher.
• Developed Traveler Reports and also implemented BAR codes using XML/BI Publisher.
• Worked on XML Bursting program and customized Standard PO Output for Communication XML Reports.
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location.
• Used performance-tuning methods to increase the performance of the Oracle database.
• Wrote a standalone queries using PL/SQL block to trace the performance issue in a large code file to increase performance.
• Provide support and resolution to helpdesk tickets.
• Preparation of technical specifications from the functional specifications received from functional team like CV60, MD 50, and MD70 using AIM.

Environment: Oracle Applications R12 - OM, INV, AR, AP, GL, UNIX Shell Scripting, Oracle Forms 10g, Reports10g, XML/BI Publisher, SQL, PL/SQL

Oracle apps developer

• Worked on Cycles such as Order to Cash O2C and Procure to Pay P2P .
• Worked with AP Invoice Interface to import invoices into Oracle applications from external systems into Oracle Applications.
• Developed Auto Lockbox Receipt Interface Program to automate the receipt processing, loaded the data into AR PAYMENTS INTERFACE ALL, and validated and imported the data into AR base tables.
• Used AR TCA APIs to convert customer information into Oracle and update the existing customer information.
• Created AR customer import to move legacy customer information into Oracle AR.
• Created PO Standard Purchase Orders Import program to populate data into PO headers, PO lines into R12.
• Identifying the defects and issues raised in SIT and providing solutions to functional team and providing logic and code fix required to development team.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.

Environment: Oracle Applications R12 - AR, OM, PO, AP, GL, Oracle 9i, Forms 6i, Discoverer 4i, Workflow Builder, SQL Loader.