Viru Ponnam

Ph no: 480-***-****

e-mail: ada2jn@r.postjobfree.com

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 OBIEE 12C Cloud, Repository (RPD), Interactive Dashboards, OBIEE Answers, BI Publisher, Tableau security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.

4+ years experience on Oracle Fusion HCM, End to end implementation experience in Global HR, Compensation, Performance Management, Payroll, Talent Management, Profile Management and Absence management modules.

Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

Architecture experience in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.

Strong experience in developing OBIEE/Siebel Analytics Repository- three layers (Physical Layer, Business Model & Presentation Layer).

Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.

Working experience with Oracle Analytics Cloud Date lake edition, Data Storage for big data and Data Visualization

Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator.

Expertise in Fit Gap analysis to gather, define and document business requirements. Both for Data warehouse models and Business intelligence models.

Strong functional documentation skills, created BR110, BR150, MD50, MD70 and TE040 for the implementation of HCM Modules

Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.

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.

Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.

Gathered business requirements using standard questionnaire and performed fit-gap analysis by taking feedback from the business users iteratively.

Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Payroll.

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, 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 training 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.

Crating User Manual, end to end business user classroom training, Functional and Technical Dcoumentation along with Desktop user knowledge session for application usage

Technical skills:

TECHNICAL SKILLS:

Oracle EBS: Oracle R12 - Supply Chain Management SCM (OM, Shipping, INV, PO), Order to Cash, Oracle CRM, HCM (Core HR, Benefits, Compensation, Learning & Development, Succession Planning), Oracle Application Express (APEX)

Oracle Fusion: Oracle Fusion HCM 11g

Other ERP: Workday

GUI: OBIEE,TABLEAU,OTBI,FRS, JIRA, Forms 10g,9i/6i/5.0/4.5, Reports 10g/9i/6i/5.0/1.3, Crystal Reports,

Oracle BI Publisher.:

Operating Systems: WINDOWS XP, NT 4.0, WINDOWS 95/3.11, Linux, HP-UNIX.

Languages: Oracle PL/SQL, SQL * PLUS, PRO*C.

Tools: TOAD, SQL Developer, Unix/Linux shell scripts, BI/XML Publisher, PUTTY,

RDBMS: Oracle 11g, 10g, 9i, 8i, 8.X, 7.X, 6.X

Data Modeling: Designer (2000, 6i), Erwin 3.5.2.

Others: TOAD, SQL*LOADER, SVN, PVCS.

Education:

●Masters in Computer Science Engineering, NIT, Bhopal,India

●Bachelors in Computer Science Engineering, Nagpur University, India

●Agile training certification

Summary of projects:

Client: Houlihan Lokey Inc, CA May’19– Till date

Role: Sr. Oracle Cloud HCM/OBIEE/BI Publisher Consultant

Implemented Oracle HCM cloud Global HR,PPM, Compensation, Absence Management and Goal Management, Payroll offerings.

Working with Benefits & Compensation team to streamline the process. Data Loading/Conversions using HCM Data loader (HDL) to load Job, Grade, Worker data, Work relationships data, Salary info.

Report development experience with OBIEE,BI Publisher, Financial Reporting Studio(FRS),OTBI for Global HCM implementation. Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.

Working with Talent Acquisition team to load data BrassRing & generate several reports using Oracle Application Express (APEX).

Created several reports using OBIEE. Created schedulers to deliver report automatically.

Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.

Gathered business requirements using standard questionnaire and performed fit-gap analysis by taking feedback from the business users iteratively.

Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Payroll.

Performed Starter steps like Create Implementation Users, View All data roles, Load/Manage Geographies.

Involved in defining of eligibility profiles, time periods, absence types and absence plans as per the client requirement both Accrual absence and qualification plans.

Configured the approvals for various business processes as per business requirements for assignment changes and absence management.

Set up and Maintained Enterprise structure and Workforce structures. Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Tested all the task and business process flows related to Payroll, Global HR and Talent Management.

Involved in End-to-End testing of Global HR, Payroll and Talent Management.

Build Custom Security to HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.

Client: Volvo Inc, NC May’17– Apr’19

Role: Sr. Oracle Cloud HCM/OBIEE/BI Publisher 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

OBIEE 12C Cloud Upgrade and development, data visulaisation usage experience for sales and market performance application.

RPD development and Security level transformations for business user access and production support.

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.

Prepared data mapping/Field mapping documents between EBS to Fusion.

Prepared documentation for Reports, Extracts and Integrations/Interfaces.

Involved in validating functional workbooks for Global HR, Compensation, Goal and performance management.

Created Custom reports as per client requirement across the modules Global HR, Compensation, Goal and performance management.

Created HCM extracts for Fusion to EBS integration for person details, Contacts, Phone numbers.

Created HCM extracts for Third party system interfaces and updated fields status after extracting data by integration HDL with Extract.

Worked on End to End Conversion process from EBS to Fusion on data related to Global HR, Compensation and Payroll data.

Worked on fast formulas

Worked on performing the conversion on same Fusion pod multiple times with help of purge Person scripts and Disabling work structures using Key map tables (Source Key).

Created Ad Hoc Reporting for global market and language traslations, OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.

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 BI Publisher RTF Template 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., OTBI reports,estimates and reporting on Tableau for usage application, 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 a greater number of interfaces

Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle HCM,EBS R12,Oracle Business Intelligence(OBIEE)12c,Cloud,,Oracle 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

Client: KPMG, CA (End Client: State of Hawaii) Oct’14– Apr’17

Role: Sr. Oracle HCM BI /Publisher Consultant

Responsibilities:

Performed in-depth analysis and documentation of business logic and requirements for State of Hawaii, health care system and medicare application, HIPAA, EDI. 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

Interacted with client during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM

Ensure that the application meets the business requirements and system goals fulfill end user requirements, and to identify and resolve system issues.

Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Payroll.

Perform Starter steps like Create Implementation Users, View All data roles, Load/Manage Geographies.

Manage Enterprise HCM Information.

Set up and Maintained Enterprise structure and Workforce structures.

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Involved in the defining of absence plans as per the client requirement both Accrual absence and qualification plans.

Execute the Complete Payroll for the client as per the US Taxation having good knowledge on 401K reports and the US Tax related Elements.

Worked with Employee and Manager Approval hierrarchy in BPM .

Shacing Strong Knowledge on Data, Abstracrt roles.

Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.

Worked on fast fast formulas in Payroll and absence management.

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 for HIPAA and EDI transactional data 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.

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.

OTBI environments to get data and creating BI Publisher reports and sub templates

Involved in modification of local object mask to simplify the creation of a greater 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, BI Publisher 11.1.1.7.1/12.2.1.0.0,Template Builder, Oracle HCM, OBIEE 10G/11G/12C, HIPAA,EDIOracle BI Server, Tableau reporting,BI Publisher Enterprise, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Client: UTI Worldwide Inc., Portland, OR (Mar’12 to Sep’14)

Sr OBIEE Report Consultant

Responsibilities:

Install, upgrade and configure all components of 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.

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.

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 mart 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

Client: Fidelity Investments, Boston Jul’11– Feb’12

Role: 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.

Client: Boston Scientific, St. Paul, MN Jan’10– Jun’11

Role: 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 Training 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.

Client: Johnson Controls Inc, WI Jun’10–Dec’10

Role: 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

Contact this candidate