Andrey Dantas Lago

Andrey Dantas Lago

Protheus Systems Analyst · ADVPL/TLPP · TMS & Back Office · Oracle/SQL · GLPI · Founder @Tiny Steps

Caxias do Sul, Brazil(54) 99917-8275dantas.andrey@gmail.comlinkedin.com/in/codantasgithub.com/CODantas

TOTVS Protheus systems analyst focused on logistics and transportation, with prior experience in the healthcare sector. I develop ADVPL/TLPP routines, support the TMS and back office, and work with Brazilian transport tax documents (CT-e, MDF-e, CIOT).

In Protheus, I cover TMS, back office, contracts, and fiscal; in development, MVC, TReport, entry points, and REST web services. I write SQL queries (SQL Server and Oracle) and automate processes with Python, PowerShell, and Power Automate.

At Irapuru Transportes, a 24/7 transportation group with 2 companies and 28 branches, I followed the Protheus implementation end to end: configuration alongside TOTVS and the consulting partners, user training, go-live, and support. After go-live, I put 20 ADVPL/TLPP routines into production and owned the systems side of moving one group company's TMS to Protheus.

I translate business needs from a wide range of areas into functional technical solutions, depending on what the company needs. This includes administering the service desk platform (GLPI) and diagnosing root causes directly in the database.

I use AI in a structured way every day: connectors that give AI assistants read-only, auditable access to the ERP and the TMS for incident diagnosis, and internal platforms that I conceive and specify, with AI-assisted implementation.

Alongside this, I founded and launched Tiny Steps (tinysteps.com.br), a children's fashion e-commerce with an AI chatbot, dropshipping, and integrated payments. I took it from scratch to a live product, using AI as an implementation tool.

Professional Experience

Mid-level IT Analyst — Irapuru Transportes

Apr 2025 — present

Caxias do Sul, RS

ERP Administration & Support

  • In-house lead for TOTVS Protheus ERP administration during its implementation phase, working alongside the consulting partners across all areas of the system: back office, contracts, TMS (transportation management), fleet, and fiscal books.
  • Handling daily system demands, including generating and customizing routines and reports.
  • Configuration and restructuring of the GLPI ticketing platform, with 21 company units registered, custom forms, and automated classification and routing rules; about 700 tickets handled personally.
  • More than 100 support cases driven with TOTVS, from diagnosis to resolution.
  • Bulk correction of the fiscal bookkeeping of 12,606 CT-e (electronic freight documents).
  • Root-cause diagnosis directly in the Oracle database for TMS module defects and the electronic NF-e (e-invoice) import flow, delivering technical workarounds.
  • Execution of the monthly fiscal close (entry-blocking parameterization by branch).
  • Support for TMS satellite systems (user administration) and management of the Silt WMS (warehouse management system).
  • Process automation with Python and PowerShell; access permission management per information security policy.
  • Support for managing Microsoft 365 tools and building Power Automate automations (e.g., a purchase request flow with two-level approval, integrated with Teams and Outlook); support for creating GPOs in Active Directory (Windows Server).

Protheus Development (ADVPL/TLPP)

  • 20 ADVPL/TLPP routines in production, including shipping volume labels printed on Zebra, delivery receipt protocol and filing, CIOT integration with e-Frete, fiscal checking of CT-e against the XML, a TSS digital certificate hub, and TReport reports.
  • Owned the systems side of moving one group company's TMS from the legacy system to Protheus TMS: new routines, branch-level access control during the transition, and close follow-up of operations in the first weeks.

Platforms conceived — own specification, AI-assisted implementation

  • Suite Irapuru — unification of 7 internal systems, in production, into a single platform, with single sign-on (SSO) and per-system/per-screen permission control.
  • Occupational Health and Safety System — management of periodic exams, PPE, workplace accident reports (CAT), safety dialogues (DDS), and inspections.
  • Freight document (CT-e) reconciliation — between the TMS and the ERP (Oracle database).
  • Financial export portal — automates exporting accounts payable/receivable from the TMS to the ERP's import layout, with an indicator dashboard; includes diagnosing and fixing a file-corruption bug caused by concurrent writes to the user registry.
  • Read-only connectors (Model Context Protocol) giving AI assistants auditable access to the ERP and the TMS for fast incident diagnosis.

Junior Systems Analyst (Protheus) — Unimed Vale do Sinos

Sep 2024 — Apr 2025

