We provide IT Staff Augmentation Services!

Sr. Oracle Epbcs/oac/bi Consultant Resume

5.00/5 (Submit Your Rating)

EXPERIENCE SUMMARY:

  • Over 14+ years of experience in IT and 9+yrs Experience in providing end - to-end business intelligence solution by dimensional modeling design, developing and configuring Oracle PBCS,OAC(Oracle Analytics Cloud),FDMEE,Oracle SCM,FSCM,OBIEE 12C Cloud,Repository (RPD),EPM, Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
  • Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
  • Expertise in Oracle PBCS, Oracle EPBCS, Hyperion Planning, Hyperion Essbase, Essbase Administration Services(EAS), Hyperion Financial Close Management, Hyperion financial data quality management Enterprise Edition(FDMEE), Oracle Data Integrator(ODI), Hyperion Financial Reporting, Smart View, ASO/BSO Applications, Maxl, MDX, Calc scripts, Hyperion business rules, Dimension build rules, Data load rules, Groovy Rules and FR reports, SQL Server databases, and Oracle databases.
  • Extensive hands-on Administrative tasks such as installation and configuration of several Hyperion Products, server settings, backups& disaster recovery & client installations of Smart view.
  • Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
  • Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor, External Tables and Collections
  • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, Access privileges, LDAP authentication setup, External table and configuration of Multiuser Development Environment.
  • Experienced in usage of Disconnected Analytics and Siebel/Oracle Delivers for sending alerts via intelligence agents (iBots) to the dashboards for the end users.
  • Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
  • Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
  • Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
  • Experience in Installing, Upgrading and Configuring OBIEE, EBS R12,OBIA from 10.1.3.4.1 to 11.1.1.3.0 and from 11.1.1.3.0 to 11.1.1.5.0 and 11.1.1.7.x.
  • Experience in working with OBIEE 11g Web Logic Server, Enterprise manager Fusion Middleware, RPD and Webcatalog.Worked in the integration of Essbase with OBIEE to enable reporting on top of OLAP cubes and accomplish slicing and dicing of data.
  • Extensive experience in at all three layers (Physical, Business Model and Presentation) of RPD using the Oracle BI Administration.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, building Analytics Repository and Metadata Modeling consisting of three layers (Physical Layer, Business Model (Semantic Layer) & Presentation Layer, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Experience in business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
  • Hands on experience in customizing reports, filters and charts in Oracle Answers.
  • Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
  • Knowledge in Data warehousing development using ETL tools such as Informatica Power Center 7.x/ 6.x and developed Informatica Mappings and Workflows with Worklets& Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
  • Experience working with various Heterogeneous Source Systems like Oracle, Teradata, and Flat files.
  • Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
  • Implemented complex business rules in Informatica by creating re-usable transformations, robust mappings/mapplets.
  • Migrated Repository and Web Catalog from one environment to another environment.
  • Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
  • Provide HIPAA compliance requirements for Oracle Stack and Database
  • Experienced in creating interactive UI Design (Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design using HTML, XML.
  • Hands on experience on SAP BO, BICS, Tableau

TECHNICAL SKILLS:

BI: Oracle PBCS/OAC/EPM.FDMEE/Hyperion/ESSBASE/OBIEE Cloud12c/ 11g/10.1.3.4/EBS R12/Siebel Analytics8.0/7.8/7.7 EPM11.1.2/9.3

ETL: Informatica Power Center/Power Mart 8.6/8.1.1/7.1.4/6.2

RDBS: Oracle 10g/9i/8, ODI, BO, Teradata, Oracle Financials R12/11i (11.5.10/11.5.9/11.5.8 )

Modeling: Dimensional Data Modeling-R Modeling

Scheduling: DAC 7.8.5v, CVS, VMS

Languages: .Net, SQL, PL/SQL, ESSBASE, Hyperion, People soft

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS

Integration Services: Oracle SOA suite, Siebel CRM

Operating Systems: Ms-Dos, Win NT 2K Win XP, Red Hat Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle EPBCS/OAC/BI Consultant

Responsibilities:

  • Created and modified existing data forms as per reporting and planning submission requirement.
  • Created ads templates for loading dimensions in to EPMA dimension library.
  • Involved in creating Oracle Cloud PBCS, OAC and EPBCS(Financials) applications in accordance with existing 11.1.2.4 applications. Created Dash boards in PBCS using forms, FR Reports etc, POC for Valid Intersection in PBCS forms.
  • Prepared new feature documents for PBCS for FP&A users for their ease of PBCS use, knowledge on the metadata management and data integration with PBCS.
  • Automated tasks (metadata updates, data loads, import/export) using EPM Automate, Created Calc manager rules in both PBCS and On-Premise Planning.
  • Involved in Hyperion Planning development activities such as Webform, Calculation Manager Rules etc.
  • Worked closely with FPA users for successful UAT for Essbase applications, Developed and modified calculation scripts, business rules in Hyperion Essbase, Planning apps 11.1.2.4.
  • Created complex webforms with Validation rules and adhoc grids.
  • Extensive work experience on Business Intelligence solutions through the complete project lifecycle from requirements analysis, design, development solutions to implementation and delivery of the overall project using Essbase technology.
  • Strong experience in development, production support and administration-oriented tasks of Hyperion EPM products.
  • Worked on Migration project related to Hyperion Planning Classic Applications to Enterprise Performance Management Architect (EPMA).
  • Experience in writing complex Business rules and creation of business rule sets as per requirement.
  • Migration of applications and components in different environments by using utilities like LCM.
  • Experience in managing user/group security in shared services, creation of ASO/BSO applications.
  • Experience in pushing data from one application to other using Essbase replicated partition, archiving BSO data into ASO application also troubleshooting data related issues.
  • Creation of calculation scripts for currency translation, allocations and for complex calculations using calculation script editor.
  • Designed and modified Essbase database outlines for better performance and for dynamic calculations.
  • Created load rules for dimension building and data loading, comprehensive experience in developing scripts using MaxL.
  • Experience in application backup using LCM and MAXL in creation and modification of reports using FR studio.
  • Strong experience in scripting languages like VBScript and Batch script to automate the process.

Confidential, NC

Sr. Oracle EBS/OAC/EPM /OBIEE Consultant

Responsibilities:

  • Performed in-depth analysis and documentation of business logic and requirements. Developed high level design documents for EBS R12 Order Management, Financial reporting EPM, and analysis projects. Extensive experience in working with Multi User Development Environments
  • EBS R12Order release, Oracle Forms, shipment documentation, bill of lading, invoicesdesign and development using BI Publisher
  • 12C Cloud Upgrade and development, data visulaisation usage experience for sales and market performance application.
  • Deployed the RPD from MUDE to DEV, QA and production environments
  • Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.
  • Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.
  • Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
  • Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
  • Created schedules to seed and purge cache for cache management. Implemented security by creating roles and web groups, and defined Object Level and Data Level .Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
  • Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
  • Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G.Worked on RTF Template, OAF(Oracle Application Framework), and interactive template for migrating reports from 11G to 12C.Worked on scheduling BIPublisher reports basing on user requirement.
  • Performed monitoring and analysis on OBIEE report usage. Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.
  • Participated in the Modeling of several multi dimensional including surrogate key design and index placement.
  • Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
  • Used Oracle Data Integrator ODI to extract relevant data from Teradata and map it to Siebel interface tables.
  • Used Oracle Data Visualization Desktop to connect to OTBI environments to get data
  • Involved in modification of local object mask to simplify the creation of more number of interfaces
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle EBS R12, Business Intelligence(OBIEE)12c,Cloud,,O racle BI Server, BI Publisher Enterprise,Teradata, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Confidential, CA

Sr. EBS/OBIEE Consultant

Responsibilities:

  • Performed in-depth analysis and documentation of business logic and requirements. Developed high level design documents for reporting and analysis projects. Extensive experience in working with Multi User Development Environments
  • Deployed the RPD from MUDE to DEV, QA and production environments
  • Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.
  • Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.
  • Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
  • Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
  • Created schedules to seed and purge cache for cache management. Implemented security by creating roles and web groups, and defined Object Level and Data Level .Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
  • Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
  • Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G.Worked on RTF Templet and interactive template for migrating reports from 11G to 12C.Worked on scheduling BIPublisher reports basing on user requirement.
  • Performed monitoring and analysis on OBIEE report usage. Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.
  • Participated in the Modeling of several multi dimensional including surrogate key design and index placement.
  • Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Design and develop Essbase data cubes to reporting and forecasting.
  • Designed Essbase data cubes to support dashboard models.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
  • Used Oracle Data Integrator ODI to extract relevant data from Oracle EBS and map it to Siebel interface tables.
  • Used Oracle Data Visualization Desktop to connect to Oracle Cloud Application OTBI environments to get data
  • Involved in modification of local object mask to simplify the creation of more number of interfaces
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle Business Intelligence(OBIEE) 11.1.1.7/12.2.1.0.0 , EBS R12, BI Publisher 11.1.1.7.1/12.2.1.0.0 , Template Builder, OBIEE 10G/11G/12C, Oracle BI Server, BI Publisher Enterprise, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Confidential, Portland, OR

Sr EBSR12/OBIEE Consultant

Responsibilities:

  • Install, upgrade and configure all components of EBS R12,Oracle OTM logistics,Order management and shipment, OBIEE on Development, Test and Production server
  • Implemented security based on LDAP Authentication
  • Created mock-ups, prototypes, technical design documents, business (user) requirements documents, test documents, etc. to deliver DW/BI solutions.
  • Created design documents and ETL mapping specification documents for DW/BI solutions and provided estimates for the same.
  • Performed Data analysis and Data Profiling on data to understand requirements of data and business, to ensure data follows the defined standards and to identify data anomalies.
  • Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling
  • Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers
  • Migrated RPD, catalog and configured Active Directory Security on servers. Design and implement data in various layers including physical, business and presentation
  • Assist the teams in generating dashboards and reports properly Perform validation of data on the reports and monitor the performance status of the same
  • Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and tuning of mappings for better performance.
  • Used Normalizer transformation with COBOL sources stored in DB2.
  • Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
  • Created sequential batches and concurrent batches for sessions.
  • Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers
  • Created user level security for intelligence dashboards based on Business Requirement
  • Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
  • Developed various Interfaces, Packages and Procedures using ODI to load data from Flat file & Relational Sources to Data Warehouse.
  • Experience in ODI components like designer, topology manager, operator and on other ODI concepts Master Repository, work Repository, Project Models, sources, targets, Interfaces, Packages, Scenarios, Knowledge Modules, metadata.
  • Created users, groups, access privileges and query privileges using Security settings in OBIEE AdminTool Integrated BI Publisher with OBIEE.
  • Installed Clustered Oracle WebLogic, SOA, And Web Center. Installation of oracle application server infrastructure, middle tier, and business intelligence
  • Installed Oracle Identity Management Components. Developed ODI interfaces utilizing technologies such as Oracle, File, and JMS to move data from a source system to a target system
  • Developed and supported integrations using Oracle Data Integrator (ODI) to implement data and master data flows across multiple systems and technologies such as Oracle EBS, Teradata, etc.
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
  • Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.
  • Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.
  • Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition. Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).
  • Defined users, groups, access privileges and query privileges

Environment: Oracle Business Intelligence (OBIEE)11.1.1.7, BICS, OBIA (7.9.6.x), Manufacturing Analytics, Oracle BI Server, BI Publisher Enterprise, BI Publisher, TOAD, Oracle11, Oracle BI Presentation Server, OBIEE Administration Console, OBIEE Enterprise Manager, DAC, ODI, Power Center 8.6.1

Confidential, Boston

Sr. OBIEE (BI Publisher) Analyst

Responsibilities:

  • Experience with installation, configuration of OBIEE 11g, setting up the web logic server, with Hyperion EPM11.1.2 Smart view, Interactive reporting, dashboards,
  • Upgradation of OBIEE 10.1.3.4. to 11.1.1.5 and hands on experience with reports and dashboards development of OBIEE 11g environment
  • Analyzed, Designed, and Developed Metadata repository (RPD) level data modeling for Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Experience with OBIEE Publisher 11g REPORTS development, ODI working on Knowledge modules, Meta data navigator, Aggregate functions, BI scheduler settings and migration
  • BI Publisher "integrated” Reports integration with JMS(JDE) Server on Development, SIT, UAT and Production environment.
  • Gathering the requirements for Client Billing (FIABS) system for OBIA Financial analytics, interaction with the business manager for technical Specifications.
  • Designed Publisher reports in the HR Functional Client Billing and Site Billing modules.
  • BI Publisher reports are triggered by Oracle 10g database usage along with the real-time Production issues based on BI publisher schedule, setting up active directory and configuration for printing reports.
  • Developing SQL queries against data source, implementing security within reports that is integrated with OBIEE security Incorporating BIP reports on OBIEE Dashboards
  • Hands on experience with XML Publisher templates, template calling, hyperlinks and XLF files, e Text templates, XML conversion
  • Trouble shooting of BI publisher reports For Oracle BRM, bill revenue reports, check forms, purchase orders and Invoices through Database Transaction and SSRS, SQL Statements
  • BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
  • Generate XML data by creating data template, create report Layout Template in Word, Upload Template, Associate with View

Environment: OBIEE 11.1.1.x, BI Publisher, SQL, OEM, Oracle Hyperion EPM 9.1, Oracle EBS, ODI, SQL Development.

Confidential, St. Paul, MN

OBIEE Analyst

Responsibilities:

  • Analyzed, Designed, and Developed Metadata repository (RPD)level data modeling for Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Experience with installation, configuration of OBIEE 11g, setting up the web logic server, with Hyperion EPM11.1.2 Smart view, Interactive reporting, dashboards,
  • Familiar with migration of Micro strategy to OBIEE 10.1.3.4. and hands on experience with reports and dashboards development of OBIEE 11g environment
  • Ability to mentor small team with OBIEE11g development and deployment through development to Production environment.
  • Develops and delivers HR Analytics Ad hoc Discoverer Reports for business users to help facilitate system stabilization.
  • Defines Role to Responsibility mapping and develops Individual Plan (ITP) for users and Corporate HR Analytics groups; Performs change management duties for business entities.
  • Experience with OBIEE Publisher 11g REPORTS development, BI scheduler settings and migration
  • Customized Dashboard pages like Invoice Details and All Transactions in Receivables Dashboard.
  • Working on Invoices, Transactional reports , payroll exception, timesheets based HR, Financial analytics related environment.
  • Assists in Self Service HR Analytics and Self Service benefits configuration and troubleshoot customization issues.
  • Created logical data models, recognize source tables and columns, to build Micro Strategy Schema objects into Hyperion BRIO including Attributes, Facts, Hierarchies.
  • Acts as a liaison between business and technical team to define OBIEE Analytics requirements including Repository definition and Dashboards for managers and executives (role based).
  • Provides HR Analytics, Benefits and Salary base table and column information to technical team and assists them in defining OBIEE Repository requirements, and defines design and content requirements for Dashboards.
  • BI Publisher reports are triggered by Siebel Workflows and documentum tool usage along with the real time Production issues based on BI publisher scheduler and configuration for printing invoices and reports.
  • Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
  • Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) using Meta data navigator, OBIEE Google maps integration, Knowledge modules, implementation a to enable building the OBIEE Logical Layer
  • Experience with Oracle Data Integrator10g modules (Designer, Topology, Operator, and Security Manager)..
  • Used various Transformations like Lookup, pivot reports, Expression, Filter, Interactive graphs and Joiner for cleansing and consistent data.
  • Developed Siebel PP address verification process using integration object, Siebel EAI Adapter, EAI XML Converter, Java scripting and eScript
  • Trouble shooting of BI publisher reports and Invoices through Siebel Transaction Database and SQL Statements
  • Usage of OLAP SQL querying for daily transactions and invoices related production issue probing.
  • Identified key facts and dimensions for the design of the star/snow flake schema.
  • Designed conceptual data model , logical and physical data models using Erwin data modeling tool and documented analysis results in a logical format to be presented to the client .
  • Used reverse engineering to connect to existing database and created graphical representation and involved in script generation.
  • Analyzed Source System and determined the necessary data for the requirement definition.
  • Validated the model and checked for compatibility of data with response to questionnaire from analyst using SQL.
  • Created Meta data Repository and documented for Data Analysis in Informatica.
  • Extensively worked with the report designing and dashboards.
  • Worked with BI publisher and built the reports.

