SUMMARY:

• Over 9 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts, BI and Transactional applications
• Extensive Business Intelligence and Data warehousing experience with Kimball and Inmon Methodology using OBIEE/Siebel Analytics and Informatica.
• Expertise in providing end - to-end business intelligence solutions using OBIEE/Siebel Analytics
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures, Levels, and Hierarchies
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool - Physical, Business Model and Mapping, and Presentation Layers, Time Series Wizard, Event Polling Tables and User and Group level Security
• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports as well
• Excellent understanding of Star Schema/Snow flake Schema methodologies and Dimensional Modeling
• Worked in different Industry Verticals and well experience in Sales, Finance, and Marketing Functional Areas
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards/Reports.
• Very good Knowledge developing Informatica Mappings / Mapplets and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Worked on Installation and up gradation of OBIEE 10g to 11g.
• Performed testing on OBIEE 11g/12c Beta version with halp of oracle. Identified bugs and reported accordingly.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel

TECHNICAL SKILLS:

• OBIEE 10g/11g/12c, Siebel Analytics (Repository, Presentation Services, Web cat, Scheduler, i-BOT’s), BI Publisher
• Business Requirements Gathering, Functional Requirements Gathering, Design Documents, AGILE, GAP analysis, User Interviews, Process Flow & Data Flow Diagrams, MS Project.
• Microsoft Project, Microsoft Office, SDLC Methodologies.
• Informatica (Power Center and Power Mart), OLAP, OLTP, Data Stage.
• Oracle Database, SQL Server.
• SQL*Plus, SQL Developer, C, C++
• Windows /NT/2000/XP, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, NC

OBIEE Architect/Lead

Responsibilities:

• Involved in gathering requirements for Finance/actuarial from business user.
• Designed Dimensional data model based as per teh reporting requirements and data flow from source system.
• Tuned long running queries generated via OBIEE. Generated desired SQL’s using OBIEE that are rendering fast on Database.
• Developed Metadata Layer (RPD) on ODS MODEL with teh necessary logic that involved creating teh Physical, BMM and teh Presentation layer.
• Created Dimensional Hierarchy for Dimensions, Logical Columns, Set up content levels for facts at different grain, Logical table Source for Prior period in BMM layer.
• Developed Complex Reports by using teh Different Views like Table, Pivot, Chart, Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Worked on onsite/offshore model.
• Performed Unit, Integration testing to validate developed reports.
• Implemented data level security using Session Variables.
• Worked on importing Essbase cubes & replicated teh reports in obiee against smart view reports.
• Upgraded 11.1.1.6.6 to 11.1.1.7 version on Exalytics, Implemented Custom Styles and Skins on new environments.
• Installed 12c on Linux machines, upgraded from 11g to 12c.
• Implemented AD and SQL BI group security configuration, Map viewer, Visual Analyzer.
• Worked with Oracle closely in resolving issues related post installation.
• Integrated Spatial Data with OBIEE. Created Themes/Styles/Tiles using map Builder for displaying default map in OBIEE at State and City level.
• Implemented times tens POC to improve performance on exalytics server.
• Implemented security as per teh user requirements.
• Invoked ibot’s thru autosys to kick off on specific days of teh month, Schedules Excel files to Sharepoint site on monthly basis via OBIEE Agents.
• Implemented write back for updating teh performance ratings.
• Performed Admin tasks like monitoring, Migrated RPD and catalog from one environment to another.
• Part of production Support team, resolved incidents based on teh severity.

Environment: OBIEE 11g/12c, Oracle DB 11g, Oracle SQL Developer, HPALM QC, Windows Server 2008/2012, Borland Star team, RTC Tool, Serena Release Manager, UNIX, Autosys.

Confidential, NJ

OBIEE Lead

Responsibilities:

