Projects

Healthcare analytics work and academic research.

Dashboard & Reporting

Behavioral Health Performance Dashboards

Built and automated Power BI dashboards giving clinical and operational leaders on-demand access to program performance, patient engagement, and outcome metrics across six behavioral health programs.

  • Tools Power BI (Power Query, DAX), SQL, CareLogic EHR
  • Scope 6 programs, recurring operational & compliance reporting
  • Environment HIPAA-aligned, PHI-minimizing workflows
SOURCE CareLogic EHR EXTRACTION SQL — Snowflake (CTEs, joins, window functions) TRANSFORM Power Query · DAX measures · KPI logic Power BI Dashboard → Clinical & Operational Leaders
Replaced manual, spreadsheet-based reporting with automated dashboard workflows — reducing reporting lag and improving consistency of performance monitoring across programs.
Power BI DAX SQL CareLogic HIPAA
PDF coming soon
Reporting Automation

Automated Quarterly Performance Reporting Pipeline

Designed and built Python-based reporting pipelines that automate quarterly and semiannual PIR (Performance Indicator Report) packages across multiple behavioral health programs — from SQL data extraction to structured Excel output.

  • Tools Python (Pandas), SQL (Snowflake), Excel
  • Output Multi-sheet Excel reports with standardized KPI logic
  • Scope Depression remission, access/timeliness, follow-up compliance, engagement
SOURCE CareLogic EHR → Snowflake SQL PROCESSING Python (Pandas) — data cleaning, dedup, date logic KPI CALCULATION Depression remission · Access/timeliness · Follow-up compliance OUTPUT Styled multi-sheet Excel → Quarterly PIR package
Replaced error-prone manual Excel workflows with reproducible, auditable pipelines — standardizing KPI definitions across programs and significantly reducing preparation time for quarterly reporting cycles.
Python Pandas SQL Snowflake Automation
PDF coming soon
Data Pipeline

EHR Data Extraction & Clinical Reporting Pipeline

Built and maintained SQL-based data pipelines from CareLogic EHR through Snowflake, applying data quality checks, deduplication logic, and PHI-minimizing transformations to produce reliable datasets for clinical and operational reporting.

  • Tools SQL (Snowflake, CTEs, window functions), CareLogic EHR
  • Focus Encounter deduplication, follow-up tracking, utilization analysis
  • Environment HIPAA-aligned, PHI-minimizing data governance
SOURCE CareLogic EHR (encounter, assessment, clinical records) EXTRACTION SQL — Snowflake (CTEs, window functions, joins) DATA QUALITY Deduplication · PHI minimization · Outlier checks CLEAN DATASET Reporting-ready · Auditable · Consistent across programs Power BI Dashboards · Python PIR Pipelines · Excel Reports
Established consistent, auditable data extraction logic that resolved discrepancies across program-level reports and improved trust in operational metrics used for leadership decision-making.
SQL Snowflake CareLogic ETL Data Quality
PDF coming soon
Working Papers
Working Paper

Power of the Past: Family Background and Subjective Social Status among College Graduates

Parental SES, higher education, and young adults' subjective social status in the U.S.

  • Data Add Health (Waves I, III, IV)
  • Methods Regression with IPTW
  • Population U.S. young adults, ages 24–32
The influence of parental SES on subjective social status disappears once college selection is accounted for, but re-emerges strongly among PhD and professional degree holders.
Predicted SSS by Education (Add Health)
SSSEducationInequalityIPTW
Working paper Slides
Working Paper

Relative Income & Subjective Well-being in Same-Sex and Different-Sex Marriages

Gendered income dynamics and subjective well-being across couple types in the U.S.

  • Data National Couples' Health and Time Study (2020–2021)
  • Methods Regression with IPTW
  • Population Married adults in the U.S.
In different-sex marriages, men gain well-being as breadwinners while women's well-being declines when they outearn husbands. No such penalties found in same-sex marriages.
SWBGenderCouplesIncome
Working paper
Working Paper

Lifetime Earnings & Subjective Social Status in Older Adults

How cumulative earnings histories shape perceived social standing in later life.

  • Data Health and Retirement Study (HRS, 2004–2022)
  • Methods Panel models (FE/RE), growth-curve modeling
  • Population U.S. adults aged 50–64
Lifetime earnings appear to explain subjective social status more robustly than current earnings, with stronger associations for men — consistent with gendered work histories.
SSSAgingLabor marketPanel data
In progress
Peer-Reviewed Articles
Research in Social Stratification and Mobility · 2024

The Gender Gap in Earnings Growth at the Early Stage of Work Careers in Korea

