Netsmartz

NYCM

Download
Project: NYCM's Billing and Commissions Module
Duration: 1-2 months

Need

New York Compensation Management (NYCM) is a company that manages compensation accounts for companies. The company acts much like an insurance company does but it makes payments on people who get injured at work like coal miners. The need was to create a mini-system to handle the billing and commissions module of a much larger system. The success of this phase led to the creation of the rest of the system.

Challenge

The business logic was quite complicated with intricate subtasks involved. So the key challenge was to understand this complicated business logic involved in New York Compensation Management (NYCM) transactions and then implementing those into an application. The application consisted of the following challenging features:

	Invoice generation
	Commission Handling
	Finance Charge Handling
	Invoice Handling
	Transaction handling

SOLUTION

The solution was NYCM's Billing and Commissions Module that was part of NYCM financial system. The portion of the system that was developed functioned to handle the billing and commissions that are based on “trusts” or a parent account. NYCM helps setup these trusts and then manages each trust for all of the companies.

For instance, one simple scenario would be that a company has 1000 employees and has a $1,200,000 policy for compensation insurance. So the system would create an invoice once a month to cover this $1,200,000 by dividing it by 12 months (being $100,000 per month.) There were several similar but complicated scenarios that were kept in mind that were responsible for the way the system was coded and functioned like Trusts, Customer, Premium, Billing Frequency, Billing Period, Invoice, Audit, Exception Charges/Credit Memos, Commission Checks, Cash Receipt, Corrections/Reversals. A Finance Charge Subsystem was meant for calculating the finance charges associated with accounts that have not paid off charges in a certain period was also part of the system. The Data Reporting feature was developed using Active Reports.

TECHNOLOGIES USED

– Programming Languages/Tools: .Net, C#, Active Reports
– Database: SQLserver 2000
– Platform: Windows Environment
– Documentation: MS Visio, Microsoft Word, Microsoft Excel, Microsoft Powerpoint

BENEFITS

The NYCM's Billing and Commissions Module enabled fast executions of calculations. It generated detailed billing and commission reports. The system provided automatic Invoice generation, Commission Handling, Finance Charge Handling, Invoice Handling, and Transaction handling.