OFSAA EPM Consultant

• Implement end-to-end EPM solutions for PFT/FTP/Allocations under guidance of IC4 leads.
• Configure OFSAA Rule Framework components including:
• Allocation and driver rules
• Transfer pricing pools and pricing rules
• Transformation rules
• Profitability and costing calculation logic
• Configure and maintain metadata (DIM/FCT structures), hierarchies, and mapping rules.
• Develop SQL/PLSQL scripts, packages, functions, and procedures for:
• Data transformation & enrichment
• Rule logic support
• Batch execution
• Exception handling
• Optimize SQL logic for medium-to-large workloads and improve execution efficiency.
• Support and enhance data pipelines (STG → FCT → Reporting layer).
• Work with ETL engineers (ODI/Informatica) to implement mapping and ingestion logic.
• Perform data profiling, cleansing, reconciliation, and lineage documentation.
• Run EPM batch cycles including PFT/FTP/Allocations.
• Analyze logs, SQL traces, and performance bottlenecks and apply tuning fixes.
• Understand performance optimization for partitions, indexes, and materialized views.
• Write and execute unit tests and SIT test plans.
• Validate profitability/FTP/Allocation rule outputs against functional requirements.
• Assist in defect triage, RCA, and support the UAT cycle.
• Prepare technical design documents, build workbooks, and mapping specifications.
• Support deployment across environments (DEV → SIT → UAT → PROD).
• Maintain version-controlled build scripts and change management documentation.

Requirements

• Strong hands-on SQL/PLSQL expertise (complex joins, aggregations, performance tuning).
• Experience configuring OFSAA Rule Framework components (allocation, FTP, PFT).
• Understanding of DIM/FCT metadata models and mapping concepts.
• Familiarity with ETL tools (ODI/Informatica) or PL/SQL-based data ingestion pipelines.
• Experience working with large data volumes and performance tuning concepts:
• Indexing strategy
• Partitions and subpartitions
• Column statistics and gathering plans
• Query execution plans
• Familiarity with OCI/Exadata environments (preferred).
• Understanding of financial/treasury data such as:
• GL & cost center hierarchies
• Product hierarchies
• Driver-based allocations
• Transfer pricing models
• Ability to convert functional logic into scalable technical execution.
• 4–7 years of experience in OFSAA EPM implementations.
• Hands-on experience in PFT/FTP/Allocations/Costing/MIS.
• Experience in multi-entity/multi-GL EPM implementations.
• Degree in Computer Science, Engineering, Information Systems, or equivalent