SUMMARY

• Over 8 years of extensive hands - on experience in Design, Development, Implementation, Analysis of Oracle Analytics, Administration tool, RPD Development, Dashboards, Configuring Dashboard, BI Delivers Configuring security at metadata and Report level, Metadata tools and User interface designs, including 3 full life cycle implementations.
• Core competencies include data modeling, design and development of ETL Data mart, Informatica and OBIEE 11g repositories, and building OBIEE 11g Dashboards/Reports.
• Extensively worked on Installation and configuration of Financials Analytics, Supply Chain Analytics, HR Analytics, and Procurement Analytics and Spend Analytics.
• Extensively worked on Business Intelligence and Data warehousing with Kimball and Inman Methodology using OBIEE 11.1.1.x/10.1.3.x and Informatica 9.0.1/8.x and OBIA/BI Apps 11.1.1.7.1/ 7.9.6.3/7.9.6.2 /7.9.6
• Strong Experience in Data Warehouse Administration Console (DAC 11g/10.1.3.4.x).
• Detailed knowledge in Data warehouse Application Console (DAC) and Informatica Servers.
• Extensive experience in installation and configuration of WebLogic Server. Experience in troubleshooting the deployment and other application problems.
• 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 demo configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components in the domain of Oracle Applications E-Business Suite.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL*Loader scripts.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc.
• Experience working with BIAPPS 11g with ODI, BI Application configuration manager(BIACM) and Oracle Functional set up manager(FSM)

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c, Access, SQL Server 7.x/2000/2008, IBM DB2 9.7

ERP: Oracle EBS, PeopleSoft, JD (General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets Purchasing, Inventory, Order Management, HR, Project Costing)

Tools: OBIEE11g/10g, Informatica 8.x/9.0.1, BI Publisher 11g, Discoverer 10g, JDeveloper, SQL Navigator, TOAD, IBM DB2 Client, SQL*PLUS, EDI, Export, Import, SQL*Loader, SQL*PLUSO/S Windows NT/XP/2000/98, Windows Server 2008, UNIX, Linux, MS-DOS.

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

OBIEE Developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Expertise in Configuration of BI Apps - ODI 11G using BIACM and FSM, Creation of Custom mappings and monitoring the loads
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Built the Physical Layer /Business Model and Mapping Layer of the Repository by using Star and snowflake Schemas.
• Customized the rpd modelling based on the user requirements and created many complex reports in FA, GL, AP, AR and PO
• Converted many EPM legacy reports into OBIEE reports and Dashboards
• Complete security setup - Authentication and Authorization, Configuration of LDAP as the Authentication provider using Windows Active Directory and created users and group’s schema and Storing groups in database for Authorization.
• 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.
• Setting up the Oracle Endeca environment for end users
• Implemented BIAPPS 11g with ODI and Customize FIN, HR Dashboards and Reports with PeopleSoft data
• 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.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• 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.

Environment: Oracle Applications 11i/R12 GL, AP, AR, Inventory, Purchasing, Fixed Assets, PeopleSoft ERP - HR, OBIEE 11.1.1.7.0 , Oracle BI Apps 11.1.1.7.1/11.1.1.9.1 , ODI, FSM, BIACM, Oracle 12C, Toad, Linux.

Confidential, Edinburg, TX

OBIEE Consultant

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata 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 data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• 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.
• 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.
• Granting access to users and maintain security by using database authentication and authorization.
• 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.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Involved in developing the Incremental ETL processes i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
• Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
• Customized Trends, Balances, Returns and Bill of Materials in Inventory and Forecast, Revenue, Effectiveness, Customer Report OOB dashboard pages in Order Management (OM) Analytics.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard (GL)
• Customized Liquidity, Financial structure, GL Balance, Cash flow OOB (Out of the Box) dashboard pages in General Ledger (GL).
• Customized Payments Due, Payment Performance, Customer Report dashboard pages in Account Receivables (AR).

Environment: Oracle R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Purchasing PO, HRMS), Oracle 11g, TOAD, SQL, PL/SQL, OBIEE 11.1.15x, BI APPS 7.9.6.3/7.9.6.2 , DAC, Informatica Power center 9.0, Discoverer 10g, BI publisher 11g, SQL*Loader, Unix Shell Scripts.

