Kaitlin Panzner Email & Phone Number

Advantage Group is the leading advisor in B2B engagement globally. We help people and organizations work better together by providing the gift of feedback and, through insight, driving positive behavior change and business growth. Advantage uses data, feedback, and strategy consulting to illuminate opportunities for mutual growth, strengthen relationships, and provide invaluable insight.As a dedicated professional in the analytics space, I thrive on delivering impactful outcomes through strategic collaboration and effective project management. My role ensures that our Advantage program aligns with company-wide goals, driving timely and effective results for our manufacturer and retailer clients. My meticulous attention to detail ensures we gather sufficient ratings before field closures, enabling us to maintain our project timelines without compromising quality.With a strong foundation in quantitative and qualitative analysis, I leverage data storytelling to share meaningful insights that empower clients to harness the full potential of Advantage data. I am the go-to resource for data-related inquiries, supporting Client Strategy Directors and the Managing Director in expanding our business with both current and prospective clients.My skill set includes advanced proficiency in Excel, strong presentation development abilities, and creative data visualization. I possess a strong understanding of data visualization principles, enabling me to translate complex data sets into clear, actionable insights using Tableau. I am passionate about maintaining a customer-centric approach and am committed to continuous professional growth through direct client interaction. I pride myself on my proactive mindset and ability to manage multiple projects simultaneously, ensuring that each client receives the attention and insights they deserve.

Projects:Broward County Airbnb Data (June 2023)• Conducted a comprehensive analysis of rental data by geographics, producing metrics such as property type, neighborhood, price, and rental duration• Leveraged data to identify optimal pricing strategies, resulting in insights that inform ideal listing creation • Used Python and Tableau to determine that short terms listings, entire homes/apartments, and listings in Tribal Lands, Lighthouse Point, and Sea Ranch Lakes were the most profitable • Identified that private rooms in Tribal Lands could bring in $225K per year in potential income, 50% higher than the following highest listing Likelihood of Dying From COVID-19 (April 2023)• Used COVID-19 data from 2020-2022 to determine the likelihood of dying from the virus based on location (region/state), gender (male/female), and age group • Utilized Excel and Tableau to identify the demographics with the highest fatality rates, revealing that men aged 85 years and older residing in California, Texas, and Florida experienced the most fatalities • Determined men had a higher death rate (0.36%) than women (0.29%); with males having more deaths in each age group (excluding the 85+ group) and on aggregate, males exceeding 100,000 more deaths than females

St Petersburg, Florida, United States

• Directed and personalized unique customer experiences for an innovative local business, using data-driven approaches to improve customer satisfaction, leading to a significant increase in customer retention and engagement• Created weekly and monthly sales reports, utilizing data to identify top-performing and underperforming retail products, enabling data-informed decisions for future inventory orders and optimizing profit margins• Managed merchandise ordering processes using predictive analytics to anticipate inventory needs based on historical sales data, reducing stockouts and overstock incidences• Led content creation for social media platforms, leveraging customer data and engagement metrics to inform strategy, resulting in an increase in online visibility and follower count• Maintained exceptional customer service standards for up to 500 customers weekly, creating an enjoyable experience, and resulting in increased repeat business

Clearwater, Florida, United States

• Responsible for conducting environmental reviews for boat dock, dredge and fill, and mangrove trimming applications for consistency with both the Pinellas County Water Navigation code and Mangrove Trimming and Preservation code• Perform field reviews of site conditions to assess environmental and navigational impacts for proposed projects, requiring extensive field analysis notes, documentation, GIS surveys, and biological assessments to produce reports in Excel • Collaborated with non-technical stakeholders, Municipal, State, and Federal officials, and applicants to schedule on-site meetings, revise details of the project, and discuss modifications to permit applications • Utilized field reports and supplemental materials to perform in-depth analysis for approving or denying permit applications, ensuring compliance with relevant regulations and environmental standards, as well as the Programmatic General Permit (SAJ-96) on behalf of the U.S. Army Corps of Engineers• Resolve enforcement cases for violations with the Water and Navigation and Mangrove Trimming regulations involving scheduling meetings, sending notices of violations, writing up consent orders, and generating mitigation plans• Train and supervise temporary employees, interns, and volunteers to assist with field reviews, enforcement cases, and data entry• Launched the implementation of Accela, a government software system, to streamline the permitting procedure, improve database management, increase online application submissions, boost response times, and generate reports for the County’s records and analysis

