We provide IT Staff Augmentation Services!

Bics/obiee/obia/informatica Consultant Resume

Sunnyvale, CA

SUMMARY:

  • 8 years of experience in Information Technology with strong background in OBIEE/Siebel Analytics, Informatica,ODI, Oracle Applications, and Data Warehousing Complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing, Production Support, Maintenance and Enhancement in variety of technological platforms with special emphasis Client/Server, Data Warehouse and Business Intelligence applications in Windows and Unix environments.
  • Business Intelligence experience using OBIEE 12c/11g/10g and Siebel Analytics 8.1.1, Informatica 7, 8, 9.x, ODI 11g/12c, Endeca Information Discovery and Clover ETL process, MicroStrategy 9.4, Business Objects XiR2/R3/R4 and QlikView V 11, Qlik Sense, Cognos.
  • Expertise in leading and Maintaining DW/BI Projects for various client projects related to OBIEE, ODI, Informatica, and Endeca.
  • Worked extensively with Oracle BI (OBIEE) applications includes meta data configuration, dashboard report development, configuring Physical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, adding multiple sources, executing direct Database requests, iBots, SSO(Single Sign On),Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart) etc.
  • Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.), Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards.
  • Setup Multi User Development Environment (MUDE) using BI Administration tool.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
  • Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Created numerous ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration).
  • Worked extensively in developing ETL Transformations, Informatica Designer (joiner, expressions, lookups, filters, routers, stored procedures etc.,), Informatica Workflow Manager (Sessions, sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, and Repository Manager.
  • Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design addressing slowly Changing Dimensions (SCDs)
  • Performed Unit, Integration, Regression and UAT testing to validate reports, dashboards and mappings.

TECHNICAL SKILLS:

BI Tools: OBIEE 11g/10g, Cognos, Tableau, Qlik sense 2.x, QlikView, Oracle BI Publisher, BI APPS 7.9.6.x/7.9.5.x, Siebel Analytics 8.x, 7.x (Administration, Answers, Interactive Dashboards, BI Publisher, Disconnected Analytics, Briefing Books, BI Delivers, Analytics Server Administration).

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

Scheduling Tools: Datawarehouse Administration Console (DAC).

ERP Applications: Oracle R12/11i (Financials (General ledger, Accounts Payable, Accounts Receivables)).

Databases: MS office, Toad, Data Loader, SQL Loader, IBM DB2, MS Access, MYSQL

Languages: Java1.6, C/C++, PL/SQL, Java script, Visual Basic

Software Methodologies: Object Oriented Analysis & Design, UML, SDLC (Agile, Iterative)

Modeling Tools: RUP, MS Visio, Influx Tool for BPE

Documentation: MD050, BR100, BR30, TE040, User manuals

Web Technologies: HTML, XML, CSS

Operating Systems: UNIX, WINDOWS XP/7.0.

PROFESSIONAL EXPERIENCE:

BICS/OBIEE/OBIA/Informatica Consultant

Confidential - Sunnyvale, CA

Responsibilities:

  • Decommissioning of OBIEE Reports, Oracle Discoverer Reports and BIP Reports to OBI Cloud Services (BICS) Platform of different oracle modules like Manufacturing Supply Chain and Management, Sales Operations, HR etc.
  • Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents and Data Lineage Documents as per the business rules.
  • Configured Interactive Dashboard with drill-down capabilities using global and local Filters , Metadata Objects and Web Catalog Objects .
  • Implementing change in the Product Hierarchy and held responsible for all the dashboards and reports in the data level
  • Backtracking of the OBIEE Metrics in the Rpd level and in the SDE and SILO’s Mappings in the Informatica to get the EBS Source Columns.
  • Re-Modeling the existing Tables, Views and Materialized Views in the data mart to improve the performance of the BICS dashboard using SQL.
  • Analyzed the current data model and modified it to get the Shipment Information, Inventory details and Backlog Units etc... In the Oracle Apps Schema.
  • Develop Business Intelligence Models, Cubes, reports and Dashboards in Oracle Business Intelligence Systems.
  • Decommissioning of HR Analytics OBIA 7.9.6.4 and maintain separate instance for the HR model in the Dev, QA to implement in Cloud Environment (BICS).
  • Implemented Consistent set change data capture (CDC) for real time reporting.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Prepared the Test Plans and Test cases for User validation (UAT) of the reports/dashboards.
  • Successfully implemented the code in DEV and deployed in UAT, Debugged and tested in final Test and deployed in Production.
  • Day to day monitoring of varies interfaces to other internal applications and external vendors for the smooth functioning of the business

Environment: BI Apps 7.9.6.4, OBIEE 11g, Informatica 9x, BICS, Oracle EBS R12, Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7, BI Publisher 11.1.1.1, Data Warehouse Administration Console (DAC), Oracle Supply Chain Management, Manufacturing, Financial and HR Modules, Oracle 11g, PL/SQL, SQL*Plus

OBIEE/ODI Consultant

Confidential - Houston, TX

Responsibilities:

  • Customized the OBIEE messages by creating Custom Message XML files
  • Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
  • Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
  • Created Financial Analytics reports which are used to analyze Trial Balance, Intercompany Balances, Journal Inquiries, Flow Analysis, Expense Analysis, Treasury Movement of Cash analysis and Payable reports.
  • Implemented Financial Analytics, Supply Chain and HR Analytics
  • Designed AFE Supplement, Well Analysis and CAPEX Accrual Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users.
  • Upgraded Rpd, Web Catalogs from OBIEE 11.1.1.7 to OBIEE 12c.
  • Configured Usage Tracking and developed reports for BA's to track the users using the reports based on Subject Areas.
  • Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
  • Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
  • Implemented Scorecards and KPI for the sales and commission data.
  • Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
  • Written the JavaScript for Analysis Protection or Standardization for OBIEE query blocking from the Power BI Users and Adhoc Report Developers.
  • Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.
  • Administered NQSConfig.ini and Instanceconfig.xml configuration files by changing html tags a per business requirements.
  • Customized Out of the box Repository (RPD) to work with other ERP systems and Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
  • Created ODI interfaces, packages, procedures.
  • Reverse engineer data stores from various source systems like Oracle, Essbase, flat files and excel files.
  • Worked on ODI options to customize Knowledge Modules.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs .
  • Worked on the LKM SQLLDR KM to load huge amounts of data from flat file to Oracle table.
  • Extensively used ODI variables in various scenarios to developer ODI packages, scenarios as per requirements.
  • Worked on ODI security manager to set up ODI users and privileges.

Environment: OBIEE 12c/ 11.1.1.7/ 10.1.3.4.1 , ODI 11g/12c, BI Apps 7.9.6.3, Hyperion IR (Brio), Oracle EBS R12 (12.2.2.4), BI Apps 7.9.6.3/7.9.6.4 , DAC 10.1.3.4.1 , 1SAP, Linux, UNIX, SQL DEV, BI/XML Publisher, Oracle 11g, Toad, PL/SQL

OBIEE/Informatica Developer

Confidential - California

Responsibilities:

  • Worked on BI Publisher reporting and build complex Data Models, Templates as per the business requirement that had to return huge data volumes.
  • Designed the Physical layer, BMM layer, Presentation Layer in RPD, created the session variable and Dynamic variable in RPD.
  • Migrated the Web Catalog , Mappings and ETL Transformation from Test to Production Environments .
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Working in Financial and Manufacturing modules.
  • Customization and enhancement of standard Oracle applications reports like Material Account Distribution Detail (MADD), Invoice Validation report, Cash requirement report using Oracle BI Publisher.
  • Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Created different kinds of Parameters and list of values according to the user requirement.
  • Changed the query in the View level and Data model level according to the user requirements.
  • Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement
  • Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
  • Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
  • Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
  • Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
  • Successfully implemented the code in DEV and deployed in SIT and UAT, Debugged and tested in final Test and deployed in Production.
  • Designed and Developed the RPD and reports by using the column selector, pivot table view selector.
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
  • Configured security in Administration console for Authentication and created Application roles.
  • Setup the visibility of dashboard reports to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
  • Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
  • Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
  • Modified the existing mappings and mapplets based on user change requests to implement new business logic and improve the Session Performance.
  • Successfully implemented the code in DEV and deployed in SIT and UAT, Debugged and tested in final Test and deployed in Production.

Environment: BI Apps 7.9.6.3, Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7, BI Publisher 11.1.1.1, Hyperion IR (Brio), Informatica Power Center 8.6, Data Warehouse Administration Console (DAC), Oracle Financial and Manufacturing modules, Oracle 11g, PL/SQL, SQL*Plus

OBIEE Developer

Confidential

Responsibilities:

  • Participated in requirements gathering by meeting with the business user and base lining the details.
  • Identified the Data Sources (Relational, Excel etc.), Identified Business Model, Determined Facts & Dimensions, Granularity, and Data Consistency across Dimensions.
  • Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model.
  • Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
  • Developed Dashboard pages like Budget Vs Actual, Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
  • Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
  • Developed Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
  • Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using Basic RPD Authentication and External Table Authentication to setup groups, access and query privileges.
  • Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
  • Created Week Ago, and Month Ago and Year Ago Fact Measures and Dimension attributes.
  • Managed Security Privileges for each Subject Area and dashboards according to user requirements.
  • Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
  • Prepared the Test Plans and Test cases for validating the reports/dashboards.
  • Written many SQL statements for validating the reports and used the same in Test documents.
  • Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.0/10.1.3.4 , Informatica 8.6, Oracle 11g/10g, BI Publisher, PL/SQL, SQL Developer, Windows XP.

Hire Now