Data Modeling Developer in San Diego, CA, United States

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.