Summary

• Over Nine years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 11g/10g/9i/8i, Informatica power center 8.x/7.x/6.x, Oracle business Intelligence OBIEE which include over 6 years of experience in Oracle business Intelligence OBIEE Reporting.
• Good experience as an Oracle Applications E-Business Suite consultant, developer with expertise in General Ledger, Account Payables, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Install Base, Service Contracts and System Administrator.
• Experience in Business Intelligence and Transactional applications, Design andImplementation of DataWarehouse/Data Mart, Gathering Business User Requirements, SystemAnalysis, Design and Data Modeling.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flakeSchemas using Ralph Kimball and Bill Inmon Methodology.
• Strong experience developing OBIEE Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges , configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages,Folders, Reports and scheduling iBots.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on SSO .
• Experience in OBIEE/BI Apps OBIA with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level
• Experience creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE best practices.
• Expertise configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup groups, access/query privileges , metadata objects and web catalog objects Dashboard, Pages, Folders, Reports .
• Expertise implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse ,OBIEE RPD development, OBIEE reports and Dashboards.
• Experience in modules like OM, Advance Pricing, AR, TCA, EB-Tax and Warehouse Management System
• Solid understanding of ETL tools Informatica , Oracle pre-built BI Apps, experience in building ETL maps, custom schema, custom reports and custom dash boards on OBIEE platform
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Expertise in DataWarehouse Administration Console DAC to configure, monitor and schedule ETL.
• Expertise in Oracle OLAP to produce analytic measures, including time-series calculations and financial models
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Strong experience in developing and customizing Reports using OBIEE 11.1.1.7.1, 11.1.1.6,11.1.1.5, 10.1.3.4.2,10.1.3.4.1/10.1.3.4.0/10.1.3.3/10.1.3.2, Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i ,BI Publisher 5.6.3/5.6.2.
• Extensively worked on PL/SQL and Informatica Power Center 9.x/8.x/7.x.
• Extensively worked on Informatica Mappings using corresponding Source,Targets and Transformations like Source Qualifier, Sequence Generator,Filter,Router,Joiner, Lookup, Expression,Update Strategy, Aggregator.

Professional Experience

Confidential

Sr OBIEE/OBIA Developer

• Involved in discussions with business users for gathering the requirements.
• Implemented Human Resources HR Analytics .
• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd .
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects.
• Developed Informatica mappings and mapplets to build key using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Union, Expressions, and Aggregator for loading the data into data warehouse.
• Created sessions and workflows in Workflow Manager.
• Customized Dashboard pages including:Benefits, Human resources,Helpdesk,Statutory and Talent Management.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and implemented custom business intelligence solutions Dashboards/Reports
• Created groups in the repository and added users to the groups and granted privileges
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan to configure, monitor and schedule ETL routines.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica WorkFlow Monitor.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Executed the SQL queries using SQL Developer.
• Created Presentation catalogs, and Folders in Presentation Layer
• Involved in Unit Testing ,System Integration testing and Regression Testing .

Environment: OBIEE 11.1.1.7.1, BI Apps 7.9.6.3, SQL Developer, Informatica Power Center 9.0.1,Oracle 11g, DAC 10.1.3.4.1, ,Windows 2000/XP

Confidential

Sr OBIEE Developer

• Involved in discussions with business users for gathering the requirements.
• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd .
• 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 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.
• 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.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• 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.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Designed and implemented custom business intelligence solutions Dashboards/Reports using the BI Applications Analytics platform.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Involved in developing reports using BI Publisher using data model and template.
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and to configure, monitor and schedule ETL routines.
• Worked on creating and tuning of mappings using different transformations in Informatica to extract
• Involved in installation and configuration of OBIEE 11.1.1.6.

Environment: OBIEE 11.1.1.6, BI Apps 7.9.6, SQL, TOAD,Informatica Power Center 8.6.1,BI Publisher 11.1.1.6,Oracle 10g, DAC 10.1.3.4.1, Linux,Windows 2000/XP

