Summary:

• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Admin Tool by importing the required objects Dimensions, Facts Aggregates into Physical Layer using Connection Pool, developing multiple dimensions drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in the Presentation Layer.
• Experience in Educational, Pharmaceutical, Banking, Financial and IT industries.
• Experience in providing end-to-end business intelligence solutions by configuring metadata and building OBIEE/Siebel Analytics Repository consisting of three layers Physical Layer, Business Model Presentation Layer .
• Experience in interacting with the Business Users to analyze the business process and gathering requirements.
• Experience in installing and configuringOBIEE.
• Dedicated IT Professional with 8 years of IT experience in Analysis, Design, Development and Implementation of data warehousing which includes extensive experience in OBIEE formerly SiebelAnalytics and Data warehousing tools.
• Good Experience in Implementing and Installation/Configuration of Oracle Business Intelligence Enterprise Edition OBIEE , BI Apps entire stack on Windows and Unix/Linux environments.
• Extensively worked in setting up a Multi-User Development Environment MUD and using OBI Answers to run queries to test and validate the repository and Migration of reports to the Dashboards.
• Developed Reports and Dashboards with different analytical views using OBIEE Analytics.
• Hands-on Experience in configuring Interactive Dashboards with drill-down capabilities using Filtersand Dashboard Prompts, OBIEE Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, pages, folders, reports .
• Experience in setting up the usage tracking, creating variables/ Initialization Blocks.
• Performed Weblogic installation, domain configuration, clustering, load balancing and performance tuning.
• Implemented Data level and Object level Security.
• Experience with Authentication through LDAP and Authorization to the external tables.
• Modify existing ETL jobs in Oracle Data Integrator ODI .
• Experience with Oracle BI Applications, specifically Industry Analytics Health Care and Higher Education and CRM analytics.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Configured and scheduled Intelligence Agents ibots to send real-time alerts to the end users using Delivers and created reports using BI Publisher.
• Proficient in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/
• Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, Cache
• Management and materialized views.
• Good understanding of Software Development Life Cycle SDLC .
• Experience in Oracle 10g/11g, SQL Server 2000 and MS-Access.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for users.
• Ability to work in groups as well as independently and initiative to learn new technologies, tools quickly.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative efficient.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Summary:

Professional Experience:

Confidential

OBIEE Consultant

The Project is to develop reports and dashboards and provide production support for the citywide performance reporting project.

Responsibilities:

• Resolving remedy tickets and production support issues.
• Provisioning the users with the required level of access to the OBIEE reports and dashboards.
• Fixing issues related to the joins in the RPD.
• Collaborate with the business users and data owners to successfully implement and maintain an enterprise level business analytics and data warehouse solution.
• ImplementedOracle BI Apps CRM analytics to provide a better customer service experience.
• Responsible for the design, setup, deployments and maintenance of both the production and non-production environments.
• Troubleshooting production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency.
• Monitoring and resolving issues related to data through Informatica and DAC.
• ETL jobs creation customization using Oracle Data Integrator ODI .
• Modifying existing ETL jobs in Oracle Data Integrator ODI .
• Create, maintain and manage documentation for all datawarehouse and reporting development efforts.
• Provide on-call support for the support issues.

Environment: OBIEE/OBIA 10g/11g 11.1.1.5.5 , informatica, Oracle Warehouse Builder 11.2.0.4 with Oracle Data Integrator ODI, Remedy, DAC, SQL Server 2008, Siebel Analytics.

Confidential

OBIEE Consultant

The project is to develop BI reports and dashboards in oracle health sciences clinical development analytics OBIEE 11.1.1.5.5 and provide technical support to the production issues.

Responsibilities:

• Participate in user meetings to understand the requirements.
• Interacted with Subject Matter Experts SME , Business Analysts and Users for gathering the business and reports / dashboards requirements.
• Resolving tickets and production support issues.
• Development of reports according to the report request in Spectrum clinical trial management system and CDA and designing the respective report design specifications document.
• Development experience with Oracle BI Apps Industry Analytics Health Care , implemented the Clinical Development Analytics CDA and Oracle clinical Health sciences Clinical Development Analytics for developing the reports and dashboards as per the business requirements.
• Performed deployments from break-fix to production environment for APEX-CODA reports.

