SUMMARY

• 8 years of deep hands on experience as Sr. OBI Apps developer in configuring both Informatica/DAC and OBIEE for different modules like Financial,Supply Chain and Order Management
• Deep expertise in developing OBIEE repository in OBIEE 11g, OBIEE 10, Oracle BI Apps, Informatica Power Centre.
• Strong understanding of OLAP, BI Architecture, Business Intelligence and Data Warehousing Concepts
• Worked extensively with Oracle Business Intelligence Applications that have completely pre - build BI solutions.
• Strong knowledge on OBIEE Infrastructure, Answers, Dashboards and Reports, Data analysis, Data warehousing and ETL techniques, PL/SQL scripts.
• Experience in setting up security and architecture in 11g by using weblogic admin console and enterprise manager.
• In depth knowledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases which includes Requirements Analysis, Design, Development and Testing.
• Experience in configuring interactive dashboards with drill-down and drill-through capabilities, Guided Navigation, Narrative Views, Master-Detail reports, Columns Selector, View Selector etc.
• Expertise in Cache Management, Performance tuning at report level and database level.
• Expertise in Extraction, Transformation and Loading (ETL) of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets and various Tasks.
• Configured DAC (Data Warehouse Administration Console) for Creating Execution plans, Metadata management and monitoring the Informatica ETL Process.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Experience in setting up a Multi-User Development Environment (MUDE) and using OBIEE Answers to run queries to test and validate the repository.
• Interacted with analysts and business users for gathering the requirements for business requirements and performed the necessary GAP analysis, translated them in to technical design documents and closely worked with the team members and made recommendations to close the GAP.
• Developed Solution Designs and delivered to Development team after reviewing the solutions with Business.
• Proficient in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBIEE.
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, etc.)
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.

TECHNICAL SKILLS

BI Tools: OBIEE 11g/10g, OBIA/BI APPS 7.9.6x/7.9.5, OBIA 11.1.1.8,Data warehouse Administration Console (DAC) 11g/10g

ETL/Data Modeling tools: Informatica 9.x/8.x/7.x, ODI 11g, ODI 12C

Oracle Apps: Oracle E-Business Suite R12/11i (Order Management, Inventory, Purchase OrderGeneral Ledger, Account Receivables, Account Payables, Bill of MaterialWork in Process)

Database: Oracle 11g/10g/9i/8i, MS Access, Teradata, MS SQL Server 2000/2005

Operating Systems: Windows 7/NT/2000/XP MS-DOS, LINUX

Tools: TOAD, SQL*Plus, SQL Developer

Languages: SQL, PL/SQL, C, C++, JDBC, JSP, XML and PERL

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Sr. OBIEE / OBIA Developer

Responsibilities:

• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Performed End-to-End development (mappings, data sources, business rules/logic, .rpd, subject areas, reports/dashboards and administration)
• Worked on OBIEE Security, Performance Tuning, Report Enhancements and Views.
• Worked extensively on various Cache Management techniques to increase the performance of the reports.
• Designed and developed Custom Mappings and Workflows in ODI to bring the data from other data source systems.
• Performance tuned the ODI interface.
• Created logical and physical schemas for corresponding data servers in Data warehouse with the help of ODI Topology Manager.
• Used ODI commands like ODI File Move, ODI File Append, and ODI File Copy.
• Developed custom mappings and extended the existing out of the box (OOTB) mappings in ODI to add additional attributes to the warehouse tables.
• Created various session and repository variables and initialized them in the Initialization blocks to change metadata dynamically as the environment changes.
• Customized and extended dimension tables like W PARTY D and W SUPPLIER ACCOUNT D. Added new columns to these tables as per the requirement.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load toOracle Business Analytics Data Warehouse OBAW.
• Performance tuningof ODI ETL and OBIEE Queries.
• Customized and extended fact tables like W PROJ FORECAST F and W AR XACT F.
• Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Environment: Oracle EBS R12.1.3, OBIA/BI APPS 11.1.1.8, BI Publisher, OBIEE 11G/12C, ODI 12C/11g, SQL Developer, Toad

Confidential, Boston, MA

Sr. OBIEE / OBIA Developer

Responsibilities:

• Worked on BI Procurement and Spend Analytics 7.9.6.3.
• Worked extensively on Answers to create custom reports as per the business requirement.
• Developed custom mappings and extended the existing out of the box (OOTB) mappings in informatica to add additional attributes to the warehouse tables.
• Involved in creation of complete new folders and mappings utilizing the universal adapters to bring in data from third party source systems.
• Worked with EBS teams to co-ordinate and validate the data sourcing chances to OBIEE as part of EBS upgrade.
• Worked on Spend Classification using Oracle Spend Classifier.
• Involved in development of new training sets with transactions having no Purchase Orders and made sure these transactions were classified in accordance with the EBS categories assigned for PO Suppliers.
• Involved in running and monitoring monthly incremental loads to Spend Data Warehouse to pull the data from non-Oracle source systems (SUN Systems, EMEA).
• Developed custom templates for the invoice reports by calling sub templates inXML/BIPublisher.
• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• Conducted UAT sessions with end users.
• Involved in unit testing, integration testing of reports generated by OBIEE.
• Created test plans, test cases and involved in unit and integration testing.
• Customized the OOTB procurement reports and also created custom reports integrating the non-oracle systems data to the reports as per the business requirement.
• Extended the PMT FACT table to add additional attributes like IQN fields from R11 source system as per the reporting needs by the business.
• Extended W AP INV DIST F table to add additional attributes from R12 source system as per the reporting needs.
• Good knowledge on P2P cycle.
• Good Knowledge on EBS procurement source tables.

