Work Experience
Data Analyst Intern
Community Development Corporation of Oregon
(September 2024 - May 2025)
Project Overview
Update the Rockwood Identity Atlas with the latest data and upgrade it to an interactive, user-friendly platform featuring comprehensive data and storytelling. This Atlas will be a valuable resource for many non-profits, community organizations, government agencies, healthcare providers, educational institutions, businesses, investors, and residents. These entities can utilize the Atlas data to make informed decisions and create targeted initiatives that benefit the Rockwood community. For example, they can develop policies, identify areas for service and support such as housing, education, health, and employment, or explore opportunities for investment and economic development.
Programming Languages and Tools
R, Javascript, GIS
Link to the Atlas site
Some Visualizations
Credit: Rockwood Identity Atlas 2025 by Chloe Bui
Code Examples
Step 1: Collect data (Races in Multnomah County, Oregon by census tract from 2012 to 2023) from American Census Bureau Site
Step 2: Wrangle data to build cleaned data for Visualization
Finance Research Assistant
Willamette University
(June 2024 - July 2024)
Project Overview
Developing an automated process for downloading 2587 10-K filings of 1500 companies from the Securities and Exchange Commission (SEC) EDGAR database, extracting and analyzing covenant-related data.
Programming Language and Tool
Python, Gitbash, StyleWriter 4
Methodology
There are four main stages in the project:
+ First is Data Acquisition: collecting 10-K filings from SEC EDGAR.
+ Second is Data Processing: handling these 10-K files, which includes
cleaning the files, extracting covenant violation-related paragraphs, and
converting them to doc files with highlighted keywords.
+ Third is manually reviewing each processed 10-K file.
+ Fourth is counting the words and analyzing each file using the StyleWriter 4 application.
Code Examples
Part 1: Automatically download 10-K filings from SEC EDGAR by using Python
Step 1: Run the command in Google Colab to clone the "edgar-crawler" repository hosted by the user "nlpaueb"
!git clone https://github.com/nlpaueb/edgar-crawler.git
Step 2: Run the command to change the current working directory to the edgar-crawler directory
cd /content/edgar-crawler
Step 3: Match 2 key variables, CIK and Filing year, of each observation from the original csv file to the corresponding SEC filing
Step 3.1. Build function “get_start_year(datadate)” to determine the start_year based on the “datadate” column of the csv file
def get_start_year(datadate):
date_parsed = datetime.strptime(str(datadate), '%Y%m%d')
if date_parsed.month > 9 or (date_parsed.month == 9 and date_parsed.day ==30):
return date_parsed.year + 1
else:
return date_parsed.year
Step 3.2: Read configuration files, modify them, and then write these modifications to a series of new configuration files
with open('/content/edgar-crawler/config.json', 'r') as file:
config_template = json.load(file)
for index, row in df.iterrows():
start_year = get_start_year(row['datadate'])
cik = row['cik']
config_template['edgar_crawler']['start_year'] = start_year
config_template['edgar_crawler']['end_year'] = start_year
config_template['edgar_crawler']['cik_tickers'] = [str(cik)]
# Write the modified config.json
with open(f'/content/edgar-crawler/config_{index}.json', 'w') as file:
json.dump(config_template, file)
Deliverables
Business Development Intern
Blue Elderberry Wisdom Farm
(July 2024 - August 2024)
Project Overview
Developed a comprehensive Business Plan and Marketing Strategy for Blue Elderberry LLC, successfully securing $50,000 in funding through the 2024 Value-Added Production Grant.
Sales and Marketing Roles
Experience Overview
Extensive experience in the pharmaceutical and medical device industry in Vietnam, specializing in business development planning, new product launches, customer relationship and project management.