Sr Obiee Consultant
Current• Created connection pools, imported the physical tables and then creating aliases, defined joins and implemented authorizations in the physical layer of the repository.• Developed the necessary star schemas in the BMM layer and modified them in order to accommodate the new business requirements• Created different Hierarchies, Levels and implemented Business Logic by creating level based measures.• Developed reports using Drill across, Drill down using hierarchies like Geography, Position, product and also the dashboards based on (Groups, Aggregated Navigation, Time series wizard, Slowly changing dimension, caching strategy)• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.