Caroline Gao

Experience

• 

  Jinan YinWuZhiFeng Culture Media, LLC

  May 2019 - Aug 2019

  Business Operations Analyst

  • Implemented data governance processes for the start-up e-commerce company to organize and clarify scattered data, including collecting and analyzing daily sales performance (correlation matrix, multi-linear regression & forecasting models) and activities by utilizing Python and Excel (Pivot table and Lookups).• Monitored the daily turnover of different live-streaming influencers and recorded the sales volume by using Excel and developed different data visualization dashboards in Tableau to generate sales reports on a daily and monthly basis.• Organized and compiled the formal report on sales data analysis and presented it to the senior managers in both weekly project meetings as well as monthly operations of review Show less

• 

  China Tower Corporation Limited(transmission tower、telecom tower、angle、steel tower、steel pole、power)

  Sept 2019 - Jan 2020

  Data Analyst

  • Inspected/modified B2B business contracts & maintained contract extensions with multiple partner companies/offices within the city, including data governance process in proofreading the customer information from the internal system by utilizing Excel (Pivot table, Vlookup, etc); gather & analyze requirements and deliver working implementations to cross-functional teams.• Developed a web scraping technique to monitor the progress of contract tasks for each assistant to improve the working efficiency of the department. Show less

• 

  Fantuan 饭团

  Feb 2023 - Jul 2023

  Operations Analyst

  • Utilized Power BI, Excel (VBA, Pivot Tables, Lookups) and heatmaps to optimize route selection for distribution personnel. Employed SQL for data querying to identify trends in logistics effectiveness and fluctuations in daily and monthly order volumes, improved delivery effectiveness by 23%• Collaborated with cross-functional teams & established SOP and implemented forecasting models (time-series/moving average) by using R to ensure logistics and warehousing operation efficiency• Implemented PM tools (Gantt charts & WBS), alongside monitored and enhanced logistics efficiency, tracking monthly performance of restaurants, conversion rates of carriers' retention, and KPIs, through the implementation of PowerBI dashboards and statistical models by R and Python Show less

• 

  UniUni

  Jul 2023 - Oct 2023

  Logistics Operations Analyst

  • Web Scraping: Implemented Python's Pandas and BeautifulSoup packages (Spyder), automated the extraction and consolidation of logistics-related data from internal system, improved the efficiency of deconsolidation processes by 54.8%• Implemented SQL (MySQL) for database design & management, data manipulation, and in-depth analysis, including converted unstructured data into diverse organized & clear tables for facilitating deeper levels of data analysis, and establishing data modeling and dashboards in PowerBI to accurately represent logistics-related information such as tracking delivery processes of TEMU• Employed R and predictive modeling (moving average) to forecast inventory & demand patterns, and proactively adjust operational strategies. streamlining data processes and enhancing accuracy in inventory forecasting processes Show less

• 

  Linktrans

  Oct 2023 - now

  Business Intelligence Analyst

  • Leveraged VBA to enhance the accuracy of tabulations and optimized algorithms to automatically calculate the monthly drop-shipping lead times, developed statistical models such as multi-linear regressions, utilized Tableau for in-depth data visualization analysis, significantly boosted the operational efficiency by 47%• Implemented SQL for the creation of a well-organized database, facilitating efficient data querying and integration, ensuring data standardization and process alignment for internal logistics system, transformed workflow precision and productivity for Amazon FBA delivery lines• Conducted in-depth logistical data analysis and reporting, collaborated and presented monthly data-driven business reports with cross-functional teams to inform strategic decision-making processes aimed at streamlining logistical operations and enhancing the productivity and efficiency Show less