Credit Suisse

• Enabled Single Sign On for OBIEE to allow authorized users to login automatically to OBIEE without entering user credentials.
• Customization of Login Screen, Logos in OBIEE
• Performance improvement by limiting the Queries from a Dashboard by Guided Navigation Section Property.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Designing K-Shell Wrapper Scripts, Automate OBIEE Jobs by NQCMD Prompt, Purging of Cache by NQCMD script automated jobs.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers. Built 3 Subject Areas, for Different business requirements
• Implemented Cache management by using Event-polling tables in database to optimize the performance.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/ iBots/Alerts, creating reports / Dashboards, cache Management/Monitoring, and building Metadata consisting of three layers (Physical Layer, Business Model & Presentation Layer) using OBIEE admin tool.
• Experience in 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).
• Identified most economical source and configured the content as a part of performance tuning.
• Worked on deployment of different OBIEE builds on LINUX, Production Server
• Responsible for migrating the web catalog and RPD from DEV, UAT and Training, Production environments.
• Implemented External table Authentication (Data level and Object level Security)
• Scheduled jobs for phone devices & Email.
• Worked on OBIEE 11g Installation, Functional requirements gathering for 11g.
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, analyzing data sources, creating interface documents etc.
• Well versed in using the security settings in OBIEE to set up Groups, Access Privileges and Query Privileges
• OBIEE Administration, Shared Services & Security Admin - Production Support

Environment: OBIEE 10.1.3.4,  Hyperion  Essbase 11.1.1.2. Control-M, Oracle 10g