H aving worked at world class banks for most of my professional career I have been able to gain a lot of experience over time in how the industry works. My model is unique in one way as that it has been implemented in several VLDBS environment holding millions of financial transaction for thousands of clients with over a hundred users using it on a day-by-day basis.
The design is such that users can be granted access to the system and see only data related to their role, function and region. Having this implementation helps stake holders justify the investment as users can query the model with any reporting tool using their active directory authentication. The model pre-calculates facts so that users can view their KPI’s without having to perform CPU intensive calculations.
The model is kept in-sync using non-blocking background tasks populating the model with data if data needs to be updated. This selective updating saves valuable CPU and disk time and has a low impact on the database log-file and therefore decreases backup volume and time.
Coming up is a full banking application set for clients (E-Banking) and Banking employees. I have created screen for:
Contact me if you would like to use part or all of my models; the Models are in PowerDesigner v.15.3., C# 4.0 and MS SQL Server 2012.