SUMMARY:

• Over 7 years of experience in OBIA.
• Extensively worked on Installation and configuration of Financials Analytics, Supply chain Analytics, HR Analytics, and Procurement Analytics and Spend Analytics.
• Worked on Business Intelligence and Data warehousing with Kimball and Inman Methodology using OBIEE 11.1.1.7/11.1.1.6/10.1.3. x / Siebel Analytics 7.x and Informatica 9.1/8.1.1/7. x/6.x and OBIA/BI Apps 7.9.3/7.9.5/7.9.6 .
• Strong Experience in Data Warehouse Administration Console (DAC 7.9.6, 7.9.5).
• Detailed knowledge in Data warehouse Application Console (DAC) and Informatica Servers.
• Expert knowledge on ODI 11g architecture.
• Worked on ODI designer, topology manager, security manager, operator, knowledge modules, agents, scheduler and metadata navigator.
• Worked on complete configuration of HR Analytics module.
• Subject matter expert for OBIEE expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Experience in providing end - to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling agents.
• Extensive experience working on RPDs, Dashboards building using OBIEE.
• Strong experience with datawarehouse production support with Informatica as ETL.
• Implemented performance tuning techniques for ETL processes.
• Extensively used Informatica administrative console to setup and maintain the users and repositories.
• Extensive experience in using functionalities like Dynamic/Conditional Layouts in XML/BI Publisher.
• Developed reports employing Sub Templates in XML/BI Publisher along with XSL.

TECHNICAL SKILLS:

OBIEE 11g/10g

Informatica 9.1/8.x/7.x

OBIA/BI Apps 7.9.3/7.9.5/7.9.6

ODI 11g

TOAD

SQL*PLUS

BI Publisher 11g/10.1.3.4

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Senior OBIEE Technical Consultant

Confidential

Responsibilities:

• Analyzed the EBS source tables for HR Analytics to assess availability of data.
• Worked on the required source and look up files for HR Analytics configuration.
• Analyzed and configured the band dimensions for HR.
• Executed the Human Resources - Oracle R1213 - Flexfield execution plan to configure the key flexfields.
• Conducted multiple test runs to load HR data from EBS to data warehouse through DAC.
• Performed analysis on the data in HR dimension and fact tables after executing each load.
• Built the custom HR reports namely -
• Head count growth rate and termination trend
• Organizational growth
• Workforce by length of service
• Demographics by age band, employee gender, ethnicity, country of birth
• Employee performance 3-yr trend report
• Customize the HR reports by adding voluntary, involuntary and total termination counts to the workforce by length of service report.
• Create detail level reports for the HR reports and enable the drill down feature on the summary reports.
• Worked on the multiple Informatica mappings to ensure successful HR data loads.
• Executed full and incremental loads for HR Analytics in development and production environments.
• Created a comprehensive documentation of HR Analytics configuration for migration from development to production environments.
• Created master repository and work repositories in ODI 11g.
• Created knowledge modules to navigate between integrated technologies, databases and applications in ODI 11g.
• Worked on the load balancing feature in ODI which enables large volumes of data to be processed by automatically balancing the workload between agents.
• Worked on the ODI designer to define the rules for data transformation and data integrity and develop projects.
• Monitored and managed the data integration process using the Operator navigator in ODI.
• Defined the physical and logical architecture of the projects using the topology navigator in ODI.
• Created a COE document on Sales Reporting and Financials - GL Detail Transactions subject area. The COE document includes the tables, columns and definitions for each column, calculations for fact table columns and formats for time dimension columns.
• Worked on Oracle’s User Productivity Kit to develop OBIEE training activities for users.
• Developed the following training activities using UPK for Sales and Finance teams -
• Creating a Report
• Adding Filters to a Report
• Adding Filter View to a Report
• Adding a Pivot Table View to a Report
• Creating Dashboard Prompts
• Publishing a Report on a Dashboard Page
• Adding a Graph
• Adding Pages to a Dashboard
• Used decision frames in the UPK demos to create branches within the training activity so that the user has multiple options to skip, explore and learn without having to go through the entire demo.
• Deployed the UPK bundle on to the server so that users from sales and finance team may access through a link on OBIEE analytics.
• Created new reports like - MRP reports, Trial Balance report, Resin and Cassettes On Hand Inventory report, Tie Ratio reports and MRP Dashboard by Month and MRP Dashboard by week reports.
• Worked on multiple APCC reports and customized them according to the client requirement.
• Customized the RPD by adding the Account, Entity, Program and Cost Center Hierarchy to the custom Financials - GL Budget and Expenses subject area.
• Changed Ledger to local for columns the ledger currency code, credit ledger amount, debit ledger amount and opening and closing ledger amount columns.
• Imported columns in different fact and dimensional tables based on the requirement and changed the lengths of the columns in physical layer to show full values on the reports.
• Changed data types of columns in W GL OTHER F table as per requirement.
• Identified the columns that are required in the report in the physical layer and moved them over to BMM and presentation layers so that the columns are exposed to be used during report development.
• Customized the LTS of the newly created columns in BMM layer such that these columns are consistent with all the other columns in the table and therefore avoid any issues related to joins.
• Created initialization blocks and dynamic variables for APCC and Manufacturing reports.
• Transpose the layout of the reports as per client requirement.
• Modified the aggregate levels for the required columns in the BMM layer.
• Customized the date and currency formats on the report.
• Created multiple graphs in the reports like bar, line, pie and stacked graphs.
• Implemented OBIEE security in WebLogic console for authentication and authorization by creating providers
• Creatednew User ID’s, account modification of existing users, password reset and deletion of accounts.
• Assigned users to appropriate groups and set up the application roles and mapped each group to the application roles.
• Set repository privileges and catalog privileges for an application role.
• Configured agents to schedule delivery of OBIEE reports.
• Migrated RPD and catalog from development to test and production environments.

