Technical Consultant - OFSAA - PFT & FTP Implementation

Key Responsibilities

1. Technical Build & Configuration

• 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.

2. SQL/PLSQL Engineering

• 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.

3. Data Integration & ETL Engineering

• 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.

4. Batch Execution & Performance Support

• 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.

5. Testing & Quality Assurance

• 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.

6. Documentation & Deployment

• 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.

7. Cross-Functional Collaboration

• Work closely with functional EPM consultants to translate allocation logic, FTP methods, and profitability calculations into technical builds.
• Collaborate with DBA, infrastructure, and data architecture teams on performance and deployment issues.
• Provide guidance and mentoring to IC1/IC2 developers.

Required Skills & Experience

Technical Skills

• 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.

Performance & Architecture Awareness

• 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).

Domain Understanding (Technical View)

• 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.

Soft Skills

• Good analytical and problem-solving ability.
• Strong communication and documentation skills.
• A self-driven mindset with the ability to drive module delivery with minimal oversight.
• Mentoring capability for junior technical consultants.

Preferred Qualifications

• 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.

Success Measures (KPIs)

• Quality and timeliness of module delivery.
• Reduced defects and optimized rule run-times.
• Accurate technical configurations aligned with business and performance requirements.
• Smooth batch execution and stable deployments.
• Positive feedback from IC4 leads, architects, and clients.