Enhanced Security and Efficiency in Financial Data Entry
Case Studies
Challenges & Solutions
Technical Environment
Executive Summary
Client
Finance Client
Industry
Banking, Financial Services, & Insurance
Business Problem
The customer’s existing applications required significant human intervention to enter data from forms with numerous fields. This manual data entry was time-consuming and led to human errors and data quality issues. The customer sought a solution to minimize human data entry, thereby improving the speed of data gathering while ensuring data quality.
Outcome
- Data breach.
- Audit trial.
Challenges
- Forms submitted by customers contained a large number of data items, making data entry cumbersome and error-prone.
- The existing systems lacked support for OCR/form upload features and automation of data extraction and loading.
- Updating these systems to accommodate modifications was time-consuming and hindered modernization efforts.
- Additionally, the rigid architecture of the existing system prevented the integration of data enrichment services.
Solutions
- Developed a desktop application designed to minimize manual intervention through extensive automation.
- An enhanced security-based architecture was implemented to prevent data breaches.
- Well-defined business requirements were identified and integrated to minimize data leaks.
- An MVVM architectural model with a robust framework was built and aligned with the financial domain, incorporating all necessary calculations.
Technical Environment
- MS visual studio 2019
- GUI developed in windows presenter foundation version V6.0.2
- MVVM architecture
- Programming language – C# version 7.3
- Database – MYSQL 8.0 CE
- QA framework – manual
- Data entry automation