Environment: OBIEE 11g, Oracle BI APPS 7.9.6.2/7.9.6.3 , DAC, Informatica 9.x/8.6.1, ODI 11g, Oracle EBS 11i/R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV), TOAD, PL/SQL

Senior OBIEE Technical Consultant

Confidential, Tustin, CA

Responsibilities:

• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• Created Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, partitions, fragmentations, aggregate tables, managing cache and overwriting the SQL execution path by making use of hints.
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Implemented OBIA Human Resource (HR) Analytics implementation.
• Developed custom Human Resource reports.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Worked on the testing and validating the Repository in OBIEE.
• Created and customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
• Implemented Incremental Load mappings for Fact mapping.
• Performed OBIEE Admin works likenew ID creation and account modification of existing users.
• Migrated RPD and catalog from development to production environment.
• Configured OBIEE agents to deliver Analytics content based on schedule and automated agents queries to obtain daily and weekly reports.
• Created hierarchies, complex and foreign joins initialization block, presentation or repository or session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Worked on Informatica - Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple systems.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC).
• Research on Gap Analysis on fact tables in financial analytics module between DEV and QA environments.
• Built custom PLP mappings to resolve gaps on fact tables across different environments.
• Enhanced and customized the out of the box (OOB) Dashboards, facts and dimensions for Order Management and Financial modules.

Environment: OBIEE 11g, Oracle BI APPS 7.9.6.2/7.9.6.3 , DAC, Informatica 9.x/8.6.1, Oracle EBS 11i/R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV), TOAD, PL/SQL.

Senior OBIEE Technical Consultant

Confidential, San Francisco, CA

Responsibilities:

• Managed and customized theETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Monitored incremental and full load of data throughData Warehouse Administration Console (DAC)and Informatica.
• ConfiguredOBIEEagents to deliver Analytics content based on schedule and automated agents queries to obtain daily and weekly reports.
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentationsand slowly changing dimensions.
• Granting access to users and maintain security by using database authentication and authorization.
• Defined theDimensional Hierarchyand created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Worked with Informatica - Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
• Worked on a micro OBI project with PeopleSoft as the data source.
• Worked on some of the PeopleSoft HRMS tables - PS JOB, PS DEPT TBL, PS JOBCODE TBL, and PERSONAL DATA.
• Have a general idea about the position tree, department tree and effective dated rows.

Environment: OBIEE 11.1.1.5, TOAD, SQL, PL/SQL, OBIA/BI APPS 7.9.6/7.9.5 , DAC,Informatica Power center 9.1/8.5

Senior OBIEE Technical Consultant

Confidential, Philadelphia, PA

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Managed and customized theDAC loads, RPD and Web catalogmetadata according to the reporting needs of the client.
• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Performed the setting up, Installation and configuration of the complete Analytics platform environment in Linux/Unix Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Worked on integrating and configuring BI Publisher with OBIEE.
• Created BI publisher reports for HR Analytics.
• Configured OBIEE agents to deliver Analytics content based on schedule and automated agents queries to obtain daily and weekly reports.
• Used Conditional formatting for highlighting the records based on conditions in XML/BI Publisher.
• Developed reports employing XML/XSL templates in XML/BI Publisher.
• Developed reports based on DCLE for Invoice Summary and Client Commission reports.
• Developed reports based on the query builder to generate the SQL for the data model.
• Developed Credit Packing Slip Details Report and Open Item Details Report using XML/BI Publisher.
• Used the Totals/Subtotals/Group/Sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Customized Min Max reports in Inventory (INV) by using XML/BI Publisher.
• Customized AR Aging reports in Accounts Receivable (AR) and Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed custom reports like Open Sales Order Report, OpenPurchase Orders Report using XML/BI Publisher.
• 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.
• Created hierarchies, complex and foreign joins initialization block, presentation or repository or session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
• Implemented Incremental Load mappings for Fact mapping.
• Performed OBIEE Admin works likenew ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple systems.
• Worked with Informatica - Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC).
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Developed balance sheet, profit and loss statement using BI Publisher.

