Ryan Liao

Bachelor's

Data Science

U S Bureau of Fiscal Service

Intern

- Fiscal Data Hub: Improving accessibility of data lake containing all fiscal related data for the federal government - Utilized DataBricks to make requests using the USASpending public API, and various other sources to analyze data, create - Created onboarding notebook to help new users learn DataBricks and Python alongside getting the data they need - Consulting other domains and offices regarding data-related activities - Data Stewards: Providing seminars and recommendations about data maturity and best practices - Data Exchanges Working Group: Improving the bureau's data exchange infrastructure by analyzing metadata and using advanced ROI & opportunity cost metrics - Analyzed data exchange metadata in Python using EDA visualizations and interactive Dash & Power BI dashboards - Classified Salesforce ticket requests automatically using NLP vectorization methods such as Doc2Vec and TF-IDF - Automated savings bonds transfer documentation for TreasuryDirect - Read, cleaned & combined text files from emails and then inserted into an access database - Projects