• Involved in requirements gathering of teh various work streams by meeting with teh business user, performed Gap Analysis and Data Analysis.
• Involved in designing teh dimensional model and suggested as per teh reporting requirements.
• Developed Metadata Layer (RPD) for teh Enterprise Management Reporting work stream with teh necessary logic that involved creating teh Physical, BMM and teh Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Logical Columns, and Level based Measures and Aggregate navigation, Fragmentation in BMM layer.
• Developed Complex Reports by using teh Different Views like Table, Pivot, Chart, Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Configured IBOT’s for delivering reports as Power Point Slides to teh Share Folder.
• Implemented Security by creating roles & web groups using Active Directory in Conjunction with External Table
• Implemented Data level security and object level security as per teh requirements.
• Enhanced performance of Reports / Dashboards by implementing teh Materialized Views, Table partitions and managing Cache etc.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Created Data Models for BIP Reports using Sql Queries.
• Created an RTF template reports with a table and Chart using BI Publisher desktop in MS Word, Created and Publish multiple templates for a BI Publisher reports using teh native features of MS Word and Schedule and manage teh BI Publisher reports.
• Scheduled Ibot's using Tidal as delivery agent to Shared Folders.
• Responsible for Migration of RPD & catalog objects across all teh environments.
• Involved in complete SDLC life cycle by adhering to Client specific quality processes and align them with client quality Standards.
• Communicated teh Status of milestones and project status report with Strategic and Internal stakeholders.
• Performed Unit, Integration testing to validate reports and worked closely with teh users for enhancements to teh existing prototypes.

Environment: OBIEE 11.1.1.5,Oracle DB 11g, MS Office Visio 2003, Oracle SQL Developer, HP Quality Center 10.0,Windows Server 2008.

Confidential, NC

OBIEE Lead

Responsibilities:

• Involved in requirements gathering of teh various work streams by meeting with teh business user, performed Gap Analysis and Data Analysis.
• Involved in designing teh dimensional model and suggested as per teh reporting requirements.
• Created Mockup Reports based on teh requirements for showing teh capabilities of teh tool to business Users.
• TEMPEffectively managed ODBC connections and imported teh Physical tables, Primary keys and foreign keys as per teh Business Requirements for Leasing and Statistics and Valuations Dashboards.
• Developed Metadata Layer (RPD) for teh different work streams with teh necessary logic that involved creating teh Physical, BMM and teh Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Logical Columns, and Level based Measures and Aggregate navigation, Fragmentation in BMM layer.
• Developed Complex Reports by using teh Different Views like Table, Pivot, Chart, Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Configured IBOT’s for delivering alerts and for Cache Seeding.
• Implemented Security by creating roles & web groups using External tables.
• Implemented Event Polling Table for Cache management.
• Enhanced performance of Reports / Dashboards by implementing teh Materialized Views, Table partitions and managing Cache etc.
• Modified Styles and Skins on dashboards as per teh Users requirements.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Created an RTF template reports with a table and Chart using BI Publisher desktop in MS Word, Created and Publish multiple templates for a BI Publisher reports using teh native features of MS Word and Schedule and manage teh BI Publisher reports.
• Involved in complete SDLC life cycle by adhering to Client specific quality processes and align them with client quality Standards.
• Communicated teh Status of milestones and project status report with Strategic and Internal stakeholders.
• Created custom Reports in Usage tracking reports User Acceleration by creating initialization blocks to insert custom columns into database table.
• Created OBIEE HR analytics reports which are used to analyze On Boarding employee, Staffing details like Active Staff and LTD Staff, Employee Retention details, Demographics of teh employee like Admin Council, Area Headcount report, Leaves and Retirement details of employee.
• Involved in implementation of ETL by using Informatica for BI Apps (Financial Analytics) and also custom tables from People soft 9.1
• Used DAC to schedule and run teh Full and Incremental ETL loads and to schedule teh Informatica jobs in Oracle Business Analytic Warehouse
• Worked on upgrading OBIEE 10g to 11g (rpd & catalog) and deployments of web app for customizations.
• Fixed Upgrade errors in RPD and Reports as per new Standards.
• Worked on Custom links on dashboards for teh business to access halp document and Share Point.
• Developed KPI’s and Scorecard’s for user, which halp them reviewing their Business performance.
• Worked on integrating OBI with Mobile BI on Ipad and rolled out for users.
• Configured Map viewer and integrated NAVTEQ spacial data with obiee metadata.
• Developed Map with various data layers with custom images.
• Worked closely with Oracle in resolving teh product Issues.
• Tested existing dashboards and new functionalities on OBI 11.1.1.7.0 beta version.
• Performed Unit, Integration testing to validate reports and worked closely with teh users to resolve teh ongoing production Issues.

