Yi-Ling (Carol) Huang
I am passionate about analyzing data and providing business insight to help people solve problems. I utilized R, SQL and Python to process data, to apply machine learning algorithms, and to visualize data appropriately. Even though I sometimes had challenges, I really enjoyed the process solving them. Each puzzle provides a new opportunity to find solutions.
Data Analyst | Business Intelligence Analyst | Business Analyst
Taipei, TW
[email protected] |+886988277423
PROFESSIONAL EXPERIENCE
Amazon.com, Inc. Taipei, Taiwan (R.O.C)
Sales Operations Intern February 2021 – February 2022
- Extracted and summarized data from database using SQL and Python and provided insights for business teams to stimulate seller quality and shorten seller launched timeline
- Devised seller tool using SQL and VBA to help sales team push forward sales pipeline and feature adoption and trigger email pushed directly to targeted sellers and thus save time for 70% of sales representatives
- Maintained seller data and designed reports and dashboards in Astro, a Salesforce tool, to assist business teams to catch up real-time seller registration status and seller performance
Efortles, Inc New York, NY
Business Operation Intern August 2020 – October 2020
- Researched online platform for marketing use and presented outcome using Notion
- Established investor list with different sweet spots using pivot table and conducted pitch deck to attract investors to invest
Lai - Yi Paper Box Manufacturing Company Changhua, Taiwan (R.O.C)
Financial Analyst Jul 2017 – Dec 2018
- Measured revenue performance by applying data visualization such as bar chart, line chart and pie chart in Excel
- Monitored production status by utilizing pivot table with months and clients
- Identified whether company should explore new customers by analyzing financial figures and monthly production status
PROJECTS
Teknion Data Solutions (Data Consulting): Analysis of Pine Cove (Summer Camp Non-Profit) – SMU MSBA Capstone Project – R, Excel, Tableau, PowerPoint
- 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 find more good applicants
- Demonstrated good universities distribution and features with map and tables in Tableau and PowerPoint
PickUp (Curated Delivery Service Company) – Data Visualization and Communication – Excel, Tableau
- 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
Job Search Database – Database Design for Business – SQL, R Shiny
- 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 queries to select data by year, region, industry category and applied CRUD (create, read, update, and delete) function in SQL
- Displayed results with tables, maps, and histograms to visualize clearly using R Shiny
