Francisco Gasperini
PT EN
Florianópolis · Brazil

Full-stack developer
and data analyst.

I work with TypeScript, React, Node.js and PostgreSQL, from the data model to deployment. Three of my own projects are live, and the largest one runs on its own domain.

See projects Download résumé
github.com/gasperinifr LinkedIn franciscogasperini@gmail.com
Portrait of Francisco Gasperini
Core stack
TypeScript React Node.js PostgreSQL Python Supabase TailwindCSS Docker
About

Who I am

I am from Florianópolis, Brazil. I hold a technical diploma in Software Development from SENAI/SC and I am currently studying Information Technology Management at IFSC, where I am in the fourth of six terms.

I work with the Quality department at Instituto Santé as a data analyst. I automated the weekly routine that consolidates patient safety indicators, which now runs with no manual intervention, and I wrote the operations manual so the department team could take the routine over.

Outside of work I keep three of my own projects in production: Lexiona, Lorekeeper and CSVision. All solo, from the database to the interface. I document architecture and processes so that operations never depend on a single person.

I am looking for a development or data role where I can contribute to production systems and keep growing technically alongside the team.

At a glance
Current role
Data Analyst, internship

Instituto Santé · Bewiki Care, Quality department

Education
Information Technology Management

IFSC · 4th of 6 terms · graduating Dec 2027

Live projects
Three, all solo

Lexiona, Lorekeeper and CSVision

Languages
Portuguese native · English C1

TOEIC Bridge 93/100, ETS Global · Brazilian citizen

Skills

What I use

Technologies I have used in my own projects or at work, not in tutorials.

Frontend

Interfaces in React with TypeScript, server state with TanStack Query and accessibility built into the structure.

React TypeScript Next.js Vite TailwindCSS TanStack Query

Backend

Custom APIs in Node and Python, JWT authentication and serverless functions in Deno.

Node.js Fastify Deno FastAPI Python JWT

Data

Relational modeling, complex queries and security enforced in the database rather than in the UI.

PostgreSQL Supabase MySQL SQL & modeling Row Level Security PL/pgSQL

Applied AI

Language models in production, with quotas, automatic model failover and human validation wherever the decision matters.

Groq Gemini Whisper Vision models Resumable jobs

DevOps

Continuous deployment from GitHub, containers and media storage.

Git CI/CD Docker Vercel Fly.io AWS S3

Data & management

The work side, in the Quality department: indicators, spreadsheets, automation and documentation.

Advanced Excel Google Apps Script Workspace APIs Tasy HIS KPIs Documentation
Experience

Where I have worked

Instituto Santé · Bewiki Care

Current
Data Analyst, internship · Quality & Patient Safety department
Aug 2026 — Present · Florianópolis, Brazil

I audit quality and patient safety records, flag inconsistencies and consolidate the KPIs tracked by management. I automated the weekly routine that consolidates and delivers these indicators, now running unattended, with batch processing, failure handling, API quota control and automated tests. I integrated large language models into the triage of inconsistent records, with mandatory human validation before any decision. I documented the architecture and wrote the operations manual, handing the routine over to the department team.

Data analysisAutomationGoogle Apps ScriptLLMsTasy HISDocumentation

Federal Institute of Santa Catarina

Funded research fellow · Organizing committee, National Science & Technology Week 2025
Sep 2025 — Dec 2025 · Florianópolis, Brazil

Supported the coordination of Brazil's National Science & Technology Week, covering activity planning, schedule management and registration control. I built the event's interactive web map, used by attendees to locate activities across the campus. Liaised with internal teams, allocated resources and tracked deliverables.

Project managementWeb developmentPlanningTeamwork
Projects

What I have built

Three of my own products running in production, and one system built at the request of a department at IFSC.

Main project

Lexiona

In production Solo project

A lesson planning platform for teachers. The teacher registers the academic term, the classes and each course's timetable, and the system generates the whole semester of lessons already laid out on the calendar, skipping holidays. Every lesson carries a plan, attendance and history.

Five AI agents read the syllabus from PDF, Word, image or audio and generate the lesson plans, suggest alternative approaches, discuss the course and replan whatever content is still pending. All of them receive the class's actual history as context.