• Life-cycle support for migration efforts from development to QA to production analytics.
• Implemented the Direct database SQL in escalation tool reports for better performance of the report.
• Documented Configuration and design specific documents, Report request and report development specification documents for the new reports and for the enhancements made to the existing reports and dashboards.
• Significantly worked on the RPD development.
• Fixing issues that are related to the joins in the RPD.
• Experienced in using BMC Remedy Application tool for updating the incidents and problem tickets and tracking the issues.
• Performance tuning of reports which have considerably longer durations of returning results for both newly developed as well as those in production as part of production support.
• Knowledge on the right fax integration with BI publisher.
• Coordinate with the offshore team.

Environment: OBIEE 11.1.1.5.5, CDA 2.1 , SPECTRUM2.1.2, Oracle 10g 11g, SQL server 2008, LINUX, Windows 7.

Confidential

Sr. OBIEE Consultant

The University of Massachusetts system information services department is engaged in the effort of upgrading OBIEE 10g dashboard and reporting toolset and Oracle BI publisher 11g reporting tool along with other software packages supporting its Business Intelligence.

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Interacted with Subject Matter Experts SME , Business Analysts and Users for gathering the business and reports / dashboards requirements.
• Involved in the migration of OBIEE 10g to OBIEE 11.1.1.6.2.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Worked on OBIEE meta-data development. Configure repository Physical Layer, Business Logic and Mapping Layer and Presentation Layer and migration of reports and Dashboards.
• Developed Performance Tuning Strategies for optimizing the performance.
• Performed unit testing and system testing of all components of OBIEE Analytics.
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Developed adhoc reports as per the business requirements.
• Created Analytics Reports including Charts and Pivot tables using OBIEEAnalyticsfor the end users.
• Developed Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters and also using different Analytics Views.
• Developed different levels of Security set-up for the entities of the application on both Repository file and Web catalog file using OBIEE 11g.
• Created an initialization block to retrieve allowable values.
• Configured the BI Delivers scheduler to schedule reports.
• Involved in GAP Analysis and requirements gathering of the various work streams by meeting with the Business Analyst and Business Users and base lining the details.
• Performed OBIEE upgrade, testing and UAT.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Coordinated with offshore team and handled the situations very well.
• Attended daily review meetings and weekly status meetings.

Environment: OBIEE 10.1.3.4 11.1.1.6.2, Oracle 10g 11g, Informatica 7.1.3, SQL server 2008, LINUX, Windows 7.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• End to End repository creation, reports creation, prompts, dashboards and data modeling in OBIEE 11g on Oracle 11g database.
• Developed and customized some of the existing Dimensions Drill down Hierarchies Logical Objects in Business Model and Mapping Layer.
• Developed Presentation Catalogs in the Presentation Layer.
• Created Aggregations and Logical Based Measures in Business Model and Mapping Layer.
• Created Analytical Views Compound Layout, chart, pivot etc. and Global/Local Prompts to design the Dashboards.
• Experience in creating dimension table type1 and type 2 mappings.
• Knowledge on creating Informatica workflows.
• Configured clusters on Weblogic using the Weblogic Console.
• Created Security Settings in Oracle Administration Tool to Provide Access Privileges and Query Privileges and also managed security for Groups in BI Analysis.
• Enhanced the performance of Reports/Dashboards by implementing the Aggregate tables.
• Created Database Report Layouts Using BI Publisher Desktop Template Builder in MS Word.

• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.