Environment: OBIEE 11.1.1.5, TOAD, SQL, PL/SQL, OBIA/BI APPS 7.9.6/7.9.5 , DAC,Informatica Power center 9.1/8.5

OBIEE Technical Consultant

Confidential, Brinckerhoff, NY

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated and configured BI Publisher with OBIEE.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• Created Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, partitions, fragmentations, aggregate tables, managing cache and overwriting the SQL execution path by making use of hints.
• Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
• Used advanced SQL techniques like Indexing and hints for performance tuning.
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Worked on the testing and validating the Repository in OBIEE.
• Created and customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the login page and dashboards in OBIEE using style sheets and XML files.
• Implemented Security by creating roles & web groups, which included Authentication to LDAP, which was SSO for Oracle BI environment, and Authorization to external table where roles and responsibilities were stored.
• Setup the visibility of Dashboard Pages to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Analyzed the requirements and developed the technical documents. Identified the stars (Dimensions/Facts) that need to be populated and created new workflows and mappings in Informatica based on the requirements.
• Implemented different views of report in OBIEE i.e. Pivot table, Titles, Graph, Filters etc.
• 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.
• Enhanced and customized the out of the box (OOB) Dashboards, facts and dimensions for Order Management and Financial modules.
• Created Multi User Development Environment (MUDE) for multiple users to modify a repository simultaneously and check in changes.
• Involved in customizing standard reports using XML/BI Publisher and registering necessary concurrent programs which also included:
• Item Quantities Summary Report and Sub-inventory Quantities report in inventory.
• Order/Invoice Summary report in Order Management
• Journal Entries Report in GL
• Developed Order/Invoice Detail Report, Sales Tracking Report, and Back Order Detail Report in Order Management using XML/BI Publisher.
• Customized Employee Listing report, Invoices on Hold report and Suppliers report as per the business requirements using XML/BI Publisher.

Environment: OBIEE 11.1.1.5/10.1.3.2 , BI APPS 7.9.5, DAC, Informatica 9.1/8.5/8.1.1 , Oracle 10g, TOAD, SQL, PL/SQL, SQL Developer.

OBIEE Technical Consultant

Confidential, Milwaukee, WI

Responsibilities:

• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• Created Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Used advanced SQL techniques like Indexing and hints for performance tuning.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Effectively migrating web cat, Skins and Style sheets from one server to another server by using catalog manager in OBIEE.
• Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger (GL) using FSG.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Customized W AP XACT F, W AP BALANCE F fact tables to add columns as per the client requirements in payables.
• Created VPD security for reports in OBIEE.
• 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.

Environment: OBIEE 11g, BI APPS7.9.6.3, DAC, Informatica, Oracle 10g, TOAD, SQL, PL/SQL

OBIEE Consultant

Confidential, DE

Responsibilities:

• Worked with business users to gather requirements. Work directly with management and Business analysts to translate Existing OLAP Reports into Detail Design specs for OBIEE.
• Installed and set up Oracle BI Apps (ODI, OBIEE) environment and responsible for administration and migration between various environments.
• Designed and Implemented Multi User Development Environment. Responsible for RPD Deployment and Catalog Management and sync All Environments.
• Extensively worked in all phases of Oracle Bi Apps like ETL, Scheduling reporting phases and done customizations of prebuilts, developing and integrating source data which is not in prebuilts.
• Involved in performance tuning by creating materialized views to create aggregate tables to avoid run time calculations and for some reports configuring ibots.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.

Environment: Oracle BIEE 10.1.3.3.1 , Oracle BI Apps 7.9.5, Informatica Power Center 8.1, DAC Oracle 10g, SQL Developer(HR, Benefits, Payroll, e-Application suite)

Oracle Applications Technical Consultant

Confidential, Boston, MA

Responsibilities:

• Developed PL /SQL packages, procedures, functions for interface program to validate the data for AR, and AP, GL modules.
• Involved in entire process of development and testing of AR Customer interface
• Developed PL/SQL script to Import Customer Invoices into Invoice Interface tables and imported into base tables using Auto Invoice Import Program
• Worked on Auto Lock box Conversion Program in Account Receivables
• Converted the customer information from legacy system into oracle Applications using custom programs and APIs to effect the HZ tables in TCA.
• Developed an interface to load external data from legacy system using SQL* Loader into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables.
• Developed PL/SQL Program to load Journals from the legacy system into GL Interface Tables.
• Integrated customized forms into Oracle Applications and added new forms and registered in Oracle applications
• Worked on Journal batch summary report, Trial balance report in GL
• Customized Aging bucket and Customer reports, invoice Payment Report in Accounts Receivables(AR) module
• Collected reporting requirements for implementing Discoverer 4i, created end user layer, business areas and various reports using Discoverer.

Environment: Oracle Applications11i, PO, AP, GL, INV, AR Oracle 9i, SQL* Plus, SQL*Loader, PL/SQL, TOAD 8.0, Reports 6i, Discoverer 4i, Windows 2000, Windows NT.