Wenjie He

Experience

• 

  Chicken Now

  Jan 2015 - Jan 2016

  Cashier
• 

  Chi Pan Asian

  Jan 2017 - Jan 2019

  Assistant Manager

  -Hired and trained sales associates to work on the floor.-Fostered strong relationships with customers and employees to strengthened our brand awareness.-Maintain accurate customer records for loyalty program-Manage and evaluate revenue and expense reports

• 

  UNIQLO

  Jan 2017 - Jan 2017

  Sales Associate
• 

  Panda Express

  Jan 2019 - Jan 2020

  Shift Lead

  -Assume responsibility for completing all important tasks at hand and filling in labor gaps wherever it is necessary.-Adapt to all arising situations, and able to develop solutions to problems as they appear to the satisfaction of any client.-Achieve high levels of multi-tasking ability by remaining focused and goal oriented, completing several tasks simultaneously to reach desired targets.-Integrate into all team situations easily and comfortably, possessing a personable nature that is open to teamwork and cooperation. Daha az göster

• 

  ADP

  Jan 2020 - Jan 2020

  Sales Operations Analyst Intern

  - Researched multiple processes within the business unit and provided alternative solutions to streamline those processes.- Created a new approach for building in excel through the use of different features and macros within excel for a better user experience.- Tested software for customization ability, low learning curve for users, ability to handle large imports of data, perform the various functions requested, and generated sensible visuals

• 

  B-Stock Solutions

  Jan 2020 - Jan 2021

  Auction Listings Technician

  - Lead projects to analyse auction listings frequency and volume to effectively determine ideal times for auctions while reducing time spent on auctions by 18%.- Effectively maintained portfolio of auctions for 10+ large retailers such as Costco, Wal-Mart, Home Depot etc.- Performed QA on 100+ auctions listings per day to ensure accurate representation of listings with 98% accuracy rate.-Manage and create visualization for auction listings data utilizing tools such as Excel, Google Sheets and Smartsheets. Daha az göster

• 

  ADP

  Jan 2021 - Jan 2023

  Sales Support Analyst

  - Used SQL to access and manipulate large territorial sales data to create an Excel tool for sales leadership in all divisions for USA to ensure respective sales team’s territories are at minimum 70% optimized every fiscal month.- Designs interactive, user-friendly, and insightful dashboards using industry best practices. Develop Dashboards in Excel and reports in SQL Server Reporting Services. Create engaging visualizations that answer key business questions and promote exploratory analysis.- Automates existing process by writing SAS programs to schedule data extracts from multiple databases during non-business hours for easy and swift reporting updates and creation.- Supports reporting and data mining efforts providing analysis that drives sales recommendations and uncover opportunities for growth at ADP.- Create multiple ad hocs to support leaders in multiple business units (BU) in Reporting and Insights while ensuring best in class process improvements. Daha az göster

• 

  The Walt Disney Company

  Jan 2023 - now

  -Wrote complex SQL queries to audit data quality in the JEWEL development environment and leveraged Power Query to automate audits for team members, improving data integrity and reporting efficiency.-Created and updated tools to establish to improve the processes across multiple Resortand/or Parks locations using data analytical tools such as VBA, Python, Power Query, etc.- Used a comprehensive set of statistical techniques, including forecasting, regressions, andscenario planning to provide analysis results for clear options and recommendations fordecision-making in the Workforce Management space.- Leveraged data manipulation/processing using Python to create engaging dashboardvisualizations in Excel and to provide multiple views on large dataset to drive and promoteeffective business decision making.- Shared subject matter expertise and collaborated on analytics approach, design, andcalculations. Effectively translated analytical results into clear, story-based presentations forboth technical and non-technical audiences. Daha az göster -Collect and analyze ridership, scheduling, operations, financial, and field data to derive actionable insights to ensure high GSM scores among all resorts of the Walt Disney World property.-Provide leadership and analysis for changes to the Walt Disney World transit system, using multiple RPA scenarios and conditions to ensure optimal trip planning for different situations.-Take a lead position on implementing Computer-Aided Dispatch (CAD) and Automatic Vehicle Location (AVL) planning processes.-Supported the charge in developing Dashboards in Excel, Tableau and reports in SQL Server Reporting Services. Design and improve existing interactive, user-friendly, and insightful dashboards using industry best practices ensuring Transportation Logistics processes are more efficient.-Analyzing a variety of data using multiple tools and forecasting models, updating existing and creating new tools/models. Daha az göster

  • Senior Workforce Analyst

    Jan 2023 - now

  • Workload Staffing Analyst

    Jan 2023 - Jan 2023