SQL Server Developer-Parsippany, NJ - Georgia IT Inc.
Parsippany, NJ
About the Job
SQL Server Developer
Location: Parsippany, NJ
Duration: 3 - 6 months
Visa: GC or USC Only
Needs work onsite for first 2 Weeks and then can work Remotely
· Changes to the existing Client Listing Report and Client Ad Hoc Extract to add TINS, Agent Bank Name, and Actual Address.
· Rebrand remaining reports and make them compliant with the new Client Bank template
· Risk Rating Project for Lender Finance - Report Changes
· Fix to the Prime Loans Interest report to use historic spreads instead of carrying the current spread backwards.
· Changes to UL Fee Report: Fix Interest Calc Days, add As Of Date parameter
· Exposure Aggregation: Develop borrower subtotal capabilities on all borrower based reports using on a new report group, and add report group to the Client Listing Report and Client Ad Hoc
· Fixes and changes to the Client Maturity Date Report – fix used line balance, new sorting, flag on dates, and fix behavior on delayed draws.
· New Agency Report for agency deals.
· Add Region filters to the Origination and Termination Dates Reports
· Break out the Status column on existing reports between Loan Status and Credit Line Status
· Fixes to Loan Rate Data Report
· TIC Report Additions
· Correct Asset Class on Client Ad Hoc and Commitment Delta
· Parameter consistency: Change report parameters for consistency.
· New Credit Line Delta Report
· Data Central Feed & Report - New report and extract to feed Data Central, replacing the existing manual process
· DCR - Add reference data to Stucky BI for NAICS code and description, add description where used in existing reports.
Location: Parsippany, NJ
Duration: 3 - 6 months
Visa: GC or USC Only
Needs work onsite for first 2 Weeks and then can work Remotely
· Changes to the existing Client Listing Report and Client Ad Hoc Extract to add TINS, Agent Bank Name, and Actual Address.
· Rebrand remaining reports and make them compliant with the new Client Bank template
· Risk Rating Project for Lender Finance - Report Changes
· Fix to the Prime Loans Interest report to use historic spreads instead of carrying the current spread backwards.
· Changes to UL Fee Report: Fix Interest Calc Days, add As Of Date parameter
· Exposure Aggregation: Develop borrower subtotal capabilities on all borrower based reports using on a new report group, and add report group to the Client Listing Report and Client Ad Hoc
· Fixes and changes to the Client Maturity Date Report – fix used line balance, new sorting, flag on dates, and fix behavior on delayed draws.
· New Agency Report for agency deals.
· Add Region filters to the Origination and Termination Dates Reports
· Break out the Status column on existing reports between Loan Status and Credit Line Status
· Fixes to Loan Rate Data Report
· TIC Report Additions
· Correct Asset Class on Client Ad Hoc and Commitment Delta
· Parameter consistency: Change report parameters for consistency.
· New Credit Line Delta Report
· Data Central Feed & Report - New report and extract to feed Data Central, replacing the existing manual process
· DCR - Add reference data to Stucky BI for NAICS code and description, add description where used in existing reports.
Source : Georgia IT Inc.