Mandatory Skills - Oracle Hyperion HFM (8+ yrs hands-on: application design, metadata, rules, consolidation, intercompany, journals, security); HFM data & metadata extraction (HFM extracts, Smart View, FDMEE/Data Management, database-level); end-to-end EPM migration/archival/decommissioning; financial close & consolidation; data validation & reconciliation; SOX/audit & data retention; SQL & data modeling; client-facing Finance/IT leadership communication
Nice to Have Skills - Archival/reporting platforms (Azure, Databricks, Snowflake, SQL Server, Oracle DB, Power BI); Oracle EPM Cloud (FCCS/Planning) or OneStream; Oracle licensing/support-contract termination; CPG or large multinational consolidation; CPA or Oracle EPM certification
Start Date – ASAP
Project duration – 8 weeks
Working Hours - Standard US business hours, full-time (40 hrs/week); overlap with Pacific Time
JD - Current-State Assessment
• Assess the current HFM environment, including applications, versions, environments (Prod/Non-Prod), and infrastructure.
• Inventory integrations, upstream/downstream dependencies (e.g., FDMEE/Data Management, EPMA, Smart View, Financial Reporting, ERP sources), and any residual jobs or connections.
• Profile data volumes, years/periods/scenarios held, and historical usage patterns, including who still accesses HFM and why.
2. Data & Metadata Retention Definition
• Define the historical financial data to be retained (scenarios, years, periods, entities, accounts, currencies, intercompany, journals).
• Define the metadata required to interpret the data correctly: hierarchies, dimensional structures, member properties, alternate hierarchies, and consolidation/translation rules.
• Identify other artifacts to preserve, such as business rules, member lists, journal templates, security classes, FR reports, and process-control/audit history.
3. Archival Approach & Recommendation
• Evaluate and recommend an archival target outside HFM (e.g., relational database, cloud data platform, or data lake with a reporting layer) that is sustainable and cost-effective.
• Design the target data model so archived data stays usable for reporting and lookups, including flattened hierarchies and point-in-time metadata.
• Lead extraction of data and metadata from HFM and loading into the archive.
4. Post-Retirement Finance Access
• Define how Finance users will access historical information after HFM is retired, including required reports, standard extracts, and a self-service or request-based retrieval process.
• Gather and prioritize reporting needs with Finance stakeholders and design the replacement reports/extracts.
5. Validation & Reconciliation
• Design and run a validation and reconciliation framework comparing archived data against HFM (balances, consolidated results, intercompany, and journals) before shutdown.
• Document reconciliation results, resolve variances, and obtain formal Finance sign-off.
6. Audit, Retention, Security & Compliance
• Identify record-retention, SOX/audit, security, and compliance requirements with Clorox Audit, Legal, and InfoSec.
• Ensure the archive enforces the right access controls, retention periods, and audit trail.
7. Decommissioning Plan & Execution
• Build and run the decommissioning plan covering application, infrastructure, integrations, licenses, user access, and operational dependencies (monitoring, backups, support contracts).
• Coordinate cutover, read-only/freeze periods, final backups, and server/environment shutdown with Clorox IT.
• Support license and support-contract termination planning.
8. Documentation, Knowledge Transfer & Engagement Management
• Produce documentation of the archive design, data dictionary, retrieval procedures, and reconciliation evidence.
• Deliver knowledge transfer to Clorox Finance and IT support teams.
• Contribute to the proposal: approach, scope, timeline, resource model, assumptions, and cost estimate. Then track progress, risks, and status reporting against it.
Key Deliverables
• HFM current-state assessment report (environment, integrations, dependencies, volumes, usage)
• Data and metadata retention matrix
• Archival approach recommendation and target-state design
• Historical data access model, with report/extract specifications
• Validation and reconciliation plan, results, and Finance sign-off
• Audit, retention, security, and compliance requirements summary
• Decommissioning plan and execution checklist
• Documentation package and knowledge transfer sessions
Required Qualifications
• 8+ years of Oracle Hyperion EPM experience, with deep hands-on HFM expertise (application design, metadata, rules, consolidation, intercompany, journals, security).
• Proven experience extracting HFM data and metadata at scale (e.g., HFM extracts, Smart View, FDMEE/Data Management, database-level extraction).
• Experience leading at least one EPM migration, archival, or decommissioning project end to end.
• Strong understanding of financial close and consolidation processes, and the ability to work directly with Corporate Finance and Controllership.
• Experience designing data validation and reconciliation frameworks for financial data.
• Working knowledge of SOX controls, audit support, and data-retention requirements.
• Strong SQL and data modeling skills.
• Excellent communication skills, and experience leading client-facing workstreams and presenting to Finance and IT leadership.
Preferred Qualifications
• Experience with modern archival/reporting targets such as Azure, Databricks, Snowflake, SQL Server, Oracle DB, or Power BI.
• Exposure to Oracle EPM Cloud (FCCS/Planning) or OneStream, and to coexistence or migration scenarios.
• Familiarity with Oracle licensing and support-contract termination considerations.
• Consumer packaged goods (CPG) or large multinational consolidation experience.
• Bachelor’s degree in Accounting, Finance, Information Systems, or a related field. CPA or Oracle EPM certification a plus.