Profile

Wagner Silva

Software Engineer | Cloud Architect | Data Engineer

7+ of Pragmatic Software & Data Engineering - Scalable Cloud Solutions, Proven Impact
LisbonStockholm
PAUSED

Portfolio At a Glance

7+ Years Across Stack
Software Engineering
System design, APIs, databases, DevOps - from concept to production
6+ Years on Google Cloud
GCP Specialist
BigQuery, Cloud Run, Cloud SQL, GKE, Vertex AI, and the whole stack of services
€48K+ Annual Value Delivered
Cost Savings
Infrastructure optimization
Global Scale
Enterprise
Production systems across EMEA, APAC, Americas

Skills

Hard Skills

GCPCloud VPCKubernetes (GKE)DockerTerraformLinuxCloud RunCloud FunctionsGCECI/CDDevOpsBigQueryDatastream (CDC)Pub/SubCloud StorageDataflowETL/ELT PipelinesData WarehousingPostgreSQLMySQLAlloyDBCloud SQLFirestoreBigtableMemorystore (Redis)Neo4jQdrantMongoDBPythonTypeScriptJavaScript/Node.jsSQLReactReact NativeAngularNext.jsVertex AIGemini ModelsRAG SystemsVector EmbeddingsLLMsREST APIsAPI Gateway (APISIX)Third-party IntegrationsSFTPLooker StudioGrafanaData VisualizationCloud IAPSSOCrowdsecIAMPrometheusCloud MonitoringCloud LoggingSRE PracticesSystem DesignArchitecture PatternsMicroservicesServerlessEvent-Driven ArchitectureCost OptimizationJiraConfluenceAgile

Soft Skills

Technical LeadershipTeam CollaborationConsensus BuildingTechnical WritingDocumentationTranslating Technical to Non-TechnicalMultilingual (PT, EN, ES, learning DE & SV)System ThinkingCreative SolutionsTroubleshootingRoot Cause AnalysisAdaptabilityPragmatic ApproachCost-Conscious MindsetQuality FocusAttention to DetailSelf-MotivatedEmpathyPatienceActive ListeningCultural SensitivityProfessional Integrity
Each project taught me something new. I'm not done learning.

Modern Productivity Tools

Claude Code
Claude Code
OpenAI Codex
OpenAI Codex
Google Gemini Code Assist
Google Gemini Code Assist
Warp AI
Warp AI

PROJECT #1 - PAGE BUILDER PLATFORM

Global Self-Service Website Platform for Solar Industry Leader

Context & Overview

  • A worldwide solar panel company needed to empower 3rd-party installers with professional websites.
  • Installers lacked technical skills, requiring a zero-code, self-service solution.
  • Platform needed to support global operations (EMEA, APAC, Americas) and maintain brand consistency.

Challenge

  • Enable non-technical installers to create websites instantly
  • Support global operations with localization
  • Handle file uploads & deploy without manual intervention

Solution

  • React-based drag-and-drop page builder with real-time preview
  • Node.js/TypeScript API on Cloud Run for backend logic
  • Automated one-click deployment pipeline to global CDN

Impact ⭐

  • Global B2B platform serving hundreds of installers
  • Zero-touch website creation (minutes vs weeks)
  • Complete full-stack ownership (UI + API + Infra)
ReactTypeScriptNode.jsCloud RunCloud SQLBigQuery
PAUSED

PROJECT #2 - ENTERPRISE RAG + AI AGENTS

Organization-Wide AI Platform

Context & Overview

  • Organization needed cost-effective, secure AI access for employees.
  • Individual subscriptions were too expensive and insecure.
  • Required access to internal company documents with role-based security.

Challenge

  • Reduce costs vs individual AI subscriptions
  • Ensure 100% data security (no external leakage)
  • Implement role-based access to sensitive documents

Solution

  • Multi-database RAG (Qdrant, Neo4j, Postgres)
  • GKE microservices with Vertex AI (Gemini) integration
  • Cloud IAP for seamless Google Workspace SSO

Impact ⭐

  • Significant cost reduction vs individual subscriptions
  • Highly customizable and extensible for internal needs
  • Sub-2 second response times with high security
PythonTypeScriptFastAPItRPCNeo4jPostgreSQLQdrantMeilisearchMinIOVertex AIGKE
PAUSED