Environment: OBIEE 10.1.3.4.1 /11 g,Oracle DB 11g, MS Office Visio 2003, Oracle SQL Developer, HP Quality Center 10.0,Windows Server 2008,Borland Star team, UNIX.

Confidential, PA

Sr.OBIEE Developer

Responsibilities:

• Involved in requirements gathering of teh various work streams by meeting with teh business user and base lining teh details.
• I involved in designing teh dimensional model and I has given suggestions as per teh reporting requirements to Data Modeler.
• Implemented Dimensional modeling in teh database and created appropriate views along with DBA to acquire teh Metadata for teh given requirement.
• TEMPEffectively managed ODBC connections and imported teh Physical tables, Views, keys and foreign keys as per teh Business Requirements for Sales, Operations, Secondary Marketing and Top of teh House Subject Areas purpose.
• Developed teh repository model (RPD) for teh different work streams with teh necessary logic that involved creating teh Physical, BMM and teh Presentation layer. Also created hierarchies, variables, and Implicit Fact Column in teh repository.
• Created Dimensional Hierarchy for all Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Developed Dashboards/Reports using teh Oracle Business Intelligence Analytics platform for requirement analysis.
• Developed Complex Reports by using teh Different Views like Table, Pivot, Chart, Gauges, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Set up OBIEE Tool Level security for specific users who can access a part of teh tool, like just answers and Dashboards.
• Implemented Security by creating roles & web groups using External tables and LDAP.
• OBIEE reports performance improved by tuning long running sql. Created indexes, created Aggregate
• Enhanced performance of Reports / Dashboards by implementing teh Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Worked extensively with Custom Style Sheets.
• Duplicated S Oracle10 and SK Oracle10 folders to S Mortgage and SK Mortgage folders and modified CSS Tags as per teh Report and Dashboard requirement.
• Created Execution Plans, Subject Areas, Tasks and Repository Management using DAC.
• Reviewed teh ETL design done by ETL team and assist them for teh successful ETL run in DAC.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Extensive Experience in testing and Production Support.

Environment: OBIEE 10.1.3.4.1, Oracle DB 10g, Win 2003 Server,, DAC,Oracle SQL Developer, Mercury Quality Center, Informatica 8.6,Unix.

Confidential

OBIEE /Siebel Analytics Consultant

Responsibilities:

• Participated in gathering and analyzing teh Business Requirements in collaboration with theSales, Marketing andFinanceSMEs, Business Analysts, and users
• Prepared teh Analytical Functional Specification and detailed Design documents within a team of data modeling, ERP and BI experts.
• Performed teh setting up, installation and configuration of teh complete Analytics platform environment and teh required connectivity for seamless integration.
• Upgraded to OBIEE 10g from Seibel Analytics 7.8.
• Developed theOracle BIEEMetadata repository (.rpd)model with for Sales subject areas that involved creating teh Physical layer, BMMlayers, and Presentation layer with aggregates, dimensions, hierarchies & time series functions usingOracle BIAdministration tool. Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with LDAP Authentication
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing teh materialized views, partitions, re-building of indexes, overwriting teh sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to teh OBIEE Repository.

Environment: Siebel Analytics 7.8, OBIEE 10.1.3.4.1, Informatica Power Center 8.x, Oracle 9i/10g, DB2, HP UNIX