We provide IT Staff Augmentation Services!

Sr. Biapps/obiee Consultant Resume

Mountain View, CA

SUMMARY:

  • 10 years of experience as an Oracle applications (E - Business Suite) consultant, expertise in General Ledger, Account Payables, Accounts Receivables, Fixed Assets, Order Management, InventoryOracle Purchasing, Install Base, Service Contracts, System Administrator, and Cash ManagementService Request.
  • Over 7 years of experience in Siebel Analytics (OBIEE) and Informatica and Oracle Data Integrator (ODI) development.
  • 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.8/11.1.1.7/11.1.1.5.0/10.1.3. x/Siebel Analytics 7.x and Informatica 9.x/8.x/7.x and OBIA/BI Apps 11.1.1.8.1/7.9.6.4/7.9.6.3/7.9.6.2/7.9.6/7.9.5.
  • Detailed knowledge in Data warehouse Application Console (DAC) 11g/10g.
  • Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and demo configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answerssecurity implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, FoldersReports) and scheduling iBots.,Strong Experience on SAAS.
  • Extensive Experience in Migrating from 10 g to 11 g
  • Extensively Worked on Fixing data mismatch issues after up gradation of OBIEE 10 g TO 11 g.
  • Extensive experience working on RPDs, Dashboards building using OBIEE.
  • Developed the RPD in MUDE (Multi User Development Environment).
  • Worked on Source Qualifier, Expression, Filter, Lookup, Update Strategy, Stored Procedure, Joiner, Router, Aggregator transformation.
  • Proficient in creating and using Informatica workflows and worklets.
  • Worked extensively on transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup Strategy, Update Strategy, Sequence generator, joiner transformations, Router etc.
  • Experience in using Sources, Mappings, Targets, and Sessions for OBIEE data warehouse loads and Resolving any data inconsistencies across loads.
  • Perfect in understanding Data Models (Star Schema and Snow Flake Schema).
  • Experience in supporting the production system and handling day-to-day issues.

TECHNICAL SKILLS:

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Cash ManagementPurchase Order, Advanced Pricing, Service Contracts, Purchasing, AOL, System Administrator.

Application Tools: OBIEE 11g/10g, Oracle Data Integrator(ODI) 11g, Informatica 9.x/8.x/7.x, DAC 11g/10.1.3.x/11.1.x, Reports 6i/4i, Discoverer 10g/6i/4i, Forms 10g/6i,, Oracle 9iAS, XML Publisher 5.6.3/5.6.2.

Databases & Tools: Oracle 10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader.

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, JAVA, XML, C, C++.

Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

Testing Tools: Quick Test Professional (QTP) 9.1/8.2/8.0, Loadrunner 9.0/8.1/8.0 PVCS.

WORK EXPERIENCE:

Confidential, Mountain View, CA

Sr. BIApps/OBIEE Consultant

Responsibilities:

  • Worked on the RPD and created the metrics.
  • Created Dimensional Hierarchies in the RPD.
  • Implemented Data Level Security and Object level Security.
  • Implemented Fragmentation logic in the RPD for Closed and Open Periods.
  • Created Implicit Facts in the RPD.
  • Created Level based metrics in the RPD.
  • Created Union Reports and used Rank function to show the data in the Waterfall graph.
  • Created Month and Quarter Trend Reports to show the different accounts data across the time periods.
  • Tuned the performance of the reports by adding Indexes and by Creating the Month and Quarter Aggregate tables for different segments.
  • Used different views (Line-Bar and Stacked Vertical.. etc) in OBIEE to show the data.
  • Configured and setup ODI, master repository, work repository.
  • Used Column selector and View Selector in the reports and created different compound layouts for reports.
  • Set up the Topology including physical architecture, logical architecture and context.
  • Created new models for the data sources.
  • Did reverse engineering for the data sources and targets.
  • Created ODI packages, scenarios using interfaces, variables, procedure.
  • Performance tuning of the ODI interfaces.
  • Used and customized different ODI knowledge modules.
  • Created and scheduled Load Plans in ODI.

Environment: OBIEE 11.1.1.7.1 , Oracle Data Integrator (ODI) 11g, BI Apps 11.1.1.8.1 (Financial Analytics), Oracle Applications 11.5.10.2(General Ledger, Account Payables, Account Receivables), Essbase 11.1.2.3, Hyperion, UNIX.

