SUMMARY:

• 7 years of experience in complete lifecycle of Business Intelligence Reports and dashboards using Siebel Analytics/OBIEE 11g/10g complete life cycle of Business Intelligence with Star and Snow Flake Schema Methodologies.
• Expertise in building repositories, developing Subject Areas, and applying security at object and data level in Administration Tool
• Strengths include Seibel Analytics development and Administration, attention to detail and problem solving
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE
• Experience with repository development, configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports . Added Metadata changes to the OBI/Siebel Analytics .rpd
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors
• Expertise in creating complex reports in Answers using various views
• Experience in BI Publisher 10g/ 11g, improved business functionality by creating actionable reports and customer facing documents, that help in speedy business decision making
• Extremely strong in OBIEE Metadata development
• Configured Hierarchies, Aggregate columns, Time series wizard in the Admin Tool.
• Extensive experience in creating Agent and scheduling them using delivers
• Strong understanding of data modeling and dimensional modeling, and designing Kimball's Star and Snowflake schemas
• Good at understanding business requirements and translating them into data warehouse dimensional modeling
• Expertise in interfacing with the Third party applications hosted in .NET, JAVA environment.
• Expertise in analyzing business issues and providing possible reporting solutions to end users
• Expertise in providing end-to-end user training and support and provided detail documentation
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file
• Good Knowledge ETL concepts in Informatica
• Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi-site development.

TECHNOLOGY:

• TOOLS: OBI EE 11x,10.1.3.x Administration Tool, Analytics, BI Answers, BI Dashboards, and Siebel 7.x Administration Tool and Analytics ,Tableau, QTP, Win Runner, Microsoft Excel, Test Directory, Microsoft Access.
• Systems: UNIX, Windows 9X/NT/2000/XP
• Databases: Oracle, Relational Databases, TOAD
• Languages: Visual Basic, SQL, HTML, C , Java
• Software: MS Project, MS Visio, MS Office, Lotus Notes

PROFESSIONAL AND PROJECT EXPERIENCE:

Confidential

OBIEE Developer

Responsibilities

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Worked with Collection and sales analytics to make sense of business performance by adding context to real-time business measure
• Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Designing the Technical Design documents by understanding the Functional Design documents for the sales performance.
• Experience in Dimensional Data Modeling and Technical documentation and presentations.
• Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
• Analyze data components and document Data Strategy to identify Key Metrics for Reporting.
• Installed and configured Oracle BI EE 11.3.3.4
• Responsible for Installing, Configuring and Administration of OBIEE 11.3.3.4 Repository for Physical, Business Model and Presentation services.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Responsible for setting up the environment including installation of OBIEE in all the environments.
• Configuring the Analytics repository RPD and implementing the security to authenticate and authorize Oracle users.
• Responsible for implementing OBIEE for the modules Retail and Sales.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Using Hyperion to define a dimensional view of the business
• Worked with historical depth and subject-area breadth sets the data warehouse apart from other information files, application databases, report caches, content stores, data marts
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Built Repository at 3 layers i.e., Physical Layer connecting to Data sources and import schema , Business Model / data mapping create Logical tables and data source mapping and Presentation Layer level create presentation catalogs .
• Created Business Facts Dimensions and defined Logical relation between them in BMM layer.
• Testing and implemented Stored Procedures, Triggers, Functions, and Packages at database level.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Also worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Extensively worked on Answers, Created Reports using different Analytics Views Pivot Table, Chart, Column Selector and Table .
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users
• Create/Manage Repository/Web Users and Groups and assigning permissions using OBIEE Administration Tool.

Environment: OBIEE Reporting 11x, SQL Developer, BI Publisher, SQL Loader, Oracle 12g, and Windows 2007

Confidential

OBIEE Developer

Responsibilities

• Gathered and refined requirements from the business users
• Installed and configured OBIEE Analytics
• Created business reports using filters with BI Answers as per client requirement Configured Usage Tracking in OBIEE.
• Developed front end reports
• Responsible for Daily/Weekly/Monthly on time report delivery to the end users
• Configured Analytics Agent and the Scheduler
• Configured Analytics Dashboard HTML style sheets to meet reports layout requirements
• Resolved application issues faced by users
• Interacted with users, developed and maintained Reports and Dashboards
• Designed and Developed new subject areas/ Customizations.
• Developed Star schema as per business requirements
• Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer, and created customized user views and set up catalog folders in the Presentation layer using administrator tool
• Configured the OBIEE Analytics repository rpd to implement organization wide data-level security.
• Configured report level security and user interface designs
• Trained in BI Publisher Standalone 11g as well as Integrated with OBIEE 11g, to answer business questions. Created customer facing documents Letters, Invoices, Application forms, and business documents per business requirements.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Environment: OBIEE Reporting 11x, Toad, BI Publisher, Oracle 9i/10g, and Windows 2000

