We provide IT Staff Augmentation Services!

Oracle Business Intelligence Administrator/developer Resume

Manhattan, NY

SUMMARY:

  • Total 9+ years of experience in system analysis, design, development, enhancement, testing, maintenance, Production Support and deployment of critical software applications using Oracle Business Intelligence tools.
  • Experience in OBIEE Administration, Linux Environments
  • Experience in Siebel Analytics 7.7,7.8.2,7.8.4/OBIA 7.9.6.1/OBIEE 10.1.3.4.1, OBIEE 11 1.1.1.5/ and Informatica 8.x/6.x..
  • Experience with repository(.rpd) development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports, Alerts)
  • Experience in Installation & Configuration of OBIEE 10g/11g, Informatica, DAC, OBI Applications in various operating systems.
  • Designed and developed OBIEE Repository(Physical, Business Model and Mapping Layer, Presentation Layer)
  • Experienced in Data Modelling using Dimensional Data Modelling, Star and Snowflake Schema modelling, Fact and Dimension tables, and Physical and Logical data modelling.
  • Extensive experience in providing end - to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, BI Publisher, Answers, building Analytics Repository using OBIEE, configuring Delivers / ibots, creating reports / Dashboards, cache monitor.
  • Experience in technology consulting, enterprise and solutions architecture and architectural frameworks with Siebel Analytics and Oracle BI
  • Experience in Business Model Development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Functions (Ago & To date), and Cache Management
  • Experience in OBIEE Security Setup (groups, access / query privileges), Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
  • Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Master-Detail Drill, Pivot Table, Chart, Gauge, Column Selector, Tabular with global and local Filters) using OBIEE Web.
  • Created various session variable and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
  • Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
  • Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Experience in mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Experience in working with different Modules Finance (AR, AP, GL, FA and SLA), Projects, Procurement and Spend, I expenses, P2P (Procure to Pay), Web Center, HR etc.
  • Unit testing & Peer review of code
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
  • Experienced in creation of technical, functional and requirement documentation MD070, MD120, DS030, Release documents as per the functional design
  • Experience in deploy RPD and Web Catalog Objects, Identifying and debugging errors in RPD before deploying and moved from DEV to QA and QA to Production.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
  • Experience in gathering requirements from Users and from the Product Owners to decide on the technical architecture and infrastructure to be used and come up with a design process.

TECHNICAL SKILLS:

BI Tools: OBIEE 11g/10g( Admin Tool, Presentation Services, Dashboard, Enterprise Manager & Web logic Console), OBI APPS 7.9.6.x, BI Publisher 10g/11g, Siebel Analytics

Data Warehousing/ETL: Informatica Power center 8.6, 9.0.1

Scheduling Tools: Data warehouse Administration Console(DAC)

Databases: Oracle 11g/10g/9i, SQL Server 2000/2005/2008

Environment: UNIX, Windows 2000/XP/2003 Server

Programming Languages/ Web Technologies: JSP, JDBC, Java Script, Servlets, C, C++, Java, VB 6.0, PL/SQL, HTML, XML, Perl

Incident Management Tools: HP Service, IT Service Now, MGTI

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

Oracle Business Intelligence Administrator/Developer

Responsibilities:

  • Handle Multiple projects administration responsibilities
  • Provide technical support for Managed Oracle BI Apps Hosting services provide by ICC including system administration of BI Apps technology components such as Informatica and ODI level security.
  • Provide routine productioon suppoer activities and provide incident and problem management support.
  • Trouble shoot BI Apps related issues.
  • Coordinate with the application and database vendors for resolution of problems (functional bugs, performance issues etc.)
  • Provide standby and oncall support as and when required.
  • Implement new BI Apps environments as required.
  • Perform application upgrades.
  • Analysis and designing of various reports and resolved the issues with in the SLA raised by application users.
  • Prepared weekly and monthly status reports on the status of the incidents

Environment: - OBI EE 11.1.1.7.4, BIP, ADF 11.1.1.6, and WebLogic Server 10.3.6.

Confidential, Manhattan, NY

Team Lead

