Oracle PL/SQL VS 2010 Workers Comp Architect

Location: NYC, NY
Date Posted: 09-12-2018
Oracle PL/SQL VS 2010 Workers Comp Architect
New York, NY
24 Months
Job Description:

(1) NY Statewide Offset Program (SWOP)
Section 171-f of the Tax Law, enacted by Chapter 55 of the Laws of 1992, authorizes the offset of debts owed to the state agencies against tax refunds and certain other state payments. NYSIF will take part in this Offset Program through the Department of Taxation and Finance.
Development works needed in the following area:
•    Changes to NYSIF’s Billing and Collections System
•    Creation of debt certification files
•    Annual Renewal
•    Weekly Offset processing including updates to Oracle Financial.
•    Reporting

(2) WCB-POC (Proof-Of-Coverage) System /Premium Computation for WC, DBL & PFL.
The WCB_POC system provides daily reporting to the NYS Workers’ Compensation Board detailing any activity or event that serves to modify a NYSIF policyholder’s Workers’ Compensation insurance coverage
The premium computation system is used to assess and compute premium for Workers’ Compensation, Disability & Paid Family Leave premiums.  It includes a component to estimate experience modification rating factors using claims history.

The duties of the consulting resources would be to plan, create, modify, test and implement code in support of any of the following:
•    Design and create applications to extract, transform and load data from source to target database
•    Develop Oracle stored procedure, packages, and triggers to integrate in-house application with cloud-based software
•    Develop batch application using .net, oracle
•    Develop online application using .net and oracle
•    Develop with modern web development frameworks.

The consultant will adhere to NYSIF’s application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process.

Candidates should have at least 84 months experience and a majority of the following should apply: 
Each candidate should fill out the months of experience they have for each item in the table:
1. At least 24 months experience using Innotas #of months  
2. At least 24 months experience using Visual Build Pro 7 or newer #of months  
3. At least 24 months experience using HP Quality Center #of months  
4. At least 84 months’ experience in Oracle development, PL/SQL development including all the following: Triggers, functions, Stored Procedures, Packages & Advanced Queuing. #of months  
5. At least 84 months’ experience in development, support and implementation of software for workers’ compensation and disability insurance to analyze and process premium calculations using algorithm following NYS Compensation Insurance Rating Board (NYCIRB) guidelines and regulations #of months  
6. At least 84 months experience with oracle PL/SQL to develop and support reporting of WC proof of coverage following IAIABC Standards #of months  
7. At least 60 months’ experience with oracle PL/SQL in development, support and implementation of Workers Compensation insurance application to evaluate and process Loss Cost analysis, assessments and NYCIRB Ratings #of months  
8. At least 36 months experience with Visual Studio 2010 or Newer to develop web applications using .net framework (, C# & #of months  
9. At least 60 months experience with XML, XSLT #of months  

Key Business Solutions, Inc.
|| Office: 916 646 2080 Ext 215 || Fax: 916 646 2081
Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
this job portal is powered by CATS