Data Management

Yi-Ting Huang

+1-408-***-**** ***********@*****.*** 3 Plaza View Ln. Unit 140, Foster City, CA 94404 EDUCATION

M.S. of Information Management, Syracuse University, Syracuse, NY, GPA: 3.97/4 Aug.2015-May2017

- Concentrated on data related courses including Database Design & Management, Data Warehouse, Data Mining, Applied Data Science, Information Visualization, Natural Language Processing; Got Certificate of Advanced Study (CAS) in Data Science M.A. of Asian Literature, National Taiwan University, Taiwan, GPA: 4.00/4 Sep.2007-Jun.2011 B.B.A. of Finance, National Taiwan University, Taiwan, GPA: 3.22/4 Sep.2003-Jun.2007 SKILLS

Data Analysis (Excel, R, Python), Database (SQL, Access, Visio), Web Design (Html, CSS, JavaScript), Visual Design (Photoshop, Illustrator), Java, Product/Project Management, Product Marketing, Market research ACADEMIC PROJECTS

Data Analysis on Syracuse Poster Project Facts, Syracuse University, Syracuse Sep.2016-Dec.2016

- Extracted, aggregated, and cleaned data of participants and works during 2001 to 2016 from relational database

- Used R to analyze the backgrounds of haiku poets including gender, living area, as well as the source which inspired their works

- Elaborated the charts and maps by Illustrator to provide audience a more persuasive outcome of data visualization Material Management Database Design for AccelStor Inc., Syracuse University, Syracuse Feb.2016-May2016

- Interviewed product managers in AccelStor Inc. to understand the requirements of the material management database

- Created databases and database objects using SQLserver, and created user interface of data entry pages and data reports using Access Citi Bike Usage Data Analysis, Syracuse University, Syracuse Oct. 2015-Dec.2015

- Validated, cleaned, and transformed dataset with 652,390 observations and 15 variables which provided data of Citi Bike seasonal trips

- Asked appropriate questions and completed analysis by R to find out who are using Citi Bikes? When are Citi Bikes used most? How long is a Citi Bike used during a trip? How often does a bike used? Where are the most popular stops and the most popular routes?

- Visualized information and raised suggestions according to the analysis results to address the potential opportunities for Citi Bike WORK EXPERIENCE

IT Support Intern, Greenpeace, San Francisco Jan.2017-Apr.2017

- Resolved help desk tickets and assisted in hardware and software resolution support; Assisted with patch files to fix issues

- Prepared laptops in Windows and Mac systems ready for users; Contributed to documentation to be used by both end users and IT staff Website and Database Development Intern, Syracuse Poster Project, Syracuse Sep.2016-Dec.2016

- Created new webpages of Gallery and made changes on file formats and names to make the website structure more organized

- Assisted with data integration efforts including extraction, validation, and preparation of data from relational databases Product Marketing - Flash Array Storage Server, AccelStor, Inc., Taiwan Mar.2015-Jul.2015

- Investigated the market trends of all-flash and hybrid flash array storage server for product positioning analysis

- Integrated internal requirements and communicated with the out-sourcing web designer to establish the company website

- Planned and executed 3 events and trade shows in the first half of 2015 to bring in 100+ potential clients/partners

- Collaborated with the system verification engineers to edit the user manuals to fulfill the customization designs Product Management - Rugged Mobile Devices, Getac Technology Corporation, Taiwan Oct.2011-May2014

- Mined specification, price and sales data of rugged mobile devices to find new opportunities in new market segment

- Implemented rugged mobile devices from development stage to mass production, focusing on material and schedule control

- Cooperated with software engineers and system verification engineers to build customized applications

- Co-worked with marketing team to build launch plans and campaign packages for EMEA and China markets

- Maintained SKU table, specification table, cost simulation table, as well as product comparison table regularly

- Diagnosed the redundant materials in BOM among different projects to reduce unnecessary costs and inventory

Contact this candidate