Jake Merten Email & Phone Number

• Develop, document, and debug new computer programs, ensuring optimal functionality through rigorous unit testing• Provide comprehensive systems testing support, including data preparation, scripting, and thorough test execution• Ensure data integrity and consistency through the creation of constraints, normalization techniques, and thorough testing• Write comprehensive Junit tests to maintain code quality and prevent regressions during development• Collaborate with cross-functional teams to define data requirements and design efficient database schemas

• Ran scripts to understand project efficiency, maintained EMIS, SAP databases and Grants Manager Enterprise System• Maintained a report repository using SQL and dashboard scraping to streamline knowledge for management staff• Managed developmental project files, logistical records, and client disaster reports• Reviewed projects in accordance with environmental laws (NEPA/CEQA/ESA), regulations, permits, and zoning

Boise, Idaho, United States

• Collaborated across teams to develop data projects including mapping, PowerBI dashboards, and excel databases• Provided technical assistance on water quality issues, including developing ArcGIS maps, regulatory memos, and maintaining/visualizing COVID-related wastewater data• Developed a VBA database to compile local, state, and national changes to government law and regulation

United States

• Developed a report repository using SQL and dashboard scraping to streamline knowledge for management staff• Ran excel scripts to understand project efficiency, maintain the EMIS database and Grants Manager Enterprise System• Reviewed projects in accordance with environmental laws (NEPA/CEQA/ESA), regulations, permits, and zoning• Performed over 100 assessments (ESAs), 50 zoning meetings, and prepared over 130 NEPA documents (CATEX)• Maintained developmental project files, accurate meeting notes, and logistical records• Served as the front-facing contact point for environmental and planning questions

Bangkok Metropolitan Area, Thailand

• Compiled information, wrote reports and used ArcGIS to generate maps for ROAM reforestation and development initiative• Drafted a USD$50 million Green Climate Fund pre-feasibility report for addition to the 2018-2028 Myanmar Restoration Plan• Supported the ROAM analytical process in SE Asia sites, helped lead interagency trainings in the Philippines and India; SEO

Madison, Wisconsin Area

• Completed careful content curation and comprehensive in-situ/remote data analysis of over 100,000 individual plant specimens

Madhya Pradesh, India

• Conducted a field study to assess the status and impact of tiger tourism in and around four MP Tiger Reserves (Panna, Bandhavgarh, Kanha, and Pench)• Trained and lead field staff in conducting fieldwork to assess the status and impact of tiger tourism in 5 MP Tiger Reserves• Analyzed field data using SQL and Tableau to create an ecotourism report/infograph outlining alternate-income strategies• Explored, studied, and enacted viable conservation techniques focusing on alternative-income strategies.

Door County, Wi

• GIS mapped, monitored, and removed invasives on 4,000 acres of TNC preserves; collected samples for genetic analysis• Interacted with the public and local preserve neighbors; negotiated stakeholder conflict resolution and contractor contracts• Developed informational outreach material and compiling invasive species data in a central GIS database

Shaver Lake, Ca

• Created a customizable Access database and performed complex data entry, GIS mapping, and SCA volunteer coordination• Led a team and volunteers through wilderness and off-trail research sites.• Transported/assembled baited camera traps and track-plate boxes, for fisher & marten in backcountry and wilderness sites

Madison, Wisconsin Area

• Conducted GIS mapping/statistical analysis for an independent project on the dietary patterns of fisher (Pekania pennanti)

Shaver Lake, Ca

Madison, Wisconsin Area

Lake Mills, Wi

Master Of Science - Ms, Environmental Science

Focus in data analytics and visualization

Bachelor Of Science (B.S.), Environmental Science

Bachelor Of Science (B.S.), Integrative Biology