Data Scientist, Lifelong learner
Hello, this is Yizhuo Li. I am a life long learner Data Scientist.
This year, 2020, I will graduate from UT Austin, Information Studies program.
Hope you have fun with this website.
Want to see more? Subscribe to my Youtube Channel!
I am going to add some new features to the old web system of the Texas State Board of Pharmacy (TSBP) which makes the whole system more automatic. Currently, the TSBP will receive the orders from the wholesalers by Email or submit a specific type of file from TSBP’s unique system. However, the problem is the system now can’t automatically load the data from the uploaded file and save the data into the TWDD database. Currently, this step is finished by a technical employee. Also, although the file’s type is required, the wholesalers sometimes will not follow the requirements. So, I try to make the whole process automatic and check whether the uploaded files are in the ARCOS format. If I finish these aims, that will help the TSBP to improve their efficiency.
Project Activities and Methods
Validate files uploaded to a public server by wholesalers are in ARCOS format
Inform wholesaler of file upload status (success/fail)
Transfer files from a publicly accessible server to internal TWDD database server via FTP
Import valid files into the TWDD database.
Provide import data reporting to staff
A system schema for the automated system.
A web system builds by Larval that implements this schema.
Several user test cases of the system.
Documentation for the system.
I typically reply to all email inquiries within 24 hours.