Artemis Shi
Summary
Analytical CRE Credit Analyst recognized for exceptional productivity and efficient task execution. Specialized in credit risk analysis, financial modeling, and regulatory compliance. Demonstrates strong critical thinking and problem-solving abilities, facilitating effective collaboration with teams and clients Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
Overview
8
8
years of professional experience
1
1
Certification
Work History
CRE Credit Analyst
Columbia Bank
Irvine
04.2025 - Current
- Analyzed credit data to assess borrower risk and creditworthiness.
- Reviewed financial statements to determine loan eligibility and compliance.
- Assessed current economic conditions to identify trends that may impact loan portfolio performance.
- Prepare detailed credit memos and risk ratings to support approval decisions
- Identified potential problem loans or areas of risk in lending portfolios.
- Maintain accurate risk ratings and ensure adherence to internal credit policies and regulatory expectations.
Junior Commercial Loan Analyst
Strategic Property Associates, LLC
Lake Forest
10.2023 - 07.2024
- Supported the underwriting process by analyzing and verifying borrower financial documents, including income statements, tax returns, and credit reports
- Monitored ongoing compliance with loan covenants and proactively identified early warning signs of deteriorating credit quality or default risk
- Performed Debt Service Coverage Ratio (DSCR) testing, EBITDA testing, and other financial analyses as requested by clients
- Conducted in-depth industry research and market analysis to identify trends, benchmark performance, and assess risks impacting borrower repayment capacity
- Finalized credit analysis reports by investigating property performance, cash flow drivers, and potential issues affecting loan viability
Business Development Internship
8k Logistic Services
Industry
06.2021 - 09.2021
- Maintained financial reports, bank reconciliations, and relevant documentation.
- Entered and coded invoices promptly for accounts pending payment.
- Assisted department manager in processing biweekly checks.
- Researched and resolved account discrepancies efficiently.
- Analyzed e-commerce sales dataset for KPIs, including gross merchandise volume and take rate.
Data Analyst Intern
China Data & Research
北京市 朝阳区
06.2020 - 12.2020
- Conducted research on social impacts of corporations using APIs and Python, identifying candidates meeting social good criteria.
- Analyzed and evaluated client social media through natural language processing techniques.
- Utilized APIs to gather data for comprehensive assessments of corporate social responsibility.
- Evaluated potential corporate partners based on alignment with social good objectives.
Office Assistant (Internship)
California Representatives 55th District Office
Brea
09.2018 - 03.2019
- Translated documents for constituents while managing correspondence and data organization.
- Analyzed customer feedback to identify key areas for enhancement.
- Acquired relevant data from primary and secondary sources for comprehensive analysis and trending.
Education
Bachelor of Arts and Science - Mathematics and Economics
University of California-San Diego
La Jolla, CA06.2023
Skills
- QuickBooks
- Data analysis
- Power BI
- Attention to detail
- Time management
- Financial modeling
- Python
- Risk assessment
- VBA
- Quantitative analysis
- Microsoft Excel
- Financial Report Writing
- Communication skills
- Qualitative analysis
- Project management
Certification
IBM Data Analytics with Excel and R Specialization Certification
Data analytics is a strategy-based science where data is analyzed to find trends, answer questions, shape business processes, and aid decision-making. This Professional Certificate focuses on data analysis using Microsoft Excel and R programming language.
Languages
- Mandarin
Personal Information
- Willing To Relocate: Anywhere
- Authorized To Work: US for any employer
Timeline
CRE Credit Analyst
Columbia Bank
04.2025 - Current
Junior Commercial Loan Analyst
Strategic Property Associates, LLC
10.2023 - 07.2024
Business Development Internship
8k Logistic Services
06.2021 - 09.2021
Data Analyst Intern
China Data & Research
06.2020 - 12.2020
Office Assistant (Internship)
California Representatives 55th District Office
09.2018 - 03.2019
Bachelor of Arts and Science - Mathematics and Economics
University of California-San Diego