Hi All,
I have come across recently on Mutual fund DB knowledge.
Basic Functionality (Flow of Data)
1. Trade Account creation (Folio is Generated)
2. Trade any funds from fund houses/Distributors/ Agents/Direct Online
3. Allotted units against the Trade amount / As on NAV (Net Asset Value on trade Date)
4. If you want to sale/Redeem your purchase funds You can redeem available units.
5. If you want to switch from your existing funds to new funds.
Switched internally its redeem from existing funds to purchase new funds.
6. If you want to switch out systematic funds transfer to your account.
In terms Database prospective.
Masters:
1. Category (Debt/Equity)
2. Fund house
3. Schemes
4. NAV
Tools Used:
1.Calastone Tool to transfer files from one source to different destinations any file formats (instead fax)
2. Forex (If Asset Management Company located in different regions and investing in different currency)
3.SSMS/ ? any DB
4. Any UI (.net/Jav App)
5. Third party integration with NSE/BSE for Master Data
