SUMMARY:

• Over 10+years of total IT experience in Data warehousing implementation, experience in Business Intelligence using Oracle Business Intelligence(OBIEE) 10g and 11g, and Siebel Analytics. Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and documentation.
• Eight plus years of strong experience in OBIEE 10.1.3.x, Siebel Analytics 7.x modeling and developing Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring ETL routines through DAC on different environments like Development and Test environment.
• Implemented BI solutions for Pharmaceutical, Retail, Financial, Telecom, Manufacturing and other sectors for their various business processes i.e. Marketing, Sales, Services and Customer Care, Energy etc.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling.
• Responsibilities included installation of Oracle BI in a single and also in a distributed environment. Building of RPD application design for Physical, Logical (BMM), and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher, and integration to Microsoft suite of tools, testing, and deployment.
• Experience configuring Interactive Dashboards with 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).
• OBIEE- SECURITY- SSO- LDAP-- OID, External Table, OBJECT level Security, ROW level Security using INIT Blocks. Experience with Federated Query tuning strategies.
• Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata using Siebel Analytics/OBIEE.
• OBIEE 10.1.3.4.2 front end for reporting and dashboards.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
• Extensive Experience in Data Warehousing development using ETL tools such as InformaticaPowerCenter / Power Mart 8.x/ 7.x.
• Proficient in coding in SQL, PL/SQL, procedures/functions, packages, Explain Plan, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views usingSQL Plus, TOAD.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance.

TECHNICAL SKILLS:

• Oracle Business Intelligence (OBI) EE 11.1.1x and 10.1.3.x(Admin, Presentation Services, Publisher). Oracle Application Express 4.2.5
• Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), iBots, Scheduler,BI Publisher.Informatica 6.x/7.x/8.x (PowerCenter / PowerMart).
• Oracle 8i/9i/10g/11g,MySQL, Microsoft SQL Server2000.
• Toad, Putty, SQL Plus 10.x/9.x/8.x,ODBC.
• SQL, PL/SQL, C,C++, HTML, XML, Java, javaScript, UNIX shell script.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. OBIEE/BI Publisher Developer

Responsibilities:

• Worked on creating several templates/notices that are sent to applicants in BI Publisher using RTF templates.
• Participated in gathering and analyzing the Business Requirements.
• Extensively used BI Publisher 11.1.1.7 for generating various types of notices that are sent to customers.
• Provided the capability to download the reports in the user defined formats from BI Publisher.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
• Used BI Publisher 11G to create reports from an Answers Request, and from BI Server data
• Trained the off-shore resources on how to develop the reports using BI Publisher.
• Trained users on using the BI Publisher for running the reports in the web.
• Gathered the business requirements and specifications from end users, marketing executives, managers and sales people.
• Configured Repository (RPD) using Physical Layer, Business Model and Mapping Layer and Presentation Layer using the Oracle BI 11g Administration Tool.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created dimensions, dimension hierarchies, level based measures and defined level, attributes level keys.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used OBIEE Delivers and iBots. Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and cutomized widgets.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.

Environment: OBIEE 11.1.1.7, BI Publisher11.1.1.7,Informatica 9.1, Oracle 11g

Confidential, Sacramento, CA

Sr. OBIEE/BI Publisher Developer

Responsibilities:

• Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
• Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
• Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
• Used expression builder utility to create new logical columns/measures in the BMM layer.
• Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
• Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports via email using BI Delivers.
• Implemented OBIEE security using embedded LDAP and Microsoft active directory.
• Created new Users and assigned the users to the BI Administrators group in OBIEE 11g Administration Console.
• Used BI Publisher 11G to create reports from an Answers Request, and from BI Server data
• Created custom Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager.
• Implemented and Managed object level and data level security using custom User groups/Application roles.
• Migrated OBIEE web-catalog objects from Dev to Pre-QA by archiving and unarchiving features of OBIEE catalog manager.
• Drafted OBIEE deployment document and prepared RPD & Webcatalog objects for migration from Pre-QA to QA.
• Coordinated with the administration team on deployments and validated the migrated code.
• Used SQL Server Management Studio to debug the SQL query issued during report execution.
• Coordinated with the QA team on defect fixes and on deployments for retesting the dashboards.
• Involved in the implementation of Usage Tracking reporting to monitor the user activity.

