SUMMARY

• Oracle certified Implementation Specialist - OBIEE 11g
• Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost-effective, high performance technical solutions to meet challenging business needs.
• Excel in strategic planning, project management, implementing best practice methodologies and consistently improving delivery times and service levels while reducing costs.
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services and BI Publisher
• Extensive experience in OBIEE security models implementation and OBIEE Environment administration (MUD creation, configuration and Support).
• Reporting solution design and OBIEE customizations to meet end users reporting requirements.
• Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Skilled with Caching & Mapping, data- level and object-level security, MUD, Integration Variables/Initialization Blocks configuration.
• Skilled expertise in creating reporting using BI Publisher from OLTP and OLAP.
• Highly skilled in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization
• Knowledge of implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Debugging, Optimizing and Performance Tuning of OBI (Siebel Analytical) Dashboards / Reports to improve performance at Database.
• Proficient in working on production and development environment in different RDBMS (in Oracle 10g/11g).
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Skilled in the ETL transformations using the tool Informatica
• Created mapping using the various transformations and triggered the mapping based on Oracle DAC
• Very good experience in Onsite offshore development model.
• Highly competent in OBIEE Upgrade from 10g TO 11g and end to end testing of the same.
• Expertise in integrating BI publisher reports with Siebel application
• Good domain knowledge & experience in Business Intelligence & Data Warehousing in CRM based Applications
• Hands on experience in installation of OBIEE (10/11G) and BI publisher (10g/11g).
• Experience working with new features Key performance indicators (KPI) like KPI watch lists, KPI Scorecards in OBIEE 11g.
• Expertise and hands on experience in development using OBIEE, Informatica, DAC.
• Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Worked on Microsoft office tool which is present in OBIEE.
• Managed day-to-day RPD, Scheduler &iBots, and Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Design & Customize OBIEE Answers Views & charts Create & save Filters Create Charts & Tables Bins in OBIEE Answers.
• Working closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
• Good analytical & problem solving skills.

TECHNICAL SKILLS

Business Intelligence: OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/ 10.1.3.4.1 , 11.1.1.9.0 , BI Publisher,ODI,Siebel Business Analytics 7.8.

DAC: DAC 7.9.4 / 7.9.6 / 7.9.6.1 / 7.9.6.2 / 10.1.3.4.1

ETL Tools: Informatica Power Mart, Informatica Power Center 7.1.4 / 8.6.1 , Oracle Data Integrator.

Database: Oracle 11g, 10g, 9i.

Siebel Applications: Siebel7.X/8.0,Siebel Call Center

CRM Verticals: Siebel eSales, Siebel e-Pharma.

Operating System: Windows 95/98/2000/XP, UNIX, Red Hat Linux, AIX, Sun Solaris OS, MS-DOS

Languages: C, C++, C#.

Internet Technologies: J2EE, JSP, XML, HTML, DHTML, XHTML, Perl, CGI, UML, JUnit

Version Control Tools: Clear case, SharePoint, Visual Source Safe, Quality Control (QC)

Siebel Analytics: Siebel analytics 7.7 / 7.8

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Lead Developer

Responsibilities:

• Design and Develop Active Data Warehouse Business Intelligence repository and dashboard reports.
• Setup data and object level security using custom application roles and groups.
• Business Intelligence Server Administration and maintenance DEV, TEST and PROD environment.
• Create deployment plans and manages migrations to higher environments.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Performed Unit testing and load testing for both the RPD and web catalog.
• Experience in setting up web catalog and administration
• Design and develop repository business model using Hyperion/Essbase Cubes.
• OBIEE Administration - Physical, Business Model & Mapping, and Presentation Layers, Answers, Dashboards, Catalog Management.
• Weblogic administration and maintenance.
• Setup DATA and OBJECT level security using custom application roles and groups.
• Design and develop OBIEE Hierarchies using active data warehouse attributes.
• Manage and monitor DAC tasks and ETL.
• Perform Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Performance tuning of Business Intelligence reports and Query optimization.
• Performed Unit testing and load testing for both the RPD and web catalog.
• End user training, support and documentation.

Confidential

OBIEE Lead Developer

Responsibilities:

• Dimensional modeling design and development.
• RPD development and testing.
• Oracle IDM SSO integration with Siebel CRM.
• Custom authentication based on GROUPS stored in external tables (Siebel), using custom SQL adapters.
• Setup DATA and OBJECT level security using custom application roles and groups.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Performed Unit testing and load testing for both the RPD and web catalog.
• Experience in setting up web catalog and administration.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
• Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.

Confidential, Westlake Village, CA

OBIEE Lead Developer

Responsibilities:

• Upgrade OBIEE environment to 11g and setup DEV, UAT, PROD
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables in RPD for the new dimension and Fact tables.
• Experience in Oracle BI Publisher Report Development (Template Building, Creating Data sets, XML generation from IO Created, Sub Templates, Parameterization, Scheduling, Translations, and Graphical Reports etc.)
• Implemented Scorecards and KPI for the sales and commission data.
• Expertise in integrating BI publisher reports with Siebel application
• Manage and monitor DAC tasks and ETL.
• Design and develop monthly customer statement (PDF) reports using BI Publisher.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Worked on Configuring MUDE (Multi User Development Environment) OBIEE scheduler, Usage Tracking, Security integration between rpd and BI Publisher, Repository Sever and Presentation Server configuration changes,and cache.
• Experienced in Data Modeling, identification of Facts and Dimensions, Creation of schemas (Star), Hierarchies, Documentation of Report and Dashboard Layouts, End User Demo/Documentation for Business/Report Users.
• Created Users, Groups by establishing a Connection to the existing LDAP Server by creating Initialization Blocks and variables for establishing Client Data level Security and object level security.
• Implemented different Caching techniques to improve the performance of BI server.
• Create and manage custom application roles and privileges.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI
• Experience in developing BI publisher reports from different data sources like database, flat file, xml, OBIEE answers. Also experience in developing reports via integration object method
• Implemented OBIEE Maps using spatial data to represent the sales trend nationally.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Used Informatica for Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Designing and implementing SCD - slowly changing dimensions types (1, 2 and 3)
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Managed day-to-day RPD, Scheduler &iBots, and Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.