PROJECT #3 - TRI-DIRECTIONAL REAL-TIME SYNC

Salesforce, Internal DB, TalentLMS

Context & Overview

  • Global solar company needed to sync data across Salesforce, TalentLMS, and internal systems.
  • Manual entry was causing errors and wasting 20+ hours/week.
  • Required conflict resolution for simultaneous updates across time zones.

Challenge

  • Keep 3 systems in perfect sync with bidirectional flow
  • Handle concurrent updates & conflicts across time zones
  • Process 15,000+ records daily with <5 min latency

Solution

  • TypeScript orchestration engine on Cloud Run Jobs
  • Conflict detection logic with priority rules
  • Firestore collection tracking update history with before/after state snapshots

Impact ⭐

  • Single source of truth across all platforms
  • 20+ hours/week saved from manual data entry
  • 99.9% sync success rate with auto-recovery
TypeScriptCloud Run JobsSalesforce APITalentLMS APIFirestoreREST
PAUSED

PROJECT #4 - GCP COST OPTIMIZATION

€15K Annual Savings

Context & Overview

  • GCP costs were rising 30% YoY, threatening sustainability.
  • No visibility into per-app costs - resources lacked proper labeling.
  • Goal: Create a cost-conscious engineering culture.

Challenge

  • Reduce rising GCP costs without performance degradation
  • Track costs per application (Storage, VMs, Cloud Run, Cloud Run Jobs)
  • Establish measurable, repeatable optimization processes

Solution

  • Implemented resource labeling across all GCP services for cost allocation
  • dbt for billing data modeling & attribution
  • Artifact Registry cleanup, storage class optimization, log ingestion reduction
  • CPU/RAM right-sizing & Committed Use Discounts (CUDs) where appropriate

Impact ⭐

  • €15,000 annual savings (30% reduction)
  • Full cost visibility per application via billing labels
  • Established automated cost monitoring & alerts
RedisBigQuerydbtCloud MonitoringTerraform

Actions Taken

Resource Labeling

  • Labels on Storage buckets, VMs, Cloud Run
  • Cloud Run Jobs, Cloud SQL tagged by app
  • dbt models for cost attribution
  • Cost allocation reports per application
  • Billing exports to BigQuery for analysis

Resource Cleanup

  • Artifact Registry: Auto-delete old images
  • Buckets: Correct storage class per use case
  • Reduced unnecessary log ingestion
  • Eliminated orphaned resources

Right-Sizing

  • CPU/RAM optimization across services
  • Cloud SQL instance tier reduction
  • GKE node pool autoscaling
  • Dev environments: Spot VMs

Strategic Purchases

  • Committed Use Discounts (CUDs)
  • Reserved capacity where predictable
  • Storage class lifecycle policies
  • BigQuery slot reservations
PAUSED

PROJECT #5 - ROW-LEVEL SECURITY SYSTEM

Secure Public Reporting

Context & Overview

  • Client needed to embed Looker Studio reports in a customer portal.
  • Requirement: Public access (no Google login) but with strict data isolation.
  • Each customer must ONLY see their own data.

Challenge

  • Publicly accessible reports with row-level security
  • No Google account login allowed for end-users
  • Scalable to thousands of concurrent users

Solution

  • Python reverse proxy injecting JWT-based secrets
  • BigQuery views with row-level filtering based on secrets
  • Seamless integration with customer portal auth

Impact ⭐

  • Secure public reporting with zero data exposure
  • Seamless user experience (no login friction)
  • Scalable to thousands of concurrent users
PythonCloud RunLooker StudioBigQueryJWT
PAUSED

PROJECT #6 - REUSABLE SFTP ARCHITECTURE

Zero Data Loss for Global Clients

Context & Overview

  • Global electronics companies needed to sync financial product data.
  • Zero data loss tolerance for payment/rebate information.
  • Opportunity to build a reusable architecture for multiple clients.

Challenge

  • Zero data loss tolerance (financial/payment data)
  • Multiple global clients with similar SFTP needs
  • Complex cross-infrastructure connectivity

Solution

  • Reusable Python SFTP client library (config-driven)
  • Cloud Run Jobs + Dataflow for validation & processing
  • Comprehensive validation pipelines (row counts, checksums)

