Senior Software Engineer – ITS Consulting

Aug 2020 to Present

• Reviewed client legacy code and developed an agile project plan/estimate for upgrade, bug fixes, documentation, and maintenance. Successfully continue delivering on that upgrade plan.
• The legacy application is so old/out-dated it still uses HTML tables and jQuery AJAX calls. The plan is to slowly upgrade the entire app to modern API’s, microservices, and React front-end component.
• Senior front-end (React/Bootstrap) and back-end (PHP, SQL, Bash) developer.
• Built an AR app for a startup R&D project.
• Built an AWS S3 file storage integration with WordPress for a religious organization.
• Built an internal dashboard for managing information security event notifications.

Co-Founder – Lakebed.io

Jan 2018 to Present

I built a data lake for Cansure. At the same time I was volunteering for the City of New Westminster on their Open Data. The City of New West expressed frustration about the number of disparate data sources (taxes, business licenses, dog licenses, building permits, etc, etc, etc). They also expressed frustration that it takes a day or more to “anonymize” data before making it openly available. The Open Data files are then hosted as flat, text files on their website server.

The challenges New West staff expressed sounded awfully similar to the challenges Cansure expressed, and before that Optimum Insurance. I believe all businesses need to pull together disparate data, make it easily accessible, query via APIs, and manage permissions/security.

So, I built Lakebed!

Senior Underwriting Analyst – Cansure Insurance

Feb 2016 to Jul 2018

• A newly created role designed to streamline audit & compliance processes and build management information systems.
• Built a standardized audit template resulting in faster audit responses and less need for discussion around audit response.
• Audit response time decreased from 18+ months to 2 months.
• Received praise from Lloyd’s markets and audit staff on the efficiency of the system, usability, and comprehensiveness.
• Built, operated, and maintained a data lake on 2 distributed servers within the office network.
• The data lake was able to import 1,800,000+ rows from 4,200+ Excel spreadsheets in less than 24 hours.
• Brought the data from ~24,000 claims in ~2,000 spreadsheets into the data lake and built a tool for searching claims. Underwriters used this tool for renewals rather than discussing each renewal and each claim with the claims staff.
• Built reports combining all spreadsheets of underwriting and claims data. These reports were used in Lloyd’s contract negotiations to show immediate impact of management decisions.
• Built an online insurance quote tool in 2 months that worked within Lloyds’ requirements for human review of policies prior to binding. The tool was so efficient and easy to use it was preferred by internal underwriting staff as well.
• Built an web app for policy renewals in 4 months that was integrated in an associations website for the members’ use. Within specified criteria association members could fill out renewal details, obtain a quote, issue a policy, and pay by credit card.