Pivotree Data Health Dashboard Project - Student Consultant, WashU CEL• Collaboration & Communication: Worked with a 5-member team to design a Logistics Data Health Dashboard POC for client, communicated and aligned requirements to the client's Market Director and SVP, reported progresses weekly.• Data Processing & Visualization: Designed Python algorithms to map raw data, identify issues like missing, type error, duplicate in columns; displayed distributions and data health status in Tableau, allowing user configuration, highly commended by client.

• Achieved 30%+ reduction in labor hours and enhanced clarity in board presentation. Simplified production process of performance scorecards on Excel, visualized reports by creating dashboards using Tableau, effectively presenting keys from raw data of departments.• Orchestrated donor information collection initiative through surveys, to understand customer preference and conduct customer analysis.• Managed team of 5 and facilitated cross collaboration and communication with client’s interested parties like CEO and operation leaders.

• Investment System Design: Delivered customer-centered digital transformation solutions for portfolio management to 3 investment organizations. Translated client need to development team. Streamlined investment system processes and data integration, leveraging low-code platforms for efficient implementation under Agile environment using Jira. Summarized playbooks and system building specifications. • Product Promotion: Developed marketing opportunities and expanded influence by organizing public forums and press, drafting industry insights and advertorials on PwC official; Collaborated with marketing team on SEM campaign thus increasing website page view by 31%.

Created datasets on snowflake-like warehouse, built data pipelines using HiveSQL, made real-time exploratory dashboards to monitor interested indicators. Identified patterns and risks and presented thematic and ad-hoc data analysis reports to stakeholders weekly, driving actionable insights for product optimization and user experience enhancement. Designed event-tracking points on websites and used SQL to analyze data collected from the points. 1) Measured conversion rates of different campaigns by funnel analysis; 2) measured marketing platform retention rates of sellers; 3) evaluated website performance of Tiktok's marketing platform by views & clicks, and suggested aggregating some modules and reordering based on data, thus improving CTR(click-through-rate) by 25%.

1. Evaluated clients' financial statements and risks, mapped landscapes and trends of Chinese steel industry by desk research, wrote prospectus of bond offering, to raise 500 million RMB for a major energy company.2. Bid for bond issuing of 4 companies and studied bond issuing mechanism.

1. Developed algorithm of NLP project "Policy Advisor" to intelligently generate policy recommendations for governments, obtained 6,000+ policy data through Python web crawler (beautifulsoup4 package), classified and labeled policy texts by KNN & Bert supervised model, finally achieved 93% accuracy rate of solution matching.2. Embedded SQL scripts with Python to realize automation of Extract-Transform-Load process of business data into database.3. Designed, constructed and maintained databases by PostgreSQL; created new columns or tables based on business requirement.