Tampa/St. Petersburg, Florida Area

• Performs biological assessment and water quality sampling in fresh, estuarine and marine ecosystems• Conducts both surface and groundwater sampling• Currently undergoing FDEP training and biological assessment certifications including Stream Condition Index, Lake Vegetation Index, Rapid Periphyton Survery, Linear Vegetation Survery, and Stream and Lake Habitat Assessments• Performs logistical planning in coordination with other personnel for field sampling events using GIS, internet, mapping programs, databases and other available sources• Assists with responding to complaint investigations including algal blooms, fish kills, etc.• Enter and upload biological, physical and chemical data into various data storage and retrieval systems including SBIO and LIMS• Organizes and maintains equipment and other sampling gear including organization of field projects, keeping inventory of coolers, kits and supplies needed for projects; cleaning of laboratory space, vehicles, and equipment• Undergoing boat and trailering certification safety training

Tampa/St. Petersburg, Florida Area

• Completed training in laboratory techniques and safety at the Environmental Compliance Division Laboratory• Training included reading and understand SOP’s, preparing reagents, and performing chemical analyses on drinking and wastewater samples• Completed Initial Demonstration of Capability (IDOC) for chloride titration and Total Suspended Solids• Independently run chloride titrations, calculations, and data entry into Element • Familiarity with St. Petersburg’s Water Resources Department including the distribution, treatment, reclamation, and sampling of water throughout the city

Clearwater, Fl

• Conduct water quality, seagrass, and benthic monitoring including sample preparation, collection, data entry, and research• Carry out independent research and analysis on collected seagrass data in Tampa Bay• Perform red tide monitoring for Pinellas County beaches involving sample collection, microscope counts, and recording weather and beach conditions• Provide help with water quality data entry and analysis for the FDEP-Water Information Network

Miami/Fort Lauderdale Area

• Prepare environmental permit applications required by local, state, and federal government agencies• Write inspection reports for ongoing compliance projects including water quality data, and site and endangered species monitoring• Assist with biological assessments including wetland delineations, vegetation and wildlife surveys, and benthic surveys• Responsible for permitting, mitigation and monitoring for wetland development projects and dock and seawall construction• Generate mangrove trimming and removal permit applications for clients including site evaluations, environmental mitigation, and annual monitoring reports• Create GIS figures for environmental permitting applications and reports• Assist with administration and clerical work in an office setting

Tampa/St. Petersburg, Florida Area

• Participated in population genetic projects for marine and freshwater sport fish species• Collected and analyzed specimens for ongoing conservation projects using molecular genetics techniques such as microsatellite genotyping and DNA sequencing• Analyze, tabulate, catalogue, and archive data using in depth knowledge of GeneMapper and Excel• Compiled microsatellite records for genome databases of different species

Mote Aquaculture Park

-Completed training in aquaculture for holding tanks and resident species to support marine conservation research/experimentation including live feed culture, nutrition and husbandry-Test/record water quality data, feed marine stock including dry, bait and live forms-Monitor food supply ensuring quality through rotifer tank husbandry, rotifer enrichment and counts -Manage growth rates by larval measurements and fish grading

Bachelor Of Science (B.S.), Marine Sciences

Relevant Coursework: *Denotes Lab Component Biological Oceanography* | Conservation Biology | GIS for Environmental Studies | Marine.

Certificate, Data Analytics

Springboard School of Data’s Data Analytics Career Track is a six month program designed to teach students the technical skills.

Master'S Degree, Coastal Zone Management

Relevant Coursework: Coastal Law and Policy | Intro to Marine GIS | Coastal Zone Management | Environmental Planning and the Environmental.