Early-career earnings growth and promotion prospects among college-educated workers in South Korea.

  • Data Graduates Occupational Mobility Survey (2008–2010)
  • Methods IPTW balancing + individual fixed-effects models
Women face lower earnings growth and promotion prospects even after balancing initial job placement and family formation; penalties are largest in small/irregular-job segments.
GenderLabor marketIPTWFixed effects
Journal PDF
Peer-Reviewed Article

How Do Children Self-Locate in the Social Hierarchy?

Educational homogamy, mothers' economic role, and children's subjective social status in Korea.

  • Data Korea Labor and Income Panel Study (KLIPS, 2005–2021)
  • Methods OLS regression, clustered standard errors
  • Population Korean adolescents, ages 15–18
Children of educationally homogamous parents report higher SSS; those from co-breadwinner families perceive themselves lower in the hierarchy compared to peers from male-breadwinner families.
Children SSS Figure
ChildrenFamilySSSGender
Journal
Peer-Reviewed Article

Admissions and Fairness: Family SES & Elite College Entry in South Korea

How different admissions tracks shape the link between family background and access to elite universities.

  • Data Graduate Occupational Mobility Survey (GOMS 2016–2017)
  • Methods Linear probability models & multinomial logit
Family SES strongly predicts elite college admission across all tracks, but the effect is stronger in exam-based and essay-based tracks — highlighting the "law of adaptation."
Admissions Figure
EducationInequalitySouth Korea
Full text (Korean)
Peer-Reviewed Article

Overwork and Organization: Overtime Hours & Women's Managerial Attainment

How organizational work hours shape gender inequality in managerial representation in Korea.

  • Data Workplace Panel Survey
  • Methods Multilevel growth models (firm-year panel)
Firms with longer overtime hours start with fewer women in management and see representation decline over time — especially in male-dominated manufacturing sectors.
GenderWorkplaceOverwork
PDF (Korean)
Policy Reports
Policy Report · Korea Employment Information Service

Evaluation of Youth Entrepreneurship Support Programs

Comprehensive evaluation of Korean youth start-up support policies combining quasi-experimental methods, surveys, and in-depth interviews.

  • Data Employment insurance DB, business surveys, field interviews
  • Methods DiD, panel fixed effects, in-depth interviews
Programs modestly improve short-term firm survival and employment, but effects on wages and long-term sustainability remain limited.
Startup Evaluation Figure
Policy EvaluationYouthDiD
Report (Korean)
Policy Report · Korea Employment Information Service

COVID-19 Direct Job Creation Programs

Evaluation of Korean emergency direct job creation projects funded by supplementary budgets during the COVID-19 crisis.

  • Data Program administrative data, Employment Insurance DB, IO analysis
  • Methods Program evaluation, descriptive analysis, input–output modeling
Programs provided large-scale short-term employment to vulnerable groups, buffering labor market shocks, but raised concerns about overlap, sustainability, and long-term job quality.
Policy EvaluationCOVID-19Labor Market
Report (Korean)
Selected Financial Research & Industry Reports
Financial Research · Kiwoom Securities · 2017

Global Financial History & Real Estate Investment Insight

Long-run housing price dynamics across advanced economies and implications for real estate investing.

  • Focus 100+ years of housing price cycles and macro drivers
  • Data Long-run international housing series, BIS/OECD, macro indicators
  • Methods Comparative time-series analysis
Real housing prices have trended up in most advanced economies (ex-Japan), with country-specific cycles; supply constraints and macro stability matter more than short-run sentiment.
Long-run housing figure
MacroReal EstateTime Series
PDF
Financial Research · Kiwoom Securities · 2017

Shrinking Middle Class & Weak Consumption

Why confidence is up but spending is flat: distributional shifts in the middle class and implications for aggregate demand.

  • Focus Middle-class share, income distribution, and aggregate demand
  • Data PCE, CPS, IMF, Bloomberg, US/intl consumer confidence surveys
  • Methods Distribution-aware macro analysis
As the middle class shrinks, aggregate spending softens despite solid sentiment; rising middle classes in Asia offset some of the global demand drag.
Middle class and consumption
ConsumptionInequalityMacro
PDF
Financial Research · Kiwoom Securities · 2017

4th Industrial Revolution: Does Productivity Growth Threaten Jobs?

Analysis of labor productivity, employment, and sectoral shifts in the era of the 4th Industrial Revolution.

  • Data OECD, BLS, global productivity and employment statistics
  • Methods Sectoral trend analysis, comparative cross-country analysis
Productivity gains reduce manufacturing jobs but expand employment in services. Long-term risk of productivity slowdown exists, but growth in high-skilled service sectors can sustain both jobs and productivity.
ProductivityEmploymentMacro
Report PDF