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

Oracle Database, SQL, PL/SQL, Database Administration, Database Architect, Database Modeling, Data Migration, ETL

The most amazing...

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

Employment

  • Senior Database Developer

    2010 - PRESENT
    Focalise Educational
    • Developed data integration with the Brazilian stock market to generate stock prices to customers.
    • Created real-time data integrations across multiple platforms using Zapier and Integromat.
    • Helped to achieve an ROI of 900% and 660% on the online conference (www.conarobo.com.br) first and the second edition 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.
    Technologies: Oracle Databases, SQL
  • 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 Oracle Database Administrator and Tuning Performance in different database sizes.
    • Developed data warehouses to integrate different data sources using ETL - SSIS.
    Technologies: Oracle, SQL Server, ETL
  • 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 International Business ERP.
    • Executed research to study the competition and develop new products.
    Technologies: Oracle Databases, SQL, PL/SQL, Project Management
  • 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 Databases, Oracle Forms, Oracle Reports, Oracle Designer

Experience

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

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

  • International Trade ERP (Development)

    An international trade ERP (Oracle) to help companies to export/import goods worldwide. Worked as a product manager, database architect, and database administrator. Led the development team and helps to create the support team to help customers to install and use 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, and send them to be analyzed in the company headquarters.

    Several small databases (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)

    I already developed many integrations in Zapier. One of the projects was the integration of a chatbot where the customer subscribed in a webinar, and in Zapier I had to access an API to make the reservation in Webinarjam platform, capture the confirmation link, shorten the link, send it back to the customer and then schedule a series of reminders until the webinar starts. Besides it, the Zapier integration sends information to other platforms as a customized internal system, Google Sheets and e-mail marketing platform.

  • 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

    SQL, MQL5, T-SQL, PHP
  • Tools

    Zapier, Facebook Ads Manager, Shell
  • Paradigms

    Database Design, ETL
  • Platforms

    Oracle, Linux
  • Storage

    PostgreSQL, Database Architecture, Database Modeling, PL/SQL, Oracle PL/SQL, PL/SQL Developer, Data Integration, SQL Developer, SQL Performance, SQL Server Integration Services (SSIS), Database Administration (DBA), Microsoft SQL Server, Database Performance, Database Administration
  • Other

    Facebook Ads, ActiveCampaign, Lead Generation, Facebook Video Ads, Facebook Banner Ads, Digital Advertising, Performance Tuning, Data Modeling, Database Optimization, Oracle Performance Tuning
  • 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