Impact ⭐

  • ZERO data loss on financial records
  • 70% faster development for subsequent clients
  • Reusable architecture deployed for multiple global clients
PythonSFTPCloud Run JobsDataflowBigQueryVPC ConnectorCloud NAT
PAUSED

PROJECT #7 - SMART API INTEGRATION

Pascom PBX Analytics

Context & Overview

  • Call center needed real-time analytics from Pascom PBX.
  • API was severely limited: no filtering, no pagination, returned ALL data.
  • Needed frequent syncs without duplicating data or overloading API.

Challenge

  • Work around severe API limitations (no filter/pagination)
  • Process 10K+ records frequently without duplicates
  • Minimize BigQuery costs and API load

Solution

  • Python sync job with local timestamp filtering
  • Hash-based deduplication to identify new records
  • Efficient delta loading to BigQuery
  • BigQuery metadata table for load audit and tracking

Impact ⭐

  • Real-time analytics operational (15-30 min freshness)
  • 99.5% data processing efficiency
  • 80% reduced BigQuery insert costs
PythonCloud Run JobsCloud SchedulerBigQuery
PAUSED

PROJECT #8 - CI/CD PIPELINE MIGRATION

Jenkins to Cloud Build

Context & Overview

  • On-premises Jenkins was becoming a bottleneck and maintenance burden.
  • 120+ different builds running in production alone.
  • Needed cloud-native solution with better scalability and reliability.

Challenge

  • Migrate 120+ production builds from on-prem Jenkins to Cloud Build
  • Maintain zero downtime during migration
  • Ensure consistency across dev, staging, and production environments

Solution

  • Phased migration from Jenkins to Cloud Build
  • Docker containerization for all apps
  • Infrastructure as Code (Terraform) for provisioning

Impact ⭐

  • Successfully migrated 120+ builds to cloud-native CI/CD
  • Eliminated on-prem Jenkins maintenance overhead
  • Improved scalability and developer productivity
Cloud BuildDockerTerraformJenkinsCI/CDDevOps
PAUSED

PROJECT #9 - APISIX API GATEWAY

Enterprise Security at Zero Cost

Context & Overview

  • Cloud Armor costs (€36K/yr) were unsustainable.
  • Needed equivalent DDoS protection and WAF capabilities.
  • Required better observability for SRE teams.

Challenge

  • Replace expensive Cloud Armor without compromising security
  • Improve observability and SRE capabilities
  • Ensure zero downtime during migration

Solution

  • Open-source APISIX Gateway on GCE Managed Groups
  • Crowdsec integration for community threat intelligence
  • Prometheus/Grafana for deep observability

Impact ⭐

  • €36,000 annual savings (100% cost reduction)
  • Enhanced security with real-time community intel
  • 10x improvement in observability metrics
APISIXCrowdsecGCEMIGPrometheusGrafana
PAUSED

PROJECT #10 - REAL-TIME CDC PIPELINE

ZNUNY/OTRS Analytics

Context & Overview

  • Support team needed real-time analytics from operational MySQL DBs.
  • Direct querying was not an option due to performance impact.
  • Strict data minimization requirements for PII.

Challenge

  • Real-time analytics from operational databases
  • Data minimization (only replicate needed fields)
  • Zero performance impact on production systems

Solution

  • Datastream CDC for near-zero latency replication
  • dbt for data modeling, testing, and documentation
  • Real-time transformation in BigQuery

Impact ⭐

  • Real-time support metrics with sub-second latency
  • Enhanced data governance (less PII replicated)
  • 60% reduced data transfer costs
MySQLDatastreamBigQuerydbtLooker Studio
PAUSED

PROJECT #11 - ON-DEMAND DATABASE ANONYMIZATION

Safe Development & Testing with Production-Quality Data

Context & Overview

  • Developers need fresh, realistic data on-demand.
  • Cannot expose production PII/sensitive data.
  • Need ability to refresh environments whenever needed.

Challenge

  • Developers need fresh, realistic data on-demand
  • Cannot expose production PII/sensitive data
  • Need ability to refresh environments whenever needed

Solution

  • On-demand snapshot and anonymization tool (manual trigger)
  • Python-based PII masking maintaining referential integrity
  • Creates new VM, validates, pauses old VM, transfers static IP to new VM
  • Old VM kept available until pending schema changes are complete

