Alvin Yap Email & Phone Number

Toronto, Ontario, Canada

● Creating a monitoring pipeline for snowflake queries to quickly triage long running queries decreasingsnowflake costs by 5%.● Developed POC to consume telemetry events from Terraform Cloud service via AWS Kinesis, providingadditional layer of security and processing while decreasing cost from previously used paid tooling.● Wrote PRDs to clearly document various project problems along architectural diagrams in confluenceto communicate complex project specifications to both technical and non-technical stakeholders● Enable new telemetry data assets while collaborating with product team allowing for more accurate insights into customer behaviour.

Toronto, Ontario, Canada

- Lead data infrastructure deprecation efforts to migrate legacy Cloudera Impala and MySQL database reliant systems to Snowflake enabling real-time data to our operations team.- Increased workflow efficiency by 30% by automating and containerizing an internal forecasting and logistic optimizer script as a web application. Reduce manual troubleshooting time by 8 hours a week. - Developed data models for Recipe Complexity, enabling more accurate customer trend analysis with a 5% improvement in trend predictions.- Provide mentorship and guidance to co-ops and Jr engineers through weekly one on ones and code review sessions.- Improved accuracy of customer churn and customer acquisition by 15% through a productionalized customer deduplication graph network.- Maintain portfolio of production level Databricks notebook which feed into various operational tooling- Prototype NLP model to gather and categorize user comment data- Optimize legacy SQL queries improving query efficiency by 15%- Develop and maintain CI/CD automation for various data pipelines and projects via GitHub Automation

Oshawa, Ontario, Canada

• Created regression test scripts/scenarios for a 3rd party software integrating with CAB systems. • Developed an ETL pipeline via DB2 and IBM DataStage to monitor data storage usage of key databases, predict future usage, and aid in decision making of when to increase storage capacity.• Engineered Data Analytic Reports via IBM cognos to aid in forecasting projects.• Performed QA testing of internal systems and created/maintained defect ticket database.-Preformed requirements gathering, and translating business documents into technical specifications tasks.-Preformed research and evaluation of the technical components in the acquisition of software, hardware, technology, systems and products-Recommended and aided in the measurement and improvement of tools, techniques, standards and performance criteria to control the quality of application development initiatives-Aided in the development of testing, integration and implementation of systems solutions into the clients' applications

Ontario, Canada

• Created end-to-end test scripts using C# and Selenium Webdriver to thoroughly test Moniroo Expense Management app.• Performed version upgrading of legacy Moniroo to current SenchaJS framework.• Full-stack development of Moniroo Mobile: specifically, SQLite database development.• ETL pipeline development for data migration from old manual test scripts to new automated scripts.

Ontario, Canada

A Medical Radiation Technology student at Markham Stouffville Hospital.Experience in emergency,fracture clinic, and OR x-ray duties.

Bachelor'S Degree, Computer Science, 3.7

Software Engineering Technology, Computer Science, 4.3 Gpa

Bachelor Of Science - Bsc, Medical Radiologic Technology/Science - Radiation Therapist

Bachelor Of Science - Bs, Forensic Chemistry