Summary:

• Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost-effective, high performance technical solutions to meet challenging business needs.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• 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 and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas 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 implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse ,OBIEE RPD development, OBIEE reports and Dashboards.
• Well experienced working with oracle EBS 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 Data Warehouse Administration Console DAC to configure, monitor and schedule ETL.
• Expertise in Oracle OLAP to produce analytic measures, including time-series calculations and financial models
• 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 ,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, and Aggregator.

Technical Skills:

Professional Experience:

Confidential

Sr OBIEE/OBIA Developer

Responsibilities:

• Designing and maintaining technical and functional documents for Oracle Financials, HRMS and Procurement, spend Analytics with lead and developer responsibilities
• Configured Oracle BI Applications Informatica, DAC and OBIEE , implemented Oracle out of the box Prebuilt Apps.
• Customized Business Intelligence BI Applications, prebuilt BI solutions. Oracle Financial Analytics delivers, implemented for the financial services.
• Experience in extracting data from Oracle EBS, OLTP, flat files and loading data to OBAW-OLAP systems.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Designed and built Oracle BI Analytics data model, designed customized Star and Snowflake schemas by extending Fact and Dimension tables.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector
• Developed Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Implemented Security by creating roles web groups, External tables and LDAP.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings Mapplets using various Transformations and monitoring Incremental Full load through DAC.
• Worked extensively to customize DAC Execution Plans, Subject areas, Task Definitions and Tables for OBIEE Financial Analytics.
• Successfully configured OBIEE EBS for oracle BI Applications.
• Developed various kinds of Reports Pivots, Charts Tabular using global and local filters.
• Security management for users, groups and web-groups using the various authentication systems such as Active Directory authentication using Session Variables to create Row-level security, as well as Dashboard / Report-level security.
• Created Session Repository variables to achieve desired functionality.
• Implemented prompts to provide dynamic filter conditions to end users.
• Customized report look and feel using column formatting and conditional formatting.
• Tuned OBIEE Reports to improve the performance.
• Implemented Cache Management techniques to improve the performance on both real time and non-real time reports.
• Configured IBots to deliver Analytics content based on Schedule to obtain weekly reports and sent notifications Alerts.

Environment: OBIA 7.9.6.4, OBIEE 11.1.1.6.8, Informatica 9.5, DAC 11g, TOAD, SQL Developer, Windows XP, LINUX OEL 5, EBS 12.1.1/11.5.10, JDE 9.1

Confidential

Sr OBIEE/OBIA Developer

Responsibilities:

• 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.1,Oracle 11g, DAC 10.1.3.4.1, ,Windows 2000/XP

Confidential

Sr OBIEE/OBIA Developer

Responsibilities:

• 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

Responsibilities:

• 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 upgrade 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, DAC 10.1.3.4.1, Java, Linux, Windows 2000/XP

Confidential

Sr OBIEE/ OBIA BI APPS Consultant

Responsibilities:

• 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, Microstrategy, XML/BI Publisher 5.6.3, SSRS, Erwin, SQL PLUS, SQL Developer, TOAD.

Confidential

Sr. OBIEE/ETL Consultant

Responsibilities:

• 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 Data Warehouse.
• 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, and 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 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 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

OBIEE Consultant

Responsibilities:

• 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 Analyze.
• 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 iBots 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, Effectiveness, 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, and 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

OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts to gather the Analytics requirements and translated business requirements to technical considerations for Data Warehouse and Reporting.
• Created the Business Model in Repository for generating reports as per the requirements.
• Involved in modeling activities which includes building Star Schema as per business requirements and configuration of Logical Layer, Logical Tables, Dimensions and Columns. Established the logical joins/keys required to support drill-down aggregation.
• Created connection pools, physical tables and defined joins in the physical layer of the repository.
• Extensively used OBIEE Admin Tool for customizing and developing Business, Physical and Presentation Layers of Metadata Repository.
• Designed and Developed OBIEE Metadata Repository .rpd using OBIEE Admin Tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions drill-down hierarchies , Logical, Facts/Measures Objects in Business Model Layer, and creating the Presentation Catalogs in the Presentation Layer.
• Created dimension hierarchies and assigned levels and custom aggregation rules for each level.
• Involved in creating Users, Groups and managing the object level and data level security.
• Designed and Configured Dashboards for different user groups with drill-down capabilities.
• Configured Repository and Session variables to get dynamic Reports and Dashboards.
• Worked extensively on OBIEE Answers to create reports as per the requirements.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement
• Developed different kinds of reports pivots, charts, tabular using global and local Filters.
• Installation of OBIEE 10.x on Windows 2003 Server and migration of Siebel Analytics 7.x to OBIEE 10.x on windows2003 Server.
• Involved in feasibility study and Prototyping some of the main reports for OBIEE.
• Configured iBots to deliver analytics content based on schedule, automated iBots queries to obtain reports sent notifications Alerts to Managers.
• Worked collaboratively with Infrastructure and support teams, consultants, project managers, and corporate development to develop consulting and project methodology, techniques, tools, and solutions.
• Assist data architecture team to optimize the database for bulk loads and large, complex, unpredictable queries
• Involved in intensive end user training both Managers and business users in Presentation Services with excellent documentation support.

Environment: OBIEE 10.x, Siebel Analytics 7.x, Informatica 7.x, SQL Server 2005, Oracle 10g, PL/SQL, TOAD, Windows XP