Analytics Engineer · Data & AI Systems · BR → CA

Engineering the pipelines, agents, and dashboards behind executive decisions.

Five years inside the engineering and technology division of a major telecom operator, building the data systems that managers, directors, and C-level leaders bet capital and headcount on. Now extending that practice into AI agents — the next interface for analytics.

5yrs
Senior data work
1.5M+
Customers served
6
Active certifications
2027
NBCC, New Brunswick
§01 · Brief

Senior data work,
built to be used.

I work as a Senior Data Analyst / Analytics Engineer inside the engineering and technology division of a major telecommunications operator. My remit covers the full data lifecycle — extraction, lakehouse, warehouse, gold semantic layer, and the Power BI surfaces leadership actually opens on a Monday morning.

The systems I build are not exploratory notebooks. They are decision infrastructure: the source of truth that managers, directors, and executives use to allocate capital, prioritize work, and steer the network.

More recently I've moved into AI agents — designing the retrieval, planning, and tool-use patterns that put the same data behind a conversational interface. I am relocating to Canada in 2027 to study at NBCC and build my career there.

§02 · Practice

Two disciplines,
one substrate.

The data platform is the same. What changes is the interface — a dashboard for a director, an agent for a field technician.

P.01 — Analytics Engineering

The pipeline from raw signal to executive dashboard.

End-to-end medallion architectures in the Microsoft Fabric and Databricks stack: source extraction, bronze landing, silver conformance, gold semantic modeling, and the Power BI report layer the business actually consumes.

  • Microsoft Fabric · Lakehouse, Warehouse, Eventhouse
  • Databricks · PySpark transformations, Delta Lake
  • Power BI · DAX, semantic modeling, governed report layer
  • Power Platform · Automate, Apps, Pages
P.02 — AI Agents

The same data, behind a conversational interface.

Building agents that decompose business questions, retrieve from governed semantic layers, call tools against operational systems, and return executive-ready answers. Grounded, auditable, and bound to the same data contracts as the dashboards.

  • Azure AI Foundry · Copilot Studio · Semantic Kernel
  • Multi-agent orchestration · planner / retriever / narrator patterns
  • RAG over Fabric OneLake and governed Power BI semantic models
  • Tool use against operational APIs and warehouses
§03 · Selected Work · 2025

Selected work.
The decisions it unlocked.

On anonymization Projects in this catalog are anonymized under NDA. Architectures, technologies, and patterns are accurate to the work delivered. Client and system identifiers are abstracted; reported figures reflect real outcomes, rounded where needed.
P-01 / 2025

Division-Wide Data & KPI Restructuring

Telecom · Engineering & Operations · Governance lead

A newly formed analytics division inherited a fragmented landscape: strategic B2B KPIs tracked in Excel, multiple dashboards reporting the same metric with conflicting numbers, unauthorized data sources, and redundant copy-pipelines inflating cost. Hand-picked by the incoming executive to lead the rebuild, end to end.

Microsoft Fabric Dataflows Gen2 T-SQL DAX Power BI Data Governance
BEFORE · fragmented MySQL · unapproved Databricks Fabric · ad hoc OneDrive files duplicate pipelines conflicting numbers B2B KPIs in Excel GOVERNANCE GATE access revoked · team-only dev UNIFIED DATA LAKE · Fabric 4 CRMs · network health · field ops · sales · churn · budget · targets BRONZE raw landed SILVER conformed dedup GOLD business aligned Data flows all ETL here · no PQ in report transformation in T-SQL · minimal DAX · lean semantic model · optimized cost single source of truth CONSUMPTION Unified Power BI report built from scratch · one home for every division KPI company visual standards KPIs · productivity · early & recurring faults · service SLA · Wi-Fi churn · backlog days · quality · full B2B suite Governance layer standards doc · dev guidelines help-desk request workflow DATA SOURCES 4 → 1 governed lake SOURCE CRMs 4 · unified ETL B2B KPIs Excel → scalable BI SCOPE All territories · MG · SUL · SP · CO · B2B
FIG · P-01 Fragmented sources behind a governance gate → unified Fabric lake on medallion architecture → one governed report, with standards and a request workflow to hold the line.
1.5M+
Customers in the
operation served
700+
Technicians & supervisors
measured by these KPIs
100+
Active users on the
unified report
4 → 1
Data sources unified
into one governed lake
P-02 / 2025

