Stractive is the preferred partner of Oracle University for conducting Instructor Led trainings (ILT) and Live virtual classes (LVC) for all the Oracle Hyperion Courses. Stractive consultants  have around 5000+hrs of combined experience in conducting Oracle Hyperion Trainings. In the Middle East, Africa and Asia Pacific region, stractive is the one of the most preferred partners of Oracle University.

This Refinery plays a crucial role in the economic development as the sole supplier of the vital fuel that powers the Country’s economy. Stractive implemented Oracle Hyperion Planning & Budgeting and Hyperion Financial Reporting solution to overcome the challenges faced by the management and finance team. Our unified single platform solution helped client to eliminate the tedious exercise of submission of budgets by more than 40 department and 80 sections, copy & paste of complex business rules and formulas from one spreadsheet to another to have single version of truth.

Company has several key entities under it, each one submitting budgets through excel sheets. In the first phase we rolled out a CAPEX budget calculation model on Hyperion Essbase, where the budgeting process was still manual and decentralized. Recently, we are working on implementing Hyperion Planning after which they will start using a new CAPEX budgeting model based on Hyperion planning across their internal departments and business units. This will be a more streamlined and automated approach than the legacy Essbase based CAPEX model.

Client needed to create dashboards for MIS and corporate analysis. The MIS application used Outlooksoft prior to moving to a model consisting Essbase engine as the data source and Oracle dashboards for reporting. The reporting solution is so designed that the reporting will be done on the latest data available in the databases, which is input from the RDBMS database as well as forecasting data for certain KPIs input using standard input schedules. The solution also takes care of the requirement to input text KPIs and display them on the Oracle BI dashboards.

The government organization focuses on comprehensive housing, with commitment to provide affordable quality homes and vibrant communities within Singapore. They have a Hyperion Planning and budgeting implementation to Budget the group operations. Stractive Consulting is helping them manage the applications with an ongoing support and development activities.

Stractive implemented a Value Based Management ("VBM") and Customer Profitability solution, using Hyperion's Business Intelligence platform which was used as the single integrated platform for bank’s reporting requirement. VBM and the Customer Profitability solution helped bank to analyze and report various FTP, NPBT by country and sectors, total expenses, and Global Costs. Stractive was involved in designing a multidimensional database schema using Hyperion, based on user requirements. Several end user reports were also created by the Stractive team using the Hyperion Web Analysis application.

Stractive met their requirement by implementing an Analytic Solution on top of HFM by using Hyperion Essbase Extended Analytics and Essbase Integration Services. This integration makes sure that Agility can report on top of multidimensional data built form HFM’s relational sources. The Essbase cubes developed provides better data analysis through reports and dashboards and hence helps in effective decision making. Also there quarterly and monthly business reviews are now presented to the business users as dashboards for extensive reach and better analysis of financial data

They had their existing Business Intelligence solution for risk reporting running on Hyperion. Although the system provided key reports required by the users, the legacy architecture could not keep pace with the size of data growth the Bank was facing while expanding its business. Stractive proposed a far advanced solution over the existing Hyperion application, to fine tune and provide performance enhancements, which helped reduce the banks monthly data warehouse build cycles from 5 days to almost 2 hours. Furthermore, by rebuilding the architecture, the storage requirements for the bank also reduced by almost 90%. Both engagements justified substantial ROI and cost savings to fund the implementations. Stractive is currently involved in a long term contract with the Bank to maintain and support new developments on their BI systems.

Implemented production planning, raw material planning, financial planning and marketing planning. Full life cycle implementation was done using Hyperion Planning and created reports on financial reporting. This is one of the most recent implemented Hyperion Planning for a metals & mining company in Indonesia. Client needs an operational planning model in place to ensure optimization of production capacities with JIT inventory planning.