Environment: Oracle EBS 12.1.3 (Advance Procurement Suite), BI Apps 7.9.6.3, Informatica 9.1, DAC 11G, Oracle 11G.

Confidential, Deerfield, IL

Sr. OBIEE / OBIA Developer

Responsibilities:

• Involved in set up, installation and configuration of BIAPPS 11.1.1.8.
• Worked with Financial Analytics and Project Analytics.
• Designed and developed tech design documents as per the requirements gathered.
• Customized out of the box Repository (RPD) to work with other ERP systems and pulling new physical tables to physical layer of RPD, joining them with dimensional tables, developing hierarchy and presenting them to presentation layer.
• Monitoring Incremental and full loads of data through BI Configuration manager and ODI studio.
• Made necessary configuration changes in BIACM for Project Analytics and ran full load.
• Involved in migrating the web catalog between different environments using the catalog manager.
• Customized and extended dimension tables like W PARTY D and W SUPPLIER ACCOUNT D. Added new columns to these tables as per the requirement.
• Customized and extended fact tables like W AP INVOICE DIST F and W AP XACT F.
• Customized and extended Project Fact tables like W PROJECT EXP LINE F.
• Developed Unit and System test plans participated in resolution of bugs in OBIEE suite.
• Customized existing OOTB reports as per the client requirement and also developed various custom AP and Project reports as per the client requirement.
• Involved in development of test scenarios and test cases and tested the reports for performance.
• Performance tuning of the reports using Load Runner tool.
• Configured interactive dashboards with drill-down and drill-through capabilities, guided navigation, narrative views, master-drill reports, column selector, view selector etc.
• Worked closely with the production support team to resolve application and data issues.

Environment: Oracle EBS R12.1.1 (General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), BI Apps 11.1.1.8, ODI 11g.

Confidential, Park Ridge, NJ

OBIA/OBIEE SENIOR CONSULATNT

Responsibilities:

• Involved in the setup, installation, and configuration of complete Analytics platform environment for OBIEE, informatica, DAC, and the required connectivity for seamless integration with data warehouse.
• Implemented financial analytics, procurement and spend analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Extracted the data from source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Developed custom mappings for a third data source and integrated it with the existing analytic warehouse.
• Interacted with analysts and business users for gathering the requirements for business requirements and performed the necessary GAP analysis, translated them in to technical design documents and closely worked with the team members and made recommendations to close the GAP.
• Involved in migrating the web catalog between the instances using the catalog manager.
• Integrated OBIEE with EBS using Single Sign On (SSO).
• Developed 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.
• Customized Out of the Box Dashboard pages like Budget vs Actual, GL Balance, Cash Flow, AP Balance, Payments Due, Invoice Details, Supplier Reports, 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.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.

Environment: Oracle EBS R12.1.1 (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.

Confidential, Hoboken, NJ

OBIA/OBIEE SENIOR CONSULATNT

Responsibilities:

• Developed Solution Designs and delivered to Development team after reviewing the solutions with Business.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the Data Warehouse.
• Implemented and Configured the Domain Value Lookup files for ETL interfaces related to HR analytics.
• Implemented HR Analytics (Proactive intelligence, Compensation Analytics, Operational Analytics). Integrated data from HR, Finance and other enterprise systems and transformed data using Informatica (ETL).
• Expertise working with Oracle HR Analytics Dashboards.
• Expertise working with Oracle HR Analytics Subject Areas likes absence, compensation, human resource performance.
• Designed and developed custom mappings and Workflows in Informatica to bring the data from other data source systems and integrated using Universal Adapters in DAC.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to data warehouse (OLAP) system.
• Maintaining user security in shared services like creating and deleting groups/users.
• Built the physical layer, BMM layer and the presentation layer of a repository by using star and snowflake schemas.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.

Environment: Oracle EBS R12.1.1, OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.1, DAC 11g.

Confidential

Siebel Analytics Developer/Informatica Developer

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server 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.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Migrated Siebel repository (.rpd) database from Dev to UAT to Production environments
• Implemented security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in Answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Configured RPD to use the LDAP authentication.
• Used ETL Processes to accommodate changes in the source systems and new requirements.
• Created and maintained metadata and ETL documentation that supports business rules and detailed source to target data mappings.

Environment: Siebel Analytics 7.8.4, Oracle 9i, Windows, Informatics 5.x/6.x.