Application Development Associate Advisor - HIH - Evernorth

Position OverviewApplication 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.QualificationsRequired Skills:8-11 years minimum of experience in enterprise application development using Hyperion:HFM (Global)Classic HFM business rules (not Calculation Manager business rules)FDMEEHFRKnowledge of Dimension Properties for HFMFCCS (Domestic / Enterprise Consolidations)Knowledge of business rulesData ExchangeReportsKnowledge of Dimension Properties for FCCSARCSData ExchangeTransaction MatchingReportsEPM AutomateMicrosoft PowerShell ScriptingOracle Enterprise Project Management Cloud (EPCMCS)Configure and support of cost collection, burdening, capitalization, and cost allocation processesExperience configuring expenditure types, cost rates, project classification, and cost structure, and associated EPCMCS rulesIntegrate costing with GL and Subledger AccountingManage Oracle Cloud security roles and data access for costingEnterprise Planning & Budgeting Cloud (EPBCS)Design and support budgeting, forecasting, and long-range planning applicationsBuild and maintain dimensions, metadata, and hierarchiesDevelop business rules, calculations, and data mapsImplement driver-based planning and scenario modelingManage data loads and integrationsTrouble shoot calculation, performance, and data issuesEnterprise 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.DRMDeveloping propertiesDeveloping Action ScriptsDeveloping HierarchiesDeveloping Blends and ExportsDOS batchARMCreating AttributesFDMEEVBScript and DOS batchSQL for creating reportsHow to create FDMEE custom reportsHow to create FCM custom reportsFDMEEImport Format scriptsFDMEE mapping scriptsVBScript and DOS batchHFRCreating reports with formulasSmart ViewCreating reports with Function BuilderEssbaseSolid understanding of BSO/ASO architecture and their inner workingsDevelop Calculation scripts, rule files, partitionsOptimization techniques for scripts as well as query response timesMaxL scripting and automation in Unix/Linux and Windows OS environmentsBasic understanding of Custom Defined Functions is a plusPlanningDesigning WebformsDeveloping Business Rules in Calc ManagerFamiliarity with Member Lists, Allocations/SpreadsUnderstanding of Security in Planning and how it relates to EssbaseUnderstanding of corporate business processes, including fundamental finance concepts as well as forecasting and budgeting cycles, and corporate reporting requirementsProven 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 systemsStrong analytical and problem-solving skills with a focus on root cause analysis and long-term fixes.Familiarity with regulatory compliance frameworks (SOX, CIP).Experience with job scheduling tools, monitoring systems, and automation platforms.Excellent communication (written & verbal), attention to detail, and documentation skills with the ability to interact with all levels of the organization. Strong interpersonal/relationship management skills. Strong time management skills. Required Experience & Education: 8-11 years minimum of experience working in production support. College degree (Bachelor) in related technical/business areas or equivalent work experience. Microsoft certifications  Desired Experience:  Experience with Accounting and Finance applicationsResponsibilities            Application & Production SupportPerform production fixes including troubleshooting with technology and business partners through solution implementation and validation.Coordinate with upstream/downstream systems for issue resolution, scheduling, and change notifications.Monitor job run times and tune performance to meet SLAs/OLAs.Operational PerformanceSupport daily/weekly/monthly/annual business processes requiring close collaboration between IT and business teams.Manage batch cycles, code promotions, and release implementations.Maintain application health checks and monitor reliability/availability.Architecture & EfficiencyEnsure architecture currency through updates