Data Analyst / Data Scientist / Business Analyst

Turning messy data into crisp, decision-ready insights.

I’m Jaewon, a UC Berkeley Data Science major with experience at DocuSign and MKS Instruments. My pipelines, models, and dashboards have powered decisions in fast-paced environments where speed and accuracy mean millions.

Python · SQL · Git Tableau · Power BI Snowflake · dbt · Airflow Excel VBA scikit-learn · XGBoost · LightGBM TensorFlow · PyTorch A/B Testing · Causal Inference
Portrait of Jaewon Shim

Projects

Personal, end-to-end projects in exploratory data analysis, forecasting, and data modeling/engineering.

Samsung stock chart visualization

Samsung Stock Price Forecasting

Implemented LSTM and GRU deep learning models in TensorFlow to forecast Samsung stock prices, achieving R² = 0.95 with the GRU model; generated 10-day predictions providing actionable insights that advised against investment due to expected price decline.

California housing aerial view

California Housing Cost Modeling

Performed EDA and built a random forest regression model to predict housing prices, applying data preprocessing, model evaluation, and hyperparameter tuning; achieved R² = 0.80 and accurately predicted the target house price.

COVID-19 data visualization

COVID-19 Statistical Data Analysis

Employed PostgreSQL and advanced SQL with CTEs to perform multivariate analysis of COVID-19 data, identifying the most infectious countries and calculating a −0.751 correlation between GDP and infection rate, revealing GDP’s strong inverse impact on pandemic spread.

Bar chart of job market metrics

Data Science Job Market Analysis

Built a PostgreSQL pipeline to identify the highest-paying Data Scientist jobs and the skills behind them, balancing frequency with pay to score “optimal” skills for upskilling.

Amazon ratings UI

Amazon Rating Tracker

BeautifulSoup + Requests scraper that captures Amazon product title and average rating with proper headers, writes to CSV, and runs on a user-set schedule (e.g., every 12 hours) to track rating trends over time.

Dashboards

Personal dashboards built to explore real datasets and deliver insights.

London Bike Rides dashboard thumbnail

[Tableau] London Bike Rides

Python pandas used for data prep and a multi-view dashboard presented in Tableau.

Details
  • Displayed five visualizations including moving average charts with parameters.
  • Implemented filters for detailed exploration.
  • Included a heatmap showing ride counts sorted by wind speed and temperature.
  • Added two additional visualizations — rides by weather, and rides by length.
Power BI survey dashboard thumbnail

[Power BI] Data-Professionals Survey

600 responses summarized with interactive visuals in Microsoft Power BI.

Details
  • Utilized treemap to allow users to filter by country.
  • Visualized average salary by job title using stacked bar charts.
  • Represented favorite programming languages per job title using stacked column charts.
  • Displayed personal difficulty ratings for each job title using donut charts.
  • Showcased average salary and work-life balance using gauges.
  • Included cards to represent core information.
  • Analyzed salary by age and gender with line charts.
Seattle Airbnb dashboard thumbnail

[Tableau] Seattle Airbnb

Geographical cost analysis with multiple breakdowns for Seattle Airbnb data.

Details
  • Explored the relationship between the number of bedrooms and cost per night.
  • Presented the average cost of Airbnb stays within Seattle by zip code.
  • Calculated total weekly Airbnb revenue in Seattle.
  • Visualized the number of Airbnb listings grouped by bedroom count.
Excel bike sales dashboard thumbnail

[Excel] Worldwide Bike Sales

Cleaned worldwide bike sales data in Excel and showcased with a dashboard.

Details
  • Removed duplicate rows and populated marital status column.
  • Created age bin column using nested IF statements.
  • Utilized pivot tables with slicers for data filtering.
  • Illustrated the relationship between average income and bike purchases with a column chart.
  • Analyzed bike purchases across different age groups using a line chart.
  • Explored the impact of commute distance on bike purchases with a line chart.

Get in touch

I’m open to full-time roles in data science/analytics. If you're hiring or open to a conversation, feel free to connect or reach out to me!

Download resume

PDF version of personal resume.

Open PDF