Role centered on the implementation of Project Accounting in 11i. The position will require the development of custom solutions/extension Oracle Applications 184.108.40.206.2 environment (10g RDBMS). Past Project Accounting (Costing) experience is an absolute must as is STRONG PL/SQL.
PA, AP, PO, INV
Local Candidates Preferred
Duties and Responsibilities
• Work Management:
o Analyze, design, develop and document code to process job costing data including burdening in Oracle Projects 11i Modules and then interface this to GL for adjustments and legacy cost and reporting systems.
o Analyze, design, develop and document code to build interfaces between Oracle Projects 11i Modules and legacy system in order to transfer customer and project information
o Analyze, design, develop and document code to convert project data, project cost data, and project customer data from legacy systems into Oracle Projects modules
o Fix all bugs identified during data conversions process for Customers, Projects and Cost Conversions
o Analyze, design, develop and document code to implement customized approach to a unique identifier from current use of town, costumer and contract number to a future use in Oracle Projects of project, organization, expenditure type and task.
o Analyze, design, develop and document code to modify existing custom reports in Oracle and other legacy systems in order to accommodate the greater length of the project, organization, and expenditure type and task unique identifier.
o Review and analyze all required and existing and Oracle Project, projects documentation including but not limited to business requirements, MD 50s, MD 70s and Oracle technical bulletins, emails and Oracle TAR documents.
o Review and analyze current and future business process in order to design and develop project Oracle Projects RICE objects
o Execute technical tests and document all test results for all developed and modified code.
o Complete all code development using SQL, SQL Plus, Logical APPS, Reports 6i, and Oracle Framework.
o Execute test plans to regression test base PA Release
o Develop test plans to regression test base for PA Release
o Work with the business analysts and developers to regression test customizations and extensions for PA Release
o Ability to execute SQL queries to validate data and ensure the integrity of transactions involving 11i base schema and custom schema.
o Execute test plans for the Verification of data before and after purging
o Coordination of QA activities for PA Release
o Provide and prepare all needed technical documentation, specifications and by resource during its assignment.
o Utilize approved hardware and software, and abide by IT and business policies.
o Abide to all processes and policies with their associated tools where applicable, i.e. using PPM for weekly timesheets.
o Document analysis, testing, solution, and user aids utilizing Microsoft Office tool set
o Provide daily and weekly progress reports as to issue progress and resolution
o Attend all required meetings and provide time estimates for all assigned and required tasks
o Strong knowledge in the Oracle 11i Applications
o Oracle Applications Financial, Supply Chain & HRMS suites
o Microsoft Office tools, MS Project, MS PowerPoint, Visio
o Oracle Applications Technology Stack (11i) on an AIX platform
Oracle RDBMS 9i & 10g
Oracle Applications customizations & extensions (Applications Library/ Foundation)
PL/SQL – SQL Plus
SQL ( Toad, SQL Developer)