Confidential

Sr OBIEE/ OBIA BI APPS Consultant

• Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and implemented custom business intelligence solutions Dashboards/Reports using the BI Applications Analytics platform.
• Configured charts, pivot table views, gauge views and filters in user interface.
• Configured global filters, dashboards and page prompts in OBI Web.
• Modified presentation layer filters and attributes to match user requirements.
• Used the Security settings in Oracle BI Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimension hierarchies to achieve the drill down functionality.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Managed security privileges for each subject area and dashboards.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and to configure, monitor and schedule ETL routines.
• Used Informatica for data extraction, mapping and conversion using Informatica Power Center.
• Extensively worked in fine-tuning of Informatica mappings.
• Created mappings using different Transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.
• Created sessions, tasks and workflows etc. in Workflow Manager.
• Worked with the Testing team to resolve, fixing and testing problems found during the systems integration test, UAT phases.
• Implemented Human Resources HR Analytics and Procurement and Spend Analytics.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Involved in upgrage from OBIEE 10 G to 11 G.
• Performed installation and configuration of OBIEE 10.1.3.4.2/11.1.1.5, Informatica 8.6.1 and DAC 10.1.3.4.1.
• Responsible for Query Tuning to enhance the performance of reports and Dashboards.

Environment:Oracle Applications 11i/R12, BI Apps 7.9.6,OBIEE 10.1.3.4.2/11.1.1.5, SQL,SQL PLUS,TOAD,Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1,Java, Linux,Windows 2000/XP

Confidential

Sr OBIEE/ OBIA BI APPS Consultant

• 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
• Created custom reports, PL/SQL packages, request sets, menus and tables.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in creating dashboard prompts and advance filter criteria.
• Involved in developing reports in Answers and embedding them in Dashboards according to the requirements.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Designed and developed Dashboards according to client requirement in OBIEE.
• Performed Data Validation of data in the reports.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Executed the SQL queries using SQL Developer.
• Developed Presentation catalogs, and Folders in Presentation Layer
• Involved in Unit Testing ,System Integration testing and Regression Testing .

Environment: Oracle Applications 11i/R12, BI Apps 7.9.5, OBIEE 11.1.1.5, ETL, Informatica,Micro strategy,XML/BI Publisher 5.6.3,SSRS,Erwin,SQL PLUS, SQL Developer,TOAD.

Confidential

Sr. OBIEE/ETL Consultant

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Experience preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the DataWarehouse.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Designed, Developed and Loaded Staging tables to temporarily accommodate the history data before sending them to files.
• Experience with Oracle Manufacturing/Supply Chain Planning
• Worked with My SQL, Netezza, Oracle, CSV and Fixed Width Flat Files as Sources and Targets.
• Developed complex mappings using Lookup, Update Strategy, Joiner, Aggregator, Router, Expression, Filter and Sequence Generator Transformations.
• Worked on Mapplets, Reusable Transformations, Reusable Tasks to run post session commands using Command task and also Non Reusable tasks in Session Components and Email Tasks.
• 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.
• Implemented incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Migrated Analytics RPD and Webcat from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Modified Dynamic Session Variables used for Data Visibility, configured Security at the repository level, Catalog level the Application level.
• Involved in setting up Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• 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.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica WorkFlow Monitor.
• Developed Informatica Mappings using corresponding Source,Targets and Transformations like Source Qualifier, Sequence Generator,Filter,Router,Joiner, Lookup, Expression,Update Strategy, Aggregator.
• Created and customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• 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.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflex Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in customizing out of the box reports to support the business requirements.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts QulikView,Payables, Accounts Receivable,Inventory, Purchasing,Fixed Assets, OBIEE 10.1.3.4.1, Informatica 9.1, Oracle 11g, My SQL, Netezza,Cognos, Unix, Toad, DB Visualizer, Aginity,Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad , Linux, File-Zilla.

Confidential

