The OFSAA EPM Consultant implements EPM solutions, configures OFSAA components, develops SQL scripts, optimizes performance, and supports data processing and validation efforts.
- 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
Top Skills
Epm
Informatica
Odi
Ofsaa
Plsql
SQL
Unison Consulting Singapore Office
1 Changi Business Park Crescent, , Plaza 8 #03-06 Tower A, Singapore, , Singapore, 486025
Unison Consulting Singapore Office
#12-00, 63 Market Street, Bank of Singapore Center, Singapore, , Singapore, 048942
Similar Jobs
Information Technology • Consulting
The Technical Consultant designs, develops, and configures components across OFSAA EPM suite, focusing on profitability, allocation, and reporting. Responsibilities include SQL scripting, ETL support, performance optimization, testing, and cross-functional collaboration to ensure effective EPM solutions.
Top Skills:
InformaticaOdiOfsaaPlsqlSQL
Cloud • Information Technology • Security • Software • Cybersecurity
The IT Operations Specialist provides onsite IT support and manages the IT asset lifecycle, ensuring technology functions correctly and efficiently for employees in Singapore.
Top Skills:
ChatgptCopilotGeminiGenerative AiGoogle WorkspaceIntuneJAMFJira Service ManagementMS OfficeOomnitzaZoom
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The role involves producing sales revenue from a SaaS model, developing relationships with C-suite clients, and leading account strategies while managing virtual teams. Candidates need significant experience in a sales environment, particularly in the financial sector in the Philippines, along with a focus on customer success and AI integration in work processes.
Top Skills:
SaaS
What you need to know about the Singapore Tech Scene
The digital revolution has driven a constant demand for tech professionals across industries like software development, data analytics and cybersecurity. In Singapore, one of the largest cities in Southeast Asia, the demand for tech talent is so high that the government continues to invest millions into programs designed to develop a talent pipeline directly from universities while also scaling efforts in pre-employment training and mid-career upskilling to expand and elevate its workforce.
