Andrew Yan
About Andrew Yan
Andrew Yan is an IT Specialist at the U.S. Geological Survey, where he has worked since 2012. He has a background in Chemistry and experience in developing automated systems and web applications to manage water data.
Work at U.S. Geological Survey
Andrew Yan has been employed as an IT Specialist at the U.S. Geological Survey (USGS) since 2012, contributing to the organization for over 12 years. His role involves automating resource provisioning and configuration in Amazon Web Services (AWS), which enhances operational efficiency. Yan has also developed web applications and tools using programming languages such as Ruby, Python, Shell, and JavaScript. His work supports the acquisition, distribution, and manipulation of national scale water data, aligning with USGS's mission to provide reliable scientific information.
Education and Expertise
Andrew Yan holds a Bachelor of Science (BS) in Chemistry from the University of California, Berkeley, which he completed from 2004 to 2008. He furthered his education at the University of Wisconsin-Madison, where he earned a Master of Science (MS) in Chemistry from 2008 to 2011. His academic background provides a strong foundation for his technical skills in IT and data management, particularly in the context of environmental science.
Previous Experience at University of Wisconsin-Madison
Before joining the USGS, Andrew Yan worked at the University of Wisconsin-Madison from 2008 to 2011. During this time, he served as both a Research Assistant and a Teaching Assistant for three years. His responsibilities included managing water quality and biological data using Oracle databases with SQL and PL/SQL. This experience contributed to his expertise in data management and application development.
Technical Skills and Projects
Andrew Yan has demonstrated proficiency in various technical areas, including the design of automated deployment pipelines for Docker containers, which improves cloud infrastructure efficiency. He has led application development teams by implementing task management and agile methodologies, ensuring effective communication with project sponsors. His skill set includes programming in Ruby, Python, Shell, and JavaScript, which he utilizes to develop applications that support national water data management.