Confidential, Pittsburgh

Sr. BIApps/OBIEE Consultant

Responsibilities:

  • Configured Financial Analytics, HR Analytics, Supply Chain and Order Management Analytics, Procurement and Spend Analytics.
  • Created Dimension hierarchies to achieve the drill down functionality.
  • Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
  • Implemeted the Oracle Index Monitoring to improve the performance of the OBIEE Reports, Informatica Tasks and DAC loads.
  • Did the GAP analysis and identified the gaps, created the technical desined the documents.
  • Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
  • Designed and Developed Custom Mappings, Workflows and Registered in DAC.
  • Upgraded BIApps from 7.9.6.3 to 7.9.6.4.
  • Upgraded Informatica server and client tool from 8.6.1 to 9.1.
  • Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Oracle Adapters in DAC.
  • Registered new tables, Indices, Workflows in DAC.
  • Created new subject areas and Execution Plans in DAC.
  • Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
  • Rebuilt the Source System Container and building the subject areas and Execution plans in DAC.
  • Responsible for customizing the out of box reports and creating new reports and dashboards.
  • Migrated repository and web catalog files from Dev environment to Production environment.
  • Used various Transformations like Lookup, Expression, Filter, and Joiner for cleansing and consistent data.
  • Analyzed, Designed, and Developed Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created and run 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, and Aggregator.
  • Created Dashboard prompts and advance filter criteria.
  • Designed Star and Snowflake Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
  • Used Hints, Indexes and other tuning techniques to increase the performance of the slowly running reports.
  • Interacted with business users to gather requirements and other data needs.
  • Created Dashboard Prompts for Selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables.
  • Developed Order and Invoice Revenue by Product dashboard in Procurement and Spend Analytics
  • Developed Order Revenue Growth Over Previous Year dashboard in Procurement and Spend Analytics
  • Designed and developed the dashboard pages Purchase Order Detail, Purchase Order with Requisition and Purchase Order without Requisition in Procurement and Spend Analytics.
  • Customized Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Analytics in OBIEE.
  • Designed and developed the dashboard pages Purchase Order (PO) Overview by All Suppliers, Business Area, Department, Division, and Region and by Top 20 Suppliers in Procurement and Spend Analytics.
  • Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE.
  • Customized W PURCH COST F, W PURCH ORDER F, W PURCH RQSTN LINE F fact tables to add new columns as per the client requirements in Procurement and Spend Analytics.
  • Customized W AP XACT F, W AP INV DIST F, W AP AGING INVOICE A fact tables to add columns as per the client requirements in financial analytics payables (AP).
  • Customized W GL BALANCE F, W GL OTHER F fact tables to add columns as per the client requirements in financial analytics general ledger (GL).
  • Customized W BUSN LOCATION D, W PARTY D, W SUPPLIER ACCOUNT D Out-of-Box (OOB) dimension tables to add new columns as per the client requirements.
  • Created Level Based Measures, new logical columns in the logical layer of RPD.
  • Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers of the RPD using the Multi User Development Environment (MUDE) in OBIEE.

Environment: OBIEE 11.1.1.7/10.1.3.4.1 , Informatica 9.1/8.6.1, BIApps 7.9.6.3/7.9.6.4 (Financial Analytics, Order Management and Supply Chain Analytics, HR Analytics), Oracle Applications R12(General Ledger, Account Payables, Account Receivables, Order Managements, Inventory, HR) BI Publisher 11.1.1.7/10.1.3.4.1 , Oracle 10g/11g, SQL Plus, TOAD, UNIX.

Confidential, Schaumburg, IL

Sr. BIApps/OBIEE Consultant

Responsibilities:

  • Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
  • Involved in installation and configuration of OBIEE with Informatica.
  • Responsible for configuring the informatica Source and lookup files.
  • Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Customizing the existing informatica repository and adding new mappings and workflows based on the requirements.
  • Used aggregated tables as logical tables sources and configured Aggregate navigation
  • 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.
  • Customized W EMPLOYEE D, W SUPPLIER PRODUCT D Out-of-Box (OOB) dimension tables to add new columns as per the client requirements.
  • Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements.
  • Designed and Developed Sessions and Workflows.
  • Optimized performance by tuning the Informatica ETL.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Configured and Scheduled Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Worked on multiple folders at time to meet the dead lines of the tasks.
  • Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
  • Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.

