Cypher Consulting

Experience

BC Ministry of Transportation Contract
(2009 - Present)

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.

(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.

(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.

(2012 - Present)