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

Data Modeling Developer in San Diego, CA, United States

Member since November 22, 2019
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

Portfolio

Experience

Location

San Diego, CA, United States

Availability

Part-time

Preferred Environment

Database Architecture, ETL, Data Migration, Database Modeling, Database Administration, 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%.

Employment

  • Senior Database Developer

    2010 - 2019
    Focalise Educational
    • Developed data integration with the Brazilian stock market to generate stock prices to customers.
    • Created real-time data integration across multiple platforms using Zapier and Integromat.
    • Helped to achieve an ROI of 900% and 660% on the online conference (www.conarobo.com.br) on the first and second editions, respectively.
    • Created the whole system to provide real-time information about the stock market to customers.
    • Developed digital advertising campaigns for 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 (chatbot), and email marketing/CRM integration.
    • Developed a business Intelligence application joining information from Facebook Ads, Google Ads, and a third-party payment gateway. Used SQL Server database, SSAS/SSIS (cubes, measures, dimensions), DAX, MDX, and dimensional modeling.
    • Developed dashboards in Power BI for marketing and financial departments. 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
  • 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
  • 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
  • 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

Experience

  • Steel Plant Production Management System | Gerdau, Inc. (Development)

    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 (Development)

    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. (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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.

Skills

  • 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, 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, SQL Azure, SQL Server DBA, PostgreSQL, Database Architecture, Database Modeling, PL/SQL, Oracle PL/SQL, PL/SQL Developer, Data Integration, SQL Developer, SQL Performance, SQL Server Integration Services (SSIS), MySQL, SQL Server Analysis Services (SSAS), Database Administration (DBA), Microsoft SQL Server, Database Performance, Database Administration, Databases, 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, Oracle Performance Tuning, Data Migration
  • Industry Expertise

    Project Management

Education

  • 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