Confidential

OBIEE Develop

Responsibilities:

• Used Metadata Design Principles to design Repository rpd based on business requirements and followed Best Practices.
• Configured Agents, write back functionality, action links and usage tracking, Microsoft Office Plugin as per the requirements.
• Localized Oracle BI for business users to support globalization for deployment Development/QA /Production
• Set up LDAP authentication, used Row-Wise Initialization blocks, and set web groups.
• Set up Analytics Multi-User Development environment for developers. Installed and deployed Oracle BI on Separate Multi Servers.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Creating dimensions, aggregations and levels using admin tool in the Business Model and Mapping Layer.
• Developed Dashboards/Reports using the Oracle Business Intelligence Analytics platform for requirement analysis.
• Implementation of different views of report i.e. View selector, Pivot table, Column selector, charts, Narrative etc.
• Configured facts, dimensions and Hierarchies.
• Implemented aggregate tables for better analytics performance.
• Implemented reporting cache to faster response time.
• Performed Unit testing and System Integration Testing to Validate the Report

Environment: OBIEE 11x, Oracle 11g Windows 7, Linux and TOAD.

Confidential

OBIEE Developer

Responsibilities

• Gathered and analyzed reporting requirements for the Sales and Returns departments.
• Involved in Data Modeling, Design Documents, and data warehouse
• Responsible for supporting and enhancements of OBIEE
• Responsible in analysis, design and implementation of the OBIEE Architecture, reports.
• Independently Designed and developed subject areas in the RPD
• Secured Dashboards and Reports by defining user roles
• Developed and scheduled iBots for delivering personalized reports to users on time
• Created reports with different views Compound, Chart, Table, Pivot, Ticker and Narrative
• Expertise in writing the queries using PL/SQL.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created and customized various Reports and Dashboards for various user groups
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository
• Define appropriate joins, calculations, dimensions and measures in the repository
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Assist in performance of Gap Analysis related to Data Models and data extracted in ETL's, and map client requirements into OBIEE/ Siebel Analytics functionality
• Implemented OBIEE security at the data and object levels
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables
• Created user manuals and troubleshooting guides
• Developed front end reports

Environment: OBIEE 10.1.3.4, Oracle 10g, PL/SQL and Windows 2003 Server.

Confidential

OBIEE Developer

Responsibilities

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Installed and configured Siebel Analytics
• Configured the OBIEE Analytics repository rpd to implement organization wide data-level security
• Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer, and created customized user views and set up catalog folders in the Presentation layer using administrator tool
• Developed Star schema as per business requirements
• Designed and Developed new subject areas/ Customizations.
• Interacted with users, developed and maintained Reports and Dashboards
• Applied Optimization techniques and tuned performance of the reports
• Configured report level security and user interface designs
• Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed front end reports
• Responsible for Daily/Weekly/Monthly on time report delivery to the end users
• Configured Analytics Dashboard HTML style sheets to meet reports layout requirements
• Resolved application issues faced by users
• Implemented caching to improve performance

Environment: OBIEE 10x, Oracle 10g, PL/SQL and Windows 2000

Confidential

Siebel Analytics Developer

Responsibilities

• Involved in creating connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Configured and Created repository using Siebel Analytic Admin tool
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Involved in created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/marketing/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
• Involved in created business reports using Siebel Answers as per requirements.
• Involved in modifications of physical, business and presentation layers of metadata repository using Siebel Analytics Administration Tool
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates

Confidential

Siebel Analytics Entry-Level Developer

Description:

Responsibilities:

• Gathered business needs by Interacting with business users for analytical data requirements.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard design.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Worked on the design of logical data model.
• Customized the Repository physical, BMM, and presentation layers .
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Worked on repository and session variables.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created materialized views and aggregates to improve performance.
• Customized reporting with Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation and automatic drill-down.
• Involved in repository migration, data and object level security in OBI Administration.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL and Windows 2000