Derek Li Email & Phone Number

Shanghai, China

• Implemented the frontend and backend of a document-grounded conversational question answering system
• Collaborated on building Django REST web APIs to facilitate file upload, parsing and download services
• Enhanced OpenAI ChatGPT with LangChain and Qdrant vector database to deliver accurate answersbased on the provided documents, improving response accuracy by 50%.
• Used NextJS with Redux Toolkit for user-friendly frontend design and state management

Columbus, Ohio, United States

• Developed an Angular web app to provide view and edit access to a cloud database, in Agile development
• Integrated a Postgres database system into the user interface for up-to-date data and local operations, withadditional features of local file parsing and local data validation
• Implemented two Python APIs to pipeline data cleaning and validation processes, facilitating the retrievaland upload of data across more than 10 tables for the merchandise planning team
• Reduced data update time from 20 to 5 minutes by optimizing workflow, achieving a 75% efficiency boost

Columbus, Ohio, United States

• Assisted instructor in weekly lab sections and conducted office hours to answer students’ questions
• Reviewed and graded weekly projects with insightful feedbacks for both students and instructors

Shenzhen, Guangdong, China

• Utilized PowerBI for data preprocessing, table integration, and visualization, to provide a forecast report of15 raw materials in the next year for the sourcing team to track and modulate future orders
• Created a Python script to download and preprocess company reports for integration into PowerBI
• Delivered a weekly-updated automatic solution for demand forecast, with an error rate below 20%

Master Of Engineering - Meng, Computer Science, 4.0

Bachelor'S Degree, Computer And Information Sciences, General, 3.9