Simera Professional Key (SPK)

Guilherme G

Paraguay

Data Engineer

$ 1,900/month

6 yrs exp

Skills

  • Docker
  • ETL
  • Git
  • GitHub
  • Microsoft SQL Server Integration Services (SSIS)
  • PostgreSQL
  • Python
  • Spark
  • SQL
  • Tableau
  • Terraform
  • Typescript
  • AirFlow
  • Bash Script
  • BigQuery
  • Data Engineer
  • Notion
  • Oracle
  • Phyton
  • Power BI
  • Pyspark
  • HTML/CSS
  • Python/R

Guilherme G

Paraguay

Data Engineer

$ 1,900 /month

6 yrs exp

Intro Video

Skills

  • Docker
  • ETL
  • Git
  • GitHub
  • Microsoft SQL Server Integration Services (SSIS)
  • PostgreSQL
  • Python
  • Spark
  • SQL
  • Tableau
  • Terraform
  • Typescript
  • AirFlow
  • Bash Script
  • BigQuery
  • Data Engineer
  • Notion
  • Oracle
  • Phyton
  • Power BI
  • Pyspark
  • HTML/CSS
  • Python/R

Data Engineer

Millicom (Tigo)
July 2023 - present

Deployed custom python code on a linux server to do data ingestion from REST APIs. Managed over 548 monthly KPIs. Led the migration of over 23 dashboards from tableau to powerBI. Implemented Documentation in my team by building a documentation webpage using docusarus, nodejs, types-cript. Implemented devops best practices by introducing Docker containers and Git version control and CI/CD pipelines

Data Analyst

Itau Unibanco
May 2022 - December 2022

In my previous role as a Data Analyst at Itau Unibanco Holding, I played a pivotal role in establishing a data-driven culture within the loans department. I implemented technical tools to make data consumption and analysis more manageable and effective. Prior to my tenure, the team relied on manual data compilation from Excel reports across various areas of the bank. However, upon joining, I implemented a SQL to PowerBI dashboarding system that allowed for weekly and monthly automation. I also developed and implemented stored procedures to retrieve data for ad-hoc reports efficiently. Additionally, I utilized Python, linear algebra, and descriptive statistics for exploratory analysis of unknown data. To streamline processes, I introduced ETL data pipelines and leveraged Airflow for orchestration. Moreover, I created a VBA application for calculating loans, resulting in the development of 23 variations deployed throughout Paraguay, which are still in use today. Tasks: • Data Analysis • Data Visualization • Data Cleaning • Data Modeling • Data Collection • Data Quality assurance • SQL • Python for data science (pandas, numpy, matplotlib) • PowerBI • ETL data pipelines • SQL Server Integration Services (SSIS) • Python Scripting & Automation • Apache Airflow • AWS • SAS • Performance Tracking and monitoring (KPIs) • Reporting and presentations • Unix CLI • VBA

GIS Data Analyst

MITIC
January 2022 - April 2022

Worked in the government as a GIS Analyst, which shares many similarities with the Data Analyst role in terms of execution, with the added use of Google Earth Pro. Tasks: • Data Analysis • Data Collection • Data Quality assurance • SQL • Python (pandas, numpy, matplotlib) • PowerBI • Google Earth Pro

Sales Associate

Roguis Cell
October 2018 - March 2020

• Customer service • Sales • Accounting • Excel bookkeeping • Data Analysis • Surveys • Purchasing and Procurement • Inventory management

Smart Scores

Communication
90
Role Fit
95
Adaptability
80
Problem-solving
90

Smart Skills

beta