Songnan Lu Email & Phone Number

Shanghai, China

-Electrical and New Energy

Shanghai, China

Shanghai, China

• Independently prepared for research on macro environment and consumer behavior in more than 10 overseas countries, producing a 30-page macro report on Africa, covering 3 sub-sectors of tools, games and live streaming• Conduct comparative research and marketing strategy analysis of competing products, collate and analyze about 10,000+ historical data from more than 10 overseas countries (using pivot table)

Beijing, China

•Researched on asset allocation models including MVO, Risk Parity, Yale model, etc. And through the retrieval and classification of asset return impact factors, assisted the mentor in completing the research report “super asset allocation”Composed market liquidity report using SQL and Python to retrieve time series data since July of 2019 from financial information terminals like Wind and Choice, and drew graphs and charts with Tableau•Respectively analyzed and evaluated the asset allocation plans (all-share, all-debt, and equity 5:5 allocations) under three different time series to obtain the optimal asset allocation plan. And calculated sharpe ratio, annualized rate, and maximum drawdown through Python libs (Numpy, Pandas, Matplotlib, Spciy)•Selected six variables from the categories of economic development, interest rate, CPI, money policy, overseas markets to build a multivariate regression model with which I predicted Shanghai Stock Exchange Composite Index•Conducted quantitative analysis on six target stocks and provided the illustrated report with customized optimal investment strategy. The work consists of data collection and cleansing, descriptive statistics, correlation, average, and profit-risk analysis

Shenzhen, Guangdong, China

•Retrieved credit default data from Bloomberg using Python programming and SQL, and conducted risk analysis of financial derivatives like interest-rate swaps by calculating VAR through Monte-Carlo Simulation•Produced risk assessment reports with data visualization by running function simulation analysis in Matlab based on the collected dataComposed the summary report “Credit Default Risk Analysis of 5 Cyclical Industries with Overcapacity” by identifying 3 main causes of default and comparing domestic default level with that of other countries•Improved the company's credit rating model with constraints added and evaluation process optimized through the research on the credit risk decision model scoring mechanism, combining with the statistical analysis of the key influencing factors in recent credit incident cases

•Provided counseling for clients’ inquiries regarding deposits, loans, and wealth management.•Assisted with loan applications, customer background investigation and independently completed the credit investigation report as part of company's financial status analysis.

Wuhan, Hubei, China

•Provided counseling for clients’ problems regarding deposits, loans, and wealth management•Assisted with loan applications, customer background investigation and independently completed the credit investigation report as part of company's financial status analysis

Master Of Science, Msc Finance, 4.0

Bachelor'S Degree, Finance, 3.92

Activities and Societies: Vice Minister of Propaganda Department in the Student Union ‘University Level Outstanding Student Leader.