John Jimenez
Available May 2026

Hello, I'm John Jimenez

|

Data Analyst IT Analyst Business Analyst Automation Analyst

Data & Automation Analyst at Florida State University focused on transforming complex operations into actionable intelligence.

Open to full-time and internship roles in Florida or remote • Start: May 2026

40+ Weekly Health Checks Automated
18M+ Annual Transit Boardings Analyzed
20% Manual QA Effort Reduced

How I Work

I enjoy taking messy operations data, turning it into something clear, and then automating the repetitive pieces.

In my internships, I have built dashboards, improved workflows, and delivered automation that helps teams move faster with fewer manual steps.

3.8
GPA
5
Internships
2026
Graduation

Education

B.S. Information Technology

Florida State University

Minor: Business Administration

GPA: 3.8 May 2026

Where I've Worked

IT Automation and Workflow Intern

FSU Information Technology Services

September 2025 – Present

Automating SharePoint-based health checks and redesigning document workflows with Power Automate and Microsoft Lists to improve compliance visibility for ITS audits.

  • Automated the Backup OnBase system health checklist, cloning 40+ weekly records while dynamically updating "Check Date" and "Results" fields
  • Audited the ITS-EDM library (8,300+ files), identifying 33% redundancy and shaping a strategic migration roadmap for long-term SharePoint performance

Data & Process Improvement Intern

Miami-Dade Citizens' Independent Transportation Trust (CITT)

May 2025 – August 2025

Designed surtax compliance dashboards, publication-ready reports, and digital intake forms that streamlined municipal transit oversight.

  • Built a contract payment tracking workbook to monitor labor hours and costs against three active purchase orders
  • Authored and formatted the 90+ page Municipal Program report by consolidating data from 30+ municipalities

Cybersecurity Research Intern

Kenus Informática S.L.

September 2024 – December 2024 Valencia, Spain

Supported ENS certification preparation and bilingual documentation for Kenus Informática's security programs.

  • Assisted with compliance documentation for Spain's Esquema Nacional de Seguridad (ENS) certification
  • Supported the systems department in risk assessment and security policy documentation

IT Automation & Project Management Intern

Miami-Dade County (Strategic Procurement)

May 2024 – September 2024

Scaled portfolio management and QA tooling with Excel, SharePoint, and Monday Work Management to increase transparency across county IT initiatives.

  • Developed VBA scripts that automated regression test status updates, reducing manual effort by 20%
  • Created an Excel dashboard surfacing real-time regression test progress for PMO briefings

IT Privacy & Compliance Intern

FSU Information Security

September 2023 – May 2024

Supported enterprise privacy by aligning NIST cybersecurity controls with COSO frameworks, assessing third-party vendors, and refreshing university policy guidance.

  • Assisted in updating university policies and privacy standards in alignment with the NIST framework
  • Performed SOC 2 Type 2 vendor assessments covering 30 critical partners

Technologies I Work With

Programming

HTML & CSS
JavaScript
MySQL
Bash

Analytics & Tools

Power BI
Excel & VBA
Power Automate
SharePoint

Design

Figma

Recognition & Certifications

Academic Honors

  • Professor Gene T. Sherron Scholarship (2024)
  • Dean's List (multiple semesters)
  • HITEC Scholar (Hispanic Technology Executive Council)
  • Institute for Civic Engagement & Democracy Honors
  • Communicating with Confidence Award

Certifications

  • CompTIA ITF+ (June 2021)
  • Monday.com Training (June 2024)

Leadership

  • CARE Program Scholar
  • SSS‑STEM
  • Florida‑Georgia LSAMP

Featured Work

Automation Data Analysis PowerShell

Library Health Audit: Preservation & Strategic Roadmap

Result: Identified 33% redundant content and a migration path for 8,300+ files.

Problem: Slow, aging SharePoint libraries. Action: built a scalable PnP PowerShell audit and extraction framework.

My Role: Built the PowerShell audit framework, utilized Copilot for M365 for deep data analysis, and formulated the roadmap to resolve SharePoint performance bottlenecks.
Data Visualization UX Design

Municipal Program PTP Update (FY 2026–30)

Result: Delivered a board-approved FY 2026-30 municipal update used for planning.

Problem: fragmented city transit data. Action: consolidated 30+ municipal sources and redesigned reporting visuals.

My Role: Verified Excel data from 30+ municipalities, added new surtax/ridership metrics, and applied data visualization to make complex data accessible.
Excel Automation

Automated Regression Test Dashboard

Result: Reduced manual QA status updates by 20% for regression reporting.

Problem: manual test-status updates slowed release prep. Action: built a SharePoint-connected VBA dashboard for real-time visibility.

My Role: Authored the VBA automations, built the analytics views, and facilitated stakeholder demos to hand off the solution.

Mobility Matters – Empowering Transit Through Technology

In this interview with Miami-Dade County's Citizens' Independent Transportation Trust (CITT), I share my journey from Miami to FSU and how I contributed to improving local transit systems through data visualization and innovation.

Contact Me

I am currently available for and seeking Data Analyst, IT, or Automation roles starting May 2026.

Fastest way to reach me: Jimenezjohn2529@gmail.com

View Resume

Resume