J

Juncheng Ke

About

Detail

Utah, United States

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Sallie Mae
    Senior Associate, Internal Audit, Data Analytics
    Sallie Mae
    Jul 2024 - Current (2 years 3 months)
    Built and maintained continuous monitoring reports using SQL and Python, including an employee history dataset and monthly reporting for the audit committee. Created a Tableau dashboard for key audit metrics by pulling, cleaning, and combining data from multiple sources, helping the team spot trends more easily. Used SQL and Python to support audits with descriptive and diagnostic analytics, and developed simple prescriptive models to flag areas that needed review. Worked with audit teams, business partners, and external groups to make sure analytics were delivered accurately and on time for each project.
  • American Express
    Analyst-Risk & Information Management
    American Express
    Aug 2022 - Jul 2024 (2 years)
    Served as a second line of defense within Commercial Credit Risk Oversight, partnering with first line Commercial Rating and Underwriting teams to review and troubleshoot material credit concerns and support consistent credit decision making. Rebuilt manual Excel processes into SQL-based rules, improving processing speed by 60% and reducing errors in the commercial rating challenge workflow. Reviewed financials and credit analyses to support monthly commercial rating challenges, helping improve accuracy in the credit rating process. Used SQL to analyze portfolio and industry-level risk trends, identifying early signs of potential credit issues.
  • S
    Credit Analyst
    Sunwest Bank
    Sep 2021 - Aug 2022 (1 year)
    Conducted comprehensive financial statement and debt service analyses to underwrite commercial credit requests using business and personal financial statements and tax returns, informing credit decisions. Developed financial models and credit analyses to support underwriting for loan originations and renewals. Collaborated cross-functionally with Portfolio Managers, Relationship Managers, Legal Counsel, and external parties to support the underwriting, monitoring, and servicing of multimillion-dollar accounts within the Utah deal portfolio. Identified and clearly articulated market and structural risks and their mitigants, contributing to proactive risk management and financial forecasting.
Education verified_user 0% verified
  • U
    Master of Science in Business Analytics
    University of Utah--David Eccles School of Business
    Jan 2022
    GPA: 3.7
  • W
    Bachelor of Science
    Weber State University--Goddard School of Business & Economics
    Jan 2020
    Major: Business Administration and Marketing, GPA: 3.6