Crystal Wang

Business Data Analyst
Boston Software Group Inc.

Experienced Information Business Analyst with exposure to data analysis, data visualization, process improvement, and cross-functional facilitation 

Welcome

Thank you for visiting this page. I hope this page can provide a quick highlight of my professional background, skills and a quick demo of my capability as a business data analyst professional.

Skills

  • Business Analyst
  • Data Analyst
  • PowerBI
  • Tableau
  • QlikView

Demo: Microsoft Power BI

In this demo, I use sample sales data and build a dashboard using Microsoft Power BI to create data visualization to illustrate comparison of sales among product categories, products, customers, and by years.

Demo: Google Analytics & Data Studio

In this demo, I use sample sales data and build Google Analytics dashboard using Google Data Studio to create data visualization for an in-store digital intelligence project.

In-Store Customer Digital Intelligence Dashboard

Built with Google Data Studio

More detail will be provided later.

Demo: QlikView Dashboard

In this demo, I use sample sales data and build QlikView dashboard to create data visualization and help business quickly explore insights and opportunities.

Built with QlikView

I put together to demonstrate a fact table with multiple levels of granularity.

I used four excel spreadsheets (Order, Product, Customer, and Salesperson) as data sources. After manipulating data with scripts, I developed various charts in Qlikview to get business insight.

Besides, I created a quick demo of the dashboard, so you can see how it works without download the Qlikview desktop.
Exported QVW file

My Recent Work Experience

Boston Software Group Inc.

July 2019-Present, Boston, MA

Business Data Analyst

• Eliciting business requirements, performing project management, and documenting product design specification for UBQ store tracking system; 

• Developing data mapping, writing SQL queries to get business insights,  and analyzing customer shopping habits in Tableau.

Tokyo Eletron

January 2018-June 2019 Austin, TX

Business Systems Analyst

  • Developed automated solutions (forms and workflows) to improve business processes, provided technical expertise in identifying, evaluating, and developing systems and procedures that meet stakeholders’ requirements and system restrictions.
  • Proactively evaluated and cleaned up master customer information for data warehouse by Microsoft SQL Server.
  • Identified critical metrics and KPIs for Sales Operations, built data modeling for forecast using Power Query, and delivered actionable insights to Director of Sales by Power BI.

Project: Improved Data Prep for Analytics, Austin, TX                              Apr. 2018 – Jul. 2018

  • Extracted, transformed, and loaded customer information and vendor information by Power Query; created a relational database for ad hoc analysis, and delivered actionable intelligence. (TEL Customer Service Award)

CVS Health

May 2017-September 2017 Woonsocket, RI

Information Analyst

  • Developed SQL queries in Microsoft Access to extract, clean, and transform UAL; prepared identity management spreadsheets with VBA, Vlookup, and If functions.
  • Performed project management for 20 apps in the Android platform in Visio and presented insights to the management monthly.

Project: Development of Hotel Booking Application, WPI, MA   Feb 2016 – May 2016                                                               

• Identified customer requirements in a variety of scenarios, cleaned up data and built ranking criteria by Excel and SPSS.• Designed a mobile application to help users select hotels by preferences: created Entity Relationship Diagram in Visio, wrote 30+ lines of SQL queries and designed clickable prototype by Android Studio.

SAP Labs

July 2013-August 2014 Shanghai, China

Technical Writer (Intern)

  • Led a group of 4 people to provide documentation supports to implement ERP systems, translated 50 pages within a week.
  • Collaborated with developers to design web pages for newly launched online SAP Learning platform, facilitated with UAT, and wrote analytical review. (https://open.sap.com/courses)