Responsibilities:

  • Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
  • Created Design and development documents for creation of new subject areas/customization.
  • Involved in creation of metadata repository (.rpd), development of all layers of OBI Physical, Business Model and Presentation layer using the Oracle BI Administrator.
  • Understanding the requirements of the client, business scenario(s), application and prepared the design documents.
  • Imported new physical tables to layer physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation.
  • Experienced in Data Modelling using Dimensional Data Modelling, Star and Snowflake Schema modelling, Fact and Dimension tables, and Physical and Logical data modelling.
  • Created Calculation Measures Using Logical Columns, Physical Columns and the Calculation Wizard.
  • Involved in implementing the Oracle BI / Security (groups, data access/query privileges), Metadata Objects and Web Catalogue Objects (Dashboard, Pages, Folders and Reports).
  • Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
  • Created Time series measures and level based measures using AGO & TODATE Functions.
  • Implemented Aggregate tables for better analytics performance.
  • Creating and Developing Custom Styles, Skins, and Messages in Oracle BI EE 11g
  • Implemented LDAP security mechanism.
  • Developed RTF Templates Using BI Publisher 11g Template Builder for Word
  • Developed BI Mobile Application using Oracle BI Mobile App Designer
  • Developed various reports as per the requirements for user interface design like table, pivot, Chart, Narrative and view selector reports by using answers component.
  • Experience in building Interactive Dashboards with drill-down capabilities and Master-Detail Drill, use of global prompts and Presentation variables.
  • Developed various reports in Finance (AP, AR, FA, GL, and SLA), I Expenses, Procurement and Spend analytics, Requisitions, Procure to Pay (P2P), and Web Center for different Operating Companies.
  • Coordinated with BI RPD and Web Catalogue objects migration from one environment to other environment.

Environment: OBIEE 11.1.1.6.10, BI Publisher 11.1.1.6.10, Oracle 11g, WLS 10.3.2.

Confidential

Team Lead

Responsibilities:

  • Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
  • Added Aggregate measures using Aggregate Persistence Wizard
  • Installed and configured OBIEE on Linux and Windows.
  • Enabled Usage Tracking Table and Dashboards
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions
  • Involved in OBIE Testing.
  • Involved in Performance Tuning of reports by identifying the indexes required on the back end tables and also from the data available in the Cache
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level
  • Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
  • Designed Interactive Dashboards and created dashboard prompts with multiple selections
  • Designed and developed Detailed Credit/Unsaleable Analysis Report using BI Publisher which extracts the Markdown reasons and multiple credit requests
  • Developed various reports in Finance (AP, AR, FA, GL, and SLA), I Expenses, Procurement and Spend analytics, Requisitions, Procure to Pay (P2P), and Web Center for different Operating Companies.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
  • Creating new measures as well as modifying the existing measures at RPD levels.
  • Involved in creating dimensional hierarchies to support drill downs.
  • Perform in depth Data Analysis and implemented Cleansing process and Data Quality
  • Performed the Full and Incremented ETL process to populate the Data Warehouse, scheduled and ran the warehouse extracts.
  • Extracted data from different sources such as SQL Server 2005, Oracle, Fixed width and Delimited Flat files to load into Operational Data Store (staging area)
  • Designed and Implemented the Pre Staging and Staging approach, for cleansing using Informatica ETL.
  • Design and developed process for Initial loads and Ongoing loads(Incremental Aggregation with Extract Date concept)
  • Provided DAC support and completed the configuration for Order Management Analytics.
  • Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Informatica

Environment: OBIA 7.9.6.3/7.9.6.2, OBIEE 11.1.1.5.0/ 10.1.3.4.2, Oracle 10g/11g, Informatica 8.6/9.0.1, DAC 10.1.3.4.2

Confidential, North Carolina

Team Lead

Responsibilities:

  • Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
  • Worked extensively with Physical Layer, Business Layer and Presentation Layer.
  • Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Created different types of Customized Reports Drilldown, Master-Detail Drill, and Aggregation to meet client requirements.
  • Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
  • Created business reports using BI Answers as per requirements.
  • Generated various Analytics Reports using global and local filters.
  • Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
  • Added users and configured security in web logic console of OBIEE 11g.
  • Managed security privileges for each subject area and dashboards according to user requirements
  • Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
  • Developed various reports in Finance (AP, AR, FA, GL, and SLA), I Expenses, Procurement and Spend analytics, Requisitions, Procure to Pay (P2P), and Web Center for different Operating Companies.
  • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
  • Created workflows for full load and incremental loads to be used by DAC.
  • Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
  • Monitoring Incremental & Full load through DAC.
  • Trained End Users and Pilot Users about OBIEE Tools.
  • Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIA 7.9.6.2, OBIEE 10.1.3.4.2, Oracle 10g/11g, Informatica 8.6 DAC

Confidential, Denver

OBIA Consultant

