Technical Consultant

Title: Technical Consultant

Contract Term: 18 Months

County(ies): Albany

Location: Albany, NY (ONSITE)

Travel and meals will be reimbursed.

Requested Qualifications:

1. 7 years experience in developing applications software using Oracle forms, reports and database.
2. 6 years experience in Application Development in Oracle Applications Suite version 11.5.10.2 ,R12.X and modules such as PO, AP, AR and GL.
3. 5 years experience modifying custom libraries, PL/SQL Oracle application reports and forms.
4. 3 years experience with NYS customs to Oracle Financials Application Suite – including inbound and outbound interfaces such as creating PO , AP , AR and GL transactions to send to SFS and process transactions data that received from SFS.
5. 5 years experience with Workflow builder including workflow customizations, defining hierarchies, document approval hierarchies and defining approval setups of purchase requisitions and purchase orders. Also experience defining and maintaining AP invoice approval hierarchies using AME.
6. 3 years 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.
7. 5 years of experience in database administration to maintain day to day database tasks to manage oracle financials database as well as Kofax Markview schema. Experience in monitoring ASM table spaces and allocate needed space to run systems smoothly. Also manage ASM disks to allocate more space to be available for tablespaces. Also experience in CommVault software to clone Oracle Enterprise Business Suite from production backups to development, test to the desired date using CommVault backups and ensure CommVault backups are occurring and usable as appropriate. Also manage oracle financials database to accommodate server patching schedule to AIX O/S and make sure database is working after patching cycle. Coordinate database upgrades as per oracle EBS supported versions.
8. 5 years of experience in providing support and maintain Kofax MarkView document management system integrated with oracle financials management system such as Purchasing and Payables modules. Experience in implementing new modules such as KIC (Kofax Import Connector) folder option to avoid scanning where ever possible. Experience in working with server group to support Mark View application server upgrades/maintenance, support Mark View document server upgrade/maintenance and Windows server upgrade/maintenance.
9. Experience in working with Kofax Markview support to resolve system issues and get the latest software to upgrade Kofax MarkView application as per the compatibility matrix to work with oracle financials EBS, Linux O/S version as well as java versions.
10. Experience in upgrading Kofax Markview application as well as scanning and folders software and re-integrate with oracle EBS modules such as PO and AP.
11. Experience in administration to manage Kofax Markview application to create user profiles assigning appropriate Kofax Markview roles depending the user responsibilities and provide management tools to supervisors to manage the workload. Experience in managing Kofax Markview customizations specific to DCJS and DHSES.

Description: DCJS’ is looking for a highly skilled technical and functional person working in a very integrated technical environment. The incumbent would be required to work utilizing DCJS identified high demand tools in technologically advanced environments such as Oracle Financials ERP system, 170 Kofax Markview document management system and CommVault with multiple platforms. This resource will provide technical oversight to teams working in multiple projects, including but not limited to: SFS Enterprise Enhancement (EE1) postproduction support, SFS grants management system and P2P postproduction support; implementation and postproduction support of subsequent phases of SFS; Grants Gateway (GG) implementation postproduction and integration of these systems with multiple technologies and platforms. The resource will provide technical support to maintain and run daily interfaces that occur between several critical systems (such as the two-way financial transaction interfaces between Oracle Financials and SFS, two-way interfaces between Oracle Financials and Grants Management Systems (GMS), Interface to pull transactions from Grants Gateway to Oracle Financials. Oracle Financials interface to pull fingerprint transactions from the DCJS Civil Fingerprint Processing system into AR module). These interfaces have critical daily interactions with numerous systems, including 2-way interfaces with the Statewide Financial Management System each day that produce Purchasing, Payables, Receivable Accounting Journal Ledger entries in both systems. The AP and PO modules of DCJS Oracle Financial system also integrated with the 170 Markview Kofax document management system software. Develop and maintain Accounts Payable and Purchasing workflows set up and customizations in the Oracle Financial ERP system. These services are essential to ensure the continuity of financial operations for user agencies, including DCJS, and its hosted agency the Division of Homeland Services and Emergency Services (DHSES).