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