Hannah Mandell

Bachelor of Arts, Computer Science. Mathematics Minor

2019 - 2023

Pomona College - Claremont, CA

GPA: 3.92

NCAA Women's Varsity Soccer, Pomona Artifical Intelligence (P-ai), Tech 4 Good, 5C Hackathon, Computer Science Department Student Liaison

High School

2015 - 2019

Wakeland High School - Frisco, TX

GPA: 4.0, Rank: 7/500

Summa Cum Laude, Senior Class President. State Champion in both Soccer and Cross Country

Software Engineer

Sep 2023 - Present

Climate - Seattle, WA

• Currently I am handling, storing, delivering, and monitoring big data to help farmers sustainably manage their operations
• High focus on data quality and navigating data contracts between scientific and business stakeholders
• Working within AWS (S3, SQS, SNS, EC2, ECS), BigQuery, Spark, Hive, Vertica, Postgres, AirFlow, and Docker

Software Engineer Intern

Jun 2023 - Sep 2023

Esri - Redlands, CA

• Forged a new GeoProcessing Tool for the ArcGIS Pro Indoors team that can gather linework, metadata, and text from floorplan PDFs to display them on a digital map
• Modified open-source libraries to parse PDF streams and ingest vector linework coordinates and attributes
• Leveraged OpenCV, Keras to extract linework and text from rasterized PDF documents of building layouts

Software Engineer Intern

May 2022 - Aug 2022

Climate - Seattle, WA

• Utilizing AirFlow, AWS (S3, SQS), Vertica, Docker, Spark, and Hive to deliver high quality batch features
• Added a customizable data validation step to a widely used feature generation pipeline to increase the efficiency of dataset preparation for data scientists and analysts
• Participate in Agile Development workflows

Software Engineer Intern

Jan 2022 - May 2022

Navfeas - Claremont, CA

• Using Docker, MongoDB, FastAPI, and NodeJS to create an API that prepares and visualizes parametric geospatial data
• Manage 3 other students, benchmark sprint goals, present quarterly updates to management

Application & Software Development Intern

Jun 2021 - Jan 2022

Colgate-Palmolive - Piscataway, NJ (Remote)

• Utilized Google Cloud, BigQuery, AppEngine, Flask to develop software and hardware for new IoT-based reorder & replenishment products
• Created and launched an API and Flask-based Bootstrap-designed web page to analyze, track, and organize KPIs for issues related to products sold on Amazon, adding visibility for a previously manually-tracked process
• Updated an API for business processing and eCommerce used by 1500+ clients daily; rewrote documentation in Confluence

Lead Data Analyst

Sep 2020 - June 2021

Pomona College Sustainability Office - Claremont, CA

• Managed, entered, and reported on energy and water data in Google Sheets and Tableau to construct an Annual Report
• Saved the college thousands of dollars by investigating water usage anomaly data and discovered faulty water meter readings

Managing Director

May 2022 - May 2023

P-ai (The Artificial Intelligence Organization of the Claremont Colleges) - Claremont, CA

• Managed club operations, hiring, logistics, finance, and outreach for 300+ members of the campus Artificial Intelligence community
• Planned and supervised 3+ student and alumni-led AI workshops per semester, coordinated industry partnerships
• Served as a point-contact and figurehead of one of the campus’ largest student organizations

Director

Jan 2023 - May 2023

5C Hackathon - Claremont, CA

• Revived a longstanding-school tradition that had been taken down by COVID, bringing 200+ participants, $3500 in prizes, and 10 sponsors (Google, Strava, Bloomberg, OpenAI, etc.) together for a 24 hour innovation challenge on "Tech for Good"
• Lead subteams in web development, logistics, marketing and design, sponsorship, and workshop preparation
• Delivered 11 workshops and diverse hacker participation, with 70% being first-time hackers and 50% as non-male identifying
• Managed corporate sponsorships and finances, including deal-making, sponsor packages, swag shipping & handling, invoices, and timely communication

Climate Modeling Research Assistant

Oct 2019 - May 2023

Williams Marine Environmental Change Lab

• Using R and Python to model historic temperature data via oxygen isotopes in marine organism skeletons, with the ultimate goal of understanding the pending impact of climate change on various ecosystems
• Reduced error by introducing comparisons testing, simulations (chronological and analytical uncertainty), and bootstrapped confidence intervals into data pipeline
• Supervised by Dr. Branwen Williams (Director of the Roberts Environmental Center, Climate Science Professor at Claremont McKenna College, and featured Nat Geo Explorer) and Dr. Diane Thompson (Director of Marine Research at Biosphere 2 and Geosciences Professor at Univ. of Arizona). Submitted to the Journal of Paleoceanography and Paleoclimatology as a co-author, where it is currently in review

Environmental Chemistry Research Assistant

May 2020 - Aug 2020

Pomona College Environmental Analysis Department

• Summer research proposal awarded through written application. Selected out of hundreds of applicants
• Combined factory waste data with scraped chemical safety data to inform non-profits on how to best provide for the impacted houseless population residing in the Tijuana River
• Remotely collaborated with a bi-national team of health professionals and academics to identify harmful pollutants, the social & political framework the pollutants acted within, and plan a legally-defensible water sampling

Apple Women in Science and Engineering Mentorship Program

Sep 2021 - Jun 2022

• Selected to a cohort of undergraduate women to be paired with a mentor in Apple Engineering throughout the year.

NOAA Hollings Scholar Select

Apr 2021

• Prestigious national appointment to NOAA (National Oceanic and Atmospheric Association) mission.

Davey O’ Brien Foundation High School Scholar Athlete Scholarship

Feb 2019

• Selected among all north Texas high school students on the basis of scholastic achievements, community service, character, leadership & varsity sports participation. Accompanied by $30,000 academic scholarship. Honored alongside Kyler Murray.