Responsibilities:

  • Installation of OBIEE, OBIA APPS, Informatica and DAC in all the three servers.
  • Configuration Of OBIA w.r.t People Soft Source System
  • Involved in performance tuning activities in OBIA.
  • Involved in setting up security model.
  • Involved in creation of metadata repository (.Rpd), development of all layers of OBI Physical, Business Model and Presentation layer using the Oracle BI Administrator
  • Preparations of MD070, MD120, DS030 as per the functional design
  • Data Analysis and Report requirement gathering from the Customer.
  • Understanding the requirements of the client, business scenario(s), application and prepared the technical solution and design documents
  • Worked on OBIEE Administration tool and Presentation Services
  • Data analysis from Source database(OLTP) to data warehouse(OLAP)
  • Imported new physical tables to layer physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation
  • Created Calculation Measures Using Logical Columns, Physical Columns and the Calculation Wizard
  • Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query
  • Implemented Aggregate tables for better analytics performance
  • Implemented basic security and external table authentication security mechanism
  • Resolving Production support incidents/tickets raised by business users within agreed SLA
  • Extensively worked for On call support during the weekends and Holidays to gather customer requirements
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Issues by reviewing design changes made to production systems
  • Resolved Incidents/CR’s in service now from users with in SLA based on Priority incidents and closely worked with L1 support team to resolve incidents
  • Ability to understand business issues quickly and translate these into solutions on the OBIEE platform based on requirement.

Environment: OBIEE Apps 7.9.6.3, OBIEE 11g, and DAC for Informatica 9.1 and People Soft

Confidential, New York

OBIEE Developer

Responsibilities:

  • Involving in design, coding and testing different modules in GSEDW (Global Service Enterprise Datawarehousing).
  • Repository modeling: Worked extensively in the development of major Subject Areas in GSEDW (Global Service Enterprise Datawarehousing).
  • Developed business reports using OBI Answers and to display the reports in Dashboards.
  • Enhancing the existing modules as well as developing new modules, unit test configuration and delivering it to Test and Production environments.
  • Security implementation at both levels (Object and Data level).
  • Segmentaton: Worked on segmentation and coordinated with ORACLE expert services.
  • Developing business reports using Siebel Answers and to display the reports in Dashboards.
  • Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
  • Interacts with business clients to define, analyze, and deliver customer requirements
  • Taking leadership and responsibility in coordinating offshore development
  • Doing project scoping with other Siebel consultants to understand the project, making feasibility analysis and recommending project assignments
  • Provide high level analysis and solutions for any configuration defects
  • Provide architectural solutions for business requirement
  • Designing the data model and data flows process in Oracle EBS environment
  • Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
  • Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters
  • Developed many Reports / Dashboards with different Analytics Views (Drill-Down Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters)
  • Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
  • Implemented security by creating roles & web groups, checks with LDAP Authentication
  • Migrate RPD from Local Environment to Dev and UAT environment
  • Created complex informatica mappings based on users requirements
  • Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
  • Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions
  • Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
  • Running and testing various reports using OBIEE/Siebel Analytics
  • Perform production supports on existing dashboard requests including making enhancement, changes, and add-ons functionalities of the dashboard report
  • Extensively used Siebel Answers to support end users
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository

Environment: OBIEE 10.1.3.2, Oracle CRM (EBS) Siebel Analytics 7.x, CRM, Informatica PowerCenter 8.x/7.x, Oracle 9i/10g

Confidential

OBIEE Developer

Responsibilities:

  • Security implementation at both levels (Object and Data level). Segmentaton: Worked on segmentation and coordinated with ORACLE expert services.
  • Developing business reports using Siebel Answers and to display the reports in Dashboards.
  • Implemented Single Sign on Functionality in IVIEW.
  • Documented Unit tests Cases, Custom Table Creation Scripts and Technical Design Document (TDD) both RPD and ETL.
  • As a deployment manager involved in major releases on live by creating/chasing the Change Requests till it successfully implemented on production.
  • Reviews code and deployment process before going on-live to
  • Involving in design, coding and testing different modules in GSEDW (Global Service Enterprise Datawarehousing).
  • Repository modeling: Worked extensively in the development of major Subject Areas in GSEDW (Global Service Enterprise Datawarehousing).
  • Developed business reports using OBI Answers and to display the reports in Dashboards.
  • Enhancing the existing modules as well as developing new modules, unit test configuration and delivering it to Test and Production environments
  • Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
  • Perform production supports on existing dashboard requests including making enhancement, changes, and add-ons functionalities of the dashboard report
  • Extensively used Siebel Answers to support end users
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository

Environment: Siebel Analytics 7.x, CRM, Siebel CRM, Informatica PowerCenter 8.x/7.x, Oracle 9i/10g

Hire Now