Our client is a financial advisor having 30+ years of experience in this field. He is also having excellent skill in handling Ms-excel. Client have done research and made few algorithms on paper and in ms- excel that will give 90% accurate prediction in investment, mutual funds etc.
He needs a system in which he will insert a person's details and get an accurate result in seconds. Which gives output as reports, graphs, solutions in such a way that the end user can easily understand it. Also the system should accept payment and proceed for membership etc.
Understanding logic from ms-excel and putting it into some other programming language with enhancement. To make it happen, client have collected data from the market for more than 10 years, obviously the database for the past 10 years is huge. Providing a quick result based on that database with lots of calculations is challenging.
We have used a combination of structured and unstructured databases both. Depends upon the requirement we fetch data from related structured/unstructured database. Our role was to implement a robust and scalable solution that will also collect data from current market to give user more accurate result. We have also used Cloud servers (AWS) using API’s to achieve these results.There are other solutions / enhancement / features :