{"id":8,"date":"2022-01-26T23:23:20","date_gmt":"2022-01-26T23:23:20","guid":{"rendered":"https:\/\/blogs.oregonstate.edu\/nguyen\/?p=8"},"modified":"2022-01-26T23:51:15","modified_gmt":"2022-01-26T23:51:15","slug":"about","status":"publish","type":"post","link":"https:\/\/blogs.oregonstate.edu\/nguyen\/2022\/01\/26\/about\/","title":{"rendered":"About"},"content":{"rendered":"\n
\"\"<\/figure>
\n

Tuyen Nguyen is a senior majoring in business information systems at Oregon State University. She is passionate about data analytics. Outside the school, she is taking courses from online websites (365DataScience, LinkedIn, and DataCamp) to learn more about Python, SQL, data analytics, data pipeline, and data engineering. Her next step is to find an internship related to data analytics.<\/p>\n\n\n\n

Tuyen Nguyen’s Resume: https:\/\/github.com\/nntuyen7\/nntuyen7\/blob\/main\/TuyenNguyenResume.pdf<\/a><\/p>\n<\/div><\/div>\n\n\n\n

WORK EXPERIENCE<\/strong><\/p>\n\n\n\n

IT Systems Analyst Intern at Oregon Department of Transportation<\/strong> (June – December 2021)<\/p>\n\n\n\n

\u2022 Took initiative to explore the system and conducted functional tests to design test cases, scenarios, and scripts
\u2022 Collaborated with officers, analysts, and vendors to define requirements and design testing plans and strategies
\u2022 Validated system to ensure that the system met the business requirements
\u2022 Reported the test progress, results, and system issues to quality assurance lead<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

ACADEMIC PROJECTS<\/strong><\/p>\n\n\n\n

Programming Project: Building 3 Python Applications<\/strong>: Developed financial goal calculator, an inventory calculator, and retrieving real-time stock data application from the website using Python in Visual Studio Code<\/p>\n\n\n\n


Course Group Project: ETL Data from Spreadsheet to Access Database<\/strong>
\u2022 Created the database and tables in Microsoft Access database, then defined keys and relationships between tables
\u2022 Programmed with Python to extract data from 50 spreadsheets and load the data to the database
\u2022 Took initiative to make essential changes and completed tasks before the deadline a week
<\/p>\n\n\n\n

Course Group Project: Data Analysis and Visualization with Tableau
\u2022 <\/strong>Downloaded data components from the IPUMS website, then implemented data filtering and sampling in Excel
\u2022 Utilized multiple regression model and visualized data using Tableau to find the factors that affected the total income
\u2022 Wrote a report about methods and concepts of the model
<\/p>\n\n\n\n

Individual Project: Hotel Database Management and Visualization<\/strong>
\u2022 Designed and developed a hotel database
\u2022 Developed SQL code for backups, stored procedures, user-defined functions, transactions, indexes, and views using T-SQL in Microsoft SQL Server
\u2022 Created a pipeline to automate loading data from CSV data file to SQL Server database and creating dashboards in Power BI
<\/p>\n\n\n\n

Individual Python Project: Sales Data Analysis with Pandas Library<\/strong>
\u2022 Gathered 12 CSV files from GitHub to a single file in Jupyter Notebook
\u2022 Cleaned data to avoid data duplication and invalid values with Pandas library, then analyzed data to answer questions
about revenues, locations, and products sold
\u2022 Visualized data using the Matplotlib library<\/p>\n\n\n\n

AWARDS<\/strong><\/p>\n\n\n\n

\u2022 International Student Continuation Scholarship 2020, 2021
\u2022 International Student Honor Roll 2019, 2020, 2021<\/p>\n","protected":false},"excerpt":{"rendered":"

Tuyen Nguyen is a senior majoring in business information systems at Oregon State University. She is passionate about data analytics. Outside the school, she is taking courses from online websites (365DataScience, LinkedIn, and DataCamp) to learn more about Python, SQL, data analytics, data pipeline, and data engineering. Her next step is to find an internship … <\/p>\n

Continue reading “About”<\/span><\/a><\/p>\n","protected":false},"author":12123,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/users\/12123"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/comments?post=8"}],"version-history":[{"count":7,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/posts\/8\/revisions"}],"predecessor-version":[{"id":24,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/posts\/8\/revisions\/24"}],"wp:attachment":[{"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/media?parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/categories?post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/nguyen\/wp-json\/wp\/v2\/tags?post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}