Commercial Finance.

Case Study
Learn More

Validating Customer Information

The objective is to send customer vehicle-related data to a third-party process (Experian). This process will validate the initial sent data and send back updated customer data that would contain changes in customer address, phone, etc. After that, the return data will be used for further processing before loading into a data warehouse.

Contact an IT Specialist

The Challenge

  • Generating initial data in a pipe delimited file.
  • Encrypting the delimited file ahead of sending it to the third-party process.
  • Sending the delimited file via an FTP process.

The Solution

  • Create an ETL process to generate a pipe delimited file based on a predefined set of business rules.
  • Create a Java class that would handle the encryption of the initial file and decryption of the returned file (PGP, GPG, passphrase).
  • Create a loop process to check if the returned file is ready for pick up from Experian (Third party) before further processing and loading.

Features Added

  • Error handling with log registration.
  • Notification alert for successful or failed run.
  • Automating the ETL to run periodically.
  • Encryption and decryption mechanism to safeguard the data.
  • FTP process implementation.
advancio industries

Different industries.
Different problems.
All solved with technology.


We’ve had the privilege of helping numerous client companies in growth and impacting their respective industries, choose a Case to read about real-life scenarios of innovative software solutions and business transformations.


Subscribe For Awesome Articles

Get more tech and business development tips delivered straight to your inbox