Oracle Hyperion Techno Functional Consultant

Job Title : Oracle Hyperion Techno‑Functional Consultant (5+ Years). Location: PAN India Experience 5 plus years of hands‑on experience in Oracle Hyperion/EPM (Cloud preferred) Role Overview We’re looking for a techno‑functional consultant who can design, build, and support Oracle Hyperion Planning (PBCS/EPBCS) solutions, lead data integrations (FDMEE/EPM Automate), and collaborate closely with finance stakeholders. This role balances functional finance processes (budgeting, forecasting, approvals) with technical delivery (calculations, integrations, performance optimization). Core Responsibilities (adopt across 5+ categories) 1) Planning & Essbase (Must‑Have for 5+) - Design, develop, and maintain PBCS/EPBCS applications and artifacts (forms, business rules, calc scripts, dashboards). - Configure and enhance EPBCS modules (Financials, Workforce, Capex, Projects). 2) Data Integration & Automation (Must‑Have for 5+) - Build and manage FDMEE mappings, workflows, and data validations. - Automate inbound/outbound interfaces using EPM Automate (scheduling, error handling, logs). - Collaborate with IT/data teams on source/target integrations. 3) Scripting & Data (Must‑Have for 5+) - Use SQL/PL/SQL for data checks and transformations; shell scripting for job automation. - Maintain integration scripts, parameter files, and environment-specific configs. 4) Functional Delivery & Governance (Must‑Have for 5+) - Translate user requirements into functional & technical designs, configuration, and test scenarios. - Prepare key deliverables: requirements, solution design, test plans, training materials, and deployment runbooks. - Implement best practices, methodology, and business process improvements. 5) Performance & Optimization (Good‑to‑Have for 5+) - Diagnose and optimize calc scripts, outlines (ASO/BSO), aggregations, and data loads. - Apply performance tuning and application optimization techniques. 6) Consolidation & Controls (Optional add‑on) - Exposure to HFM (Hyperion Financial Management) for consolidations and reporting. - Understand SOX controls, audit readiness, environment management. 7) Reconciliation & Metadata (Optional add‑on) - ARCS: Configure profiles, rules, workflows, and reporting. - DRM: Support metadata governance, hierarchies, and workflow approvals. Must‑Have Skills (5+ Categories) - PBCS/EPBCS: Forms, rules (Calc Manager/Groovy), approvals, security. - Essbase: Outline management, calc scripts, ASO/BSO concepts. - FDMEE & EPM Automate: Mappings, workflows, batch automation, error handling. - SQL/PLSQL & Shell scripting: Data validation, automation, utilities. - Documentation & Testing: Functional specs, technical design, test scenarios, UAT. - Stakeholder Engagement: Strong communication with finance users, ability to handle ambiguity. Good‑to‑Have Skills - Performance Tuning: Hybrid aggregation strategy, Groovy optimizations, partitioning. - HFM (consolidations), ARCS (reconciliations), DRM (metadata governance). - Jython scripting within FDMEE. - SOX & compliance understanding. - Experience with budget approval process design and workflow optimization. Soft Skills - Excellent communication: ability to listen, understand, and improve processes. - Work independently with minimal supervision; strong ownership. - Team player who adapts quickly to new concepts and changing priorities. - Strong focus on customer satisfaction and business outcomes. - Mentor junior team members; provide ad‑hoc trainingand user support. Job Title : Oracle Hyperion Techno‑Functional Consultant (5+ Years). Location: PAN India Experience 5 plus years of hands‑on experience in Oracle Hyperion/EPM (Cloud preferred) Role Overview We’re looking for a techno‑functional consultant who can design, build, and support Oracle Hyperion Planning (PBCS/EPBCS) solutions, lead data integrations (FDMEE/EPM Automate), and collaborate closely with finance stakeholders. This role balances functional finance processes (budgeting, forecasting, approvals) with technical delivery (calculations, integrations, performance optimization). Core Responsibilities (adopt across 5+ categories) 1) Planning & Essbase (Must‑Have for 5+) - Design, develop, and maintain PBCS/EPBCS applications and artifacts (forms, business rules, calc scripts, dashboards). - Configure and enhance EPBCS modules (Financials, Workforce, Capex, Projects). 2) Data Integration & Automation (Must‑Have for 5+) - Build and manage FDMEE mappings, workflows, and data validations. - Automate inbound/outbound interfaces using EPM Automate (scheduling, error handling, logs). - Collaborate with IT/data teams on source/target integrations. 3) Scripting & Data (Must‑Have for 5+) - Use SQL/PL/SQL for data checks and transformations; shell scripting for job automation. - Maintain integration scripts, parameter files, and environment-specific configs. 4) Functional Delivery & Governance (Must‑Have for 5+) - Translate user requirements into functional & technical designs, configuration, and test scenarios. - Prepare key deliverables: requirements, solution design, test plans, training materials, and deployment runbooks. - Implement best practices, methodology, and business process improvements. 5) Performance & Optimization (Good‑to‑Have for 5+) - Diagnose and optimize calc scripts, outlines (ASO/BSO), aggregations, and data loads. - Apply performance tuning and application optimization techniques. 6) Consolidation & Controls (Optional add‑on) - Exposure to HFM (Hyperion Financial Management) for consolidations and reporting. - Understand SOX controls, audit readiness, environment management. 7) Reconciliation & Metadata (Optional add‑on) - ARCS: Configure profiles, rules, workflows, and reporting. - DRM: Support metadata governance, hierarchies, and workflow approvals. Must‑Have Skills (5+ Categories) - PBCS/EPBCS: Forms, rules (Calc Manager/Groovy), approvals, security. - Essbase: Outline management, calc scripts, ASO/BSO concepts. - FDMEE & EPM Automate: Mappings, workflows, batch automation, error handling. - SQL/PLSQL & Shell scripting: Data validation, automation, utilities. - Documentation & Testing: Functional specs, technical design, test scenarios, UAT. - Stakeholder Engagement: Strong communication with finance users, ability to handle ambiguity. Good‑to‑Have Skills - Performance Tuning: Hybrid aggregation strategy, Groovy optimizations, partitioning. - HFM (consolidations), ARCS (reconciliations), DRM (metadata governance). - Jython scripting within FDMEE. - SOX & compliance understanding. - Experience with budget approval process design and workflow optimization. Soft Skills - Excellent communication: ability to listen, understand, and improve processes. - Work independently with minimal supervision; strong ownership. - Team player who adapts quickly to new concepts and changing priorities. - Strong focus on customer satisfaction and business outcomes. - Mentor junior team members; provide ad‑hoc trainingand user support.