Design and maintain a Microsoft Access database to store thoroughbred horse racing data to support a US-based syndicate with over $500K invested in a web 3 metaverse project.
Silks.io - A US-based syndicate with over $500K invested in a web 3 metaverse project.
Employment Ontario Service Provider
Thornhill, ON
Database Specialist
01.2012 - 07.2022
Job overview
Developed custom case management systems in Microsoft Access automating client, employment consultant, job developer and incentive administration processes.
Ongoing support for in-house database including report development, ad hoc queries, and development of new requirements.
Responsible for data integrity across in-house (Microsoft) and government (CaMS) data management systems.
Interviewed, tested, trained, created training manuals and ensured data integrity for all administrative positions including Data Entry Clerk and Incentives Administrator positions.
Legal Aid Alberta
Edmonton, AB
Systems Administrator
09.1999 - 12.2011
Job overview
Responsible for office systems and network administration at Youth Criminal Defence Office (YCDO) with offices in Calgary and Edmonton.
Wrote a proposal and was successful in obtaining funding to refresh hardware and software and design a customized case management application.
Designed, developed and deployed custom case management system with Microsoft Access front end and SQL Server back end to automate lawyer (court, case and billing) and youth worker processes.
Developed reports for Microsoft Dynamics 4.0 Case Management systems for Legal Aid business units. Support for legacy YCDO Case Management System including monthly KPI reporting and ad hoc queries.
Golder Associates Ltd.
Burnaby, BC
Database Specialist, Information Systems Group
12.1996 - 01.1999
Job overview
Joined Information Systems group December 1996 to focus full-time on designing and maintaining databases for large projects with complex data requirements.
Ensured data integrity for laboratory and field data.
Generated reports using Access, Excel, Paradox and SigmaPlot.
Also created Access front-end user interfaces for several Golder clients.
Golder Associates Ltd.
Burnaby, BC
Environmental Group Coordinator, Environmental & Health Sciences Group
01.1993 - 12.1996
Job overview
Project and proposal coordination, scheduling and financial tracking, production of a monthly newsletter for the International Health and Environmental Sciences Group, meeting and conference organization, and designed/maintained a Microsoft Access database for tracking environmental project experience across Canada.
The group expanded from 22 to over 40 engineers, scientists and technicians during this time period.
I reported directly to the head of the Environmental group who was also President of Golder.
Timeline
Database Specialist
Alpha Racing
07.2022 - 07.2024
Database Specialist
Employment Ontario Service Provider
01.2012 - 07.2022
Systems Administrator
Legal Aid Alberta
09.1999 - 12.2011
Database Specialist, Information Systems Group
Golder Associates Ltd.
12.1996 - 01.1999
Environmental Group Coordinator, Environmental & Health Sciences Group
Client Relations / Logistics Specialist at Conquest Racing (Ferrari Racing Team)Client Relations / Logistics Specialist at Conquest Racing (Ferrari Racing Team)