Zhenwei Yu Email & Phone Number

Hangzhou, Zhejiang, China

API Testing and Automated Testing- Developed and executed automated test scripts for API testing, ensuring robust validation of service interfacesTest Development and ToolingData Visualization Tool DevelopmentDeveloped a data visualization tool using Python, enabling test data configuration in tabular form and converting it into SQL queries. This innovation enhanced test case setup efficiency by over 20%Database Schema Comparison ToolCreated a Python-based tool for comparing table structures across different databases such as TiDB, Oracle, and MySQL. This tool ensured schema consistencyTest Analysis and Test Case Development- Test Case Design Authored and maintained over 1000+ detailed test cases based on thoroughly reviewed and approved test plans- Shift-Left Testing Implementation Pioneered shift-left testing by creating test analysis mind maps (using XMind) early in the development process, ensuring comprehensive coverage and early defect identificationTest Environment Operations- Centralized Logging System Setup Established a centralized logging system to streamline the monitoring and analysis of microservices exception logs- Environment Maintenance Managed and maintained the test environment, ensuring the smooth operation of key components and quick resolution of daily operational issuesPerformance Testing and Optimization- API Performance Testing Led the performance testing of API interfaces, constructing comprehensive performance test cases using JMeter- Stress Testing and Analysis Conducted stress tests utilizing the Perfma platform, generating detailed AWR reports to evaluate system robustness- SQL Optimization Analyzed performance reports to identify slow SQL queries, providing targeted optimization recommendations to the development team to enhance system performance

Hangzhou, Zhejiang, China

• Collected all district economy data from government website, imported to Excel worksheet• Replaced the missing data with logical weight of former time series ,deleted rows up to 3 years missing value, created new indicator for clustering• Visualized the data with Tableau, used SPSS analyzed data distribution, confirmed data veracity• Used R clustering data based on 9 indicators, supported sales department to execute precision marketing

Hangzhou, Zhejiang, China

• Connected MySQL, Redis, Linux to keep path of chain to work successfully • took charge of PHP research and online business interfaces development• Assisted with back end development for an online shopping platform, with front-end developer , defining consistent attribute name , interface name and testing mock data through back-end

Master'S Degree, Information System

Bachelor'S Degree, E-Commerce/Electronic Commerce

Activities and Societies: Vice-President Of Pop Music Club • Constantly communicated with the club advisor and club members to know.