Peiqing Zuo

Experience

• 

  Suning

  May 2018 - Mar 2019

  Accountant

  Accountant for Retail Business Accounting- Queried transaction data using SQL and identified potential frauds by analyzing key indexes, including historical payment, refund application records, and address consistency.- Built a dashboard to calculate key metrics of promotional activities, including customer acquisition rate, turnover growth, and return on investment, with Python. Analyze potential influencing factors and make recommendations for follow-up activities.- Collected accounting data from SAP ERP, analyzed cash flow and account balances through Excel, and assisted the chief accountant in issuing quarterly financial statements. Show less

• 

  China International Intellectech Group Co.,Ltd

  Aug 2020 - Jun 2021

  Operations Analyst

  Associate Operations Analyst focus Human Resources Consulting Service- Analyzed enterprise employment demand and generated suggestions regarding recruitment plans, corporate employment structure, talent allocation, salary research reports, and digital HR transformation based on annual national preferential policies.- Served 10 clients for 6 consecutive months. Helped enterprises cut 10% of labor costs by optimizing employment structure and providing suitable candidates. Used Tableau to develop visualizations of recruitment insights. Show less

• 

  UT Dallas Office of Research and Innovation

  Jun 2022 - Aug 2022

  Data Analyst

  Data Analyst Intern in Streaming Video Equipment Development Project- Built a proof of concept for a video recording and transmission device for an online video site by integrating electronic components into a mini personal computer. The potential customers of this device include bookmakers and transportation companies.- Designed and built the underlying database system of the project to organize details about videos, users, and user interactions. Designed a service for scale to support 5000 concurrency users. Improved the operating efficiency of the database by 20% by using Database Normalization to reduce redundancy in data processing, building ETL pipeline, and optimizing complex SQL queries.- Used Python to add the facial recognition feature to identify the number of passengers in the vehicle and blink detection to gauge user engagement and attention levels. Show less

• 

  Allway Tools, Inc.

  Jun 2023 - Dec 2023

  Business Intelligence Analyst

  Business Intelligence Analyst at Accounting and Sales team- Monitored customer invoices, rectified errors, recorded payments in ERP system, and collaborated on cash flow management with the Controller.- Utilized the EDI system to obtain order data, then got in touch with consumers to verify the specifics of the order. Created metrics using system data to assess error rates and order fulfillment accuracy. Determined the root causes of mistakes and offered suggestions for enhancements to raise the order processing accuracy to 98%.- Created dynamic charts with Power BI to show purchasing, inventory, and sales data. Utilized R statistical techniques to anticipate inventory requirements for the upcoming quarter, examined KPIs impacting sales using several models, decreased inventory while maintaining sales volumes, and increased corporate liquidity utilization by 10%.- Led a team to upgrade inventory system, evaluated financial viability, drafted a comprehensive plan, addressed testing phase issues, and optimized system usage. Show less

• 

  YITA LLC

  Feb 2024 - Apr 2024

  Outbound Supervisor

  Outbound Supervisor in Warehouse Management Team- Leading a 10-person picking team to process more than 1,800 items per day. Through the use of WMS and PDA devices making timely adjustments to staffing and unloading sequences, picking efficiency is ranked among the top of the company's warehouses.- Assisting manager to improve SOP production. Add new cases to SOP and provide example image support for existing cases.

• 

  BLOOMSUNG INC

  Apr 2024 - now

  ICQA

  ICQA for warehouse operation team- SOP material collection, process modification and promotion.- ShipBob full process management, make corresponding improvements to warehouse processes based on ShipBob's system and regulations. Focus on solving the overpick return process.