Excel, SQL, R, Python, Tableau

Yi-Ling (Carol) Huang

214-***-**** *******@***.*** linkedin.com/in/yi-ling-huang

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX

Master of Science in Business Analytics, GPA 3.737 May 2020

Coursework: Data Mining, Data Visualization and Communication, Big Data Platforms, Database Design for Business

National Cheng Kung University Tainan, Taiwan (R.O.C)

Master of Business Administration-Finance, GPA 3.94/4.30 June 2017

National Yunlin University of Science & Technology Yunlin, Taiwan (R.O.C)

Bachelor of Business Administration-Department of Finance, GPA 3.90/4.00 June 2015

CERTIFICATIONS & TECHNICAL SKILLS

CFA (Chartered Financial Analyst) Level 1 • R • Python • SQL • Tableau • Excel • KNIME • Alteryx • SAS

PROFESSIONAL EXPERIENCE

Lai – Yi Paper Box Manufacturing Factory Changhua, Taiwan (R.O.C)

Accountant July 2017 – January 2019

Optimized accounting procedure on managing daily transactions and monitoring financial reports regularly

Enhanced working efficiency by computerizing thousands of transactions instead of recording transactions by hand

Boosted 15% production by updating raw materials and finished goods status using Excel in Google Sheets and inviting clients as reader to review

Monitored revenue performance by plotting sales bar chart and product category pie chart in accounting software

Identified whether company should explore new customers by analyzing financial and production reports

PROJECTS

Portuguese Bank – Data Mining

Evaluated subscription of new savings product at bank to determine whether success of product can be predicted

Scrubbed raw data and managed data issues including missing values and separated data into training and validation sets in R

Devised decision tree, machine learning algorithm, for subscription variable using training set

Examined model performance with validation set applying confusion matrix and accuracy

Teknion Data Solutions & Pine Cove (Summer Camp Non-Profit Organization) – Capstone Project

Leveraged current recruiting data to build and test model to identify criteria for “good fit” camp counselor and identify 3rd party data sources to identify potential recruiting opportunities to expand list of camp counselor applicants

Separated multi values in one cell into dummy variables and dealt with missing values and typo in R

Constructed decision tree, machine learning algorithm, to figure out rules that classify good camp counselors

Classified rules into marketing variables and predictive variables and applied marketing variables to target universities which have similar characteristics and thus find more good applicants

Demonstrated outcomes with PowerPoint and visualized good universities distribution and their features in Tableau

PickUp (Curated Delivery Service Company) – Data Visualization and Communication

Worked with local start-up company to analyze and to recommend potential new markets in California and Canada applying similar characteristics in current markets

Synthesized multiple data sources including demographics, traffic and customer base for both current and potential areas

Designed score card index in Excel based on ranked variables to identify target markets

Built Tableau dashboards and queries to visualize pros and cons of potential markets and to recommend target markets

Weblogs Task – Big Data Platforms

Clarified most frequently visited pages accessed from default smu.edu web page

Constructed Regular Expression (RegEx) pattern to capture URLs and cleaned data using Python

Defined schema for data set and converted it, using that schema, into data frame

Obtained first 20 results and sorted from most frequent to less frequent writing SQL query

Database Design for Business

Developed H1B database for international students narrowing job searching efforts to targeted companies

Collected data from multiple sources such as myvisajobs and PayScale and built database in SQL to relate different worksheets

Established filters applying SQL queries to select data by year, region, industry category

Displayed results with tables, maps, and histograms to visualize clearly using R Shiny

Contact this candidate