Ellen Hsu

Portland, OR · ellemonke@gmail.com

Creative Data Analyst with a capacity for learning and producing at a fast pace. Builder of ETL processes, data warehouses, and data visualizations - specializing in Python, SQL, and AWS tools. Fearless problem-solver, often reducing system complexities by over 40%. Passionate about transforming data into user-friendly tools and bridging communication between engineers and end-users.

Skills

Programming Languages & Tools

Python (Pandas, Matplotlib, NumPy, SciPy, Flask, Beautiful Soup, Web APIs)
JavaScript (D3, Plotly, Leaflet)
SQL (PostgreSQL, SQLAlchemy) + MongoDB
HTML/CSS (Bootstrap, Flexbox)
Big Data & AWS (S3, EC2, Spark, Athena, EMR, Cassandra, Redshift, Airflow, Snowflake)
Machine Learning (Scikit-learn, TensorFlow)
Tableau (Maps, LOD)
Alteryx
Excel (VBA, Pivot Tables)

Education

Nanodegree - Predictive Analytics

Udacity

2020 (In Progress)

Nanodegree - Data Engineering

Udacity

2020

Certificate - Data Analytics

University of Oregon Boot Camp

2019 - 2020

MBA - Marketing

Marylhurst University

BA - Interdisciplinary Computing & the Arts

University of California, San Diego

Project Highlights

COVID-19 Analysis

Python (Pandas, Matplotlib, APIs),
JavaScript (Leaflet, D3), HTML, CSS

On March 25, days after self-quarantine orders began in Oregon, I began analyzing risk factors for COVID-19. As the pandemic evolved, I discovered a correlation between COVID-19 hotspots and the world's largest airports. I also tracked spread and fatality rates across countries and debunked early myths surrounding COVID-19 risk factors.

Website | Github

Machine Learning: Predicting HDI

Python, Scikit-learn, Pandas, Matplotlib, Flask

For this project, we calculated which indicators contributed most to the Human Development Index (HDI). I created the machine learning model and built the app that predicts HDI. I also built the Flask website.

Website | Github

Full Stack: World Happiness

JavaScript, D3, Python, Pandas, NumPy, SciPy, HTML, CSS, Bootstrap

The report analyzed global happiness and the factors correlated to it. I built the correlogram using Python and JavaScript and created a responsive website template.

Website | Github

Data Analysis: Ecological Footprint

Python, Pandas, NumPy, SciPy, Matplotlib

I uncovered the story of our analysis that developed countries create large ecological footprints. I also compared land usage to see which ones created higher proportions of biodeficit or bioreserve.

Website | Github

E-Commerce: Vintalier.com

I designed my own e-commerce website including the layout, UX, add-ons, and cart conversion funnel. The website was built on BigCommerce by CartDesigners and I maintained the PHP snippets. I handled the Google Shopping integration.

Website | Social Media

Experience

Supply Chain Analyst

Nike (Contract)

Responsible for supply chain network capacity planning and optimization. Analyzing consumer goods flow using data analytics tools including Tableau, Alteryx, Snowflake, Teradata, Excel, etc. Performing cloud database administration and ad hoc analysis. Managing logistics operations in a highly collaborative, cross-functional team environment.

October 2020 - Current

Owner, Entrepreneur

Vintalier LLC

Founded and grew a successful multi-channel retail store, initially as e-commerce then also as a brick-and-mortar store in 2013. Continued to sell on four e-commerce platforms and designed financial tools to forecast the annual purchasing budget, product mix and monthly cash flow.

February 2009 - March 2020

Marketing Manager

Motech Industries Inc.

Overhauled the corporate website to a content management system and trained 30 stakeholders from 7 business groups across 4 languages. Managed an international marketing budget of ~$100K. Drove the strategic and creative direction of quarterly advertising campaigns.

July 2009 - November 2010

Freelance Digital Producer

ID Branding & Exprima

Produced websites for small to mid-sized businesses in an agency environment. Managed feature enhancements for Intel’s digital asset management system.

June 2008 - June 2009

Digital Producer

Nike (Contract)

Cleaned 48% of the intranet in obsolete sites and defined new account management procedures. Served as interim Senior Digital Manager to facilitate progress and motivation during leadership and IT transitions.

November 2006 - March 2008

Web Content Developer

Intel (Contract)

Contributed to the massive rollout of the Intel re-brand. Launched product sites monthly. Designed live site mockups and storyboards.

November 2005 - November 2006

Senior Technical Web Writer

San Diego Supercomputer Center

Architected a 400-page cross-departmental website. Developed a survey to define the department's mission and objectives. Wrote user documentation for high-performance computing technology.

April 2004 - July 2005

Web Developer/Designer

Virtual Reality Medical Center

Designed the website. Successfully launched a new e-commerce project. Monitored Overture and AdWords to improve SEO.

October 2002 - April 2004

Interests

Aside from being passionate about analytics, I enjoy being creative and dabbling in portrait drawing. I try to spend my free time with loved ones as much as possible including my sprightly little cat, Marcel. In the evenings, I like to put on some downtempo hip hop or pop music and read modern economics books. Right now I'm on a Joseph Stiglitz binge and have a particular obsession with the U.N.'s Sustainable Development Goals.

I'd like to be a better social activist with a lens of optimism - and a better cook, especially Indian or Thai food.