Zhenyu Wang Email and Phone Number

1.Implemented and managed end-to-end data storage for customers, optimized the test process with MySQL and MongoDB, and improved the efficiency of the management system. Created visual dashboards with Tableau for daily information tracking and data filtering.2.Perform data processing by extracting, transforming, and loading data (ETL) from a variety of data sources such as Excel, Flat File, Oracle, and MySQL to assist in data-driven business decisions and provide feasibility reporting and analysis support to management.

1. Project Leadership: Managed a team of 9 in an ESG evaluation project, coordinatized the creation of quantitative and machine learning models including (NLP, K-Means, PCA, Ridge, Lasso, Linear Model) to evaluate a client’s sustainability progress, which led to a three-year operational plan with revised targets and strategies, all under a stringent deadline in 4 months.2. Language Model: Implemented Python NLP models for sustainability analysis in client documents using Named Entity Recognition, transformed evaluation results into numerical format with TFIDF, and presented ESG key metrics through heat-maping for enhanced operational plan monitoring.

1. Daily Transaction Management: I was responsible for overseeing the daily transactions of the company. This included collecting and analyzing transaction data to identify trends and patterns that informed our trading strategies for the following trading day. Notably, I consistently managed an average daily transaction volume exceeding $1.5 million, ensuring the efficient execution of trades.2. Asset Monitoring and Risk Management: I closely monitored the company's extensive assets, which exceeded $4 billion in value. My role involved accumulating and analyzing data on the ratio of assets to liabilities within our investment portfolio. This data played a crucial role in our risk management efforts, as it allowed us to proactively identify and mitigate potential risks. By doing so, we successfully reduced the risk of our products violating regulatory standards, enhancing the company's compliance and stability.3. Product Risk Control: I leveraged a combination of Excel and Python to calculate the net value of our various investment products and establish product risk control thresholds. To bolster our risk management capabilities, I implemented automated warnings for products that fell below these risk control thresholds. This proactive approach enabled us to swiftly adjust our positions to minimize risk exposure and protect our investments.4. Data Automation: I took the initiative to import the latest stock industry data categories and gathered position data for the company's various products using Python. This data allowed us to categorize and match our stock holdings with the relevant industry sectors, providing a clear and insightful view for our customers. This automation significantly improved efficiency, reducing the need for manual work by an impressive 70%.

1.Financial Data Collection: Throughout the internship, I was entrusted with the critical task of collecting and aggregating financial data from diverse sources. This required meticulous attention to detail to ensure the accuracy and completeness of the data.2.Construction of Financial Position and Risk Reports: A core aspect of my role involved actively participating in the construction of financial position and risk reports. These reports were instrumental in guiding the company's strategic decision-making processes and risk management strategies.3.Data Integration and Review: To maintain data integrity, I played a key role in integrating and reviewing financial data. This process involved cross-referencing data points to guarantee their reliability and relevance.4.Data Processing and Visualization : I took the lead in processing and summarizing the amassed financial data to create comprehensive financial position and risk reports. These reports provided vital insights into the company's financial health and highlighted potential areas of risk.5.Accounts Reconciliation: I also contributed to the execution of accounts reconciliation activities when necessary. This task demanded precision and an acute understanding of financial records to ensure the company's financial reporting accuracy.6.Identification of Operational Improvements: Proactively identifying areas for operational enhancements was an essential part of my role. I conducted in-depth research on cost structures, delved into market trends, and studied potential business opportunities and investments. These efforts aimed to empower the company to optimize its financial operations and enhance overall efficiency.