BING-HUNG WEI

adm7zs@r.postjobfree.com 405-***-**** 310 Wadsack Dr, Norman, OK, United States linkedin.com/in/binghungwei/ SUMMARY

Data analyst with 2 years of experience in data analysis. Skilled at forecasting and statistical models, and passionate about data visualization. Currently a master’s student at the University of Oklahoma in Business Administration and Information Technology. Seeking a full-time Business analyst/Data analyst role starting from July 2021. EDUCATION

Master of Science, Information Technology Aug 2019 - May 2021 University of Oklahoma GPA: 3.5

Master of Business Administration, Finance Aug 2019 - May 2021 University of Oklahoma GPA: 3.5

Bachelor of Science, Chemistry and minor in Economic Sep 2013 - Jun 2018 National Taiwan University

SKILLS

Tools: SQL, Python, SAS, R, Tableau, PowerBI, Hadoop, VBA, SAP, AWS, google analytics, Alteryx (learning) Modeling: Decision Tree, Time Series analysis, A/B testing, Regression, ANOVA, Clustering, Classification Courses: Data Warehouse, Machine learning, Data Science and analytics, Database Design & Admin EXPERIENCE

Data Analyst (business intelligence) Intern, Octavemusic, Taipei, Taiwan Jul 2020 - Aug 2020

• Natural Language Processing: Performed sentiment analysis on a large unstructured dataset (0.5M samples) of music content using supervised ML Model and categorizing items based on content recognition. (Python, NLP, NLTK)

• Decision Supporting: Developed automated dashboards in PowerBI to assist management in evaluating KPIs and improving the time to complete daily administrative tasks by 10%

• Exploratory Data Analysis (EDA): Conducted data analysis on sales records using time series analysis, descriptive analytics, and seasonality trends to forecast monthly product demand, saving 10% on inventory costs Business Analyst Intern, Automay, Oklahoma City, OK May 2020 - Jul 2020

• Data wrangling pipeline: Automated the ETL and data preprocessing pipeline to transform over 1M rows of unstructured data into semi-structured JSON format, reducing information query time by 20%

• Machine learning: Developed K-NN and Decision Tree algorithms on processed data to predict the cost of pre-owned vehicles, reducing overall purchasing cost by 20%

• Business Intelligence: Formulated histogram charts, choropleth maps, and line plots in Tableau to establish season- ality trends in pre-owned car prices by make and model, reducing sourcing cost, and improving inventory management Associate Analyst, Chinping Industrial, Taipei, Taiwan Oct 2018 - Jun 2019

• Revenue Prediction: Developed a forecasting pipeline to analyze sales records and purchasing contracts to predict future revenue, reducing calculation times by 10%

• Data Mining: Visualized sales data via PowerBI to forecast upcoming peak seasons, which allow for inventory re- alignments and re-adjustment of logistics delivery schedules, reducing 10% inventory holding cost

• Customer Relationship Management (CRM): Communicated with clients to understood the market need, im- proving the client satisfaction

Data Analyst Intern, National Taiwan University, Taipei, Taiwan Sep 2015 - Jun 2016

• Statistical analysis: Collaborated with biochemical scientists and made statistical analysis to conduct process im- provement on biofuel production, resulting in a 30% increase in biofuel yield and a reduction of $3/L in cost

• Data modeling: Made process improvement on biofuel production, leading to a 50% increase in yield PROJECTS

Machine Learning Project - Credit Card Default Analysis

• Architected various Machine Learning classifiers (Decision trees, KNN) in Python with a top-K accuracy of 82%, which is 60% higher than baseline(logistic) regression models on a dataset of 300k samples Donation financial analysis project (for RestoreOKC non-profit organization)

• Developed forecasting models in Tableau and PowerBI on a $2.7M donor data set to predict peak donation seasons as well as geographical regions and focus groups most likely to respond well to targeted advertising campaigns

• Developed a production strategy and a Financial Planning and Analysis (FP&A) spreadsheet over 30 acres of land, generating $1.5M revenue

Student investment fund project

• Researched financial market, financial reports, and loan information to evaluate financial performance

• Forecast 3 years of financial income and expense in ARIMA models, predicting future financial revenue

• Generated sensitivity analysis to manage over 1M USD asset and compared portfolio performance with benchmark 1