Wei Wang
Data Analyst
Palatine,IL
Summary
Proven Data Analyst with a track record of leveraging SQL and Power BI to drive decision-making. Working experience in electronic and manufacturing industry. Excelled in transforming complex sales data into actionable insights, enhancing product performance through meticulous analysis and collaborative cross-departmental efforts. Demonstrates strong analytical skills and a keen ability to communicate complex information effectively.
Overview
4
4
years of professional experience
6
6
years of post-secondary education
4
4
Certifications
Work History
Sales and Purchasing Data Analyst
Hyper Microsystems
02.2024 - Current
- Identified Slow-Moving Inventory: Analyzed SKU-level sales performance to pinpoint underperforming products and devised strategies to improve sell-through rates.
- SQL Analysis for Sales Metrics: Extracted and queried sales data using SQL to generate critical insights into inventory and sales trends.
- Sales Data Analysis: Conducted comprehensive analyses using Excel to calculate sell-through rates, track product performance, and develop actionable recommendations to optimize inventory management.
- Data Visualization: Leveraged Power BI and Tableau to create interactive dashboards and visualizations, enabling clearer insights into sales metrics and product performance, enhancing data-driven decision-making.
- Business Impact: Increased monthly sales by 12% and reduced slow-moving inventory levels through targeted recommendations and streamlined inventory strategies.
Data Analyst
Navajo Manufacturing
03.2021 - 10.2022
- Generated monthly reports leveraging advanced Excel functions for data analysis and visualization.
- Analyzed shipping data to evaluate performance metrics and identify trends.
- Collected data from Bills of Lading (BOL) and reconciled received quantities against manifests to ensure accuracy.
- Collaborated with cross-functional teams to identify inefficiencies and recommend data-driven solutions.
Education
Master of Science - Management Information Systems
University of Colorado
CO 02.2022 - 11.2023
Bachelor of Arts - English Language And Literature
Fujian Normal University
Fujian 06.2016 - 07.2020
Skills
SQL
Power BI
Tableau
ETL processes
Microsoft Azure
Finance
Excel
Certification
Microsoft Power BI Data Analyst Certification
Timeline
Sales and Purchasing Data Analyst
Hyper Microsystems
02.2024 - Current
Master of Science - Management Information Systems
University of Colorado
02.2022 - 11.2023
Data Analyst
Navajo Manufacturing
03.2021 - 10.2022
Bachelor of Arts - English Language And Literature
Fujian Normal University
06.2016 - 07.2020
Microsoft Power BI Data Analyst Certification
Microsoft Azure Data Fundamentals Certification
Tableau Desktop Specialist
CompTIA A+
Similar Profiles
Mary KingMary King
Account Executive at Hyper Microsystems IncAccount Executive at Hyper Microsystems Inc
Oleksandr NackonechnyiOleksandr Nackonechnyi
Warehouse Worker at Hyper Microsystems IncWarehouse Worker at Hyper Microsystems Inc
Usama KhanUsama Khan
System Administrator at SAT MicrosystemsSystem Administrator at SAT Microsystems