Alexandre Wanderer

A system to manage the distribution of raw materials (iron, oil, stone) into different plants to produce steel products. The system uses SQL Server and was integrated with schedule production systems. The main function was to plan the availability of raw materials on each power plant.

An international trade ERP in Oracle that helps companies to export/import goods worldwide. I worked as a product manager, database architect, and database administrator. Led the development team and helped to create the support team to assist customers in installing and using the system.

Remote system to collect information from harvesters (and other types of equipment) in farms and field operations around the world. Afterward, the information is sent to be analyzed in the company headquarters.
Several small databases in SQL Server were used in mobile equipment and the data was synchronized with a central database, and then analyzed by other systems.

Among all integrations I have already developed in Zapier, I worked on a chatbot integration for a webinar subscription. The solution allowed access to an API to make the reservation in the Webinarjam platform, capture the confirmation link, shorten the link, send it back to the customer and then schedule a series of reminders to be sent to users before the webinar. The integration with Zapier also allowed sending information to other platforms as a customized internal system, Google Sheets, and an email marketing platform.

I worked on an integration with precision scale application for a shoe factory laboratory to test the raw materials before using it in the factory. The application was developed in Visual Basic using direct communication with the scale through VB components.

I developed some complex data integration between spreadsheets and different systems using advanced VBA macros. The spreadsheets are connected to different database sources—namely SQL Server and Oracle—and are used both as source and destination data.

Business Intelligence platform for digital marketing projects.

I developed the extraction of data from Facebook, Google Ads (Display, Youtube, etc.). The data is loaded into a SQL Server database, transformed according to some specific business rules, and loaded into fact tables to be used by analytical tools.

I developed dashboards in PowerBI and Excel to provide information to the final users.

Tools used: SSIS, SQL Server, DAX functions, dimensional modeling (fact tables, dimensional tables), and pivots.

I led the design, development, and maintenance of multiple ETL pipelines that integrated external data from a variety of vendors, suppliers, and customers into Databricks, Azure Synapse, and Datasphere. By ensuring reliable, high-quality data ingestion, I enabled timely analytics and supported data-driven decision-making across the organization.

Led the migration of legacy data marts (SQL Server) to Databricks.

Key Achievements:
• Reduced sampling job runtime by introducing frequency-based scheduling and change-detection overrides.
• Cut compute costs by eliminating redundant sampling on low-activity tables and streamlining resource-intensive workflows.
• Improved data validation accuracy by applying smart rounding thresholds and multi-tiered match classification (MATCH, CLOSE_ENOUGH, MISMATCH).
• Consolidated 1,000+ SQL queries into logical clusters using AST normalization, CodeBERT embeddings, and graph-based join analysis — enabling refactoring and reuse.
• Cleaned up 500+ unused Databricks artifacts, freeing workspace resources and improving governance with automated reporting dashboards.
• Standardized migration processes, producing technical documentation, KPIs, and tooling enhancements adopted across other client projects.