Summary
Overview
Work History
Education
Project Experience
Skills And Expertise
Timeline
Generic

Menglu(Kalinda) Zhang

Summary

Columbia University Risk Management graduate with comprehensive experiences in risk analysis and financial forecasting. Skilled in rapidly acquiring new knowledge and applying it effectively. Driven by a passion for continuous learning and successfully navigating change.

Seeking to leverage analytical skills to drive risk management initiatives in a forward-thinking organization.

Overview

4
4
years of professional experience

Work History

Risk Analyst

Joblogic-X Corporation
New York, USA
08.2024 - Current
  • Conducted loan default analysis for a lending bank, identifying key risk indicators, and improving credit risk evaluation accuracy by 15% through SQL data integration and pattern recognition.
  • Built comprehensive business tables to enhance pre-loan assessments, reducing default risk by 10%, and improving decision-making efficiency.
  • Visualized risk trends and predictors using Tableau, presenting findings to senior management to support strategic risk mitigation strategies.
  • Automated data processing workflows using Python reduce manual data entry time by 30%, leading to faster and more informed decision-making.

Financial Analyst & Payroll

Grand Kempinski Hotel
Shanghai, China
02.2021 - 06.2023
  • Managed payroll processing for 500+ employees, including annual bonuses, handling an average monthly payroll of CNY 4 million, ensuring 100% accuracy in pre-income tax declarations, and compliance with regulatory requirements.
  • Forecasted financial income and risks for the global chain hotel using advanced Excel models, improving budget accuracy by 20%, and supporting strategic financial planning.
  • Conducted risk assessments based on financial data and market trends, identifying potential risks, and proposing mitigation strategies that reduced operational risks by 15%.
  • Supported internal and external audits by preparing detailed financial reports, ensuring compliance with the Uniform System of Accounts for the Lodging Industry (USALI), and improving audit efficiency by 25%.

Education

Master of Science - Enterprise Risk Management

Columbia University
New York, NY
12.2024

B.A - Hospitality Business Management, Bachelor of International Business in Hospitality Business Management

Washington State University & César Ritz Colleges Switzerland
Brig, Switzerland
12.2020

Project Experience

Wholesale PD Model Development

  • Developed a Probability of Default (PD) model using financial data from the FRB and FDIC, creating key financial ratios and integrating default data using Python (Pandas, Statsmodels, Scikit-learn).
  • Conducted single and multi-factor analysis using logistic regression, achieving an AUC score of 0.85, and identified top predictive models for loan default risk.
  • Evaluated model predictions on cases like Silicon Valley Bank and Signature Bank, proposing actionable improvements that enhanced model accuracy by 10%.
  • Led a cross-functional team of 5 during the risk assessment project, improving collaboration and delivering results 20% ahead of schedule.

Skills And Expertise

  • Skills: SQL, Microsoft (Excel, Word, PowerPoint), Tableau, Python
  • Certificates: Google Data Analytics Certificate, First Aid CPR AED

Timeline

Risk Analyst

Joblogic-X Corporation
08.2024 - Current

Financial Analyst & Payroll

Grand Kempinski Hotel
02.2021 - 06.2023

Master of Science - Enterprise Risk Management

Columbia University

B.A - Hospitality Business Management, Bachelor of International Business in Hospitality Business Management

Washington State University & César Ritz Colleges Switzerland
Menglu(Kalinda) Zhang