Environment: OBIEE 11.1.1.7, BI Publisher11.1.1.7,Informatica 9.1, Oracle 11g, Siebel 8.2.2.2

Confidential, Palo Alto, CA

OBIEE Lead

Responsibilities:

• Worked on Change Requests (CR’s) and modified the RPD and complex reports accordingly.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like revenue-opportunity using Star Schema and Snowflake Schema.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created user groups and implemented security using external table authentication.
• Customized new subject areas and included new tasks to load custom tables.
• Configured iBots to alert the management and sales teams as per their requirements.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Developed Interactive Dashboards with Prompts and added Forecast Measures which generate forecast values.
• Developed custom reports/Ad-hoc queries using Analysis and assigned them to application specific dashboards.
• Configured Web Catalog Objects (Dashboards, Pages, Filters, and Reports).
• Configured users, roles and privileges in administration console.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Executed Test cases in all phases of testing, Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Performed Report Validation and Integration Testing and manipulations using SQL.

Environment: OBIEE 11.1.1.6, BI Publisher11.1.1.6,Informatica 9.1, Oracle 11g, BI APPS 7.9.6.3

Confidential

Sr. OBIEE/BI Publisher Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications, and generating reports for theEmployment and Administration (ETA), Unemployment Insurance (UI), Unemployment Compensation for Ex-service members (UCX), and Unemployment Compensation for Federal Employees (UCFE) programs.
• Worked closely with business users to ensure completeness of requirements.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like benefits and revenue using Star Schema and Snowflake Schema.
• Extensively used BI Publisher 11.1.1.7 for generating various types of reports.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created dimensions, dimension hierarchies, level based measures and defined level, attributes level keys.
• Enforced Criteria based navigation to achieve better SLA on adhoc queries based on products, customer origination, and industries.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured iBots to alert the management and sales teams as per their requirements.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Worked on OBIEE Administration Tool for customizing and modifying the Physical layer, BMM and Presentation layers of the repository (.rpd).
• Worked extensively on OBIEE Answers to create the reports as per the business requirements.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used OBIEE Delivers and iBots.Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.

Environment: Oracle Business Intelligence 11.1.1.5, Oracle 11g, Oracle BI Publisher 11.1.1.5, ODI 11.1.1.5.0

Confidential, Newbury Park, CA

Sr. OBIEE Developer

Responsibilities:

• Gathered the business requirements and specifications from end users, marketing executives, managers and sales people.
• Worked on OBIEE Administration Tool for customizing and modifying the Physical layer, BMM and Presentation layers of the repository (.rpd).
• Worked extensively on OBIEE Answers to create the reports as per the business requirements.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used OBIEE Delivers and iBots.Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Created user groups and implemented security using external table authentication.
• Created dimensions, dimension hierarchies, level based measures and defined level, attributes level keys.
• Involved in Clustering of Production Environment,Cache management, Creating Aggregate tables etc.
• Implemented conditional guided navigation to alter the interactive dashboard content dynamically.
• Used the Catalog Manager and maintained the Analytics web catalog tomanage dashboards & answers.
• Created iBots and Delivers to send alert messages to subscribed users.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Performed Dimensional modeling, identified Fact tables to store Measures and Dimension table to store business attributes, before ETL.
• Involved in the different stages of the design process starting form source definition to monitoring and verifying the Workflows for extraction, transformation and loading data.
• Extensively used Source Qualifier, Connect & Unconnected Lookup, Expression, Filter, Joiner & Update Strategy transformations.
• Performance Tuning of database, sources, targets, mapping and session was performed.
• Developed the Unit & Integration test cases scripts.
• Executed the Unit & Integration Testing scripts.

