Data formatting app

Whilst working at Drive Electric (an electric car leasing company), I created a data processing app for internal use in data formatting. Once completed, it saved the company over 20 hours of work a week, which had previously been spent manually formatting large financial data sets.

Although it would have been ideal for the process to be entirely automated—such as through an API call to the banks to request their data—none of the banks offered such a service. As a result, functionality had to be designed around this limitation. Users were required to first upload raw pricing data (containing tens of thousands of entries across varying car models, terms, and mileages). Each bank had its own unique data format, and the app would convert the respective file into a unified format that could then be uploaded to the CRM system for company-wide use.

Even after the project's completion, I continued maintaining the app for the next 18 months, as banks frequently changed their formatting, requiring adjustments and reinterpretation. I also used the formatted data for pricing analysis and discovered that some car models unexpectedly appreciated in value over longer-term periods—an insight that proved valuable.