• 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.
• Extensively involved in performance tuning.
• Implemented, Configured and Tested Data security and Dashboard security in OBIEE 11g.
• Configured the BI Delivers scheduler to schedule reports.
• Dashboards Implemented were for Financial Analytics, Procurement and Spend Analytics, Supply Chain Analytics. Some minor customization was done on the Dashboard level.
• Performed Order Management and Inventory Analytics.
• OBIEE BI Apps packaged analytics installation for demonstration purpose configuring DAC, setups and running processes .
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema .
• Attended defect review meetings and weekly status meeting.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4 11g, Oracle 10g 11g, Informatica 8.6, DBI 8 with EBS R12,Oracle e-Business Suite R12,Data Warehouse administrationConsole DAC , Oracle BI Publisher, Oracle Delivers, SQL, PL/SQL, and TOAD 6.3/7.0, Windows XP, UNIX/LINUX.

Confidential

OBIEE Consultant

Responsibilities:

• Configured and created repository using OBIEE 10.1.3 Admin Tool.
• Created numerous executive level reports. Dashboards were generated to provide insight into the marketing and financial data.
• Designed schemas using the fact, dimension and extension tables, by creating logical joins in the physical layer.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Designed and customized RPD's, Oracle Answers, Dashboards and Cache.
• Generated various Analytics Reports like formulary report and Direct Sales Report using global and local filters.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Created saved several BI Publisher reports by selecting an Analysis request as Data Source.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.

Environment: OBIEE/ Siebel Analytics 10.1.3.1/7.7.1 BI Answers, BI Dashboards, BI Scheduler , Oracle BI apps DAC , Informatica Power Center 8.6.1, Oracle 10g, SQL, PL/SQL, and TOAD 6.3/7.0, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Customized and developed repository, configured metadataobjects Subject Area, Table, Column and WebCatalogObjects Dashboard, Pages, Folders, Reports .
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives.
• Created templates for presenting results and Analytics and modified the SiebelDashboard using cascading style sheets.
• Built Repository at 3 layers Physical Layer connecting Data sources import schema , Business Model data mapping create Logical tables data source mapping Presentation layer level create presentation catalogs , create presentation folders, test and validate the model.
• Design Customize Siebel Answers Views charts, Create save Filters, Create Charts Tables in Siebel Answers.
• Created Users and user groups in Siebel Analytics web.
• Configured published iBots to deliver analytics content based on schedule, automate iBot queries to obtain Daily weekly Transactions to all Departments in Organization by Email.

Environment: OBIEE 10.1.3.4, Informatica Power Center 8.1, Power Mart, Oracle10g, DAC, SQL, PL/SQL, UNIX, HTML, Windows XP.

Confidential

OBIEE Consultant

Responsibilities:

• Interacted with Case Services Management business representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Identified the GAP's by analyzing the CS Data Mart instance and provided alternative solutionsas well recommended changes to database.
• Designed and developed the OBIEE/Siebel Analytics Metadata Repository .rpd using OBIEE/Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing Multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters using Presentation Services/Siebel Analytics Web.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository.
• Performing the benchmark for upgradation process from OBIEE/Siebel Analytics to Oracle Business Intelligence.

Environment:OBIEE 10.1.3.2, Oracle ware house builder 10g, Informatica PowerCenter 7.8, Oracle 10g, Windows XP.

Confidential

Siebel Analytics Developer

Responsibilities:

• Gathered requirements, functional and technical specifications and interacted with business managers and end users.
• Used Metadata Design Principles to design Repository .rpd based on business requirements and followed Best Practices.
• Localized Siebel for business users to support globalization for deployment.
• Set up Analytics Multi-User Development environment for developers.
• Built the Physical Layer /Business Model and MappingLayer/ Presentation Layer of a Repository by using Star Schemas.

• Configured facts, dimensions and Hierarchies.

• Implemented aggregate tables for better analytics performance.

• Implemented reporting cache to faster response time.
• Scheduled the developed reports according to client requirements.
• Developed custom dashboards and reports using Siebel Answers.
• Created proactive agents called iBots to alert the related team to notify about the business changes.
• Tested and validated the repository, reports and dashboards.

Environment: Siebel Analytics7.7, Informatica 7.1, Oracle 9i, TOAD, UNIX, Windows XP.