Collected and structured daily point-of-sale (POS) data in Excel to track revenue across shifts.
Built weekly and monthly sales reports, breaking down performance by item, time of day, and day of week.
Tracked and visualized peak-hour trends to optimize staffing schedules and reduce idle time.
Monitored inventory usage vs. sales volume to minimize waste and improve ordering accuracy.
Operations Assistant
Green Home Land Construction Inc
08.2023 - Current
Consolidated daily material, labor, and equipment cost records in Excel to create structured project databases.
Developed automated summary tables and pivot charts to visualize cost breakdowns by project and timeframe.
Monitored project timelines and milestones, updating weekly dashboards to support scheduling decisions.
Produced budget variance reports that helped improve forecasting and purchasing strategies.
Data and Content Assistant Intern
Sino TV
11.2022 - 05.2023
Collected and organized 200 + daily content entries in Excel, maintaining accurate and up-to-date internal records across multiple departments.
Managed and structured digital content archives and website assets, improving data accessibility and retrieval efficiency by streamlining folder hierarchies.
Developed and maintained Excel-based tracking sheets and content logs with formulas and filters to improve workflow visibility and reduce reporting time.
Collaborated with cross-functional teams including production, editorial, and web management to ensure data accuracy and meet publishing deadlines.
Translated and standardized bilingual (Chinese–English) documents and media scripts, ensuring precision and consistent formatting for broadcast.