Summary

• Over 7 years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence BI applications using OBIEE/Siebel Analytics and OBIEE Apps.

• Extensive experience in OBIEE 11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, customizing and managing repository and Presentation services Answers, Dashboards Delivers , OBI/Siebel iBots BI Scheduler , BI publisher, BI RPD and Web-catalog administration.

• 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.

• Strong working knowledge in Metadata modeling in all three layers physical, BMM, presentation .

• Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
• Expertise in developing OBIEE repositories from scratch, and also many Reports/dashboards with different analytics views drill-down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters using OBIEE Answers/Dashboard.
• Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts.
• Extensive Knowledge on Oracle Delivers and Implemented schedule based iBots to deliver reports.
• Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2.
• Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.

Technical Skills

RDBMS : Oracle 10g/11g, SQL Server 2000/2005, MS Access.

Languages : C, C , SQL, PL SQL

ETL Tools : Informatica Power center 8.1/7.1 , Oracle OLAP

Analytics : OBIEE 11g, OBIEE 10.1.3.x, Siebel Analytics 7.8,

Tools/Utilities : SQL Loader, TOAD, SQL developer

Scripting : UNIX Shell Scripting, JavaScript

Web Languages : HTML, XML

Operating systems : Windows 98/2000/XP/Vista, Unix, Linux

Professional Experience

Confidential

OBIEE Developer

Responsibilities

• Assist the application teams with running Repository Creation Utility RCU to install the underlying database schemas.
• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making
• Perform reviews on the design and code frequently to ensure the project standards are being adhered to.
• Provide technical support to application development and test teams.
• Troubleshoot any issues with the deployment process, database issues, applications and development tools.
• Identify Process improvements and implement them.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/ImportDatapumputilities .
• Prepared the webcat and repository. Created security groups and application roles.
• Developed measure for time comparison using time functions, ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
• Expert in using OBIEE Analysis to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy.
• Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability
• Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables
• Worked on Repository .rpd , customized the RPD with the requirements of the End User. Designed and Developed the three layers Physical, BMM, Presentation
• Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Configured OBIEE and BIP with Oracle UCM Web Center Content
• Involved in trouble shooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments.
• Involved in documentation of environment using Visio tool.
• Applied the patches to the WebLogic servers.

Environment: OBIEE 11.1.1.7, Oracle BI Publisher 11.1.1.7 SQL,, Oracle Database 10g/11G, SQL Developer, RMAN,Windows2003 server, Red Hat Linux 5.2 and IBM AIX 7.1,Keypass,Oracle UCM 11.1.1.7. WebLogic server 10/11g ,HPserver automation tool , J2EE,Apache 2.2, Sunone,Sun Solaris, RedHat Linux 6, Anthill,Oracle 11g, MQ Client,Remedy.

Confidential

OBIEE Developer

Responsibilities:

• 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.4.1 Admin tool.

• Worked with Onsite/Offshore teams.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer created numerous executive level reports. Dashboards were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Created business reports using Oracle BI Answers as per requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Conduct impact assessment and determine size of effort based on requirements.
• Work with the team for customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation.
• Provide status reporting against the program plan or schedule.
• Keep the project manager and product committee informed of task accomplishment, issues and status
• Escalate issues which cannot be resolved by the team.

Environment: OBIEE 10.1.3.4.1, Oracle BI Applications 7.9.6.2/3, Oracle DAC BI Publisher SQL, PL/SQL, Oracle Database 10g, Teradata, Oracle EBS R12, Oracle 10g/11g, SQL Developer, Windows 2003 server and Red Hat Linux 5.2

Confidential

OBIEE Developer

Responsibilities:

• Part of an OBIEE configuration and development team, ensuring design, development and testing work is completed to standard and on time.
• Capture and document Management Information/Business Intelligence requirements from clients, via interviews/workshops, ensuring suitable balance of business needs and delivery feasibility.
• Design, configuration and documentation of Logical and Physical Data Model and ETL process mapping configuration.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer, external table security with session variables, tested and validated the business model repository level calculations using Oracle BI Administration tool.

• Developed several Dashboards and Reports using different Views Pivot Table, Chart and Column Selector, Narrative and so on , with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.

• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes and report changes.
• Preparation for and execution of Component, System and User Acceptance testing, including bug resolution.
• Creation of Reports, Dashboards, Customizing login screen, and Portal banner.
• Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.

• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

Environment: OBIEE 10.1.1.X, Siebel Analytics 7.8, DAC 7.9.5, ORACLE 11g, SQL, TOAD, PL/SQL,DB2, BI Publisher, XML, Oracle Reports, UNIX.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the Analytics repository Physical Layer, Business Model and Mapping Layer and Presentation Layer .
• Created Complex Joins, Alias Tables and Views.
• Tuned Siebel Analytics Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.

• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Siebel Analytics Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.

Environment: Siebel Analytics 7.8.5, Informatica 7.1.2 Power Center Designer, Workflow Manager, Workflow Monitor , Oracle 10g/9i, SQL, PL/SQL, SQL Server 2000/2005, Windows 2000/2003, ER Studio.