SUMMARY

• 7+ Years of experience as Oracle Business Intelligence and Applications Consultant wif successful track record in gathering user requirements, designing, developing and supporting different Business Applications.
• Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and has a strong understanding on OBIEE 11g and Oracle 12c capabilities wif Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1.
• Project management experience, assisting PMs in developing project scopes, budgets and schedules. Helped manage each phase of the SDLC — from requirements definition for OBIEE Reports, solutions design and testing through implementation, acceptance, training and support.
• Experienced in OBIEE 11.1.1.7,Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC). Experienced in Data Warehousing Methodologies.
• Extensively worked on Business Intelligence and Datawarehousing wif Kimball and Inman Methodology using OBIEE and Informatica, DAC.
• Experienced customizing Intelligence Dashboards/Score cards wif drill-down capabilities using global and local Filters, Analytics Security Setup (groups, access / query privileges (Oracle Access Manager Console)), Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders and Reports).
• Strong skills in Requirement Study, Gap Analysis, Scope Definition, Synchronization, Recommendations to Business Process Improvements.
• Extensively worked on Creating Users, Groups and Initialization Blocks in Oracle Admin Tool to set up Security using LDAP.
• Extensively worked on Installation and configuration of Financials Analytics, Supply chain and Order management Analytics, HR Analytics, and Procurement and Spend Analytics, Access Management products similar to OAM & OIM.
• Created Dimension hierarchies, Time comparisons and Share measures along wif ranks.
• Designed and developed variables and initialization blocks in the repository.
• Extensively worked on Extract, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Proven Strength in Creating guidelines and templates for designing & developing BI Applications.
• Adept at development and customization of RICE (Reports, Interfaces, Conversions, Extensions) objects.
• Experienced in General Ledger, Account Payables, Accounts Receivable, Inventory, Purchase Order and Order Management.
• Strong experience in developing and customizing Reports and Forms using Oracle Reports, Discoverer and BI Publisher.
• Experienced in providing end-to-end business intelligence solutions 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 iBots.
• Created workflows wif Worklets and Sessions, scheduled and modified using DAC and workflow monitor.
• Involved in discoverer administration task installation and export and import of EUL using Discoverer 11g.
• Developed and Scheduled workbooks using Discoverer Desktop.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Experience in SQL*Loader, Data Loader, UTL FILE, Oracle Import/Export utilities, SQL Navigator and UNIX Shell scripting.
• Adept at creating technical reference guides, user manuals and other related technical documentation, including Application Implementation Methodology (AIM).
• Very proficient in SQL tuning and optimization of queries.
• Experience in supporting the production system and handling day-to-day issues.
• Worked Extensively on OBIEE Administration Tool and Presentation Services.
• Excellent analytical, problem solving and communication skills wif ability to be an TEMPeffective team member and has the capability to work under severe time constraints.
• Participate in the analysis, requirement gathering, and design and development phases of ATG-Endeca projects that encompass major enhancements in all Endeca specific modules ranging from the, ProductCatalogSimpleIndexing, ITL (Information Transformation Layer), CAS (Content Acquisition System), and Experience manager for merchandizing.

TECHNICAL SKILLS

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order, Project Accounting, SCM

Application Tools: OBIEE 11g/10g/ 12C,Discoverer /9i/10g/11g, BI Publisher, Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g. Endeca MDEX 6.4.1.2, Endeca Developer Studio 6.5.0

ETL Tools: Informatica 9.x/8.x/7.x/6.x, ODI 11g,ODI 12c

Databases: Oracle RDBMS, Oracle 8i /9i/10g/11g, MS SQL Server 2000/2003

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

Operating System: UNIX, Linux (Red hat enterprise),Solaris and WINDOWS 98/2000/NT/XP

Other Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. OBIEE Consultant /Admin

Responsibilities:

