• Monitored key performance indicators (KPIs) for the east-coast sales team and generated analysis reports from CRM system to expedite
sales KPI attainment, achieving up to $5 million per month
• Oversaw the new customer account setup and OMS training process, collaborating with cross-functional teams to streamline customer
onboarding and boost company revenue by 8-10% each quarter
• Utilized financial system and Excel to generate monthly bills for both warehouse and air/ ocean freight clients, ensuring timely invoice
reconciliation to maintain the company's current accounts receivable
• Worked closely with sales and legal teams for assisting in contract preparation and documentation review
• Analyzed MTD data using Excel from the internal EASY BI system, identified irregular client revenue, and reported findings to Account
Managers
• Participated in weekly meetings with carriers to address any operational issues and cultivate positive relationships

• Developed and implemented monthly net benefits analytical dashboard by collecting over 50,000 data points using SQL and Power BI
• Analyzed delivery lead time and company cargo volume to automate data analysis using Python
• Led cross-functional teams, including pricing and operations, to identify data source of 5 carriers’ zone chart, clean data and generate
reports for cost pricing negotiations using Python and Excel
• Detected 5 data errors while generating 10 invoices monthly, resulting in recovering over $30,000 in overpayment and improving billing
team efficiency by 30% through data analysis automation with Python
• Led the T86 project, monitored air freight status on a daily basis, coordinated with customs clearance company to ensure smooth customs
clearance processes, and facilitated cargo pickup
• Collaborated with bonded warehouses, supervised the smooth delivery of T86 products through carriers