SQL Server 7.0 development using stored procedures, triggers and views. System and OO design and architecture using use cases, CRC and UML strategies. Familiar with Rational Rose. The Government Allocation Program distributes scheduled contributions for active and retired members of the military and civilians on monthly basis. Files are received from the state street bank on a monthly and daily basis.
Monthly file is received on first day of the month and called blanket file.
Daily file is called composite file. Blanked file is matched against the database and search is performed to allocate contributions to the proper fund and account number. The unmatched records are left for research. Same processing is done for the composite file. Any of the unmatched records are researched and applied and second transmission file is sent to DST on 5th day of the month.