• Requirement Gathering for OBIEE Reports.
• Provide estimation of the efforts and Time required for the development of OBIEE Reports.
• Developed Physical, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool by following standard OBIEE practices.
• Designed the Star Schema for different subject areas and build hierarchies, level-based measures, Aggregate level and Alias tables.
• Implementation of Object level security for the Dashboards and OBIEE reports.
• Extensive use of Image prompts, Action Links, Go-URL functionality for the development of Interactive Dashboards and Business Intelligence reports
• Migration of Security components, custom image prompts, style and skins from OBIEE 11.1.1.7.0 to OBIEE 11.1.1.9.0. & OBIEE12.2.1
• Performed Data Validation by executing Unit Test cases for Business Intelligence Reports.
• Created multiple Dimensions (Drill-Down Hierarchies) & Fact objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created materialized views and aggregates to improve performance.
• ETL jobs creation & customization using Oracle Data Integrator (ODI).
• Customized reporting wif OBIEE Answers and integrated them into the Dashboards.
• DevelopedOTBIreports for benefits and performance modules, Implement OTBI solutions for external interfaces
• Documented and maintained ETL specifications and processes.
• Provided assistance in creating data management standards and procedures.
• Worked on UNIX platform for security reasons.
• Designed DW tables, scripts, ETL maps.
• Migrated the Web Catalog, Mappings and ETL Transformation from Test to Production Environments.
• Providing ability to drill down from GL variance account details in Financial Analytics to identify work orders in Manufacturing Analytics that are causing large variances.
• Production Costing and Inventory (Manufacturing Analytics) helped track work order exceptions and provide analysis for inventory balances.
• Working on the implementation of Oracle E-Business suite R12 system.
• Provide hands on support and problem resolution in Order Management, Shipping, Purchasing, Manufacturing and Inventory in the Oracle EBS.
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Presented the disparate data in a consolidated view using Oracle Manufacturing Analytics
• Fine Tuned the Customized Workforce Profile Subject Area by editing the Custom Dimensions and Hierarchies at the Report, RPD & Database level.
• Migration to OBIEE 11.1.1.6 which includes Application Development Framework (ADF).
• Developed technical solutions to business problems in the OBIEE repository, and OBIA.
• Managed security privileges for each subject area and dashboards according to user requirements as per Business Intelligence requirements.
• Setting up External table authentication to enable Single Sign on (SSO) for Users in Development environment leveraging Analytics Repository.

Environment: Oracle Applications R12 (GL, AR, AP, OM, INV, PO), OBIEE12.2.1,OBIEE 11.1.1.9, Oracle BI Applications 11.1.1.3, Oracle 11g, Informatica 9.1, DAC 11.1.1, SQL*Loader, TOAD, Siebel Analytics (Supply Chain, Order Management).

Confidential, Round Rock, TX

Sr. OBIEE Developer/Admin

Responsibilities:

• Interacted wif Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Configured Oracle BI Applications Configuration Manager and Oracle Data Integrator, Oracle BI Applications Functional Setup Manager.
• Involved in Design and Development of custom business intelligence solution (Metadata and Dashboards Reports) using OBIEE 11g. Coordinated and worked wif different teams like SAP BW, DBA, testing team, functional team and end users Use the best practices of business intelligence to design the analytical solutions.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Converted Hyperion BQY reports into OBIEE BI Publisher reports and Integrated BI Publisher wif OBIEE to build reports in word, excel and doc format.
• Customized Out Of Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions,
• Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards
• Creating a Master Detail Report in BI Publisher wif Consistent Look and Feel Using Sub templates
• Setup Multi User Development Environment (MUDE) in OBIEE. Involved in Knowledge transfer to USDA IT Developer on various issues and product maintenance.
• Assisted ETL team to configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE Administration on Repository side as well as front end to display of OBIEE reports based on business user needs. Involved in unit testing, Security. and integration testing of the reports generated by OBIEE

Environment: Oracle Applications 11i (AR, AP, GL, OM, INV, SCM), Oracle 10g, OBIEE 11.1.1.3, Oracle BI Applications 11.1.1.3, Oracle 11g, SQL*Loader, Oracle BI Publisher, Informatica 7.1, Discoverer 10g, Reports 6i, TOAD, UNIX Shell Scripting, Shell Scripting, Windows NT.

Confidential, Omaha, NE

Oracle Middleware Architect

Responsibilities:

