# Sophia Wang > Software Engineer at Affinity Location: San Francisco Bay Area, United States Profile: https://flows.cv/sophiawang Double majoring in Computer Science and Statistics and Data Science. ## Work Experience ### Software Engineer @ Affinity.co Jan 2022 – Present | San Francisco Bay Area ### Data Platform Intern @ Visa Jan 2021 – Jan 2021 Identified string-matching algorithms for consumer name similarity analysis Implemented and analyzed algorithms’ accuracy to perform consumer entity resolution in Identity Graph Computed operational metrics like data size/count to understand Identity Graph growth rate for storage capacity computation in Hadoop clusters Published operational metrics in Grafana, Power BI, and Tableau ### Research Assistant @ The University of Arizona College of Nursing Jan 2020 – Jan 2021 | Tucson, Arizona, United States Recoding free response answers of over 2000 survey respondents to a nurse pain survey to numerical values using Python for easier data analysis ### Database Intern @ HealthTrio, LLC Jan 2019 – Jan 2020 | Tucson, Arizona, United States Rewriting a job in the ETL process that reduced the runtime from 6 hours to 2.5 hours and the shortened rebuild time of elastic search from 8 hours to 4 hours Refactoring legacy SQL stored procedures and scripts to make them more dynamic and optimized Converting sql scripts into Azure Data Studio notebooks to allow nontechnical users to run code Configuring polybase to explore potential benefits of adopting MongoDB ### Statistics REU in SIgnal Detection @ University of Arizona Jan 2019 – Jan 2020 | Tucson, Arizona Collaborating with a professor to develop code in R that can detect signals from noise and the intervals where those signals are located Utilizing recursion and dyadic intervals to improve computation time from n^2​ ​to nlog(n) ### Web Scraper @ University of Arizona Jan 2018 – Jan 2019 | Tucson, Arizona Enabling the team to use machine learning and natural language processing to build a platform containing documents pertaining to environmental policy Working in Lopez-Hoffman lab to write scripts that download PDF documents relating to environmental policy from various websites Ran scripts using the high performance computing cluster with multiple threads to automatically download and store documents into box ### Section Leader @ University of Arizona Jan 2018 – Jan 2019 | Tucson, Arizona Attended class lectures and administered exams Facilitated lab hours once a week for two hours to enhance student understanding of weekly assignments Responded to student questions through online platform ### Research Assistant @ University of Arizona Jan 2018 – Jan 2018 | Tucson, Arizona Worked with professor and PhD student in geolocation normalization using neural networks Wrote file conversions from text sentences to BIO-format and vice versa Ran evaluation scripts ### Tutor @ TutorSync Jan 2017 – Jan 2018 | United States Contacted and negotiated prices with tutees' parents Designed my own Algebra I curriculum for summer tutees Understood each tutee's learning style ## Education ### Bachelor of Science - BS in Computer Science, Statistics and Data Science University of Arizona ## Contact & Social - LinkedIn: https://linkedin.com/in/sophia-lee-wang --- Source: https://flows.cv/sophiawang JSON Resume: https://flows.cv/sophiawang/resume.json Last updated: 2026-03-29