Machine Learning Financial Analyst

Lingyi Wu

Email Address: **********@*****.***

https://www.linkedin.com/in/lingyi-wu-a42097227/

EDUCATION

MS in Healthcare Decision Analysis University of Southern California Bachelor of Economics/Law Shandong University of Finance and Economics. SKILLS

Projects: https://github.com/MarianaWu01/lingyiwu.github.com Data Analysis Skills: Python / SQL / GitHub / VS Code / PyCharm / Colab / Google Analytics / BigQuery

/ Databricks / DBFS / Tableau / Power BI / A/B Testing / Time Series Analysis / Machine Learning / Deep Learning / NLP / EDA / Feature Engineering / Model Evaluation / Financial Engineering / SAP / Adtech

/ Martech Stack/Looker / Firebase / GA4

WORKING EXPERIENCES

Tel 213-***-****

Address: Los Angeles.CA

08/2021-05/2023

09/2014-06/2018

Financial Analyst at China&Guangfa Securities 2018-2021 2022-2023

Built an unsupervised stock recommendation system using K-means clustering and PCA to deliver personalized investment insights. Created a dynamic stock and capital pool, segmenting 30,000 clients to identify high-net-worth individuals. Enabled targeted marketing and equity recommendations based on behavioral and portfolio patterns.

Built a customer service voice automation system using Zoom’s cloud telephony integration to streamline support workflows. Collected and analyzed call logs and interaction data to identify peak inquiry times, optimize staffing schedules, and improve resolution rates. Generated dashboards to monitor call performance metrics, driving data-informed decisions in customer operations. Automated foreign exchange workflows in Excel using VBA macros and formula libraries to support stock purchases in A-shares across 167 countries. Applied VLOOKUP and XLOOKUP to streamline FX rate matching and transaction reconciliation, significantly improving the accuracy and efficiency of international investment reporting.

R&D in Gilead Science

Scraped cost data for rare diseases DLBCL and AML from clinical trial websites using BeautifulSoup,focusing on competitors like Pfizer and Bristol Myers Squibb. Analyzed cancer survival and medical expenditure data with pandas to support pricing strategies. Applied machine learning models using scikit-learn to identify pricing patterns and optimize cost-effectiveness for CAR-T therapies.

Applied natural language to processing (NLP) and topic modeling on clinical datasets, including preprocessing literature (tokenization, stemming, and stop-word removal) and feature extraction using TF-IDF. Identified the most relevant documents from EHR and IQVIA databases to support strategy development.

Developed automated data ingestion pipelines with Python and Selenium to track patient survival, relapse, and refractory conditions. Created a real time Tableau dashboard to visualize treatment outcomes, improving clinical analysis by 20%. Managed tasks and timelines using Jira and Gantt charts to ensure timely delivery of solutions.

Financial Analyst in Miniso 2023-2024

Built a KPI-driven data warehouse to track key metrics, including sales velocity, shelf-life, and inventory turnover. Optimized seasonal inventory with time-series models forecasting restocking for Thanksgiving, Black Friday, and Christmas. On January 30th, identified two batches of near-expiry goods two days in advance, enabling prompt clearance and minimizing losses. Built an automated alert system using Python + SMTP to send bulk email and SMS, get notification by webhooks. Enabled real-time logistics tracking and proactive issue notifications. Improved transparency and reduced manual follow-ups.

INTERNSHIP

China Quantitative Investment Association 2014-2018 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 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 school-level flea market for idle items.

Prepared the exhibition booth of Qilu Philately Seminar. Introduced hedge funds by lecturers and ensured the attendance of audiences. In the process of campus promotion of partner website, the company received 2000 website registrations, 8,000 likes and we got 1,3000 CNY sponsorship. HONORS &AWARDS

Second Class Scholarship in school 4 years Won the 2nd ranking in Guotai Junan Cup Simulated Stock trading Competition(500 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) Modeled and optimized transportation routes using Python (Pandas, Geopandas) cutting 10% of administrative costs while ensuring service continuity. Analyzed large-scale inventory data from SAP, automated data cleaning and reporting pipelines, and generated monthly cost-saving recommendations for senior management.

CS Lead in Esley Dunn Games(Martech) 2024-2025

Implemented real-time user acquisition tracking by linking YouTube, TikTok, LinkedIn, and Facebook to Google Analytics via SDK and Firebase. Integrated data into a CDP and stored it in BigQuery to support Martech strategies. Built a centralized website with iOS/Android download links to boost cross-platform engagement and visibility. Designed a user acquisition website using HTML/CSS and led SEO optimization at Easley-Dunn Games for indie titles Robot Race and Surpunk TD, boosting search rankings. Streamlined ad delivery via programmatic platforms and established direct purchasing channels. Automated ad buying and applied CTR-based dynamic pricing to maximize ROI and revenue. Shared game trailers on YouTube, using PGC to attract audiences for Robot Race and Surpunk TD. Tracked user behavior with Google Analytics and analyzed retention with Looker to optimize ad campaigns. Ran A/B tests and improved mobile CTR by 20% through data-driven design updates.

System Analyst in Piggy Express

Integrated UPS, FedEx, and USPS APIs for order creation, address validation, label printing, and tracking. Designed a standardized logistics layer and implemented asynchronous concurrency to boost processing efficiency and scalability. Optimized logistics tracking, reducing customer service involvement and lowering return rates by 20%.

Designed and built an ETL pipeline to collect structured and unstructured logistics data, including order information and tracking. Combined real-time and batch processing with Kafka and Spark to improve data sync and analysis. Integrated order forms with the backend system to optimize order processing and logistics operations.

Developed a price-based recommendation system using Selenium to scrape real-time data from TikTok and Temu. Integrated recommendation algorithms to provide personalized product suggestions. Implemented distributed system design for efficient real-time data processing. Enabled real-time competitor price monitoring and optimized pricing strategies. 2024-2025

Contact this candidate