Cypher Consulting

Experience

Senior Data Analyst - Cypher Consulting

BC Ministry of Transportation Contract
(2009 - Present)

Key Consulting Projects

• ICBC Data Design Transition: Provided key consulting on a large-scale system redesign driven by a change in ICBC's data design.
  • Acted as the data expert, advising the ICBC data team on the Province's data needs.
  • Advised the software development team on data and system requirements.
  • Kept the Ministry of Transportation team informed on decisions and developments throughout.
• Province of BC AI Usage Initiative: Provided key consulting and testing on an initiative evaluating the Collision Information System as a candidate for AI-assisted updates.
  • Performed extensive testing and provided detailed feedback to the Province.
  • Made the team running the AI aware of the ramifications of its changes, which were making small modifications throughout the system and breaking functionality.
  • Advocated for the client's needs, withholding sign-off until the entire system was verified to be running as expected before any AI updates were pushed to production.

Ongoing Responsibilities

• Managed the Landmark Kilometre Inventory database in Microsoft Access:
  • Ensured data accuracy and integrity.
  • Queried data using SQL.
  • Updated highway segment, landmark, and classification data using Excel and VBA macros.
  • Wrote and maintained code to enhance efficiency and prevent errors.
  • Documented system processes comprehensively.
  • Worked with GIS mapping software and linestring geometry.
  • Generated KML files for use as layers in Google Earth.
• Managed the Collision Information System:
  • Processed and validated monthly collision data from ICBC, ensuring accuracy before integrating it into the Collision Information System.
  • Communicated with RCMP detachments to resolve data anomalies.
  • Worked extensively with linestring geometry datasets and Oracle SDO geometry.
  • Managed, analyzed, and validated traffic volume data, identifying and correcting inconsistencies to ensure accuracy.
  • Generated statistical reports.
  • Maintained system error logs, created system bug reports and uploaded them to the client's JIRA service.
  • Provided system testing and consulting services.
  • Managed and updated the Collision Information System website using CMS Lite.
  • Maintained and updated a custom VB6 utility for processing data per the client's needs.
• Developed and maintained software using VB6, VBA, Java, Fortran, SQL, Python, HTML, Kotlin, and batch scripting.

Fisheries and Oceans Canada (DFO) Contract

(2025 - 2026)

• Collaborated directly with the department's ocean scientists to define requirements and design a web application for visualizing oceanographic mooring data.
• Designed and developed the application using the Django framework, integrating it seamlessly with DFO's existing collection of applications.
• Built interactive map visualizations of mooring data derived from government-provided datasets.

Economic Cycle Research Institute (ECRI) Contract

(2024 - Present)

• Provided system analysis services to identify potential areas where automation could be implemented.
• Optimized Excel VBA software, streamlining user experience and improving system logging.
• Developed a VBA-based solution to integrate research software with web APIs, enabling real-time updates for international data.

Service Canada - EC-05 - Casual Employee

(2022 - 2023)

• Provided support for the Planning, Accountability and Strategic Analysis team in the Strategic Services Branch:
  • Developed Python scripts for data retrieval and manipulation from Oracle databases and Excel sheets.
  • Created visualizations and reports to enhance stakeholder decision-making.

Artist - Self-Employed

(2012 - Present)

• Actor, musician, and director in theatres across Western Canada.
• Member of Canadian Actors’ Equity Association since 2015.

Education

Bachelor of General Studies

Thompson Rivers University - 2021
Computer Science Focus

• Courses included:
  • Database Systems
  • Algorithm Design
  • Java, Python, C++, Operating Systems, Networking

Diploma in Musical Theatre

Capilano University - 2012

Skills

• Computer Systems Analysis
• Consulting / Communication
• Database Design and Management
• Data Analysis
• Programming / Software Development
• Computer Specification, Optimization, and Troubleshooting
• System Documentation
• System Testing / QA, including review of AI-generated changes

Software / Language Proficiency

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