Hsin-Wei Pan

P: 857-***-**** E: adl7h8@r.postjobfree.com

Data Analysis Data Mining Reporting Dashboards MySQL Python Business Intelligence Data Modeling Big Data Market Research Business Development Data Science Data Warehousing Data Profiling Data Quality

Data Analyst / Business Analyst / BI Analyst

Summary:

Good knowledge in Data analysis, Data visualization, Data cleansing, Data modeling, and Business Intelligence.

Excellent Database administration (DBA) skills including user authorizations, Database creation, Tables, indexes, and backup creation.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development

Worked on data pre-processing and cleaning using Python, data processing using MySQL, and storytelling dashboards using Tableau.

Excellent sense of teamwork, leadership and communication skills.

Education:

Northeastern University, Boston, MA Jan 2019 – June 2020

MS in Analytics GPA 3.9/4.0

Fu Jen Catholic University, Taipei, Taiwan Sep 2013 – June 2017

BS in Electrical Engineering GPA 2.8/4.0

Technical Skills:

Programming Languages: Python, R (Data cleaning & modeling), MySQL (Databases management), Knime, Advanced Excel

Data Visualization/ BI: Tableau (proficient), Python, R, Qlik, Excel

Statistical Modeling: Decision Tree, Random Forest, Regression, K-means Clustering, Time Series

Others: Azure, C++, LabVIEW, Biomedical (Electrical Engineering Background)

Work Experience

Market Research Analyst Intern Oct 2020 – Present

DigitalPi, Boston

Did research about AI and AR applications to provide ideas that could be potentially used for the future products.

Provided quality insights of the IT market that help the company come up with innovative ideas and problem-solving strategies

Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data

Applied business intelligence tools to provide quality dashboards that can reveal the results of data analysis.

Business Analyst Feb 2018 – Aug 2018

Bryant International Co., Ltd., Taipei, Taiwan

Collected the data of product yield rate to manage the quality of our product from every supplier to meet our customers’ needs.

Built datasets of mechanical elements suppliers and customers to better organize the data.

Analyzed the suppliers and customer’s data to optimize the selling performance.

Private, Army of Taiwan R.O.C. Oct 2017 – Jan 2018

Mechanical elements Operations Intern Jul 2016 – Jun 2017

Bryant International Co., Ltd., Taipei, Taiwan

Received orders from customers and updated new data to Excel.

Got familiar with the mechanical elements and contacted suppliers from Europe and the US.

Project Experience

Preventing Intellectual Property (IP) Theft at GE Aviation, using Tableau and Knime Jan 2020 – Mar 2020

Built K-mean clustering and decision trees models (13K+ rows of data) to find the possibly risky group of employees to estimate the potential loss.

Initiated the strategic solutions for loss prevention and compared the internal cost and the potential loss.

Improving Marketing Campaigns on Facebook at ViacomCBS, using Python, Tableau, and R Apr 2020 – Jun 2020

Proposed the optimal custom audience metrics for the most successful advertisements.

Created decision trees model for new marketing plan which reaches more people with lower costs.

Employees Compensation Analysis in Greater Boston Area, using Python May 2020 – Jun 2020

Differentiated payroll into high and low incomes groups by different standards of quartile.

Built decision trees model to acquire the highly relative attributes, such as “overtime” and “education”.

How Deep Brain Stimulation (DBS) Mitigates Parkinsons Disease, biomedical application Sep 2016 – Jan 2017

Analyzed DBS and other treatments to explain why it becomes powerful to fight the disease by using the micro stimulator.

Leadership Experience

Captain, Fu Jen Catholic University Department of EE Baseball Team 2015 – 2016

Designed the training plan with target and timeline in each session.

Set game plans and motivated the team with encouragement and techniques supporting.

Contact this candidate