Environment: OBIEE 10.1.3.4, Informatica 8.1.1, BI Apps 7.9.5(Financial Analytics) Oracle Applications R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 9i (9.2.0), Discoverer 10g, Repots10g,SQL*PLUS, SQL*Loader, TOAD, UNIX

Confidential, Athol, MA

BIApps/OBIEE Consultant

Responsibilities:

  • Created Metadata repository - Physical layer, Business Model and Presentation Layer for contract activation report in Service Contracts
  • Configured iBots in order to deliver the reports based on Schedule and automated iBot queries to deliver at scheduled timings.
  • Used Catalog Manager to migrate web catalog from one instance to another.
  • Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
  • Created reports in Answers and embedded them in Dashboards according to the requirements.
  • Used various Transformations like Lookup, Expression, Filter, Joiner and for better data scrubbing and to cleansing and consistent data.
  • Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
  • Participated in Production Support and resolved problems that occurred during this phase.
  • Developed repository and created logical columns, Hierarchies, Economical Source and Aggregate navigation in the Business model according to the requirements.
  • Identified the granularity level of the data required to be available for analysis.
  • Created hierarchy based Sales Card Dashboards and marketing dashboards (Buying segments, Purchase analysis) for different Business units and end users.
  • Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, SQL Server, flat files and loading to Oracle target database.
  • Designed and developed logical model in BMM in Repository.

Environment: Informatica 8.1.1, OBIEE 10.1.3.4, BI Apps 7.9.5, Oracle Applications R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Supply Chain(SCM), Service Contracts, Install Base, Oracle 9i (9.2.0), Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unixz

Confidential, Atlanta, GA

Oracle Apps/OBIEE Consultant

Responsibilities:

  • Developed Service Contract conversion program by using the standard API’s.
  • Imported Items from legacy system into Oracle Inventory using the Standard Item Interface Program.
  • Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
  • Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
  • Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
  • Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
  • Developed Open interface to import orders from legacy system to apps.
  • Developed new report Credit Memos in AR using Discoverer
  • Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
  • Developed Contract History Report using Discoverer in Service Contracts
  • Developed Give Service Report using XML/BI publisher in Service Contracts

Environment: Oracle Applications 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Supply Chain(SCM),Service Contracts, Install Base, BOM,WIP, Inventory, Oracle 9i, Discoverer 10g, XML Publisher, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX.

Confidential, Pittsburgh, PA

Oracle Apps/OBIEE Consultant

Responsibilities:

  • Involved in installation and configuration of OBIEE with Informatica.
  • Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
  • Responsible for configuring the informatica Source and lookup files.
  • Customizing the existing informatica repository and adding new mappings and workflows based on the requirements.
  • Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements.
  • Designed and Developed Sessions and Workflows.
  • Optimized performance by tuning the Informatica ETL.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Configured and Scheduled Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Worked on multiple folders at time to meet the dead lines of the tasks.
  • Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
  • Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.

Environment: OBIEE 10.1.3.4, Informatica 8.1.1, BI Apps 7.9.5(Financial Analytics) Oracle Applications R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 9i (9.2.0), Discoverer 10g, Repots10g,SQL*PLUS, SQL*Loader, TOAD, UNIX

Confidential, New Jersey

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
  • Worked on Service Contract conversion program by using the standard API’s.
  • Developed the interface program for customer interface by using the standard API’s
  • Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
  • Interacted with business groups, developers to understand requirements, rules and workflow.
  • Development of stored procedure that extracts data from AR, AP and PO modules or reconciliation according to business requirement
  • Developed an interface program using GL journal Import to load journals in General Ledger.
  • Used holds & Line workflows together as approvals. This can be used in Automatic and Manual approvals.
  • Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
  • As a Discoverer Administrator created Business Areas, Folders, and Setup joins between folders, Registered PL/SQL functions, created Item Classes, created date hierarchies and item hierarchies etc.
  • Maintained user security and privileges at business area level.
  • Provided Periodic backups of EUL and involved in export, import of End User Layers from one instance to another.
  • Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.
  • Designed and Developed functional and technical documents and assisted the business in documenting the functional specifications as a part of MD50 creation.
  • Developed UNIX Shell scripts to run the interface program and to archive the data.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Accounts Payables, Account Receivables, Order Management, Service Contracts, Inventory, Oracle 9i,Optio,Oracle Purchasing, Discoverer 10g, Service Contracts, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX

Hire Now