Design the architecture and advise hardware sizing, certification matrix and patch levels and patch levels as a prior step to Hyperion products implementation to ensure proper infrastructure. Advice Best practice layout of the Essbase, HFM, and Planning environments scoped between 100 & 1000 users at specific percentage of concurrency.
A subject matter expert conducts and validates business discussions with customers to understand current financial consolidations, planning and budgeting process. Convert the business needs into technical documents, conceptual design and measurable results. Lead and review the design functional prototype and assure requirements implemented successfully.
Review configuration, analyze and assess environment ensure proper methods and actions for backup and recovery used to avoid loss of a single file, loss of an application, or loss of an entire server.
Monitor and respond to problems and issues throughout the implementation, go live and during production operations. Apply Best practices and optimize performance to avoid OS, Database, Weblogic and Hyperion bottlenecks. Verify deployment configuration and processes minimize the potential for availability, integrity, or performance problems. Create Performance baseline and profile the environment.
A strategy to maintain Hyperion products patch levels and to enable IT Managers and Technical staff control the patch process. Facilitate patching decision by enabling short term and long term planning. Execute patching processes and enhance to integrate them with change management procedures.
Administrate, update and maintain Hyperion systems including exporting/importing of files into application. Deploy, automate, application support, prepare documentation and test reports. Monitor the data outputs and inputs, system usage and system message logs. Administrator is also responsible to organize and manage Hyperion system workflow.
Collaborate with business and technology resources to identify key business requirements. Deploy and maintain the Physical Layer, Business Model and Presentation layers in OBIEE repository. Ensure compliance with performance criteria through database SQL and metadata/report tuning.
Perform product gap analysis and specify customization scope to enhance prebuilt module capabilities from data integration to OBI metadata (RPD) to OBI presentation UI to the user community. Installing & configuring DAC and customize ETL to extend capabilities of OBIA modules.
Provides infrastructure and application support to various business lines. Technical implementation, support to development teams and assist in the maintenance and tuning of a complex OBI environment. Install, configure and manage OBIEE/OBIA environments including Reports & dashboards
Monitor business critical databases for health checks and business continuity. Optimize performance of small and large OLTP. Resolve O/S bottlenecks which may affect database performance.
Review current operating environments and system constraints. Provide detailed assessment of database installations, backup and upgrade procedures to Oracle Database 11g from prior releases to take advantage of Oracle's new version enhanced availability, reliability, scalability and cost efficiency.