Projects
AI-powered tools, data infrastructure, and analytics solutions
Featured Projects
DAHAE
Internal NL2SQL Slack Bot
An AI-powered Slack bot that translates natural language questions into SQL queries, enabling non-technical team members to access data insights instantly without writing code.
Key Features
- Natural language to SQL conversion using Claude API
- Integration with DataHub for metadata context
- BigQuery query execution and result formatting
- Conversational follow-up questions
- Query explanation and optimization suggestions
FINDY
AI-Powered Location Discovery
A conversational AI service that helps users discover places and locations based on natural language descriptions. Built as a side project to explore LLM capabilities in location-based services.
Key Features
- Natural language place search ("cozy cafe with outdoor seating")
- Context-aware recommendations based on preferences
- Integration with location APIs for real-time data
- Multi-turn conversation for refining searches
Data Infrastructure
Core Layer Architecture
@ Wrtn Technologies
Designed and implemented a new Core Layer in the data warehouse hierarchy, standardizing metric definitions and ensuring consistency across three major products.
Solution: Standardized DW hierarchy with Core Layer
PII Masking Pipeline
@ Coinone
Built an automated PII masking infrastructure using GCP Sensitive Data Protection APIs, enabling secure data analysis while maintaining compliance.
Solution: Terraform-coded BigQuery Remote Functions for automated masking
dbt Incremental Macros
@ Wrtn Technologies
Developed standardized dbt incremental strategy macros ensuring idempotency and stable metric management, replacing legacy batch scripts.
Solution: Robust incremental macros with idempotent design
Airflow Environment
@ IoTrust
Established the company's first Airflow environment from scratch, automating data pipelines and Slack notification bots for monitoring.
Solution: Airflow DAGs with Slack alerting
Analytics & BI
First Activation Data Mart
@ IoTrust
Built a comprehensive data mart tracking new user first activation metrics, enabling product teams to optimize onboarding funnels.
Redash KPI Dashboards
@ IoTrust
Reorganized fragmented ad-hoc dashboards into structured KPI dashboards, reducing data request concentration on analysts.
Conversion Rate Optimization
@ IoTrust
Led A/B testing task force and funnel analysis that improved purchase conversion rate by 32%p through data-driven experimentation.
Marketing Settlement Automation
@ Coinone
Automated marketing event settlement queries using BigQuery TVFs, eliminating redundant manual query creation and validation.
Community & Writing
Seoul dbt Meetup
Community Organizer
Hosting official in-person meetups as part of dbt Labs' global community, fostering a practical learning environment for dbt practitioners in Seoul.
Data Analysis Korea
Community Founder
Founded and operate South Korea's data community with 1,800+ members. Organized 105 presentation sessions with 66 data professionals.
Datayanolja Speaker
2024 & 2025
Presented technical talks on data modeling topics at Korea's premier data conference.
Want to see more?
Check out my blog for detailed technical articles and case studies.