Alexandre Wanderer, Data Modeling Developer in San Diego, CA, United States
Alexandre Wanderer

Data Modeling Developer in San Diego, CA, United States

Member since June 18, 2020
Alexandre is a database and data migration specialist, as well as a leader with over two decades of professional experience. He has worked for clients in industries like finance/trading and automotive, and his passion for software and technology drives his work ethic and development style.
Alexandre is now available for hire


  • Focalise Educational
    Microsoft Power BI, Business Intelligence (BI), SQL, SQL Server DBA...
  • Brivia Digital
    ETL, Microsoft SQL Server, Oracle, SQL, Databases, Data Engineering...
  • WBuild Technology
    Project Management, PL/SQL, SQL, Oracle RDBMS, Databases, Data Engineering...



San Diego, CA, United States



Preferred Environment

Database Architecture, ETL, Data Migration, Database Modeling, Database Administration (DBA), PL/SQL, SQL, Databases

The most amazing...

...project I've worked on is an online conference for trading automation with more than 30,000 attendees and a ROI of 900%.


  • Senior Database Developer

    2010 - 2019
    Focalise Educational
    • Developed data integration with the Brazilian stock market to generate stock prices for customers.
    • Created real-time data integration across multiple platforms using Zapier and Integromat.
    • Helped to achieve Return on investment (ROI) of 900% and 660% on an online conference for, on the first and second editions respectively.
    • Built the whole system to provide real-time information about the stock market to customers.
    • Implemented digital advertising campaigns for the lead generation, content creation, and sales funnels, generating thousands of leads and sales.
    • Managed content creation projects generating thousands of leads and sales on Facebook and YouTube.
    • Created sales funnels with high-quality content and offers, remarketing, one-on-one conversations via chatbot, email marketing, and CRM integration.
    • Developed a Business intelligence application combining information from Facebook Ads, Google Ads, and a third-party payment gateway. Used SQL Server database, SSAS, and SSIS, including cubes, measures, dimensions, DAX, MDX, and dimensional modeling.
    • Developed dashboards in Power BI for marketing and financial departments. The dashboards included the lead generation, top three traffic sources, top 10 ads, daily sales, investment in ads, and more.
    Technologies: Microsoft Power BI, Business Intelligence (BI), SQL, SQL Server DBA, Databases, Data Engineering, Data Pipelines, RDBMS, MySQL
  • Senior Database Architect

    2007 - 2019
    Brivia Digital
    • Developed systems for different segments like automotive, wine, shoes, and international trade.
    • Installed, managed, and administered dozens of databases in different clients at the same time.
    • Played a lead role in planning, testing, and development.
    • Worked as a Microsoft SQL and Oracle Database administrator tuning performance in different database sizes.
    • Developed data warehouses to integrate different data sources using ETL—SSIS.
    • Developed business intelligence applications and cubes (dimensions, pivot, measures).
    • Created dashboards in Microsoft PowerBI for sales, marketing, and production departments. Example dashboards included lead generation, weekly revenue, and top five revenue-generating customers.
    Technologies: ETL, Microsoft SQL Server, Oracle, SQL, Databases, Data Engineering, Data Pipelines, RDBMS
  • Founder/Software Engineer/Project Manager

    1999 - 2007
    WBuild Technology
    • Played a lead role in planning, testing, and development.
    • Managed commercial, financial, and production departments.
    • Managed information technology projects such as an international business ERP.
    • Executed research to study the competition and develop new products.
    Technologies: Project Management, PL/SQL, SQL, Oracle RDBMS, Databases, Data Engineering, Data Pipelines, RDBMS
  • SQL Developer

    1995 - 1999
    Azaleia Shoe Company
    • Led database design, administration, architecture, and SQL development.
    • Headed real-time data migration from different mobile systems to a centralized Oracle database.
    Technologies: Oracle Designer, Oracle Reports, Oracle Forms, Oracle RDBMS, SQL, Databases, Data Engineering, Data Pipelines, RDBMS


  • Steel Plant Production Management System | Gerdau, Inc.

    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.

  • International Trade ERP

    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.

  • Agriculture Equipment Tests | AGCO, Corp.

    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.

  • Zapier Integration

    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.

  • Visual Basic Scale Integration

    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.

  • BI Spreadsheets Integration

    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.

  • Marketing Business Intelligence - Focalise

    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.

  • Turn Chaos Into Profit: Understanding the ETL Process (Publication)
    ETL can consolidate data from various sources into an organized, reliable, and usable database. This allows businesses to employ previously unused or underused data to improve their performance. In this article, Toptal Data Modeling Developer Alexandre Wanderer demonstrates all stages of the ETL process in building a data warehouse.


  • Languages

    Visual Basic, Visual Basic for Applications (VBA), Excel VBA, SQL, MQL5, T-SQL, MDX, Python, PHP
  • Tools

    Microsoft Power BI, Google Analytics, Zapier, Facebook Ads Manager, Microsoft Excel, Shell, Oracle Forms, Oracle Reports, Oracle Designer
  • Paradigms

    Dimensional Modeling, OLAP, Business Intelligence (BI), Database Design, ETL
  • Platforms

    Oracle, Amazon Web Services (AWS), Linux
  • Storage

    Oracle SQL, Databases, MySQL, Azure SQL, SQL Server DBA, PostgreSQL, Database Architecture, Database Modeling, PL/SQL, Oracle PL/SQL, PL/SQL Developer, Data Integration, SQL Performance, SQL Server Integration Services (SSIS), Data Pipelines, RDBMS, SQL Server Analysis Services (SSAS), Database Administration (DBA), Microsoft SQL Server, Database Performance, Azure Queue, Oracle RDBMS
  • Other

    DAX, Multidimensional Expressions (MDX), Data Visualization, Facebook Ads, ActiveCampaign, Lead Generation, Facebook Video Ads, Facebook Banner Ads, Digital Advertising, Performance Tuning, Data Modeling, Database Optimization, CSV, Excel Expert, Data Engineering, Data Handling, Finance, Data, CSV File Processing, Oracle Performance Tuning, Data Migration
  • Industry Expertise

    Project Management


  • Doctorate Degree in International Business
    2019 - 2020
    San Diego University for Integrative Studies - San Diego, CA, USA
  • Master's Degree in International Business
    2015 - 2018
    Southern States University - San Diego, CA, USA
  • Bachelor's Degree in Computer Science
    1995 - 2000
    Universidade Feevale - Novo Hamburgo, RS, Brazil

To view more profiles

Join Toptal
Share it with others