ObieeOac

Preferred skills and qualifications 7 or more years of experience in building and delivering analytical or higher degree in Computer Science Computer knowledge on OBIEE/OAC RPD in OBIEE/OAC Reports & Dashboard and/or Data Visualization Projects to Data Warehouse design Star Schema modeling. Build and manage the OAC RPD models to optimize data accessibility and performance. Create dynamic userfriendly OAC dashboards and visualizations that turn data into insights. Set up alerts and automate data flows to keep business teams informed in realtime. Collaborate on data warehouse design data pipelines helping shape how we store and manage data. Good understand on Snowflake/Oracle Hyperion/EPM Have a good broader business understanding and mindset while technically leading efforts in specific areas. Make effective judgments and choices on design and roadmap based on various considerations. Work with business and technical teams to understand needs and deliver effective OAC solutions. Troubleshoot and solve any issues that come up with data flows dashboards or OAC configurations. Stay current with OAC updates and best practices continually improving our analytics capabilities. Excellent knowledge in development of repository at all the three layers including Physical Layer Business Model and Mapping Layer and Presentation Layer. Knowledge in creating Logical columns Hierarchies (Level Based Parent Child) Measures Aggregation Rules Aggregations Time Series in Business Model and Catalog Folders in Presentation layers. Good Knowledge in security set up for reports and dashboards and OBIEE administrative activities. Experience on Oracle SQL database performance tuning by implementing Views Materialized views creating indexes. Strong interpersonal and team leadership skills