Harbans Heer

I optimized a DWH that was slow running, didn't contain any error handling or logging, didn't have a robust ETL, and didn't process the customer analytics cube successfully. I added error handling into the SSIS packages, created monitoring and reporting of the batch, optimized the SQL procedures and code, and fixed the bugs in the cube. These improvements reduced the batch run time from 8 hours to 4 hours.

I was the lead developer for the migration of an AML application from SQL 2005 to SQL 2008. The application comprised multiple components that extracted data or linked to a number of different sources. Some of these sources were test databases as opposed to production databases. The sources all had to be aligned to production and tested for accuracy before migration was performed.

I assisted in the migration of a mainframe application to a Windows-based application designed to improve accuracy and efficiency. A two-tier application, consisting of VB6 screens for the interfaces and MS Access for the core processing, was designed to accept information via media input, process it, and produce the monthly client statements.

My role included:
• Investigating and documenting client requirements by means of functional and technical specifications.
• Object-oriented analysis and design (taking measures to record and resolve technical issues).
• Coding, testing, and implementing application code using VB and MS Access.
• Producing and maintaining documentation for all phases of the project.
• Providing post-implementation support to the client.

The overnight batch for a P&L data warehouse was failing to complete within the required SLAs, and it wasn't providing an estimated completion time. I built an ASP.Net MVC application that monitored the queue of P&L entries to be processed. It enabled the overnight support team to see how many records had been processed, how many were processing, and how many were waiting to be processed, along with estimated completion times.