Summary

Overview

Work History

Education

Skills

Relevant Course Work

Languages

Timeline

Oliver Grannis Pflaum

New York

Summary

Organized technology professional, proficient in QuickBooks, Microsoft software, coding languages, and ArcGIS. Experienced in both technical and social skills. Expert public speaker with experience leading conferences with hundreds of participants.

Overview

years of professional experience

Work History

Bookkeeper/Driver

Glencadia Dog Camp

09.2024 - Current

Maintained accurate financial records and reconciliations using QuickBooks and Zoho, ensuring compliance with NY accounting standards.
Prepared monthly financial reports to inform strategic budget decisions.
Drove Large 16 foot Sprinter Van in NYC Area to pick up and drop off dogs

GIS Analyst

Environmental Defense Fund

01.2025 - 05.2025

Partnered with the Environmental Defense Fund (EDF) to develop GIS-based tools identifying affordable housing locations in North Carolina while safeguarding wetlands, biodiversity, and flood-prone zones.
Led a team using ArcGIS Pro and Python to conduct multi-layer spatial analyses integrating climate adaptation, infrastructure resilience, and environmental justice, to advocate housing policy for 9 North Carolina counties.
Delivered policy-relevant, data-driven recommendations to support sustainable housing development strategies balancing environmental sensitivity with community needs.
Applied advanced geospatial methods to inform state and local planning decisions, strengthening long-term resilience in vulnerable communities.
Developed Excel-based model to determine development potential while protecting wetlands and avoiding flood zones, providing policymakers with actionable tools.

Director

Columbia SIPA

09.2023 - 05.2024

Directed a nonprofit educational organization serving hundreds of underprivileged high school students in the New York City area through free Model UN conferences and teaching programs.
Oversaw multiple committees of Columbia undergraduates, managing logistics, curriculum design, and outreach to schools.
Developed and implemented educational curricula tailored to partner schools’ needs, strengthening students’ debate, public speaking, and critical thinking skills.
Managed organizational strategy, budgeting, and long-term program sustainability, while upholding CESIMS’ philanthropic mission.
Collaborated with school administrators and NYC education stakeholders to expand program access, fostering equitable educational opportunities for underserved students.

Head Intern

Shaun Abreu's Constituent Services

05.2023 - 09.2023

Managed high-volume constituent communications, addressing issues related to housing, public benefits, and city services.
Assisted constituents in navigating NYC agencies, resolving cases involving tenant rights, social services, and community resources.
Designed and implemented new tracking workflows that reduced case resolution time.