Cypher Consulting

Senior Data Analyst – Cypher Consulting
BC Ministry of Transportation Contract
(2009 – Present)

• Managed the Landmark Kilometre Inventory database in Microsoft Access
  • Ensured accuracy of data and database integrity
  • Queried data using SQL
  • Updated highway segment, landmark, and classification data using Excel spreadsheets and VBA macros
  • Wrote and maintained code to increase efficiency and prevent errors
  • Wrote clear and concise documentation for system processes
  • Worked with GIS Mapping software
  
  
• Managed the Collision Information System
  • Retrieved monthly batches of accident data from ICBC, ensured accuracy of information, and loaded them into the Collision Information System
  • Communicated with RCMP detachments regarding data anomalies
  • Extensive work with Linestring Geometry datasets and Oracle SDO Geometry
  • Maintained and submitted system error reports
  • Provided system testing and consulting services
  • Managed annual Traffic Volume datasets
  • Maintained Collision Information System website using CMS Lite
  • Generated statistical reports
• Provided technical support to end users
  
• Wrote and maintained software and systems using VB6, VBA, Java, Fortran, SQL, Python, HTML, and Batch Script

Economic Cycle Research Institute (ECRI) Contract
(2024)

• Optimized Excel VBA software, streamlining user experience and improving system logging

Service Canada – EC-05 – Casual Employee
(2022 – 2023)

• Worked for the Planning, Accountability and Strategic Analysis team in the Strategic Services Branch
  • Provided support and consultation on a human resources database project
  • Created and edited Python scripts for the retrieval and manipulation of data from an Oracle Database and Excel sheets
  • Created reports and visualizations to help stakeholders better understand the data being transferred and its implications for the organization

Artist – Self Employed
(2012 – Present)

• Actor/Musician/Director in theatres across Western Canada
• Member of Canadian Actors’ Equity Association since 2015

Bachelor of General Studies – Thompson Rivers University – 2021

• Computer Science Focus
• Courses in:
  • Database Systems
  • Algorithm Design
  • Java, C++, Operating Systems, Networking

Codecademy courses in Python and Java

Diploma in Musical Theatre – Capilano University – 2012

• Problem Solving / Creative Thinking
• Consulting / Communication
• Database Design and Management
• Data Analysis
• Programming / Software Development
• Computer Specification, Optimization, and Troubleshooting
• System Documentation

• Microsoft Access, Excel, Visio, Power BI
• Proficient in VBA, Python, Java, SQL, Batch Script
• Familiar with Fortran, C++, C, HTML