What are the responsibilities and job description for the Senior .NET & Oracle PL/SQL Developer (Hybrid) New York, NY position at Brandon Consulting Associates?
SHORT DESCRIPTION
1) PRS (Integrated Policy Renewal System) / EPS (Earned Premium System)
An in-house transaction processing system designed for Workers Compensation Insurance premium calculations, adhering to NYCIRB guidelines for both advance and earned premium types.
- Main Modules : Declarations, Renewals, Rebills, Audits, Audit Rescind, and Audit Adjustments.
- Tasks : Systems enhancements and production fixes.
2) Billing and Collection System
A web-based, in-house application for billing and collections with functionalities including cash processing, refunds, journal entries, non- payment cancellations, and policy reinstatements.
3) PayGo (Pay-as-You-Go) System
A web-based online system for tracking premium payments made directly by payroll vendors for enrolled policies.
4) Diaries and Workload Distribution System
An in-house integrated diary and workload distribution system for tracking manual underwriter reviews across various underwriting modules.
Integrated with underwriting modules to close diaries automatically based on completed activities.
5) Batch Transaction Reporting Modules for Brokers and Payroll Agencies
A batch reporting system for tracking policies and providing daily data to brokers in .al3 format. Also supports payroll agencies enrolled in PayGo programs.
The consulting resources will be responsible for planning, creating, modifying, testing, and implementing code to support any of the following activities :
integrate in-house applications with cloud-based software.
The consultant will ensure compliance with NYSIF's application development standards, which include, but are not limited to :
Skill Chart
24 months experience with Azure DevOps Server
84 months experience in using NYCIRB (New York Compensation Insurance Rating Board) guidelines and regulations to develop and support software to analyze and process Workers' Compensation and Disability insurance premium
84 months experience in Software Development Life Cycle to generate and process CIRB Estimated Experience Ratings, Workers Compensation Insurance Policy Renewals, Rebills, and Audits
84 months experience with Oracle PL / SQL utilizing Packages, Types, Objects, Triggers and Advanced Queuing
60 months experience with ACORD AL3 data format and transformation for Underwriting and Claims applications
60 months experience as a .Net application developer using C#, Visual Studio 2010 or newer version
60 months experience in developing software systems for supporting Workers Compensation and Disability Insurance account receivables billing (using Accrual Accounting Method)
48 months experience with Redwood ActiveBatch job scheduling
48 months experience with web browser application development using Javascript, CSS, Xslt and html
