Data Analyst Sales

WILLIAM TSAI

*** * **** ** #***, Seattle, WA ****2, 216-***-****, adhreu@r.postjobfree.com

Work History

EXPEDITORS INTERNATIONAL (Fortune 500 Global Supply Chain Company.) Seattle, WA Business Analyst and Report Designer – Global Business Operations 03/2020 – 09/2020

Constructed process scorecard and workflow operations analytical dashboards in Power BI to enable global logistic products’ performance visibility. Collaborated with data engineers on ETL and data warehousing and created views in MS SQL server database, wrangled the data in Power Query, and analyzed product compliance and performance forecasting by applying advanced DAX. Reduced the processes delay by around 5% globally compared to last quarter.

Generated operations analytics reports using SQL on SQL Server Management Studio and Python Panda Data Frame for internal operations auditing. Edited and integrated the queries in the Visual Studio Code and managed the projects on GitLab, assisting the internal auditors to conduct over 180 global branches’ performance auditing.

Optimized existing Power BI reports using a more efficient data model strategy and DAX to enhance performance speed on the server, reduced 35% of the byte count in the reports to render on the front-end web system. CHAMPION ONE (Open Optical Networks Solution Company.) Independence, OH Intern Data Analyst 05/2019 – 12/2019

Developed an interactive sales analysis dashboard leveraging Power BI, SQL, and Excel to analyze KPI and sales to drive actionable insight. The data visualization report enables the managers to identify opportunities and allocate resources to potential clients, resulted in growing regional sales by 7% compared to the same period last year.

Set up a data gateway and conducted ETL process between Acctivate (ERP), Power Bi, and Excel using CData (ODBC), enabling non-technical specialists to access inventory and sales data to create reports serving a variety of purposes.

Analyzed the sales team’s productivity on HubSpot (CRM) to compose productivity reports for performance review. JOANN STORES (American Specialty Retailer of Crafts and Fabrics.) Hudson, OH Lean Six Sigma Program – Student Analyst, Demand Forecasting of Short Life-Cycle Product SKUs 01/2019 – 05/2019

Created a predictive model in VBA applied Stepwise Linear Regression and Hypothesis Testing for demand forecasting.

Optimized the precision of weekly demand forecasting of knitted products by an estimated 18% compared to current. TAIPEI FUBON COMMERCIAL BANK CO, LTD. (First rank listed bank in Taiwan.) Taipei, Taiwan Corporate Banking – Assistant Relationship Manager 02/2017 – 10/2017

Conducted client due diligence by analyzing customer financial reports, industry standards, e-JCIC, and Bloomberg.

Analyzed the team’s KPIs, planned the remaining credit balance, and generated the weekly summary report in Excel. CTBC BANK CO, LTD. (First rank listed bank in Taiwan.) Taipei, Taiwan Financial Consultant 03/2016 – 02/2017

Analyzed mutual funds and corporate financial indicators to forecast and report financial products’ performance.

Managed portfolios worth over $5 million. Guided clients to generate an average ROI of 12% per annum on portfolios. Data Science Project

Enrollment Forecasting and Data Visualization Programming of US Public University Statistics Cleveland, OH Goal: Simulate, predict, and optimize the effect on enrollment with a one-time tuition decrease. 01/2020 – 01/2020

Used unsupervised machine learning algorithms K-means Clustering and the Elbow method to determine the optimal clusters, and applied Linear Regression to forecast the effect statistics of tuition variation on enrollment. Education

CASE WESTERN RESERVE UNIVERSITY, WEATHERHEAD SCHOOL OF MANAGEMENT Cleveland, OH Master of Science in Operations Research and Supply Chain Management 08/2018 – 01/2020

Merit-based scholarship recipient. Leadership: VP of Weatherhead Supply Chain Operations Club. SHIH CHIEN UNIVERSITY Taipei, Taiwan

Bachelor of Business Administration in Finance 09/2010 – 06/2014

Merit-based scholarship recipient.

Skills

Language: SQL, VBA, Basic Java, R, Python (Library: Numpy, Pandas, Matplotlib, Scipy, Scikit-Learn), Power BI DAX Tool: SharePoint, Excel, MSFT Power BI, Tableau, MS SQL Server, GitLab, Azure DevOps, Spark, HubSpot (CRM), SAP (ERP)

Contact this candidate