Digital
Development of Automated Data Integration and Data Processing Application
A global Insurance holding company required an automated solution that can integrate business logic from multiple applications, pull data from different sources, apply business rules for output data and send notifications to optimize efficiency and streamline the user experience.
Client Challenges and Requirements
- Hybrid Application Development: The need to create a hybrid application that combines existing and new functionalities.
- Data Integration: The need to efficiently extract and integrate data from various sources.
- Business Logic Implementation: Generating output in accordance with specific business rules.
- Maintenance and Management: Streamlining the maintenance and management of their systems.
Bitwise Solution
- Conduct reverse engineering to identify the business logics existing in VB scripts.
- Update the existing application to the latest version of C# .NET Core, implementing dependency injection.
- Implement a notification system based on client-defined business rules to expedite verifications.
- Introduce a robust functionality for managing master data, allowing for accurate addition, updates, and deletion of master records.
- Eliminate dependencies on Essbase cube and PeopleSoft to optimize and reduce processing time.
- Develop a hybrid application with a Windows-based user management module, incorporating diverse modules for more efficient maintenance.
- Implement export to Excel function for output and masters.
Tools & Technologies We Used
Asp.net
C#
SQL Server
.NET Core
Windows forms
Excel
Key Results
Automation of the process for hassle-free and streamlined flow
Optimized performance
Improved communication and collaboration
Significantly reduced data reconciliation time from 25 minutes to 3 minutes