Reliability & Productivity Analytics · FTTX Maintenance

Telecom · FTTX Network Maintenance & POP Infrastructure

Leadership ran network maintenance with no reliable instrumentation. KPIs lived in Excel with no shared definitions, so every executive, manager, and supervisor read the same metric differently — and the source system's database was too poorly structured to trust. Built from scratch, the first real measurement these teams ever had.

Microsoft Fabric Medallion Dataflows Gen2 T-SQL Power BI Geospatial
SOURCE CRM database poorly structured hard to interpret never in BI/cloud PIPELINE · Fabric medallion Lake → Lakehouse → Bronze · Silver · Gold → Dataflows built from scratch KPI criteria defined with exec mgmt one shared definition OPERATIONAL MEASUREMENT · first ever MTTD mean time to dispatch team MTTR mean time to resolution Network downtime mean duration · frequency Affected customers per incident · scale Productivity technician & team output + network downtime · incident counts · quality measures INSIGHT · unlocked NOC efficiency first-ever view of how fast the Network Ops Center detects an incident & routes it to the field Geographic incident map clusters of large-scale incidents made visible by location → justified major capital investment in FTTX network construction & repair Power BI report company visual standards · exec · manager · supervisor views BUILT From scratch · CRM → BI RELIABILITY KPIs MTTD · MTTR · downtime FIELD ORG MEASURED 100+ techs · 5 mgrs · 1 exec OUTCOME Insight → FTTX investment
FIG · P-02 An unusable CRM database rebuilt into a reliability-measurement engine — MTTD, MTTR, downtime — surfacing NOC efficiency and geographic incident clusters that justified capital investment in the network.
MTTD · MTTR
Core reliability KPIs
instrumented for the first time
NOC
Detection-to-dispatch
efficiency made measurable
FTTX capex
Incident-cluster insight
justified network investment
scratch → BI
CRM to governed report,
built end to end
§04 · Stack

An index
of the tools.

01 Data Platform
  • Microsoft Fabric daily
  • OneLake · Lakehouse · Warehouse daily
  • Databricks · Delta Lake weekly
  • Eventhouse · KQL monthly
02 Languages
  • SQL · T-SQL · KQL daily
  • Python · PySpark daily
  • DAX daily
  • M (Power Query) weekly
03 Analytics & ML
  • Power BI Premium · semantic models daily
  • MLflow · model registry weekly
  • scikit-learn · XGBoost weekly
  • Power BI Paginated Reports monthly
04 AI Agents
  • Azure AI Foundry active
  • Copilot Studio active
  • Semantic Kernel · LangGraph active
  • Azure OpenAI · embeddings active
05 Automation
  • Power Automate daily
  • Power Apps weekly
  • Azure DevOps · Git daily
  • Fabric Data Pipelines daily
06 Method
  • Medallion architecture default
  • Data contracts · governed semantic layer default
  • Lean Six Sigma in training
  • Stakeholder & executive comms continuous
§05 · Trajectory

From the operator,
to New Brunswick.

A deliberate path. Senior data work, then certifications that match the next decade of the field, then formal study in Canada.

2022 — Present

Senior Data Analyst / Analytics Engineer

Engineering & Technology division of a major telecommunications operator. End-to-end ownership from raw data to executive consumption.

2024 — Present

Specialization · AI Agents

Hands-on projects building grounded, multi-agent systems over the same governed data layer. Production deployments in field operations and internal analytics.

2027 →

NBCC · Information Technology: Business & Advanced Analytics

New Brunswick Community College, Canada. Formal pathway into the Canadian market, leading toward permanent residency.

Certifications
Certified · verifiable
AZ-900
Microsoft Certified: Azure Fundamentals Verify credential
Certified
Roadmap · 2026 – 2027
DP-600
Fabric Analytics Engineer Associate
In progress
DP-700
Fabric Data Engineer Associate
In progress
AB-620
AI Agent Builder Associate
In progress
LSS
Lean Six Sigma · Green Belt
In progress
AB-730
AI Business Professional
Planned
AB-731
AI Transformation Leader
Planned
AI-300
Designing & Implementing AI Solutions
Planned
§06 · Contact

If the brief sounds right, let's talk.

Email
contact@gustavoresende.com
LinkedIn
linkedin.com/in/gustavo-resende
Based
Brazil · relocating to Canada, 2027