Confidential, Brea, CA

OBIEE, ETL Consultant

Responsibilities:

• Installed and configured complete suite of OBIEE 11.1.1.5.0 , DAC and Informatica 9.0.1 in both development and production environment on UNIX platform.
• Played various roles - OBIEE developer/OBIEE Administrator.
• Solely responsible for migration of repository and Web Catalog from 10g to 11g.
• Test and identify impact and changes required for 11g rollout from RPD and Catalog perspective.
• Provided training to the existing team on 11g and the new capabilities.
• Responsible for installing, configuring and administration of Oracle BI Apps 7.9.6.3/7.9.6.2
• Performed WebLogic 10g installation, domain configuration and performance tuning. Deployed required applications on BEA WebLogic.
• Integrated Informatica servers with DAC and customized the data warehouses and configured filter settings in it.
• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (rpd).
• Drive collaboration with the user & BI team
• Mentor BI team through implementation efforts. Communicate design, build and test effort progress to key users & issues to Project Manager.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Import/create tables and add/change physical joins/keys.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Gathering requirements from business users and converting them into technical design documents.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns and used DAC has deployment tool for ETL.
• Creating global filters, complex queries, prompts reports (charts, tables, graphs) in Answers and also created rpd/report development and worked on OOTB.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Extensively worked on Tpump, Mload, Fast Load Teradata Utilities.
• Extensively worked on Teradata environment by using Teradata SQL Assistant
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Expressions and Aggregator) for loading the data into data warehouse.
• Resolved open issues with production system.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Resolved issues with Full load, DAC tasks, failed Informatica mappings and some other issues with BI apps 7963.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures

Environment: PeopleSoft 9.0, JD Edwards 9.0 (GL, AP, AR, PO, OM, INV), IBM DB2 v9.7, IBM DB2 Client, AS400 iSeries Navigator, TOAD, SQL, PL/SQL, OBIEE 11.1.1.5.0 /10.1.3.4.1, OBIA/BI APPS 7.9.6.3/7.9.6.2 , DAC, Informatica Power center 9.0.1/8.6.1 , Teradata V2 R6, Teradata SQL Assistant 12.0, WebLogic 10.3.5/10.3.4 , Oracle 11g/10g, IBM AIX 6.1/5L 5.3 and Unix Shell Scripts, BI publisher 10g

Confidential, Milpitas, CA

OBIEE Developer

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• 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.
• 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.
• Developed GL journal Import interface program in General Ledger (GL).
• Effectively migrating web cat, Skins and Style sheets from one server to another server by using catalog manager in OBIEE.
• Extensively worked on Tpump, Mload, Fast Load Teradata Utilities.
• 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 (AP).
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings
• 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.
• 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 suite.
• 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.
• Imported data from XML and flat flies to load them into Data Warehouse
• Worked on custom designing GL Auditor Report, GL Financial Statements using BI Publisher.

Environment: EBS 11.5.10(AP, AR, GL, FA, Purchasing (PO), OM, Service contracts (CRM, AOL), OBIEE 10.1.3.x, BI APPS 7.9.6.1, DAC, Informatica 8.1.1, Oracle 10g, TOAD, SQR developer, SQL*Loader, Teradata V2 R6, Teradata SQL Assistant 12.0,UNIX Shell Scripts.

Confidential

BI Developer

Responsibilities:

• Developed various trending reports to analyze the revenue generate by products and sales reps.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema.
• Implemented Type 2 slowly changing dimensions to keep track of current and complete historical data.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Enforced Criteria based navigation to achieve better SLA on adhoc queries based on products, customer origination, and industries.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured iBots to alert the management and sales teams as per their requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Extensively customized Siebel Admin Tool Configuration by developing Platform Mapping to get new and customized warehouse tables in Physical, BMM and Presentation Layers.
• Implemented security model for various new star schemas developed to meet the business requirements.

Environment: Siebel Analytics 7.8.4, Informatica 7.1, WIN XP Professional, TOAD, Erwin