Sr OBIEE Consultant

• Implemented Financial Analytics and Procurement and Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• 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.
• Extensively worked on SRs as per the client's requirement to get the reports for the Business Analyzation.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Created Environment Variable on Unix/Linux Environment.
• Designed and developed Dashboard Pages including: Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Implemented incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Responsible for extracting Data from Oracle Apps Modules and loading into stage system and warehouse system.
• Customized Dashboard pages including: Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Essectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts And Dimensions.
• Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in Iprocurement, Payables and General ledger.
• 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.
• 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, Aggregator.
• Designed and Developed Sessions and Workflows.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment:Oracle Applications 11i/R12 XML/BI Publisher 10.1.3.4, Supply Chain SCM , Procurement and HR Analytics /Sales Analytics /Spend Analytics, Informatica Power Center 8.6, Data Warehouse Administration Console DAC , Data Quality 8.6.2, Java, Data Explorer 8.6,Hyperion, Informatica Power Exchange 8.5,Teradata,Data Modeling, Oracle 11g, PL/SQL, SQL Plus, UNIX Sun Solaris .

Confidential

Oracle Apps Developer

• Created Dashboards and Answers for End user.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• 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.
• Involved in the installing and configuring of Financial Analytics.
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity,GL Balance,Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AR Balance,Payments Due,Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like AP Balance,Overview,Payments Due,Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview,Margins,Revenue,Products and Customers in Profitability Dashboard.
• Setup Multi User Development Environment MUDE in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica WorkFlow Monitor.
• Responsible for extracting data from Oracle Apps Modules and loading into stage system and warehouse system.
• Created and ran Sessions Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source,Targets and Transformations like Source Qualifier, Sequence Generator,Filter,Router,Joiner, Lookup, Expression,Update Strategy, Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool..
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing and Regression Testing .
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Created VPD security for reports in OBIEE.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables,Fixed Assets,BI Apps 7.9.5, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Essbase,Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, ,SQL PLUS, SQL Loader, TOAD,Unix.

Confidential

Oracle Apps Developer

• Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules. Designed and recommended solution for custom processes flow integrated with standard applications.
• Provided customer support for Oracle standard and custom built Applications.
• Involved in Customization of Cancelled Orders Report, Orders Summary Report.
• Involved in Open Sales Order conversion based on client specifications.
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Developed interface program for Customer interface by using the standard API's
• Developed Registration Scripts for moving objects from one environment to another.
• Created new responsibilities and involved in defining the required system profile options.
• Wrote custom code with validations to transfer the data from staging table to interface tables.
• Developed Customer Data Import program for data loading from different systems to oracle TCA tables.
• Expertise in Oracle Discoverer in Creating various business areas, user views, custom folders and joins for reporting.
• Developed various custom business areas by using the Discoverer for various modules.
• Created complex folders and created Item Classes.
• Migrated Business Areas/Item Classes/Hierarchies from one Instance to the other.
• Involved in Unit Testing and Performance Testing for reports.
• Involved in preparation of various documents like MD050, MD070 functional Technical Design documents.
• Performed unit, system, integration testing with reference to interfaces to non-oracle applications
• Created and have setup Resources using public packages.
• Responsible for techno design documentation of the reports.

Environment: Oracle Apps 11i General Ledger, Order Management, Inventory, Accounts Receivables, System Administrator, Oracle 8i, Reports 6i, Discoverer 4i, SQL, PL/SQL, SQL Loader, Sun Solaris OS 2.8, Unix Shell scripting, PVCS.

Confidential

Oracle Programmer/Analyst

• Coordinated with the business users to collect requirements.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL LOADER.
• Customized and developed Oracle Forms and Reports using Oracle Forms 6i and Reports 6i
• Developed Reports to extract the monthly sales information
• Participated in performance tuning, unit test case preparation and execution.
• Utilized tools like TOAD during development of the application

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL Loader, SQL Plus, Forms 6i, Reports 6i, Windows 2000.

Skills