Warehouse Operations United States

JIAYI LING

Rowland Heights, California, United States

*******@*****.*** 559-***-**** linkedin.com/in/jiayi-ling-27912973 SUMMARY

Logistics professional and WMS developer with hands-on experience designing and implementing custom inventory systems across multi-location operations. Skilled in AppSheet, Google Apps Script, and full-stack development. Proven ability to optimize fleet logistics, automate workflows, and drive data-informed improvements in warehouse operations. EXPERIENCE

Warehouse & Fleet Specialist/WMS Developer Pacific Transload and Transport Compton, CA Oct 2024 – Present

• Built and deployed a web-based WMS using AppSheet and Google Apps Script across multiple warehouses.

• Enabled batch, pallet, and serial number tracking with automated suffixes for partial shipments.

• Managed drayage and long-haul transport of oversized and overweight photovoltaic (PV) panels and Battery Energy Storage Systems (BESS), ensuring safety and permit compliance.

• Reduced delivery delays by 15% through optimized port drayage scheduling and on-site dispatch coordination.

• Digitized inventory with photo documentation for solar/BESS shipments.

• Developed real-time dashboards to enhance operational transparency and data-driven decisions. Full Stack Engineer Industry Software Inc. Oct 2023 – Sep 2024

• Built responsive UI and REST APIs using HTML, CSS, JavaScript, Bootstrap, and Django.

• Improved engagement and reduced development time through efficient frontend-backend integration.

• Built facility resource allocation tools and maintenance trackers as part of a Django web app project.

Dispatcher Four Season Travel LLC Aug 2023 – Sep 2023

• Coordinated tour logistics, managed quotations and invoices, and maintained billing records.

• Managed end-to-end trip data, including driver routes, wages, and invoice preparation.

• Demonstrated problem-solving skills through efficient billing and invoice management. Logistics Specialist P1 Logistics Inc. Jul 2022 – Jun 2023

• Used SAP and Python automation to optimize port appointments and logistics reporting.

• Analyzed daily computer data, adhered to management directives, and utilized Python automation for port appointment scheduling.

Dispatcher MKK EXPRESS INC. Feb 2022 – Jul 2022

• Used AppScript to automate data processing and enhance invoicing workflows in Google Sheets.

• Handled client communications and resolved billing issues in coordination with the finance team.

• Trained new team members and supported daily operations across departments. Dispatcher Assistant Smax Freight LLC Aug 2021 – Feb 2022

• Handled client communication, shipment tracking, and built automation with UiPath and Python.

• Tracked containers and proactively informed clients of shipment progress. Procurement Manager / Computer Specialist New Hope Dreams Inc Aug 2020 – Apr 2021

• Oversaw procurement contracts, warehouse operations, and managed computer refurbishment.

• Negotiated procurement contracts and managed inventory stocking.

• Progressed through various roles in purchasing, warehousing, and leadership. PROJECTS

Technical Projects & System Implementations – Pacific Transload and Transport

• Designed a responsive WMS using AppSheet and Google Apps Script, automating inventory and scheduling.

• Integrated real-time analytics and dashboards (15% reduction in bottlenecks). Automation Toolkit for Container Tracking & Port Communication

- Smax Freight LLC, MKK Express Inc., P1 Logistics Inc. (2021–2023)

• Built Python web scrapers to monitor container status (availability, holds, LFD) from port and carrier sites.

• Automated emails to terminals and carriers, reducing manual work and delays.

• Used Google Sheets API to sync tracking data for real-time team access and alerting.

• Streamlined drayage operations by cutting daily manual checks by 70%. EDUCATION

Diploma of Education, Residential and Commercial Drafting 2013 – 2015 West Island Career Centre – Montreal, Canada

Bachelor of Engineering, Electronic Information Engineering 2009 – 2013 Shenzhen University – Shenzhen, China

SKILLS

• Logistics & WMS: Warehouse Management Systems, Inventory Tracking, SAP Integration, Dispatch Coordination

• Development: AppSheet, Google Apps Script, Python, JavaScript, HTML5, CSS3, Bootstrap, Django, UiPath

• Data & Design: Data Analysis &Visualization, Figma, Photoshop, AutoCAD, Revit, 3ds Max, Sketchup

• Soft Skills: Creative Problem Solving, Cross-Functional Collaboration

• Languages: English (Fluent), Chinese (Native), French (Intermediate ), Spanish (Beginner)

Contact this candidate