Gustavo Costa Email & Phone Number

Lisbon, Portugal

Uberlândia, Minas Gerais, Brazil

- Implemented row-level quality tests, which provided more granularity to pinpoint and remediate data quality issues. Using the library Great Expectations (GX) and Spark, there's been about a 5% increase on average in task duration, which it's great compared to the benefits.- Reduced 70% costs with MERGE operations in BigQuery native tables, migrating BigQuery native tables to external tables hosted in GCS.- Refactored an API service in FastAPI (Python) to improve readability and maintainability. The service processes document uploads and extracts data using AI, leveraging object-oriented programming techniques to enhance code structure and efficiency.- Developed an API in FastAPI to provide clients with direct access to data stored in the data warehouse. Empowered clients with autonomy and ensured high availability for seamless data retrieval.Technologies:- Python (Pyspark, Pandas, FastAPI)- API (Rest, Soap)- SQL, NoSQL- Airflow- GCP Cloud Storage, BigQuery, Dataproc, Kubernetes, Artifacts, Cloud Composer, Secret Manager- Mac OS- GitHub- CI/CD- Docker

São Paulo, Brasil

Achievements:- Reduced in 80% the dashboards failures in production by fixing ETL pipeline jobs;- Increased in 2x the efficiency of data delivery to partners;- Reduced costs in 70% by parallelizing data pipelines.Context:At Linker, a bank exclusively focused on serving companies, my role involves building consistent ETL pipelines that source data from APIs and both SQL and NoSQL databases. I work with batch processing and near real-time updates to ensure the data is up-to-date and accurate. I also collaborate directly with business teams, helping them extract meaningful data and creating automation solutions using refined data to build business rules. Technologies:- Python (PySpark, Pandas, Numpy)- API (Get, Post)- SQL, NoSQL- PostgreSQL, MySQL, AuroraDB- DynamoDB, DocumentDB- AWS S3, Redshift, Glue, DMS, Kinesis, RDS, Lambda, Athena- Linux- CI/CD

Uberlândia, Minas Gerais, Brasil

Achievements:- Reduced 80% of manually extraction of data from marketing tools (social medias, CRM, mail automations, leads journeys);- Reducted execution time in 85% of ETL Python code extraction from API;Context:At Bowe, a marketing and sales consulting company, my role involved engaging with clients to gain insights into their data sources and identify any requirements for customized dashboards. To ensure seamless data integration, consolidated customer data from diverse sources into a centralized data lake and warehouse, employing ETL pipelines. Additionally, I collaborated closely with data analysts, lending my expertise to assist in the development of interactive and visually appealing dashboards, empowering our clients to closely monitor and evaluate the performance of their marketing campaigns.Technologies:- Python (Pandas, Numpy, Requests)- SQL- AWS Lambda, Redshift, S3, Athena, EventBridge, CloudWatch- Power BI, DataStudio, Qlik- AppScript- API

Achievements:- Increased 30% (7 to 5 hours) in agility of dashboard implementation by standardizing data.- Increased team revenue by 20% in creation of a product for marketing and sales analysis.Context:During that time, main focus was on maintaining client dashboards and creating a product that prioritized delivering analytics to track marketing campaigns that generated sales.Technologies:- Python- Google Functions, BigQuery- AWS Lambda, S3, Redshift, Athena, EventBridge, CloudWatch- Power BI, DataStudio, QlikView- API

Uberlândia, Minas Gerais, Brasil

Achievements:- Reducted storage costs in 40% and increased agility in 80% the execution of functions through the migration of the Google Cloud Platform (GCP) cloud server to Amazon Web Services (AWS);- Reduced costs in 20% by consuming API with Python, instead of payed extractors.Context:During that period, the stability of customer dashboards with daily updates had been achieved. Consequently, the focus changed to pipeline efficiency and implementing a data lake solution.Technologies:- Python- Google Functions, BigQuery- AWS Lambda, S3, Redshift, Athena, EventBridge, CloudWatch- Power BI, DataStudio, QlikView

Uberlândia, Minas Gerais, Brasil

Achievements:- Increased 25% of revenue with BI works by assuming new clients;- Increased 60% number of active dashboards by building new dashes and keeping up to date twice a day;- Reduced 80% of manually extraction of data from marketing tools (social medias, CRM, mail automations, leads journeys);Context:As the first member of Bowe's Business Intelligence (BI) team had the responsibility of creating intuitive dashboards for our clients and automate the update process.Technologies:- Python- Google Functions- BigQuery- Power BI, DataStudio- Stitch, Pluga

Master Of Business Administration - Mba, Data Modeling/Databases Storage And Administration, Data Engineering

Fundamentos De Abm, Marketing

Bachelor'S Degree, Aeronautical Engineering

Activities and Societies: - Scientific research in programming - Student Company - Internship with sandwich graduation

Sandwich Period, Mechanical And Aerotechnical Engineering

Iniciação Científica Pibic, Automação E Programação Em Labview