Work
Automation, integrations and operational systems.
Production systems and case studies organized by operational domain. Most source code is private.
Fiscal Operations
SPED parsing, fiscal reconciliation, NFSe processing, government portal integration and tax data validation.
SPED Cross-Check Automation
Reduced up to 3 hours of manual work per analyst per day. Reconciliation that previously required manual collection across multiple sources now runs automatically.
Parses SPED tax files, collects complementary fiscal data from government portals, cross-validates multiple datasets, and generates Excel reconciliation reports — replacing a repetitive daily manual process.
NFSe Processing Pipeline
Eliminated per-company manual portal access for invoice retrieval. Documents are organized and ready for reconciliation without human intervention.
Accesses government portals to retrieve NFSe XML documents, organizes files by company and period, extracts invoice data, and generates audit-ready reports for reconciliation workflows.
SPED Fiscal Analytics Engine
Transforms SPED files into actionable analytics in seconds: revenue breakdown, ICMS exposure, top products, gross margin.
Parses Brazilian SPED EFD ICMS/IPI fiscal files and surfaces revenue, tax, gross margin and product analytics through a real-time BI dashboard — transforming raw text files into structured business intelligence.
Accounting Operations
Payroll-to-accounting mapping, journal entry generation, configurable exports and accounting system integration.
Payroll Accounting Mapper
Eliminated hours of monthly manual mapping per company. Accounting rules are centralized and reusable instead of scattered across analyst spreadsheets. Export format is configurable and adaptable to different accounting systems.
Reads payroll Excel reports, applies a configurable de-para mapping per company and cost center, resolves debit/credit GL accounts through a priority-based engine, and exports journal entries ready to import into accounting systems.
Consolidated Export Generator
Removed a full manual data-entry step from the monthly accounting workflow. Exports are generated automatically with correct grouping and formatting.
Generates consolidated accounting exports grouped by economic group, including tax entries and summary totals — formatted for direct import into accounting systems. Eliminates manual preparation, consolidation and data entry across the client portfolio.
Labor Operations
Payroll validation, labor compliance verification, tax deposit tracking and monthly operational workflows.
Payroll Validation & Analytics
Reduced repetitive review work. Validation outputs are consistent and centralized across the client portfolio instead of distributed across analyst files.
Combines Python payroll validation workflows with web dashboards that compare system results against rule-based calculations — replacing monthly spreadsheet-heavy review with centralized operational visibility.
Labor Compliance Tracker
Replaced spreadsheet-based monthly conference of labor compliance data. Verification status is visible per company per month with full traceability.
Web application that manages monthly labor compliance verification across client portfolios — tracking FGTS deposits, tax withholding, social security contributions, and labor obligation checkpoints per company per month. Auto-loads client lists and provides structured conference workflows.
Corporate & Compliance
Digital certificate management, permit monitoring, operational dashboards and compliance tracking.
Internal Operations Platform
Replaced per-company manual portal access and spreadsheet tracking with centralized dashboards. Certificate compliance moved from a manually-updated spreadsheet to continuous automated monitoring with expiration alerting.
Internal platform consolidating certificate compliance monitoring, NFSe document retrieval through government APIs, operational dashboards from legacy database data, and permit/CND status tracking — all under a unified authorization layer with read-only integration to a legacy database.
Digital Certificate Management
Replaced a manually-updated spreadsheet with continuous automated monitoring. The compliance team sees certificate status and risk at a glance without accessing raw data.
Scans environments for digital certificates, extracts X.509 metadata, validates expiry, stores credentials with AES-256-GCM encryption, and surfaces risk and status through operational dashboards with alerting.
Permit & CND Monitoring
Replaced per-company manual portal checks with a centralized monitoring system. Status history and document organization are automatic instead of dependent on individual effort.
Consults government portals to check operating permit and fiscal clearance status across all managed companies. Registers results with history, downloads available documents, and provides centralized visibility through an operational dashboard.
Production work is private by default. Case studies describe real systems with specifics generalized. Reach out to discuss any project in detail.