Data Analyst

Wen-Chieh (Jamie) Wu www.linkedin.com/in/wenchieh-wu

*** ********* *****, ***** ** 85282 480-***-**** adcqu9@r.postjobfree.com

SUMMARY

Data analyst experienced in data analysis, interpretation, and reconciliation to provide data-driven and customized solutions. Skilled in data visualization, SQL, SSRS, machine learning, statistics, programming, and problem solving. Bilingual in English and Mandarin.

EDUCATION

W. P. Carey School of Business, Arizona State University, Tempe, AZ Aug 2018 – May 2019

Master of Science in Business Analytics

National Central University, Taipei, Taiwan Sep 2014 – June 2018

Bachelor of Information Management

PROFESSIONAL EXPERIENCE

Business Data Analyst Dec 2019 – Present

North Central University / National Education Partners, Scottsdale, AZ

•Utilized SQL, custom scripts and stored procedures to gather and assess data from the reporting database, transactional database, operational data store, and external systems to assist university leadership in decision making

•Developed and built SSRS reports, designed ad-hoc reports, gathered requirements, analyzed data to support clients’ operation reports based on their business requirements

•Utilized Business Intelligence (BI) software, Birst, to designed and built dashboards with interactive views, trends, and drill-downs that provide clear visualizations of various university-specific KPIs and the performance in real time; Sprinted in sourcing, processing, managing data and distributing business-driven and actionable visual reports

•Conducted statistical analysis and trend analysis to provide insights on current school performance

•Continually assessed data quality throughout the database and coordinates with IT in the correction of source data or creation of translation sources

Data Analyst Intern July 2019 – Nov 2019

Katerra, Tempe, AZ

•Extracted and cleaned the data, assessed data quality, eliminated irrelevant outliers and transformed raw data into actionable information that drives business improvements

•Applied statistical analysis to identify and interpret patterns and trends in construction projects

•Conducted regression analysis and developed prediction models to improve accuracy of building cost estimation and demand forecasting

•Conducted S curve analysis to identify projects performance and found the root cause of profit decreasing

•Utilized data visualization tool to make clear and concise visual representations of data; Created customized presentation quality data summary dashboards and figures for business performance and external clients. Reported directly to CEO and COO to support business operations

Data Analyst (Project) Jan 2019 – May 2019

Televerde, Tempe, AZ

•Built churn propensity model for Televerde’s customer base and visualized analysis and results from business perspective through Python Seaborn and Tableau, successfully predicted potential churner with 93% accuracy rate and identified the main factors affecting churn rate

•Preprocessed and cleaned a 300GB dataset in Python. Process including EDA, data cleaning and data preprocessing

•Created complex machine learning models and applied supervised learning algorithms, including logistic regression, decision tree, random forest, KNN, ensemble algorithms to classify data, and evaluated the performance by using classification report, confusion matrix and accuracy rate

University Teaching Assistant, Computer Information System Jan 2019 – May 2019

Arizona State University, Tempe, AZ

•Managed and provided support for a Prob Solving & Act Analytics class with 120 individuals.

•Assisted students with analytical techniques, including statistical concepts, data modeling, Excel, machine learning, optimization modeling and SQL

•Graded assignments and offered constructive feedbacks on class materials based on student performance

•Interpreted statistical analysis results and tutored students in SQL, machine learning related knowledge

PROFESSIONAL SKILLS

•Programming: Python (Pandas, Numpy, Scikit-learn, Seaborn, Matplotlib), SQL, R, and Tableau

•Statistical Analysis: DOE, Descriptive Statistics, Distribution, Hypothesis Testing, ANOVA

•Other Software: Tableau, Birst, Microsoft Azure ML, Visual Studio, Microsoft Excel

Contact this candidate