Binchong An

Experience

• 

  University of Minnesota, Twin Cities

  Sept 2014 - Dec 2014

  Academic Project

  Using Data and Metrics in HRIR Cases September 2014-December 2014• Applied pair-wise table, regression model, statistical hypothesis to identify the factors influencing workforce satisfaction and provide recommendations to improve workforce success• Used pair-wise table to select explanatory variables with the highest contribution to overall satisfaction, and remove multicollinearity by combining highly related variables• Justified the explanatory variables by using Theories, Articles, F tests and Hypothesis tests• Prioritized explanatory variables by contribution and compared with benchmark figures to assess the scope for improvements• Provided corresponding recommendations and suggested using follow-up survey for evaluation and reduce Type II error Show less

• 

  GVC

  Jan 2015 - Mar 2015

  HR volunteer

  • Streamlined the recruitment process to ensure the procedure is legal and efficient• Revised phone interview questions to make them more organized and effective• Participated in the establishment of employment law manual and employee handbook to support recruitment process

• 

  University of St. Thomas

  Aug 2016 - May 2019

  Academic Projects

  Machine Learning Course Project• Applied logistic regression, naïve Bayes, Support Vector Machine, random forests and K-Nearest Neighbors(KNN) in Python to predict fundraising status for a crowd sourcing platform Kickstarter, implemented cross validation, Principal Component Analysis (PCA) and GridSearchCV to gauge model performance and compared efficiency for model selection purposes • Developed multivariate regression model & performed T-test, ANOVA and Chi-square test in R to analyze medical expense patterns and recognized influential factors• Retrieved and counted unique records and conducted descriptive analyses for NYC parking ticket datasets by using paired Resilient Distributed Datasets (RDD), case and join functions in Spark • Built interactive dashboards using Tableau and presented analytical findings in a clear mannerData Warehousing and Database Design• Designed the Facts and Dimensions Table using Excel to build a data warehousing environment • Extracted, transformed and loaded data (ETL) from multiple sources to the data warehousing environment by SQL• Used Pivot Tables, Pivot Charts, SQL Queries to analyze retrieved data and generate business insights• Utilized SQL to insert, organize and query data to analyze customer purchasing behavior, deriving business insights for decision making in sales Show less

• 

  Fagron

  Oct 2018 - May 2019

  Sales & Marketing Data Analyst & Insights Intern

  • Applied K-means clustering algorithm on Customer Value Evaluation Index in Python to improve customer retention• Evaluated the effectiveness of marketing campaigns and provided recommendations by using regression techniques• Improved decision making and data visibility by using R markdown to generate weekly report for finance department • Conducted sales trend analyses in Tableau for managerial decision making• Created a daily automatically updated sales dashboard including various sales trend analyses in Excel Pivot • Developed communication and teamwork skills through cross-department projects Show less

• 

  Alzheimer's Association®

  Sept 2019 - Jul 2020

  Database Assistant

  • Initiated data visualization and data screening process to establish preliminary understanding of training datasets• Enhanced data accuracy and integrity by revising and updating 50% data in Raiser’s Edge database• Analyzed participants’ preference on program schedule by identifying ignored factor to reduce bias and delivered contribution rates tables

• 

  University of Minnesota, Extension

  Aug 2021 - now

  Research Assistant

  • Developed interactive Tableau dashboards by using Advance Analysis Actions, Calculations, Parameters, Background Images, Highlighted Map Filter, Navigation, View Switch, Sets, Geo Coding and Hierarchies with data blending and join methods• Converted existing ArcGIS Maps into Tableau dashboards by Esri Connector • Maintained and issued programs reports by county, partner, and program to leadership team for strategic planning purposes on an ongoing basis • Independently redeveloped Education and Administrative Reporting (EARS), quarterly and annual extension program reports in Python for validation purposes • Conducted data extraction, data integration and pivot analysis for cross-departmental collaboration Show less