*Job Title:* *OFSAA developer* *Duration: *9+ months
*Location: *Jersey City, NJ *Developer, Oracle Financial Services Analytical Appliances, Analyst* *JOB SUMMARY: *The OFSAA developer will be part of a development team implementing profitability solution using OFSAA Key responsibilities of the developer includes the following: - Configuration of rules for cost and revenue allocation in OFSAA for profitability calculation. Configure FTP rules in OFSAA. Write T2Ts to transform data. Develop procedure using PL/SQL. Understand business requirements and implement technical solution within OFSAA in an efficient way. Test OFSAA configurations and fix defects as appropriate. - Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. - Understand complex SQL queries, analyze data related issues and identify root cause of issues / defects. Develop and implement performance optimal system. - Maintain the end-to-end OFSAA batch and provide technical support. *Major responsibilities include:* - Production support of OFSAA, this includes batch runs and minor development requests to fix defects as required. - Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. Analyze data related issues and identify root cause of issues / defects. - Develop rules for cost and revenue allocations in OFSAA including configuring FTP rules and writing T2Ts to transform data. Develop adhoc procedures using PL/SQL. - Testing in support of projects and creation of project artifacts as required by project life cycle. *Qualifications* - 5+ years of Hands-on experience in OFSAA v6.1 Profitability, FTP and GL Reconciliation modules. - Good expertise in configuring allocation rules in OFSAA for cost allocation and revenue allocation for profitability management. - Good expertise in configuring Transfer pricing rules in OFSAA FTP module. - Good expertise 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 Stored Procedures in Oracle database. - In-depth understanding of Dimensions, hierarchies and attributes as it applies to OFSAA profitability modules. - In-depth understanding of Data Warehousing concepts and dimensional modeling. - Good understanding of functional aspects of profitability calculations. - Working knowledge of OFSAA Run-Rule framework as it applies to Credit Risk application is a plus. - 6+ years of experience working in the financial industry. Flexible in managing competing priorities and objectives. - Ability to work independently as needed. - Strong team player with a ‘can-do’ attitude. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
