• Hello there! 👋
    Kaiyin "Carolyn" Chan at your service!

    A digital alchemist weaving data into gold

My Work

Recent Work

Call Center Performance Dashboard (Power BI)

An interactive Power BI dashboard created for the Forage program, tailored for call center managers. It visualizes crucial KPIs including customer satisfaction, call volumes, response times, and agent performance metrics. This tool offers real-time insights to streamline operations and boost customer service efficiency.

Dynamic Sales & Customer Dashboard (Tableau)

This comprehensive dashboard serves as a centralized platform for exploring various facets of sales data, including revenue trends, product performance, and customer demographics. It is meticulously structured to cater to the needs of sales managers, marketing professionals, and business analysts seeking to understand market dynamics and refine their strategies.

YouTube Video Trends Analytics (Tableau)

A project focuses on automating the Extract, Transform, Load (ETL) process and data processing for YouTube analytics.

Sales & Customer Insights Dashboard (Tableau)

An AWS-powered data pipeline integrated with an interactive Tableau dashboard for enhanced e-commerce data analysis.

Greentrace

A Dash-based web application showcasing CO2 emissions and individual carbon footprints, backed by thorough environmental data analysis.

College Return on Investment

A Streamlit-powered web application for college financial analysis, backed by a Firestore database architecture.

Crime Information

A crime data collector app built with Python and Flask.
About Me

Who Am I?

Hi, I'm Kaiyin "Carolyn" Chan. As a graduate of USC's Applied Data Science program, I bring a dynamic toolkit to the realm of analytics engineering. I excel in translating complex data into compelling narratives for strategic decisions, backed by technical prowess in Python, R, SQL, and Tableau.

With proven experience in tech and banking, my analytical journey is marked by measurable impacts on process improvement and business intelligence. I thrive in roles that challenge me to distill data into actionable insights, and I'm eager to contribute to a team that values innovative problem-solving and data-driven strategies.

Problem-Solving

Communication

Collaboration

Critical Thinking

On the lookout for a role that celebrates analytical ingenuity? Let's connect!

Email: chankaiy@usc.edu
Location: Los Angeles, CA, willing to relocate
Status: Actively seeking a full-time position in Analytics Engineer and Data Analyst

My Specialty

My Skills

Python logo

Python

sql logo

SQL

r logo

R Studio

tableau logo

Tableau

databricks logo

Databricks

streamlit logo

Streamlit

git logo

Git

docker logo

Docker

airflow logo

Apache Airflow

postgresql logo

PostgreSQL

oracle logo

Oracle Database

tableau logo

Amazon Web Services

Education

Education

School Icon

University of Southern California | CA, USA
Jan 2022 - Dec 2023

Courses:

  • Foundations of Data Management
  • Data Science of Scale
  • Machine Learning for Data Science
  • Foundations and Applications of Data Mining
  • Database Systems
  • Information Retrieval and Web Search Engines
  • Research Methods and Analysis for User Studies
  • User Experience Design and Strategy
  • School Icon

    Fu Jen Catholic University | TPE, TW
    Sep 2015 - Jun 2019

    Courses:

  • Application of Statistics Package
  • Discrete Data Analysis
  • Machine Learning for Data Science
  • Database Administration
  • Time Series Analysis
  • Regression Analysis
  • Data Mining
  • Mathematical Statistics
  • Experience

    Work Experience