Ryan Yee Email & Phone Number

Vancouver, Bc

Designed and sketched Entity-Relationship Diagrams(ERDs) using LucidChart/Draw.io to model database structures.Authored comprehensive Technical Design Documents to outline projects requirements and architecture.Developed and maintained backend features with Python/Django, including API development, data management, and deployment planning.Executed unit and integration tests to validate code quality and functionality.Managed task creation and system design updates by creating Jira tickets, refining ERDs, and updating technical documentation to align with evolving project blueprints and MVP requirements.

Coquitlam, British Columbia, Canada

Achieved a 50% Increase in website loading speed to enhance overall performance, utilizing tools such as Google PageSpeed Insights and GTmetrix.Developed a Shopify application to fetch orders, applying additional logic based on a COGS template, and enable users to seamlessly download order data in XLSX format.Implemented a pricing solution using logic that adjusts product prices within orders according to their standalone status or as add-ons, simplifying cost calculations based on order position. This automated a previously 2-hour daily task of manually editing an Excel sheet with just a simple click of a button.Developed a SKU parsing algorithm utilizing regular expressions to accurately categorize products based on SKU patterns, enhancing pricing and organization within order data.Resolved pre-consent cookie firing issues by optimizing and customizing third-party scripts to align with GDPR requirements, strengthening user privacy and compliance for the company’s website.

Diploma, Software Development

Electrical Engineering