Summary:

• Over 7 years of IT experience in analysis, design, development, testing, implementation and maintenance of various operational as well as BI applications.
• 6 years of strong experience in OBIEE, Siebel Analytics Admin Tool, Analytic Web, Presentation Services, Publisher and Scheduler.
• Proficient in building analytical repository, business models, generating reports, and creating dynamic Dashboards using Oracle BI / Siebel Analytics.
• Expertise in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring OTB metadata, Answers, Delivers / iBots, creating Interactive Dashboards with drill-down and drill-across capabilities, Security groups, access / query privileges , Web Catalog Objects Dashboard, Pages, Folders, Reports , cache monitor, and building Repository consisting of three layers Physical Layer, Business Model Presentation Layer using Oracle BI / Siebel Analytics.
• Good in validating the BI reports/dashboards by preparing the Test Plans Cases.
• Experience in Siebel CRM development/configuration.
• Knowledge of Extraction, Transformation Loading of data to Data Warehouse using Informatica Power Center.
• 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
• Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi site development

Skills Summary:

EXPERIENCE

Confidential

OBIEE 11g/Informatica Developer

• Translate the business defined metrics and KPI's to OBIEE key Facts and Dimensions.
• Developed Informatica ETL mappings get data from Oracle source system to dataware house
• Developed incremental ETL mapping to get incremental data for nightly loads.
• Performance tuned source qualifier quires in Informatica mappings to get data faster.
• Design and development of OBIEE RPD, report and dashboards.
• Data Reconciliation and validation of OBIEE RPD, reports and dashboards with Business Users.
• Responsible for documenting the design and test results.
• Support and Maintenance of all OBIEE Reports, Dashboards and Applications.

Confidential

OBIEE 11g/BI Publisher/Siebel Developer

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Participate in the development of detailed design requirements.
• Develop Dashboards and Reports so as to meet the Functional Requirements.
• Use the Admin Tool to develop the 3 layers physical, BMM, Presentation in the Repository
• Create connection pools, physical tables and defined Primary key foreign key joins, complex joins in the physical layer of the repository.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Create dimensions, dimension hierarchies, levels, level based measures and define level, attributes level keys.
• Create new logical columns in the BMM layer and create various calculation measures using the expression builder utility.
• Customize/create presentation layer catalog folders, to show different views of the business model to different users and assign group permissions to the catalog folders.
• Format columns in the request and use various filtering options as and when needed.
• Customize prompts to avoid excessive data population in Reports and Graphs.
• Modify the UI for the look and feel of the reports.
• Perform Assembly and Unit testing on various Subject areas.
• Configure Intelligence dashboards by adding included and embedded content such as links/images, HTML objects, folders and drilldowns
• Create global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Create Agents iBots and configured Interactive dashboards to alert the users as per the requirements.
• Conducted testing/validation and debugging the applications using SQL scripts and log files.
• Maintained the Analytics web catalog using Catalog manager to manage Dashboards, Answers and Delivers.
• Work on improving the dashboard performance, readability, and security.
• Provide solutions and fixes to complex issues in reporting, dashboards, repository and security.
• Develop new or change existing SQL queries against Siebel CRM data sources for BI publisher .
• Define different data set used for developing the BI publisher reports like SQL and WSDL/Web Service files.
• Create different templates for different Types of invoices and service agreements used for billing and agreements.
• Create BI publisher .xlf translation file for different regions and languages.
• Document technical design for solutions for BI Publisher Reports.
• Integrate BI Publisher reports in Siebel CRM application.
• Coordinate with Administrators and testers/Business Users during code migration and validation.
• Track and update defect status in remedy system.
• Validate report data against Siebel CRM application for data consistency between applications.
• Check for BI reports scheduling in BI Publisher and scheduler database.
• Configure correct symbolic URL and Report Parameters in Siebel CRM for BI Publisher reports integration.
• Configured SiebelCRM Applets, Bussiness Components, Fields and Controls using Siebel Tools.
• Other technical duties as needed for the completion and delivery of the NxGen Reporting system.

Environment: OBIEE 11g/10.1.3.4.2,BI Publisher,Siebel 8.0, Oracle 9i/10g, Microsoft Suite, Remedy, BI template Builder.