Impact ⭐

  • High-quality testing with realistic, fresh data
  • Full data security compliance with zero PII exposure
  • Fast environment provisioning (< 2 hours for full refresh)
PythonSQLCloud SQLCloud StorageFirewallGCETerraform
PAUSED

PROJECT #12 - TECHNICAL LEADERSHIP

SharePoint Communication Site from Ground Zero

Context & Overview

  • Global conservation foundation with 100K+ users worldwide needed a communication site.
  • No existing structure - built entirely from ground zero.
  • Required coordination across stakeholders, designers, and content teams.

Challenge

  • Build complete SharePoint communication site from scratch
  • Understand user behavior through stakeholder interviews
  • Coordinate content workflow with communications team and designer

Solution

  • Led stakeholder interviews to understand user needs and behavior
  • Defined content workflow with communications team for site map
  • Collaborated with designer on UI/UX, iterated with content team
  • Power BI reports and data automation for dynamic virtual hub sections

Impact ⭐

  • Complete communication site delivered from concept to launch
  • Data-driven sections powered by Power BI automation
  • Improved international collaboration and content management
SharePointPower BIPower AutomateMicrosoft 365

Actions Taken

Discovery & Planning

  • Stakeholder interviews to understand user behavior
  • Defined site map and information architecture
  • Content workflow with communications team
  • Iterative design process with UI/UX designer

Technical Delivery

  • SharePoint communication site architecture
  • Power BI reports for dynamic sections
  • Data automation driving virtual hub content
  • Power Automate workflows for content updates

Stakeholder Coordination

  • Foundation executive team
  • Communications and content team
  • In-house UI/UX designer from my team
  • IT team coordination

Leadership Skills Applied

  • End-to-end project ownership
  • Cross-functional team facilitation
  • Iterative feedback loops with all teams
  • Translating requirements to technical solutions
PAUSED

PROJECT #13 - INTERACTIVE PORTFOLIO SYSTEM

Data-Driven Presentation Platform with AI Narration

Context & Overview

  • Traditional portfolios are static PDFs that fail to showcase technical depth and personality.
  • Recruiters spend seconds scanning resumes - needed an engaging, memorable format.
  • Wanted to demonstrate full-stack skills through the portfolio itself (meta-project).

Challenge

  • Build a presentation system that exports to professional PDF format
  • Integrate AI voice narration for each project slide
  • Create reusable data-driven architecture for multiple presentation variants

Solution

  • Next.js 15 with TypeScript - data-driven slide generation from structured JSON
  • Gemini AI integration for TL;DR summaries & voice narration
  • Multi-layout system (9 layouts) with Mermaid diagrams & ReactFlow visualizations

Impact ⭐

  • Self-referential: The portfolio showcases the skills used to build it
  • AI-powered: Gemini generates project summaries and narration on-demand
  • Production-ready: Deployed on Cloud Run with automated CI/CD via Cloud Build
Next.js 15ReactTypeScriptTailwind CSSCloud RunGemini AIMermaid

Core Strengths & Highlights

Zero
Data Loss
Financial & sensitive data
Security
First
RLS, IAP, PII masking
€15K+
Cost Savings
Efficient architectures
Reusable
Patterns
Libraries at scale
Complex
Integrations
Tri-sync, API workarounds
AI/ML
Innovation
RAG, Vertex AI, LLMs
100K+
Global Scale
Users worldwide
End-to-End
Ownership
Interviews to production

Why Stockholm?

This isn't just a job change - it's a life decision I've already committed to.

Career Growth

Deep GCP specialization and engineering in Europe's leading tech ecosystem

Cultural Fit

Swedish values - pragmatism, honesty, work-life balance - align with how I work

Long-Term Commitment

I need work permit sponsorship, but this isn't short-term. I'm relocating my life to Stockholm, not just taking a job.

By sponsoring this move, you're not just filling a role - you're enabling a career transition I've planned deliberately. I'm ready to invest years here.

Logistics & Next Steps

Lisbon
Current Location
Ready to move
Visa
Status
Need Swedish work permit
ASAP
Start Date
Flexible / Remote start
Swedish Ribbon

Thank You

Wagner Silva
Software Engineer | Cloud Architect | Data Engineer

PAUSED