Shengwei Zhu

Shengwei Zhu

Los Angeles, United States

Shengwei Zhu

Data Analysis | Excel Automation | Business Operat
I help businesses turn messy data into clear, actionable insights.

With a background in Business Analytics and real-world experience in logistics and operations, I specialize in building efficient Excel/Google Sheets systems, dashboards, and data analysis workflows that save time and improve decision-making.

What I can help you with:
• Excel / Google Sheets automation (formulas, dashboards, reporting), python
• Data cleaning and structuring
• Business performance analysis (cost, revenue, operations)
• Simple dashboards for daily/weekly tracking
• Any Accounting related job - QuickBook, Financial Accounting, etc.

If you are dealing with manual reports, messy spreadsheets, or unclear numbers, I can help simplify and optimize your workflow.

Working hours

  • Monday:09h00 To 23h00
  • Tuesday:09h00 To 23h00
  • Wednesday:09h00 To 23h00
  • Thursday:09h00 To 23h00
  • Friday:09h00 To 23h00
  • Saturday:09h30 To 22h00
  • Sunday:09h30 To 22h00
• Designed and implemented standardized operational SOP frameworks governing shipment lifecycle knowledge & management, customs coordination, and vendor performance controls.
• Developed structured KPI tracking systems to monitor delivery timeliness, clearance milestones, and return cycle performance, maintaining 100% on-time execution for internally managed operations.
• Built analytical shipment dashboards (Excel / Google Sheets) integrating ETA, discharge, delivery, empty return, and delay attribution to enhance operational transparency and executive reporting.
• Conducted carrier performance and cycle-time analysis to support data-driven vendor selection and service optimization decisions.
• Performed shipment-level cost and revenue analysis to improve margin visibility and inform pricing strategy.
• Partnered cross-functionally with shippers, brokers, warehouses, and customers to mitigate operational risks and ensure compliance within contractual and regulatory timelines.
- Monitoring production metrics: yield, crop condition, harvesters performance, etc., and provide actionable insights
- Re-design and create new payroll procedure: reduced payroll period from 4 days down to 1 day
- Created 3 databases with MySQL and manipulate data with JetBrain PyCharm.
- Leading data collection and production analysis across multiple departments
- Established and created SOP, operational standard, and implement KPI frameworks
- Created General Quality Control Procedures for field and warehouse
- Forecasting costs and resources using historical data and performance
- Producing recurring reports to communicate operational performance
- Collaborating with cross-functional teams to improve efficiency
  • 🇬🇧 English
0.0 (0)
0
0
0
0
0
⚠️
Please sign in as a customer to give your feedback

    Need a service ?

    Do you want to hire the services of this Professional ?

    Post your need and you will receive dozens of proposals from the Professionals of the community.