Risk Analyst

XIAOJIA (JESSY) CHEN

** ********* **** # ***, ********, CT 06902

e: ******@****.*** c: 203-***-****

Self-motivated, results-oriented, and data-driven fast learner. Dedicated over 2 years of analytical experiences with data analysis and visualization in finance field. CERTIFICATION & SKILLS & LANGUAGE

Certification: CFA Level II Candidate; GMAT 720

Skills: Proficient in Excel (VBA), Tableau, SAS, SQL, Bloomberg, Python, PowerPoint, Word, Outlook, Photoshop Language: Mandarin (Native), English, Spanish

WORK EXPERIENCE

KeyBank, Cleveland, OH Aug 2017 – Present

Model Risk Intern (CCAR/DFAST stress testing & PD/LGD Modeling)

• Compose SQL commands to query data from Webs Hill and clean resulted dataset to ensure external data reliability.

• Assist with data-mapping and issue-solving of large dataset (300 million) using SQL and SAS for more accurate risk modeling.

• Develop SAS macros and use backfilling to fix problematic dataset and improve data quality.

• Implement PD/LGD models and apply stress testing to support CCAR reporting.

• Perform data visualization analysis using BI tools such as Tableau to support knowledge transfer among departments.

• Review and summarize legal documentations and financial research reports for manager. Case Western Reserve University, Cleveland, OH Jan 2017 – May 2017 Reimbursement Assistant (Biomedical Department)

• Ensured budget commitment and balance precision by administrating reimbursement system in the department.

• Performed reconciliation process and conducted monthly close process to generate financial statements. Case Western Reserve University, Cleveland, OH May 2016 – Aug 2016 Budget Analyst Intern (Budget and Financial Planning Office)

• Revised monthly budget for actual expenses and assisted with yearly budget planning and forecasting report generation.

• Generated customized monthly financial statements according to various requests from different departments.

• Composed budget planning analysis to compare CWRU with over 100 other universities to optimize future budget planning.

• Identified potential trends and issues by conducting detailed CFI analysis based on ten-year financial data.

• Prepared slides to present the overall performance of CWRU based on ratio analysis to top executive. Standard Chartered Bank, Nanchang, China Aug 2013 – Sep 2013 Credit Analyst Intern

• Analyzed outstanding loans, payment history and credit reports and identified influential factors of repayment.

• Worked on a risk evaluation model to more accurately assess debtor’s financial performance based on their annual reports. EDUCATION

Case Western Reserve University (US Rank 37), Cleveland, OH Aug 2015 – May 2017

• Master of Science in Finance; GPA 3.4

• Projects

• Structure Notes Design (Based on ETF)

• Designed a VNQ Index-Linked structure note, hedging 99% percent risk in the housing market.

• Used VBA to build calculation model and to price the structure note.

• Defined and analyzed potential risks to both bank and clients and developed a user-friendly GUI tool in VBA for better presenting to clients.

• Mergers & Acquisition Analysis

• Analyzed the effect of M&A based on market abnormal return at both announcement date and completion date

• Defined the market reactions for new M&A in SAS, taking various influential factors into consideration. University of Nottingham, Ningbo, China Aug 2011 – May 2015

• International Business (Focus on Finance), Bachelor of Arts Honored Program Degree; GPA 3.8

• Exchange Student in Industrial Economics, Nottingham, UK Jan 2013 – Jul 2013 LEADERSHIP & ACTIVITIES

• AIESEC project leader Sep 2011 – Sep 2012

Contact this candidate