Lucas Rollin Ferreira

About

I'm a Civil Engineer graduated from UFSC (GPA 8.8/10.0) with a specialization in Full-Stack Web Development and Data Analysis. I build web applications with Django, HTMX, AlpineJS and Tailwind CSS, automate workflows with Python and Google Apps Script, and design strategic dashboards with Power BI.

I currently work as a Civil Engineer at ARESC, where I develop internal web applications, automate data collection and processing routines, cutting operational time by 40%, and build dashboards for regulatory indicator monitoring.

Throughout my career I have also worked at SCGÁS in market intelligence and geospatial analysis, and at D'Campos Construtora, managing planning and control across 4 vertical construction projects (~12,000 m²). I am a native Portuguese speaker, fluent in English (C2), and hold all five Harvard CS50 certifications: CS50x, CS50P, CS50 SQL, CS50W and CS50AI.

Experience

DEC 2024 — PRESENT

Civil Engineer · ARESC

Regulation, inspection and process management in the state infrastructure sector. I develop internal web applications with Django, HTMX, AlpineJS and Tailwind CSS; automate data collection and processing routines with Python and Google Apps Script, reducing operational time by 40%; and build Power BI dashboards for regulatory indicator monitoring.

Python | Django
HTMX
AlpineJS
Tailwind CSS
Apps Script
Power BI
Data Analysis

NOV 2024 — FEB 2026

Full-Stack Developer & Cost Estimator · Freelance

Built a web application for civil engineering cost estimation using Django, Vanilla JavaScript and SQL, including database modeling for cost inputs and unit price compositions. Delivered strategic dashboards and custom automations for clients across different industries.

Django | Python
JavaScript
SQL
Power BI
Cost Estimation

SEP 2023 — JUL 2024

Planning & Market Intelligence Intern · SCGÁS

Created Power BI dashboards to analyze the piped gas project portfolio; mapped and optimized project management processes using BPMN (Bizagi); and conducted geospatial and statistical studies with QGIS to identify potential customers and support strategic decisions.

Power BI
Advanced Excel
QGIS
Bizagi (BPMN)
Data Analysis

APR 2022 — JUL 2023

Planning & Civil Engineering Intern · D'Campos Construtora

Monitored 4 vertical construction projects (~12,000 m²), controlling schedule, quality and quantities. Prepared physical schedules in MS Project, tracked materials via Sienge ERP, and developed quality manuals and service verification checklists (FVS) to standardize construction quality.

MS Project
Advanced Excel
Sienge ERP
AutoCAD
Quality Management

Projects

Costplan

Web application for civil engineering project cost estimation, enabling the creation of Unit Price Spreadsheets (UPS) based on predefined cost compositions and a structured input database.

Django | Python
JavaScript
SQL
HTML
SCSS
Cost Estimation

Hardplan

Web application for construction project scheduling with algorithms including the Critical Path Method (CPM) and Line of Balance (LOB).

Flask | Python
SQL
JavaScript
Scheduling

Hardplan ERP

Relational database supporting the core features of an ERP system for construction companies: projects, inputs, suppliers, contracts and cost control.

SQL
Data Modeling
Construction

Budgetpy

Python CLI tool for calculating civil construction project costs using SINAPI data, with support for cost compositions and exportable report generation.

Python
CLI
SINAPI
Cost Estimation