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
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
Erin BadmanErin Badman
Barista at Hyper Hyper CoffeeBarista at Hyper Hyper Coffee
Lizmarie MaldonadoLizmarie Maldonado
Amazon Delivery Driver at Midwest LogisticsAmazon Delivery Driver at Midwest Logistics
Nicole EvansNicole Evans
AVP, Default Loan Servicing at Wintrust MortgageAVP, Default Loan Servicing at Wintrust Mortgage