Our client is a global technology consulting and digital solutions company helping more than 300 clients succeed in a converging world. They go the extra mile for their clients and accelerate their digital transformation with Mosaic platform enabling their mobile, social, analytics, IoT and cloud journeys.
Our client is a USD 14 million company with 104,000+ professionals across the 5 continents, helping global customers with innovations solutions.
The Group operates in the key industries that drive economic growth, enjoying a leadership position in the construction industry, financial industry and technological.
We are currently searching for an Hyperion (Oracle EPMA) Analyst
Responsibilities
- Person will be responsible for the maintenance, enhancement and support Hyperion financial planning database (Oracle EPMA Hyperion version11 or higher) used for budgeting, forecasting and financial reporting purposes, and optimizes Hyperion capabilities.
- Design, develop and evolve existing Hyperion modeling and structure to meet current and future need. This will include working with process owners to identify continuous improvement opportunities and develop software solutions to support process effectiveness and efficiencies.
- Individual will also be accountable for managing projects and software throughout their respective lifecycles.
- Maintain, enhance and support the Hyperion financial planning database used for budgeting, forecasting and financial reporting purposes, and optimize Hyperion capabilities.
- Design, develop and evolve existing Hyperion modeling and structure to meet current and future needs.
- Create reports and web forms, support and train users, and maintain security.
- Performance tuning, upgrading, testing, server maintenance, back-up planning, security administration and migration.
- Providing support to the Hyperion user community.
- Automate Data loading and Dimension Build Process, Email notification Via ODI, Maintain the Topology and logical schema for ODI environment, Schedule the ODI packages in with help of ODI scheduling utility.
- Work with management to develop long-term plans for the deployment of IT solutions for the Financial Reporting, Planning and Budgeting system.
- Provide production support for existing applications ensuring responsiveness to customer requests and quality of work
- Ensure internal controls are followed and report exceptions immediately
- Remain at the forefront of industry practices and application development
- Demonstrate good communication, analytical and problem-solving skills to help identify, communicate and resolve system issues in order to maximize the benefit of IT systems
- Analyze the effectiveness and efficiency of existing business processes and business requests, and recommend solutions using system standards and best practices
- Conduct analysis of system specifications, configurations and develop appropriate documentation
- Perform solution designing, requirements definition, functional design, testing and implementation of IT solutions Support, assist and train the users on new modified system configurations highlighting the impact on business processes
- Monitor software product developments/trends to ensure productivity and competitive edge.
- Ensure data integrity and quality control procedures to ensure high quality accurate output.
- Work closely with onsite team, off shore team, managers and executives to ensure the release of high quality solutions
- Comply with regulatory and change control requirements and processes
Requirements
- Experience in Hyperion System 11.1.2.4 modules (Essbase BSO, Essbase ASO, Planning, Essbase Studio ,Financial Reports)
- Strong Experience with ETL tools - ODI, SQL Database, and Oracle Database. Good knowledge of SQL/Oracle query writing and analysis.
- Strong scripting experience in developing Calc Scripts, MaxL Scripts, Batch Scripts, reporting using Excel Add-in/Smartview custom utility/Financial reporting studio.
- Extensive knowledge in integrating MSAD and other LDAP technologies, LCM, Skilled in performance tuning, upgrading, testing, server maintenance, back-up planning, security administration and migration
- Extensive experience in building a Multi-Dimensional Database (MDDB) and in defining hierarchy, dimensions and formulas in Hyperion Essbase
- Understanding of Financial Planning processes and how they integrate with other areas of an organization
- Ability to perform all tasks in the implementation cycle, including business process definition, configuration and unit testing, support of user acceptance testing and post-live support
Language:
- English Intermediate
- Spanish Native
If you meet these qualifications and are pursuing new challenges that focus on delivering innovative solutions that increase business value, we’d like to talk with you today. Come be a part of the action at Sequoia Connect.