OFSAA developer (Westwood)


: $107,040.00 - $160,420.00 /year *

Employment Type

: Full-Time


: Information Technology

Loading some great jobs for you...

Job Description

  • TheOFSAA developer will be part of a development team implementing profitabilitysolution using OFSAA Key responsibilities of the developer includes thefollowing:
  • Configurationof rules for cost and revenue allocation in OFSAA for profitabilitycalculation. Configure FTP rules in OFSAA. Write T2Ts to transform data.Develop procedure using PL/SQL. Understand business requirements and implementtechnical solution within OFSAA in an efficient way. Test OFSAA configurationsand fix defects as appropriate.
  • Troubleshoottechnical issues by analyzing OFSAA log files and fixing the issues.
  • Understandcomplex SQL queries, analyze data related issues and identify root cause ofissues / defects. Develop and implement performance optimal system.
  • Maintainthe end-to-end OFSAA batch and provide technical support.
  • Majorresponsibilities include:
  • Productionsupport of OFSAA, this includes batch runs and minor development requests tofix defects as required.
  • Troubleshoottechnical issues by analyzing OFSAA log files and fixing the issues. Analyzedata related issues and identify root cause of issues / defects.
  • Developrules for cost and revenue allocations in OFSAA including configuring FTP rulesand writing T2Ts to transform data. Develop adhoc procedures using PL/SQL.
  • Testingin support of projects and creation of project artifacts as required by projectlife cycle.
  • Qualifications

  • 5 years of Hands-on experience in OFSAA v6.1 Profitability, FTP and GLReconciliation modules.
  • Goodexpertise in configuring allocation rules in OFSAA for cost allocation andrevenue allocation for profitability management.
  • Goodexpertise in configuring Transfer pricing rules in OFSAA FTP module.
  • Goodexpertise in building T2T (Table to Table) transformations in OFSAA.
  • 3 years of expertise in developing forms with the help of OFSAA forms framework.
  • 6 years of experience writing and debugging complex SQL queries and StoredProcedures in Oracle database.
  • In-depthunderstanding of Dimensions, hierarchies and attributes as it applies to OFSAAprofitability modules.
  • In-depthunderstanding of Data Warehousing concepts and dimensional modeling.
  • Goodunderstanding of functional aspects of profitability calculations.
  • Workingknowledge of OFSAA Run-Rule framework as it applies to Credit Risk applicationis a plus.
  • 6 years of experience working in the financial industry. Flexible in managing competingpriorities and objectives.
  • Abilityto work independently as needed.
  • Strongteam player with a can-do attitude.

  • Associated topics: algorithm, backend, back end, c++, develop, developer, perl, sde, software development engineer, sw * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

    Launch your career - Create your profile now!

    Create your Profile

    Loading some great jobs for you...