Experience

From sales to Business Intelligence

From sales to the public sector, I apply data analysis, Power BI, and ETL pipelines to turn operational routines into management KPIs.

Evolution

Progression by phase

Each stage added a capability to the same goal: measure better, reduce manual work, and deliver reliable information.

  1. Phase 01Business foundation

    Marketing and commercial operations

    Reading sales, customers, stock, and commercial indicators before the technical layer.

    • Indicators
    • Reports
    • Excel

    Evidence: Palácio das Baterias, an official Moura distributor: sales KPIs, management reports, and Trade Marketing.

  2. Phase 02Organizational data

    Compensation and Budget Management

    Consolidation of workforce records, hiring budget, and financial impact analysis.

    • Budget
    • Workforce analysis
    • Management reports

    Evidence: Jaboatão dos Guararapes City Hall: salary structures, budget, and compliance.

  3. Phase 03KPIs and dashboards

    Public-Sector Data and Business Intelligence

    Modeling, DAX measures, and Power BI dashboards to track revenue and fiscal indicators.

    • Power BI
    • DAX
    • Power Query

    Evidence: Jaboatão dos Guararapes Municipal Treasury Department and the Public Revenue Intelligence Platform case.

  4. Phase 04Data and routines

    Automation and ETL

    SQL queries, Python ETL routines, and dataset standardization to reduce manual consolidation.

    • SQL
    • Python
    • Pandas

    Evidence: Python Automation Operational Intelligence

  5. Phase 05Mar 2026 — Oct 2026

    People Management Data

    Hiring and staffing datasets, workforce KPIs, and management reports for workforce planning.

    • Power BI
    • KPIs
    • Data quality

    Evidence: RM Terceirização, assigned to the Municipal Department of Education of Jaboatão dos Guararapes.

  6. Phase 06Current work

    Analytics Products and Development

    MVP and data-oriented solution development with Next.js, TypeScript, Git, and GitHub.

    • Next.js
    • TypeScript
    • Git

    Evidence: Horizon, a UNIFG extension project, and the case studies published in this portfolio.

Professional work

Roles and outcomes

Responsibilities and outcomes across People Management, public administration, data, Business Intelligence, commercial operations, and technology infrastructure.

Horizon - UNIFG University Extension Project

Developer | University Extension Project

Feb 2026 — PresentJaboatão dos Guararapes
  • Collaborate on MVPs and technology solutions in a team environment similar to a startup.
  • Use Git and GitHub for version control and collaboration across the project team.
  • Take part in activities and ceremonies organized with Scrum and Kanban.
RM Terceirização - Personnel and Human Resources Consulting

Administrative Support | Data Analysis, BI, and People Analytics

Mar 2026 — Oct 2026assigned to the Municipal Department of Education of Jaboatão dos Guararapes
  • Structured and maintained the centralized database of contracted professionals in the municipal school network, integrating hiring, staffing, and school-unit distribution data into a single source of truth.
  • Implemented data standardization, validation, and inconsistency handling routines (data quality), increasing the reliability of the information behind hiring and reassignment decisions.
  • Built and maintained Power BI dashboards, with Power Query (ETL) and DAX measures, to monitor KPIs for vacancies, staffing, staff shortages, and hiring needs by unit.
  • Monitored the hiring cap and the evolution of personnel expenses, producing control indicators aligned with the Fiscal Responsibility Law (LRF).
  • Produced management reports and workforce planning analyses, supporting demand prioritization and data-driven decision-making.
Jaboatão dos Guararapes City Hall

IT Infrastructure Support Intern

Feb 2026 — Mar 2026Jaboatão dos Guararapes
  • Handled and resolved hardware, software, and connectivity tickets, logging and following up on each request.
  • Performed preventive and corrective maintenance on computers and equipment.
  • Supported LAN networks, structured cabling, and fault diagnosis (troubleshooting).
Jaboatão dos Guararapes City Hall - Municipal Treasury Department

Data Analysis | Business Intelligence Intern

Jan 2025 — Feb 2026Jaboatão dos Guararapes
  • Led the migration of management reports from Excel to Power BI, replacing manual refreshes and email distribution with dashboards published on Power BI Service, with centralized, real-time access on web and Power BI Mobile.
  • Eliminated operational rework and reduced the risk of manual errors by centralizing fiscal indicators in a single, up-to-date source for managers.
  • Built DAX measures and dashboards to monitor tax revenue KPIs, track targets, analyze seasonality, and compare periods.
  • Built ETL pipelines with Power Query and Python (Pandas) automations for data extraction, cleaning, consolidation, and refresh.
  • Ran SQL queries and exploratory data analysis (EDA) to identify trends, inconsistencies, and anomalies in revenue collection.
  • Communicated results to managers and multidisciplinary teams through stakeholder reporting, supporting data-driven fiscal management.
Jaboatão dos Guararapes City Hall

Job and Salary Analyst | Workforce Budget and Fiscal Compliance

Nov 2017 — Jun 2019Jaboatão dos Guararapes
  • Reported personnel expenses to the State Court of Accounts, ensuring the consistency, traceability, and legal compliance of the information.
  • Prepared budget and financial impact studies and scenario simulations for public examinations, fixed-term selection processes, and salary-floor adjustments, advising the Executive Secretary and the legal department.
  • Monitored the personnel expense limits of the Fiscal Responsibility Law (LRF), anticipating the risk of exceeding them and proposing alternative hiring and adjustment scenarios.
  • Analyzed workforce data and position, career, and compensation structures to identify distortions and support workforce planning.
Palácio das Baterias - Official Moura Distributor

Commercial and Trade Marketing Assistant | Commercial Intelligence and Budget Management

Jan 2014 — Mar 2017Recife, PE
  • Updated sales and revenue KPIs daily, giving leadership continuous visibility into monthly targets in an operation with more than 300,000 batteries sold (automotive, motorcycle, heavy-duty, marine, and UPS).
  • Extracted and prepared sales, order, customer portfolio, and promotional stock data from the Datasul (TOTVS) ERP and CRM, with advanced Excel analysis and data integrity checks.
  • Fully managed an annual marketing budget above R$ 300,000: planning, allocation, execution control, and spend monitoring.
  • Structured, with sales reps and supervisors, negotiations that standardized more than 50 auto repair shops to the Moura visual standard in exchange for higher monthly purchase volume.

See this experience applied in projects

The case studies detail problems, technical decisions, and demonstrable outcomes across data, automation, and web applications.