Capgemini - Customer Case Study

AMS is a data staging system that imports and converts data into a specialized format for import into the Dyna financial modeling system. External outsource service providers send simple files which are imported and converted through 3 databases. SSW's role was development in Visual Basic, JavaScript and SQL Server 7.0 stored procedures. This involved building stored procedures to do data transformation and building an ActiveX component to queue and run batch jobs. The web interface required programming in JavaScript and VB COM objects. SSW worked on this large 3-tier ASP/VB/SQL Server 2000 project. One of the requirements was to create a specialized data transformation system to feed data into an asset management system for predicting future rental prices on all properties owned by the Commonwealth Bank. The data would come in as CSV and tab-delimited files (amongst others), which would be read into the first SQL Server database via DTS. Following this, stored procedures moved and transformed it into the second SQL Server database where it was in a standard format. Then stored procedures moved it into a third database which was in a special format for output into a text script that the Commonwealth Bank Asset Management package could read. The 'Administration' and 'Script Importing' sections of this project used an ASP interface created by SSW. Validation of the imported data was done in DTS via a Visual Basic 6.0 COM object called by the DTS ActiveX scripts.