Data Developer

Zifan Xu

***********@*****.*** 347-***-**** ** River Rd, New York, NY 10044

SUMMARY

• Experienced in planning and managing financial instruments, handling relationships with public companies and operating commercial loans

• Expert in insights extraction, analysis, visualization and presentation from data through both machine learning and business perspectives, knowledgeable in analyzing financial market data and data analytical tools

• A curious, persistent and positive learner, able to work with large scale dataset in different areas and absorbing new skills EXPERIENCE

BANK OF NINGBO, Shenzhen, China

Loan Specialist, Corporate Finance Department JUL 2013 – JUL 2015

• Collected different types of relevant data to the revenues and profits of the target company, executed the data integration and data analysis to analyze how the factors influence the profits, then determine whether to cooperate with the company

• Maintained stock credit customers, included writing annual credit investigation reports, dealing with international business

• Handled businesses like real estate loans, entrustment loans, asset trusteeship and discounts; developed new clients; took charge of departmental clerical work

• Independently managed sequel credit customers and credit loans; processed brand new businesses: capital recording and entrustment loans of overseas loan under domestic guarantee Intern, Corporate Finance Department MAR 2013 – JUN 2013

• Created credit investigation reports of financial companies, mastered the principles and procedures of business

• Took charge of assisting loan specialist to handle bank acceptance bill discount and Learned banking systems ACADEMIC PROJECT

Lending Club Loans Analysis MAY 2018 – PRESENT

• Use Python to do data preprocessing, data transformation based on real world dataset of lending club

• Create data visualization graphs through Python and Excel, analyze each feature which influences loan default risk

• Build logistic regression and random forest modeling to get the business decision which can avoid high default risk

• Combine all steps together to develop a presentation from business perspective to deliver the result and solutions Database Development NOV 2017 – DEC 2013

• Design a relational database about luxury wine company in Oracle SQL Developer

• Joined the connections between tables by SQL to get the different correlation of every feature in database SKILLS

ALGORITHMS: Logistic Regression, Decision Tree, Random Forests, Support Vector Machine, Naïve Bayes PROGRAMMING: Python (Numpy, Pandas, Matplotlib, Scikit-Learn, Regular Expression), R (dplyr), HTML, CSS TOOLS: Bloomberg Terminal, Excel, Word, PowerPoint SQL: MySQL, MS. SQL Server, Oracle SQL Developer, MongoDB VISUALIZATION: Python (Plotly, Seaborn, Matplotlib), R (ggplot2), Tableau LANGUAGE: English (Fluent), Mandarin (Native)

EDUCATION

NEW YORK UNIVERSITY SEP 2017 – MAY 2019

Master of Science in Management and Systems (STEM) GPA: 3.8

• Degree focus: Quantitative Financial Modeling, Financial Management, Data Mining and Design QINGDAO UNIVERSITY OF TECHNOLOGY SEP 2009 – JUL 2013 Bachelor of Science in Information and Computing Science GPA: 3.7 (Major)

• Degree focus: Mathematical Analysis, Applied Statistics INTERESTS

Travelling, Workout, Reading, Playing the piano, Singing

Contact this candidate