Data Analyst Manager

Kefan Yu

**** ******** ** *** ***, LIC, NY, *****

917-***-**** *****@*******.***

EDUCATION

Fordham University, Gabelli School of Business New York, NY 2016 - 2018

Master of Science, Information Systems, GPA: 3.6/4.00

• Master of Science, Information Systems, GPA: 3.6/4.00

• Financial Risk Manager (FRM) - Passed Part I & II

• CFA Level I Passed

University of Massachusetts – Boston Boston, MA 2011- 2015

Bachelor of Science, Finance and Minor in Economics, GPA: 3.73/4.00

• Bachelor of Science, Finance and Minor in Economics, GPA: 3.73/4.00

• 2015-2016 Dean’s List

• Membership in Beta Gamma Sigma

EXPERIENCE

BANK OF CHINA New York, NY 08/18- 04/20

Financial Institutions Department- AML/KYC Analyst

• Implementing several critical project actions, such as client onboarding, risk assessment, CRR & KYC governance change; review and carry out project related tasks, such as data quality review, data profiling, drafting & proof-reading procedure

communicating with RM Team and related parties (clearing department) to ensure project progress.

• Performing FID new clients onboarding and FID existing client KYC Refresh related tasks and duties (CIP, CDD, EDD, RFI and OFAC Name Screening including identifying Suspicious Activities, etc.,).

• Initiating workflows to maintain and update business data & clients’ profile (Demand Account & Sweep Account) in system and

conduct BSA/KYC review from clients’ accounts to ensure compliant with EDD and regulatory requirements.

• Conducting Ad Hoc Projects, include KYC T.O.M Project, CRR Model Project, Risk Management Project, Fenergo

Project (Client Onboarding), LexisNexis Bridger, etc.

• Liaising with RM Team, Nested Team, LCD EDD/Transaction Monitoring/Sanctions Team, escalating to BSA/KYC Officer.

• Identifying nested relationships among correspondent banking (especially high-risk clients) by using sorting Pivot Table to mitigate risk of suspicious transactions

AXA ADVISOR, LLC New York, NY 10/17 – 04/18

Financial Data Analyst

• Conducted portfolio performance reports, organized and coordinated financial planning seminars and targeted marketing

analysis programs, formulated asset maps and target maps for clients.

• Performed analysis and presented results for client’ information and investment exceptions using SQLite and Jupyter;

Assisted manager in improving work efficiency by 20%.

• Executed Excel transformed and cleaned unstructured customer data into well-structured data format, which

increased the efficiency of the sales team by 8%.

• Conducted interviews with prospective AXA candidates; led intern team of 4 in training on unique software applications and

mentored for networking with managers at events.

CHINA CINDA ASSET MANAGEMENT Co. LTD Hangzhou, China 04/16-08/16

Business Analyst

• Performed research for NPA (Non-performing Assets) and target company’s financial structure and presented report on

weekly meeting

• Collaborated with Market Research Department to conduct due diligence on NPA (Residential Real Estate, Commercial

Real Estate, Factory) and evaluated the price by using common analysis

• Built strong relationships with investors and target bank by keeping lines of communication open and having collaborative

discussions

ADDITIONAL INFORMATION

Technical Skills: Python (Pandas, Numpy, Matplotlib), SQL, R, EXCEL (Professional in Pivot Table and Financial Modeling)

Languages: Fluent English, Native Mandarin

Cortication: Coursera: Introduction to Data Science in Python

Contact this candidate