Word, PowerPoint, Excel, Power BI, SQL, Tableau, STATA, R, Python

JINGWEI GUO

**** ******* **, ** *****, CA ***** Apartment L 858-***-**** ******@****.***

EDUCATION

University of California San Diego San Diego, US Expected August 2025 Bachelor in Management Science (Economics, Finance, Operations Research), Computational Social Science Minor GPA 3.7/4.0

Relevant Coursework: Business Analytics (Excel, SQL, Tableau), Advanced Machine Learning Algorithms, Corporate Finance

PROFESSIONAL EXPERIENCE

The Venetian Resort Las Vegas Las Vegas, U.S.

Strategy and Financial Planning & Analysis Intern Jun– Aug 2024

• Prompt Engineering: Collaborated effectively with ChatGPT4o and the FP&A team for reporting process automation. Clearly understood the needs of the team and experimented with ChatGPT4o for possible ways of programming in Python.

• Financial Data Anomaly Detection Automation: Automated anomaly detection for 30 revenue centers' financial data, replacing manual Excel Pivot Table checks. Developed a Python-based system integrated with Microsoft SQL Server via pyodbc to efficiently remove outliers and calculate percentile thresholds, reducing anomaly detection time by more than 95%.

• Calendar Update Automation: Automated the manual ETL process for the Financial Daily Operating Report's event calendar. Developed a Python-based system integrated with Microsoft Outlook and Excel via pywin32 to automatically download and filter email attachments, extract event and group data from four different Excel structures, and update the master file. Reduced the calendar update process by more than 95%.

KPMG Corporate Advisory Shanghai, China

General Risk and Strategy Consulting (Life Science) Intern Aug – Nov 2023

• Market Access: Facilitated three OTC drug registrations of a Global 500 multinational pharmaceutical company in the Chinese market; Conducted comprehensive secondary research across five countries, encompassing treatment recommendations, certified similar drugs, academic articles, and more, to establish the global safety and efficacy status of the drugs.

• Biomedical Policy Analysis: Advised the company's internal government affairs team in analyzing China’s policy trends; Researched priority policies in China's Fourteenth Five-Year Plan for 21 Free-Trade Zones, emphasizing advanced technology, pharmaceutical import, approval processes, and cross-border data sharing.

• Innovative Drug Valuation: Supported a biotech startup specializing in first-in-line solid tumor U-CART treatment with a $30 million financing round with a business plan. Contributed to r-NPV valuation models for two pipelines by researching market size factors (prevalence, relapse rates, protein positivity) and projecting 15-year revenues across nine cancer indications. Mercer Consulting Shanghai, China

Survey Data Analysis Project Intern Jun - Aug 2023

• Project Scope: Assisted in developing Mercer's biannual China Corporate Learning and Development Trends report.

• Data Exploration: Processed and explored the survey data (400+ sample size) for each of the 60 survey questions on Excel.

• Cross Analysis & Data Visualization: Cross-analyzed data using Excel functions (VLOOKUP, IFS, etc.) and pivot tables; developed interactive, linkable dashboards using graphs like stacked bar charts, radar charts, composite pie charts, and slicers.

• Report Writing & Deliverable Design: Generated data insights “significantly more firms have implemented AI-supported learning.” Wrote and designed the data version report (40 pages) using Mercer standard delivery suite and color panel.

PROJECT EXPERIENCE

Capital One x CFA Case Competition April 2023

Led a Team to participated in 2023 Consult for America (CFA) Business Case Competition sponsored by Capital One

• Problem Diagnosis & ESG Solutions Development: Researched Capital One's business lines, analyzed 10K and sustainability reports, and proposed innovative eco-friendly solutions to encourage clients towards sustainability.

• ESG Solutions Impact Analysis: Defined key metrics such as CO2 emissions and footprint records to assess the potential impacts of the proposed solutions; Evaluated the solutions based on these metrics, considering factors such as expenses, time requirements, and overall impact; Presented the solutions in a quadrant format for easy comparison.

• Deliverable Design: Appraised by Capital One analysts through a professional stand-alone presentation deliverable (20 pages). ECON 112 Final Project: Empirical Investigation of Monetary Policy Impact on Illinois' Economy August 2024

• Research Question: Investigated how changes in the Federal Funds Rate impact Illinois' Real GDP and Unemployment Rate.

• Methodology: Utilized quarterly data from 1997 to 2022 and employed a Vector Autoregression (VAR) model to assess the dynamic impact of monetary policy shocks. Conducted Granger causality tests to evaluate variables’ predictive relationships.

• Key Findings: Increased Federal Funds Rate has a short-term contractionary effect on Illinois' economy, causing a temporary GDP drop and unemployment rise, with effects diminishing over time.

ADDITIONAL INFORMATION

Language: English (Professional Proficient), Mandarin (Native) Computer: Word, PowerPoint, Excel, Power BI (Microsoft Certified Data Analyst Associate), SQL, Tableau, STATA, R, Python Certificates: Bloomberg Market Concept Certificate, Bloomberg Environmental Social Governance Course Certificate

Contact this candidate