Edward Jiwook Kim

Data Engineer

RBC•  September 2022 - April 2023•  Toronto, ON, Canada

- Collaborated with auditors across the Chief Audit Executive (CAE) group departments to gather business requirements, refining and implementing over 100 Key Risk Indicator (KRI) metrics using Python, R, and SQL - Automated 15+ Extract-Transform-Load (ETL) data pipelines using Dataiku for the Risk Assessment Planning Tool Organizer (RaptOR), facilitating monthly and quarterly data ingestion and metrics updates - Conducted analysis of End User Data Applications (EUDA) across two different systems, successfully restoring over 8.5% of previously lost tabular data entry linkages with 100% precision, ensuring data integrity

Data Scientist

Wish•  January 2022 - April 2022•  Toronto, ON, Canada

- Conducted Exploratory Data Analysis (EDA) on sequential user behavior logs, identifying significant differences between fraudulent and normal user patterns using an Long Short-Term Memory (LSTM) model - Consolidated 1,500+ user actions into 90 categories based on User Experience (UX) behavior chunks and automated the mapping process using Airflow cron jobs to enhance team insights

Programmer & Data Analyst

Barcode of Life Data Systems•  May 2019 - August 2019•  Guelph, ON, Canada

- Designed, planned, and implemented a comprehensive automated DNA barcode data workflow dashboard using Google APIs (Forms & Sheets) and PHP, enhancing data management efficiency by streamlining processes and visualizing the tasks - Enhanced the barcode sequencing instrument's file uploader User Interface (UI) and resolved rendering issues using AJAX - Compiled taxonomy JSON files to create a responsive multi-node tree with D3.js, effectively visualizing hierarchical structures