Jackson Huang Email and Phone Number

• Performing analysis on Customer demographics, shopping behaviors, and other Customer KPIs• Developing dashboards for the eCommerce and Marketing team leveraging consistent KPIs across the group by using Power BI and SQL on the Amperity CDP• Improving the quality of existing data products and sources to increase usage of data in day-to-day business operations

• Generated sales reports for management by conducting data cleansing and mining with SQL and Excel• Partnered with stakeholders and provide financial analytics to support the accounting team by generating daily, weekly, and monthly reports with Excel (Pivot Table, V-lookup, and advanced formula) • Managed product listing and troubleshooting by using Excel (Pivot Table, V-lookup, and advanced formula)• Built out data and reporting infrastructure from the ground up using PowerBI, Excel, and SQL to provide real-time insights into the products, sales, and business KPIs across different market platforms• Partnered with finance, marketing, and management teams in the development of reporting by retrieving and manipulating data in MySQL, analyzing data, and creating visualizations and dashboards with Python and PowerBI• Delivered analytical findings of sales and product performance by retrieving data from different databases and analyzing 700k SKUs and sales data with Advanced Excel (Google Sheets)• Recommended the improvements of traffic on Amazon by conducting product analysis with Python and PowerBI

• Delivered competitive market analysis addressing luxury shoe market focused on strategy for new brand introduction representing 40% potential sales growth. Reported directly to head of marketing• Created a comprehensive database and seasonal Line Sheets for all wholesale accounts using excel formulas• Increased sales efficiency by 8% by implementing an inventory management system for 250 SKUs

• Improved process efficiency by 8% by managing enrollment database of over 1,000 student accounts for online courses • Provided reports suggesting improvements to the online course offerings by conducting qualitative and quantitative research

• Expanded the potential millennial customer base by 10% by conducting market research • Partnered with the R&D team to launch a new collection of skin care products by analyzing products and market• Enhanced brand awareness and increased customer base by 8%, by targeting B2B and B2C through Beauty and Cosmetics trade and trunk shows• Increased sales by 15% through market research and targeting dental offices with specially formulated dental products

• Launched haircare products by partnering with R&D team and analyzing primary and secondary data• Generated sales by 8-10% by actively communicating and advising accounts on how to sell and display product lines effectively• Promoted new product lines by collaborating with vendors for trunk shows