Perform routine maintenance and monitoring of Oracle Essbase applications(21c)
Design, develop, write and optimize complex Calc scripts, Business Rules and Report scripts to support budgeting, forecasting and reporting cycles
Infrastructure & Configuration:
Lead Essbase 21c installation , configuration and upgrade along with MSSQL metadata service configuration including setting up environments for development, testing and production.
Configure and manage metadata security and access across essbase applications
Administration and Operations:
Administrative tasks include data load monitoring, cube SyncUP, metadata updates and security administration.
Monitor system health, performance, resource utilization, and daily backup.
Business Analysis and Reporting:
Collaborate directly with business users to gather requirements for new reporting and analytical needs.
Implement solutions and enhance user experience using MDX scripts for complex reporting and analysis.
Provide support and assistance for the Oracle smartview usage to users.
Foundation/Shared service Security Responsibilities:
Manage and maintain all user access and security provisioning through the Hyperion shared service console.
Configure and troubleshoot integration with external user directories(e.g: LDAP/AD) for authentication.
