Categories : All, Case Study, Finance, Microsoft Development
Client is a web application which will provide a financial platform with a mission to incentivize financial responsibility through Education (Library), Competition (Rankings) and Reward (accumulation of points to certain levels = rewards). Specifically, with the help of this application the user gets a financial-social platform to be connected with each other; share and get solutions over their financial problems and get rewards by managing their financial statements. Financial Service providers can provide their details in the resources section so that user can find and avail these local financial service provider’s services. Users can provide their own review regarding these financial service providers.
Client is a financial web platform for the individuals to manage their financial aspect. Client provide platform w here users can generate various reports to analyze their income and expense. Once user provides various inputs they are able to generate value creation component. Platform provides various competitive, compass reading and other reward summary to motivate users to participate on platform.
Client is basically divided into community and finance section.
Community section has elements like building associates, board members; invite friends, discussion in boardroom and water-cooler, FSP resources, libraries and test . Community section is free to access for all users.
Finance section has finance inputting (Income inputs, Cash flow inputs and Balance Sheet inputs), reports (Monthly & Annual Income Statement, Monthly & Annual Balance Sheet, Monthly & Annual Cash flow Statement), vitals. Vitals provide various value creation or competitive data.Vital sections have competitive ranking, compass reading, reward summary, income statement, cash flow statement, balance sheet statement competitive and ranking information.
Compass reading provide value creation since inception and for last 30 days. Client provide access to value creation component either via earning reward points or via paying one time or recurring subscription.
There is a FSP section for financial service provider to advertise their service offering. FSP can register and manage their account. FSP can subscribe for various paid activities like featured listing, priority listing and advance profile.
Ensuring more complex relation between data and their consistency. Each entity or information is being used in various places in conjunction with other information. Showing the most relevant information at various places by clear way of presentation is the main challenge as almost all the information is similar to the different entities.
|Operating System & Server Management||Red Hat Linux OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups|
|Quality Assurance Testers||1|
The design approach was built around PHP 5 and MY SQL SERVER 5 due to the financial nature of the application. In order to most effectively access the database in an object-oriented context, an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner. An intermediary abstraction layer was
created for accessing data from the database. Triggers, Stored Procedure and Custom MYSQL
functions were used only for complex calculation of data from multiple tables and were utilized heavily with the conditional syntax to ensure smooth performance of the website.
The UI layer was kept free of any business logic with images, applications and data being called from their respective servers. Web usability guidelines were strictly followed during development and the interface was made easily navigable through the judicious use of AJAX, CSS3 and HTML5 controls. The application was developed and fully functional within a span of 7 months.