Yingfan Zhang
Boston,MA
Summary
Business and data analyst with 6 years of experience in financial industry. Expertise in analysis and testing of business requirements to drive deployment of applications, business processes and system solutions.
Overview
1
1
Certification
5
5
years of post-secondary education
6
6
years of professional experience
Work History
Data Analyst Programming Specialist Intern
GTSP
Santa Clara, CA
12.2020 - Current
- Conducted marketing analysis to target clients from social media, find out the needs and search for our matching product.
- Built client relationship with social media, increased customer engagement and improved the sales performance.
- Developed market analysis report dashboard for direct leader and created process flowchart to manage the marketing activities.
Vice President
Chinese Students Community Boston University
01.2020 - 05.2020
- Designed and hosted the Spring Festival Event, made the guest list and invitation cards, checked RSVPs and responded to questions from the students and guests.
Business Analyst
China Construction Bank
Xi'an, Shaanxi
12.2014 - 02.2018
- Developed a comprehensive market research report with Excel on the current financial products of clients and conducted data visualization and summarized the data to compare financial benefits between clients current products and team recommended products; reach 47% of acceptance rate on recommendation products.
- Conducted data analysis using time series model (Moving Average) to identify revenue and cost trends, predicted profits and risks of loans and created 5 large-scale loan project plans, including the Qujiang New District Cultural Tourism Project Centralized Loan Project (worth $5 million), which became the core project of the bank.
- Optimized financial product combinations to bid on the government loan projects, worked closely with sales department and got the Government Debt Centralized Declaration Project ($200 million) for the bank.
Product Manager
China Construction Bank
Xi'an, China
07.2012 - 12.2014
- Built regression models using R to optimize the usage of financial products and visualized the results to give suggestions to the customers.
- Gained 74 business clients for the bank.
- Designed product combination to balance the benefit and cost of customers, finished 200% of the task in 2014, and was awarded the honorable title of “Marketing Expert”.
Education
Master of Science - Applied Business Analytics
Boston University
Boston, MA 08.2019 - 09.2020
Bachelor of Science - Marketing
Nanchang University
Nanchang, China 09.2008 - 06.2012
Skills
R
Adobe Premiere
SQL
FinanceMarketing analysisMicrosoft Excel
MinitabPythonRisk analysisSix SigmaTableau
Certification
Six Sigma Green Belt Certification
Projects
“North End Bar Microbrewery Investment Report” Boston University Aug.2019
- Analyzed the feasibility in five aspects, including marketing, innovation, operation management, finance and human resources.
- Led financial analyst and used break-even analysis, risk analysis and decision tree model to analyze the situation with Excel Solver.
“CDC and South Bank of Texas Managerial Report” Boston University Jun.2020
- Applied the decision tree model to analyze the estimated benefits and costs under 3 different circumstances
- Analyzed the risk probability to compare the growth of risks and revenues of different interest rates. (R and python)
- Completed the whole process of business understanding, problem framing, data cleaning, feature engineering, modeling, evaluation and make recommendations.
Timeline
Data Analyst Programming Specialist Intern
GTSP
12.2020 - Current
Six Sigma Green Belt Certification
04-2020
Vice President
Chinese Students Community Boston University
01.2020 - 05.2020
Master of Science - Applied Business Analytics
Boston University
08.2019 - 09.2020
Business Analyst
China Construction Bank
12.2014 - 02.2018
Product Manager
China Construction Bank
07.2012 - 12.2014
Bachelor of Science - Marketing
Nanchang University
09.2008 - 06.2012