Confidential, Memphis, TN

Senior OBIEE/OBIA Developer

Responsibilities:

• Infrastructure setup (DEV, UAT,PROD) - Installation and configuration.
• Dimensional modeling design and development.
• RPD development and testing.Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Performed Unit testing and load testing for both the RPD and web catalog.
• Experience in setting up web catalog and administration.
• Designed and customized OBIEE reports to meet the Confidential requirements and standards.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
• Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
• Implemented OBIEE write back functionality extensively to allow user interactive operations to modify and update data.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
• Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.

Environment: OBIEE 11.1.1.6.7 , Oracle 11g R2, Informatica 9.2.1, TOAD

Confidential, Los Angeles, CA

Senior OBIEE/OBIA consultant

Responsibilities:

• Requirements gathering, interacting with business users and documentations.
• Infrastructure setup (DEV, UAT, PROD) - Installation and configuration.
• Dimensional modeling design and development.
• RPD development and testing.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly Balances for each region & send alerts to upper management by using IBots
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Performed Unit testing and load testing for both the RPD and web catalog.
• Experience in setting up web catalog and administration.
• Design and development of monthly and Quarterly reports for Federal government.
• Designed and customized OBIEE reports to meet the FED requirements and standards.
• Customized OBIEE report outputs to Federal specifications and formats.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Customized and developed repository configured metadata objects (Subject Area Table Column) and Web Catalog Objects (Dashboard Pages Folders Reports).
• Developing the Facts Dimensions necessary hierarchies and the joins between the logical tables adding aggregates in the BMM layer of OBIEE Repository.
• Implemented OBIEE write back functionality extensively to allow user interactive operations to modify and update data.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities
• Created Dashboard prompts global filters and combined similar requests in OBIEE Answers.

Environment: OBIEE 11.1.1.6.7 , Oracle 11g R2, Informatica 9.2.1, TOAD

Confidential, Rochester, NY

OBIEE/Informatica Developer

Responsibilities:

• Leverage Sales and Service Analytics of BI Applications 7.9.6.1.
• Performed installation of Oracle Business Intelligence Enterprise Edition (OBIEE 11.1.1.6.1 ) in Windows (32 and 64 bit) and Linux Operating systems in Prod, Dev, Performance and QA environments.
• Collaborated with the business representatives and existing model’s development team in understanding the complexities of de-normalizing the current OLTP models into OLAP model
• Worked with out-of-the-box Oracle BI Applications 7.9.6.1 for evaluating the amount of customization that will be required with respect to the sales and service analytics.
• Analyzed the out of the box ETL mappings (SIL’s and SDE’s) and their dependencies.
• Identified the key fields that need to be additionally added for the current staging environments.
• Managed the MUD (multiuser development environment) for the project
• Customized the out of the box DAC containers - Siebel 8.0 verticals and scheduled the full and incremental loads as per the staging and target requirements.
• Integrated OBIEE in Siebel Application and configured SSO.
• Implemented the Change Data Capture mechanism in DAC to capture the changes using auxiliary tables.
• Customize Informatica mappings to include new dimensions and fact tables.
• Configure DAC Tasks as per Informatica mappings.
• Implemented Data Level Security leveraging the BI Apps Security Model.
• Customize OBIEE RPD to model the new changes and create reports accordingly.
• Create new Star Schemas and new Subject Areas to build data models based on Confidential Data Model.
• Perform GAP Analysis to implement the customization.
• Managed the onshore and offshore deliverables and maintained a highly organized and streamlined environment.

Environment: OBIEE 11.1.1.6.1 , AIX 5.3, Oracle 11g, Informatica 8.6.1, BI Apps 7.9.6.1, SQL, PL/SQL, TOAD.

Confidential

OBIEE/BIAPPS Developer

Responsibilities:

• Design and customization of DW Schema
• Created and modified Execution Plans and tasks using DAC to manage ETL jobs for data population
• Development and customization of ETL Mappings
• Implementation of object level and position based data level security
• Development and customization of OBIEE RPD
• Customized Star Schema in BI Repository to improve performance.
• Gathered user feedback to support enhancements during iterative development phase
• Implementing OBIEE metadata (RPD) design and development
• Designed the 3 Layers - Physical Layer, Business Mapping Modeling and Presentation Layer adhering to the Oracle Design/Build review standards and best practices
• Development of Dashboards and Reports
• Modification of reports based on end user feedback
• Generated test data for unit and system testing of ETL and OBI code

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6.1, DAC 10.1.3.4.1 , SQL, PL/SQL, TOAD.

Confidential, Easton, Pennsylvania

OBIEE Developer

Responsibilities:

• Responsibilities:Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Service and created logical tables and defined the complex joins for a business model.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Extensively involved in review of the Design documents with the peers(at different levels)
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments
• Extensively worked with Administration team to resolve the issues happened while migration to different environments.
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Involved in unit testing the reports.
• Extensively worked on the defect fixing, Technical document changes and migration process.
• Updating the status sheets on regular basis to know the status of the objects.
• Involved in MOM preparation
• Worked as a onsite & offshore coordinator
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, Informatica, Toad, Siebel CRM, DAC ( 10.1.3.4.1 .)