It Intern Analyst

Tuyen N. Nguyen

Corvallis, OR – ********@*****.*** – 313-***-**** – linkedin.com/in/nntuyen7

SUMMARY

• Passionate about data analytics to improve business performance and keep track of measurable objectives and goals

• IT Systems Analyst intern at Oregon Department of Transportation for 6 months to ensure system quality and meet system requirements based on testing-driven software development and Agile methodology

• IT intern at A-dec in Business Intelligence team to create and maintain ETL pipelines to migrate data from different systems with SSIS packages, and create Power BI reports

• Proficient in using SQL and T-SQL to design normalized and denormalized databases with OLTP and OLAP systems, maintain, automatically update the database and backups, retrieve necessary data to analyze and visualize

• Effectively using Python (Pandas, NumPy) and Excel (Power Query, PivotTable) to work with datasets including cleaning, analyzing, and visualizing data

• Having knowledge using business intelligence tools such as Power BI and Tableau to create data models, dashboards, and reports

EDUCATION

Oregon State University Estimated Graduation: December 2022 Bachelor of Science, Business Information Systems (GPA: 3.77)

• Relevant Coursework: Applied Quantitative Methods, Business Data Management, Application Development, Business Telecommunication and Networking, Information Systems Security EXPERIENCE

A-dec Inc. Jun - Dec 2022

Business Intelligence Intern Newberg OR

• Program with SQL to retrieve supply chain data and interview users to gather their requirements for reports

• Design data models and process data with Power Query to create Power BI reports based on customers’ requirements to improve operations data and storing data processes

• Create SSIS packages to import data from ERP system to the data mart, then utilize Azure DevOps for source control

• Provide information services by solving ServiceNow tickets for business users to help them automate storing process Oregon Department of Transportation Jun - Dec 2021 IT Systems Analyst Intern Salem OR

• Defined all system requirements by interviewing and collaborating with officers, analysts, and system developers

• Covered all requirements by generating more than 100 practical test cases for system functional test

• Ensured traceability of requirements to test cases

• Generated weekly test report status about system performance and stability for QA and developers ACADEMIC PROJECTS

Programming Project: Building 3 Python Applications Jun - Sep 2020

• Developed a financial goal calculator, an inventory calculator, and retrieving time-series stock data application delivered by an API from the website using Python in Visual Studio Code Course Group Project: Data Analysis and Visualization with Tableau Jan - Mar 2021

• Utilized multiple regression model and chose appropriate graph to visualize data using Tableau, then found the factors that affected the total income

• Wrote a professional report including methods and concepts of the model Individual Project: Hotel Database Management and Visualization Sep - Dec 2021

• Designed and developed a hotel database based on the OLTP concept to reduce transaction processing time

• Utilized T-SQL code to create backups, stored procedures, functions, transactions, indexes, and views in Microsoft SQL Server to keep the data updated, ensure data quality and integrity

• Created a pipeline to automate loading data from CSV data files to SQL Server database and creating dashboards in Power BI to reduce manual work

AWARDS

• Carol Brenne Sampson Information Technology Scholarship 2022

• International Student Continuation Scholarship 2020, 2021

Contact this candidate