• Responsible for the design, development, implementation and maintenance or the server infrastructure and application design.
• Responsible for Oracle, servers, networks, build process. Consult for initial hardware design and acquisition.
• Ensure backups are reliable and being done on a regular schedule. Monitor database servers, answer requests, and resolve all production issues (including issues caused outside the servers but affecting them)
• Design of UNIX/Oracle security model, database physical design, database performance monitoring, database change review and implementation, database capacity planning
• Responsible for shell scripting processes to make database changes and build processes run smoothly, including Windows and Unix
• Performs release build/ configuration management of the databases
• Responsible for day-to-day database operations, monitoring and maintaining schema objects
• Responsible for system redundancy, failover, and high system availability strategies Wrote PL/SQL Stored procedures using HTP and HTF procedure calls to generate HTML web reports.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Worked wif Business users to gather functional specifications for OBI applications and prepare functional specification document.
• Collaborated wif Oracle EBS team to figure out the source tables and columns required for OBIA custom reports.
• Worked on different OBI Application modules (Oracle Financial Analytics, Oracle Project Analytics, Oracle Procurement and Spend Analytics).
• Imported required custom tables from oracle 11g data warehouse to the physical layer of the repository using predefined connection pools and created aliases for all the physical tables.
• Implemented Business logic by creating dimension hierarchies, level based measures and aggregates in BMM, presentation catalogs and folders in presentation layer.
• Created custom reports/dashboards wif different customized views as required by the user (Drill down, gauge, column selector, ticker etc).
• Created EBS query to validate OBIA reports.
• Performed Authentication and Authorization (Created new groups and added users to the group, implemented object and row level security).
• Created Scenarios, packages and added them to ODI load plan.
• Migrated ODI object between environments.
• Worked on Oracle Data Integrator to create new data servers and loaded fact and dimension tables in the data ware house.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.
• Defined Session variables in the repository to populate the current date filters.
• Worked on Dashboard and Page level prompts and Report filters.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse (SIL mappings).
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed executive level Forms and reports for Invoice details by customer, by item, by product type using Oracle Forms, Reports, and Business Objects.
• Modified several Customized Reports like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs using XML/BI Publisher.
• Developed Responsible for creating backend procedures and triggers.

Environment: Oracle 9i, Siebel CRM 7.8, Analytics 7.7, XML/BI Publisher, Discoverer3.1, Informatica 6.2, SQL Loader, TOAD, Windows NT, UNIX.

Confidential, Richardson, TX

OBIEE Developer

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Created item classes, conditions and joins using Discoverer Administrator.
• Registered functions using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Involved in customization of reports for giving statistical data as per requirements.
• Customized various standard reports like Purchase Order Summary, Purchase Orders Outstanding, Purchase Order Detail Report, Invoice Detail Report, Invoice Payment Register, Invoice Payment Outstanding, General Ledger Account Analysis Report etc using Reports 6i.
• Developed new forms using TEMPLATE.FMB and customized existing forms in the OM module according to the client’s requirements.
• Customized standard oracle reports like Check Formatting Report, etc as per client's requirements.
• Worked on tuning the SQL queries using the tuning utilities TKPROF in UNIX.

Environment: Oracle 9i, Windows/NT, PL/SQL, Siebel CRM 7.8, Analytics 7.7, Reports 6i, Discoverer 4i, TOAD 7.3, SQL Loader.

Confidential

OBIEE Consultant

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Created Reports based on user requirements.
• Worked on Dashboard and Page level prompts and Report filters.
• Interacted wif functional consultants for mapping legacy data to Oracle tables.
• Developed conversion mapping documents (CV40) to map legacy journal entries, inventory items, and AP vendors and purchase orders to Oracle 11i.
• Developed several workbooks using Discoverer Desktop.
• Scheduled workbooks using Discoverer Desktop.
• Designed and developed reports like pack slip report, trip report, Open Purchase order report, AR aging report and AP trial balance report and registered the developed reports using AOL.

Environment: Oracle 9i, Siebel CRM 7.8, Analytics 7.7, Informatica 6, Discoverer, Reports 6i and Toad.