Guilherme O.
Data Engineer

Skills

Sql

Sas

Databricks

Microsoft Excel (Advanced Analytics Add-ons)

Python

Amazon Aws

Google Cloud

Guilherme is available for hire

Meet Guilherme O.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Economist with a profound interest in data analytics since 2012, possessing a unique combination of economics and data analysis expertise. This skillset facilitates the effective fulfillment of technological requirements with a deep comprehension of business operations, thereby optimizing data utilization.

Database Management Consultant
1/1/2022 - Present

Developed and maintained databases while performing extensive data analysis to support various business areas. Utilized SSIS for efficient data ETLs and leveraged Python for task automation. Ensured the continuous functionality and relevance of business intelligence by maintaining Power BI dashboards.
BI Analyst
7/1/2021 - 1/1/2022

Executed development and data analysis for various business areas, with a focus on maintaining data loads using cloud tools such as Google Cloud Platform (GCP) and Amazon Web Services (AWS). Played a pivotal role in a data governance project, overseeing and completing the documentation of metadata, processes, and data dictionaries. Produced visual data presentations utilizing PowerBI, showcasing insights and trends effectively.
Data Analyst
12/1/2020 - 7/1/2021

Responsible for driving innovation and technology in data analytics for hydrometry, leveraging cloud tools from the Azure suite to facilitate the presentation of key performance indicators to partners and investors. Developed expertise in big data analysis using Databricks, creating insightful analytics on hydrometry gains. Demonstrated proficiency in presenting data through Redash and PowerBI, ensuring clear and actionable insights for stakeholders.
MIS Analyst
5/1/2019 - 10/1/2020

Analyzed and developed fraud KPIs, focusing on monitoring and projecting accounting results. Conducted studies and formulated strategies for fraud prevention. Automated processes and ETLs using Python, VBA, SQL, and SAS to enhance efficiency. Structured and implemented a robust database architecture by transitioning from Access and manual Excel reports to SQL Server, encompassing implementation, documentation, and training phases.
Senior MIS Analyst
8/1/2017 - 4/1/2019

Developed proficiency in creating indicators for collection planning and management dashboards. Automated various processes to enhance efficiency. Demonstrated strong expertise in data governance and process mapping within the relevant area. Utilized advanced tools and frameworks to support these initiatives and ensure seamless operations.
MIS Analyst
8/1/2014 - 12/1/2015

Gained expertise in database extraction and manipulation using SQL Server. Demonstrated the ability to create and maintain comprehensive management reports. Developed and implemented effective collection campaigns and incentives for operational use. Conducted in-depth studies and portfolio analysis to generate valuable insights for decision-making.