Case Study Web Application to Facilitate Foreign Currency Exchange
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 4
Client
Requirement
The client is a multi-national financial conglomerate who demanded a reliable tool to facilitate the actual process of managing the currency conversion transactions. The application provides quick and easy access to the currency positions at any point and also ensures data integrity along with providing online reports in compliance with Central Bank. The application is designed and developed to accurately convert any currency into MUR (Mauritian Rupee) according to the latest currency price and gives accurate output after calculating the commission for each transaction. The application’s highlight is its ad-hoc reporting capability. The application user’s are as follows: Admin: The Admin users will create role and grant access to everyone in the system. They can also track and report activity carried out throughout the system. Manager: The Manager will track the available currency and total transactions performed in a day. He is also responsible for creating an opening balance with each cashier as he solely allots currency to each cashier for transaction processing. Cashier: The Cashier is basically the users that record transactions in the system and deal with customers. They share records with the Manager and are also responsible for closure activity for each day. The application is divided into following accounts: Master-Till Account: This account maintains the record of the total currency collected along with the master record of branch’s overall earning. Swift Bank Account: The application converts travel cheque’s directly into the currency. The customers can demand bank for currency transfer which is handled through Swift Bank Account. Suspense Account: During daily closure, Cashier checks the amount and if there is any erroneous transaction it is subjected under Suspense Account and is rectified.
Project
Challenges
The challenges faced were:
Converting a currency into multiple currencies.
Transferring currencies via. Swift Account by applying complex calculations and deducting commissions behind every transaction.
Calculating average value of the currency purchased.
Ensuring secure transfer of data.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 4
Technologies Operating System & Server Management
Development Tools & Environments
Used Windows 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 .Net Framework 4.0, JavaScript, JQuery, Microsoft Visual Studio, HTML, CSS etc. MSSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Database
Manpower Project Leader
2
Developers
3
Designers
2
Quality Assurance Testers
2
Planning Keeping in mind the structure of the website and the challenges involved, a four-tier development approach was adopted consisting of:
The Database layer containing MSSQL Server Database, Tables, Stored Procedures and so on.
The Interface layer and Database Abstraction layer for converting data between incompatible type systems in databases and accessing data from the database respectively.
The Business Logic layer consisting of all the business logic procedures for interactive modules.
The User Interface layer which forms the Graphical User Interface of the website.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 4
Architecture
Development
Highlights
The site was equipped with a robust architecture to offer centralized access to multiple users. Customizable viewing options were designed to enhance user experience and allow personalization. Access control and other security measures were taken care off. The web application was developed keeping the SEO-promoted architecture in mind. Also, the reporting flow chart was used to show profit and loss charts. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of HTML and CSS controls. The site was developed and fully functional within a span of 4 months.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4