Novo Hamburgo, RS

  • Development and maintenance of ADVPL/TLPP solutions (MVC model), with a focus on security and regulatory compliance for the healthcare sector.
  • Gathering, detailing, and analysis of medium-complexity software requirements with end users.
  • Execution of manual and automated tests (unit testing fundamentals).
  • Code versioning (TortoiseSVN) and technical documentation.

ADVPL/TLPP Developer & Data Analyst — ProcData

Sep 2023 — Aug 2024

Caxias do Sul, RS

  • ADVPL/TLPP development in the MVC model and construction of REST web services for system integration.
  • Writing SQL queries (Oracle) for reports and data requests; data model design and optimization.
  • Management of release deployment and migration; application of ERP updates.
  • Unit testing and versioning via Git; technical documentation.
  • Building Power BI dashboards (ETL, advanced modeling, DAX measures, KPIs) for activity management and management accounting.

Projects

Conceived and specified by me, implemented with AI assistance, except where noted.

RunSoundAdvpl — Open source · ADVPL + C++

Developed by me: an ADVPL class that plays sounds and music in Protheus through a C++ DLL loaded by SmartClient, with no .bat workaround. Open source on GitHub, with a usage example.

ADVPL · C++ · SmartClient

Delivery Occurrence Integration (EDI) — Shipper platform integration

A Python EDI integration service (parsing market-standard layout files) with automatic submission to a shipper platform's API, including a monitoring dashboard, email alerts, backoff retries, and execution as a Windows/Linux service. Validated in a staging environment.

Python · Flask · REST API integration · Observability

Freight Table Conversion Tool — Web application

A web application for converting Excel spreadsheets into hierarchical CSV files compatible with a transportation management system (TMS), deployed in a Docker container.

Node.js · Express · Docker

Document Digitization System — MVP · replacement for licensed legacy software

An MVP of an in-house electronic fiscal document digitization system, aimed at eliminating per-machine/per-user licensing costs from a third-party solution, with a barcode (QR) reading engine, image processing, and PDF generation with metadata, corporate SSO, full audit trail, and tracking of the 5-year legal retention period.

Java 21 · Spring Boot 3 · Angular · OpenCV · Apache PDFBox · ZXing · H2 · Oracle (read-only) · JWT/SSO

Tiny Steps — Founder · children's fashion e-commerce

I conceived and launched it from scratch to production: an AI chatbot for customer service, dropshipping (AliExpress), and integrated payments. I used AI as an implementation tool, focusing on product vision and customer experience.

Internal IT Team Portal — Web portal · IT management

An internal portal for the IT team with a task backlog (owners, deadlines, checklists, and rescheduling history), team chat, link and server monitoring with email alerts, announcements, and an indicator dashboard integrated with the ticketing platform.

Next.js · React · TypeScript · PostgreSQL · Drizzle

Internal Systems Orchestration Monorepo — DevOps

Consolidation of multiple internal systems (previously independent repositories) into a monorepo with Docker Compose, preserving Git history, container/port/database isolation, and shared SSO — simplifying deployment and maintenance of the entire IT stack.

Docker Compose · Independent containerized apps

Email Server Diagnostic Tool (SMTP) — Web utility

A web utility for testing and validating email-sending (SMTP) configurations used by an ERP system, with real-time feedback via streaming.

Python · Flask · Server-Sent Events

Skills

ERP & Development

  • TOTVS Protheus (TMS, back office, fiscal)
  • ADVPL
  • TLPP
  • MVC model
  • TReport
  • Entry points
  • REST web services
  • TSS (CT-e, MDF-e, NF-e)
  • CIOT (e-Frete)

Databases

  • Oracle
  • SQL Server
  • SQLite
  • Data modeling

Support & Service Desk

  • GLPI (administration)
  • Formcreator & workflows
  • SLA configuration
  • Profiles & permissions
  • Active Directory (GPO)

Automation & Integration

  • Python
  • PowerShell
  • Power Automate
  • Microsoft 365
  • REST APIs
  • Microsoft Graph API
  • Git

Data Analysis

  • Power BI
  • DAX
  • ETL

Methodology

  • Unit testing
  • Git / SVN
  • Technical documentation
  • OOP

Education

Associate Degree in Data Science, Data Processing

UNINTER Centro Universitário Internacional

Feb 2024 — paused in the first semester

Mechatronics Technician

SENAI-RS

Jul 2012 — Jul 2014

Languages

Portuguese (Native) · Spanish (Basic) · English (Basic)