Youqi Lu

Deloitte-Forage Data Analysis

• Development of a Car Rental Information System, Team Leader, Information Management Lab 607, Lecturer Jingyun Tang, BISTU, 04/23, 06/23, Collaborated with the team to understand business requirements, leading to the creation of use case specifications outlining the operational processes and outcomes of each function., Designed major classes and their interrelationships based on these specifications., Engaged in interface design and the creation of use case and sequence diagrams using UML tools., Responsible for designing the database structure, defining tables and fields., Spearheaded the programming of the personal information modification page using HTML and CSS.
• Analysis and Mitigation Strategies for Disk Macro Viruses, Team Leader, Information Management Lab 607, Associate Professor Xuan Sun, BISTU, 03/23, 06/23, Played a key role in threat modeling to identify the infection pathways and destructive behaviors of disk macro viruses., Developed and planned mitigation strategies tailored to the unique characteristics of these viruses., Conducted experiments in a controlled sandbox setting to monitor virus activities., Authored detailed reports describing the lifecycle of virus infections., Provided recommendations for virus prevention.
• Comprehensive Database Design and Optimization for a Retail Management System, Team Leader, Information Management Lab 603, Associate Professor Xiaobo Wang, BISTU, 09/22, 12/22, Created an Entity-Relationship (ER) diagram focusing on entities such as products, orders, inventory, and memberships., Took charge of writing the underlying code in SQL Server., Implemented a series of data integrity checks and error handling mechanisms., Conducted extensive data queries and modifications using SQL queries during the system testing phase., Performed database performance optimization.