endorsedOngoing

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

Services Covered:

Custom Software Development

Industry

Software Development

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

Toronto, Canada

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
Spring
Amazon Web Services (AWS)
Rest
Mockito

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Liftup had finished the project within two months, and the client had been using it ever since. The solution decreased their CSV processing time by half for files up to 60 million data lines. The vendor also quickly adapted to the client's needs, which was exactly what they'd been looking for.”
Cristian Beres
Founder & Solutions Architect
Date: 09/10/2021