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