Hfm Consultant

Tekskills Inc.; Chennai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tekskills Inc. in Chennai seeks an experienced Hyperion/Financial Consolidation expert to support HFM systems, perform data loads, metadata updates, and routine maintenance. You will apply MaxL scripting, Essbase tools, and DRM for reliable consolidation and reporting.

Responsibilities include troubleshooting data integrity, supporting budgeting/forecasting, and creating documentation for system designs and SOPs. A strong SQL/PLSQL background is required, with excellent communication skills.

Qualifications

• Experience with Hyperion related modules and metadata management is required.
• Strong SQL/PLSQL skills for data handling and troubleshooting.
• Familiarity with DRM, data loading, and metadata updates.

Responsibilities

• Provide daily system support for HFM with high availability and performance.
• Assist with budgeting, forecasting, and consolidation processes.
• Troubleshoot data integrity issues and access problems in HFM.
• Manage FDMEE integrations and data hierarchies in DRM.
• Design and maintain financial reports using HFM and Smart View.
• Create technical documentation including SOPs and tests.
• Support application enhancements and patch management.

Skills

HFM architecture

HFM calculation rules

Financial planning & consolidation

FDMEE & ODI

SQL & PL/SQL

HFM, Essbase, Smart View, HFR

Essbase ASO/BSO, MaxL scripting

Performance tuning

Communication & documentation

Tools

FDMEE

ODI

MaxL scripting

Job description

Role & responsibilities

Deep understanding of HFM's architecture, features, and metadata management.

• Proficiency in writing, debugging, and optimizing HFM calculation rules.
• Strong understanding of financial planning, forecasting, and consolidation processes.
• Hands-on experience with tools like FDMEE, ODI, or similar.
• Proficiency in SQL and PL/SQL for data management and troubleshooting.
• Experience with HFM, Essbase, Smart View, and Hyperion Financial Reporting (HFR).
• Knowledge of Essbase (ASO/BSO), MaxL scripting, and performance tuning.
• Strong communication, analytical, and documentation skills.

Roles & Responsibilities

• System Support & Maintenance: Provide daily support for HFM, ensuring high availability and performance, handling data loads, metadata updates, and system health checks.
• Financial Consolidation & Reporting: Support finance teams with budgeting, forecasting, consolidation, and reporting processes, including managing HFM rules and ensuring data integrity.
• Issue Resolution: Troubleshoot and resolve HFM-related issues, such as data integrity problems, process failures, and user access issues.
• Integration & Data Management: Manage FDMEE (or other data management tools) integrations with source systems (like ERPs) and maintain hierarchies in Data Relationship Management (DRM).
• Reporting & User Support: Design and maintain financial reports using HFM, along with supporting users with Smart View for data retrieval and analysis.
• Documentation: Create and maintain technical documentation, including system designs, test plans, support logs, and Standard Operating Procedures (SOPs).
• Application Enhancements: Assist with minor enhancements and the application of patches to the HFM environment.