Environment: OBIEE 11.1.1.3/10.1.3.4 , PL\SQL, Oracle BI Apps 7.9.6, BI Apps 7.9.6.1(Financial Analytics, HR Analytics) Oracle Applications R12, General Ledger, Micro strategy, Account Payables, Account Receivables, Order Managements, Siebel tools, Oracle EBS 11.0.3, SQL Developer, TOAD.

Confidential, WI

Sr OBIEE/BI Publisher

Responsibilities:

  • BI Publisher "integrated" with Siebel 8.0 environment with integration on Development, SIT UAT and Production environment
  • Designed Publisher reports Financial Analytics, Responsible for designing plant-by-plant deployment plan for Financial Analytics,, testing strategy, and functional specification documentation.
  • BI Publisher reports are triggered by Siebel Workflows usage along with the real time Production issues based on BI publisher scheduler and configuration for printing invoices and reports.
  • Developing SQL queries against both OLAP and OLTP data sources Implementing security within reports that is integrated with OBIEE security Incorporating BIP reports on OBIEE Dashboards
  • Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
  • Hands on experience with XML Publisher templates, template calling, hyperlinks and XLF files, e Text templates, XML conversion
  • Trouble shooting of BI publisher reports and Invoices through Siebel Transaction Database and SQL Statements
  • BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
  • Generate XML data, create report Layout Template in Word, Upload Template, Associate with View
  • BI Publisher Report Maintenance Separate query, layout, and translation Report output
  • Data Logic Layout Translation BI Publisher
  • Worked on both OLTP and OLAP systems and even excel spreadsheets and pulled the data from them.
  • Identified key facts and dimensions for the design of the star/snow flake schema.
  • Designed conceptual data model, logical and physical data models using Erwin data modeling tool and documented analysis results in a logical format to be presented to the client.
  • Oracle BI Apps SQL Server Siebel CRM, E-Business Suite, PeopleSoft BI Publisher Data Source
  • BI Publisher Integration, create report layouts, report layout deployment and administration
  • BI Publisher Engine using XSL, BI Publisher Client, BI Publisher Engine, XSL Siebel Application Web Services, BI Publisher Server Siebel & OBIEE BI Publisher Client BI Publisher Engine XSL OBIEE Server Any Siebel Version Data
  • Scheduling and Bursted reports, wider range of Template types and output formats.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle EBS R12, Oracle BI Apps 7.9.6, Oracle 10g,Siebel tools.

We'd love your feedback!