EXPERIENCE SUMMARY:

• Over nine years of experience as Oracle BIEE/Siebel /BI Publisher/XML Publisher/Oracle EBS / Peoplesoft and 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 wif OBIEE/Siebel Analytics 11g/10.1.3.x. /Siebel Configuration/ EAI/EIM Applications includes
• Extensively worked on OBIEE Publisher, 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 wif 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 wif Process Manufacturing, Financial, Sales, Marketing, pharma, HRMS,Time and Labor(OTL),Order management Analytics.
• Experience in Data Analysis & Warehousing using Informatica. Strong understanding of Dimensional Modeling, Hyperion, Smart view Star and Snowflake Schemas and Dashboard Reports.
• Extensive experience in configuring Interactive Dashboards wif drill-down capabilities using global and local Filters, 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,

TECHNICAL SKILLS:

BI: OBIEE 11.1.1.7/1.6/1.5/10.1.3.4/Siebel Analytics8.0/7.8/7.7/Discoverer

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

Languages: .Net,SQL, 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, Portland, OR

Sr. Oracle BI Publisher Developer

Responsibilities:

• BI Publisher "integrated" wif 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 aretriggered by Oracle 10g database usage along wif the real time Production issues based on BI publisher scheduler and configuration for printing reports.
• Experience wif Oracle BI Apps SQL Server, Oracle warehouse builder(OWB), BI Publisher integration wif BI presentation services environment
• Developing templates related to Global Invoicing, Shipment and movement documents
• Working wif 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.
• 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 wif 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 wif View
• Template translations to various languages including finnish, French, Swedish conversions of invoice reports
• Working wif batch processing of printing environment, laser printing and dot matrix printing for airway bill documents design and testing coordination wif various levels of development aspects.
• Hands on experience wif 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,JDE E1, Oracle EBS, Oracle BRM, Oracle Discoverer, TIBCO CLE, SQL Development

Confidential, Boston

Senior BI(Siebel analytics) Publisher Consultant

Responsibilities:

• BI Publisher "integrated" Reports integration wif JMS(JDE) Server on Development, SIT, UAT and Production environment.
• Gathering the requirements for Client Billing(FIABS) system for OBIA Financial analytics, interaction wif the business manager for technical Specifications.
• Designed Publisher reports in the HR Functional Client Billing and Site Billing modules.
• BI Publisher reports aretriggered by Oracle 10g database usage along wif 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 wifin reports dat is integrated wif OBIEE security Incorporating BIP reports on OBIEE Dashboards
• Hands on experience wif 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 wif 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 PublisherIntegration wif Siebel I/O’s, create report layouts, report layout deployment and administration
• BI Publisher Engine usingXSL, 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,JDE E1, Oracle OTL, Oracle EBS, Oracle BRM, Oracle Discoverer, Siebel tools, SQL Development.

Confidential, MN

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

Responsibilities:

• BI Publisher "integrated" wif Siebel 8.0 environment wif integration on Development, SIT UAT, and Production environment
• Designed Publisher reports in the Clinical IS and Site Management modules.
• BI Publisher reports aretriggered by Siebel Workflows usage along wif 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 wifin reports dat is integrated wif OBIEE securityIncorporating BIP reports on OBIEE Dashboards
• Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
• Hands on experience wif 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 wif 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 PublisherIntegration wif Siebel I/O’s, create report layouts, report layout deployment and administration
• BI Publisher Engine usingXSL, 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" wif Siebel 8.0 environment wif integration on Development, SIT UAT, and Production environment
• Designed Publisher reports and Invoices in the HR and Financial modules.
• BI Publisher reports aretriggered by Siebel Workflows usage along wif 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 wifin reports dat is integrated wif OBIEE securityIncorporating BIP reports on OBIEE Dashboards
• Siebel Business Component layer knowledge on financial analytics and sales environment and integration objects.
• Hands on experience wif 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 wif 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 PublisherIntegration, create report layouts, report layout deployment and administration
• BI Publisher Engine usingXSL, 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 wif the development
• Creating New data models for SQL queries through BI Publisher and web services data models.
• XML templates. template calling, e Text Templates and XLF file development for BI Publisher for Report and Invoice printing purpose
• Hands on experience wif 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 Autantication and SSO in Production and also other Autantication types (External table autantication 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. dis 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 wif 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, SQL server 2005/2000,Oracle EBS R 12,Siebel CRM,SQL Developer, Teradata, peoplesoft

Confidential, GA

Oracle Business Intelligence Analyst

Responsibilities:

• Captured Business Intelligent requirements from demonstrate out of box subject areas, Facilitate Out of box Metrics, 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 dat TEMPhas 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 wif 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, eBS, EPM, Linux.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Performed GAP Analysis between existing database tables and Business Process Requirements and recommended enhancements to Metadata Reporting in all 3 layers (Physical, Business and Presentation) for Sales Analytics and Call Center.
• Participated in the data analysis and validated the metrics used by the client’s business contact center.
• Enhanced existing Business Models & created customized Dashboards using Webcat for revenue ratio reports.
• Performed the detailed design of Reports/ Dashboards using Siebel Answers and Webcat and Analytical Data Model (Metadata/ .rpd) by performing Gap Analysis between the OTB reports and the new requirements.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Creation/ Re-building of Indexes and Managing Cache etc.
• Created hierarchy based Sales Card Dashboards for different Business units.
• Configured existing dashboards, metadata objects and report level security to set up position based functional dashboard access.
• Configured iBots to deliver analytics content based on schedule, automated iBots queries to obtain reports & sent notifications Alerts to Managers.

Environment: Siebel Analytics 7.8.2, Informatica Power Center 7.1, Oracle 9i, Sun Solaris.