Learn Data Skills
Beta

Andrew Guo

Student

College of the Holy Cross

Technologies

My Portfolio Highlights

My New Course

Data Manipulation with dplyr

My New Course

Introduction to Data Visualization with ggplot2

My New Course

Intermediate R

My New Course

Data Manipulation with dplyr

Always willing, ready, and eager to learn and improve!

My Work

Take a look at my latest work.

course

Introduction to the Tidyverse

course

Introduction to R

course

Intermediate R

course

Introduction to the Tidyverse

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to R
Intermediate R
Introduction to the Tidyverse
Introduction to Data Visualization with ggplot2

My Work Experience

Where I've interned and worked during my career.

Federal Highway Administration | Jun 2023 - Aug 2023

STIPDG Intern, Transportation Specialist

Interviewed for and selected from a highly competitive pool of candidates to be a transportation specialist intern in the Federal Highway Administration (FHWA) office in Connecticut. Developed a white paper for the Connecticut Department of Transportation under the guidance of the CT Division Transportation Planner and Division Engineering Team Leader clarifying eligibility for federal transportation funding programs in the context of legislative and population changes through the Bipartisan Infrastructure Law and the 2020 Census. Developed two chapters in the Appendix for the Division's Discretionary Grant Program Guide, one for sending discretionary grant documents to CT municipalities and their officials to improve the efficiency and response times of document delivery, the second for clarifying language regarding the submission deadlines and required documentation for BIP, RAISE, and SS4A Discretionary Grant quarterly performance/progress reports, under the guidance of the Divison Discretionary Grant Program Manager. Conducted a time series analysis focusing on determining the effectiveness of seatbelt laws in reducing the rate of highway traffic fatalities per 100 million vehicle miles traveled (VMT) to determine if there is convincing evidence based on these statistics for New Hampshire should adopt a seatbelt law. Analysis included examination of slopes over time with specific comparison of slopes before and after seatbelt enforcement, as well as forecasting of fatalities per 100 million VMT from 2019 through 2035.
Show More

National Fisheries Institute | Sep 2022 - Dec 2022

Intern, Public Policy and Government Affairs

Interviewed for and selected to be a Fall 2022 Intern at the National Fisheries Institute through the College of the Holy Cross Washington Semester Program. Regularly updated the Specially Designated National (SDN) List in NFI’s situational report on Russia and Ukraine Sanctions for its member companies. Kept record of events, information, and important updates on behalf of NFI’s Vice President of Government Affairs, Director of Public Policy, and Director of Government Relations at various conferences, meetings, and webinars. Assisted in lobbying efforts on Capitol Hill by taking notes, distributing any reading materials, and supporting NFI’s positions to legislative aides and political representatives. Received high praise in an end-of-internship report from NFI commending a strong work ethic, a consistently high quality of work, a willingness to take ownership of responsibilities, and the professionalism brought with the responsibilities. Drafted internal reports and memos as well as letters and emails addressed to Federal Agencies and NFI member company political representatives on behalf of NFI’s Vice President of Government Affairs, Director of Public Policy, and President/Chief Executive Officer. Instructed NFI staff how to use various pieces of office equipment and computer technologies, such as setting up/ using printers and Microsoft Excel.

St. Paul's School | Jun 2022 - Aug 2022

Intern, Law and Governance Course Teaching Assistant, Dormitory Residential Assistant

Interviewed for and selected among a highly competitive pool of candidates to be an assistant teacher for a college-level course for rising high school seniors in New Hampshire. Completed training on establishing teacher-student boundaries, handling difficult situations, mitigating and resolving conflict, as well as safety and first aid/CPR training. Maintained daily communication with my master teacher and co-intern on particular details we notice in class, such as what material students are paying attention in, why students aren’t completing their work, and insights on each of us could improve in fostering a better learning experience for the students. Held daily office hours for students during the Program’s “Study Hours” and answered any questions that students had on class material, homework, and projects. Developed a comprehensive lesson plan for an entire day of class in political philosophy, using the Greek tragedy Antigone as a case study for examining questions on morality, justice, equality, and power. • Received commendations from master teacher and a Program Assistant Director for my lesson in an end of internship report, particularly on my efforts to facilitate class discussion and my ability to break down a complex text into more accessible terms for high school students. Held weekly dormitory and campus-wide meetings, alongside co-interns and House Supervisors, on topics such as privilege, income inequality, intersectionality, diversity, equity, inclusion, and accessibility for students to learn from. Maintained a welcoming dormitory space that had zero issues of bullying, harassment, hazing, or toxicity throughout the entire program.

Marshalls Convenience Stores | Jun 2021 - Jan 2022

Retail Associate

Interviewed for and hired for a part-time job at Marshall’s Convenience Stores, worked periodically during academic summer and winter breaks. Completed extensive training on loss prevention procedures, cash register operations, and inventory and item management. Trained first-time employees in understanding operating procedures for inventory management, handling difficult customers, and operating cash registers. Commended for consistently high customer service and excellent inventory management.

My Education

Take a look at my formal education

Bachelor of Arts - BA, Political Science, Statistics, Asian Studies  · (AugustCollege of the Holy Cross | 2024
William & Mary
High School Diploma Nashua High School South | 2020

About Me

Political Science and Statistics student looking to further improve knowledge, skills, and abilities in data science. Currently improving technical skills in R, Python, and SQL.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free