Data Analyst

Bu Huang

Tel: 206-***-****

Email: *******@*****.***

SUMMARY OF SKILLS

Research: Key Informant Interview; Focus Group; Survey Research; Site Visit; Observational study; Design of Experiment; Customer Segmentation; Online and Offline Behavior Analysis

Statistical: SPSS; SAS; Python; HLM; M-Plus; Amos

Data visualization: PowerBI; Tableau; Google Looker Studio

Web Analytics: Adobe Analytics; Google Analytics

Other: Advanced Excel skills; SQL/Snowflake; Qualtrics, Gainsight, NPS/CSAT, Salesforce; Project Management; Power App and Power Automate; T-Test, ANOVA, Regressions, Factor Analysis, Cluster Analysis, Structural Equation Modeling (SEM) and HLM; Presentation; Writing (40+ peer-reviewed papers); familiar with LLM

EDUCATION

Ph.D, Sociology, Bowling Green State University, Bowling Green, OH.

MS, Applied Statistics, Bowling Green State University, Bowling Green, OH.

BLL, Law, Peking University, Beijing, China.

WORK EXPERIENCE

Greatnonprofits.org (Contract), Seattle, WA, Apr 2025 – present

Position: Data Analyst

Updating scripts from MySQL to Postgres SQL (new website and new database related activities)

Combining data from SQL database with Web Analytics data and perform data checking

Creating dashboards to visualize data and share insights

Do A/B testing and statistical analysis

Prime 8 Consulting (Contracting at Microsoft), Redmond, WA, Aug 2024 – Apr 2025

Position: Data Analyst, Sales Execution & Operations, Microsoft

Developing PowerBI dashboards

Business analysis and reports writing

Using compelling storytelling based on data insights to make strategic recommendations

Data cleaning and tracking, examining data that may contribute to potential successful sales

VMware, Bellevue, WA, Dec 2021 – Jan 2024

Position: Customer Success Specialist, Customer Success Intelligence and Innovation

Pulling data from SQL tables and developing dashboard in Tableau

Collect data from various sources, using Data visualization to drive strategy

Pre and Post Intervention analysis and create Machine Learning models to predict churns

Customer panel management, NPS, CSAT, VOC, survey design and data analysis

Insight Global (Contracting at Cisco), Seattle, WA, Feb 2021 – Dec 2021

Position: Research Data Analyst, DLJ Experience Research

Doing quantitative usability research to augment data gained from qualitative interviews

Programming surveys, extracting the insights from surveys and moderated (or unmoderated) tests, combining data from Snowflake, and presenting the findings

TEKsystems (Contracting at Microsoft), Redmond, WA, Jul 2020 – Sept 2020

Position: Business Insights Analyst, World Wide Learning, Microsoft

Developing PowerBI dashboards and writing reports on a pilot project within WWL

Data cleaning and tracking, exploring factors related to the certification pass rates

TEKsystems (Contracting at Microsoft), Redmond, WA, Jan 2020 – Jun 2020

Position: Business Data Analyst, Cloud Infrastructure and Operations, Microsoft

Building PowerBI dashboards on supply shortages and leading daily check-ins with managers

Doing price analysis and creating MBR templates for business reviews with major manufacturers of Network Sourcing parts/equipment

IBM, Seattle, WA, Mar 2015 - Jan 2020

Positions: Consultant, Global Business Services; Data Scientist/Business Insights and Operations Manager, Watson Education

A year of consulting experience (as a data analyst/scientist) on various client projects ranging from Autonomous Cars, Human Resources Analytics to Cognitive Analysis in Financial Services

Building AI assisted, predictive and personalized learning models in K-12 schools

Leading operations meetings for the leadership team (Watson Education), tracking financial and operations data, managing revenue and cost, and helping with financial planning

The Seattle Times, Seattle, WA, Jan 2014 - Mar 2015

Position: Analyst, Business Intelligence Department

Web Traffic Analysis and Ads Performances (Adobe Analytics/Google Analytics)

Market Segmentation, Marketing Campaign Analysis and Digital Marketing analytics

Pulling data from SQL databases on Digital Subscription, performing Retention analysis and building BI dashboards for all aspects of the business

Starbucks, Seattle, WA, Oct 2011 - Jan 2014

Position: Manager, Advanced Analytics, Global R&D Sensory Department

Mapping and Data Mining – discovering white spaces for new product development

Design of Experiment (A/B testing, Full Factorial Design and Response Surface) and related data analysis to help food scientists to create best-tasting products and find cost effective suppliers/ingredients for established products

Organization of panel database -Product Guidance Testing/Central Location Testing

Compucom (Contracting at Microsoft), Redmond, WA, Jan 2010 - Jun 2010 & Oct 2010 - Oct 2011

Position: Usability Researcher, PSS Microsoft

Mining web usage data at the support.microsoft.com

Work flow analysis and A/B testing

Safeco Insurance, Seattle, WA, Oct 2006 – May 2008

Position: Senior Market Research Analyst, Marketing Department

Customer data analysis & customer and agency profile and segmentation analyses

Building response and conversion models for Direct/Database Marketing/Lead Generation

Building churn models to help retain customers and increase renewal rate

Contact this candidate