Hao Guo
South Amboy
Summary
Accounts Receivable Specialist at JD Logistics with a strong focus on billing reconciliation and data analysis. Resolved a $2 million logistics billing discrepancy and enhanced forecasting accuracy by 15% using advanced analytical techniques. Proficient in Tableau and Python, with a proven track record in improving financial reporting and facilitating collaboration across teams.
Overview
3
3
years of professional experience
Work History
Accounts Receivable Specialist
JD Logistics
New Jersey
03.2025 - Current
- Managed over 20 client accounts, including two key accounts generating $2 million monthly revenue.
- Coordinated warehouse, sales, and customer-service teams to resolve a $2 million logistics billing issue.
- Analyzed customer payment behaviors to identify delinquency risks and partnered with sales for timely payments.
- Performed AR-based financial analysis supporting Finance BP in evaluating customer-level P&L and refining forecasts.
- Collaborated with China-based IT team to maintain billing systems, ensuring data accuracy across platforms.
- Designed a settlement dashboard enhancing invoice issuance monitoring and improving month-end efficiency.
Team Lead / Student Consultant
Schnuck
Missouri
08.2024 - 10.2024
- Led a pilot study analyzing two years of sales and forecast data from five stores, improving forecasting accuracy by 15%.
- Identified key variables such as weather and workdays, using regression analysis and random forest to refine predictive models.
- Created interactive Tableau dashboards to present findings and recommendations to the data science team.
- Scaled insights chain-wide, leading to the adoption of new variables and improved inventory management.
Data Analysis Intern
Petro China
Beijing
05.2023 - 08.2023
- Analyzed over 7,000 sales records, resolving inconsistencies to improve data accuracy by 7.5%.
- Built interactive dashboards using Tableau to visualize sales trends and customer segmentation.
- Conducted market analysis and competitor benchmarking, increasing Beijing's gasoline market share by 3% in the next quarter.
- Applied financial modeling techniques such as DCF analysis and forecasting to evaluate strategic opportunities.
Education
Master - Business Analysis, Customer Analysis
Washington University in St. Louis
Saint Louis, MI12.2024
Bachelor - Economics
University of Connecticut
Storrs, CT05.2023
Skills
- Accounts receivable management
- Billing reconciliation and expertise
- Payment tracking and aging analysis
- Logistics coordination
- Data analysis and visualization
- Python and SQL proficiency
- Excel functions including pivot, XLOOKUP, and Power Query
- Automation of processes
- ERP and settlement systems knowledge
- Tableau and Power BI skills
- Financial reporting
Websites
Languages
English
Professional
Chinese (Mandarin)
Native/ Bilingual
Timeline
Accounts Receivable Specialist
JD Logistics
03.2025 - Current
Team Lead / Student Consultant
Schnuck
08.2024 - 10.2024
Data Analysis Intern
Petro China
05.2023 - 08.2023
Master - Business Analysis, Customer Analysis
Washington University in St. Louis
Bachelor - Economics
University of Connecticut