Skip to content
Hyeok Brian Lee

Hyeok Brian Lee · Data & Automation Specialist

I turn complex workflows into practical, automated solutions.

I connect data, systems, and AI to reduce repetitive work and make operational information easier to use. My work spans API integrations, document processing, RPA, data pipelines, and analytics.

Explore My WorkGet in Touch

Selected Projects

Three projects exploring how automation, AI, and analytics can support everyday business operations.

Project 01Workflow Automation · API Integration

From invoice email to a complete CRM record.

An automated workflow retrieves filtered emails through the Gmail API, downloads PDF attachments, extracts invoice information, and populates the corresponding fields in Zoho CRM. It also attaches the original PDF to the record and sends a summary email after processing.

The problem

Processing invoice emails involves several repetitive steps: finding the right messages, downloading documents, reading invoice details, entering CRM data, and keeping the source files connected to their records.

Workflow

  1. 01Retrieve emails matching configured filters through the Gmail API.
  2. 02Download their PDF attachments.
  3. 03Parse the PDFs and extract invoice information.
  4. 04Create and populate the corresponding Zoho CRM records.
  5. 05Attach the original PDFs to those records.
  6. 06Send a processing summary by email.

Value

Connects document handling, data entry, and reporting into one workflow, reducing manual handoffs and keeping source documents accessible from the CRM.

  • Python
  • Gmail API
  • PDF Parsing
  • Zoho CRM API
  • Email Automation
Screen recording · 1:27
Project 02Applied AI · Document Knowledge

Benefits information, explained through conversation.

A conversational assistant that helps employees explore a detailed benefits booklet through natural-language questions. Built around LLM integration with document knowledge retrieval, the assistant is configured to search the document, reference relevant sections, and consider eligibility rules, exclusions, shared limits, and policy amendments.

Why it matters

Benefits questions often depend on several connected rules. A useful answer needs more than a matching keyword: it may require checking dependent eligibility, treatment restrictions, reimbursement limits, and dated amendments together.

Intended behavior

  • Search the attached policy knowledge.
  • Explain benefits in plain language.
  • Reference supporting policy sections.
  • Ask for missing information when it affects the answer.
  • Distinguish general coverage guidance from a personalized estimate.
  • LLM Integration
  • Knowledge Retrieval
  • RAG
  • Prompt Design

Employee Benefits Assistant — live demo

This assistant answers questions about a sample group benefits booklet. It is not a chatbot about my career.

Interactive demo using a fictional employee benefits policy. Not real insurance coverage.

Please use hypothetical questions and avoid sharing personal medical information.

Sample questions
  • “Do basic dental and crowns have separate annual limits?”
  • “Does my 20-year-old university student qualify to start braces?”

Sample benefits booklet (PDF)

Download

Fictional policy document used for this demo.

Project 03Data Analytics · Tableau

An interactive view of repair operations.

A Tableau dashboard for exploring HVAC repair data in a visual, interactive format. The project brings repair-related information together to support operational analysis and make the data easier to investigate.

  • Tableau
  • Data Visualization
  • Operational Analytics
Open in Tableau Public

On smaller screens the dashboard scrolls inside its frame — the external link gives the best full-screen experience.

Expertise

What I work with day to day.

Automation & Integration

Connecting systems and removing repetitive steps.

  • Python
  • UiPath Studio
  • UiPath Orchestrator
  • API integrations
  • n8n
  • Visual Basic

Data Engineering & Analytics

Preparing dependable data for analysis and operational decisions.

  • SQL Server
  • SSIS
  • MySQL
  • ETL pipelines
  • Power BI
  • Tableau

Applied AI

Making business information accessible through natural-language interfaces.

  • LLM integration
  • Conversational assistants
  • Document knowledge retrieval
  • Agentic workflows

Experience & About

Business context, hands-on implementation.

I’m Hyeok Brian Lee, a data and automation specialist with a background in service operations at LG Electronics Canada. I work with stakeholders to understand operational challenges and build practical solutions using automation, APIs, data pipelines, and AI. My approach combines business context with hands-on technical implementation.

Employment achievement · LG Electronics Canada

Approximately 11 manual work hours saved per week through automation in 2025.

Measured in my role at LG Electronics Canada — separate from the portfolio demos on this site.

Education

BASc, Chemical Engineering — University of Toronto

Timeline

  1. April 2021 – Present

    Assistant Manager, Service Network Planning

    LG Electronics Canada

  2. September 2018 – April 2021

    Planning Analyst, Service Network Planning

    LG Electronics Canada

  3. August 2017 – September 2018

    Associate, Return Authorizations

    LG Electronics Canada

Selected experience

  • Developing and maintaining UiPath and Python automation, including deployment and scheduling.
  • Building API integrations and Python/SSIS ETL pipelines into SQL Server.
  • Developing an LLM-powered interface for operational database inquiries.
  • Creating operational dashboards and supporting service-network planning.

Contact

Let’s make your workflows work better.

Interested in data, automation, or applied AI? I’d be happy to connect.