Leyang CAO

•Built scalable ETL data pipelines to clean, standardize, and integrate order, shipment, inventory, and supplier datasets across multiple operational systems, reducing manual data reconciliation by 80% and enabling data visibility into supply chain health •Designed and automated key operational metrics including OTIF compliance, fulfillment delay ratio, and supplier defect trends, driving a 15% improvement in delivery performance and reducing late shipments by 12% •Developed interactive Tableau dashboards with dynamic warehouse and supplier filters, KPI summaries, and time-series incident trend analyses, accelerating root-cause detection by 40% and increasing stakeholder adoption rate by 60% •Delivered actionable insights and recommendations to operation and supply chain teams, optimizing warehouse assignment logic and carrier routing, resulting in a 10% reduction in fulfillment risk and 2-day improvement in average delivery time

•Analyzed regional market performance using Excel and Power BI, integrating sales, demographic, and promotion datasets to identify growth opportunities, which boosted marketing ROI by 18% and guided strategic investment decisions •Developed multi-source event performance on visualized dashboards tracking attendance, engagement rate, and conversion ratio for five commercial events, reducing manual reporting time by 60% and enabling real-time performance evaluation •Built sponsor performance evaluation models with regression analysis to measure collaboration value and synergy, expanding partnership opportunities by 25% and optimizing cross-brand exposure efficiency •Coordinated cross-functional teams across marketing, sales, and logistics to ensure seamless event execution, which increased operational efficiency by 20% and enhanced post-event customer satisfaction survey results

- Processed project data with Excel and Vimo, and identified key issues to support strategy development - Assisted project manager with progress tracking, resource allocation, and cross-departmental communication - Created technical documentation like user manuals and operational guides to ensure accuracy and consistency

•Collected and analyzed audience engagement data from WeChat and Tencent Video platforms using Excel pivot tables to optimize content scheduling, increasing total readership by over 1,000 and follower growth by 10% •Automated content performance reports with Python scripts and visualization templates, reducing manual analytics workload by 50% and improving reporting accuracy for management reviews •Executed A/B testing on content formats, visual elements, and publishing time slots, generating a 22% improvemen in engagement rate per post and informing future content strategies

- Drafted sulfur purchase contracts and created asphalt verification checklists to support material procurement - Conducted market research on supply-demand trends, pricing and competitive landscapes of the asphalt market - Coordinated with overseas petroleum coke clients, documented meeting minutes, and outlined action plans

•Conducted quantitative market analysis on China’s personal care sector using Python and Excel to segment customer behavior, producing over 70 pages strategic report that revealed over $2 million potential growth opportunities •Evaluated Taobao digital marketing campaigns through clickstream and ROI data, building performance models that optimized budget allocation and improved ad click-through rate by 14% •Designed consumer segmentation and predictive purchase models using survey and behavioral data, which enhanced targeting precision and reduced acquisition cost by 10% •Compiled data-driven marketing reports and Power BI visualizations to present findings to senior management, accelerating decision-making processes by 25%

Joint program by Dalian University of Foreign Languages and University of Alcalá

·Nominee for Univ. Student of the Year of Liaoning Province ·Liaoning Govt. Scholarship ·Bachelor's Degree with Honors ·Outstanding Graduate Award ·1st Prize of Zhixue Scholarship