Or
Shengwei Zhu

Shengwei Zhu

Data Analysis | Excel Automation | Business Operat
📍 Los Angeles, United States · (0) · Member since April 2026
Availability
🏠 Works remotely / from home Yes No
🧰 Travels to client Yes No

Presentation

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.
📋

Background

Business Analyst
F1 Global · 12/08/2025 – Today
• 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.
Business Analyst
Lucky Farms · 04/03/2025 – 12/05/2025
- 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
🕐

Working hours

Monday
From09h00To23h00
Tuesday
From09h00To23h00
Wednesday
From09h00To23h00
Thursday
From09h00To23h00
Friday
From09h00To23h00
Saturday
From09h30To22h00
Sunday â–ª Today
From09h30To22h00

Reviews

No reviews

⚠️
Please as a customer to give your feedback
💬
No reviews yet.
Be the first to share your experience with this professional.