Concept, product, design and development are mine, from the database to the interface. Free end to end: every service it uses has a permanent free tier, and the system was designed to fit inside them.

React 18 TypeScript PostgreSQL Supabase Deno Groq TailwindCSS PWA
Visit lexiona.org
Highlights
  • The calendar is the product: a course timetable becomes a full semester of lessons, with movable holidays computed rather than typed in.
  • Five AI agents that work from the course's real history, not from a generic prompt.
  • Isolation between teachers is enforced inside the database, by Row Level Security, not by the interface.
  • Accessibility built into the structure: theming, high contrast, density, text scaling from 80% to 160% and full keyboard navigation.
  • Installable PWA, on its own domain.
In production Solo project

Lorekeeper

End-to-end platform for running tabletop RPG campaigns. Characters, NPCs, locations, items, events and narrative in a single system, for game masters and players. AI content generation with automatic model failover when a provider fails, an interactive relationship graph between the entities of the world, real-time chat, an event timeline and D&D 5e content import. Custom Fastify API with JWT authentication and S3 media uploads.

React TypeScript Fastify PostgreSQL AWS S3 Docker
Live demo Repository
In production Solo project

CSVision

Turns a spreadsheet into a dashboard. Users drag and drop a CSV, a language model identifies the role of each column, and the app builds interactive, customizable charts on its own. The CSV parser was written from scratch in TypeScript, and the whole analysis runs in the browser: only metadata reaches the server, so the spreadsheet never leaves the user's machine.

Next.js 14 TypeScript Supabase Groq Recharts
Live demo Repository
Commissioned

DPPE Dashboards

System that automatically generates dashboards from the CSV spreadsheets of the DPPE department at IFSC's Florianópolis campus, built at the department's request. It replaces the manual chart-building done for every new file, with aggregation functions written in PL/pgSQL inside Postgres and a React presentation layer.

React TypeScript PostgreSQL PL/pgSQL Supabase
Repository
Other public work

SNCT 2025 Map

Interactive web map of the campus, used by attendees to find the activities of Brazil's National Science & Technology Week. Built during the research fellowship at IFSC.

Open the map

Indicators Dashboard Manual

Operations documentation for the weekly indicators routine at Instituto Santé, written so the Quality department team could take it over without depending on me.

Read the manual

EcoPraia

Web application built by a team, about waste collection on the beaches of Florianópolis. Problem-based learning project for the Technical Diploma in Software Development, in 2024.

Repository
Certifications

Courses and exams

ETS Global

TOEIC Bridge · Listening & Reading

May 2024
93/100 · English C1
CISCO Networking Academy

Python Essentials 1

2023
CISCO Networking Academy

Introduction to Cybersecurity

2023
Cubos Academy

UX/UI Design short course

2023
Education

My background

2025 — Present

Information Technology Management

Federal Institute of Santa Catarina · Florianópolis · 2,200h applied undergraduate degree · 4th of 6 terms · expected graduation Dec 2027

DevelopmentProgramming Logic · Object-Oriented Programming · Web Programming I & II · Software Development Processes
DataDatabases · Business Statistics · Human-Computer Interaction
IT ManagementProject Management · IT Strategy & Planning · Process Modeling · Knowledge Management · Decision Making
InfrastructureNetwork Infrastructure & Management · Network Operating Systems · Infrastructure Virtualization
UpcomingData Science · ICT Governance · Information Security · Knowledge Modeling · Capstone Thesis
2022 — 2024

Technical Diploma in Software Development

SENAI/SC · Florianópolis · concurrent with the High School Diploma · 1,112h of technical training

DevelopmentProgramming Logic · Systems Development · Application Programming
Software EngineeringSystems Modeling · Software Testing · Deployment & Maintenance
Data & FundamentalsDatabases · Computational Logic · IT Fundamentals
InfrastructureComputer Networking Fundamentals · Internet of Things · Applied Electronics
Contact

Let's talk

I am open to opportunities in development and data.Reach me through any channel.

E-mail
franciscogasperini@gmail.com LinkedIn
linkedin.com/in/francisco-gasperini GitHub
github.com/gasperinifr Résumé · EN
English version (PDF) Résumé · PT
Portuguese version (PDF)