Estimated Length: 24 months Full-Time Negotiable Hour

Mandatory Requirements

Expert 84+ Months

Desired Requirements

• Minimum of 84 months experience in developing applications software using Oracle forms, reports and database.
• Minimum 72 months experience in Application Development in Oracle Applications Suite version 11.5.10.2 and modules such as PO, AP, AR and GL.
• Minimum of 36 months experience modifying custom libraries, PL/SQL Oracle application reports and forms.  
• Minimum of 36 months experience with NYS customs to Oracle Financials Application Suite – including inbound and outbound interfaces.
• Minimum of 24 months experience in creating users, roles in Kofax Mark View/Kofax Capture imaging system as well as Mark View Administration. 
• Experience with upgrading Kofax MarkView systems as well as installation and upgrading application server.
• Minimum of 36 months experience in managing e-business (EBS) databases, patches, upgrading and cloning EBS.
• Minimum of 36 months experience with Workflow builder including workflow customizations, defining hierarchies, , document approval hierarchies and defining approval setups of purchase requisitions and purchase orders.
• Minimum of 24 months experience with State Civil Fingerprint processing (revenue feeder system using auto invoicing), NYS Grants Management System (GMS), and NYS GMS interfaces with Oracle using PDOI, including design and implementation of IT solutions and the impacts of such solutions on the agency’s integrated systems.

Responsibilities

• Provide technical support to maintain and run daily interfaces that occur between a number of critical systems (such as the two-way interface code between Oracle Financials and SFS, two Grants Management Systems (GMS) and the client's Civil Fingerprint Processing system (a revenue feeder system using auto invoicing),  
• Provide technical architect services associated with these integrated systems.  
• Perform role of database administrator for the Oracle Financial System and Kofax (formerly 170 Systems) workflow and records management system. 
• Provide technical support to maintain Oracle Financials outbound process to send transactions such as contracts, encumbrances, vouchers, refunds, and receivable transactions to current Statewide Financial System (SFS). 
• Provide technical support to maintain Oracle financials inbound process to receive transaction files from the SFS every day and process them.  This includes posting Central Accounting System (CAS) side entries into Oracle Financials management system to reconcile both SFS and Financial Management System (FMS) systems. Also make changes to these reconciliation processes to work with SFS phased initiatives. 
• Provide support to Oracle Financials System production, development and test applications as well as database tasks such as maintaining table spaces, working with OITS staff to maintain server level space allocation to support systems growing space needs, patching to upgrade applications, databases to Oracle supported versions. Also do Oracle Enterprise Business Suite cloning from production backups to development, test and SFS test environments to help system enhancements to automate processes and also develop code and test.  Ensure CommVault backups are occurring and usable as appropriate.  
• Provide support to maintain Grant Management System (GMS) interface to load contract information directly into Oracle financials management system, support to maintain Division of Homeland Security and Emergency Services (DHSES) GMS interface to load contract information, support Enterprise Fingerprint System (EFP) interface to load fingerprint transactions into Receivables module in Oracle Financials Management system (FMS). Support EFP Federal Bureau of Investigations (FBI) fee reconciliation process. Modify code to work with SFS requirements. 
• Provide support to internal review process workflows in Oracle purchasing module to get internal review online approvals. Also support customizations made to Purchasing Requisition approval workflow process for all program areas to get requisition online approvals. 
• Provide support/build various custom reports and forms in Purchasing (PO), Accounts Payable (AP), Accounts Receivable (AR) and General Ledger (GL) modules as per user requirements and modify these screens and reports to capture additional data to work with SFS changes. Also support Oracle application manager, creating responsibilities, menus and folder administration. 
• Provide support for Kofax Mark View Imaging system integrated with PO and AP modules of Oracle Financials. Also support Mark View application server upgrades/maintenance, support Mark View document server maintenance/upgrades as well as Mark View application upgrades, administration, roles and user creation. 
• Provide support for the statewide initiates to a) migrate the client to the statewide Grants Gateway System; and b) migrate the client to the Statewide Financial System. These initiatives include support for the go-live implementation and provide post-production support as needed to address the Statewide Financial System (SFS) and other SFS releases or project needs and support future SFS phases for implementation and post production support.  These initiatives have co-dependencies which must be coordinated and managed in order to successfully address all grant related business needs. Migration to SFS may also involve establishing an interface between SFS and the client's EFP system. 

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer