WS Willian Soncini

Resume in English

resume_en.md

Senior Data Engineer

Senior Data Engineer with 7+ years of experience building data platforms, analytics automation, integrations, and internal tools for corporate and multinational environments.

Python AWS SAP HANA Redshift Analytics Automation
Download PDF Ver currículo em português
7+

years across data, automation, and platforms

70%

approximate AWS cost reduction

122+

forecast spreadsheets consolidated for Agrichem

90%+

Cockpit dashboard performance gain

Professional Summary

Senior Data Engineer with 7+ years of experience building data platforms, analytics automation, integrations, and internal tools for corporate and multinational environments. Hands-on background with Python, SQL, AWS Glue, Athena, Redshift, S3, SAP HANA, BODS, Airflow, and Power BI, plus the ability to ship APIs and data-facing applications with FastAPI, Node.js, and React when the product requires it. Proven record in cost optimization, performance gains, and automation of business-critical workflows, with full professional English proficiency.

Key Achievements

  • Helped reduce AWS costs by approximately 70% through refactoring, retiring legacy flows, and strategically migrating workloads to SAP HANA and BODS.
  • Automate Agrichem’s forecast campaign, consolidating 122+ spreadsheets and reconciling projections with current and historical revenue data.
  • Build a data warehouse for Agrichem from scratch, with landing/raw layers in S3 queried via Athena and refined/trusted layers in Redshift.
  • Delivered commercial and analytics solutions that contributed to a revenue increase from R$ 220M to R$ 240M at Safra Rica.
  • Created and optimized the executive Cockpit report, the company’s main leadership dashboard, with a 90%+ performance gain.

Technical Skills

  • Data Platforms: AWS Glue, Athena, Redshift, S3, Airflow, Spark, BODS, SAP HANA, ETL/ELT, Data Warehouse.
  • Languages: Python, SQL, JavaScript, TypeScript, Dart.
  • Backend & APIs: FastAPI, Django, Flask, Node.js, Express, REST APIs, corporate integrations.
  • Applications & Analytics: React, Next.js, Power BI, Power Automate, SharePoint, React Native, Flutter.
  • Infrastructure & AI: Docker, Terraform, GitHub Actions, Linux, Zabbix, Grafana, OpenAI API, ElevenLabs, Amazon SageMaker.

Professional Experience

Nutrien Ag Solutions

Senior IT Analyst | Data Engineering, Automation & Full Stack
Apr/2023 - Present | Monte Azul Paulista, São Paulo, Brazil
Promoted from IT Analyst to Senior IT Analyst in 2026.

  • Built Agrichem’s data warehouse with landing/raw layers in S3, Athena queries, and refined/trusted layers in Redshift for analytics consumption and materialized consolidated views.
  • Automated Agrichem’s forecast campaign, including generation, collection, and consolidation of 122+ spreadsheets cross-referenced with current and historical revenue data.
  • Maintained and optimized hundreds of ETL jobs using Airflow, AWS Glue, Redshift, Athena, S3, SAP HANA, and BODS, helping reduce AWS costs by approximately 70%.
  • Automated paginated REST API integrations (Agrometrika, SAAM) and parallel Oracle extraction routines in Python, powering Power BI reports and 30+ daily automated reports.
  • Built a sales approval web application using React, FastAPI, and MySQL, including email-based authentication and traceability.
  • Worked on data migration and modernization initiatives (Azure -> SAP HANA, Data Factory -> BODS, Firebird -> Oracle), including view, procedure, and trigger conversion plus Power Automate and SharePoint workflows.

Safra Rica Agribusiness

IT Analyst | Data Engineering, Web Systems & Infrastructure
Nov/2018 - Apr/2023 | Monte Azul Paulista, São Paulo, Brazil
Promoted from IT Assistant to IT Analyst in 2022.

  • Developed web systems for market pricing and sales budgeting using Node.js, React, and PostgreSQL.
  • Contributed directly to revenue growth from R$ 220M to R$ 240M through commercial tooling and data analysis.
  • Built a MySQL data warehouse with Python ETLs and cronjobs, consolidating data from 60+ views.
  • Created the Cockpit report, the company’s main executive dashboard, with a 90%+ performance gain.
  • Delivered 80+ custom reports in Python/SQL, automated ERP routines with PyAutoGUI, and administered Linux/Windows servers with Zabbix and Grafana.

Infojet Soluções

IT Assistant | 2018

  • Delivered technical support, equipment maintenance, system installation, and support for administrative and sales routines.

Selected Project

AI-Powered English Learning Platform

  • Building an English learning platform with AI conversation, shadowing, grammar training, and guided practice.
  • Integrating OpenAI and ElevenLabs for voice features and conversational interaction.

Education

Bachelor’s Degree in Information Systems
Centro Universitário Unifafibe - Bebedouro, São Paulo, Brazil
2018 - 2021

Relevant Training & Certifications

Additional courses and certificates are available on LinkedIn.

Languages

  • Portuguese: Native or Bilingual
  • English: Full Professional Proficiency