L. Mansfield
Logan Mansfield

Logan Mansfield.

IT analyst moving into analytics engineering: I build the pipelines, models, and dashboards that turn raw operational data into decisions. By day I’m responsible for the ticketing and webstore platforms behind ZooTampa’s admissions revenue; my SQL, Python, and modeling work is self-driven and on GitHub.

Now IT Point of Sale Systems Analyst at ZooTampa at Lowry Park
Building A fraud-detection pipeline over simulated webstore checkouts, with live daily numbers
Latest Quack Query — ask a data file questions in plain English; an LLM writes the SQL and DuckDB runs it in your browser
SQL source
SELECT now, building, latest
FROM resume;
  1. raw Page markup
  2. staging Parsed page rows
  3. mart resume

This query writes what’s shown above, from the site’s own tables; a check fails the build if it ever stops matching. See its checks.

All projects →
SQL source
SELECT title, eyebrow, year, summary, tags
FROM projects
WHERE featured
ORDER BY sort_order;
  1. raw Page markup
  2. staging Parsed page rows
  3. mart projects

This query writes what’s shown above, from the site’s own tables; a check fails the build if it ever stops matching. See its checks.

Experience

Full résumé (PDF)
  1. IT Point of Sale Systems Analyst

    Nov 2024 – present

    ZooTampa at Lowry Park · Tampa, FL

    I’m responsible for the Gateway Galaxy 8 ticketing platform and eGalaxy webstores, the systems behind the Zoo’s admissions and membership revenue: product and pricing configuration, monitoring, and vendor escalation. I built nine new premium animal-experience products and an admission-inclusive bundle, all still on sale, and designed and monitored the webstore upsells (add-on offers, a membership upsell tile, announcement ribbons) in custom HTML, CSS, and JavaScript. I also administer two POS platforms and a fleet of about 90 terminals, and gather requirements from front-line departments for platform changes.

  2. Guest Engagement Coordinator (started as Guide)

    Nov 2022 – Nov 2024

    ZooTampa at Lowry Park · Tampa, FL

    Overhauled the department’s reporting system, saving about four coordinator hours a week (roughly 200 hours a year). Produced weekly operational reports for leadership flagging risks and changes, and co-wrote education programs and their SOPs with animal care staff.

  3. Data Analyst

    Aug 2019 – Jul 2022

    Excel Esports · London, UK

    Designed and delivered a data-driven talent scouting system in Excel and Python within six months; the resulting academy roster became the most dominant in the organization’s history by league performance. Delivered weekly tactical, meta, and player-development analysis that produced direct advantages in official matches.

SQL source
SELECT
    role,
    note,
    concat_ws(' · ', org, location) AS org,
    strftime(started, '%b %Y') || ' – '
        || coalesce(strftime(ended, '%b %Y'), 'present') AS dates,
    summary
FROM experience
ORDER BY started DESC, sort_order;
  1. raw Page markup
  2. staging Parsed page rows
  3. mart experience

This query writes what’s shown above, from the site’s own tables; a check fails the build if it ever stops matching. See its checks.

Credentials

  • Microsoft Certified: Power BI Data Analyst Associate PL-300
  • SQL Certification of Competency LearnSQL.com
  • Microsoft Fabric in a Day workshop
SQL source
SELECT credential, detail
FROM credentials
ORDER BY sort_order;
  1. raw Page markup
  2. staging Parsed page rows
  3. mart credentials

This query writes what’s shown above, from the site’s own tables; a check fails the build if it ever stops matching. See its checks.

Toolkit

Data stack

  • SQL
  • Python · pandas
  • DuckDB
  • Databricks
  • Spark SQL / PySpark
  • Postgres / Supabase
  • Microsoft Fabric
  • Power BI
  • Excel

Forecasting & ML

  • scikit-learn
  • XGBoost

Platforms I run at ZooTampa

  • Gateway Galaxy 8 · eGalaxy
  • PAR Pixel POS
  • HTML · CSS · JavaScript
SQL source
-- Not every table here makes it onto a page. SHOW ALL TABLES lists them.
SELECT category, list(skill ORDER BY sort_order) AS skills
FROM skills
GROUP BY category
ORDER BY min(sort_order);
  1. raw Page markup
  2. staging Parsed page rows
  3. mart skills

This query writes what’s shown above, from the site’s own tables; a check fails the build if it ever stops matching. See its checks.

Tools over time

When I used each one
  • Paid work
  • Personal projects
Solid boxes are paid work: SQL and Python as a data analyst at Excel Esports, then Power BI and SQL at ZooTampa. Outlined boxes are tools I’ve used in my own projects: they show when I picked each one up, not years on the job. Hover a box, or open Data source below, to see what I built with each.
Data source
Tools and when I used them
ToolWhenHow
Python2021 – Jul 2022Paid work, data analyst at Excel Esports
2023 – nowPersonal projects: Fraud Detection Pipeline, Attendance Forecasting, Roll Call
SQL2020 – Jul 2022Paid work, data analyst at Excel Esports
2024 – 2025Personal projects: Member Segmentation (RFM), Quack Query, Owl Park
2026 – nowPaid work at ZooTampa
Power BI2024Personal projects: Member Segmentation (RFM), Owl Park Data Architecture
2025 – nowPaid work at ZooTampa
Fabric2025Personal projects: Owl Park Data Architecture
Snowflake2025Personal projects
Databricks2025 – nowPersonal projects: Fraud Detection Pipeline
Roles and credentials
MilestoneWhen
Data Analyst, Excel EsportsAug 2019
Joined ZooTampa at Lowry ParkNov 2022
IT Point of Sale Systems Analyst, ZooTampaNov 2024
SQL Certification of Competency, LearnSQL.com2025
Microsoft Fabric in a Day workshop2025
Microsoft Certified: Power BI Data Analyst Associate (PL-300)2025

Drawn from one small data file; a check fails the build if the chart and the file ever disagree.

About

I’m a data analyst in Tampa, FL, moving into analytics engineering. I came to data through analysis, three years turning esports performance numbers into scouting and tactical decisions, and then moved into the systems side: today I’m responsible for the ticketing and webstore platforms behind ZooTampa’s admissions revenue, from product and pricing setup to vendors and the point-of-sale hardware across the park. That job taught me where operational data comes from and how it breaks.

My analytics work is self-driven and public. I hold the Microsoft PL-300 and a LearnSQL certification of competency, and on my own time I ship data tools: natural-language-to-SQL on DuckDB in the browser, theme-park attendance forecasting, a fraud-detection pipeline over simulated webstore checkouts, and a local-first desktop analytics assistant. I’m looking for analytics engineering and data analyst roles where I own the path from source system to trusted model.

What I care about is data people can trust: clear models, honest metrics, and reporting a non-technical stakeholder can read at a glance, plus the question behind the number: why a channel underperformed, whether a pricing change did what it was supposed to, and what the pipeline missed.

Let’s connect

The fastest ways to reach me