Involve in creation/modify Metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layers.
Collaborate with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
Create star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
Set up security to authenticate users and grant permissions and privileges to appropriate users thus facilitating efficient web use in a large environment
Used Catalog Manager to migrate new Projects and enhancements from Development to Production environment.
Configure LDAP security through RPD in Admin Tool.
Create users and groups and setup the Data Level Security as well as Object Level Security.
Design and implement security object level security using custom roles and privileges
Design row level security based on client requirements and department sourcing
Performance trouble shooting including indexing, seeding, aggregation
Create drillable/guided navigation reports based on business requirements
Create performance reports (Usage tracking) to be reviewed by the technical team
Create iBots/Intelligence Agents for job-critical levels and auditable differences delivered to dashboards
Design, test and modify OBIEE security using roles, privileges in Enterprise Manager (EM), Administration Console to Access security