SellYourClassic

Teravision’s nearshore agile team had the formula for developing this Orlando-based niche automobile marketplace

Sell Your Classic (SYC) is a well-known player in the American classic car market. With more than 15.000 unique cars available and a massive amount of photos to process, they needed to refresh and unify the user experience.

This is where the ETL (Extract-Transform-Load) process came in handy. It was needed to download, process (crop, resize, filter, dismiss, others) and re-upload all of the automobile images on the site.

Teravision Technologies and SYC are working together on optimizing their marketplace in order to increase customer loyalty.

Technologies used: Amazon Web Services, Firebase, PHP, WordPress

We work with a:

Fixed Scope Software Development

The Team:

The task was to deliver a turnkey Project Rescue to make all photos available on an ongoing basis.

The team assigned to reload this web marketplace was:

Project Management

Scrum Master

QA

QA Manager

· One QA Specialist

Development

Two Full Stack Developers

DevOps

DevOps Specialist

Software Architecture

One Software Architect

Customer team collaboration was crucial to success.

SYC gave Teravision’s team full access to codebase, documentation and pinpointed the bottlenecks in the existing photo processing engine.

To set a comprehensive code optimization of previous PHP routines, an architect and a tech lead isolated the slow code areas and substituted these segments with a new, less recursive code and added the option of passing bigger parameters within each call.

The photo processing has three sides: extract, transform and load. While the development team worked on making the previous code faster, the QA and DevOps teams worked on ensuring that all uploads were in the right place with the expected quality at the CDN.

Existing assets and code were diligently provided by the Product Owner. Multi-threading all uploads was crucial to reducing processing time from hours to minutes for each gallery.

Ulyses Torres

Product Owner

“There were three things I appreciated most from Teravision.

First of all, their level of knowledge and professional way to handle meetings. They realized the need for massive photo uploads, independent loads and the use of Cron Jobs as nobody had before.

I just left the work in their hands.

Second. Daily meetings were rich and transparent. We corrected the course in a timely manner when needed.

Third. Commitment to troubleshoot and solve complicated situations. They never told me “it can’t be done” and even better we saved around $7 per photo in comparison to other providers.

Essentially they never gave up, they investigated and solved.

We will work together in the near future, for sure.”

Ulyses Torres – Product Owner

Highlights in ETL

Re-coded and sped up image processing. Our team rewrote previous direct petitions code to make image processing faster than before. They also developed a new method of processing using other PHP techniques.

Decreased the calls to Firebase. We optimized access to gallery functions by making all calls related to one gallery in just one JSON instead of multiple tiny resource-consuming calls.

Multi-threading. We ran the same routine over mutually exclusive sets of photos for faster processing.

Use of a CDN (Content Delivery Network). We used AWS S3 to make all automobile images available as fast as modern business standards require.

Set up a nearshore team in Colombia for your ETL and software development needs.

Contact Us. Your business deserves the right software to grow. We’ve got the ingredients to build it.