Xinyue Li Email & Phone Number

• Utilized SQL and Microsoft Access to manage extensive database, developing scripts to regularly monitor data and automatically generate reports, resulting in a 5% improvement in data accuracy• Identified and resolved bugs in daily operational scripts, incorporating error handling to decrease script crash rates by 30%• Managed data processing for the REDCap project, including the automation of data downloads via API and subsequent data reformatting using Pandas for consistency and… Show more • Utilized SQL and Microsoft Access to manage extensive database, developing scripts to regularly monitor data and automatically generate reports, resulting in a 5% improvement in data accuracy• Identified and resolved bugs in daily operational scripts, incorporating error handling to decrease script crash rates by 30%• Managed data processing for the REDCap project, including the automation of data downloads via API and subsequent data reformatting using Pandas for consistency and accuracy Show less

• Led innovative website development with WordPress and PHP, improving user experiences• Rewrote the homepage for enhanced user-friendliness and resolved website bugs• Maintained and updated websites, skillfully integrating SQL databases to optimize data management• Collaborated with the development team to proactively identify and fix website bugs, ensuring seamless user experiences