Home > Merrill Lynch Award
Merrill Lynch Award

The award was for a system called the UAT Recon Data Mart. These programs aided the UAT Control team in administering a complex mirror approach to tracking the real stock market positions created through UAT scripts, while hedging these positions to avoid risk, and enabling validation of a new bookeeping system against the old system. The system consisted of two pieces. UATLoad, the load routine for the data mart ran nightly against production DB2 tables, and inserted data into SQL Server tables after cleansing and modification. The second piece, UATRecon enabled automated reconciliation of activities, positions and balances. The system used the following technologies: Visual Basic, DB2, T-SQL Stored Procedures, SQL Server