Lingyi Wu

Email Address:ad4z3l@r.postjobfree.com. Tel 213-***-****

www.linkedin.com/in/lingyi-wu-a42097227 Address: Los Angeles.CA EDUCATION

MS in Healthcare Decision Analysis University of Southern California 08/2021-05/2023 Bachelor of Economics/Law Shandong University of Finance and Economics. 09/2015-06/2018 SKILLS

Projects: https://github.com/MarianaWu01/lingyiwu.github.com Programming:Spark/Python(sklearn,pandas,numpy)/SQL/AWS/R/SAS/Matlab/Eviews/Tableau Data Analysis Skills:Github/Databricks/NLP//Kafka/AB testing/AR model/Time Series Analysis/Deep Learning/HDFS system/Scala/Exploratory Data Analysis/Hypothesis Testing/Feature Engineering/Model Evaluation/ Tensorflow/Database/Machine Learning/Probability and Statistics/Arch Model/Data Visualization/Big Data/Apache Spark Financial engineering/Financial calculations/MapReduce/Headoop Working Experience

Data Analyst at Miniso 09/2023-03/2024

R&D in Gilead Science 08/2022-12/2022

Financial Abalyst at Guangfa Securities 09/2018-05/2020 Managed the transportation costs effectively and help the company make logistics budget plans. Monitored the costs and capacity of third-party warehouses to ensure efficient operations. Oversaw the costs of third-party transportation companies, allocated logistics expenses reasonably Monitored operational risks within the company effectively, overseeing potential issues within third-party entities. On January 30th, identified two batches of perishable food issues and reported potential risks two days in advance. Through meticulous data analysis, promptly alerted and reported these risks, enabling the company to proactively avoid potential losses.

Designed optimal transportation routes, resulting in a 15% reduction in costs and ensuring reliable deliveries and yielding significant financial benefits. Developed comprehensive transportation route maps for North America, enhancing logistics optimization and improving supply chain operations. Assessed the insurance coverage of participants in clinical treatment utilizing CAR-T therapy for rare diseases DLBCL and AML. We ensured that individuals had adequate coverage for potential medical expenses incurred during the treatment, effectively covering the expenses associated with cancer therapy. Through these efforts, we guaranteed the continuity of treatment for patients.

Extracted information related to insurance coverage and risk management strategies mentioned in clinical literature, ensuring alignment with insurance policies.Considered insurance coverage and potential reimbursement scenarios in predicting treatment outcomes, ensuring financial feasibility for patients and improving the quality and accuracy of PRO surveys.

Analyzed insurance claims data to identify potential coverage gaps and optimize insurance plans for CAR-T therapy, aiming to minimize financial burden on patients, increase cost-effectiveness, and maximize patient survival outcomes. This ensures that patients receive timely and effective treatment in case of recurrence. Extracted data from Wind Financial Terminal into Python for cleaning, processing, mining. Analyzed the volatility feature of stock price and market index and drove key investment decisions via predicting the stock price with time-series modeling.Wrote reports for China Citic Bank regularly. Analyzed earnings data in stock pools and help customers to find the best buying price and selling price according to the historical trading price. Generated real-time dashboards using Wind which helped automatically compare 20+ financial indicators of 100 target stocks in financial and medical sectors. Help customers make smarter buying and selling decisions Designed reports analyzing valuation metrics and stock performance of public technology companies. Develop scalable Tableau dashboards and data ETL pipelines to track key valuation metrics to help identify the potential risks that should Financial Analyst at Shanghai Pudong Development Bank 10/2016-02/2017 RESEARCH EXPERIENCES

Tech worker in USC 08/2022-12/2022

China Quantitative Investment Association 10/2014-06/2018 HONORS & AWARDS

pay attention to and closely monitoring key performance metrics. Figure out the key metrics that could help with the success of investment

Conducted Bank Customer Churn Prediction. Trained supervised machine learning models including Logistic Regression,Random Forest and K-Nearest Nieghbors to identify customers who are likely to churn in the future and applied regularization with optimal parameters to overcome overfitting. Utilized Random forest and sklearn to train the model and find optimal hyperparameters.

Utilized unsupervised models to make fraud detection. Increased the accuracy of credit card fraud detection from 25% to 40%.Tuned 60 hyper-parameters to achieve the best model accuracy by maximizing the AUC and related statistics. Help to allocate Bank’s Allowance for Loan and Lease Loss more precisely. Built product sale forecasts model in Python to optimize commercial marketing channels and identified key factors for improving sales performance. using CRM to gather and updated customer data in the bank systems. Promoted the credit card and financial products and succeed in selling 70,000 CNY financial products. Designed a student information inquiry system. Monitored scholarship coverage of USC Atheletes and effectively solve the situation that athletes cannot continue their studies due to financial hold on their accounts at the beginning of each semester.

Utilized VBA, Excel, and SQL to ensure all USC athletes maintained proper insurance coverage, a process involving the implementation of suitable insurance programs and solutions, updating the insurance plan regularly and encouraging athletes to utilize insurance responsibly post-injury. Reduced the financial burden on athletes' families when athletes get injuries during sports activities.

Analylized historical data of USC football matches by using pandas. Classified the historical achievements of star athletes and used visualization tools such as plot to make graphs for athlete promotion on the Instagram and on the schools management platform.

Promoted the electronic products of the sponsor through posters and marketing campaigns. Made resource connection with Credit Ease, Yong 'an Futures, Blue Devil Digital, Wahaha, Three people's Teahouse, Yunlong Bookstore and other enterprises and established a good cooperative relationship. Made business plans and development strategies for companies. Organized and solicit sponsorship to support campus financial knowledge contest, evening welcome parties, campus singer contest and other school-level events, completed the writing of enterprise plans and organized a junk sale to help idle items get better use. Prepared the exhibition booth of Qilu Philately Seminar. Introduced hedge funds to junior students, promoted lecturers and ensured the attendance of audiences. In the process of campus promotion of partner website, the company received 800 website registrations, 8,000 likes and we got 1,3000 CNY sponsorship. Certificate of Data Engineerng https://laioffer.com/zh/certificates/?id=DS2208042223012034 Second Class Scholarship in school 4 years

Won the 2nd ranking in Guotai Junan Cup Simulated Stock trading Competition(300 participants) Secretary of Jinshi Friendship Reading Club

Gold Medal in the 8th World Chinese Youth Art Festival Guzheng Competition (junior group) Gold Award in 8th China Youth Art Talent National Guzheng Competition Gold Award in 7th group China Youth Art Talent National Guzheng Team Competition National Guzheng (a traditional Chinese instrument) Examination (Band 10) https://m.uhomes.com/liveplayback/106107xcode=000cb24b8372d6d995e2&share_id=261496&app_id=11&sharetag=mo ments&language=zh&invite_code=BWMHPFFnBjdUaAM6

Outstanding Volunteer certificate of Southwest Hospital in China