Skip to content
AL

Hi, I'm

Andrey Dantas Lago

Mid-level IT Analyst/TOTVS Protheus (TMS) & GLPI Support/SQL Server/Oracle · Python/Founder @Tiny Steps004 LAG

IT Analyst with experience in ERP systems, platform integration, and process automation in the logistics and healthcare sectors.

I work with TOTVS Protheus (TMS, back office, contracts, fiscal) and develop in ADVPL/TLPP. I write SQL queries (SQL Server and Oracle) and automate processes with Python, PowerShell, and Power Automate.

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.

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: "Mid-level IT Analyst",

stack: ["Protheus", "SQL", "Python", "GLPI"],

founder: "Tiny Steps",

openToWork: true, // Open to new opportunities

}

Open to new opportunities

Get in touchWhatsAppLinkedInDownload CV (PDF)

Caxias do Sul, Brazil

1722 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.
  • 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).
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.

Junior Systems Analyst — 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.

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-01Founder · 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-02MVP · 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-03Shipper 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-04Web 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-05DevOps

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-06Web 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-07Web 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 a process is slowing your team down, your systems don't talk to each other, or you need a site that actually converts, I take it from diagnosis to delivery. I plan, specify, and drive the implementation — using AI-assisted tools in the process — always with direct technical validation, so you get speed without sacrificing quality.

Process Automation

Less manual rework, more time for your team to focus on what matters. I replace repetitive tasks with Python and PowerShell scripts and Power Automate flows, integrated into your real workflow.

Website Creation

A professional digital presence, from planning to launch. This site, in fact, is the proof — built with the same methodology I offer you.

Systems Integration

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

ERP/GLPI Consulting

Implementation without the headache. Administration, configuration, and implementation support for the TOTVS Protheus ERP and the GLPI service desk platform, from someone who's done it in practice.

Let's talk about your project

Index

Skills

ERP & Development

  • ADVPL
  • MVC model
  • TLPP
  • TOTVS Protheus (TMS, back office, fiscal)

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