Financial CSV Analysis System for Web Agency (Java & AWS)
Services Covered:

Industry
Software Development
Duration
44 months
Budget
50K - 199K
Start Date
1 January 2018
Team Size
1-5
Engagement Model
Offshore
Project Capability Score (PCS)
73/100
Good
Project Capability Score (PCS) estimates how capable LiftUp is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS
Client
Synergo Group
Project Summary
LiftUp augmented a web agency's team to build a financial analysis system that validates and analyzes large CSV accounting files. The solution used Java 8, Spring and AWS to identify currency data sets, map and group values, and detect formatting issues. Delivered within two months, the system halved CSV processing time for files up to 60 million lines and the client continued to use and extend the solution.
Key Challenges
- Build a system to identify currency data sets and validate CSV accounting data
- Map/group values of the same kind and detect empty or wrongly formatted data across thousands of lines and hundreds of files in a short time span
Project Deliverables
- Financial analysis mechanism for CSV files (validation and currency identification)
- CSV validation features and grouping/mapping of values
- System capable of processing files up to 60 million data lines with decreased processing time
Project Solution
LiftUp developed a financial analysis mechanism for CSV accounting files that identifies currency data sets, groups/matches values, detects empty or incorrectly formatted values, and validates CSV data at scale. The vendor added CSV validation features and optimized processing to handle files with up to 60 million lines. The implementation used Java 8, Spring, AWS and exposed REST interfaces; the small vendor team (PM, tech lead, administrative specialist) worked closely with the client and delivered the solution rapidly.
Project Outcome
- Decreased CSV processing time by 50% for files up to 60 million data lines
- Delivered earlier than expected and the client continued to use and extend the solution
Platforms
Cloud
API/Integration Platform
Tech Stack
Java
SpringAmazon Web Services (AWS)
Rest
Mockito
Client Endorsement
Overall Review Rating
5
5 out of 5 stars
Timeliness
Cost Rating
Willing to Refer
Quality of Deliverables
Liftup wrapped up the project in two months, and we've been using it since then. The solution cut our CSV processing time in half for files with up to 60 million data lines. They also adjusted to our needs quickly, which was exactly what we were hoping for.
Note: This endorsement is based on publicly available client feedback from external review sources.
More Projects by LiftUp
Endorsed
Ongoing
Education
Accessible Mobile Health App for Older Adults (iOS & Android)
Services Covered:
+3 more
Endorsed
Ongoing
Hospitality, Travel & Tourism
Database Restructure & Angular-to-React Migration for SaaS Platform
Services Covered:
+3 more