Environment: Oracle Business Intelligence 11.1.1.3 and 10.1.3.4.2, Oracle 10g, SQL Server XML, UNIX, ER-win 4.0, Oracle BI Publisher 10.1.3.4.0.

Confidential, Bentonville, AR

Sr. OBIEE Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Gathered requirement and analysis for contact center telephony customized analytics.
• Work closely with business users to ensure completeness of requirements.
• Preparing MD50 and MD70 documents for the new functional requirements.
• Working on the BI publisher reports, dashboards, adhoc reports.
• Implemented Security by creating roles & web groups using LDAP Authentication.
• 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.
• CreatedTest Cases based off of the design specifications.
• Createdmock reports as per the user requirements.
• Developed liaison with the Business to translate Business issues into IT solutions.
• Created adhoc reports and dashboard mock up as per the requirement.
• Wrote SQL Queries to test the transformations.
• Aggregate Navigation-Creating aggregate tables using materialized views.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Performed Report Validation and Integration Testing and manipulations using SQL.
• Exposure and knowledge of ETL transformation using ODI.

Environment: OBIEE 10.1.3.4, Oracle10g, ODI,SQL, SQL*Plus, Toad, BI Publisher.

Confidential, Plano, TX

OBIEE Developer

Responsibilities:

• Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance meta-data
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and Created repository using OBIEE 10.1.3 Admin tool.
• Responsible for migrating the web catalog and RPD from DEV to DEVINT.
• Developed various trending reports to analyze the revenue generate by products and sales reps.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created dimensions, dimension hierarchies, level based measures and defined level, attributes level keys.
• Enforced Criteria based navigation to achieve better SLA on adhoc queries based on products, customer origination, and industries.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured iBots to alert the management and sales teams as per their requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Developed Custom INFORMATICA Mappings to implement Cycle Time reporting on Audit Trial Capability provided by SIEBEL CRM.
• Worked on transformations like Source Qualifier, Expression, Filter, Lookup, Update Strategy, Sequence generator, Joiner, Router, Aggregator transformation.
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Checked the source, target and mapping bottlenecks to tune the ETL process performance.
• Performed Unit tested for mappings before adding new developed sessions into the existing batch.
• Integration tested the entire batch after including the individual sessions.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked on BI Publisher.

Environment: OBIEE 10.1.3.3, OBIA, SQL Server 2003, SQL, SQL*Plus, TOAD, Informatica 8/7.1

Confidential, New York, NY

OBIEE Developer/Siebel Analytics Consultant

Responsibilities:

• Involved in Full project life cycle implementation for PPCE Data Warehouse.
• Identified the granularity level of the data required to be available for analysis.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using Siebel Analytics Server Admin and Web tool.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL.
• Developed PL/SQL procedures for complex business logics like to calculate measures inward, outward premiums, claim payments and reserves.
• Involved in Reconciliation Process while testing loaded data with user reports.
• The efficiency of the Informatica workflow sessions was increased by running sessions in parallel, key range partitioning of the sources.
• Identified and solved numerous technical and operational problems in the Data mart design and ETL implementations.
• Involved in the development of UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.

Environment: Siebel Analytics/OBIEE, Oracle Application Server Release 3 (10.1.3), OBIEE 10.1.3.3, Oracle 9i/10g, SQL, PL/SQL, Informatica Power center 7.1, Windows 2003 Sever.

Confidential

Oracle Developer

Responsibilities:

• Created and customized database with appropriate table spaces to increase the performance.
• Created stored procedures and triggers to view, update and enter the check-in and checkout procedures.
• SQL Loader was used to convert the data from the Excel to oracle tables.
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Sub-queries and joins were extensively used in stored procedures.
• Created database triggers to automate the transactions that take place online.
• Used dynamic SQL to find out the availability of tickets.
• Optimize the SQL statements using hints and created SQL scripts to tune performances and make backups.

Environment: Oracle 8i/7i, PL/SQL, Visual Basic, ASP, HTML, JavaScript, VB Script