SUMMARY:

• Fourteen years of experience as Oracle BIEE/BI Publisher /BI Cloud/OTBI/ Siebel /OTBI/BI Publisher/XML Publisher a nd experience in gathering Business Requirements, performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence using agile development techniques.
• Experience in working with OBIEE/Siebel Analytics 12c/11g/ 10.1.3.x. /Siebel Configuration/ EAI/EIM Applications includes
• Extensively worked on Cognos to OBIEE Publisher conversion and migration, scheduler, Hyperlinks, reports generation.BI publisher exp on XML Publishing, eText templates, configuration
• RPD Development(physical,Business,presentation Layers), Dashboard Development and security , Dimensional hierarchies, Expression builder, Timeseries wizard, Calculation wizard , Creating initialization blocks and repository, session variables .
• Aggregate Navigation - Creating aggregate tables using materialized views , Multiuser development, Merging and Importing Objects from different repositories, Experience in migrating metadata and web catalogue between different environments
• Clustering,Load Balancing, Configuring delivers, bots , Cache management, performance tuning at report level, database level . Installation,development,administration,production Support of OBIEE
• Experience in installing and configuring Oracle Bi Applications(informatica,DAC,OBIEE) and integrated with Oracle EBS, Oracle e-Business suite (Oracle Process Manufacturing, Oracle Inventory, Oracle Purchasing and Oracle Sales).
• Expertise in configuration of Oracle BI Analytics Repository, DAC (Execution Plans, Subject Areas, Containers, Design, Setup, Execute etc.,), Create/Manage Intelligent dashboards
• Expertise in working with Process Manufacturing , Financial, Sales, Marketing, pharma, HRMS, Time and Labor(OTL), Order management Analytics.
• Experience in BigData, Data Analysis & Warehousing using Informatica. Primavera, Strong understanding of Dimensional Modeling, Hyperion, Smart view Star and Snowflake Schemas and Dashboard Reports.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters,MICR fonts, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Knowledge on BIRT Framework and Web Java development.
• Worked Extensively on OBIEE Administration Tool, OBIEE Answers and Intelligence Dashboards and customized reports (Aggregations, Drilldown to meet client requirements.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, Bitmapped Indexes and Partitions.
• Production Support - involved in support, Administration, Migration, Maintenance, performance Tuning, Deliverables
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Excellent people management, team building, presentation, facilitation techniques, motivation & leadership skills. Ability to learn and adapt to new technologies,
• Coordinated with offshore development team members to resolve issues, Provided regular status reports and interacted directly with client leads.

TECHNICAL SKILLS:

BI: OBIEE12c cloud/ 11.1.1.9/1.6/1.5/ 10.1.3.4/ SSRS/ Siebel Analytics8.0/ 7.8/7.7/ /crystal reports/Cognos

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

RDBS : Oracle 10g/9i, EBS,OPM, SQl Server

Modeling : Erwin, Dimensional Data Modeling-R Modeling

Scheduling : DAC 7.8.5v, CVS, VMS

Tools : .Net, SQL,SSIS, PL/SQL, ESSBASE, Hyperion

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

Integration Services : Oracle SOA suite

Operating Systems: Win XP, Red Hat Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. 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 in OBIEE 12c Cloud Environments
• Oracle BI Publisher12C installation, setup and configuration, migration to various environments.
• OBIEE12c Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.
• BI Publisher reports are triggered by BigData usage along with the real time Production issues based on OTBI BI publisher scheduler and configuration for printing reports.
• 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.
• C onverting OTBI, Cognos, brio, PeopleSoft crystal reports in Oracle Reports and new reports. Using RTF and BI Publisher Engine with OBIEE Interface.
• Working on various BI Publisher Data model, Data structure, data entities and SQL interfaces for the application.Using bursting capability for Batch Reporting
• Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources
• 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.
• 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 Cloud 12c, Intelligence(OBIEE)12c, BI Publisher12c, Template Builder, O racle BI Server, BI Publisher Enterprise, SSRS, Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Confidential, CA

Sr. Oracle BI Publisher Report

Responsibilities:

• Oracle BI Publisher12C installation, setup and configuration, migration to various environments.
• OBIEE12c Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.
• BI Publisher reports are triggered by BigData usage along with the real time Production issues based on OTBI BI publisher scheduler and configuration for printing reports.
• Experience with Oracle BI Apps SQL Server, Financial Reporting studio11.1.2.3,, BI Publisher integration with BI presentation services environment.
• Working with state client for billing, report and notices generation using BI Publisher and integrating with Siebel environment.
• Developing templates related to, cconnector, notices, approval and denial documents.
• Working with the business users to resolve production issues related templates, xml conversions, XSLT transformations, binary decode and encode load data to test the layouts of reports.
• C onverting crystal reports into Oracle Reports and new reports. Using data structure, data entities RTF and BI Publisher Engine with OBIEE Interface. Working on various BI Publisher and SQL interfaces for the application.Using bursting capability for Batch Reporting
• Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources
• Develop and support forms generated using legal pre-printed forms through Oracle BI Publisher
• Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.
• Analyze Medicaid data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.
• Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher
• BI Publisher Integration with Siebel I/O’s, 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
• Involved with production support for Notices and reports.

Environment: OBIEE12c, 11g, BI Publisher 11g,Discoverer,, Siebel tools,, SSIS,Oracle OTL, Oracle EBS, SQ L Development

Confidential, FL

Sr. Oracle BI Publisher/Cognos Report Consultant

Responsibilities:

• BI Publisher installation, setup and configuration, migration to various environments..
• OBIEE Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.
• Conversion from Cognos to BI Publisher reports for Oracle CC&B usage along with the real time Production issues based on BI publisher scheduler and configuration for printing reports.
• Experience with Oracle BI Apps SQL Server, Crystal Reports BI Publisher, Conversion and Migration of report from BI Publisher integration with BI presentation services environment.
• Working with the business users to resolve production issues related templates, xml conversions, XSLT transformations, binary decode and encode load data to test the layouts of reports.
• C onverting crystal reports in Oracle Reports and new reports. Using RTF and BI Publisher Engine with OBIEE Interface. Working on various BI Publisher and SQL interfaces for the application.Using bursting capability for Batch Reporting
• Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources
• Develop and support forms generated using legal pre-printed forms through Oracle BI Publisher
• Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.
• Analyze Medicaid data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.
• Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher
• BI Publisher Integration with Siebel I/O’s, 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
• Involved with production support for Notices and reports.

Environment: OBIEE 11g, BI Publisher 11g,Discoverer,Oracle CC&B,, Siebel tools,, Oracle OTL, Oracle EBS, SQ L Development

Confidential, Portland, OR

Sr. Oracle BI Publisher Consultant

Responsibilities:

• BI Publisher "integrated" with OBIEE presentation services on Dev, QA. Prod environment.
• OBIEE Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.
• BI Publisher reports are triggered by Oracle 10g database usage along with the real time Production issues based on BI publisher scheduler and configuration for printing reports.
• Experience with Oracle BI Apps SQL Server, Oracle warehouse builder(OWB), BI Publisher integration with BI presentation services environment
• R eports and retrofitting process using Oracle conversion utility, data structure, taking 11i reports and migrating them to R12
• Developing templates related to Global Invoicing, Shipment and movement documents
• Working with the business users to resolve production issues related templates, xml conversions, XSLT transformations, binary decode and encode load data to test the layouts of reports. converting older reports crystal reports in Oracle Reports and new reports. Using RTF and BI Publisher Engine with OBIEE Interface. Working on various BI Publisher and SQL interfaces for the application.Using bursting capability for Batch Reporting
• Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views
• BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization
• Develop and support pixel perfect Freight Forwarding document / forms using Oracle BI Publisher with XML supersets, services and database as data sources
• Develop and support forms generated using legal pre-printed forms through Oracle BI Publisher
• Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.
• Analyze Freight Forwarding data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.
• Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher
• Generate XML data by creating data template, Create report Layout Template in Word, Upload Template, Associate with View
• Template translations to various languages including finnish, French, Swedish conversions of invoice reports
• Working with batch processing of printing environment, laser printing and dot matrix printin g for airway bill documents design and testing coordination with various levels of development aspects.
• Hands on experience with XML Publisher templates, template calling, hyperlinks and XLF files, e Text templates, XML conversion
• Trouble shooting of Oracle Discoverer , BI publisher reports setting up active directory and Invoices through Siebel Transaction Database and SQL Statements

Environment: OBIEE 11g, BI Publisher 11g,Primavera, Cognos,Oracle EBS, Discoverer,Crystal Reports, SQL Development

Confidential, Boston

Senior Oracle BI Publisher Consultant

Responsibilities:

• BI Publisher "integrated" Reports integration with JMS(JDE) Server on Development, SIT, UAT and Production environment.
• Gathering the requirements for CC&B,Client Billing(FIABS) system for 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.
• Conversion from crystal reports using the standard Report Wizard with the Oracle as the data source, Set up a database connection to an Oracle database
• Publish to Business Objects using the Publishing Wizard , Explain the differences between connecting to the Universe and directly to the Database
• Use the Select Expert feature and filter data at the report level, Group data using the Section Expert and format the report fields, Create a formula to combine several fields into a single field
• 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, Peoplesoft Time and labor(OTL), bill revenue reports, check forms, purchase orders and Invoices through Database Transaction and 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
• 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
• Oracle BI Apps SQL Server Siebel CRM, E-Business Suite, PeopleSoft BI Publisher Data Source
• BI Publisher Integration with Siebel I/O’s, 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 Bursting reports, wider range of Template types and output formats .
• Experience on developing data templates, RTF Templates and PDF template layouts using OBIEE Publisher tool

Environment: OBIEE 11g, BI Publisher 10g,11g,crystal reports, Oracle OTL, Oracle EBS, SQ L Development .

Confidential, MN

Sr.BI/XML(Siebel) Publisher(Report Writer)-EBS consultant

Responsibilities:

• BI Publisher "integrated" with Siebel 8.0 environment with integration on Development, SIT UAT, and Production environment
• Designed Publisher reports in the Clinical IS and Site Management modules.
• 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 sourcesImplementing security within reports that is integrated with OBIEE securityIncorporating 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 Oracle Discoverer , BI publisher reports setting up active directory 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.
• Oracle BI Apps SQL Server Siebel CRM, E-Business Suite, PeopleSoft BI Publisher Data Source
• BI Publisher Integration with Siebel I/O’s, 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 11g, Siebel8.1, BI Publisher, Oracle EBS, Oracle Discoverer, Oracle APEX, Siebel tools, SQL Developer.

Confidential, WI

Siebel Analytics BI Publisher consultant

Responsibilities:

• BI Publisher "integrated" with Siebel 8.0 environment with integration on Development, SIT UAT, and Production environment
• Designed Publisher reports and Invoices in the HR and Financial modules.
• 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 sourcesImplementing security within reports that is integrated with OBIEE securityIncorporating 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 Bursting reports, wider range of Template types and output formats.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g,Siebel tools, SQL server. .

Confidential, MN

OBIEE Developer

Responsibilities:

• End to end BI Publisher life cycle experience, installation, configuration, along with the development
• Creating new data models for SQL queries through BI Publisher and web services data models.
• XML templates. Crystal report s conversion, template calling, e Text Templates and XLF file development for BI Publisher for Report and Invoice printing purpose
• Hands on experience with BI Publisher Scheduler and Production related issue resolving ability
• Created Technical Specs based on functional requirement. Identified the Facts and Dimensions based on the design specification.
• 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.
• 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 Custom 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, Aggregations, 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.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Involved in upgrading the Siebel analytics web catalog to Oracle BI presentation catalog. Also 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,Cahe management, Creating Aggregate tables, Ibots etc
• Involved in coding several conversions such as AR transactions, Customers, AP Invoices, Items, Vendors, Purchase Orders, Price Lists, Fixed Assets and also changing several custom interfaces for 11ifor Oracle Process Manufacturing(OPM)
• Involved in installation and configuration of disconnected analytics.
• Involved in performance tuning at the report level,rpd level, dashboard level
• Configured Delivers- iBots to alert the users based on the requirement.
• 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, Oracle BI Apps 7.9.6, Oracle HRMS, Oracle 10g,Siebel tools, Oracle Essbase, Informatica Power Center 8.6 Windows NT and XP, crystal reports, SQL server 2005/2000,Oracle EBS R 12,Siebel CRM,SQL Developer, Teradata, peoplesoft