Application Development Associate Advisor - HIH - Evernorth

Requirements

• Required Skills:
• 8-11 years minimum of experience in enterprise application development using Hyperion:
• HFM (Global)
• Classic HFM business rules (not Calculation Manager business rules)
• FDMEE
• HFR
• Knowledge of Dimension Properties for HFM
• FCCS (Domestic / Enterprise Consolidations)
• Knowledge of business rules
• Data Exchange
• Reports
• Knowledge of Dimension Properties for FCCS
• ARCS
• Transaction Matching
• EPM Automate
• Microsoft PowerShell Scripting
• Oracle Enterprise Project Management Cloud (EPCMCS)
• Configure and support of cost collection, burdening, capitalization, and cost allocation processes
• Experience configuring expenditure types, cost rates, project classification, and cost structure, and associated EPCMCS rules
• Integrate costing with GL and Subledger Accounting
• Manage Oracle Cloud security roles and data access for costing
• Enterprise Planning & Budgeting Cloud (EPBCS)
• Design and support budgeting, forecasting, and long-range planning applications
• Build and maintain dimensions, metadata, and hierarchies
• Develop business rules, calculations, and data maps
• Implement driver-based planning and scenario modeling
• Manage data loads and integrations
• Trouble shoot calculation, performance, and data issues
• Enterprise Data Management Cloud (EDMCS)
• Design, develop and maintain data hierarchies, metadata and master data structures to support financial and enterprise data governance.
• Configure validations, properties, property categories, blends, exports, node types, versioning and other components to ensure data integrity across financial applications.
• Set up and manage EDM applications, data chains, subscriptions, node type converters, views and viewpoints to streamline data governance.
• Perform environment migrations for EDM to ensure seamless transition across development, test, UAT and production environments.
• Develop, configure and test integrations between EDM and other Hyperion and Non-Hyperion applications (HFM, FCCS, ARM, ARCS, ARCS, EBS, ERP, Essbase, Allocations, Workday, Ariba, etc.)
• Maintain and update automation scripts (batch scripts, PowerShell, epmautomate, B2B connections.)
• Implement and enforce data governance best practices while ensuring compliance with internal controls, audit requirements, and corporate policies.
• Apply skip updates in EDM for selected Oracle updates and conduct regression testing post updates for EDM.
• Maintain up-to-date documentation on system configurations, processes and best practices.
• Support system enhancements and adhere to internal life cycle change management policies.
• DRM
• Developing properties
• Developing Action Scripts
• Developing Hierarchies
• Developing Blends and Exports
• DOS batch
• ARM
• Creating Attributes
• VBScript and DOS batch
• SQL for creating reports
• How to create FDMEE custom reports
• How to create FCM custom reports
• Import Format scripts
• FDMEE mapping scripts
• Creating reports with formulas
• Smart View
• Creating reports with Function Builder
• Essbase
• Solid understanding of BSO/ASO architecture and their inner workings
• Develop Calculation scripts, rule files, partitions
• Optimization techniques for scripts as well as query response times
• MaxL scripting and automation in Unix/Linux and Windows OS environments
• Basic understanding of Custom Defined Functions is a plus
• Planning
• Designing Webforms
• Developing Business Rules in Calc Manager
• Familiarity with Member Lists, Allocations/Spreads
• Understanding of Security in Planning and how it relates to Essbase
• Understanding of corporate business processes, including fundamental finance concepts as well as forecasting and budgeting cycles, and corporate reporting requirements
• Proven experience in application support, production operations, and IT-business coordination; including experience developing applications under an onshore-offshore model.
• Strong understanding of upstream/downstream integrations between mainframe, Oracle, and distributed services.
• Experience with job scheduling tools, monitoring systems, and automation platforms.
• Knowledge of industry standard source control systems
• Strong analytical and problem-solving skills with a focus on root cause analysis and long-term fixes.
• Familiarity with regulatory compliance frameworks (SOX, CIP).
• Excellent communication (written & verbal), attention to detail, and do

Additional Information

Position Overview Application Development Associate Advisor - Hyperion is responsible for ensuring the stability, efficiency, and compliance of enterprise applications across their lifecycle. This role supports both business and technology production operations, through performing coordinating fixes, maintaining architecture currency, and driving operational excellence. The position requires a strong understanding of application ecosystems, business processes, and regulatory requirements.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Cigna? Share your experience