Confidential

Siebel Analytics/ OBIEE Consultant

• Gathered and documented user requirements, Business Requirements and System Requirements from Business users
• Installed and configured Siebel Analytics/OBIEE in Development, Testing/QA, and Production environment and integrated with Siebel CRM.
• Upgraded Siebel Analytics 7.8.2 to OBIEE 10.1.3.2.
• Installed and Configured Disconnected Analytics/OBIEE repository and WebCAT set up database extract for remote users in Siebel and Synchronize Disconnected Laptops.
• Installed and Configured BI Publisher and integrated with MS Word to create BI Publisher report
• Configured Usage Tracking to track usage of reports by users and Subject Area etc.
• Configured BI Scheduler for scheduling Ibots to deliver reports to users.
• Configured LDAP security in OBIEE for user authentication to work with Siebel CRM
• Configured OBIEE repository for Hyperion Essbase database
• Imported the Hyperion Essbase Cube in Physical Layer, deleted the tables not required for reporting.
• Created presentation tables from Hyperion Essbase Cube as logical tables.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer to customize the existing business models and also developed new models.
• Created aliases and opaque views in physical layer.
• Developed session initialization blocks and variables for data level security.
• Created business model and designed a dummy fact model for the OLTP data model.
• Defined outer joins and logical keys in the business model and put filters to restrict data to only a particular business group.
• Created presentation tables as per Business Area definition in OLTP Screen
• Worked extensively in configuration and development of the Siebel Analytics/OBIEE Web Catalog Reports, Filters, Prompts, and Dashboards
• Created reports in BI Answers depending on business requirements using different views such as view selector, pivot table, table, chart, Metrics Reports etc.,
• Defined object level security by giving permissions to dashboard pages and prompt sections to different user groups.
• Extensively created BI Publisher reports, defined data source, created parameters for prompts and created BI Publisher .RTF Templates for repeated grouping data for different fields in the report.
• Converted BI Answers report to BI Publisher reports for online OBIEE and Vice Versa for OBIEE Disconnected environment
• Worked closely with testers in preparing test scripts, establishing test data, executing test scripts, and recording defects during informal and formal testing in HP Quality Center
• Used HP Quality Center for updating defects fixes and status.
• Created and maintained documents, Report Validation Document RVD and Installation verification document to provide the procedures for set up, implementing and maintaining the system and to provide documented instructions for operations associated with the system.
• Worked with production support team during go live and stabilization period. Handled release activities for Siebel Analytics/OBIEE.
• Trained end users on OBIEE reports and how to build adhoc reports by choosing the right combination of presentation layer columns
• Received Lilly External collaborator award for outstanding performance in the US OneLilly project.
• Received Center of Excellence award for outstanding performance in the US OneLilly project Release 2.

Environment: Siebel Analytics 7.8/OBIEE 10.1.3.4, Oracle 9i/10g, InformaticaPower Center 8.1.1, Microsoft Suite, BI Publisher, Siebel 7.5/8.0, HP Quality Centre.

Confidential

Siebel Analytics/OBIEE Consultant

• Configure analytics repository with logical dimensional modeling using Star Schema Facts and Dimensions .
• Customize and modify the physical, business and presentation layers of metadata repository using Siebel Analytics Administration Tool.
• Create connection pools, physical tables, define joins and implement authorizations in the physical layer of the repository.
• Develop Analytics Reports including Charts and Pivot table's Compound layout using Siebel Answers.
• Modify the customer and product hierarchies by assigning custom attributes to various levels in the hierarchy tree structure
• Create dimension sources for each level of aggregates and specify aggregate levels for each source.
• Create the reports as per the client requirements using Siebel Answers.
• Provide customized prompts and filters to avoid excessive data on Reports.
• Create effective dashboards by including guided navigational links and drilldowns
• Manage security - Create groups in the repository, add users to the groups, grant privileges explicitly and through group inheritance for each subject area and dashboards.
• Develop business models to display in the presentation layer for query

Environment:

Siebel Analytics 7.8.4, Oracle 9i, Windows 2k.