Yuan Gu Email and Phone Number

Built up ESG model for China A shares independently. Analyzing research reports and authoritative websites both home and aboard, screened first 100 factors that has been used in mature ESG models and summarized foreign investment prederence under mature ESG models. Considering risk control and Chinese context, built ESG model on 4 positive primary indicators and 6 negative exclusive indicator with focus on Governance (G factor). Categorized the screened factors into this model frame. Completeness and practicability of the model were recognized by group leader.Dealt with data accessibility problem, under the fact that domestic disclosure rate of factors relating to ESG was below 30%. Using SQL and based on database Wind and Choice, screened 43 representative factors with full accessibility as well as fulfilled the origin, expected direction (+/-) and frequency of data resource for each factor.Cleaned up data source. Using Matlab with database Wind and Choice, complemented function codes for 15 sheets. Prepared data for industry neutralization treatment. With focus on market capitalization, profit and A share trade amount, prepared excel data after dealing with year and industry.

Dealt with basic works, collected and verified expense accounts, organized daily vouchers and prepared electric vouchers.According to relevant account information, verify the operating conditions of three subsidiaries in 2018. Prepared profit or loss summery, budget implementation summery as well as the adjusted profit or loss summery.