BECS found themselves in a situation where the company lost access to their accounting software (because of vendor issues). All they received from the vendor was a backup 💾 of the MySQL database. But this was useless to the average person. So through a reference they got in touch with me, and I was able to help them by:

• restoring this backup to a temporary Google Cloud MySQL server
• Analyze the database schema and data
• reconstruct their quotations and invoices through writing custom SQL queries
• validating the query results against old pdf quotations and invoices from their clients, to make sure that the calculations matched.
• export the reconstructed database query results data to CSV format so that they could be imported into their new accounting software Quickbooks.

This allowed BECS to could continue their administrative operations 👍🏽

Automated ordering saves time, and the mobile app allows the business to have a direct communication channel with it’s customers through push notifications improving on their customer engagement.

Assist the Smart Wheels brand in the following areas:

• Research and advice on SaaS Car Rental Online Reservation Systems
• Research and advice on local online payment options and service providers
• Search Engine Optimization (SEO) improvements, including:
  • Linking the website to Google Search Console
  • Adding a Blog section to the website for articles related to Curaçao, cars, and helpful tips for tourists
  • Adjusting website page titles and meta information for better search engine recognition
  • Integration of Google Analytics for website traffic monitoring
• Setup a vehicle reservations integration for customers that buy vacation packages through by June and Corendon
• Ongoing website maintenance and updates

Assist the Smart Wheels brand with the expansion to Bonaire in the following areas:

• Succesful configuration of the Bonaire web domain
• Allow for easy re-use of the existing Curacao website version for Bonaire, by migrating website files to separate web server.
• Remove and/or update existing Curaçao content (images, video, text, articles, SEO) to match Bonaire branding
• Setup a vehicle reservations integration for customers that buy vacation packages through by June and Corendon
• Ongoing website maintenance and updates

The project consists out of 3 deliverables

1. Wordpress plugin to display winning numbers results on website.
2. Winning Number Results Manager Web Application that is used internally to Create, Read, Update and Delete results and send out Push Notifications to mobile phone app users.
3. Mobile App that:
   1. Shows their existing website on the main screen,
   2. Supports push notifications,
   3. Search feature where users can look up past draw results.‍

Curaçao Sports & Movement Guide was designed from the ground up as a website and packaged as a PWA (Progressive Web App) to be easily navigated, searchable, linkable and installable as a mobile app so you can find to the information you need quickly.

This project was a collaboration with the Fundashon Guia Di Deporte to provide a comprehensive guide to all sports and movement related information on the island.

Coming from a web development background, I wanted to learn more about developing mobile apps for the iOS and Android platforms. So I took the time to explore these platforms and their tooling. This ended up being my first mobile app published to the app stores.