Senior Database Developer
2010 - 2019Focalise 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 www.conarobo.com.br, 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 DBASenior Database Architect
2007 - 2019Brivia 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, OracleFounder/Software Engineer/Project Manager
1999 - 2007WBuild 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 RDBMSSQL Developer
1995 - 1999Azaleia 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