SUMMARY

• Over 7 +years of IT experience in all phases of Software Development Life Cycle (SDLC) and having comprehensive background in End - to-End implementation of Business Intelligence using Oracle Business Intelligence (OBI)/ Siebel Analytics in Pharmaceutical, Marketing, Telecom and Finance domains.
• Expertise in Administration Tool and Presentation Services, BI Publisher and Scheduler, including Migration and Upgrading.
• Excellent Understanding of OBIEE 10g and 11g Architecture and upgrade process
• Proficient in configuring and managing Oracle BI Servers; Oracle BI Answers and Interactive Dashboards; iBots, Publisher; OBIEE plug-ins and Oracle Indicators
• Proficient in generating reports, creating dynamic Dashboards and Scheduling IBots.
• Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards / Reports.
• Expertise in creating BI Publisher reports using different logics in the templates.
• Experience in customizing OBIEE screens and reports using xml.
• Experience in Configuring BI Publisher and generated different types of reports using BI Publisher
• Experience in setting up Object level and Data level Security.
• Involved in the Data warehouse data modeling based on the client requirements.
• Working Knowledge in Configuring LDAP Authentication for Repository.
• Experience in customizing OBIEE screens and reports using xml.
• Experience in Configuring BI Publisher and generated different types of reports using BI Publisher.
• Experience in working with different operating systems like UNIX and Windows.
• Involved in Unit Testing, Integration Testing and User Acceptance Testing.
• Well acquainted with Software Development Life Cycle.

TECHNICAL SKILLS

Functional: Business Requirements Analysis and Process mapping

BI/OLAP: Siebel Analytics 7.x/OBIEE 10.1.x

DW/ETL Tools: Informatica Power Center 7.x/6.x

Database: Oracle10g/8i/ 9i, DB2, MS SQL Server 7.0/2000 and MS Access

Languages: SQL*PLUS, MYSQL, PL/SQL, Unix Shell Script, C, JAVA

Internet: HTML, XML, XHTML, Java Script

O/S: Windows 95/98/2000, Windows NT/XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. OBIEE Consultant

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales and Marketing Subject Matter Experts (SMEs), Business Analysts and Users.
• Performed the analysis of Cash Equities and Cash Balances Subject Areas to identify facts, dimensions and hierarchies of dimensions.
• Handled all Administrator responsibilities starting with Installation of OBIEE on different environments till code migration.
• Designed metadata repository using Administration Tool.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Created BI Publisher reports using Microsoft word plug in to design report templates.
• Implemented multiple logical conditions in a single RTF template.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Filters (global and local) and provided customized Prompts.
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment.
• Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.
• Implemented Security at Object Level and Data Level.
• Used Microsoft word plug in to design report templates in BI Publisher.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.
• Conducted user training to familiarize users to the new reporting environment.
• Worked on Migration to OBIEE 11.1.1.6 which includes Application Development Framework (ADF).
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up External table authentication to enable Single Sign on (SSO) for Users in Development environment leveraging Analytics Repository.
• Documented Business requirements/Functional Requirements document (As a BA role for OBIEE reports).

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0 & 10.1.4.2, Informatica Power Center 8.1, Windows XP

Confidential, Franklin Lakes, NJ

Sr.OBIEE Consultant

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI/Siebel Analytics Web.
• Integrated BI Publisher with OBIEE and developed reports in pdf and word formats.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.

Environment: OBIEE 10.1.3.3/10.1.3.4 , BI Publisher, Informatica Power Center 8.1, Oracle 10g, ERwin, TOAD, SQL*Plus, Sql*Loader, Windows, UNIX

Confidential, Indianapolis, IN

Sr.OBIEE Consultant

Responsibilities:

• Actively participated in interacting with BA and ETL team
• Implemented installation and configuration of Oracle BI EE 10.1.3.3/10.1.3.4 on UNIX environment.
• Documented the procedure for the installation of OBIEE on UNIX supporting the infrastructure.
• Created full Confidential Metadata repository and customized the metadata definition as per the requirement of the business.
• Integrated BI Publisher with OBIEE and developed reports in pdf and word formats
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment
• Customized OBIEE screen to affirm the functional requirements.
• Created reports against Essbase Cubes.
• Integrated OBIEE with Essbase Cubes and built various reports to meet the requirements.
• Configured OBIEE admin tool for integration tasks.
• Configured OBIEE scheduler and SMTP server for sending email alerts to users.
• Created the MUD Environment in order to implement concurrent development of the repository.
• Extensively worked on the catalog manager for the Migration of the Reports in Production.
• Solved the production and QA environment bugs in reports.

Environment: OBIEE 10.1.3.3/10.1.3.4 , Siebel ePharma 8.0.0.8, Oracle 10g, TOAD, SQL*Plus, Sql*Loader, Windows, UNIX

Confidential

Jr. Programmer

Responsibilities:

• Develop Informatica Mappings according to the requirements.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Creation ofTransformationslike Sequence generator, Lookup, joiner, Filter and Source qualifier transformations in Informatica Designer.
• Created Complexmappingsusing Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in the work flows using workflow manager.
• Provided productionsupportby monitoring the processes running daily.
• Developed Informatica mappings and also tuned them for better performance
• Created Informatica mappings withPL/SQL Procedures/Functionsto build business rules to load data.
• CreatedSchemaobjects like Indexes and Views.
• Experience in backup and restoring of Repository.
• Designed and developedOracle PL/SQLProcedures.
• Designed and DevelopedOracle PL/SQLandShell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning ofOracle PL/SQLScript.
• Designed and developedUNIX shell scripts.
• Developed mappings for policy, claims dimension tables.
• PL/SQL statements performance tuning.

Environment: Informatica Power Center 5.1.2,Work Flow Manager, Work Flow Monitor, PL/SQL, Oracle, FTP, TOAD, Windows 2000, IBM AIX4.0, Shell Scripts, SQL * Loader, Unix scripting.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Analyze, Design and Developed Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model / layers with dimensions & time series objects, presentation layers with presentation catalogs, LDAP security using variables etc.,.
• Designed and developed various Dashboards /Reports that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
• Configured & published Delivers / iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

Environment: Siebel Analytics 7.5, Informatica Power Center 6.2, Windows XP, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.