--- title: "Resume" date: 2019-02-11T07:50:51-05:00 draft: false --- {{% resume/section projects %}} {{% resume/project name="AML Risk Analytics" languages="Python, SQL, Tableau" date="July 2025" show="true" %}} * Built an end-to-end AML simulation using **Python**, generating **9M+ records** across customers, transactions, and alerts to mimic real-world financial behavior and suspicious activity patterns. * Wrote advanced **SQL (CTEs + joins)** to classify **high-risk customers**, calculate alert counts, and filter transactions over the past 90 days with aggregated metrics. * Engineered a **risk scoring model** in Python using transaction thresholds and alert volume to classify customers as Elevated or Critical risk. * Designed **interactive Tableau dashboards** (Risk Heatmap, Alert Efficiency, Risk vs. Avg Amount) to visualize cross-country AML exposure and alert effectiveness. - **Developed KPI-ready metrics** (alert rate, avg USD exposure, transaction volume) to drive AML performance reporting and enable cross-country risk comparisons. - **Normalized multi-currency transaction data** to ensure consistent exposure calculations across USD, CAD, and EUR, supporting reliable AML metric aggregation. {{% /resume/project %}} {{% resume/project name="Spotify Visualized" url="https://github.com/Kevin-Mok/astronofty" languages="Python, Django" date="June 2023" show="true" %}} - **Built a high-performance Python backend** using Django and PostgreSQL to process 10K+ data records per user, optimizing ingestion pipelines via API integration and ORM modeling. - **Engineered normalized database schemas** to streamline query workflows, achieving a **50% reduction in PostgreSQL latency** for high-volume reporting tasks. - **Visualized user music libraries in Tableau**, creating dashboards that grouped tracks by **artist and genre**, enabling users to explore listening patterns and discover trends in their Spotify data. {{% /resume/project %}} {{% resume/project name="Rarity Surf" languages="Python, Django, JavaScript, React" date="Oct 2022" show="true" %}} - **Built a full-stack reporting tool** using React, Django, and **PostgreSQL** to analyze structured/unstructured metadata from APIs, enabling real-time rarity scoring and improving insight delivery by **80%**. - **Optimized SQL query performance** within a Django-based pipeline, processing NFT ranking data at scale and exposing results via GraphQL with **low-latency response times under high concurrency (2,000+ queries)**. {{% /resume/project %}} {{% /resume/section %}} {{% resume/section "Work Experience" %}} {{% resume/work-experience name="Red Hat" title="Cloud/Software Engineer Intern" languages="Kubernetes, GoLang, Jenkins" date="May 2022 — Aug 2023" %}} - **Decreased manual configuration errors by 80%** by automating service discovery and dynamic config updates, aligning with AML goals of minimizing operational risk and improving data integrity. - **Enhanced CI pipeline reproducibility and performance** by rewriting the Jenkins nightly pipeline to support automated PR-level testing with reusable parameters, improving report consistency across environments. - **Collaborated cross-functionally** with developers and testers to maintain reliable infrastructure, echoing the AML role's emphasis on stakeholder partnership for building robust reporting systems. - **Improved system reliability** during production launches by implementing startup probes for legacy services, reducing downtime and enhancing stability for automated monitoring/reporting pipelines. - **Reduced reporting deployment time by 66%** by building a CLI-based solution to push compiled binaries directly into Kubernetes/Openshift clusters, accelerating turnaround for testing and data validation workflows. {{% /resume/section %}} {{% resume/section skills %}} **Python**, **SQL**, **PostgreSQL** **Tableau**, **MongoDB**, **JavaScript**, Django, **React**, Bash, **Git**, **Linux**, **Command Line**, Go(Lang), AWS, Kubernetes, Terraform, Docker (Compose), Jenkins, Groovy, Solidity, C {{% /resume/section %}} {{% resume/section education %}} {{% resume/education name="University of Toronto (St. George)" title="Computer Science Specialist — 3.84 GPA (CS). Graduated with High Distinction." date="2019 — 2024" %}} {{% /resume/section %}}