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.
• 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.
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)
May 2017-September 2017 Woonsocket, RI
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.
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)