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:

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 ReportsOracle 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, PUTTYRDBMS: 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.

PROFESSIONAL EXPERIENCE:

Confidential, CA

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.

Confidential, NC

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,,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. 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,EDI Oracle 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

Confidential, Portland, OR

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

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

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.

Confidential, AZ

Sr. OBI EE Developer

Responsibilities:

• Created Technical Specs (SOA) based on functional requirement. Identified the Facts and Dimensions based on the design specification.
• Created Dashboard pages like AR Balance, Time & Expense, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level-based measures and defined level, attributes level keys .
• Extensively worked on admin tool , Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports , and cutomized widgets .
• Designed, developed and modified OOTB reports and dashboards.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non-Real-Time reports.
• Client was using intensive custom-built processes. My tasks involved everything from OWB and Workflow installation to the actual data conversion, migration to production, Installed and evaluated OBIEE and Oracle Data Integrator (ODI) 10.1.3.5.0.
• Implemented and automated batch integration processes that import Oracle ERP Customer, Agreement, and Licensing data, Symantec Partner data, and Marketing Opportunity data into Siebel CRM using Siebel EIM, PL/SQL, Java scripting and Unix shell scripts. Designed and implemented data migration solutions for merge and acquisition activities prototyped Siebel and Sharepoint integration using Siebel Web Service, EAI, Workflow, Business Service, iFrame, and soupUI.
• Configured users, roles and privileges in administration console.
• Worked on security for users based on LDAP Authentication and SSO in Production and also other Authentication types ( External table authentication and Database ) in other environments.
• Worked extensively on Custom Build Real-time (OLTP source) and Non-Real-Time Reports to enable Market/ Corporate Users to Order Management, Installation Management and Cash Management .
• Expertise in Financial Analytics, sales analytics, marketing analytics.
• Created the Custom Business model rpd from the scratch.
• Configured C ustom Business model to report on Oracle HRMS Sales Rep and Installer Pay Stubs, pay to procure(P2P) and Daily Commission Report . This involved creating dimensional hierarchies, Level based measures, Fragmentation content, Pivot reports, Aggregations, Interactive reports and complex joins. Configured Bridge and Helper tables .
• Configured Implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.
• Created various Static and Dynamic variables for different report and Security requirements.
• Involved in upgrading the Siebel analytics web catalog to Oracle BI presentation catalog. performed upgrading the existing repository for use with Oracle BI infrastructure.
• Responsible for Production support and involved in Migration of metadata and Web catalogue from Dev to UAT to production and also installation of OBIEE
• Involved in Clustering of Production Environment, Cache management, Creating Aggregate tables, Ibots etc
• Involved in installation and configuration of disconnected analytics.
• Involved in performance tuning at the report level, rpd level, dashboard level
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Monitored the daily Incremental Load in Production environment and fix any issues during the Load.

Environment: OBIEE 10.1.3.4 , Hyperion Essbase, Oracle BI Apps 7.9.6, (Financial Analytics, Order Management and Supply Chain Analytics) Oracle Applications R12, General Ledger, Account Payables, Oracle 10g, Siebel tools, Oracle Essbase, Informatica Power Center 8.6, BI Apps 7.9.5(Financial Analytics) Oracle Applications R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Windows NT and XP, AIX. SQL server 2005/2000, Oracle EBS 11, Siebel CRM, SQL Developer, Teradata, peoplesoft

Confidential

Siebel analytics Consultant

Responsibilities:

• Captured Business Intelligence requirements from demonstrate out of box subject areas , Facilitate Out of box Metrics , SOA applications , workshops and prepared high level and detailed design documentation .
• Installed and configured OBIEE, Informatica, Oracle Applications (eBS R12) and DAC.
• Took part in DBA work as well.
• Designed and Developed call report/ Revenue Star/Company Star/Motivator Star/Person Star/Usage Accelerator Company/Contact/CRM Usage schema diagrams based on Siebel CRM Customizations and Existing Motivator System Functionality .
• Developed Company Star Schema diagram that has the relationships to Entity/Risk Ratings/Marketing Source (Campaigns)/Primary Contact/Sales Rep (Primary/Secondary via W ORG PARTY Visibility)/Day Dimensions.
• Configured/Developed Physical Layer/Business Layer/Presentation Layer Objects including Custom Tables/ Alias/Keys (composite)/Foreign Keys, Business Layer Logical Display Folder/Sources/Complex Joins/Keys/Foreign Keys/Dimensions/Drilldown Keys for Division, LOB, Region, Team, Center hierarchies/Aggregations.
• Customized the reports to inmprove the look and feel .
• Developed BI dashboards for motivator dashboards including Tiering Report, Sales Performance etc., extensively used Dashboard , Pages , Sections , Add Column , Dashboard Prompts including Constrained Prompts with Default Session Variable Values Initialization, View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Dynamic Access mechanism via My/My Team/My Company Team/My Opportunity Team View modes, Add Explicit Permissions on Shared Folders via Catalog Manager etc.
• Customized Financial analytics

Environment: OBIEE, Oracle BI Platform 10.1.3.3.1, Oracle BI Applications 7.9.3, Data Administration Console (DAC), Siebel Answers, Siebel Administration Tool, Oracle BI Server, Oracle BI Scheduler, Oracle BI Presentation Server, Siebel CRM, Financial analytics, .