Skip to content
AL

Hi, I'm

Andrey Dantas Lago

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

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.

profile.ts

const andrey = {

role: "Protheus Systems Analyst",

stack: ["Protheus", "ADVPL/TLPP", "TMS", "Oracle/SQL"],

founder: "Tiny Steps",

openToWork: true, // Open to new opportunities

}

Open to new opportunities

Get in touchWhatsAppLinkedInDownload CV (PDF)

Caxias do Sul, Brazil

2950 contributions on GitHub

@CODantas

Irapuru Transportes · Unimed Vale do Sinos · ProcData · TOTVS Protheus · Oracle · GLPI

Journey

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

IRA-2025-01Suite Irapuru

unification of 7 internal systems, in production, into a single platform, with single sign-on (SSO) and per-system/per-screen permission control.

IRA-2025-02Occupational Health and Safety System

management of periodic exams, PPE, workplace accident reports (CAT), safety dialogues (DDS), and inspections.

IRA-2025-03Freight document (CT-e) reconciliation

between the TMS and the ERP (Oracle database).

IRA-2025-04Financial 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.

IRA-2025-05Read-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.

Technical Projects

Projects

PRJ-01Open source · ADVPL + C++

RunSoundAdvpl

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.

Keywords: ADVPL · C++ · SmartClient

PRJ-02Shipper platform integration

Delivery Occurrence Integration (EDI)

Conceived and specified by me, implemented with AI assistance: 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.

Keywords: Python · Flask · REST API integration · Observability

PRJ-03Web application

Freight Table Conversion Tool

Conceived and specified by me, implemented with AI assistance: a web application for converting Excel spreadsheets into hierarchical CSV files compatible with a transportation management system (TMS), deployed in a Docker container.

Keywords: Node.js · Express · Docker

PRJ-04MVP · replacement for licensed legacy software

Document Digitization System

Conceived and specified by me, implemented with AI assistance: 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.

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

PRJ-05Founder · children's fashion e-commerce

Tiny Steps

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.

PRJ-06Web portal · IT management

Internal IT Team Portal

Conceived and specified by me, implemented with AI assistance: 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.

Keywords: Next.js · React · TypeScript · PostgreSQL · Drizzle

PRJ-07DevOps

Internal Systems Orchestration Monorepo

Conceived and specified by me, implemented with AI assistance: 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.

Keywords: Docker Compose · Independent containerized apps

PRJ-08Web utility

Email Server Diagnostic Tool (SMTP)

Conceived and specified by me, implemented with AI assistance: a web utility for testing and validating email-sending (SMTP) configurations used by an ERP system, with real-time feedback via streaming.

Keywords: Python · Flask · Server-Sent Events

Professional Services

Also taking on new projects — from diagnosis to delivery

If your company runs Protheus and needs a new routine, a TMS adjustment, or systems that actually talk to each other, I take it from diagnosis to delivery, always with direct technical validation. On web and integration projects, I specify and drive the implementation using AI-assisted tools, so you get speed without sacrificing quality.

Protheus Development (ADVPL/TLPP)

Routines the standard product doesn't cover, built to last. I develop in ADVPL/TLPP with MVC, entry points, TReport, REST web services, and dictionary compatibility scripts, and fix customizations that break in production.

Protheus TMS & Transport Tax Documents

For carriers on Protheus: support for TMS implementation and migration, CT-e, MDF-e, and CIOT (TSS and e-Frete), fiscal checks against the XML, and reconciliation between the legacy TMS and the ERP, with diagnosis straight in the database.

Systems Integration

No more exporting a spreadsheet from one system to import it into another. I connect Protheus to TMS platforms, APIs, EDI, and databases (Oracle, SQL Server), eliminating rework between platforms that don't talk to each other today.

Automation & Service Desk

Less manual rework, more time for your team to focus on what matters. Python and PowerShell scripts, Power Automate flows, and GLPI administration (forms, routing rules, and SLA).

Website Creation

Professional digital presence, from planning to launch. This site is proof: it was conceived and built with AI-assisted tools, the same methodology I offer you.

Let's talk about your project

Index

Skills

ERP & Development

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

Databases

  • Data modeling
  • Oracle
  • SQL Server
  • SQLite

Support & Service Desk

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

Automation & Integration

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

Data Analysis

  • DAX
  • ETL
  • Power BI

Methodology

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

Appendix

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