· Designed and implemented various data visualizations in Tableau, including mapping, area charts, and line charts; developed interactive dashboards that improved report clarity by 40%· Assisted UIUC DMI department in producing charts, including enrollment growth, retention rates. Analyzed international student distribution to identify key demographic trends and impact on campus diversity

· Analyze and calculate raw 100+ data and analyze for significance tests using DID, RCT, and mean difference tests. · Create appropriate charts and graphs, search 10+ literature to provide information to complete research experiments

· Quickly learned FormBuilder to help NGO I-PAWS improve business processes. Earned 6 certificates in Linkedin BPI program. · Redefined dog activity recording process by incorporating 12 triggers and 4 security groups for stage transition · Streamlined expense reimbursement process, reducing form filling time by 60%

· Manipulate sales data from Jan. to Jun. 2024 (6000 data points) using Quick BI and update 25 dashboards · Perform ad hoc reporting and analysis involving subquery and join using SQL to aid sales channel expansion · Initiate smart contract redundancy detection using SQL, which enables the automated reminder, reduce managers' review time by 30%

· Proactively reached out to 6 UIUC graduates, reached partnership with 7 tier-one universities’ entrepreneurship clubs via them, interviewed the most entrepreneurs per week among the interns , filtered out 30 projects, 3 of them gained approval, drawing the company’s investment of 6 million+ RMB Discovered and partnered with 30+ projects in the U.S. college startup community to accelerate startup incubation.

· Analyzed 10+ typical products and competitive landscape, discovered an exception to the general sales trend for 2023 Q1, drafted an in-depth report · Organize weekly meetings with 4 members of the team to develop weekly research proposals and submit reports to

· Built industry research framework adopted by the company and performed intensive and targeted candidate search · Worked with MBB, Big 4 consulting, market research firms, etc., to interview 200+ industry experts to derive expert insights . · Assisted team in completing 50 + projects, overachieving the monthly target by 15% and won a renewed internship contract

· Performed market analysis using 180+ questionnaires and used the insights to conduct customer profiling and positioning · Conducted competitive analysis, developed a new business channel by partnering with 3 student unions, bringing in 6000+ perspectives