Yuqian (Miranda) Ding

Teaching Assistant for SIPA U6401 Macroeconomic Analysis

Teaching Assistant for SIPA U6400 Microeconomic Analysis

• Supported the global-scale ESG integration project, contributing proactively in methodology mapping and ESG scoring: - Methodology Mapping: Improved the robustness of excel mapping model, cooperated with London team, and mapped 20000+ transactions globally in three weeks. - ESG Scoring: Independently reviewed and commented 240 legacy deals, and supported the rating of 34 post-crisis deals. • Reviewed and checked the credit enhancement of 190+ tranches in the internal system, improving the accuracy of the database. • Self-learned full-time analysts’ training, building cash flow waterfall model and running RMBS model for Prime Jumbos.

• Co-led the financing project of a plant-based food brand, took charge of producing business plans, teasers, memos and maintained communication with the founder and investors through face-to-face and virtual calls. • Completed four 3000-word plus memos on four companies in the consumer sector, covering the investment thesis, industry overview, competition landscape, business model, operating performance and competitive analysis. • Produced the operating forecasts and COMP models for 3 companies in the consumer sector. • Initiated 10 plus conference calls with investors and completed memos to evaluate the potential transaction. • Completed industry mappings covering the supply chains of baking, alcohol beverages, offline dining and pre-made dishes.

• Completed 15 DCF models for tech companies in the semiconductor and PCB industry, covering both listed and unlisted. • Interviewed industry experts and corporate management, and gathered information for producing financial models. • Performed desk researches into the semiconductor and PCB industries. • Attended corporate conference calls and produced meeting minutes.

• Independently produced a 30-page research report on a US car-hailing company and pitched the company within the group. • Assisted in arranging for analyst roadshows, corporate conference calls, and other industry expert calls. • Sent thousands of invitations to registered clients with no errors. • Produced market summary and daily report.

• Produced the working papers of fixed and intangible assets, conducted reasonable tests, and completed the client's credit review. • Liaised with more than 100 colleagues across the world, collected and translated more than 200 copies of resumes and materials involved in an audit rotation bidding project. • Prepared, sorted, and filed audit papers, audit reports, and other relevant materials on time.

• Built and updated the DCF models of several companies listed in Shanghai and Hong Kong. • Evaluated the prospect of a domestic brand with a benchmark analysis in the 4P framework. • Produced daily reports on market transactions, industry news and disclosures of company under coverage. • Maintained two databases, updated the online and offline sales and consumer preference on a weekly basis.

Concentration on International Finance Specialization in Data Analytics &​ Quantitative Analysis STEM-Designated Program