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 settings (DEV → SIT → UAT → PROD).
Maintain version-controlled build scripts and change management documentation.
Robust 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

📌 Ofsaa Epm Consultant Hyderabad (India)
🏢 Nameless
📍 India