Marcy Guo Email & Phone Number

Charlotte, NC, US

Chesterfield, Missouri, United States

• Developed a comprehensive financial model for monitoring policy lapses and Cash Surrender Values (CSV) in USD-dominated Single Premium Whole Life insurance, enhancing risk management and decision-making
• Analyzed the use of CDX/CDS overlays to optimize investment yields and manage foreign exchange risk, providing critical liability information for investment strategies
• Automated the preparation of in-force reports using VBA, significantly improving efficiency and accuracy in tracking net GAAP liabilities and managing international treaties

Los Angeles, CA

• Utilized machine learning and deep learning techniques to develop an automated approach for adjusting liquidity range to align closely with spot market price, leveraging AI predictive models and advanced machine.

Canada

• Leveraged financial models based on EBITDA and free cash flow (FCF) from all departments to project future expenses and company growth rate through Excel and VBA, enabling effective resource allocation and strategic.
• Performed research via ChatGPT to identify grants and subsidies in the North American region, increasing company’s budget allocation efficiency by achieving the government-sponsored investment totaling $50000+
• Associated with Software Development Department to collect and modify 10000+ market data for fixed asset depreciation in the aviation industry to boost the development of an integrated aviation monitoring system

United States

• Served as the Undergraduate Learning Assistant (ULA) for ECON420-Intermediate Macroeconomics, assisting Professor Addae-Ankrah.
• Held weekly office hours, providing guidance and answering students' questions.
• Actively participated in the ECON department undergraduate learning assistant program seminar, enhancing pedagogical skills applicable in diverse contexts.

Shanghai, China

• Led in-depth research on China's Internet finance industry using SWOT analysis, including product segmentation, regulatory changes, and market growth, developing adjusted company strategy after pandemic and presenting.
• Calculated various risk metrics (VaR, ES) for leading companies within the fintech industry, revalued 300+ debt, annuity, and collateral products, and assisted to construct enterprise risk management procedures in.
• Participated in development of a new risk quantification model for Internet financial products, expanding the database source for the model's internal algorithms, increasing accuracy rate by 23.5% and decreasing.

Xi'an, Shaanxi, China

• Revised maximum loan amount policy for residential housing loans based on integration of financial profiles, demographics data and credit scores, conducting thorough assessments for over 250 clients and decreasing.
• Engaged in digital transformation and advancement of financial record keeping, and drafted corporate Semiannual Compliance Letter based on internal control system and compliance with China Banking Regulatory Commission.

Master'S Degree, Econometrics And Quantitative Economics

• Relevant Coursework: Risk Analytics, Financial Modeling, Machine Learning, Financial Statement Assessment, Advanced Econometrics.

Bachelor Of Science - Bs, Statistics ; Economics, 3.96/4.00

• Honors and Leadership: Highest Distinction, Undergraduate Learning Assistant at Department of Economics • Teamwork: Carolina Women in.

Business Statistics