I was wasting too much time each month converting timesheet data into invoices
Development
Previously I worked as a front-end web developer, working with HTML, CSS and Javascript (mostly using Javascript's React, Jquery and NodeJS libraries) for 4 years, starting as a freelancer and then full-time employed.
I enjoy using the skills I have learnt in that industry to create applications to solve problems (such as an invoicing tool from when I was freelancing that imported my timesheets and generated an invoice based on the timesheets). Recently I have started using my programming skills to work with data. I find the beauty of data analysis being that data is often flexible in terms of it's application and you have a lot of choice in choosing the tool you feel is best for the job of analysis. Sometimes it's SQL, or Excel or Python or even a combination. To this end I have started building a football statistics analysis tool that uses NodeJS to fetch csv files containing data which is then stored in a bespoke MySQL database I created and then uses Javascript to perform analysis and display the results. This project is still in it's early stages so there is nothing to see yet but you can find some completed projects below with links to my Github repo.
Portfolio
Problem:
Solution:
An app that produces printable and itemised invoices.
Implementation:
Invoice data is entered and saved to the database along with a timesheet reference.
Timesheets can be exported from Excel in CSV format and imported and processed by Invoicer
The timesheet reference acts as a hook to retrieve the CSV data and import it to the invoice ready for printing.
Written in the functional component React style
Features pagination component to help the user browse through invoices
Uses custom hook to manage status notifications returned from API calls
Uses Typescript to make the development process more efficient
Stack:
Problem:
I wanted to make a to-do list that was a bit more interesting than a typical list
Solution:
An app modelled on the real world scenario of putting sticky notes on a fridge.
Implementation:
Notes have a random tilt applied.
Originally written in plain Javascript with no data storage.
Refactored to explore the Svelte programming workflow.
A MongoDB back-end was added to store the note data
Stack:
Problem:
I wanted to quickly select slideshows and videos to play through a projector whilst playing music at home
Solution:
An app that uses Javascript functionality to automate switching between slideshows and videos.
Implementation:
Takes advantage of the asynchronous nature of Javascrpt to sequence slideshows and videos
Slideshows and videos can be triggered individually or combined in 'stories'
The mobile interface allows the user to trigger the various media.
An admin interface can be used to upload media and create stories with various settings for duration and randomness
Originally written in class component style React
Admin and Launcher re-written to use functional React and custom hooks
Stack: