# Qihang Yan > Software Development Engineer at AWS Location: San Francisco Bay Area, United States Profile: https://flows.cv/qihangyan ## Work Experience ### Software Engineer @ Amazon Web Services (AWS) Jan 2022 – Present | San Francisco Bay Area Database Migration Service ### Software Engineer @ Amazon Jan 2021 – Jan 2022 | Austin, Texas, United States Amazon Fulfillment Tech - Product Assurance, Risk, and Safety Tech ### Data Engineer @ Amazon Robotics Jan 2020 – Jan 2021 | Westborough, Massachusetts, United States ### SW Data Engineer Intern @ Amazon Robotics Jan 2019 – Jan 2019 • Designed and implemented a data-driven, knowledge-based framework in Python3 for classifying root causes of any inefficiencies in the Amazon’s warehouse system using K-Means Clustering and dynamic statistical analysis. • Deployed the framework end-to-end in a development pipeline using Native AWS services, including Lambda Functions, ECS, Athena, S3 and etc. • Deep dived to identify where inefficiencies could occur by collaborating with multiple teams, and built an automated data aggregation model using SQL for extracting and aggregating features relevant to these inefficiencies. • Conducted extensive data science research for data exploration, and applied techniques such as scaling, PCA (principal component analysis), and various machine learning algorithms. ### Teaching Assistant @ Cornell University Jan 2018 – Jan 2019 | Ithaca, New York Area • Assist professor with teaching and preparation in courses: Embedded System and Language&Information Retrieval. • Write auto-grader scripts in Python for students’ assignments • Conduct lab sessions and office hours to teach related course materials ### Software Data Engineer Intern @ CODE.GAME(Shenzhen Dianmao Technology Co. Ltd.) Jan 2018 – Jan 2018 | Shenzhen, Guangdong, China • Performed data cleansing and integrating with Python3, extracted relevant data from multiple MySQL repositories, transformed them into JSON forms, and exported to MongoDB • Created an automated teacher evaluation system using heuristic function, to inspect and report their periodical performances during online courses, and to help company maintain course qualities • Built an OLAP(Online-analytical processing) system used for dynamic analysis of children’s performance on homework, and increased efficiency of the task • Used Bokeh on Jupyter Notebook to conduct data visualization and simplified the companies’ data analysis process ### Summer PM Intern @ Quadrant Jan 2018 – Jan 2018 | San Francisco Bay Area • Reviewed and organized technical documents for clearer management • Designed and built the company’s official website using Sparkle, collaborated with the company’s directors and discussed the information to include for optimal marketing effects Researched and edited Wikipedia articles related to the company for future easy references ### Embedded System Intern @ Bosch Jan 2017 – Jan 2017 | Shanghai City, China • Participated in VCU (Vehicle Control Unit) Software Development, reviewed and refactored high level logics of the control unit using Simulink • Conducted Lab Car Tests for prototype ECU (Engine Control Unit), built circuit board for various signal analysis, inspected testing simulation with INCA, CANalyzer, etc, provided detailed result records using data analysis • Reviewed for problematic logic designs based on testing data by researching and examining circuit documents • Designed and built Knowledge Management Wiki Page to link and store useful departmental information for resource management ## Education ### Bachelor of Science - BS in Computer Science Cornell University ## Contact & Social - LinkedIn: https://linkedin.com/in/qihang-yan --- Source: https://flows.cv/qihangyan JSON Resume: https://flows.cv/qihangyan/resume.json Last updated: 2026-03-29